excel_report.php

极限网络智能办公系统 - Office Automation 2008 官方100％ 源码

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

 $STYLE_ARRAY=explode(",",$FIELDMSGNAME);
 $ARRAY_COUNT=sizeof($STYLE_ARRAY);
 $COUNT=0;
 if($STYLE_ARRAY[$ARRAY_COUNT-1]=="")$ARRAY_COUNT--;
 for($I=0;$I<$ARRAY_COUNT;$I++)
   {
     $EXCEL_OUT.=$STYLE_ARRAY[$I]."\t";
    }
  $EXCEL_OUT.="\n";
  
//-----------先组织SQL语句-----------
 if($SERVICE_NAME!="")
 {
     if($WHERE_STR=="")
         $WHERE_STR.=" where SERVICE_NAME like '%".$SERVICE_NAME."%'";
     else
         $WHERE_STR.=" and SERVICE_NAME like '%".$SERVICE_NAME."%'";
 }
  if($SERVICE_DESC!="")
 {
     if($WHERE_STR=="")
         $WHERE_STR.=" where SERVICE_DESC like '%".$SERVICE_DESC."%'";
     else
         $WHERE_STR.=" and SERVICE_DESC like '%".$SERVICE_DESC."%'";
 }
if($PROVIDER_NAME!="")
   {
     if($WHERE_STR=="")
         $WHERE_STR.=" where PROVIDER_NAME like '%".$PROVIDER_NAME."%'";
     else
         $WHERE_STR.=" and PROVIDER_NAME like '%".$PROVIDER_NAME."%'";
   }
$query="SELECT PROVIDER_NAME,SERVICE_NAME,STANDARD_PRICE,SERVICE_DESC,a.MEMO,a.MEMO1,a.USERDEF1,a.USERDEF2,a.USERDEF3,a.USERDEF4,a.USERDEF5 FROM SERVICE a
         LEFT OUTER JOIN PROVIDER c
         ON a.PROVIDER_ID = c.PROVIDER_ID".$WHERE_STR;
 $cursor= exequery($connection,$query);
 $USER_COUNT=0;
 while($ROW=mysql_fetch_array($cursor))
 {
 	$STYLE_ARRAY=explode(",",$FIELDMSG);
   $ARRAY_COUNT=sizeof($STYLE_ARRAY);
   $COUNT=0;
   if($STYLE_ARRAY[$ARRAY_COUNT-1]=="")$ARRAY_COUNT--;
   for($I=0;$I<$ARRAY_COUNT;$I++)
   { 
     
     $MESSAGE=$ROW[$STYLE_ARRAY[$I]];
     if($STYLE_ARRAY[$I]=="USERDEF1" || $STYLE_ARRAY[$I]=="USERDEF2" || $STYLE_ARRAY[$I]=="USERDEF3" || $STYLE_ARRAY[$I]=="USERDEF4" || $STYLE_ARRAY[$I]=="USERDEF5")
     {
     	   $query = "select * from FIELDSETTING where TABLENAME='SERVICE' and FIELDNO='$STYLE_ARRAY[$I]' ORDER BY ORDERNO ASC  ";
         $cursor1=exequery($connection,$query);
        
         if($ROW1=mysql_fetch_array($cursor1))
         {
  	       $FIELDNAME=$ROW1["FIELDNAME"];
           $ORDERNO=$ROW1["ORDERNO"];
           $STYPE=$ROW1["STYPE"];
           $TYPENAME=$ROW1["TYPENAME"];
           $TYPEVALUE=$ROW1["TYPEVALUE"];
           $TYPECODE=$ROW1["TYPECODE"];
           $ISQUERY=$ROW1["ISQUERY"];
           $ISGROUY=$ROW1["ISGROUY"];
           $FIELDNAME=$ROW1["FIELDNAME"];
           $FIELDNO=$ROW1["FIELDNO"];
           $FIELDNO1=$FIELDNO."1";
          }
           if($STYPE=="D")
          {
          	$TYPEVALUE=str_replace("，",",",$TYPEVALUE);
            $TYPEVALUE_ARRAY=explode(",",$TYPEVALUE);
            $TYPENAME=str_replace("，",",",$TYPENAME);
            $TYPENAME_ARRAY=explode(",",$TYPENAME);
            $TYPENAME_COUNT=sizeof($TYPENAME_ARRAY);
            if($TYPENAME_ARRAY[$TYPENAME_COUNT-1]=="")$TYPENAME_COUNT--;
            for($I1=0;$I1<$TYPENAME_COUNT;$I1++)
            {
            	 if($MESSAGE==$TYPEVALUE_ARRAY[$I1])
       	       {
       	       	  $MESSAGE=$TYPENAME_ARRAY[$I1];
       	       }
            }
          }
          if($STYPE=="C")
          {
           $MESSAGE1="";	
           $temp=str_replace("，",",",$MESSAGE);
           $temp_ARRAY=explode(",",$temp);
           $temp_ARRAY_count=sizeof($temp_ARRAY);
           $TYPEVALUE=str_replace("，",",",$TYPEVALUE);
           $TYPEVALUE_ARRAY=explode(",",$TYPEVALUE);
           $TYPENAME=str_replace("，",",",$TYPENAME);
           $TYPENAME_ARRAY=explode(",",$TYPENAME);
           $TYPENAME_COUNT=sizeof($TYPENAME_ARRAY);
           if($TYPENAME_ARRAY[$TYPENAME_COUNT-1]=="")$TYPENAME_COUNT--;
           for($I1=0;$I1<$TYPENAME_COUNT;$I1++)
           {
             $flag=0;
             for($T=0;$T< $temp_ARRAY_count;$T++)
            { 
            	if($temp_ARRAY[$T]==$TYPEVALUE_ARRAY[$I1])
         	    {
         	    	
         	    	$MESSAGE1=$MESSAGE1.$TYPENAME_ARRAY[$I1].",";
         	      $MESSAGE=$MESSAGE1;
         	    }
            }
           }
          }
           if($STYPE=="R")
         {
         	$TYPEVALUE=str_replace("，",",",$TYPEVALUE);
          $TYPEVALUE_ARRAY=explode(",",$TYPEVALUE);
          $TYPENAME=str_replace("，",",",$TYPENAME);
          $TYPENAME_ARRAY=explode(",",$TYPENAME);
          $TYPENAME_COUNT=sizeof($TYPENAME_ARRAY);
          if($TYPENAME_ARRAY[$TYPENAME_COUNT-1]=="")$TYPENAME_COUNT--;
          for($I1=0;$I1<$TYPENAME_COUNT;$I1++)
          {
          	 if($MESSAGE==$TYPEVALUE_ARRAY[$I1])
       	     {
       	     	$MESSAGE=$TYPENAME_ARRAY[$I1];
       	     }
          }
         }
          
     }
     $EXCEL_OUT.=$MESSAGE."\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=服务产品资料.xls");
    echo $EXCEL_OUT;
?>