📄 search.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" >
<?
//-----------先组织SQL语句-----------
$query = "SELECT * from USER_PRIV where USER_PRIV=$LOGIN_USER_PRIV";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
$PRIV_NO=$ROW["PRIV_NO"];
if($USER_ID!="")
$WHERE_STR.=" and USER_ID like '%".$USER_ID."%'";
if($USER_NAME!="")
$WHERE_STR.=" and USER_NAME like '%".$USER_NAME."%'";
if($BYNAME!="")
$WHERE_STR.=" and BYNAME like '%".$BYNAME."%'";
if($SEX!="")
$WHERE_STR.=" and SEX=$SEX";
if($DEPT_ID!="")
$WHERE_STR.=" and USER.DEPT_ID=$DEPT_ID";
if($DUTY_TYPE!="")
$WHERE_STR.=" and DUTY_TYPE=$DUTY_TYPE";
if($USER_PRIV!="")
$WHERE_STR.=" and USER.USER_PRIV=$USER_PRIV";
if($POST_PRIV!="")
$WHERE_STR.=" and POST_PRIV=$POST_PRIV";
if($CANBROADCAST!="")
$WHERE_STR.=" and CANBROADCAST=$CANBROADCAST";
if($NOT_LOGIN!="2")
$WHERE_STR.=" and NOT_LOGIN='$NOT_LOGIN'";
if($NOT_VIEW_USER!="2")
$WHERE_STR.=" and NOT_VIEW_USER='$NOT_VIEW_USER'";
if($NOT_VIEW_TABLE!="2")
$WHERE_STR.=" and NOT_VIEW_TABLE='$NOT_VIEW_TABLE'";
?>
<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>
<?
$USER_COUNT=0;
$query = "SELECT * from USER,USER_PRIV,DEPARTMENT where DEPARTMENT.DEPT_ID=USER.DEPT_ID and USER.USER_PRIV=USER_PRIV.USER_PRIV ".$WHERE_STR." order by ";
if($LAST_VISIT_TIME!="")
$query .= "LAST_VISIT_TIME ".$LAST_VISIT_TIME.",";
$query .= "DEPT_NO,PRIV_NO,USER_NO,USER_NAME";
$cursor= exequery($connection,$query);
while($ROW=mysql_fetch_array($cursor))
{
$USER_ID=$ROW["USER_ID"];
$USER_NAME=$ROW["USER_NAME"];
$DEPT_ID=$ROW["DEPT_ID"];
$SEX=$ROW["SEX"];
$TEL_NO_DEPT=$ROW["TEL_NO_DEPT"];
$MOBIL_NO=$ROW["MOBIL_NO"];
$EMAIL=$ROW["EMAIL"];
$USER_COUNT++;
$query1 = "SELECT * from DEPARTMENT where DEPT_ID=" .$DEPT_ID;
$cursor1= exequery($connection,$query1);
if($ROW=mysql_fetch_array($cursor1))
$DEPT_NAME=$ROW["DEPT_NAME"];
else
$DEPT_NAME="离职人员/外部人员";
if($SEX=="0")
$SEX="男";
else
$SEX="女";
$DEPT_LONG_NAME=dept_long_name($DEPT_ID);
if($USER_COUNT==1)
{
?>
<table align="center" border="0" cellspacing="1" width="100%" class="small" bgcolor="#000000" cellpadding="3">
<?
}
if($USER_COUNT%2==1)
$TableLine="TableLine1";
else
$TableLine="TableLine2";
?>
<tr class="<?=$TableLine?>">
<td nowrap align="center" title="<?=$DEPT_LONG_NAME?>"><u style="cursor:hand"><?=$DEPT_NAME?></u></td>
<td nowrap align="center"><a href="user_info.php?USER_ID=<?=$USER_ID?>"><?=$USER_NAME?></a></td>
<td nowrap align="center"><?=$SEX?></td>
<td align="center"><?=$TEL_NO_DEPT?></td>
<td align="center"><A href="/general/mobile_sms?TO_ID=<?=$USER_ID?>,&TO_NAME=<?=$USER_NAME?>,"><?=$MOBIL_NO?></A></td>
<td align="center"><?=$EMAIL?></td>
</tr>
<?
}
if($USER_COUNT>0)
{
?>
<thead class="TableHeader">
<td nowrap align="center">部门</td>
<td nowrap align="center">姓名</td>
<td nowrap align="center">性别</td>
<td nowrap align="center">单位电话</td>
<td nowrap align="center">手机</td>
<td nowrap align="center">电子邮件</td>
</thead>
</table>
<?
}
else
Message("","无符合条件的用户");
?>
<br>
<div align="center">
<input type="button" value="返回" class="BigButton" onClick="history.back();">
</div>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -