📄 run_log.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
include_once( "../../prcs_role.php" );
echo "<html>\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 class=\"bodycolor\" topmargin=\"5\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/menu/workflow.gif\" align=\"absmiddle\"><span class=\"big3\"> 流程日志</span> \r\n </td>\r\n </tr>\r\n</table>\r\n";
$query = "SELECT * from FLOW_TYPE where FLOW_ID=".$FLOW_ID;
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$FLOW_TYPE = $ROW['FLOW_TYPE'];
}
$LOG_COUNT = 0;
$query = "select * FROM FLOW_RUN_LOG WHERE RUN_ID='".$RUN_ID."' ORDER BY PRCS_ID,FLOW_PRCS";
$cursor = exequery( $connection, $query );
$ROWSPAN = mysql_num_rows( $cursor );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$LOG_COUNT;
$LOG_USER_ID = $ROW['USER_ID'];
$LOG_PRCS_ID = $ROW['PRCS_ID'];
$LOG_CONTENT = $ROW['CONTENT'];
$LOG_TIME = $ROW['TIME'];
$PRCS_NAME = "-";
if ( $FLOW_TYPE == 1 && $LOG_FLOW_PRCS != $ROW['FLOW_PRCS'] )
{
$LOG_FLOW_PRCS = $ROW['FLOW_PRCS'];
$query1 = "select PRCS_NAME FROM FLOW_PROCESS WHERE FLOW_ID='".$FLOW_ID."' AND PRCS_ID={$LOG_FLOW_PRCS}";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
{
$PRCS_NAME = $ROW1['PRCS_NAME'];
}
}
$query1 = "select USER_NAME FROM USER WHERE USER_ID='".$LOG_USER_ID."'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
{
$LOG_USER_NAME = $ROW1[0];
}
if ( $LOG_COUNT == 1 )
{
echo "<table class=\"TableList\" width=\"100%\" border=0>\r\n <thead class=\"TableHeader\">\r\n <td nowrap align=\"center\">步骤序号</td>\r\n";
if ( $FLOW_TYPE == 1 )
{
echo "<td nowrap align=\"center\">步骤名称</td>";
}
echo " <td nowrap align=\"center\">相关人员</td>\r\n <td nowrap align=\"center\">发生时间</td>\r\n <td nowrap align=\"center\">内容</td>\r\n </thead>\r\n";
}
if ( $LOG_COUNT % 2 == 0 )
{
$TableLine = "TableLine1";
}
else
{
$TableLine = "TableLine2";
}
echo " <tr class=\"";
echo $TableLine;
echo "\">\r\n \t<td nowrap align=\"center\">";
echo $LOG_PRCS_ID == 0 ? "-" : $LOG_PRCS_ID;
echo "</td>\r\n";
if ( $FLOW_TYPE == 1 )
{
echo "<td nowrap align=\"center\">".$PRCS_NAME."</td>";
}
echo " \t<td nowrap align=\"center\">";
echo $LOG_USER_NAME;
echo "</td>\r\n \t<td nowrap align=\"center\">";
echo $LOG_TIME;
echo "</td>\r\n \t<td >";
echo $LOG_CONTENT;
echo "</td>\r\n </tr>\r\n";
}
if ( 0 < $LOG_COUNT )
{
echo "</table>";
}
else
{
message( "", "无流程日志!" );
}
echo "</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -