export.php

极限网络智能办公系统 - Office Automation 2008 官方100％ 源码

<?php
 

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" );
$query = "select * from FIELDSETTING where TABLENAME='ADDRESS'";
$cursor = exequery( $connection, $query );
$J = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$FIELDNAME .= $ROW['FIELDNAME'].",";
}
if ( $TYPE == 0 )
{
	echo "姓名,职位,昵称,电子邮件地址,手机,传呼机,QQ,MSN,性别,生日,配偶,子女,家庭所在地邮政编码,家庭所在街道,家庭电话1,公司,公司所在地邮政编码,公司所在街道,办公电话1,公司传真,附注,".$FIELDNAME."\n";
}
else
{
	echo "姓名,职位,昵称,电子邮件地址,手机,传呼机,QQ,MSN,性别,生日,配偶,子女,家庭所在地邮政编码,家庭所在街道,家庭电话1,公司,公司所在地邮政编码,公司所在街道,办公电话1,公司传真,附注,".$FIELDNAME."\n";
}
$connection = openconnection( );
$query = "SELECT * from ADDRESS where USER_ID='' and GROUP_ID=".$GROUP_ID;
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$ADD_ID = $ROW['ADD_ID'];
	$PSN_NAME = format_cvs( $ROW['PSN_NAME'] );
	$SEX = format_cvs( $ROW['SEX'] );
	if ( $SEX == "0" )
	{
		$SEX = "男";
	}
	else if ( $SEX == "1" )
	{
		$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'] )."\"";
	$DEF_FIELD_ARRAY = array( );
	$DEF_FIELD_ARRAY = get_field_text( "ADDRESS", $ADD_ID );
	$EXCEL_OUT = "";
	while ( list( $key, $value ) = each( &$DEF_FIELD_ARRAY ) )
	{
		$EXCEL_OUT .= $value['HTML'].",";
	}
	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},".$EXCEL_OUT."\n";
}
?>