word_report.php

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

<?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 ( $LINKMAN_NAME != "" )
{
	$WHERE_STR .= " and a.LINKMAN_NAME like '%".$LINKMAN_NAME."%'";
}
if ( $POST_PRIV != "" )
{
	$WHERE_STR .= " and a.POST_PRIV like '%".$POST_PRIV."%'";
}
if ( $HOBBY != "" )
{
	$WHERE_STR .= " and a.HOBBY like '%".$HOBBY."%'";
}
if ( $SEX != "" )
{
	$WHERE_STR .= " and a.SEX='".$SEX."'";
}
if ( $BIRTHDAY != "" )
{
	$WHERE_STR .= " and a.BIRTHDAY ='".$BIRTHDAY."'";
}
$query = "SELECT FIELDNO from FIELDSETTING where TABLENAME='LINKMAN'";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$FIELDNO = "LINKMAN".$ROW['FIELDNO'];
	if ( $$FIELDNO != "" )
	{
		$LINKMANID_STR = "";
		$urlstr = $urlstr."&".$FIELDNO."=".$$FIELDNO;
		$WHERE_STR1 = " where TABLENAME='LINKMAN' 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 ) )
		{
			$LINKMANID_STR = $LINKMANID_STR.$ROW1['IDENTY_ID'].",";
		}
		$LINKMANID_STR = "'".str_replace( ",", "','", substr( $LINKMANID_STR, 0, -1 ) )."'";
		$WHERE_STR .= " and a.LINKMAN_ID in (".$LINKMANID_STR.")";
	}
}
$query = "SELECT a.LINKMAN_ID as LINKMAN_ID,b.CUSTOMER_ID as CUSTOMER_ID,CREATE_DATE,b.CUSTOMER_CODE as CUSTOMER_CODE,LINKMAN_NAME,SEX,BIRTHDAY,POST_PRIV,HOBBY,ADD_HOME,POSTALCODE_HOME,a.TEL_NO_WORK,a.TEL_NO_HOME,a.MOBILE,a.EMAIL as EMAIL,a.OICQ,a.ICQ,a.MEMO,a.MEMO1,a.CREATE_DATE,a.USERDEF1,a.USERDEF2,a.USERDEF3,a.USERDEF4,a.USERDEF5,b.CUSTOMER_NAME  FROM `LINKMAN` a LEFT OUTER JOIN CUSTOMER b ON a.`CUSTOMER_ID` = b.`CUSTOMER_ID` where a.SELLER='".$LOGIN_USER_ID."' ".$WHERE_STR;
echo $query;
$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['LINKMAN_ID'];
	$COUNT = 0;
	if ( $STYLE_ARRAY[$ARRAY_COUNT - 1] == "" )
	{
		--$ARRAY_COUNT;
	}
	$I = 0;
	for ( ;	$I < $ARRAY_COUNT;	++$I	)
	{
		$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 ) )
		{
			$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='LINKMAN' 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 ( $ROW = mysql_fetch_array( $cursor2 ) )
					{
						$CODE_NO = $ROW['CODE_NO'];
						$CODE_NAME = $ROW['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 ( $ROW = mysql_fetch_array( $cursor2 ) )
					{
						$CODE_NO = $ROW['CODE_NO'];
						$CODE_NAME = $ROW['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 ( $ROW = mysql_fetch_array( $cursor2 ) )
					{
						$CODE_NO = $ROW['CODE_NO'];
						$CODE_NAME = $ROW['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;
?>