excel_data.php
来自「极限网络智能办公系统 - Office Automation 2008 官方10」· PHP 代码 · 共 213 行
PHP
213 行
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_html.php" );
$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'];
}
$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 );
}
ob_end_clean( );
header( "Cache-control: private" );
header( "Content-type: application/vnd.ms-excel" );
header( "Content-Disposition: attachment; filename= ".$EXCEL_NAME.".xls" );
echo "\r\n<html xmlns:o=\"urn:schemas-microsoft-com:office:office\"\r\nxmlns:x=\"urn:schemas-microsoft-com:office:excel\"\r\nxmlns=\"http://www.w3.org/TR/REC-html40\">\r\n<head>\r\n<title></title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n</head>\r\n<body topmargin=\"5\">\r\n\r\n <table border=\"1\" cellspacing=\"1\" width=\"95%\" class=\"small\" cellpadding=\"3\">\r\n <tr style=\"BACKGROUND: #D3E5FA; color: #000000; font-weight: bold;\">\r\n <td align=\"center\">名称/文号</td>\r\n <td align=\"center\">流程状态</td>\r\n <td align=\"center\">流程开始时间</td>\r\n";
$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'];
}
$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" );
$ECLASS = get_attr( $ELEMENT, "CLASS" );
if ( $ECLASS == "DATE" || $ECLASS == "USER" )
{
$ETITLE = str_replace( "<", "<", $ETITLE );
$ETITLE = str_replace( ">", ">", $ETITLE );
$ETITLE = stripslashes( $ETITLE );
echo " <td align=\"center\">";
echo $ETITLE;
echo "</td>\r\n";
}
}
echo " </tr>\r\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 )
{
echo " <tr>\r\n";
$query1 = "SELECT RUN_NAME from FLOW_RUN where RUN_ID='".$MY_ARRAY[$I]."'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$RUN_NAME = $ROW['RUN_NAME'];
}
echo " <td align=\"center\">";
echo $RUN_NAME;
echo "</td>\r\n";
$query1 = "SELECT 1 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 = "已结束";
}
echo " <td align=\"center\">";
echo $STATUS;
echo "</td>\r\n";
$PRCS_TIME = "";
$query1 = "SELECT PRCS_TIME 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 = "";
}
}
echo " <td align=\"center\">";
echo $PRCS_TIME;
echo "</td>\r\n";
$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'];
$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" || $ECLASS == "USER" )
{
++$ITEM_ID;
$STR = "DATA_".$ITEM_ID;
$ITEM_VALUE = $$STR;
if ( $ECLASS != "LIST_VIEW" )
{
$ITEM_VALUE = str_replace( "\r\n", " ", $ITEM_VALUE );
}
if ( $ECLASS == "AUTO" && $ENAME == "SELECT" && $ITEM_VALUE != "" )
{
$EDATAFLD = get_attr( $ELEMENT, "DATAFLD" );
switch ( $EDATAFLD )
{
case "SYS_LIST_DEPT" :
$query_auto = "SELECT DEPT_NAME 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 PRIV_NAME 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 USER_NAME 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" :
if ( $Tmp_0 )
{
break;
}
}
else if ( $ECLASS == "LIST_VIEW" )
{
$ITEM_VALUE = str_replace( "\r\n", "|", $ITEM_VALUE );
$ITEM_VALUE = str_replace( "`", ",", $ITEM_VALUE );
}
else
{
if ( $ECLASS == "SIGN" )
{
$ITEM_VALUE = "";
}
else
{
if ( $ECLASS == "AUTO" && $ITEM_VALUE == "{宏控件}" )
{
$ITEM_VALUE = "";
}
$ITEM_VALUE = str_replace( "<", "<", $ITEM_VALUE );
$ITEM_VALUE = str_replace( ">", ">", $ITEM_VALUE );
$ITEM_VALUE = stripslashes( $ITEM_VALUE );
if ( !( $ENAME == "INPUT" ) && !strstr( $ELEMENT, "type=checkbox" ) )
{
break;
}
if ( $ITEM_VALUE == "on" )
{
$ITEM_VALUE = "是";
}
else
{
$ITEM_VALUE = "否";
}
}
}
}
echo " <td>";
echo $ITEM_VALUE;
echo "</td>\r\n";
}
}
echo "</tr>";
}
echo "</table>";
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?