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_org.php" );
include_once( "inc/check_type.php" );
$EXCEL_OUT = "供应商编码,供应商名称,地区,电话,传真,电子邮件,记录员";
$EXCEL_OUT .= "\n";
$query1 = "select DEPT_ID from DEPARTMENT";
$cursor1 = exequery( $connection, $query1 );
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
	$DEPT_ID = $ROW['DEPT_ID'];
	if ( is_dept_priv( $DEPT_ID ) == 1 )
	{
		$TO_ID = $TO_ID.$DEPT_ID.",";
	}
}
$TO_ID = "'".str_replace( ",", "','", substr( $TO_ID, 0, -1 ) )."'";
$WHERE_STR .= " where c.DEPT_ID in (".$TO_ID.")";
$query1 = "select PRIV_NO from USER_PRIV where USER_PRIV='".$LOGIN_USER_PRIV."'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
	$LOGIN_PRIVNO = $ROW['PRIV_NO'];
}
$query1 = "select USER_PRIV,PRIV_NO from USER_PRIV";
$cursor1 = exequery( $connection, $query1 );
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
	$PRIV_NO = $ROW['PRIV_NO'];
	$USER_PRIV = $ROW['USER_PRIV'];
	if ( $LOGIN_PRIVNO < $PRIV_NO )
	{
		$TO_PRIV = $TO_PRIV.$USER_PRIV.",";
	}
}
$TO_PRIV = "'".str_replace( ",", "','", substr( $TO_PRIV, 0, -1 ) )."'";
$WHERE_STR .= " and (c.USER_PRIV in (".$TO_PRIV.") or a.PROVIDER_RECORDER='{$LOGIN_USER_ID}')";
if ( $PROVIDER_NAME != "" )
{
	$WHERE_STR .= " and PROVIDER_NAME like '%".$PROVIDER_NAME."%'";
}
if ( $PROVIDER_CODE != "" )
{
	$WHERE_STR .= " and PROVIDER_CODE like '%".$PROVIDER_CODE."%'";
}
if ( $PROVIDER_SHORT != "" )
{
	$WHERE_STR .= " and PROVIDER_SHORT like '%".$PROVIDER_SHORT."%'";
}
if ( $PROVIDER_AREA != "" )
{
	$WHERE_STR .= " and PROVIDER_AREA= '".$PROVIDER_AREA."'";
}
if ( $MEMO != "" )
{
	$WHERE_STR .= " and MEMO like '%".$MEMO."%'";
}
if ( $ORDERFIELD != "" )
{
	if ( $ORDERSIGN == "DOWN" )
	{
		$ORDERTYPE = "ASC";
	}
	if ( $ORDERSIGN == "UP" )
	{
		$ORDERTYPE = "DESC";
	}
	$OREDERBY = " ORDER BY ".$ORDERFIELD." ".$ORDERTYPE;
}
$query1 = "SELECT a.PROVIDER_RECORDER as PROVIDER_RECORDERID,PROVIDER_ID,PROVIDER_NAME,TEL_NO,FAX_NO,a.EMAIL as EMAIL,b.CODE_NAME as PROVIDER_AREA,BANK,ACCOUNT,PROVIDER_CODE,USER_NAME as PROVIDER_RECORDER from PROVIDER a\r\n         LEFT OUTER JOIN SYS_CODE b ON a.PROVIDER_AREA=b.CODE_NO AND b.PARENT_NO = 'AREA'\r\n         LEFT OUTER JOIN USER c ON a.PROVIDER_RECORDER=c.USER_ID\r\n         ".$WHERE_STR.$OREDERBY;
$cursor = exequery( $connection, $query1 );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$EXCEL_OUT .= $ROW['PROVIDER_CODE'].",".$ROW['PROVIDER_NAME'].",".$ROW['PROVIDER_AREA'].",".$ROW['TEL_NO'].",".$ROW['FAX_NO'].",".$ROW['EMAIL'].",".$ROW['PROVIDER_RECORDER'];
	$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;
?>