excel_report.php

极限网络智能办公系统 - Office Automation 2008 官方100％ 源码

<?php
 

include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
$STYLE_ARRAY = explode( ",", $FIELDMSGNAME );
$ARRAY_COUNT = sizeof( $STYLE_ARRAY );
$COUNT = 0;
if ( $STYLE_ARRAY[$ARRAY_COUNT - 1] == "" )
{
	--$ARRAY_COUNT;
}
$I = 0;
for ( ;	$I < $ARRAY_COUNT;	++$I	)
{
	$EXCEL_OUT .= $STYLE_ARRAY[$I]."\t";
}
$EXCEL_OUT .= "\n";
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 ( $PROVIDER_AREA != "" )
{
	if ( $WHERE_STR == "" )
	{
		$WHERE_STR .= " where b.PROVIDER_AREA= '".$PROVIDER_AREA."'";
	}
	else
	{
		$WHERE_STR .= " and b.PROVIDER_AREA= '".$PROVIDER_AREA."'";
	}
}
if ( $PROVIDER_ADD != "" )
{
	if ( $WHERE_STR == "" )
	{
		$WHERE_STR .= " where b.PROVIDER_ADD like '%".$PROVIDER_ADD."%'";
	}
	else
	{
		$WHERE_STR .= " and b.PROVIDER_ADD like '%".$PROVIDER_ADD."%'";
	}
}
if ( $PROVIDER_ADD != "" )
{
	if ( $WHERE_STR == "" )
	{
		$WHERE_STR .= " where b.MEMO like '%".$MEMO."%'";
	}
	else
	{
		$WHERE_STR .= " and b.MEMO like '%".$MEMO."%'";
	}
}
if ( $CUSTOMERUSERDEF1 != "" )
{
	if ( $WHERE_STR == "" )
	{
		$WHERE_STR .= " where USERDEF1 like '%".$CUSTOMERUSERDEF1."%'";
	}
	else
	{
		$WHERE_STR .= " and USERDEF1 like '%".$CUSTOMERUSERDEF1."%'";
	}
}
if ( $CUSTOMERUSERDEF2 != "" )
{
	if ( $WHERE_STR == "" )
	{
		$WHERE_STR .= " where USERDEF2 like '%".$CUSTOMERUSERDEF2."%'";
	}
	else
	{
		$WHERE_STR .= " and USERDEF2 like '%".$CUSTOMERUSERDEF2."%'";
	}
}
if ( $CUSTOMERUSERDEF3 != "" )
{
	if ( $WHERE_STR == "" )
	{
		$WHERE_STR .= " where USERDEF3 like '%".$CUSTOMERUSERDEF3."%'";
	}
	else
	{
		$WHERE_STR .= " and USERDEF3 like '%".$CUSTOMERUSERDEF3."%'";
	}
}
if ( $CUSTOMERUSERDEF4 != "" )
{
	if ( $WHERE_STR == "" )
	{
		$WHERE_STR .= " where USERDEF4 like '%".$CUSTOMERUSERDEF4."%'";
	}
	else
	{
		$WHERE_STR .= " and USERDEF4 like '%".$CUSTOMERUSERDEF4."%'";
	}
}
if ( $CUSTOMERUSERDEF5 != "" )
{
	if ( $WHERE_STR == "" )
	{
		$WHERE_STR .= " where USERDEF5 like '%".$CUSTOMERUSERDEF5."%'";
	}
	else
	{
		$WHERE_STR .= " and USERDEF5 like '%".$CUSTOMERUSERDEF5."%'";
	}
}
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 ( $POST_PRIV != "" )
{
	if ( $WHERE_STR == "" )
	{
		$WHERE_STR .= " where a.POST_PRIV like '%".$POST_PRIV."%'";
	}
	else
	{
		$WHERE_STR .= " and a.POST_PRIV like '%".$POST_PRIV."%'";
	}
}
if ( $POSTALCODE_HOME != "" )
{
	if ( $WHERE_STR == "" )
	{
		$WHERE_STR .= " where a.POSTALCODE_HOME like '%".$POSTALCODE_HOME."%'";
	}
	else
	{
		$WHERE_STR .= " and a.POSTALCODE_HOME like '%".$POSTALCODE_HOME."%'";
	}
}
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 ( $MEMO1 != "" )
{
	if ( $WHERE_STR == "" )
	{
		$WHERE_STR .= " where a.MEMO like '%".$MEMO1."%'";
	}
	else
	{
		$WHERE_STR .= " and a.MEMO like '%".$MEMO1."%'";
	}
}
$query1 = "SELECT a.LINKMAN_NAME,a.MAIN_LINKMAN,a.MEMO,a.MEMO1,a.SEX,a.TEL_NO_WORK,a.TEL_NO_HOME,a.MOBILE,a.EMAIL as EMAIL,a.OICQ,a.ICQ,a.POST_PRIV,a.BIRTHDAY,a.HOBBY,a.POSTALCODE_HOME,a.ADD_HOME,b.PROVIDER_NAME,b.PROVIDER_CODE,b.PROVIDER_SHORT  \r\n        FROM `PROVIDER_LINKMAN` a \r\n        LEFT OUTER JOIN PROVIDER b ON a.`PROVIDER_ID` = b.`PROVIDER_ID` ".$WHERE_STR;
$cursor = exequery( $connection, $query1 );
$USER_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$STYLE_ARRAY = explode( ",", $FIELDMSG );
	$ARRAY_COUNT = sizeof( $STYLE_ARRAY );
	$COUNT = 0;
	if ( $STYLE_ARRAY[$ARRAY_COUNT - 1] == "" )
	{
		--$ARRAY_COUNT;
	}
	$I = 0;
	for ( ;	$I < $ARRAY_COUNT;	++$I	)
	{
		$MESSAGE = $ROW[$STYLE_ARRAY[$I]];
		if ( $STYLE_ARRAY[$I] == "SEX" )
		{
			if ( $MESSAGE == "0" )
			{
				$MESSAGE = "男";
			}
			else if ( $MESSAGE == "1" )
			{
				$MESSAGE = "女";
			}
		}
		if ( $STYLE_ARRAY[$I] == "MAIN_LINKMAN" )
		{
			if ( $MESSAGE == "0" )
			{
				$MESSAGE = "普通联系人";
			}
			else if ( $MESSAGE == "1" )
			{
				$MESSAGE = "主联系人";
			}
		}
		if ( $STYLE_ARRAY[$I] == "USERDEF1" || $STYLE_ARRAY[$I] == "USERDEF2" || $STYLE_ARRAY[$I] == "USERDEF3" || $STYLE_ARRAY[$I] == "USERDEF4" || $STYLE_ARRAY[$I] == "USERDEF5" )
		{
			$query = "select * from FIELDSETTING where TABLENAME='PROVIDER_LINKMAN' and FIELDNO='".$STYLE_ARRAY[$I]."' ORDER BY ORDERNO ASC  ";
			$cursor1 = exequery( $connection, $query );
			if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
			{
				$FIELDNAME = $ROW1['FIELDNAME'];
				$ORDERNO = $ROW1['ORDERNO'];
				$STYPE = $ROW1['STYPE'];
				$TYPENAME = $ROW1['TYPENAME'];
				$TYPEVALUE = $ROW1['TYPEVALUE'];
				$TYPECODE = $ROW1['TYPECODE'];
				$ISQUERY = $ROW1['ISQUERY'];
				$ISGROUY = $ROW1['ISGROUY'];
				$FIELDNAME = $ROW1['FIELDNAME'];
				$FIELDNO = $ROW1['FIELDNO'];
				$FIELDNO1 = $FIELDNO."1";
			}
			if ( $STYPE == "D" )
			{
				$TYPEVALUE = str_replace( "，", ",", $TYPEVALUE );
				$TYPEVALUE_ARRAY = explode( ",", $TYPEVALUE );
				$TYPENAME = str_replace( "，", ",", $TYPENAME );
				$TYPENAME_ARRAY = explode( ",", $TYPENAME );
				$TYPENAME_COUNT = sizeof( $TYPENAME_ARRAY );
				if ( $TYPENAME_ARRAY[$TYPENAME_COUNT - 1] == "" )
				{
					--$TYPENAME_COUNT;
				}
				$I1 = 0;
				for ( ;	$I1 < $TYPENAME_COUNT;	++$I1	)
				{
					if ( $MESSAGE == $TYPEVALUE_ARRAY[$I1] )
					{
						$MESSAGE = $TYPENAME_ARRAY[$I1];
					}
				}
			}
			if ( $STYPE == "C" )
			{
				$MESSAGE1 = "";
				$temp = str_replace( "，", ",", $MESSAGE );
				$temp_ARRAY = explode( ",", $temp );
				$temp_ARRAY_count = sizeof( $temp_ARRAY );
				$TYPEVALUE = str_replace( "，", ",", $TYPEVALUE );
				$TYPEVALUE_ARRAY = explode( ",", $TYPEVALUE );
				$TYPENAME = str_replace( "，", ",", $TYPENAME );
				$TYPENAME_ARRAY = explode( ",", $TYPENAME );
				$TYPENAME_COUNT = sizeof( $TYPENAME_ARRAY );
				if ( $TYPENAME_ARRAY[$TYPENAME_COUNT - 1] == "" )
				{
					--$TYPENAME_COUNT;
				}
				$I1 = 0;
				for ( ;	$I1 < $TYPENAME_COUNT;	++$I1	)
				{
					$flag = 0;
					$T = 0;
					for ( ;	$T < $temp_ARRAY_count;	++$T	)
					{
						if ( $temp_ARRAY[$T] == $TYPEVALUE_ARRAY[$I1] )
						{
							$MESSAGE1 = $MESSAGE1.$TYPENAME_ARRAY[$I1].",";
							$MESSAGE = $MESSAGE1;
						}
					}
				}
			}
			if ( $STYPE == "R" )
			{
				$TYPEVALUE = str_replace( "，", ",", $TYPEVALUE );
				$TYPEVALUE_ARRAY = explode( ",", $TYPEVALUE );
				$TYPENAME = str_replace( "，", ",", $TYPENAME );
				$TYPENAME_ARRAY = explode( ",", $TYPENAME );
				$TYPENAME_COUNT = sizeof( $TYPENAME_ARRAY );
				if ( $TYPENAME_ARRAY[$TYPENAME_COUNT - 1] == "" )
				{
					--$TYPENAME_COUNT;
				}
				$I1 = 0;
				for ( ;	$I1 < $TYPENAME_COUNT;	++$I1	)
				{
					if ( $MESSAGE == $TYPEVALUE_ARRAY[$I1] )
					{
						$MESSAGE = $TYPENAME_ARRAY[$I1];
					}
				}
			}
		}
		$EXCEL_OUT .= $MESSAGE."\t";
	}
	$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=供应商联系人.xls" );
echo $EXCEL_OUT;
?>