📄 dept.php
字号:
<?
include_once 'inc/auth.php';
include_once 'inc/utility_all.php';
$query = '' . 'SELECT * 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'];
}
$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>
</';
echo 'table>
<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>
<tr class="TableControl">
<td>
';
$PARA_URL = 'user.php';
$PARA_TARGET = 'user';
$PRIV_NO_FLAG = 0;
include_once 'dept_list/index.php';
echo ' </td>
</tr>
</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" c';
echo 'ellpadding="3" id="0" style="display:none">
';
if (substr ($PRCS_PRIV, -1) == ',')
{
$PRCS_PRIV = substr ($PRCS_PRIV, 0, -1);
}
$query = 'SELECT * 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 + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -