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