excel_data.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 252 行
PHP
252 行
<?
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;
}
for ($I = 0; ($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 '
<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body topmargin="5">
<table border="1" cellspacing="1" width="95%" class="small" cellpadding="3">
<tr style="BACKGROUND: #D3E5FA; color: #000000;';
echo ' font-weight: bold;">
<td align="center">名称/文号</td>
<td align="center">流程状态</td>
<td align="center">流程开始时间</td>
';
$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);
for ($I = 0; ($I < $ITEM_ID_MAX); ++$I)
{
$ELEMENT = $ELEMENT_ARRAY[$I];
$ETITLE = get_attr ($ELEMENT, 'TITLE');
$ECLASS = get_attr ($ELEMENT, 'CLASS');
if ((($ECLASS == 'DATE') OR ($ECLASS == 'USER')))
{
continue;
}
else
{
$ETITLE = str_replace ('<', '<', $ETITLE);
$ETITLE = str_replace ('>', '>', $ETITLE);
$ETITLE = stripslashes ($ETITLE);
echo ' <td align="center">';
echo $ETITLE;
echo '</td>
';
continue;
}
}
echo ' </tr>
';
$MY_ARRAY = explode (',', $RUN_ID_STR);
$ARRAY_COUNT = sizeof ($MY_ARRAY);
if (($MY_ARRAY[($ARRAY_COUNT - 1)] == ''))
{
--$ARRAY_COUNT;
}
for ($I = 0; ($I < $ARRAY_COUNT); ++$I)
{
echo ' <tr>
';
$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>
';
$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>
';
$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>
';
$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;
for ($J = 0; ($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') OR ($ECLASS == 'USER')))
{
continue;
}
else
{
++$ITEM_ID;
$STR = ('DATA_'.$ITEM_ID);
$ITEM_VALUE = $$STR;
if (($ECLASS != 'LIST_VIEW'))
{
$ITEM_VALUE = str_replace ('
', ' ', $ITEM_VALUE);
}
if (((($ECLASS == 'AUTO') AND ($ENAME == 'SELECT')) AND ($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))
{
$ITEM_VALUE = $ROW['DEPT_NAME'];
break;
}
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))
{
$ITEM_VALUE = $ROW['PRIV_NAME'];
break;
}
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))
{
$ITEM_VALUE = $ROW['USER_NAME'];
break;
}
break;
}
case 'SYS_LIST_SQL':
{
break;
}
}
}
else
{
if (($ECLASS == 'LIST_VIEW'))
{
$ITEM_VALUE = str_replace ('
', '|', $ITEM_VALUE);
$ITEM_VALUE = str_replace ('`', ',', $ITEM_VALUE);
}
else
{
if (($ECLASS == 'SIGN'))
{
$ITEM_VALUE = '';
}
else
{
if ((($ECLASS == 'AUTO') AND ($ITEM_VALUE == '{宏控件}')))
{
$ITEM_VALUE = '';
}
$ITEM_VALUE = str_replace ('<', '<', $ITEM_VALUE);
$ITEM_VALUE = str_replace ('>', '>', $ITEM_VALUE);
$ITEM_VALUE = stripslashes ($ITEM_VALUE);
if ((($ENAME == 'INPUT') AND strstr ($ELEMENT, 'type=checkbox')))
{
if (($ITEM_VALUE == 'on'))
{
$ITEM_VALUE = '是';
}
else
{
$ITEM_VALUE = '否';
}
}
}
}
}
echo ' <td>';
echo $ITEM_VALUE;
echo '</td>
';
continue;
}
}
echo '</tr>';
}
echo '</table>';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?