word_report.php

通达网络办公 - Office Anywhere 2008 增强版100％源码(3.4.081216) 内含 通达OA2008增強版接近完美破解补丁20081216集 及 最新通达OA2008ADV(

<?php

include_once( "inc/auth.php" );
include_once( "inc/utility_org.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 ( $SCOPE == "1" || $SCOPE == "" )
{
	$WHERE_STR .= " where a.SELLER='".$LOGIN_USER_ID."' ";
}
if ( $SCOPE == "2" )
{
	$WHERE_STR .= " where ((find_in_set( '".$LOGIN_USER_ID."',a.SHAREUSER) and a.SHARE='1') or (a.SHAREUSER='' and  a.SELLER!='{$LOGIN_USER_ID}' and a.SHARE='1'))";
}
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.")";
}
if ( $CUSTOMER_NAME != "" )
{
	$WHERE_STR .= " and a.CUSTOMER_NAME like '%".$CUSTOMER_NAME."%'";
}
if ( $CUSTOMER_CODE != "" )
{
	$WHERE_STR .= " and a.CUSTOMER_CODE like '%".$CUSTOMER_CODE."%'";
}
if ( $CUSTOMER_SHORT != "" )
{
	$WHERE_STR .= " and a.CUSTOMER_SHORT like '%".$CUSTOMER_SHORT."%'";
}
if ( $CUSTOMER_AREA != "" )
{
	$WHERE_STR .= " and a.CUSTOMER_AREA='".$CUSTOMER_AREA."'";
}
if ( $CUSTOMER_ADD != "" )
{
	$WHERE_STR .= " and a.CUSTOMER_ADD like '%".$CUSTOMER_ADD."%'";
}
if ( $SOURCE != "" )
{
	$WHERE_STR .= " and a.SOURCE ='".$SOURCE."'";
}
if ( $KIND != "" )
{
	$WHERE_STR .= " and a.KIND ='".$KIND."'";
}
if ( $SELLMODE != "" )
{
	$WHERE_STR .= " and a.SELLMODE ='".$SELLMODE."'";
}
if ( $ATTRIBUTE != "" )
{
	$WHERE_STR .= " and a.ATTRIBUTE ='".$ATTRIBUTE."'";
}
if ( $ENTERTYPE != "" )
{
	$WHERE_STR .= " and a.ENTERTYPE ='".$ENTERTYPE."'";
}
if ( $ENTERMEMO != "" )
{
	$WHERE_STR .= " and a.ENTERMEMO like '%".$ENTERMEMO."%'";
}
$query = "SELECT FIELDNO from FIELDSETTING where TABLENAME='CUSTOMER'";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$FIELDNO = "CUSTOMER".$ROW['FIELDNO'];
	if ( $$FIELDNO != "" )
	{
		$CUSTOMERID_STR = "";
		$urlstr = $urlstr."&".$FIELDNO."=".$$FIELDNO;
		$WHERE_STR1 = " where TABLENAME='CUSTOMER' and (FIELDNO='".$ROW['FIELDNO']."' and ITEM_DATE like '%".$$FIELDNO."%')";
		$query1 = "SELECT IDENTY_ID FROM `FIELD_DATE`".$WHERE_STR1;
		$cursor1 = exequery( $connection, $query1 );
		while ( $ROW1 = mysql_fetch_array( $cursor1 ) )
		{
			$CUSTOMERID_STR = $CUSTOMERID_STR.$ROW1['IDENTY_ID'].",";
		}
		$CUSTOMERID_STR = "'".str_replace( ",", "','", substr( $CUSTOMERID_STR, 0, -1 ) )."'";
		$WHERE_STR .= " and a.CUSTOMER_ID in (".$CUSTOMERID_STR.")";
	}
}
$query = "SELECT a.CUSTOMER_ID,a.CUSTOMER_NAME as CUSTOMER_NAME,a.CUSTOMER_SHORT as CUSTOMER_SHORT,a.CUSTOMER_CODE as CUSTOMER_CODE, a.TEL_NO as TEL_NO,\r\n        a.FAX_NO,a.CUSTOMER_WWW,a.EMAIL,d.CODE_NAME as CUSTOMER_AREA,a.CUSTOMER_ADD,a.POSTALCODE,a.MEMO,h.USER_NAME AS SELLER,\r\n        e.CODE_NAME AS `SOURCE`,c.CODE_NAME AS KIND,b.CODE_NAME AS 'SELLMODE',f.CODE_NAME AS `ATTRIBUTE`,g.CODE_NAME AS `ENTERTYPE`,\r\n        a.ENTERMEMO,a.MEMO1,a.USERDEF1,a.USERDEF2,a.USERDEF3,a.USERDEF4,a.USERDEF5\r\n        from CUSTOMER a LEFT OUTER JOIN SYS_CODE b\r\n        ON a.SELLMODE = b.CODE_NO AND b.PARENT_NO = 'SELL_MODE'\r\n        LEFT OUTER JOIN SYS_CODE c\r\n        ON a.KIND = c.CODE_NO AND c.PARENT_NO = 'CRM_KIND'\r\n        LEFT OUTER JOIN SYS_CODE d\r\n        ON a.CUSTOMER_AREA = d.CODE_NO AND d.PARENT_NO = 'AREA'\r\n        LEFT OUTER JOIN SYS_CODE e\r\n        ON a.SOURCE = e.CODE_NO AND e.PARENT_NO = 'CRM_SOURCE'\r\n        LEFT OUTER JOIN SYS_CODE f\r\n        ON a.ATTRIBUTE = f.CODE_NO AND f.PARENT_NO = 'CRM_ATTRIBUTE'\r\n        LEFT OUTER JOIN SYS_CODE g\r\n        ON a.ENTERTYPE = g.CODE_NO AND g.PARENT_NO = 'CRM_TYPE'\r\n        LEFT OUTER JOIN USER h ON a.SELLER = h.USER_ID\r\n        ".$WHERE_STR;
$cursor = exequery( $connection, $query );
$USER_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$WORD_OUT .= "<tr>";
	$STYLE_ARRAY = explode( ",", $FIELDMSG );
	$ARRAY_COUNT = sizeof( $STYLE_ARRAY );
	$IDENTY_ID = $ROW['CUSTOMER_ID'];
	$COUNT = 0;
	if ( $STYLE_ARRAY[$ARRAY_COUNT - 1] == "" )
	{
		--$ARRAY_COUNT;
	}
	$I = 0;
	for ( ;	$I < $ARRAY_COUNT;	++$I	)
	{
		$query = "select * from FIELDSETTING where TABLENAME='CUSTOMER' and FIELDNO='".$STYLE_ARRAY[$I]."' ORDER BY ORDERNO ASC  ";
		$cursor1 = exequery( $connection, $query );
		if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
		{
			$MESSAGE = "";
			$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";
			$query2 = "select ITEM_DATE from FIELD_DATE where TABLENAME='CUSTOMER' and FIELDNO='".$STYLE_ARRAY[$I]."' and IDENTY_ID='{$IDENTY_ID}'";
			$cursor2 = exequery( $connection, $query2 );
			if ( $ROW2 = mysql_fetch_array( $cursor2 ) )
			{
				$MESSAGE = $ROW2['ITEM_DATE'];
			}
			if ( $STYPE == "D" )
			{
				if ( $TYPECODE != "" )
				{
					$query2 = "select * from SYS_CODE where PARENT_NO='".$TYPECODE."' order by CODE_ORDER";
					$cursor2 = exequery( $connection, $query2 );
					while ( $ROW3 = mysql_fetch_array( $cursor2 ) )
					{
						$CODE_NO = $ROW3['CODE_NO'];
						$CODE_NAME = $ROW3['CODE_NAME'];
						$TYPEVALUE = $TYPEVALUE.$CODE_NO.",";
						$TYPENAME = $TYPENAME.$CODE_NAME.",";
					}
				}
				$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" )
			{
				if ( $TYPECODE != "" )
				{
					$query2 = "select * from SYS_CODE where PARENT_NO='".$TYPECODE."' order by CODE_ORDER";
					$cursor2 = exequery( $connection, $query2 );
					while ( $ROW3 = mysql_fetch_array( $cursor2 ) )
					{
						$CODE_NO = $ROW3['CODE_NO'];
						$CODE_NAME = $ROW3['CODE_NAME'];
						$TYPEVALUE = $TYPEVALUE.$CODE_NO.",";
						$TYPENAME = $TYPENAME.$CODE_NAME.",";
					}
				}
				$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" )
			{
				if ( $TYPECODE != "" )
				{
					$query2 = "select * from SYS_CODE where PARENT_NO='".$TYPECODE."' order by CODE_ORDER";
					$cursor2 = exequery( $connection, $query2 );
					while ( $ROW3 = mysql_fetch_array( $cursor2 ) )
					{
						$CODE_NO = $ROW3['CODE_NO'];
						$CODE_NAME = $ROW3['CODE_NAME'];
						$TYPEVALUE = $TYPEVALUE.$CODE_NO.",";
						$TYPENAME = $TYPENAME.$CODE_NAME.",";
					}
				}
				$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 ( ;	do
	{
	$I1 < $TYPENAME_COUNT;	++$I1	)
					{
						if ( $MESSAGE == $TYPEVALUE_ARRAY[$I1] )
						{
							$MESSAGE = $TYPENAME_ARRAY[$I1];
						}
						break;
					}
				} while ( 1 );
			}
		}
		else
		{
			$MESSAGE = $ROW[$STYLE_ARRAY[$I]];
		}
		$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;
?>