?? flow_view.php
字號:
<?
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)
{
?>
<html>
<head>
<title><?=$TITLE?></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script>
focus();
</script>
</head>
<body class="bodycolor" topmargin="5">
<?
}
?>
<table style='border-collapse:collapse' border=1 cellspacing=0 cellpadding=3 bordercolor='#000000' width="100%" class="small">
<?
if($PRINT_FLAG)
{
?>
<tr>
<td nowrap colspan="3" class="TableHeader"><img src="/images/green_arrow.gif" align="absmiddle"> <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="";
$PRCS_FLAG_ALL=4;
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"];
if($PRCS_FLAG!=4)
$PRCS_FLAG_ALL=0;
$PRCS_USER_NAME="";
$query1 = "SELECT * 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 * 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="\n\n會簽意見：\n";
$FEED_CONTENT.=$ROW["CONTENT"]." ".$ROW["EDIT_TIME"]."\n";
}
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($PRCS_FLAG==1)
$TIME_USED=0;
elseif($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($DAY>0)
$TIME_STR.=$DAY."天";
if($HOUR>0)
$TIME_STR.=$HOUR."時";
if($MIN>0)
$TIME_STR.=$MIN."分";
if($SEC>0)
$TIME_STR.=$SEC."秒";
if($PRCS_FLAG==1)
$PRCS_FLAG_DESC.="<img src='/images/email_close.gif' alt='未接收辦理' align='absmiddle'> ".$PRCS_USER_NAME." [<font color=green>未接收辦理</font>]";
elseif($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>]";
$PRCS_FLAG_DESC.="<br>     開始于：$PRCS_TIME";
}
elseif($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";
}
elseif($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";
}
$PRCS_FLAG_DESC.="<br>";
}
if($PRCS_FLAG>2)
$PRCS_FLAG_DESC.="<br>     步驟結束于：$DELIVER_TIME";
if($PRCS_ID_I==1 && !$PRINT_FLAG)
{
?>
<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=" ";
?>
<tr class="TableLine1">
<td nowrap align="center">第<b><span class="Big4"><?=$PRCS_ID_I?></span></b>步</td>
<?
if($FLOW_TYPE==1)
{
$query1 = "SELECT * 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"];
else
$PRCS_NAME="<font color=red>流程步驟已刪除</font>";
?>
<td><img border=0 src="/images/arrow_down.gif"> 序號<?=$FLOW_PRCS?>：<?=$PRCS_NAME?></td>
<?
}
?>
<td><?=$PRCS_FLAG_DESC?></td>
</tr>
<?
}
if($PRCS_FLAG==4 && !$PRINT_FLAG)
{
?>
<tr>
<td nowrap align="center" colspan="3" class="TableHeader" height=30><b>流程結束</b></td>
</tr>
<?
}
?>
</table>
<br>
<?
if(!$PRINT_FLAG)
{
?>
<div align="center">
<input type="button" value="關閉" class="BigButton" onClick="javascript:window.close();">
</div>
</body>
</html>
<?
}
?>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -