search.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 182 行
PHP
182 行
<?
include_once 'inc/auth.php';
include_once 'inc/utility_all.php';
$ITEMS_IN_PAGE = 20;
if (!isset ($start))
{
$start = 0;
}
echo '
<html>
<head>
<title>人员查询结果 </title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
echo '<s';
echo 'cript src="/inc/sort_table.js"></script>
</head>
<body class="bodycolor" topmargin="5" onload="SortTable(\'beSortTable\');">
';
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_PRIV.USER_PRIV=USER.USER_PRIV and USER.DEPT_ID!=0 and NOT_LOGIN!=1 '.$WHERE_STR);
$query = ('SELECT count(*) from USER,DEPARTMENT,USER_PRIV '.$WHERE_STR);
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$USER_COUNT = $ROW[0];
}
echo '<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td align="right" valign="bottom" class="small1">共';
echo $USER_COUNT;
echo '条记录 ';
echo page_bar ($start, $USER_COUNT, $ITEMS_IN_PAGE);
echo '</td>
</tr>
</table>
';
$USER_COUNT = 0;
$query = (('SELECT * from USER,DEPARTMENT,USER_PRIV '.$WHERE_STR).((((''.' order by DEPT_NO,PRIV_NO,USER_NO,USER_NAME limit ').$start).',').$ITEMS_IN_PAGE));
$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'];
$USER_PRIV = $ROW['PRIV_NAME'];
$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;
echo '<table id="beSortTable" 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>电';
echo '子邮件</b></td>
</tr>
';
}
if ((($USER_COUNT % 2) == 1))
{
$TableLine = 'TableLine1';
}
else
{
$TableLine = 'TableLine2';
}
$DEPT_ID1 = $DEPT_ID;
echo ' <tr class="';
echo $TableLine;
echo '" align="center">
<td nowrap title="';
echo $DEPT_LONG_NAME;
echo '">';
echo $DEPT_NAME;
echo '</td>
<td nowrap>';
echo $USER_PRIV;
echo '</td>
<td nowrap><a href="user.php?USER_ID=';
echo $USER_ID;
echo '" target="user_info">';
echo $USER_NAME;
echo '</a></td>
<td nowrap>';
echo $USER_ID;
echo '</td>
<td nowrap>';
echo $SEX;
echo '</td>
<td nowrap>';
echo $TEL_NO_DEPT;
echo '</td>
<td nowrap>
';
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 nowrap><a href="mailto:';
echo $EMAIL;
echo '">';
echo $EMAIL;
echo '</a></td>
</tr>
';
}
if (($USER_COUNT == 0))
{
message ('<br>提示', '没有符合条件的人员');
echo '<br>
<div align="center">
<input type="button" value="返回" class="BigButton" onClick="history.back();">
</div>
';
exit ();
}
echo '
</table>
<br>
<div align="center">
<input type="button" value="返回" class="BigButton" onClick="location=\'query.php\'">
</div>
</body>
</html>';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?