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

📄 sign.php

📁 通达OA的PDA部分源代码
💻 PHP
字号:
🔍 
<?

  include_once '../auth.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>
<form action="sign_submit.php"  method="post" name="form1">
会签意见<br>
<textarea cols="18" name="CONTENT" rows="3" wrap="on">';
  echo $CONTENT;
  echo '</textarea>
<br>
<input type="hidden" name="P" value="';
  echo $P;
  echo '">
<input type="hidden" name="FLOW_ID" value="';
  echo $FLOW_ID;
  echo '">
<input type="hidden" name="RUN_ID" value="';
  echo $RUN_ID;
  echo '">
<input type="hidden" name="PRCS_ID" value="';
  echo $PRCS_ID;
  echo '">
<input type="button" value="返回" onClick="location=\'index.php?P=';
  echo $P;
  echo '\'">&nbsp;
<input type="submit" value="保存">
</form>
<hr>

';
  $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'];
  }

  $CUR_TIME = date ('Y-m-d H:i:s', time ());
  $query = '' . 'SELECT * from FLOW_RUN_PRCS where USER_ID=\'' . $LOGIN_USER_ID . '\' AND RUN_ID=' . $RUN_ID . ' AND PRCS_ID=' . $PRCS_ID;
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $PRCS_FLAG = $ROW['PRCS_FLAG'];
    $TOP_FLAG = $ROW['TOP_FLAG'];
    if ($PRCS_FLAG == 1)
    {
      $query = '' . 'update FLOW_RUN_PRCS set PRCS_FLAG=\'2\',PRCS_TIME=\'' . $CUR_TIME . '\' WHERE USER_ID=\'' . $LOGIN_USER_ID . '\' AND RUN_ID=' . $RUN_ID . ' AND PRCS_ID=' . $PRCS_ID;
      exequery ($connection, $query);
    }
  }

  $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'];
      }
      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 = '

会签意见：
';
        }

        $FEED_CONTENT .= $ROW['CONTENT'] . '
';
      }

      $PRCS_FLAG_DESC .= $PRCS_USER_NAME;
      if ($OP_FLAG == 1)
      {
        $PRCS_FLAG_DESC .= ' 主办人 ';
      }

      if ($PRCS_FLAG == 1)
      {
        $PRCS_FLAG_DESC .= ' 未接收';
      }
      else
      {
        if ($PRCS_FLAG == 2)
        {
          $PRCS_FLAG_DESC .= ' 办理中';
        }
        else
        {
          if ($PRCS_FLAG == 3)
          {
            $PRCS_FLAG_DESC .= ' 已转交';
          }
          else
          {
            if ($PRCS_FLAG == 4)
            {
              $PRCS_FLAG_DESC .= ' 已办结';
            }
          }
        }
      }

      $PRCS_FLAG_DESC .= '' . ' 开始于 ' . $PRCS_TIME;
      $PRCS_FLAG_DESC .= ' ' . $FEED_CONTENT . '<br>';
    }

    if (2 < $PRCS_FLAG)
    {
      $PRCS_FLAG_DESC .= '' . '<br>步骤结束于 ' . $DELIVER_TIME;
    }

    echo '    <b>第';
    echo $PRCS_ID_I;
    echo '步:
';
    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>';
      }

      echo $PRCS_NAME;
    }

    echo '    </b> ';
    echo $PRCS_FLAG_DESC;
    echo '<br>
';
  }

  echo '
</body>
</html>';
?>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -