?? index.php
字號:
<?
include_once '../auth.php';
include_once 'inc/utility_all.php';
echo '
<html>
<head>
<title>工作流</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body>
<font color=blue size=+2><b>工作流</b></font>
<br><br>
';
$query = '' . 'SELECT * from FLOW_RUN_PRCS,FLOW_RUN,FLOW_TYPE WHERE FLOW_RUN_PRCS.RUN_ID=FLOW_RUN.RUN_ID and FLOW_RUN.FLOW_ID=FLOW_TYPE.FLOW_ID and USER_ID=\'' . $LOGIN_USER_ID . '\' and PRCS_FLAG<\'3\' and not (TOP_FLAG=\'1\' and PRCS_FLAG=1) order by FLOW_RUN_PRCS.PRCS_FLAG,PRCS_TIME desc';
$cursor = exequery ($connection, $query);
$FLOW_COUNT = 0;
while ($ROW = mysql_fetch_array ($cursor))
{
++$FLOW_COUNT;
if (20 < $FLOW_COUNT)
{
break;
}
$PRCS_ID = $ROW['PRCS_ID'];
$RUN_ID = $ROW['RUN_ID'];
$FLOW_ID = $ROW['FLOW_ID'];
$PRCS_FLAG = $ROW['PRCS_FLAG'];
$FLOW_PRCS = $ROW['FLOW_PRCS'];
$OP_FLAG = $ROW['OP_FLAG'];
if ($OP_FLAG == '1')
{
$OP_FLAG_DESC = '主辦';
}
if ($PRCS_FLAG == '1')
{
$STATUS = '未接收';
}
else
{
if ($PRCS_FLAG == '2')
{
$STATUS = '已接收';
}
}
$query = '' . 'SELECT * from FLOW_RUN WHERE RUN_ID=\'' . $RUN_ID . '\'';
$cursor1 = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor1))
{
$FLOW_ID = $ROW['FLOW_ID'];
$RUN_NAME = $ROW['RUN_NAME'];
}
$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'];
$FLOW_TYPE = $ROW['FLOW_TYPE'];
}
if ($FLOW_TYPE == '1')
{
$query = '' . 'SELECT * from FLOW_PROCESS WHERE FLOW_ID=\'' . $FLOW_ID . '\' AND PRCS_ID=\'' . $FLOW_PRCS . '\'';
$cursor1 = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor1))
{
$PRCS_NAME = '第' . $PRCS_ID . '步：' . $ROW['PRCS_NAME'];
}
}
else
{
$PRCS_NAME = '第' . $PRCS_ID . '步';
}
echo '
';
echo $FLOW_COUNT;
echo '.<b>';
echo $FLOW_NAME;
echo '</b> - ';
echo $RUN_NAME;
echo '<br>
';
echo $PRCS_NAME;
echo ' ';
echo $OP_FLAG_DESC;
echo '
<a href="form.php?P=';
echo $P;
echo '&FLOW_ID=';
echo $FLOW_ID;
echo '&RUN_ID=';
echo $RUN_ID;
echo '&PRCS_ID=';
echo $PRCS_ID;
echo '">表單</a>
<a href="sign.php?P=';
echo $P;
echo '&FLOW_ID=';
echo $FLOW_ID;
echo '&RUN_ID=';
echo $RUN_ID;
echo '&PRCS_ID=';
echo $PRCS_ID;
echo '">會簽</a>
';
if ($FLOW_TYPE == '1')
{
if (!$OP_FLAG)
{
echo ' <a href="stop.php?P=';
echo $P;
echo '&RUN_ID=';
echo $RUN_ID;
echo '&PRCS_ID=';
echo $PRCS_ID;
echo '">辦理完畢</a>
';
}
}
else
{
echo ' <a href="stop.php?P=';
echo $P;
echo '&RUN_ID=';
echo $RUN_ID;
echo '&PRCS_ID=';
echo $PRCS_ID;
echo '">結(jié)束流程</a>
';
}
echo '
<hr>
';
}
if ($FLOW_COUNT == 0)
{
echo '無待辦工作';
}
echo '
<a href="../main.php?P=';
echo $P;
echo '">返回</a>
</body>
</html>
';
?>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -