search.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 168 行
PHP
168 行
<?
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">
</head>
<body class="bodycolor" topmargin="5" >
';
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 (($USER_PRIV != ''))
{
($WHERE_STR .= ((''.' and USER.USER_PRIV=').$USER_PRIV));
}
echo '<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/menu/infofind.gif" align="absmiddle">';
echo '<s';
echo 'pan 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 and NOT_LOGIN!=1 '.$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'];
$MOBIL_NO_HIDDEN = $ROW['MOBIL_NO_HIDDEN'];
++$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))
{
echo '
<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';
}
echo ' <tr class="';
echo $TableLine;
echo '">
<td nowrap align="center" title="';
echo $DEPT_LONG_NAME;
echo '"><u style="cursor:hand">';
echo $DEPT_NAME;
echo '</u></td>
<td nowrap align="center"><a href="user_info.php?USER_ID=';
echo $USER_ID;
echo '">';
echo $USER_NAME;
echo '</a></td>
<td nowrap align="center">';
echo $SEX;
echo '</td>
<td align="center">';
echo $TEL_NO_DEPT;
echo '</td>
<td align="center">
';
if (($MOBIL_NO_HIDDEN != '1'))
{
echo ' <A href="/general/mobile_sms?TO_ID=';
echo $USER_ID;
echo ',&TO_NAME=';
echo $USER_NAME;
echo ',">';
echo $MOBIL_NO;
echo '</A>
';
}
else
{
echo ' ';
echo '<s';
echo 'pan title="不公开" style="cursor:hand">***********</span>
';
}
echo ' </td>
<td align="center">';
echo $EMAIL;
echo '</td>
</tr>
';
}
if ((0 < $USER_COUNT))
{
echo ' <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 ('', '无符合条件的用户');
}
echo '
<br>
<div align="center">
<input type="button" value="返回" class="BigButton" onClick="history.back();">
</div>
</body>
</html>';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?