📄 excel_data.php
字号:
<?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 \t<td align=\"center\">流水号</td>\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" ) )
{
if ( $ECLASS == "USER" )
{
break;
}
}
else
{
continue;
}
$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";
$query = "select HIDDEN_ITEM from FLOW_PROCESS,FLOW_RUN_PRCS where FLOW_PROCESS.FLOW_ID=".$FLOW_ID." and FLOW_RUN_PRCS.RUN_ID={$MY_ARRAY[$I]} and FLOW_RUN_PRCS.USER_ID='{$LOGIN_USER_ID}' and FLOW_PROCESS.PRCS_ID=FLOW_RUN_PRCS.FLOW_PRCS";
$cursor = exequery( $connection, $query );
$HIDDEN_STR = "";
while ( $ROW = mysql_fetch_array( $cursor ) )
{
if ( $ROW['HIDDEN_ITEM'] )
{
$HIDDEN_STR .= $ROW['HIDDEN_ITEM'];
}
}
$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 $MY_ARRAY[$I];
echo "</td>\r\n <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";
$DATA = array( );
$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'];
$DATA[$ITEM_ID] = $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" );
$ETITLE = get_attr( $ELEMENT, "TITLE" );
if ( !( $ECLASS == "DATE" ) )
{
if ( $ECLASS == "USER" )
{
break;
}
}
else
{
continue;
}
++$ITEM_ID;
if ( find_id( $HIDDEN_STR, $ETITLE ) )
{
$ITEM_VALUE = "";
}
else
{
$ITEM_VALUE = $DATA[$ITEM_ID];
}
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" :
}
else if ( $ECLASS == "LIST_VIEW" )
{
if ( !( $ITEM_VALUE != "" ) )
{
break;
}
$LV_TITLE = get_attr( $ELEMENT, "LV_TITLE" );
$LV_SIZE = get_attr( $ELEMENT, "LV_SIZE" );
$MY_ARRAY_SIZE = explode( "`", $LV_SIZE );
$LV_VALUE = $ITEM_VALUE;
$ITEM_VALUE = "<TABLE class='small' style='border-collapse:collapse' border=1 cellspacing=0 cellpadding=2 bordercolor='#000000'><TR class=TableHeader>\n";
$LV_ARRAY = explode( "`", $LV_TITLE );
$ARRAY_COUNT_TITLE = sizeof( $LV_ARRAY );
if ( $LV_ARRAY[$ARRAY_COUNT_TITLE - 1] == "" )
{
--$ARRAY_COUNT_TITLE;
}
$K = 0;
for ( ; $K < $ARRAY_COUNT_TITLE; ++$K )
{
$ITEM_VALUE .= "<TD nowrap>".$LV_ARRAY[$K]."</TD>\n";
}
$ITEM_VALUE .= "</TR>\n";
$LV_ARRAY = explode( "\r\n", $LV_VALUE );
$LV_ARRAY_COUNT = sizeof( $LV_ARRAY );
if ( $LV_ARRAY[$LV_ARRAY_COUNT - 1] == "" )
{
--$LV_ARRAY_COUNT;
}
$K = 0;
for ( ; $K < $LV_ARRAY_COUNT; ++$K )
{
$ITEM_VALUE .= "<tr>\n";
$TR_DATA = $LV_ARRAY[$K];
$LV_ARRAY1 = explode( "`", $TR_DATA );
$L = 0;
for ( ; $L < $ARRAY_COUNT_TITLE; ++$L )
{
$TD_DATA = $LV_ARRAY1[$L];
if ( $TD_DATA == "" )
{
$TD_DATA = " ";
}
$ITEM_VALUE .= ( "<td width=".$LV_ARRAY_SIZE[$L] * 9 ).">".$TD_DATA."</td>\n";
}
$ITEM_VALUE .= "</tr>\n";
}
$ITEM_VALUE .= "</TABLE>\n";
}
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 + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -