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";
$WHERE_STR .= " where (a.SALESMAN='".$LOGIN_USER_ID."' or a.CREATOR='{$LOGIN_USER_ID}') and a.CONTRACT_ID='-1' and a.LINE_ID='-1' ";
if ( $HISTORY_CODE != "" )
{
	$WHERE_STR .= " and a.HISTORY_CODE like '%".$HISTORY_CODE."%'";
}
if ( $CUSTOMER_NAME != "" )
{
	$WHERE_STR .= " and b.CUSTOMER_NAME like '%".$CUSTOMER_NAME."%'";
}
if ( $CUSTOMER_CODE != "" )
{
	$WHERE_STR .= " and b.CUSTOMER_CODE like '%".$CUSTOMER_CODE."%'";
}
if ( $CUSTOMER_SHORT != "" )
{
	$WHERE_STR .= " and b.CUSTOMER_SHORT like '%".$CUSTOMER_SHORT."%'";
}
if ( $ARE != "" )
{
	$WHERE_STR .= " and b.CUSTOMER_AREA= '".$ARE."'";
}
if ( $KIND != "" )
{
	$WHERE_STR .= " and b.KIND= '".$KIND."'";
}
if ( $SELLMODE != "" )
{
	$WHERE_STR .= " and b.SELLMODE= '".$SELLMODE."'";
}
if ( $ATTRIBUTE != "" )
{
	$WHERE_STR .= " and b.ATTRIBUTE= '".$ATTRIBUTE."'";
}
if ( $ENTERTYPE != "" )
{
	$WHERE_STR .= " and b.ENTERTYPE= '".$ENTERTYPE."'";
}
if ( $PRODUCT_NAME != "" )
{
	$WHERE_STR .= " and c.PRODUCT_NAME like '%".$PRODUCT_NAME."%'";
}
if ( $PRODUCT_MODE != "" )
{
	$WHERE_STR .= " and c.PRODUCT_MODE ='".$PRODUCT_MODE."'";
}
if ( $PRODUCT_TYPE != "" )
{
	$WHERE_STR .= " and c.PRODUCT_TYPE like '%".$PRODUCT_TYPE."%'";
}
if ( $SERVICE_NAME != "" )
{
	$WHERE_STR .= " and d.SERVICE_NAME like '%".$SERVICE_NAME."%'";
}
if ( $SERVICE_DESC != "" )
{
	$WHERE_STR .= " and d.SERVICE_DESC like '%".$SERVICE_DESC."%'";
}
if ( $DATE1 != "" )
{
	$WHERE_STR .= "  and a.DATE>='".$DATE1."'";
}
if ( $DATE2 != "" )
{
	$WHERE_STR .= "  and a.DATE<='".$DATE2."'";
}
if ( $ORDERFIELD != "" )
{
	if ( $ORDERSIGN == "DOWN" )
	{
		$ORDERTYPE = "ASC";
	}
	if ( $ORDERSIGN == "UP" )
	{
		$ORDERTYPE = "DESC";
	}
	$OREDERBY = " ORDER BY ".$ORDERFIELD." ".$ORDERTYPE;
}
$query1 = "SELECT c.PRODUCT_NAME as PRODUCT_NAME,d.SERVICE_NAME as SERVICE_NAME,a.PRICE as PRICE,a.AMT as AMT,a.TOTAL_PRICE as TOTAL_PRICE,a.DATE as DATE,a.HISTORY_CODE as HISTORY_CODE,e.USER_NAME as SELLER,b.CUSTOMER_NAME as CUSTOMER_NAME,a.HISTORY_ID as HISTORY_ID,a.TYPE as TYPE,f.USER_NAME as CREATOR\r\n         from SALE_HISTORY a\r\n         LEFT OUTER JOIN CUSTOMER b ON a.CUSTOMER_ID=b.CUSTOMER_ID\r\n         LEFT OUTER JOIN PRODUCT  c ON a.PRODUCT_ID=c.PRODUCT_ID and a.TYPE='PRO'\r\n         LEFT OUTER JOIN SERVICE  d ON a.SERVICE_ID=d.SERVICE_ID and a.TYPE='SER'\r\n         LEFT OUTER JOIN USER  e ON a.SALESMAN=e.USER_ID\r\n         LEFT OUTER JOIN USER  f ON a.CREATOR=f.USER_ID\r\n         ".$WHERE_STR.$OREDERBY;
$cursor = exequery( $connection, $query1 );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$EXCEL_OUT .= $ROW['HISTORY_CODE'].",".$ROW['PRODUCT_NAME'].",".$ROW['SERVICE_NAME'].",".$ROW['PRICE'].",".$ROW['AMT'].",".$ROW['TOTAL_PRICE'].",".$ROW['DATE'].",".$ROW['CUSTOMER_NAME'].",".$ROW['SELLER'].",".$ROW['CREATOR'];
	$EXCEL_OUT .= "\n";
}
echo $query1;
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;
?>