📄 show_users.php
字号:
<?php
function dept_tree_list( $DEPT_ID )
{
global $connection;
global $DEEP_COUNT;
global $USER_PRIV;
global $COUNT1;
global $COUNT2;
global $COUNT3;
global $COUTN_DEPT;
$query = "SELECT * from DEPARTMENT where DEPT_PARENT='".$DEPT_ID."' order by DEPT_NO";
$cursor = exequery( $connection, $query );
$OPTION_TEXT = "";
$DEEP_COUNT1 = $DEEP_COUNT;
$DEEP_COUNT .= " ";
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$COUNT;
$DEPT_ID = $ROW['DEPT_ID'];
$DEPT_NAME = $ROW['DEPT_NAME'];
$DEPT_NAME = htmlspecialchars( $DEPT_NAME );
$DEPT_PRIV = 1;
$OPTION_TEXT_CHILD = dept_tree_list( $DEPT_ID );
$USER_NAME_STR1 = $USER_NAME_STR2 = $USER_NAME_STR3 = "";
$query1 = "SELECT USER_NAME from USER where USER_PRIV='".$USER_PRIV."' AND DEPT_ID='{$DEPT_ID}' and NOT_LOGIN='0' order by USER_NO,USER_NAME";
$cursor1 = exequery( $connection, $query1 );
while ( $ROW1 = mysql_fetch_array( $cursor1 ) )
{
$USER_NAME_STR1 .= $ROW1['USER_NAME']."，";
++$COUNT1;
++$COUNT_DEPT["{$DEPT_ID}"][1];
}
$query1 = "SELECT USER_NAME from USER where FIND_IN_SET(".$USER_PRIV.",USER_PRIV_OTHER) AND DEPT_ID='{$DEPT_ID}' and NOT_LOGIN='0' order by USER_NO,USER_NAME";
$cursor1 = exequery( $connection, $query1 );
while ( $ROW1 = mysql_fetch_array( $cursor1 ) )
{
$USER_NAME_STR2 .= $ROW1['USER_NAME']."，";
++$COUNT2;
++$COUNT_DEPT["{$DEPT_ID}"][2];
}
$query1 = "SELECT USER_NAME from USER where USER_PRIV='".$USER_PRIV."' AND DEPT_ID='{$DEPT_ID}' and NOT_LOGIN='1' order by USER_NO,USER_NAME";
$cursor1 = exequery( $connection, $query1 );
while ( $ROW1 = mysql_fetch_array( $cursor1 ) )
{
$USER_NAME_STR3 .= $ROW1['USER_NAME']."，";
++$COUNT3;
++$COUNT_DEPT["{$DEPT_ID}"][3];
}
$USER_NAME_STR1 = substr( $USER_NAME_STR1, 0, -2 );
$USER_NAME_STR2 = substr( $USER_NAME_STR2, 0, -2 );
$USER_NAME_STR3 = substr( $USER_NAME_STR3, 0, -2 );
$OPTION_TEXT .= "\r\n <tr class=TableData>\r\n <td nowrap class=\"TableContent\">".$DEEP_COUNT1."├".$DEPT_NAME."</td>\r\n <td class=\"TableContent\" align=\"center\">".( $COUNT_DEPT["{$DEPT_ID}"][1] ? $COUNT_DEPT["{$DEPT_ID}"][1] : 0 )."/".( $COUNT_DEPT["{$DEPT_ID}"][2] ? $COUNT_DEPT["{$DEPT_ID}"][2] : 0 )."/".( $COUNT_DEPT["{$DEPT_ID}"][3] ? $COUNT_DEPT["{$DEPT_ID}"][3] : 0 )."</td>\r\n <td style=\"cursor:hand\">".$USER_NAME_STR1."</td>\r\n <td style=\"cursor:hand\">".$USER_NAME_STR2."</td>\r\n <td style=\"cursor:hand\">".$USER_NAME_STR3."</td>\r\n </tr>";
if ( $OPTION_TEXT_CHILD != "" )
{
$OPTION_TEXT .= $OPTION_TEXT_CHILD;
}
}
$DEEP_COUNT = $DEEP_COUNT1;
return $OPTION_TEXT;
}
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
$query = "SELECT PRIV_NAME from USER_PRIV where USER_PRIV='".$USER_PRIV."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$PRIV_NAME = $ROW['PRIV_NAME'];
}
echo "\r\n<html>\r\n<head>\r\n<title>查看角色详情--";
echo $PRIV_NAME;
echo "</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/user_list/folder.gif\" align=\"absmiddle\"><span class=\"big3\"> 角色详情--[";
echo $PRIV_NAME;
echo "]</span>\r\n </td>\r\n </tr>\r\n</table>\r\n\r\n";
$COUNT1 = $COUNT2 = $COUNT3 = 0;
$OPTION_TEXT = dept_tree_list( 0 );
echo " <table class=\"TableBlock\" width=\"100%\" align=\"center\">\r\n <tr class=\"TableHeader\">\r\n <td nowrap align=\"center\">部门/成员单位</td>\r\n <td nowrap align=\"center\">人数统计</td>\r\n <td nowrap align=\"center\">主角色</td>\r\n <td nowrap align=\"center\">辅助角色</td>\r\n <td nowrap align=\"center\">禁止登陆</td>\r\n </tr>\r\n ";
echo $OPTION_TEXT;
echo " <tfoot class=\"TableControl\">\r\n <td nowrap align=\"center\"><b>合计：</b></td>\r\n <td></td>\r\n <td nowrap align=\"center\"><b>";
echo $COUNT1;
echo "</b></td>\r\n <td nowrap align=\"center\"><b>";
echo $COUNT2;
echo "</b></td>\r\n <td nowrap align=\"center\"><b>";
echo $COUNT3;
echo "</b></td>\r\n </tfoot>\r\n </table>\r\n\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -