word_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++)
   {
   	 if($I==0)
      {
      	$WORD_OUT.="<table border=1 cellspacing=0 cellpadding=0 style='border-collapse:collapse;border:none;mso-border-alt:solid'><tr bgcolor=#EEEEEE>";
      }
   	  $WORD_OUT.="<td nowrap align=\"center\" style='border:solid windowtext .5pt;padding:0.1cm 5.4pt 0.1cm 5.4pt'><b>$STYLE_ARRAY[$I]</b></td>";
    }
  $WORD_OUT.="</tr>";
  
//-----------先组织SQL语句-----------
if($PRODUCT_NAME!="")
 {
     if($WHERE_STR=="")
         $WHERE_STR.=" where PRODUCT_NAME like '%".$PRODUCT_NAME."%'";
     else
         $WHERE_STR.=" and PRODUCT_NAME like '%".$PRODUCT_NAME."%'";
 }
  if($PRODUCT_TYPE!="")
 {
     if($WHERE_STR=="")
         $WHERE_STR.=" where PRODUCT_TYPE like '%".$PRODUCT_TYPE."%'";
     else
         $WHERE_STR.=" and PRODUCT_TYPE like '%".$PRODUCT_TYPE."%'";
 }
  if($PRODUCT_DESC!="")
 {
     if($WHERE_STR=="")
         $WHERE_STR.=" where PRODUCT_DESC like '%".$PRODUCT_DESC."%'";
     else
         $WHERE_STR.=" and PRODUCT_DESC like '%".$PRODUCT_DESC."%'";
 }
 if($PRODUCT_MODE!="")
   {
     if($WHERE_STR=="")
         $WHERE_STR.=" where PRODUCT_MODE ='$PRODUCT_MODE'";
     else
         $WHERE_STR.=" and PRODUCT_MODE ='$PRODUCT_MODE'";
   }

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 c.PROVIDER_NAME as PROVIDER_NAME,PRODUCT_NAME,PRODUCT_CODE,PRODUCT_TYPE,b.CODE_NAME as PRODUCT_MODE,MEASURE_UNIT,COST_PRICE,STANDARD_PRICE,PRODUCT_DESC,a.MEMO,a.MEMO1,a.USERDEF1,a.USERDEF2,a.USERDEF3,a.USERDEF4,a.USERDEF5 FROM PRODUCT a LEFT OUTER JOIN SYS_CODE b
        ON a.PRODUCT_MODE = b.CODE_NO AND b.PARENT_NO = 'PRODUCT_MODE'
        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))
 {
 	 $WORD_OUT.="<tr>";
 	 $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='PRODUCT' 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];
       	     }
          }
         }
          
     }
     $WORD_OUT.="<td align=\"center\" style='border:solid windowtext .5pt;padding:0.1cm 5.4pt 0.1cm 5.4pt'>$MESSAGE</td>";
     
   }
   $WORD_OUT.="</tr>";
 }
  $WORD_OUT.="</table>";
  $WORD_NAME="产品资料";
 ob_end_clean();
 Header("Cache-control: private");
 Header("Content-type: application/msword");
 Header("Accept-Ranges: bytes");
 Header("Accept-Length: ".strlen($WORD_OUT));
 Header("Content-Disposition: attachment; filename= $WORD_NAME.doc");

 echo $WORD_OUT;
?>