excel_report.php

极限网络智能办公系统 Office Automation V3.0官方100％源代码.

<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");

 $query = "SELECT count(*) from SAL_ITEM";
 $ITEM_COUNT=0;
 $cursor= exequery($connection,$query);
 if($ROW=mysql_fetch_array($cursor))
    $ITEM_COUNT=$ROW[0];

 if($ITEM_COUNT==0)
   exit;

 $query = "SELECT * from SAL_FLOW where FLOW_ID=$FLOW_ID";
 $cursor= exequery($connection,$query);
 $FLOW_COUNT=0;
 if($ROW=mysql_fetch_array($cursor))
    $CONTENT=$ROW["CONTENT"];

 $EXCEL_OUT.="部门\t";
 $EXCEL_OUT.="姓名\t";
 $EXCEL_OUT.="角色\t";
 if($fld_str=="")
{
 $query = "SELECT ITEM_ID from SAL_ITEM";
 $cursor= exequery($connection,$query);
 $FLOW_COUNT=0;
 while($ROW=mysql_fetch_array($cursor))
    {
    	$STYLE=$STYLE.$ROW["ITEM_ID"].",";
    }
 }
 else
 {  
  $STYLE=$fld_str;
  }
 $STYLE_ARRAY=explode(",",$STYLE);
 $ARRAY_COUNT=sizeof($STYLE_ARRAY);
 $COUNT=0;
 if($STYLE_ARRAY[$ARRAY_COUNT-1]=="")$ARRAY_COUNT--;
 for($I=0;$I<$ARRAY_COUNT;$I++)
   {
   	 $query1 = "select ITEM_ID,ITEM_NAME from SAL_ITEM where ITEM_ID='$STYLE_ARRAY[$I]'";
     $cursor1= exequery($connection,$query1);
     if($ROW=mysql_fetch_array($cursor1))
        {
        	$ITEM_NAME=$ROW["ITEM_NAME"];
          $ITEM_ID[$COUNT]=$ROW["ITEM_ID"];
          $EXCEL_OUT.=$ITEM_NAME."\t";
        }
     $COUNT++;
    }
  $EXCEL_OUT.="\n";
  
if($COPY_TO_ID!="")
   {
   	$COPY_TO_ID="'".str_replace(",","','",substr($COPY_TO_ID,0,-1))."'";
    $WHERE_STR.=" and USER.USER_ID in ($COPY_TO_ID)";
   }
if($TOID!="" and $TOID!="ALL_DEPT")
   {
   	 $TOID="'".str_replace(",","','",substr($TOID,0,-1))."'";
     $WHERE_STR.=" and DEPARTMENT.DEPT_ID in ($TOID)";
   }
  if($DEPT_FLAG!=1) 
  {    
   $query = "SELECT * from USER,USER_PRIV,DEPARTMENT where DEPARTMENT.DEPT_ID=USER.DEPT_ID and USER.USER_PRIV=USER_PRIV.USER_PRIV".$WHERE_STR." order by DEPT_NO,PRIV_NO,USER_NAME";
  }
  else
  {
   $query = "SELECT * from USER,USER_PRIV where USER.USER_PRIV=USER_PRIV.USER_PRIV and DEPT_ID=0";
  }
 $cursor= exequery($connection,$query);
 $USER_COUNT=0;
 while($ROW=mysql_fetch_array($cursor))
 {
    $USER_COUNT++;

    $USER_ID=$ROW["USER_ID"];
    $USER_NAME=$ROW["USER_NAME"];
    $DEPT_ID=$ROW["DEPT_ID"];
    $USER_PRIV=$ROW["USER_PRIV"];

    if($DEPT_ID==0)
       $DEPT_NAME="离职人员/外部人员";
    else
    {
       $query1="select * from DEPARTMENT where DEPT_ID=$DEPT_ID";
       $cursor1= exequery($connection,$query1);
       if($ROW=mysql_fetch_array($cursor1))
          $DEPT_NAME=$ROW["DEPT_NAME"];
    }
    $query1 = "SELECT * from USER_PRIV where USER_PRIV='$USER_PRIV'";
    $cursor1= exequery($connection,$query1);
    if($ROW=mysql_fetch_array($cursor1))
         $USER_PRIV=$ROW["PRIV_NAME"];
    $EXCEL_OUT.=$DEPT_NAME."\t";
    $EXCEL_OUT.=$USER_NAME."\t";
    $EXCEL_OUT.=$USER_PRIV."\t";
   $query1="select * from SAL_DATA where FLOW_ID=$FLOW_ID and USER_ID='$USER_ID'";
   $cursor1= exequery($connection,$query1);
   if($ROW=mysql_fetch_array($cursor1))
   {
      for($I=0;$I< $COUNT;$I++)
     {
       $STR="S".$ITEM_ID[$I];
       $$STR=format_money($ROW["$STR"]);
     }
   }
   else
   {
     for($I=0;$I< $COUNT;$I++)
     {
       $STR="S".$ITEM_ID[$I];
       $$STR="";
     }
   }
   for($I=0;$I< $COUNT;$I++)
   {
      $STR="S".$ITEM_ID[$I];
      $STR_COUNT=$STR."_COUNT";
      $$STR_COUNT+=$$STR;
      $EXCEL_OUT.=$$STR."\t";
   }
   $EXCEL_OUT.="\n";
 }
 if($USER_COUNT!=0)
 {
 	 $EXCEL_OUT.="合计\t\t\t";
  for($I=0;$I< $COUNT;$I++)
   {
      $STR="S".$ITEM_ID[$I];
      $STR_COUNT=$STR."_COUNT";
      $DATA=format_money($$STR_COUNT);

      $EXCEL_OUT.=$DATA."\t";
   }
   $EXCEL_OUT.="\n";
 }
 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= 工资报表-$CONTENT.xls");
 echo $EXCEL_OUT;
?>