📄 query.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_org.php" );
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<script Language=\"JavaScript\">\r\nfunction CheckForm(form_action)\r\n{\r\n document.form1.action=form_action;\r\n document.form1.submit();\r\n}\r\n</script>\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\" onload=\"document.form1.USER_ID.focus();\">\r\n\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/notify_new.gif\" align=\"absmiddle\"><span class=\"big3\"> 查询用户</span>\r\n </td>\r\n </tr>\r\n</table>\r\n\r\n<table class=\"TableBlock\" width=\"90%\" align=\"center\">\r\n <form action=\"search.php\" method=\"post\" name=\"form1\">\r\n <tr>\r\n <td nowrap class=\"TableData\" width=\"120\">用户名：</td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"text\" name=\"USER_ID\" class=\"BigInput\" size=\"20\" maxlength=\"20\"> \r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">真实姓名：</td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"text\" name=\"USER_NAME\" class=\"BigInput\" size=\"10\" maxlength=\"10\"> \r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">别名：</td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"text\" name=\"BYNAME\" class=\"BigInput\" size=\"10\" maxlength=\"10\"> \r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">性别：</td>\r\n <td nowrap class=\"TableData\">\r\n <select name=\"SEX\" class=\"BigSelect\">\r\n <option value=\"\"></option>\r\n <option value=\"0\">男</option>\r\n <option value=\"1\">女</option>\r\n </select>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">部门：</td>\r\n <td nowrap class=\"TableData\">\r\n <select name=\"DEPT_ID\" class=\"BigSelect\">\r\n <option value=\"\"></option>\r\n";
echo my_dept_tree( 0, $DEPT_ID, 1 );
if ( $DEPT_ID == 0 )
{
echo " <option value=\"0\">离职人员/外部人员</option>\r\n";
}
echo " </select>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">角色：</td>\r\n <td nowrap class=\"TableData\">\r\n <select name=\"USER_PRIV\" class=\"BigSelect\">\r\n <option value=\"\"></option>\r\n\r\n";
$query = "SELECT * from USER_PRIV order by PRIV_NO desc";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$USER_PRIV1 = $ROW['USER_PRIV'];
$PRIV_NAME = $ROW['PRIV_NAME'];
echo " <option value=\"";
echo $USER_PRIV1;
echo "\">";
echo $PRIV_NAME;
echo "</option>\r\n";
}
echo " </select>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\" width=\"120\">管理范围：</td>\r\n <td nowrap class=\"TableData\">\r\n <select name=\"POST_PRIV\" class=\"BigSelect\">\r\n <option value=\"\"></option>\r\n <option value=\"0\">本部门</option>\r\n <option value=\"1\">全体</option>\r\n <option value=\"2\">指定部门</option>\r\n </select>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">是否允许登录OA系统：</td>\r\n <td nowrap class=\"TableData\">\r\n \t <select name=\"NOT_LOGIN\" class=\"BigSelect\">\r\n <option value=\"2\"></option>\r\n <option value=\"0\">允许</option>\r\n <option value=\"1\">禁止</option>\r\n </select>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">是否允许查看用户列表：</td>\r\n <td nowrap class=\"TableData\">\r\n \t <select name=\"NOT_VIEW_USER\" class=\"BigSelect\">\r\n <option value=\"2\"></option>\r\n <option value=\"0\">允许</option>\r\n <option value=\"1\">禁止</option>\r\n </select>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">是否允许显示桌面：</td>\r\n <td nowrap class=\"TableData\">\r\n \t <select name=\"NOT_VIEW_TABLE\" class=\"BigSelect\">\r\n <option value=\"2\"></option>\r\n <option value=\"0\">允许</option>\r\n <option value=\"1\">禁止</option>\r\n </select>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">考勤排班类型：</td>\r\n <td nowrap class=\"TableData\">\r\n <select name=\"DUTY_TYPE\" class=\"BigSelect\">\r\n <option value=\"\"></option>\r\n";
$query = "SELECT * from ATTEND_CONFIG order by DUTY_TYPE";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$DUTY_TYPE = $ROW['DUTY_TYPE'];
$DUTY_NAME = $ROW['DUTY_NAME'];
echo " <option value=\"";
echo $DUTY_TYPE;
echo "\">";
echo $DUTY_NAME;
echo "</option>\r\n";
}
echo " </select>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\" width=\"120\">IMA广播权限：</td>\r\n <td nowrap class=\"TableData\">\r\n <select name=\"CANBROADCAST\" class=\"BigSelect\">\r\n <option value=\"\"></option>\r\n <option value=\"0\">无</option>\r\n <option value=\"1\">有</option>\r\n </select>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\" width=\"120\">按最后登录时间排序：</td>\r\n <td nowrap class=\"TableData\">\r\n <select name=\"LAST_VISIT_TIME\" class=\"BigSelect\">\r\n <option value=\"\"></option>\r\n <option value=\"desc\">降序</option>\r\n <option value=\"asc\">升序</option>\r\n </select>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableControl\" colspan=\"2\" align=\"center\">\r\n <input type=\"button\" value=\"查询\" class=\"BigButton\" onclick=\"CheckForm('search.php');\" title=\"查询用户\" name=\"button\"> \r\n <input type=\"button\" value=\"导出\" class=\"BigButton\" onclick=\"CheckForm('export.php');\" title=\"导出用户信息\" name=\"button\">\r\n </td>\r\n </form>\r\n</table>\r\n\r\n<br>\r\n";
message( "提示", "点击左侧部门后，可以新建用户" );
echo "</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -