export.php

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

<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  $EXCEL_OUT = '计划名称,计划内容,开始时间,结束时间,计划类别,开放部门,开放人员,负责人,参与人,创建人,创建日期,状态,备注
';
  $query5 = $QUERY_PLAN;
  $cursor5 = exequery ($connection, $query5);
  while ($ROW = mysql_fetch_array ($cursor5))
  {
    $PLAN_ID = $ROW['PLAN_ID'];
    $NAME = $ROW['NAME'];
    $CONTENT = $ROW['CONTENT'];
    $BEGIN_DATE = $ROW['BEGIN_DATE'];
    $END_DATE = $ROW['END_DATE'];
    $TYPE = $ROW['TYPE'];
    $TO_ID = $ROW['TO_ID'];
    $MANAGER = $ROW['MANAGER'];
    $PARTICIPATOR = $ROW['PARTICIPATOR'];
    $CREATOR = $ROW['CREATOR'];
    $CREATE_DATE = $ROW['CREATE_DATE'];
    $ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
    $ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
    $ATTACHMENT_COMMENT = $ROW['ATTACHMENT_COMMENT'];
    $REMARK = $ROW['REMARK'];
    $SUSPEND_FLAG = $ROW['SUSPEND_FLAG'];
    $TO_PERSON_ID = $ROW['TO_PERSON_ID'];
    $CONTENT = str_replace ('
', '<br>', $CONTENT);
    $query1 = (((''.'SELECT * from PLAN_TYPE where TYPE_ID=\'').$TYPE).'\'');
    $cursor1 = exequery ($connection, $query1);
    if ($ROW1 = mysql_fetch_array ($cursor1))
    {
      $TYPE_DESC = $ROW1['TYPE_NAME'];
    }
    else
    {
      $TYPE_DESC = '';
    }
    if (($TO_ID == 'ALL_DEPT'))
    {
      $TO_NAME = '全体部门';
    }
    else
    {
      $TO_NAME = '';
      $TOK = strtok ($TO_ID, ',');
      while (($TOK != ''))
      {
        if (($TO_NAME != ''))
        {
          ($TO_NAME .= '，');
        }
        $query1 = ((''.'select * from DEPARTMENT where DEPT_ID=').$TOK);
        $cursor1 = exequery ($connection, $query1);
        if ($ROW = mysql_fetch_array ($cursor1))
        {
          ($TO_NAME .= $ROW['DEPT_NAME']);
        }
        $TOK = strtok (',');
      }
    }
    $TO_PERSON_NAME = '';
    $TOK = strtok ($TO_PERSON_ID, ',');
    while (($TOK != ''))
    {
      if (($TO_PERSON_NAME != ''))
      {
        ($TO_PERSON_NAME .= '，');
      }
      $query1 = (((''.'select * from USER where USER_ID=\'').$TOK).'\'');
      $cursor1 = exequery ($connection, $query1);
      if ($ROW1 = mysql_fetch_array ($cursor1))
      {
        $DEPT_ID = $ROW1['DEPT_ID'];
        $DEPT_NAME = dept_long_name ($DEPT_ID);
        ($TO_PERSON_NAME .= $ROW1['USER_NAME']);
      }
      $TOK = strtok (',');
    }
    $PARTICIPATOR_NAME = '';
    $TOK = strtok ($PARTICIPATOR, ',');
    while (($TOK != ''))
    {
      if (($PARTICIPATOR_NAME != ''))
      {
        ($PARTICIPATOR_NAME .= '，');
      }
      $query1 = (((''.'select * from USER where USER_ID=\'').$TOK).'\'');
      $cursor1 = exequery ($connection, $query1);
      if ($ROW = mysql_fetch_array ($cursor1))
      {
        $DEPT_ID = $ROW['DEPT_ID'];
        $DEPT_NAME = dept_long_name ($DEPT_ID);
        ($PARTICIPATOR_NAME .= $ROW['USER_NAME']);
      }
      $TOK = strtok (',');
    }
    $MANAGE_NAME = '';
    $TOK = strtok ($MANAGER, ',');
    while (($TOK != ''))
    {
      if (($MANAGE_NAME != ''))
      {
        ($MANAGE_NAME .= '，');
      }
      $query1 = (((''.'select * from USER where USER_ID=\'').$TOK).'\'');
      $cursor1 = exequery ($connection, $query1);
      if ($ROW = mysql_fetch_array ($cursor1))
      {
        $DEPT_ID = $ROW['DEPT_ID'];
        $DEPT_NAME = dept_long_name ($DEPT_ID);
        ($MANAGE_NAME .= $ROW['USER_NAME']);
      }
      $TOK = strtok (',');
    }
    $query1 = (((''.'select * from USER where USER_ID=\'').$CREATOR).'\'');
    $cursor = exequery ($connection, $query1);
    if ($ROW = mysql_fetch_array ($cursor))
    {
      $DEPT_ID = $ROW['DEPT_ID'];
      $DEPT_NAME = dept_long_name ($DEPT_ID);
      $CREATOR_NAME = $ROW['USER_NAME'];
    }
    if (($SUSPEND_FLAG == 1))
    {
      if ((compare_date ($CUR_DATE, $BEGIN_DATE) < 0))
      {
        $STATUS_DESC = '未开始';
      }
      else
      {
        $STATUS_DESC = '<font color=\'#00AA00\'><b>进行中</b></font>';
      }
      if (($END_DATE != '0000-00-00'))
      {
        if ((0 < compare_date ($CUR_DATE, $END_DATE)))
        {
          $STATUS_DESC = '<font color=\'#FF0000\'><b>已结束</b></font>';
        }
      }
      else
      {
        $END_DATE = '';
      }
    }
    else
    {
      $STATUS_DESC = '<font color=\'#FF0000\'><b>暂停</b></font>';
    }
    ($EXCEL_OUT .= ((((((((((((((((((((((((((''.$NAME).',').$CONTENT).',').$BEGIN_DATE).',').$END_DATE).',').$TYPE_DESC).',').$TO_NAME).',').$TO_PERSON_NAME).',').$MANAGE_NAME).',').$PARTICIPATOR_NAME).',').$CREATOR_NAME).',').$CREATE_DATE).',').$STATUS_DESC).',').$REMARK).'
'));
  }
  ob_end_clean ();
  header ('Cache-control: private');
  header ('Content-type: application/vnd.ms-excel');
  header ('Accept-Ranges: bytes');
  header (('Accept-Length: '.strlen ($EXCEL_OUT)));
  header (('Content-Length: '.strlen ($EXCEL_OUT)));
  header ('Content-Disposition: attachment; filename= 工作计划.csv');
  echo $EXCEL_OUT;
?>