⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 flow_view.php

📁 极限网络智能办公系统 Office Automation V3.0官方100%源代码.
💻 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>&nbsp&nbsp&nbsp&nbsp&nbsp开始于:$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>&nbsp&nbsp&nbsp&nbsp&nbsp开始于:$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>&nbsp&nbsp&nbsp&nbsp&nbsp开始于:$PRCS_TIME";
       }
       $PRCS_FLAG_DESC.="<br>";
    }

    if($PRCS_FLAG>2)
       $PRCS_FLAG_DESC.="<br>&nbsp&nbsp&nbsp&nbsp&nbsp步骤结束于:$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="&nbsp;";
?>
    <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 + -