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) //Foxmail
{
?>
姓名,职位,昵称,电子邮件地址,手机,传呼机,QQ,MSN,性别,生日,配偶,子女,家庭所在地邮政编码,家庭所在街道,家庭电话1,公司,公司所在地邮政编码,公司所在街道,办公电话1,公司传真,附注
<?
}
else //outlook
{
?>
姓名,职务,昵称,电子邮件地址,移动电话,小灵通,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\n";
}
?>