personal_sign.php

来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 117 行

PHP
117
字号
<?
  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);
  $cursor1 = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor1))
  {
    $FLOW_NAME = $ROW['FLOW_NAME'];
    $FORM_ID = $ROW['FORM_ID'];
    $FLOW_TYPE = $ROW['FLOW_TYPE'];
    $FLOW_DOC = $ROW['FLOW_DOC'];
  }
  if (($PRINT_FLAG != 1))
  {
    echo '
<html>
<head>
<title>会签意见</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<body class="bodycolor" topmargin="1" leftmargin="0">
';
  }
  $query = ((''.'SELECT PRCS_ID,FLOW_PRCS from FLOW_RUN_PRCS WHERE RUN_ID=').$RUN_ID);
  $cursor = exequery ($connection, $query);
  while ($ROW = mysql_fetch_array ($cursor))
  {
    $PRCS_ID1 = $ROW['PRCS_ID'];
    $FLOW_PRCS1 = $ROW['FLOW_PRCS'];
    $query = ((((''.'SELECT PRCS_NAME from FLOW_PROCESS WHERE FLOW_ID=').$FLOW_ID).' AND PRCS_ID=').$FLOW_PRCS1);
    $cursor1 = exequery ($connection, $query);
    if ($ROW = mysql_fetch_array ($cursor1))
    {
      $PRCS_NAME = $ROW['PRCS_NAME'];
    }
    $PRCS_ID_ARRAY[$PRCS_ID1] = $PRCS_NAME;
  }
  $query = (((''.'SELECT * from FLOW_RUN_FEEDBACK where RUN_ID=').$RUN_ID).' order by PRCS_ID,EDIT_TIME');
  $cursor = exequery ($connection, $query);
  $FEEDBACK_COUNT = 0;
  while ($ROW = mysql_fetch_array ($cursor))
  {
    ++$FEEDBACK_COUNT;
    if (($FEEDBACK_COUNT == 1))
    {
      echo '     <table style=\'border-collapse:collapse\' border=1 cellspacing=0 cellpadding=3 bordercolor=\'#000000\' width="100%" class="small">
     <tr class="TableHeader">
      <td>会签意见</td>
    </tr>
';
    }
    $USER_ID = $ROW['USER_ID'];
    $PRCS_ID1 = $ROW['PRCS_ID'];
    $CONTENT = $ROW['CONTENT'];
    $ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
    $ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
    $EDIT_TIME = $ROW['EDIT_TIME'];
    $CONTENT = str_replace ('<', '&lt', $CONTENT);
    $CONTENT = str_replace ('>', '&gt', $CONTENT);
    $CONTENT = stripslashes ($CONTENT);
    $CONTENT = str_replace ('
', '<br>', $CONTENT);
    $query1 = (((''.'SELECT USER_NAME,DEPT_ID from USER where USER_ID=\'').$USER_ID).'\'');
    $cursor1 = exequery ($connection, $query1);
    if ($ROW = mysql_fetch_array ($cursor1))
    {
      $USER_NAME = $ROW['USER_NAME'];
      $DEPT_ID = $ROW['DEPT_ID'];
      $DEPT_NAME = dept_long_name ($DEPT_ID);
    }
    echo '    <tr class="TableData">
      <td>
      <b>
';
    if (($PRCS_ID1 != 0))
    {
      echo '      	第';
      echo $PRCS_ID1;
      echo '步 ';
      echo $PRCS_ID_ARRAY[$PRCS_ID1];
    }
    echo '    <u title="部门:';
    echo $DEPT_NAME;
    echo '" style="cursor:hand">';
    echo $USER_NAME;
    echo '</u>:</b>
    <br>
    ';
    echo $CONTENT;
    echo '    <i>';
    echo $EDIT_TIME;
    echo '</i>
    <br>
';
    if (($ATTACHMENT_ID != ''))
    {
      $TMP = attach_link ($ATTACHMENT_ID, $ATTACHMENT_NAME, 0, 1, 1, 0, 0, 1, 1, 0, '');
      if ($WORD)
      {
        $TMP = str_replace ('<img ', '<span ', $TMP);
      }
      echo $TMP;
    }
    echo '       </td>
     </tr>
';
  }
  if ((0 < $FEEDBACK_COUNT))
  {
    echo '</table>';
  }
?>

⌨️ 快捷键说明

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