export.php

通达OA官方提供的30源代码,感觉很实在

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

ob_end_clean();

$EXCEL_OUT="部门,书名,作者,图书编号,图书类别,ISBN号,出版社,出版日期,存放地点,数量,价格,内容简介,借阅状态,录入人,备注\n";

$WHERE_STR=" where 1=1";
if($BOOK_NAME!="")
  $WHERE_STR.=" and BOOK_NAME like '%".$BOOK_NAME."%'";
  
if($BOOK_NO!="")
  $WHERE_STR.=" and BOOK_NO like '%".$BOOK_NO."%'";

if($LEND!="")
  $WHERE_STR.=" and LEND='$LEND'";

if($AUTHOR!="")
  $WHERE_STR.=" and AUTHOR like '%".$AUTHOR."%'";

if($ISBN!="")
  $WHERE_STR.=" and ISBN like '%".$ISBN."%'";

if($PUB_HOUSE!="")
  $WHERE_STR.=" and PUB_HOUSE like '%".$PUB_HOUSE."%'";

if($AREA!="")
  $WHERE_STR.=" and AREA like '%".$AREA."%'";

if($TYPE_ID!="all")
  $WHERE_STR.=" and TYPE_ID='$TYPE_ID'";

if($LOGIN_USER_PRIV!=1)  
   $WHERE_STR.=" and (OPEN='0' or OPEN='' or OPEN='1' or find_in_set('$LOGIN_DEPT_ID',OPEN) or OPEN='ALL_DEPT'or BORR_PERSON='$LOGIN_USER_NAME')";

$query="SELECT * from BOOK_INFO ".$WHERE_STR." order by '$ORDER_FIELD'";
$cursor= exequery($connection,$query);
while($ROW=mysql_fetch_array($cursor))
{
	 $DEPT1=$ROW["DEPT"];
   $OPEN1=$ROW["OPEN"];
   $BORR_PERSON1=$ROW["BORR_PERSON"];
      
   if($OPEN1=="0" && $DEPT1!=$LOGIN_DEPT_ID && $LOGIN_USER_NAME!=$BORR_PERSON1)
      continue;
      
   $BOOK_ID=$ROW["BOOK_ID"];
   $BOOK_NAME1=$ROW["BOOK_NAME"];
   $TYPE_ID1=$ROW["TYPE_ID"];
   $AUTHOR1=$ROW["AUTHOR"];
   $ISBN1=$ROW["ISBN"];
   $PUB_HOUSE1=$ROW["PUB_HOUSE"];
   $PUB_DATE1=$ROW["PUB_DATE"];
   $AREA1=$ROW["AREA"];
   $AMT1=$ROW["AMT"];
   $PRICE1=$ROW["PRICE"];
   $BRIEF1=$ROW["BRIEF"];
   $LEND1=$ROW["LEND"];
   $BORR_PERSON1=$ROW["BORR_PERSON"];
   $MEMO1=$ROW["MEMO"];
   $DEPT1=$ROW["DEPT"];
   $BOOK_NO=$ROW["BOOK_NO"];
   $OPEN1=$ROW["OPEN"];      

   if($LEND1=="1")
  	  $LEND_DESC="已借出";
   else
  	  $LEND_DESC="未借出";

   $query2 = "SELECT TYPE_NAME from BOOK_TYPE where TYPE_ID='$TYPE_ID1'";
   $cursor2=exequery($connection,$query2);
   if($ROW=mysql_fetch_array($cursor2))
   	$TYPE_NAME=$ROW["TYPE_NAME"];
 
   $query3 = "SELECT DEPT_NAME from DEPARTMENT where DEPT_ID='$DEPT1'";
   $cursor3=exequery($connection,$query3);
   if($ROW=mysql_fetch_array($cursor3))
   	  $DEPT_NAME=$ROW["DEPT_NAME"];

   $BRIEF1 = str_replace("\r\n","",str_replace(",","，",$BRIEF1));

   $EXCEL_OUT.="$DEPT_NAME,$BOOK_NAME1,$AUTHOR1,$BOOK_NO,$TYPE_NAME,$ISBN1,$PUB_HOUSE1,$PUB_DATE1,$AREA1,$AMT1,$PRICE1,$BRIEF1,$LEND1,$BORR_PERSON1,$MEMO1\n";

}

Header("Cache-control: private");
Header("Content-type: application/vnd.ms-excel");
Header("Accept-Ranges: bytes");
Header("Accept-Length: ".strlen($EXCEL_OUT));
Header("Content-Length: ".strlen($EXCEL_OUT));
Header("Content-Disposition: attachment; filename= 图书信息导出.csv");
echo $EXCEL_OUT;
?>