export.php

极限网络智能办公系统—MYOA26—100％—源程序。

<?php

function format( $STR )
{
	$STR = str_replace( "\"", "'", $STR );
	if ( strpos( $STR, "," ) )
	{
		$STR = "\"".$STR."\"";
	}
	return $STR;
}

include_once( "inc/conn.php" );
session_start( );
if ( $LOGIN_USER_ID == "" )
{
	exit( );
}
$query = "select * from ADDRESS_GROUP where GROUP_ID={$GROUP_ID}";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$GROUP_NAME = $ROW['GROUP_NAME'];
}
if ( $GROUP_ID == 0 )
{
	$GROUP_NAME = "默认";
}
header( "Content-type: application/octet-stream" );
header( "Content-Disposition: attachment; filename=".$GROUP_NAME.".csv" );
if ( $TYPE == 0 )
{
	echo "姓名,职位,昵称,电子邮件地址,手机,传呼机,QQ,ICQ,性别,生日,配偶,子女,家庭所在地邮政编码,家庭所在街道,家庭电话1,公司,公司所在地邮政编码,公司所在街道,办公电话1,公司传真,附注\r\n";
}
else
{
	echo "姓名,职务,昵称,电子邮件地址,移动电话,寻呼机,QQ,ICQ,性别,生日,配偶,子女,住宅所在地的邮政编码,住宅所在街道,住宅电话,公司,公司所在地的邮政编码,公司所在街道,业务电话,业务传真,附注\r\n";
}
$connection = openconnection( );
$query = "SELECT * from ADDRESS where USER_ID='{$LOGIN_USER_ID}' and GROUP_ID={$GROUP_ID}";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$PSN_NAME = format( $ROW['PSN_NAME'] );
	$SEX = format( $ROW['SEX'] );
	if ( $SEX == 0 )
	{
		$SEX = "男";
	}
	else
	{
		$SEX = "女";
	}
	$BIRTHDAY = format( $ROW['BIRTHDAY'] );
	$NICK_NAME = format( $ROW['NICK_NAME'] );
	$MINISTRATION = format( $ROW['MINISTRATION'] );
	$MATE = format( $ROW['MATE'] );
	$CHILD = format( $ROW['CHILD'] );
	$DEPT_NAME = format( $ROW['DEPT_NAME'] );
	$ADD_DEPT = format( $ROW['ADD_DEPT'] );
	$POST_NO_DEPT = format( $ROW['POST_NO_DEPT'] );
	$TEL_NO_DEPT = format( $ROW['TEL_NO_DEPT'] );
	$FAX_NO_DEPT = format( $ROW['FAX_NO_DEPT'] );
	$ADD_HOME = format( $ROW['ADD_HOME'] );
	$POST_NO_HOME = format( $ROW['POST_NO_HOME'] );
	$TEL_NO_HOME = format( $ROW['TEL_NO_HOME'] );
	$MOBIL_NO = format( $ROW['MOBIL_NO'] );
	$BP_NO = format( $ROW['BP_NO'] );
	$EMAIL = format( $ROW['EMAIL'] );
	$OICQ_NO = format( $ROW['OICQ_NO'] );
	$ICQ_NO = format( $ROW['ICQ_NO'] );
	$NOTES = format( $ROW['NOTES'] );
	echo "{$PSN_NAME},{$MINISTRATION},{$NICK_NAME},{$EMAIL},{$MOBIL_NO},{$BP_NO},{$OICQ_NO},{$ICQ_NO},{$SEX},{$BIRTHDAY},{$MATE},{$CHILD},{$POST_NO_HOME},{$ADD_HOME},{$TEL_NO_HOME},{$DEPT_NAME},{$POST_NO_DEPT},{$ADD_DEPT},{$TEL_NO_DEPT},{$FAX_NO_DEPT},{$NOTES}\n";
}
?>