export.php

通达OA2007SE源代码 非常好的

<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  $EXCEL_OUT = '部门,姓名,性别,生日,角色,用户名,别名,用户排序号,管理范围,手机,IP
';
  $query = ((''.'SELECT * from USER_PRIV where USER_PRIV=').$LOGIN_USER_PRIV);
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $PRIV_NO = $ROW['PRIV_NO'];
  }
  if (($USER_ID != ''))
  {
    ($WHERE_STR .= ((' and USER_ID like \'%'.$USER_ID).'%\''));
  }
  if (($USER_NAME != ''))
  {
    ($WHERE_STR .= ((' and USER_NAME like \'%'.$USER_NAME).'%\''));
  }
  if (($BYNAME != ''))
  {
    ($WHERE_STR .= ((' and BYNAME like \'%'.$BYNAME).'%\''));
  }
  if (($SEX != ''))
  {
    ($WHERE_STR .= ((''.' and SEX=').$SEX));
  }
  if (($DEPT_ID != ''))
  {
    ($WHERE_STR .= ((''.' and USER.DEPT_ID=').$DEPT_ID));
  }
  if (($DEPT_ID != '0'))
  {
    ($WHERE_STR .= ' and DEPARTMENT.DEPT_ID=USER.DEPT_ID');
  }
  if (($DUTY_TYPE != ''))
  {
    ($WHERE_STR .= ((''.' and DUTY_TYPE=').$DUTY_TYPE));
  }
  if (($USER_PRIV != ''))
  {
    ($WHERE_STR .= ((''.' and USER.USER_PRIV=').$USER_PRIV));
  }
  if (($POST_PRIV != ''))
  {
    ($WHERE_STR .= ((''.' and POST_PRIV=').$POST_PRIV));
  }
  if (($CANBROADCAST != ''))
  {
    ($WHERE_STR .= ((''.' and CANBROADCAST=').$CANBROADCAST));
  }
  if (($NOT_LOGIN != '2'))
  {
    ($WHERE_STR .= (((''.' and NOT_LOGIN=\'').$NOT_LOGIN).'\''));
  }
  if (($NOT_VIEW_USER != '2'))
  {
    ($WHERE_STR .= (((''.' and NOT_VIEW_USER=\'').$NOT_VIEW_USER).'\''));
  }
  if (($NOT_VIEW_TABLE != '2'))
  {
    ($WHERE_STR .= (((''.' and NOT_VIEW_TABLE=\'').$NOT_VIEW_TABLE).'\''));
  }
  $query = 'SELECT * from USER,USER_PRIV';
  if (($DEPT_ID != '0'))
  {
    ($query .= ',DEPARTMENT');
  }
  if (($LOGIN_USER_PRIV != '1'))
  {
    ($query .= (((((''.' where USER.USER_PRIV=USER_PRIV.USER_PRIV and USER_PRIV.PRIV_NO>').$PRIV_NO).' and USER_PRIV.USER_PRIV!=1 ').$WHERE_STR).' order by '));
  }
  else
  {
    ($query .= ((' where USER.USER_PRIV=USER_PRIV.USER_PRIV '.$WHERE_STR).' order by '));
  }
  if (($LAST_VISIT_TIME != ''))
  {
    ($query .= (('LAST_VISIT_TIME '.$LAST_VISIT_TIME).','));
  }
  if (($DEPT_ID != '0'))
  {
    ($query .= 'DEPT_NO,');
  }
  ($query .= 'PRIV_NO,USER_NO,USER_NAME');
  $cursor = exequery ($connection, $query);
  while ($ROW = mysql_fetch_array ($cursor))
  {
    $USER_ID = $ROW['USER_ID'];
    $USER_NAME = format_cvs ($ROW['USER_NAME']);
    $BYNAME = format_cvs ($ROW['BYNAME']);
    $SEX = $ROW['SEX'];
    $DEPT_ID = $ROW['DEPT_ID'];
    $POST_PRIV = $ROW['POST_PRIV'];
    $USER_NO = $ROW['USER_NO'];
    $MOBIL_NO = $ROW['MOBIL_NO'];
    $BIND_IP = $ROW['BIND_IP'];
    $PRIV_NAME = format_cvs ($ROW['PRIV_NAME']);
    $DEPT_NAME = format_cvs ($ROW['DEPT_NAME']);
    $BIRTHDAY = $ROW['BIRTHDAY'];
    $BIRTHDAY = strtok ($BIRTHDAY, ' ');
    if (($BIRTHDAY == '0000-00-00'))
    {
      $BIRTHDAY = '';
    }
    if (!is_dept_priv ($DEPT_ID))
    {
      continue;
    }
    else
    {
      if ((($DEPT_ID == 0) OR ($DEPT_ID == '')))
      {
        $DEPT_NAME = '离职人员/外部人员';
      }
      if (($SEX == '0'))
      {
        $SEX = '男';
      }
      else
      {
        if (($SEX == '1'))
        {
          $SEX = '女';
        }
      }
      if (($POST_PRIV == '0'))
      {
        $POST_PRIV = '本部门';
      }
      else
      {
        if (($POST_PRIV == '1'))
        {
          $POST_PRIV = '全体';
        }
        else
        {
          if (($POST_PRIV == '2'))
          {
            $POST_PRIV = '指定部门';
          }
        }
      }
      ($EXCEL_OUT .= ((((((((((((((((((((((''.$DEPT_NAME).',').$USER_NAME).',').$SEX).',').$BIRTHDAY).',').$PRIV_NAME).',').$USER_ID).',').$BYNAME).',').$USER_NO).',').$POST_PRIV).',').$MOBIL_NO).',').$BIND_IP).'
'));
      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= OA用户.csv');
  echo $EXCEL_OUT;
?>