export.php

极限网络智能办公系统 Office Automation V3.0官方100％源代码.

<?
include_once 'inc/conn.php';
include_once 'inc/utility_all.php';
session_start ();
ob_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,MSN,性别,生日,配偶,子女,家庭所在地邮政编码,家庭所在街道,家庭电话1,公司,公司所在地邮政编码,公司所在街道,办公电话1,公司传真,附注
';
}
else
{
	echo '姓名,职务,昵称,电子邮件地址,移动电话,小灵通,QQ,MSN,性别,生日,配偶,子女,住宅所在地的邮政编码,住宅所在街道,住宅电话,公司,公司所在地的邮政编码,公司所在街道,业务电话,业务传真,附注
';
}
$connection = openconnection ();
$query = 'SELECT * from ADDRESS where USER_ID=\'\' and GROUP_ID=' . $GROUP_ID;
$cursor = exequery ($connection, $query);
while ($ROW = mysql_fetch_array ($cursor))
{
	$PSN_NAME = format_cvs ($ROW['PSN_NAME']);
	$SEX = format_cvs ($ROW['SEX']);
	if ($SEX == 0)
	{
		$SEX = '男';
	}
	else
	{
		$SEX = '女';
	}
	$BIRTHDAY = format_cvs ($ROW['BIRTHDAY']);
	$NICK_NAME = format_cvs ($ROW['NICK_NAME']);
	$MINISTRATION = format_cvs ($ROW['MINISTRATION']);
	$MATE = format_cvs ($ROW['MATE']);
	$CHILD = format_cvs ($ROW['CHILD']);
	$DEPT_NAME = format_cvs ($ROW['DEPT_NAME']);
	$ADD_DEPT = format_cvs ($ROW['ADD_DEPT']);
	$POST_NO_DEPT = format_cvs ($ROW['POST_NO_DEPT']);
	$TEL_NO_DEPT = format_cvs ($ROW['TEL_NO_DEPT']);
	$FAX_NO_DEPT = format_cvs ($ROW['FAX_NO_DEPT']);
	$ADD_HOME = format_cvs ($ROW['ADD_HOME']);
	$POST_NO_HOME = format_cvs ($ROW['POST_NO_HOME']);
	$TEL_NO_HOME = format_cvs ($ROW['TEL_NO_HOME']);
	$MOBIL_NO = format_cvs ($ROW['MOBIL_NO']);
	$BP_NO = format_cvs ($ROW['BP_NO']);
	$EMAIL = format_cvs ($ROW['EMAIL']);
	$OICQ_NO = format_cvs ($ROW['OICQ_NO']);
	$ICQ_NO = format_cvs ($ROW['ICQ_NO']);
	$NOTES = '"' . format_cvs ($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 . '
');
}
?>