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 ( $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."%'";
	}
}
$query1 = "SELECT * FROM PRODUCT a LEFT OUTER JOIN SYS_CODE b\r\n        ON a.PRODUCT_MODE = b.CODE_NO AND b.PARENT_NO = 'PRODUCT_MODE'\r\n        LEFT OUTER JOIN PROVIDER c\r\n        ON a.PROVIDER_ID = c.PROVIDER_ID".$WHERE_STR;
$cursor = exequery( $connection, $query1 );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$PRODUCT_MODE = getalldate( "PRODUCT_MODE", $ROW['PRODUCT_MODE'] );
	$EXCEL_OUT .= $ROW['PRODUCT_NAME'].",".$ROW['PRODUCT_CODE'].",".$ROW['PRODUCT_TYPE'].",".$PRODUCT_MODE.",".$ROW['MEASURE_UNIT'].",".$ROW['COST_PRICE'].",".$ROW['STANDARD_PRICE'].",".$ROW['PROVIDER_NAME'];
	$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;
?>