📄 query.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
?>
<html>
<head>
<title>查询用户</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</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/menu/infofind.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" 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,0);
?>
<option value="0">离职人员/外部人员</option>
</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"];
?>
<option value="<?=$USER_PRIV1?>"><?=$PRIV_NAME?></option>
<?
}
?>
</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"];
?>
<option value="<?=$DUTY_TYPE?>"><?=$DUTY_NAME?></option>
<?
}
?>
</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="submit" value="查询" class="BigButton" title="查询用户" name="button">
</td>
</form>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -