flow_view.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 312 行
PHP
312 行
<?
include_once 'inc/auth.php';
include_once 'inc/utility_all.php';
include_once '../prcs_role.php';
if (!run_role ($RUN_ID, 0))
{
exit ();
}
$query = ((''.'SELECT * from FLOW_TYPE where FLOW_ID=').$FLOW_ID);
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$FLOW_NAME = $ROW['FLOW_NAME'];
$FLOW_TYPE = $ROW['FLOW_TYPE'];
}
$query = ((''.'SELECT * from FLOW_RUN WHERE RUN_ID=').$RUN_ID);
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$RUN_NAME = $ROW['RUN_NAME'];
}
$TITLE = ((('流程图 - '.$FLOW_NAME).' - ').$RUN_NAME);
if (($PRINT_FLAG != 1))
{
echo '
<html>
<head>
<title>';
echo $TITLE;
echo '</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
echo '<s';
echo 'cript>
focus();
</script>
</head>
<body class="bodycolor" topmargin="5">
';
}
echo '
<table style=\'border-collapse:collapse\' border=1 cellspacing=0 cellpadding=3 bordercolor=\'#000000\' width="100%" class="small">
';
if ($PRINT_FLAG)
{
echo ' <tr>
<td nowrap colspan="3" class="TableHeader"><b>流程图</b></td>
</tr>
';
}
$query = ((''.'SELECT MAX(PRCS_ID) from FLOW_RUN_PRCS where RUN_ID=').$RUN_ID);
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$PRCS_ID = $ROW[0];
}
for ($PRCS_ID_I = 1; ($PRCS_ID_I <= $PRCS_ID); ++$PRCS_ID_I)
{
$query = (((((''.'SELECT * from FLOW_RUN_PRCS where RUN_ID=').$RUN_ID).' and PRCS_ID=').$PRCS_ID_I).' order by PRCS_FLAG desc,PRCS_TIME');
$cursor = exequery ($connection, $query);
$PRCS_FLAG_DESC = '';
while ($ROW = mysql_fetch_array ($cursor))
{
$PRCS_USER = $ROW['USER_ID'];
$PRCS_TIME = $ROW['PRCS_TIME'];
$DELIVER_TIME = $ROW['DELIVER_TIME'];
$PRCS_FLAG = $ROW['PRCS_FLAG'];
$FLOW_PRCS = $ROW['FLOW_PRCS'];
$OP_FLAG = $ROW['OP_FLAG'];
$PRCS_USER_NAME = '';
$query1 = (((''.'SELECT USER_NAME,DEPT_ID from USER where USER_ID=\'').$PRCS_USER).'\'');
$cursor1 = exequery ($connection, $query1);
if ($ROW = mysql_fetch_array ($cursor1))
{
$PRCS_USER_NAME = $ROW['USER_NAME'];
$DEPT_ID = $ROW['DEPT_ID'];
$DEPT_NAME = dept_long_name ($DEPT_ID);
}
else
{
$PRCS_USER_NAME = $PRCS_USER;
}
$query = (((((((''.'SELECT CONTENT,EDIT_TIME from FLOW_RUN_FEEDBACK where RUN_ID=').$RUN_ID).' and PRCS_ID=').$PRCS_ID_I).' and USER_ID=\'').$LOGIN_USER_ID).'\' order by EDIT_TIME');
$cursor1 = exequery ($connection, $query);
$FEED_CONTENT = '';
while ($ROW = mysql_fetch_array ($cursor1))
{
if (($FEED_CONTENT == ''))
{
$FEED_CONTENT = '
会签意见：
';
}
($FEED_CONTENT .= ((($ROW['CONTENT'].' ').$ROW['EDIT_TIME']).'
'));
}
if (($OP_FLAG == 1))
{
$PRCS_USER_NAME = (((((((''.'<span class=\'big4\'><u title=\'主办人，部门：').$DEPT_NAME).' ').$FEED_CONTENT).'\' style=\'cursor:hand\'><b>').$PRCS_USER_NAME).' 主办</b></u></span>');
}
else
{
$PRCS_USER_NAME = (((((''.'<u title=\'部门：').$DEPT_NAME).'\' style=\'cursor:hand\'><b>').$PRCS_USER_NAME).'</b></u>');
}
if (($FLOW_TYPE == 1))
{
$query1 = ((((''.'SELECT PRCS_NAME,TIME_OUT from FLOW_PROCESS WHERE FLOW_ID=').$FLOW_ID).' AND PRCS_ID=').$FLOW_PRCS);
$cursor1 = exequery ($connection, $query1);
if ($ROW = mysql_fetch_array ($cursor1))
{
$PRCS_NAME = $ROW['PRCS_NAME'];
$TIME_OUT = $ROW['TIME_OUT'];
}
else
{
$PRCS_NAME = '<font color=red>流程步骤已删除</font>';
}
}
if (($PRCS_FLAG == 1))
{
$TIME_USED = 0;
}
else
{
if (($PRCS_FLAG == 2))
{
$TIME_USED = (time () - strtotime ($PRCS_TIME));
}
else
{
$TIME_USED = (strtotime ($DELIVER_TIME) - strtotime ($PRCS_TIME));
if (($DELIVER_TIME == ''))
{
$TIME_USED = 0;
}
}
}
if (($PRCS_TIME == ''))
{
$TIME_USED = 0;
}
$DAY = floor (($TIME_USED / 86400));
$HOUR = floor ((($TIME_USED % 86400) / 3600));
$MIN = floor ((($TIME_USED % 3600) / 60));
$SEC = floor (($TIME_USED % 60));
$TIME_STR = '';
if ((0 < $DAY))
{
($TIME_STR .= ($DAY.'天'));
}
if ((0 < $HOUR))
{
($TIME_STR .= ($HOUR.'时'));
}
if ((0 < $MIN))
{
($TIME_STR .= ($MIN.'分'));
}
if ((0 < $SEC))
{
($TIME_STR .= ($SEC.'秒'));
}
$TIME_OUT_FLAG = 0;
if (((($PRCS_FLAG == '2') AND ($PRCS_TIME != '')) AND ($TIME_OUT != '')))
{
if ((($TIME_OUT * 3600) < $TIME_USED))
{
$TIME_OUT_FLAG = 1;
$TIME_USED = ($TIME_USED - ($TIME_OUT * 3600));
$DAY = floor (($TIME_USED / 86400));
$HOUR = floor ((($TIME_USED % 86400) / 3600));
$MIN = floor ((($TIME_USED % 3600) / 60));
$SEC = floor (($TIME_USED % 60));
$TIME_USED = '';
if ((0 < $DAY))
{
($TIME_USED .= ($DAY.'天'));
}
if ((0 < $HOUR))
{
($TIME_USED .= ($HOUR.'时'));
}
if ((0 < $MIN))
{
($TIME_USED .= ($MIN.'分'));
}
if ((0 < $SEC))
{
($TIME_USED .= ($SEC.'秒'));
}
}
}
if (($PRCS_FLAG == 1))
{
($PRCS_FLAG_DESC .= (('<img src=\'/images/email_close.gif\' alt=\'未接收办理\' align=\'absmiddle\'> '.$PRCS_USER_NAME).' [<font color=green>未接收办理</font>]'));
}
else
{
if (($PRCS_FLAG == 2))
{
($PRCS_FLAG_DESC .= (('<img src=\'/images/email_open.gif\' alt=\'办理中\' align=\'absmiddle\'> '.$PRCS_USER_NAME).' [<font color=green>办理中 已用时：'));
($PRCS_FLAG_DESC .= ($TIME_STR.'</font>]'));
if ($TIME_OUT_FLAG)
{
($PRCS_FLAG_DESC .= (((('<br>     <font color=red>限时'.$TIME_OUT).'小时,超时').$TIME_USED).'</font>'));
}
($PRCS_FLAG_DESC .= ((''.'<br>     开始于：').$PRCS_TIME));
}
else
{
if (($PRCS_FLAG == 3))
{
($PRCS_FLAG_DESC .= (('<img src=\'/images/flow_next.gif\' alt=\'已转交下步\' align=\'absmiddle\'> '.$PRCS_USER_NAME).' [<font color=green>已转交下步 用时：'));
($PRCS_FLAG_DESC .= ($TIME_STR.'</font>]'));
($PRCS_FLAG_DESC .= ((''.'<br>     开始于：').$PRCS_TIME));
if (($DELIVER_TIME != 'NULL'))
{
($PRCS_FLAG_DESC .= ((''.'<br>     结束于：').$DELIVER_TIME));
}
}
else
{
if (($PRCS_FLAG == 4))
{
($PRCS_FLAG_DESC .= (('<img src=\'/images/flow_next.gif\' alt=\'已办结\' align=\'absmiddle\'> '.$PRCS_USER_NAME).' [<font color=green>已办结 用时：'));
($PRCS_FLAG_DESC .= ($TIME_STR.'</font>]'));
($PRCS_FLAG_DESC .= ((''.'<br>     开始于：').$PRCS_TIME));
if (($DELIVER_TIME != 'NULL'))
{
($PRCS_FLAG_DESC .= ((''.'<br>     结束于：').$DELIVER_TIME));
}
}
}
}
}
($PRCS_FLAG_DESC .= '<br>');
}
if ($WORD)
{
$PRCS_FLAG_DESC = str_replace ('<img ', '<span ', $PRCS_FLAG_DESC);
}
if ((($PRCS_ID_I == 1) AND !$PRINT_FLAG))
{
echo ' <tr class="TableLine2">
<td nowrap align="center" colspan="3" height=30 class="TableHeader">
<b>流程开始</b><br>
</td>
</tr>
';
}
if (($PRCS_FLAG_DESC == ''))
{
$PRCS_FLAG_DESC = ' ';
}
if (($PRCS_ID_I == $PRCS_ID))
{
$CLASS = 'TableContent';
}
else
{
$CLASS = 'TableLine1';
}
echo ' <tr class="';
echo $CLASS;
echo '">
<td nowrap align="center">第<b>';
echo '<s';
echo 'pan class="Big4">';
echo $PRCS_ID_I;
echo '</span></b>步</td>
';
if (($FLOW_TYPE == 1))
{
echo ' <td>';
if (!$WORD)
{
echo '<img border=0 src="/images/arrow_down.gif">';
}
echo ' 序号';
echo $FLOW_PRCS;
echo '：';
echo $PRCS_NAME;
echo '</td>
';
}
echo ' <td>';
echo $PRCS_FLAG_DESC;
echo '</td>
</tr>
';
}
if ((($PRCS_FLAG == 4) AND !$PRINT_FLAG))
{
echo ' <tr>
<td nowrap align="center" colspan="3" class="TableHeader" height=30><b>流程结束</b></td>
</tr>
';
}
echo '</table>
<br>
';
if (!$PRINT_FLAG)
{
echo '<div align="center">
<input type="button" value="关闭" class="BigButton" onClick="javascript:window.close();">
</div>
</body>
</html>
';
}
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?