export_cc.php

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

<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  $EXCEL_OUT = '部门,姓名,出差地点,开始日期,结束日期,批示领导,状态
';
  $query = (((((((((((((''.'SELECT * from ATTEND_EVECTION,USER,DEPARTMENT where DEPARTMENT.DEPT_ID=USER.DEPT_ID and ATTEND_EVECTION.USER_ID=USER.USER_ID and ((to_days(EVECTION_DATE1)>=to_days(\'').$DATE1).'\') and to_days(EVECTION_DATE1)<=to_days(\'').$DATE2).'\')) or (to_days(EVECTION_DATE2)>=to_days(\'').$DATE1).'\') and to_days(EVECTION_DATE2)<=to_days(\'').$DATE2).'\')) or (to_days(EVECTION_DATE1)<=to_days(\'').$DATE1).'\') and to_days(EVECTION_DATE2)>=to_days(\'').$DATE2).'\'))) order by DEPT_NO,USER_NO,USER_NAME');
  $cursor = exequery ($connection, $query);
  $EVECTION_COUNT = 0;
  while ($ROW = mysql_fetch_array ($cursor))
  {
    $USER_ID = $ROW['USER_ID'];
    $DEPT_ID = $ROW['DEPT_ID'];
    $USER_NAME = $ROW['USER_NAME'];
    $EVECTION_ID = $ROW['EVECTION_ID'];
    $EVECTION_DATE1 = $ROW['EVECTION_DATE1'];
    $EVECTION_DATE1 = strtok ($EVECTION_DATE1, ' ');
    $EVECTION_DATE2 = $ROW['EVECTION_DATE2'];
    $EVECTION_DATE2 = strtok ($EVECTION_DATE2, ' ');
    $EVECTION_DEST = $ROW['EVECTION_DEST'];
    $STATUS = $ROW['STATUS'];
    $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
    {
      ++$EVECTION_COUNT;
      if (($STATUS == '1'))
      {
        $STATUS = '在外';
      }
      else
      {
        $STATUS = '归来';
      }
      $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).',').$EVECTION_DEST).',').$EVECTION_DATE1).',').$EVECTION_DATE2).',').$LEADER_NAME).',').$STATUS).'
'));
      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;
?>