export.php

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

<?
  function getalldate ($CODE, $GETVALUE)
  {
    global $connection;
    $query = (((''.'SELECT * from SYS_CODE where PARENT_NO=\'').$CODE).'\' order by CODE_ORDER');
    $cursor = exequery ($connection, $query);
    while ($ROW = mysql_fetch_array ($cursor))
    {
      $CODE_NO = $ROW['CODE_NO'];
      $CODE_NAME = $ROW['CODE_NAME'];
      if (($CODE_NO == $GETVALUE))
      {
        return $CODE_NAME;
        continue;
      }
    }
  }
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  include_once 'inc/check_type.php';
  $EXCEL_OUT = '办公用品名称,办公类别,单价,办公用品描述,计量单位,供应商,警戒库存,当前库存';
  ($EXCEL_OUT .= '
');
  if (($LOGIN_USER_ID != 'admin'))
  {
    $WHERE_STR = (((((''.' where (PRO_MANAGER=\'\' or  PRO_MANAGER=\'').$LOGIN_USER_ID).'\' or PRO_CREATOR=\'\' or PRO_CREATOR=\'').$LOGIN_USER_ID).'\')');
  }
  else
  {
    $WHERE_STR = ' where 1=1';
  }
  if (($PRO_NAME != ''))
  {
    ($WHERE_STR .= ((' and PRO_NAME like \'%'.$PRO_NAME).'%\''));
  }
  if (($PRO_DESC != ''))
  {
    ($WHERE_STR .= ((' and PRO_DESC like \'%'.$PRO_DESC).'%\''));
  }
  if (($LOW_Stock == -1))
  {
    ($WHERE_STR .= ' and `PRO_STOCK` <= `PRO_LOWSTOCK`');
  }
  if (($OFFICE_PROTYPE != ''))
  {
    ($WHERE_STR .= (((''.' and OFFICE_PROTYPE= \'').$OFFICE_PROTYPE).'\''));
  }
  $query1 = ('select * from OFFICE_PRODUCTS'.$WHERE_STR);
  $cursor = exequery ($connection, $query1);
  while ($ROW = mysql_fetch_array ($cursor))
  {
    $OFFICE_PROTYPE = getalldate ('OFFICE_PROTYPE', $ROW['OFFICE_PROTYPE']);
    ($EXCEL_OUT .= (((((((((((((($ROW['PRO_NAME'].',').$OFFICE_PROTYPE).',').$ROW['PRO_PRICE']).',').$ROW['PRO_DESC']).',').$ROW['PRO_UNIT']).',').$ROW['PRO_SUPPLIER']).',').$ROW['PRO_LOWSTOCK']).',').$ROW['PRO_STOCK']));
    ($EXCEL_OUT .= '
');
  }
  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-Disposition: attachment; filename=办公用品.csv');
  echo $EXCEL_OUT;
?>