word_report.php

极限网络智能办公系统—MYOA26—100％—源程序。

<?php

include_once( "../auth1.php" );
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
include_once( "inc/check_type.php" );
$connection = openconnection( );
$query = "SELECT * from IK_APP where APP_ID={$APP_ID}";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$APP_FLD_CTRL = $ROW['APP_FLD_CTRL'];
	$APP_DESC = $ROW['APP_DESC'];
	$EDIT_APP_ID = $ROW['EDIT_APP_ID'];
}
$query = "SELECT * from IK_TABLE where TABLE_ID={$TABLE_ID}";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$TABLE_NAME = $ROW['TABLE_NAME'];
}
$query = "SELECT * from IK_FIELD where TABLE_ID={$TABLE_ID} and FIELD_INDEX='1'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$FIELD_INDEX_NAME = $ROW['FIELD_NAME'];
}
$query = "SELECT * from {$TABLE_NAME} ";
$FIELD_NAME_ARRAY = explode( ",", $FIELD_NAME_STR );
$ARRAY_COUNT = sizeof( $FIELD_NAME_ARRAY );
if ( $FIELD_NAME_ARRAY[$ARRAY_COUNT - 1] == "" )
{
	--$ARRAY_COUNT;
}
$I = 0;
for ( ;	$I < $ARRAY_COUNT;	++$I	)
{
	$STR = $FIELD_NAME_ARRAY[$I];
	$FIELDVALUE = $$STR;
	$FIELD_NAME = $STR;
	if ( $FIELDVALUE == "CHECKBOX_ON" )
	{
		$FIELDVALUE = "1";
	}
	else if ( $FIELDVALUE == "CHECKBOX_OFF" )
	{
		$FIELDVALUE = "0";
	}
	$STR = $FIELD_NAME."_ORDER_CHECK";
	if ( $$STR == "on" )
	{
		$ORDER_CHECK_STR .= ",".$FIELD_NAME;
		$STR = $FIELD_NAME."_REV_CHECK";
		if ( $$STR == "on" )
		{
			$ORDER_CHECK_STR .= " desc";
		}
	}
	$STR = $FIELD_NAME."_LIST_CHECK";
	if ( $$STR == "on" )
	{
		$LIST_CHECK_STR .= $FIELD_NAME.",";
	}
	$STR = $FIELD_NAME."_REPORT_CHECK";
	if ( $$STR == "on" )
	{
		$REPORT_CHECK_STR .= $FIELD_NAME.",";
	}
	$STR = $FIELD_NAME."_RELATION";
	$RELATION = $$STR;
	if ( $FIELDVALUE != "" && $FIELDVALUE != "SELECT_ALL_VALUE" || $RELATION == "" )
	{
		$WHERE_STR .= " and {$FIELD_NAME}";
		switch ( $RELATION )
		{
		case 1 :
			$WHERE_STR .= "='".$FIELDVALUE."'";
			break;
		case 2 :
			$WHERE_STR .= ">'".$FIELDVALUE."'";
			break;
		case 3 :
			$WHERE_STR .= "<'".$FIELDVALUE."'";
			break;
		case 4 :
			$WHERE_STR .= ">='".$FIELDVALUE."'";
			break;
		case 5 :
			$WHERE_STR .= "<='".$FIELDVALUE."'";
			break;
		case 6 :
			$WHERE_STR .= "!='".$FIELDVALUE."'";
			break;
		case 7 :
			$WHERE_STR .= " like '".$FIELDVALUE."%'";
			break;
		case 8 :
			$WHERE_STR .= " like '%".$FIELDVALUE."%'";
			break;
		case 9 :
			$WHERE_STR .= " like '%".$FIELDVALUE."'";
			break;
		case "" :
			$STR = $FIELD_NAME."_TIME1";
			$FIELDVALUE1 = $$STR;
			$STR = $FIELD_NAME."_TIME2";
			$FIELDVALUE2 = $$STR;
			if ( $FIELDVALUE1 != "" )
			{
				if ( !is_date( $FIELDVALUE1 ) )
				{
					message( "错误", "日期格式错误 - [{$FIELDVALUE1}]" );
					exit( );
				}
				$WHERE_STR .= ">='{$FIELDVALUE1}'";
			}
			if ( !( $FIELDVALUE2 != "" ) )
			{
				break;
			}
			if ( !is_date( $FIELDVALUE2 ) )
			{
				message( "错误", "日期格式错误 - [{$FIELDVALUE2}]" );
				exit( );
			}
			if ( $FIELDVALUE1 != "" )
			{
				$WHERE_STR .= " and {$FIELD_NAME}";
			}
			$WHERE_STR .= "<='{$FIELDVALUE2} 23:59:59'";
		}
	}
}
if ( $LIST_CHECK_STR == "" )
{
	message( "提示", "至少选择一个列表项" );
	exit( );
}
if ( $WHERE_STR != "" )
{
	$WHERE_STR = substr( $WHERE_STR, 4 );
	$query .= " where ".$WHERE_STR;
}
if ( $ORDER_CHECK_STR != "" )
{
	$ORDER_CHECK_STR = substr( $ORDER_CHECK_STR, 1 );
	$query .= " order by ".$ORDER_CHECK_STR;
}
$cursor = exequery( $connection, $query );
$NUM_FIELDS = mysql_num_fields( $cursor );
$DATA_COUNT = 0;
while ( $ROW1 = mysql_fetch_array( $cursor ) )
{
	++$DATA_COUNT;
	if ( $DATA_COUNT == 1 )
	{
		$WORD_OUT .= "<table border=1 cellspacing=0 cellpadding=0 style='border-collapse:collapse;border:none;mso-border-alt:solid'><tr bgcolor=#EEEEEE>";
		$I = 0;
		for ( ;	$I < $NUM_FIELDS;	++$I	)
		{
			$FIELD_NAME = mysql_field_name( $cursor, $I );
			if ( find_id( $LIST_CHECK_STR, $FIELD_NAME ) )
			{
				$query = "SELECT * from IK_FIELD where FIELD_NAME='{$FIELD_NAME}' and TABLE_ID={$TABLE_ID}";
				$cursor1 = exequery( $connection, $query );
				if ( $ROW = mysql_fetch_array( $cursor1 ) )
				{
					$FIELD_DESC = $ROW['FIELD_DESC'];
				}
				$WORD_OUT .= "<td nowrap align=\"center\" style='border:solid windowtext .5pt;padding:0.1cm 5.4pt 0.1cm 5.4pt'><b>{$FIELD_DESC}</b></td>";
			}
		}
		$WORD_OUT .= "</tr>";
	}
	$WORD_OUT .= "<tr>";
	$I = 0;
	for ( ;	$I < $NUM_FIELDS;	++$I	)
	{
		$FIELD_VALUE = $ROW1[$I];
		$FIELD_NAME = mysql_field_name( $cursor, $I );
		$$FIELD_NAME = $FIELD_VALUE;
		if ( find_id( $LIST_CHECK_STR, $FIELD_NAME ) )
		{
			$query = "SELECT * from IK_FIELD where FIELD_NAME='{$FIELD_NAME}' and TABLE_ID={$TABLE_ID}";
			$cursor1 = exequery( $connection, $query );
			if ( $ROW = mysql_fetch_array( $cursor1 ) )
			{
				$FIELD_TYPE = $ROW['FIELD_TYPE'];
				$FIELD_AUTOVALUE = $ROW['FIELD_AUTOVALUE'];
				$FIELD_CODE_FIX = $ROW['FIELD_CODE_FIX'];
				$FIELD_CODE_SQL = $ROW['FIELD_CODE_SQL'];
				$FIELD_INTERFACE_TYPE = $ROW['FIELD_INTERFACE_TYPE'];
			}
			if ( $FIELD_INTERFACE_TYPE == 5 )
			{
				if ( $FIELD_VALUE == "0" )
				{
					$FIELD_VALUE = "否";
				}
				else if ( $FIELD_VALUE == "1" )
				{
					$FIELD_VALUE = "是";
				}
			}
			if ( $FIELD_AUTOVALUE == "D" )
			{
				$FIELD_VALUE = substr( $FIELD_VALUE, 0, 10 );
			}
			else if ( $FIELD_AUTOVALUE == "T" )
			{
				$FIELD_VALUE = substr( $FIELD_VALUE, 11 );
			}
			if ( $FIELD_CODE_SQL != "" )
			{
				$POS1 = strpos( $FIELD_CODE_SQL, " " ) + 1;
				$POS2 = strpos( $FIELD_CODE_SQL, "," );
				$FIELD = substr( $FIELD_CODE_SQL, $POS1, $POS2 - $POS1 );
				$FIELD_CODE_SQL .= " where {$FIELD}='{$FIELD_VALUE}'";
				$cursor1 = exequery( $connection, $FIELD_CODE_SQL );
				if ( $ROW = mysql_fetch_array( $cursor1 ) )
				{
					$FIELD_VALUE = $ROW[1];
				}
			}
			else if ( $FIELD_CODE_FIX != "" )
			{
				$OPTION_ARRAY = explode( ",", $FIELD_CODE_FIX );
				$FIELD_VALUE = $OPTION_ARRAY[$FIELD_VALUE];
			}
			$WORD_OUT .= "<td align=\"center\" style='border:solid windowtext .5pt;padding:0.1cm 5.4pt 0.1cm 5.4pt'>{$FIELD_VALUE}</td>";
			if ( !( $REPORT_CHECK_STR != "" && $FIELD_INTERFACE_TYPE <= 2 && $FIELD_TYPE != "D" ) && !find_id( $REPORT_CHECK_STR, $FIELD_NAME ) )
			{
				$STR = $FIELD_NAME."_REPORT_COUNT";
				$$STR += $FIELD_VALUE;
			}
		}
	}
	$WORD_OUT .= "</tr>";
}
if ( 0 < $DATA_COUNT )
{
	if ( $REPORT_CHECK_STR != "" )
	{
		$WORD_OUT .= "<tr bgcolor=#EEEEEE>";
		$I = 0;
		for ( ;	$I < $NUM_FIELDS;	++$I	)
		{
			$FIELD_NAME = mysql_field_name( $cursor, $I );
			if ( find_id( $LIST_CHECK_STR, $FIELD_NAME ) )
			{
				$REPORT_COUNT = "";
				if ( find_id( $REPORT_CHECK_STR, $FIELD_NAME ) )
				{
					$STR = $FIELD_NAME."_REPORT_COUNT";
					$REPORT_COUNT .= $$STR;
				}
				$WORD_OUT .= "<td align=\"center\" style='border:solid windowtext .5pt;padding:0.1cm 5.4pt 0.1cm 5.4pt'>{$REPORT_COUNT}</td>";
			}
		}
		$WORD_OUT .= "</tr>";
	}
	$WORD_OUT .= "</table>";
}
else
{
	message( "", "无符合条件的记录" );
	exit( );
}
$WORD_NAME = $APP_DESC." - 报表";
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;
echo "\r\n";
?>