export_qj.php

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

<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  $EXCEL_OUT = '部门,姓名,请假原因,开始日期,结束日期,批示领导,状态
';
  $query = (((((((((((((''.'SELECT * from ATTEND_LEAVE,USER,DEPARTMENT where DEPARTMENT.DEPT_ID=USER.DEPT_ID and ATTEND_LEAVE.USER_ID=USER.USER_ID and ((to_days(LEAVE_DATE1)>=to_days(\'').$DATE1).'\') and to_days(LEAVE_DATE1)<=to_days(\'').$DATE2).'\')) or (to_days(LEAVE_DATE2)>=to_days(\'').$DATE1).'\') and to_days(LEAVE_DATE2)<=to_days(\'').$DATE2).'\')) or (to_days(LEAVE_DATE1)<=to_days(\'').$DATE1).'\') and to_days(LEAVE_DATE2)>=to_days(\'').$DATE2).'\'))) and allow in(\'1\',\'3\') order by DEPT_NO,USER_NO,USER_NAME');
  $cursor = exequery ($connection, $query);
  $LEAVE_COUNT = 0;
  while ($ROW = mysql_fetch_array ($cursor))
  {
    $USER_ID = $ROW['USER_ID'];
    $DEPT_ID = $ROW['DEPT_ID'];
    $USER_NAME = $ROW['USER_NAME'];
    $LEAVE_ID = $ROW['LEAVE_ID'];
    $LEAVE_DATE1 = $ROW['LEAVE_DATE1'];
    $LEAVE_DATE2 = $ROW['LEAVE_DATE2'];
    $LEAVE_TYPE = $ROW['LEAVE_TYPE'];
    $LEADER_ID = $ROW['LEADER_ID'];
    $STATUS = $ROW['STATUS'];
    $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
    {
      ++$LEAVE_COUNT;
      switch ($LEAVE_TYPE)
      {
        case 1:
        {
          $LEAVE_TYPE = '事假';
          break;
        }
        case 2:
        {
          $LEAVE_TYPE = '病假';
          break;
        }
        case 3:
        {
          $LEAVE_TYPE = '婚假';
          break;
        }
        case 4:
        {
          $LEAVE_TYPE = '产假';
          break;
        }
        case 5:
        {
          $LEAVE_TYPE = '其它';
          break;
        }
      }
      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).',').$LEAVE_TYPE).',').$LEAVE_DATE1).',').$LEAVE_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;
?>