excel_report.php

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

<?php

include_once( "inc/auth.php" );
include_once( "inc/utility_html.php" );
$connection = openconnection( );
$query = "SELECT * from FLOW_TYPE WHERE FLOW_ID={$FLOW_ID}";
$cursor1 = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
	$FLOW_NAME = $ROW['FLOW_NAME'];
	$FORM_ID = $ROW['FORM_ID'];
}
$query = "SELECT * from FLOW_FORM_TYPE WHERE FORM_ID={$FORM_ID}";
$cursor1 = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
	$FORM_NAME = $ROW['FORM_NAME'];
	$PRINT_MODEL = $ROW['PRINT_MODEL'];
}
$EXCEL_NAME = "流程：".$FLOW_NAME." - 数据报表";
$LETTER_STR = "\\,/,:,*,?,\",<,>,|";
$MY_ARRAY = explode( ",", $LETTER_STR );
$ARRAY_COUNT = sizeof( $MY_ARRAY );
if ( $MY_ARRAY[$ARRAY_COUNT - 1] == "" )
{
	--$ARRAY_COUNT;
}
$I = 0;
for ( ;	$I < $ARRAY_COUNT;	++$I	)
{
	$EXCEL_NAME = str_replace( $MY_ARRAY[$I], "", $EXCEL_NAME );
}
$EXCEL_OUT = "文号/说明\t流程状态\t流程开始时间\t";
$ELEMENT_ARRAY = html_element( $PRINT_MODEL );
$ITEM_ID_MAX = sizeof( $ELEMENT_ARRAY );
$I = 0;
for ( ;	$I < $ITEM_ID_MAX;	++$I	)
{
	$ELEMENT = $ELEMENT_ARRAY[$I];
	$ETITLE = get_attr( $ELEMENT, "TITLE" );
	$ETITLE = str_replace( "<", "&lt", $ETITLE );
	$ETITLE = str_replace( ">", "&gt", $ETITLE );
	$ETITLE = stripslashes( $ETITLE );
	$EXCEL_OUT .= $ETITLE."\t";
}
$EXCEL_OUT .= "\n";
$MY_ARRAY = explode( ",", $RUN_ID_STR );
$ARRAY_COUNT = sizeof( $MY_ARRAY );
if ( $MY_ARRAY[$ARRAY_COUNT - 1] == "" )
{
	--$ARRAY_COUNT;
}
$I = 0;
for ( ;	$I < $ARRAY_COUNT;	++$I	)
{
	$query1 = "SELECT * from FLOW_RUN where RUN_ID={$MY_ARRAY[$I]}";
	$cursor1 = exequery( $connection, $query1 );
	if ( $ROW = mysql_fetch_array( $cursor1 ) )
	{
		$EXCEL_OUT .= $ROW['RUN_NAME']."\t";
	}
	$query1 = "SELECT * from FLOW_RUN_PRCS WHERE RUN_ID={$MY_ARRAY[$I]} AND PRCS_FLAG<>'4'";
	$cursor1 = exequery( $connection, $query1 );
	if ( $ROW = mysql_fetch_array( $cursor1 ) )
	{
		$STATUS = "执行中";
	}
	else
	{
		$STATUS = "已完成";
	}
	$EXCEL_OUT .= $STATUS."\t";
	$PRCS_TIME = "";
	$query1 = "SELECT * from FLOW_RUN_PRCS WHERE RUN_ID={$MY_ARRAY[$I]} AND PRCS_ID=1";
	$cursor1 = exequery( $connection, $query1 );
	if ( $ROW = mysql_fetch_array( $cursor1 ) )
	{
		$PRCS_TIME = $ROW['PRCS_TIME'];
		if ( $PRCS_TIME == "0000-00-00 00:00:00" )
		{
			$PRCS_TIME = "";
		}
		$EXCEL_OUT .= $PRCS_TIME."\t";
	}
	$query = "SELECT * from FLOW_RUN_DATA where RUN_ID={$MY_ARRAY[$I]} order by ITEM_ID";
	$cursor = exequery( $connection, $query );
	while ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$ITEM_ID = $ROW['ITEM_ID'];
		$ITEM_DATA = $ROW['ITEM_DATA'];
		$ITEM_DATA = str_replace( chr( 10 ), " ", $ITEM_DATA );
		$ITEM_DATA = str_replace( chr( 13 ), " ", $ITEM_DATA );
		$STR = "DATA_".$ITEM_ID;
		$$STR = $ITEM_DATA;
	}
	$ITEM_ID = 0;
	$J = 0;
	for ( ;	$J < $ITEM_ID_MAX;	++$J	)
	{
		$ELEMENT = $ELEMENT_ARRAY[$J];
		$ENAME = get_attr( $ELEMENT, "NAME" );
		$EVALUE = get_attr( $ELEMENT, "VALUE" );
		$ECLASS = get_attr( $ELEMENT, "CLASS" );
		if ( $ECLASS != "DATE" )
		{
			++$ITEM_ID;
		}
		$STR = "DATA_".$ITEM_ID;
		$ITEM_VALUE = $$STR;
		if ( $ECLASS == "DATE" )
		{
			$ITEM_VALUE = "";
		}
		else
		{
			if ( $ECLASS == "AUTO" && $ENAME == "SELECT" && $ITEM_VALUE != "" )
			{
				$EDATAFLD = get_attr( $ELEMENT, "DATAFLD" );
				switch ( $EDATAFLD )
				{
				case "SYS_LIST_DEPT" :
					$query_auto = "SELECT * from DEPARTMENT where DEPT_ID={$ITEM_VALUE}";
					$cursor_auto = exequery( $connection, $query_auto );
					if ( !( $ROW = mysql_fetch_array( $cursor_auto ) ) )
					{
						break;
					}
					$ITEM_VALUE = $ROW['DEPT_NAME'];
					break;
				case "SYS_LIST_PRIV" :
					$query_auto = "SELECT * from USER_PRIV where USER_PRIV={$ITEM_VALUE}";
					$cursor_auto = exequery( $connection, $query_auto );
					if ( !( $ROW = mysql_fetch_array( $cursor_auto ) ) )
					{
						break;
					}
					$ITEM_VALUE = $ROW['PRIV_NAME'];
					break;
				case "SYS_LIST_USER" :
				case "SYS_LIST_PRCSUSER1" :
				case "SYS_LIST_PRCSUSER2" :
					$query_auto = "SELECT * from USER where USER_ID='{$ITEM_VALUE}'";
					$cursor_auto = exequery( $connection, $query_auto );
					if ( !( $ROW = mysql_fetch_array( $cursor_auto ) ) )
					{
						break;
					}
					$ITEM_VALUE = $ROW['USER_NAME'];
					break;
				case "SYS_LIST_SQL" :
				}
			}
			else
			{
				if ( $ECLASS == "AUTO" && $ITEM_VALUE == "{宏控件}" )
				{
					$ITEM_VALUE = "";
				}
				$ITEM_VALUE = str_replace( "<", "&lt", $ITEM_VALUE );
				$ITEM_VALUE = str_replace( ">", "&gt", $ITEM_VALUE );
				$ITEM_VALUE = stripslashes( $ITEM_VALUE );
				$ITEM_VALUE = str_replace( chr( 10 ), "<br>", $ITEM_VALUE );
				if ( $ENAME == "INPUT" && strstr( $ELEMENT, "type=checkbox" ) )
				{
					if ( $ITEM_VALUE == "on" )
					{
						$ITEM_VALUE = "是";
					}
					else
					{
						$ITEM_VALUE = "否";
					}
				}
			}
		}
		$EXCEL_OUT .= $ITEM_VALUE."\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= {$EXCEL_NAME}.xls" );
echo $EXCEL_OUT;
?>