?? export.php
字號:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
ob_end_clean();
$EXCEL_OUT="部門,書名,作者,圖書編號,圖書類別,ISBN號,出版社,出版日期,存放地點,數(shù)量,價格,內(nèi)容簡介,借閱狀態(tài),錄入人,備注\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= 圖書信息導(dǎo)出.csv");
echo $EXCEL_OUT;
?>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -