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 ( $SCOPE == "1" || $SCOPE == "" )
{
	$WHERE_STR .= " where (b.SELLER='".$LOGIN_USER_ID."' or a.SELLER='{$LOGIN_USER_ID}')";
}
if ( $SCOPE == "2" )
{
	$WHERE_STR .= " where ((find_in_set( '".$LOGIN_USER_ID."',b.SHAREUSER) and b.SHARE='1') or (b.SHAREUSER='' and  b.SELLER!='{$LOGIN_USER_ID}' and b.SHARE='1') or a.SELLER='{$LOGIN_USER_ID}' )";
}
if ( $SCOPE == "3" )
{
	$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 (h.DEPT_ID in (".$TO_ID.") or a.SELLER='{$LOGIN_USER_ID}')";
}
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 ( $CUSTOMER_AREA != "" )
{
	$WHERE_STR .= " and b.CUSTOMER_AREA='".$CUSTOMER_AREA."'";
}
if ( $CUSTOMER_ADD != "" )
{
	$WHERE_STR .= " and b.CUSTOMER_ADD like '%".$CUSTOMER_ADD."%'";
}
if ( $SOURCE != "" )
{
	$WHERE_STR .= " and b.SOURCE ='".$SOURCE."'";
}
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 ( $ENTERMEMO != "" )
{
	$WHERE_STR .= " and b.ENTERMEMO like '%".$ENTERMEMO."%'";
}
if ( $CUSTOMERUSERDEF1 != "" )
{
	$WHERE_STR .= " and b.USERDEF1 like '%".$CUSTOMERUSERDEF1."%'";
}
if ( $CUSTOMERUSERDEF2 != "" )
{
	$WHERE_STR .= " and b.USERDEF2 like '%".$CUSTOMERUSERDEF2."%'";
}
if ( $CUSTOMERUSERDEF3 != "" )
{
	$WHERE_STR .= " and b.USERDEF3 like '%".$CUSTOMERUSERDEF3."%'";
}
if ( $CUSTOMERUSERDEF4 != "" )
{
	$WHERE_STR .= " and b.USERDEF4 like '%".$CUSTOMERUSERDEF4."%'";
}
if ( $CUSTOMERUSERDEF5 != "" )
{
	$WHERE_STR .= " and b.USERDEF5 like '%".$CUSTOMERUSERDEF5."%'";
}
if ( $LINKMAN_NAME != "" )
{
	$urlstr = $urlstr."&LINKMAN_NAME=".$LINKMAN_NAME;
	$WHERE_STR .= " and a.LINKMAN_NAME like '%".$LINKMAN_NAME."%'";
}
if ( $SEX != "" )
{
	$urlstr = $urlstr."&SEX=".$SEX;
	$WHERE_STR .= " and a.SEX ='".$SEX."'";
}
if ( $HOBBY != "" )
{
	$urlstr = $urlstr."&HOBBY=".$HOBBY;
	$WHERE_STR .= " and a.HOBBY like '%".$HOBBY."%'";
}
if ( $LINKMANUSERDEF1 != "" )
{
	$urlstr = $urlstr."&LINKMANUSERDEF1=".$LINKMANUSERDEF1;
	$WHERE_STR .= " and a.USERDEF1 like '%".$LINKMANUSERDEF1."%'";
}
if ( $LINKMANUSERDEF2 != "" )
{
	$urlstr = $urlstr."&LINKMANUSERDEF2=".$LINKMANUSERDEF2;
	$WHERE_STR .= " and a.USERDEF2 like '%".$LINKMANUSERDEF2."%'";
}
if ( $LINKMANUSERDEF3 != "" )
{
	$urlstr = $urlstr."&LINKMANUSERDEF3=".$LINKMANUSERDEF3;
	$WHERE_STR .= " and a.USERDEF3 like '%".$LINKMANUSERDEF3."%'";
}
if ( $LINKMANUSERDEF4 != "" )
{
	$urlstr = $urlstr."&LINKMANUSERDEF4=".$LINKMANUSERDEF4;
	$WHERE_STR .= " and a.USERDEF4 like '%".$LINKMANUSERDEF4."%'";
}
if ( $LINKMANUSERDEF5 != "" )
{
	$urlstr = $urlstr."&LINKMANUSERDEF5=".$LINKMANUSERDEF5;
	$WHERE_STR .= " and a.USERDEF5 like '%".$LINKMANUSERDEF5."%'";
}
$query1 = "SELECT a.LINKMAN_NAME,a.SEX,a.BIRTHDAY,a.HOBBY,a.POST_PRIV,a.POSTALCODE_HOME,a.ADD_HOME,a.TEL_NO_WORK,a.TEL_NO_HOME,a.MOBILE,a.EMAIL as EMAIL,a.OICQ,a.ICQ,a.MEMO,a.MEMO1,a.USERDEF1,a.USERDEF2,a.USERDEF3,a.USERDEF4,a.USERDEF5,b.CUSTOMER_NAME  \r\n          FROM `LINKMAN` a \r\n          LEFT OUTER JOIN CUSTOMER b ON a.`CUSTOMER_ID` = b.`CUSTOMER_ID` \r\n          LEFT OUTER JOIN USER h ON a.SELLER = h.USER_ID ".$WHERE_STR;
echo $query1;
$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] == "USERDEF1" || $STYLE_ARRAY[$I] == "USERDEF2" || $STYLE_ARRAY[$I] == "USERDEF3" || $STYLE_ARRAY[$I] == "USERDEF4" || $STYLE_ARRAY[$I] == "USERDEF5" )
		{
			$query = "select * from FIELDSETTING where TABLENAME='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;
?>