dept.php

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

PHP
188
字号
<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  if (($PRCS_ID_NEXT == ''))
  {
    $QUERY_PRIV = '';
  }
  else
  {
    $query = (((((''.'SELECT PRCS_USER,PRCS_DEPT,PRCS_PRIV,USER_FILTER from FLOW_PROCESS where FLOW_ID=').$FLOW_ID).' and PRCS_ID=\'').$PRCS_ID_NEXT).'\'');
    $cursor = exequery ($connection, $query);
    if ($ROW = mysql_fetch_array ($cursor))
    {
      $PRCS_USER = $ROW['PRCS_USER'];
      $PRCS_DEPT = $ROW['PRCS_DEPT'];
      $PRCS_PRIV = $ROW['PRCS_PRIV'];
      $USER_FILTER = $ROW['USER_FILTER'];
    }
    $QUERY_PRIV = ' and (1=2 ';
    if (($PRCS_USER != ''))
    {
      if ((substr ($PRCS_USER, -1) == ','))
      {
        $PRCS_USER = substr ($PRCS_USER, 0, -1);
      }
      $PRCS_USER = (('\''.str_replace (',', '\',\'', $PRCS_USER)).'\'');
      ($QUERY_PRIV .= (((''.' or USER_ID in(').$PRCS_USER).')'));
    }
    if (($PRCS_DEPT != ''))
    {
      if ((substr ($PRCS_DEPT, -1) == ','))
      {
        $PRCS_DEPT = substr ($PRCS_DEPT, 0, -1);
      }
      ($QUERY_PRIV .= (((''.' or DEPT_ID in(').$PRCS_DEPT).')'));
    }
    if (($PRCS_PRIV != ''))
    {
      if ((substr ($PRCS_PRIV, -1) == ','))
      {
        $PRCS_PRIV = substr ($PRCS_PRIV, 0, -1);
      }
      ($QUERY_PRIV .= (((''.' or USER.USER_PRIV in(').$PRCS_PRIV).')'));
    }
    ($QUERY_PRIV .= ') ');
  }
  echo '
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
  echo '<s';
  echo 'cript language="JavaScript">
function clickMenu(ID)
{
  targetelement=document.all(ID);
  if (targetelement.style.display=="none")
  {
      targetelement.style.display=\'\';
      if(ID=="1")
         ID="0";
      else
         ID="1";
      targetelement=document.all(ID);
      targetelement.style.display="none";
  }
  else
      targetelement.style.display="none";
}
</script>
</h';
  echo 'ead>
<body class="bodycolor"  topmargin="1" leftmargin="0">
  <table border="0" cellspacing="1" width="100%" class="small" bgcolor="#000000" cellpadding="3" align="center">
     <tr class="TableHeader" onclick="javascript:parent.user.location=\'user.php?INTEL=1&FLOW_ID=';
  echo $FLOW_ID;
  echo '&RUN_ID=';
  echo $RUN_ID;
  echo '&PRCS_ID=';
  echo $PRCS_ID;
  echo '&PRCS_ID_NEXT=';
  echo $PRCS_ID_NEXT;
  echo '\';" style="cursor:hand" title="点击伸缩列表">
       <td nowrap align="center"><b>全部经办人</b></td>
     </tr>
  </table>
  <table border="0" cellspacing="1" width="100%" class="small" bgcolor="#000000" cellpadding="3" align="center">
     <tr class="TableHeader" onclick="javascript:parent.user.location=\'user.php?INTEL=2&FLOW_ID=';
  echo $FLOW_ID;
  echo '&RUN_ID=';
  echo $RUN_ID;
  echo '&PRCS_ID=';
  echo $PRCS_ID;
  echo '&PRCS_ID_NEXT=';
  echo $PRCS_ID_NEXT;
  echo '\';" style="cursor:hand" title="点击伸缩列表">
       <td nowrap align="center"><b>按流程选择</b></td>
     </tr>
  </table>
  <table border="0" cellspacing="1" width="100%" class="small" bgcolor="#000000" cellpadding="3" align="center">
     <tr class="TableHeader" onclick="clickMenu(\'1\')" style="cursor:hand" title="点击伸缩列表">
       <td nowrap align="center"><b>按部门选择</b></td>
     </tr>
  </ta';
  echo 'ble>
  <table border="0" cellspacing="1" width="100%" class="small" cellpadding="3" id="1">
    <tr class="TableContent">
      <td align=center style="cursor:hand" onclick="parent.user.location=\'user.php?DEPT_ID=';
  echo $LOGIN_DEPT_ID;
  echo '&FLOW_ID=';
  echo $FLOW_ID;
  echo '&RUN_ID=';
  echo $RUN_ID;
  echo '&PRCS_ID=';
  echo $PRCS_ID;
  echo '&PRCS_ID_NEXT=';
  echo $PRCS_ID_NEXT;
  echo '\'";>
      	<b>本部门经办人</b><br>
      </td>
    </tr>
';
  if (($USER_FILTER == ''))
  {
    echo '    <tr class="TableControl">
      <td>
';
    $PARA_URL = 'user.php';
    $PARA_TARGET = 'user';
    $PRIV_NO_FLAG = 0;
    $xname = 'flow_turn';
    $showButton = 1;
    include_once 'dept_list/index.php';
    echo '      </td>
    </tr>
';
  }
  echo '  </table>
  <table border="0" cellspacing="1" width="100%" class="small" bgcolor="#000000" cellpadding="3" align="center">
     <tr class="TableHeader" onclick="clickMenu(\'0\')" style="cursor:hand" title="点击伸缩列表">
       <td nowrap align="center"><b>按角色选择</b></td>
     </tr>
  </table>
  <table border="0" cellspacing="1" width="100%" class="small" bgcolor="#000000" cellpadding="3" id="0" st';
  echo 'yle="display:none">
';
  if ((substr ($PRCS_PRIV, -1) == ','))
  {
    $PRCS_PRIV = substr ($PRCS_PRIV, 0, -1);
  }
  if (($USER_FILTER == '2'))
  {
    ($QUERY_PRIV .= (((''.' and USER.USER_PRIV=\'').$LOGIN_USER_PRIV).'\''));
  }
  $query = (('SELECT USER_PRIV.USER_PRIV,PRIV_NAME from USER_PRIV,USER where USER_PRIV.USER_PRIV=USER.USER_PRIV and DEPT_ID!=0 and NOT_LOGIN!=\'1\' '.$QUERY_PRIV).' group by USER_PRIV.USER_PRIV order by PRIV_NO');
  $cursor = exequery ($connection, $query);
  $PRIV_COUNT = 0;
  while ($ROW = mysql_fetch_array ($cursor))
  {
    ++$PRIV_COUNT;
    $USER_PRIV = $ROW['USER_PRIV'];
    $PRIV_NAME = $ROW['PRIV_NAME'];
    echo '<tr class="TableControl">
  <td align="center" onclick="javascript:parent.user.location=\'user.php?FLOW_ID=';
    echo $FLOW_ID;
    echo '&RUN_ID=';
    echo $RUN_ID;
    echo '&PRCS_ID=';
    echo $PRCS_ID;
    echo '&PRCS_ID=';
    echo $PRCS_ID;
    echo '&PRCS_ID_NEXT=';
    echo $PRCS_ID_NEXT;
    echo '&USER_PRIV=';
    echo $USER_PRIV;
    echo '\';" style="cursor:hand">';
    echo $PRIV_NAME;
    echo '</td>
</tr>
';
  }
  echo '</table>
</body>
</html>
';
?>

⌨️ 快捷键说明

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