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语句-----------
 $WHERE_STR.=" where a.SALESMAN='$LOGIN_USER_ID' and a.CONTRACT_ID='-1' and a.LINE_ID='-1' ";
 if($CUSTOMER_NAME!="")
		 $WHERE_STR.=" and b.CUSTOMER_NAME like '%".$CUSTOMER_NAME."%'";
 if($CUSTOMER_CODE!="")
		 $WHERE_STR.=" and b.CUSTOMER_CODE like '%".$CUSTOMER_CODE."%'";
 if($CUSTOMER_SHORT!="")
		 $WHERE_STR.=" and b.CUSTOMER_SHORT like '%".$CUSTOMER_SHORT."%'";
 if($ARE!="")
		 $WHERE_STR.=" and b.CUSTOMER_AREA= '$ARE'";
 if($KIND!="")
		 $WHERE_STR.=" and b.KIND= '$KIND'";
 if($SELLMODE!="")
		 $WHERE_STR.=" and b.SELLMODE= '$SELLMODE'";
 if($ATTRIBUTE!="")
		 $WHERE_STR.=" and b.ATTRIBUTE= '$ATTRIBUTE'";
 if($ENTERTYPE!="")
		 $WHERE_STR.=" and b.ENTERTYPE= '$ENTERTYPE'";
 if($PRODUCT_NAME!="")
     $WHERE_STR.=" and c.PRODUCT_NAME like '%".$PRODUCT_NAME."%'";
 if($PRODUCT_MODE!="")
      $WHERE_STR.=" and c.PRODUCT_MODE ='$PRODUCT_MODE'";
 if($PRODUCT_TYPE!="")
      $WHERE_STR.=" and c.PRODUCT_TYPE like '%".$PRODUCT_TYPE."%'";
 if($SERVICE_NAME!="")
    $WHERE_STR.=" and d.SERVICE_NAME like '%".$SERVICE_NAME."%'";
 if($SERVICE_DESC!="")
    $WHERE_STR.=" and d.SERVICE_DESC like '%".$SERVICE_DESC."%'";

if($DATE1!="")
    $WHERE_STR.="  and a.DATE>='$DATE1'";
if($DATE2!="")
    $WHERE_STR.="  and a.DATE<='$DATE2'";
 
$query1="SELECT c.PRODUCT_NAME as PRODUCT_NAME,d.SERVICE_NAME as SERVICE_NAME,a.PRICE as PRICE,a.AMT as AMT,a.TOTAL_PRICE as TOTAL_PRICE,a.DATE as DATE,e.USER_NAME as SELLER,b.CUSTOMER_NAME as CUSTOMER_NAME,a.HISTORY_ID as HISTORY_ID,a.TYPE as TYPE,c.PRODUCT_CODE as PRODUCT_CODE,d.SERVICE_CODE as SERVICE_CODE
         from SALE_HISTORY a
         LEFT OUTER JOIN CUSTOMER b ON a.CUSTOMER_ID=b.CUSTOMER_ID
         LEFT OUTER JOIN PRODUCT  c ON a.PRODUCT_ID=c.PRODUCT_ID and a.TYPE='PRO'
         LEFT OUTER JOIN SERVICE  d ON a.SERVICE_ID=d.SERVICE_ID and a.TYPE='SER'
         LEFT OUTER JOIN USER  e ON a.SALESMAN=e.USER_ID
         ".$WHERE_STR;    
 $cursor= exequery($connection,$query1);
 $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='OPPORTUNITY' 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;
?>