📄 user_group.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
include_once( "inc/utility_org.php" );
include_once( "general/workflow/prcs_role.php" );
include_once( "inc/user_online.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 != "" )
{
$QUERY_PRIV .= " or FIND_IN_SET(USER.USER_ID,'".$PRCS_USER."')";
}
if ( $PRCS_DEPT != "" )
{
if ( $PRCS_DEPT == "ALL_DEPT" )
{
$QUERY_PRIV .= " or 1=1";
}
else
{
if ( substr( $PRCS_DEPT, -1, 1 ) == "," )
{
$PRCS_DEPT = substr( $PRCS_DEPT, 0, -1 );
}
$QUERY_PRIV .= " or DEPT_ID in(".$PRCS_DEPT.")";
}
}
if ( $PRCS_PRIV != "" )
{
if ( substr( $PRCS_PRIV, -1, 1 ) == "," )
{
$PRCS_PRIV = substr( $PRCS_PRIV, 0, -1 );
}
$QUERY_PRIV .= " or USER.USER_PRIV in(".$PRCS_PRIV.")".flow_other_sql( $PRCS_PRIV );
}
$QUERY_PRIV .= ") ";
if ( $USER_FILTER == "1" )
{
$QUERY_PRIV .= " and USER.DEPT_ID='".$LOGIN_DEPT_ID."'";
}
else if ( $USER_FILTER == "2" )
{
$QUERY_PRIV .= " and USER.USER_PRIV='".$LOGIN_USER_PRIV."'";
}
}
echo "\r\n<html>\r\n<head>\r\n<title></title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n<style>\r\n.menulines{}\r\n</style>\r\n<script src=\"/inc/js/utility.js\"></script>\r\n<script src=\"./user_select.js\"></script>\r\n<script>\r\nvar parent_window = getOpenner();\r\nvar top_flag = parent_window.form1.TOP_FLAG";
echo $LINE_COUNT;
echo ".value;\r\nvar op_user = parent_window.getElementById('PRCS_OP_USER";
echo $LINE_COUNT;
echo "');\r\nvar op_user_name = parent_window.getElementById('PRCS_OP_USER_NAME";
echo $LINE_COUNT;
echo "');\r\nvar prcs_user = parent_window.getElementById('PRCS_USER";
echo $LINE_COUNT;
echo "');\r\nvar prcs_user_name = parent_window.getElementById('PRCS_USER_NAME";
echo $LINE_COUNT;
echo "');\r\n\r\nvar DEL_IMG0='<img src=\"/images/remove.png\" align=\"absmiddle\" onclick=cancel_user(this,0,\"";
echo $LINE_COUNT;
echo "\")>';\r\nvar DEL_IMG1='<img src=\"/images/remove.png\" align=\"absmiddle\" onclick=cancel_user(this,1,\"";
echo $LINE_COUNT;
echo "\")>';\r\n\r\n</script>\r\n</head>\r\n<body class=\"bodycolor\" topmargin=\"0\" leftmargin=\"0\" onload=\"begin_set()\">\r\n\r\n";
include_once( "inc/my_priv.php" );
$query = "SELECT * from USER_GROUP where GROUP_ID='".$GROUP_ID."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$GROUP_NAME = $ROW['GROUP_NAME'];
$USER_STR = $ROW['USER_STR'];
}
echo "<table class=\"TableBlock\" width=\"100%\">\r\n<tr class=\"TableHeader\">\r\n <td colspan=\"2\" align=\"center\">";
echo htmlspecialchars( $GROUP_NAME );
echo "</td>\r\n</tr>\r\n\r\n";
$USER_COUNT = 0;
$query = "SELECT UID,USER_ID,USER_NAME,USER.DEPT_ID,DEPT_NAME,PRIV_NO,SEX from USER,USER_PRIV,DEPARTMENT where USER.USER_PRIV=USER_PRIV.USER_PRIV and USER.DEPT_ID=DEPARTMENT.DEPT_ID and NOT_LOGIN!='1' and find_in_set(USER_ID,'".$USER_STR."')";
if ( $DEPT_PRIV == "3" )
{
$query .= " and find_in_set(USER.USER_ID,'".$USER_ID_STR."')";
}
if ( $EXCLUDE_UID_STR != "" )
{
$query .= " and not find_in_set(USER.UID,'".$EXCLUDE_UID_STR."')";
}
$query .= $QUERY_PRIV;
$query .= " order by DEPT_NO,PRIV_NO,USER_NO,USER_NAME";
$cursor = exequery( $connection, $query );
for ( ; while ( $ROW = mysql_fetch_array( $cursor ) )
{
do
{
$UID = $ROW['UID'], $USER_ID = $ROW['USER_ID'], $USER_NAME = $ROW['USER_NAME'], $DEPT_ID_I = $ROW['DEPT_ID'], $DEPT_NAME = $ROW['DEPT_NAME'], $PRIV_NO_I = $ROW['PRIV_NO'], $SEX = $ROW['SEX'], if ( $SEX == "" )
{
$SEX = "0", }
if ( is_dept_priv( $DEPT_ID_I, $DEPT_PRIV, $DEPT_ID_STR, TRUE ) )
{
if ( $ROLE_PRIV == "0" && $PRIV_NO_I <= $MY_PRIV_NO || $ROLE_PRIV == "1" && $PRIV_NO_I < $MY_PRIV_NO )
{
break;
}
if ( !( $ROLE_PRIV == "3" ) )
{
break;
}
find_id( $PRIV_ID_STR, $PRIV_NO_I ); if ( find_id( $PRIV_ID_STR, $PRIV_NO_I ) )
{
break;
if ( find_id( $PRIV_ID_STR, $PRIV_NO_I ) )
{
break;
if ( find_id( $PRIV_ID_STR, $PRIV_NO_I ) )
{
break;
}
}
}
}
)
{
} while ( 0 );
++$USER_COUNT;
if ( $USER_COUNT == 1 )
{
echo "<tr class=\"TableData\">\r\n <td onclick=\"javascript:add_all();\" style=\"cursor:pointer\" align=\"center\" colspan=\"2\">全部添加</td>\r\n</tr>\r\n<tr class=\"TableData\">\r\n <td onclick=\"javascript:del_all();\" style=\"cursor:pointer\" align=\"center\" colspan=\"2\">全部删除</td>\r\n</tr>\r\n";
}
echo "<tr class=\"TableData\">\r\n <td title=\"设为主办人\" nowrap class=\"menulines_op\" id=\"";
echo $USER_ID;
echo "_op\" name=\"";
echo $USER_NAME;
echo "\" width=\"55\" align=\"center\" onclick=\"javascript:click_op('";
echo $USER_ID;
echo "_op')\" style=\"cursor:pointer\">\r\n <input type=\"checkbox\" id=\"opbox_";
echo $USER_ID;
echo "\">主办\r\n </td>\r\n <td title=\"";
echo $DEPT_LONG_NAME;
echo "\" class=\"menulines\" id=\"";
echo $USER_ID;
echo "\" name=\"";
echo $USER_NAME;
echo "\" width=\"90%\" align=\"center\" onclick=\"javascript:click_user('";
echo $USER_ID;
echo "')\" style=\"cursor:pointer\">\r\n ";
echo $USER_NAME;
echo " ";
if ( array_key_exists( $UID, $SYS_ONLINE_USER ) )
{
echo "<img align=\"absmiddle\" src=\"/images/".$SEX."-1.gif\" title=\"在线\">";
}
echo " </td>\r\n</tr>\r\n";
}
if ( $USER_COUNT == 0 )
{
echo "<tr class=\"TableControl\">\r\n <td align=\"center\">无符合条件的用户</td>\r\n</tr>\r\n";
}
echo "</table>\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -