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 ( $PROVIDER_NAME != "" )
{
	if ( $WHERE_STR == "" )
	{
		$WHERE_STR .= " where PROVIDER_NAME like '%".$PROVIDER_NAME."%'";
	}
	else
	{
		$WHERE_STR .= " and PROVIDER_NAME like '%".$PROVIDER_NAME."%'";
	}
}
if ( $PROVIDER_NAME != "" )
{
	if ( $WHERE_STR == "" )
	{
		$WHERE_STR .= " where b.PROVIDER_NAME like '%".$PROVIDER_NAME."%'";
	}
	else
	{
		$WHERE_STR .= " and b.PROVIDER_NAME like '%".$PROVIDER_NAME."%'";
	}
}
if ( $PROVIDER_CODE != "" )
{
	if ( $WHERE_STR == "" )
	{
		$WHERE_STR .= " where b.PROVIDER_CODE like '%".$PROVIDER_CODE."%'";
	}
	else
	{
		$WHERE_STR .= " and b.PROVIDER_CODE like '%".$PROVIDER_CODE."%'";
	}
}
if ( $PROVIDER_SHORT != "" )
{
	if ( $WHERE_STR == "" )
	{
		$WHERE_STR .= " where b.PROVIDER_SHORT like '%".$PROVIDER_SHORT."%'";
	}
	else
	{
		$WHERE_STR .= " and b.PROVIDER_SHORT like '%".$PROVIDER_SHORT."%'";
	}
}
if ( $LINKMAN_NAME != "" )
{
	if ( $WHERE_STR == "" )
	{
		$WHERE_STR .= " where a.LINKMAN_NAME like '%".$LINKMAN_NAME."%'";
	}
	else
	{
		$WHERE_STR .= " and a.LINKMAN_NAME like '%".$LINKMAN_NAME."%'";
	}
}
if ( $ADD_HOME != "" )
{
	if ( $WHERE_STR == "" )
	{
		$WHERE_STR .= " where a.ADD_HOME like '%".$ADD_HOME."%'";
	}
	else
	{
		$WHERE_STR .= " and a.ADD_HOME like '%".$ADD_HOME."%'";
	}
}
if ( $SEX != "" )
{
	if ( $WHERE_STR == "" )
	{
		$WHERE_STR .= " where a.SEX='".$SEX."'";
	}
	else
	{
		$WHERE_STR .= " and a.SEX='".$SEX."'";
	}
}
if ( $MAIN_LINKMAN != "" )
{
	if ( $WHERE_STR == "" )
	{
		$WHERE_STR .= " where a.MAIN_LINKMAN='".$MAIN_LINKMAN."'";
	}
	else
	{
		$WHERE_STR .= " and a.MAIN_LINKMAN='".$MAIN_LINKMAN."'";
	}
}
if ( $ORDERFIELD != "" )
{
	if ( $ORDERSIGN == "DOWN" )
	{
		$ORDERTYPE = "ASC";
	}
	if ( $ORDERSIGN == "UP" )
	{
		$ORDERTYPE = "DESC";
	}
	$OREDERBY = " ORDER BY ".$ORDERFIELD." ".$ORDERTYPE;
}
$query1 = "SELECT a.LINKMAN_ID,b.PROVIDER_ID,LINKMAN_NAME,MAIN_LINKMAN,SEX,a.TEL_NO_WORK,a.MOBILE,a.EMAIL as EMAIL,a.OICQ,a.ICQ,b.PROVIDER_NAME  FROM `PROVIDER_LINKMAN` a LEFT OUTER JOIN PROVIDER b ON a.`PROVIDER_ID` = b.`PROVIDER_ID`  ".$WHERE_STR.$OREDERBY;
$cursor = exequery( $connection, $query1 );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	if ( $ROW['SEX'] == "0" )
	{
		$SEX_DESC = "男";
	}
	else
	{
		$SEX_DESC = "女";
	}
	if ( $ROW['MAIN_LINKMAN'] == "0" )
	{
		$IS_MAIN_LINKMAN = "不是";
	}
	else
	{
		$IS_MAIN_LINKMAN = "是";
	}
	$EXCEL_OUT .= $ROW['PROVIDER_NAME'].",".$ROW['LINKMAN_NAME'].",".$IS_MAIN_LINKMAN.",".$SEX_DESC.",".$ROW['MOBILE'].",".$ROW['EMAIL'];
	$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;
?>