📄 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语句-----------
$connection=OpenConnection();
if($USER_NAME!="")
$WHERE_STR.=" and USER_NAME like '%".$USER_NAME."%'";
if($DEPT_ID!="all")
$WHERE_STR.=" and USER.DEPT_ID=$DEPT_ID";
if($SEX!="ALL")
$WHERE_STR.=" and SEX=$SEX";
if($TEL_NO_DEPT!="")
$WHERE_STR.=" and TEL_NO_DEPT like '%".$TEL_NO_DEPT."%'";
if($EMAIL!="")
$WHERE_STR.=" and EMAIL like '%".$EMAIL."%'";
$WHERE_STR=" where USER.DEPT_ID=DEPARTMENT.DEPT_ID and USER.DEPT_ID!=0 ".$WHERE_STR;
$USER_COUNT=0;
$query="SELECT * from USER,DEPARTMENT ".$WHERE_STR." order by DEPT_NO";
$cursor= exequery($connection,$query);
while($ROW=mysql_fetch_array($cursor))
{
$USER_COUNT++;
$USER_ID=$ROW["USER_ID"];
$USER_NAME=$ROW["USER_NAME"];
$USER_PRIV=$ROW["USER_PRIV"];
$DEPT_ID=$ROW["DEPT_ID"];
$SEX=$ROW["SEX"];
$TEL_NO_DEPT=$ROW["TEL_NO_DEPT"];
$MOBIL_NO=$ROW["MOBIL_NO"];
$EMAIL=$ROW["EMAIL"];
$MOBIL_NO_HIDDEN=$ROW["MOBIL_NO_HIDDEN"];
$query1 = "SELECT * from USER_PRIV where USER_PRIV='$USER_PRIV'";
$cursor1= exequery($connection,$query1);
if($ROW=mysql_fetch_array($cursor1))
$USER_PRIV=$ROW["PRIV_NAME"];
$query1 = "SELECT * from DEPARTMENT where DEPT_ID='$DEPT_ID'";
$cursor1= exequery($connection,$query1);
if($ROW=mysql_fetch_array($cursor1))
$DEPT_NAME=$ROW["DEPT_NAME"];
$DEPT_LONG_NAME=dept_long_name($DEPT_ID);
if($SEX==0)
$SEX="男";
else
$SEX="女";
if($USER_COUNT==1)
{
$DEPT_ID1=$DEPT_ID;
?>
<table border="0" cellspacing="1" width="100%" class="small" bgcolor="#000000" cellpadding="3">
<tr class="TableHeader" align="center">
<td nowrap><b>部门</b></td>
<td nowrap><b>角色</b></td>
<td nowrap><b>姓名</b></td>
<td nowrap><b>用户名</b></td>
<td nowrap><b>性别</b></td>
<td nowrap><b>单位电话</b></td>
<td nowrap><b>手机</b></td>
<td nowrap><b>电子邮件</b></td>
</tr>
<?
}
if($USER_COUNT%2==1)
$TableLine="TableLine1";
else
{
$TableLine="TableLine2";
}$DEPT_ID1=$DEPT_ID;
?>
<tr class="<?=$TableLine?>" align="center">
<td nowrap title="<?=$DEPT_LONG_NAME?>"><?=$DEPT_NAME?></td>
<td nowrap><?=$USER_PRIV?></td>
<td nowrap><a href="user.php?USER_ID=<?=$USER_ID?>" target="user_info"><?=$USER_NAME?></a></td>
<td nowrap><?=$USER_ID?></td>
<td nowrap><?=$SEX?></td>
<td nowrap><?=$TEL_NO_DEPT?></td>
<td nowrap>
<?
if($MOBIL_NO_HIDDEN!="1")
{
?>
<A href="/general/mobile_sms?TO_ID=<?=$USER_ID?>,&TO_NAME=<?=$USER_NAME?>,"><?=$MOBIL_NO?></A>
<?
}
else
{
?>
<span title="不公开" style="cursor:hand">***********</span>
<?
}
?>
</td>
<td nowrap><a href="mailto:<?=$EMAIL?>"><?=$EMAIL?></a></td>
</tr>
<?
}
if($USER_COUNT==0)
{
Message("<br>提示","没有符合条件的人员");
?>
<br>
<div align="center">
<input type="button" value="返回" class="BigButton" onClick="history.back();">
</div>
<?
exit;
}
?>
</table>
<?
Message("","共".$USER_COUNT."个符合条件的用户");
?>
<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 + -