word_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	)
{
	if ( $I == 0 )
	{
		$WORD_OUT .= "<table border=1 cellspacing=0 cellpadding=0 style='border-collapse:collapse;border:none;mso-border-alt:solid'><tr bgcolor=#EEEEEE>";
	}
	$WORD_OUT .= "<td nowrap align=\"center\" style='border:solid windowtext .5pt;padding:0.1cm 5.4pt 0.1cm 5.4pt'><b>".$STYLE_ARRAY[$I]."</b></td>";
}
$WORD_OUT .= "</tr>";
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_CODE != "" )
{
	if ( $WHERE_STR == "" )
	{
		$WHERE_STR .= " where PROVIDER_CODE like '%".$PROVIDER_CODE."%'";
	}
	else
	{
		$WHERE_STR .= " and PROVIDER_CODE like '%".$PROVIDER_CODE."%'";
	}
}
if ( $PROVIDER_SHORT != "" )
{
	if ( $WHERE_STR == "" )
	{
		$WHERE_STR .= " where PROVIDER_SHORT like '%".$PROVIDER_SHORT."%'";
	}
	else
	{
		$WHERE_STR .= " and PROVIDER_SHORT like '%".$PROVIDER_SHORT."%'";
	}
}
if ( $PROVIDER_AREA != "" )
{
	if ( $WHERE_STR == "" )
	{
		$WHERE_STR .= " where PROVIDER_AREA= '".$PROVIDER_AREA."'";
	}
	else
	{
		$WHERE_STR .= " and PROVIDER_AREA= '".$PROVIDER_AREA."'";
	}
}
if ( $PROVIDER_ADD != "" )
{
	if ( $WHERE_STR == "" )
	{
		$WHERE_STR .= " where PROVIDER_ADD= '".$PROVIDER_ADD."'";
	}
	else
	{
		$WHERE_STR .= " and PROVIDER_ADD= '".$PROVIDER_ADD."'";
	}
}
if ( $PROVIDER_ADD != "" )
{
	if ( $WHERE_STR == "" )
	{
		$WHERE_STR .= " where MEMO= '".$MEMO."'";
	}
	else
	{
		$WHERE_STR .= " and MEMO= '".$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."%'";
	}
}
$query1 = "SELECT PROVIDER_SHORT,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,PROVIDER_WWW,PROVIDER_ADD,MEMO,a.USERDEF1,a.USERDEF2,a.USERDEF3,a.USERDEF4,a.USERDEF5 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;
echo $query1;
$cursor = exequery( $connection, $query1 );
$USER_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$WORD_OUT .= "<tr>";
	$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] == "USERDEF1" || $STYLE_ARRAY[$I] == "USERDEF2" || $STYLE_ARRAY[$I] == "USERDEF3" || $STYLE_ARRAY[$I] == "USERDEF4" || $STYLE_ARRAY[$I] == "USERDEF5" )
		{
			$query = "select * from FIELDSETTING where TABLENAME='PROVIDER' 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];
					}
				}
			}
		}
		$WORD_OUT .= "<td align=\"center\" style='border:solid windowtext .5pt;padding:0.1cm 5.4pt 0.1cm 5.4pt'>".$MESSAGE."</td>";
	}
	$WORD_OUT .= "</tr>";
}
$WORD_OUT .= "</table>";
$WORD_NAME = "供应商信息";
ob_end_clean( );
header( "Cache-control: private" );
header( "Content-type: application/msword" );
header( "Accept-Ranges: bytes" );
header( "Accept-Length: ".strlen( $WORD_OUT ) );
header( "Content-Disposition: attachment; filename= ".$WORD_NAME.".doc" );
echo $WORD_OUT;
?>