export.php

来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 86 行

<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  ob_end_clean ();
  $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).'
');
  }
  else
  {
    echo (('姓名,职务,昵称,电子邮件地址,移动电话,小灵通,QQ,MSN,性别,生日,配偶,子女,住宅所在地的邮政编码,住宅所在街道,住宅电话,公司,公司所在地的邮政编码,公司所在街道,业务电话,业务传真,附注,'.$FIELDNAME).'
');
  }
  $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).'
');
  }
?>