export_wc.php

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

<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  $EXCEL_OUT = '部门,姓名,外出原因,申请时间,外出时间,归来时间,批示领导,状态
';
  $query = (((((''.'SELECT * from ATTEND_OUT,USER,DEPARTMENT where DEPARTMENT.DEPT_ID=USER.DEPT_ID and ATTEND_OUT.USER_ID=USER.USER_ID and to_days(SUBMIT_TIME)>=to_days(\'$').$DATE1).'\') and to_days(SUBMIT_TIME)<=to_days(\'$').$DATE2).'\') order by DEPT_NO,USER_NO,USER_NAME');
  $cursor = exequery ($connection, $query);
  $OUT_COUNT = 0;
  while ($ROW = mysql_fetch_array ($cursor))
  {
    $USER_ID = $ROW['USER_ID'];
    $USER_NAME = $ROW['USER_NAME'];
    $OUT_TYPE = $ROW['OUT_TYPE'];
    $SUBMIT_TIME = $ROW['SUBMIT_TIME'];
    $OUT_TIME1 = $ROW['OUT_TIME1'];
    $OUT_TIME2 = $ROW['OUT_TIME2'];
    $ALLOW = $ROW['ALLOW'];
    $STATUS = $ROW['STATUS'];
    $DEPT_ID = $ROW['DEPT_ID'];
    $LEADER_ID = $ROW['LEADER_ID'];
    $LEADER_NAME = '';
    $query = (((''.'SELECT * from USER where USER_ID=\'').$LEADER_ID).'\'');
    $cursor1 = exequery ($connection, $query);
    if ($ROW = mysql_fetch_array ($cursor1))
    {
      $LEADER_NAME = $ROW['USER_NAME'];
    }
    if (!is_dept_priv ($DEPT_ID))
    {
      continue;
    }
    else
    {
      ++$OUT_COUNT;
      if (($STATUS == '0'))
      {
        $STATUS_DESC = '外出';
      }
      else
      {
        if (($STATUS == '1'))
        {
          $STATUS_DESC = '已归来';
        }
      }
      if (($ALLOW == '0'))
      {
        $STATUS_DESC = '待批';
      }
      if (($ALLOW == '2'))
      {
        $STATUS_DESC = '不批准';
      }
      $query1 = ((''.'select * from DEPARTMENT where DEPT_ID=').$DEPT_ID);
      $cursor1 = exequery ($connection, $query1);
      if ($ROW = mysql_fetch_array ($cursor1))
      {
        $USER_DEPT_NAME = $ROW['DEPT_NAME'];
      }
      ($EXCEL_OUT .= ((((((((((((((((''.$USER_DEPT_NAME).',').$USER_NAME).',').$OUT_TYPE).',').$SUBMIT_TIME).',').$OUT_TIME1).',').$OUT_TIME2).',').$LEADER_NAME).',').$STATUS_DESC).'
'));
      continue;
    }
  }
  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;
?>