export.php

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

<?php

function GETALLDATE( $CODE, $GETVALUE )
{
	global $connection;
	$query = "SELECT * from SYS_CODE where PARENT_NO='".$CODE."' order by CODE_ORDER";
	$cursor = exequery( $connection, $query );
	while ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$CODE_NO = $ROW['CODE_NO'];
		$CODE_NAME = $ROW['CODE_NAME'];
		if ( !( $CODE_NO == $GETVALUE ) )
		{
			continue;
		}
		return $CODE_NAME;
	}
}

include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
include_once( "inc/check_type.php" );
$EXCEL_OUT = "办公用品名称,办公用品类别,单价,办公用品描述,计量单位,供应商,警戒库存,当前库存,创建人,管理人";
$EXCEL_OUT .= "\n";
if ( $LOGIN_USER_ID != "admin" )
{
	$WHERE_STR = " where (PRO_MANAGER='".$LOGIN_USER_ID."' or PRO_CREATOR='{$LOGIN_USER_ID}' or (PRO_MANAGER='' and PRO_DEPT=''))";
}
else
{
	$WHERE_STR = " where 1=1";
}
if ( $PRO_NAME != "" )
{
	$WHERE_STR .= " and PRO_NAME like '%".$PRO_NAME."%'";
}
if ( $PRO_DESC != "" )
{
	$WHERE_STR .= " and PRO_DESC like '%".$PRO_DESC."%'";
}
if ( $LOW_Stock == -1 )
{
	$WHERE_STR .= " and `PRO_STOCK` <= `PRO_LOWSTOCK`";
}
if ( $OFFICE_PROTYPE != "" )
{
	$WHERE_STR .= " and OFFICE_PROTYPE= '".$OFFICE_PROTYPE."'";
}
$query1 = "select * from OFFICE_PRODUCTS".$WHERE_STR;
$cursor = exequery( $connection, $query1 );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$OFFICE_PROTYPE = getalldate( "OFFICE_PROTYPE", $ROW['OFFICE_PROTYPE'] );
	$EXCEL_OUT .= "\"".str_replace( "\"", "\"\"", $ROW['PRO_NAME'] )."\",\"".$OFFICE_PROTYPE."\",\"".str_replace( "\"", "\"\"", $ROW['PRO_PRICE'] )."\",\"".str_replace( "\"", "\"\"", $ROW['PRO_DESC'] )."\",\"".str_replace( "\"", "\"\"", $ROW['PRO_UNIT'] )."\",\"".str_replace( "\"", "\"\"", $ROW['PRO_SUPPLIER'] )."\",\"".$ROW['PRO_LOWSTOCK']."\",\"".$ROW['PRO_STOCK']."\",\"".$ROW['PRO_CREATOR']."\",\"".$ROW['PRO_MANAGER']."\"";
	$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=办公用品.csv" );
echo $EXCEL_OUT;
?>