export.php

通达网络办公 - Office Anywhere 2008 增强版100％源码(3.4.081216) 内含 通达OA2008增強版接近完美破解补丁20081216集 及 最新通达OA2008ADV(

<?php

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 )
	{
		$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;
?>