?? index.php
字號(hào):
<?
include_once("../auth.php");
include_once("inc/utility_all.php");
?>
<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++;
//---- 顯示20條 ----
if($FLOW_COUNT>20)
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."步";
?>
<?=$FLOW_COUNT?>.<b><?=$FLOW_NAME?></b> - <?=$RUN_NAME?><br>
<?=$PRCS_NAME?> <?=$OP_FLAG_DESC?>
<a href="form.php?P=<?=$P?>&FLOW_ID=<?=$FLOW_ID?>&RUN_ID=<?=$RUN_ID?>&PRCS_ID=<?=$PRCS_ID?>">表單</a>
<a href="sign.php?P=<?=$P?>&FLOW_ID=<?=$FLOW_ID?>&RUN_ID=<?=$RUN_ID?>&PRCS_ID=<?=$PRCS_ID?>">會(huì)簽</a>
<?
if($FLOW_TYPE=="1")
{
if(!$OP_FLAG)
{
?>
<a href="stop.php?P=<?=$P?>&RUN_ID=<?=$RUN_ID?>&PRCS_ID=<?=$PRCS_ID?>">辦理完畢</a>
<?
}
}
else
{
?>
<a href="stop.php?P=<?=$P?>&RUN_ID=<?=$RUN_ID?>&PRCS_ID=<?=$PRCS_ID?>">結(jié)束流程</a>
<?
}
?>
<hr>
<?
}//while
if($FLOW_COUNT==0)
echo "無待辦工作";
?>
<a href="../main.php?P=<?=$P?>">返回</a>
</body>
</html>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -