search_submit.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 232 行
PHP
232 行
<?
include_once 'inc/auth.php';
include_once 'inc/check_type.php';
include_once 'inc/utility_all.php';
echo '
<html>
<head>
<title>联系人查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
echo '<s';
echo 'cript>
function add_detail(ADD_ID)
{
URL="add_detail.php?ADD_ID="+ADD_ID;
myleft=(screen.availWidth-500)/2;
window.open(URL,"detail","height=550,width=400,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=50,left="+myleft+",resizable=yes");
}
function delete_add(ADD_ID)
{
msg=\'确认要删除该联系人么？\';
if(window.confirm(msg))
{
URL="delete.php?ADD_ID=" + ADD_ID;
';
echo ' window.location=URL;
}
}
</script>
</head>
<body class="bodycolor" topmargin="5">
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/menu/address.gif" align="absmiddle">';
echo '<s';
echo 'pan class="big3"> 查询结果</span>
</td>
</tr>
</table>
<br>
';
$query = 'select * from ADDRESS_GROUP where USER_ID=\'\' order by GROUP_NAME asc';
$cursor = exequery ($connection, $query);
while ($ROW = mysql_fetch_array ($cursor))
{
$PRIV_DEPT = $ROW['PRIV_DEPT'];
$PRIV_ROLE = $ROW['PRIV_ROLE'];
$PRIV_USER = $ROW['PRIV_USER'];
if (($PRIV_DEPT != 'ALL_DEPT'))
{
if (((!find_id ($PRIV_DEPT, $LOGIN_DEPT_ID) AND !find_id ($PRIV_ROLE, $LOGIN_USER_PRIV)) AND !find_id ($PRIV_USER, $LOGIN_USER_ID)))
{
continue;
}
}
$GROUP_ID1 = $ROW['GROUP_ID'];
($GROUP_ID_STR .= ($GROUP_ID1.','));
}
$GROUP_ID_STR = ($GROUP_ID_STR.'0,');
$query = 'SELECT * from ADDRESS where USER_ID=\'\'';
if (($GROUP_ID != 'ALL_DEPT'))
{
($query .= (((''.' and GROUP_ID=\'').$GROUP_ID).'\''));
}
if (($PSN_NAME != ''))
{
($query .= (((''.' and PSN_NAME like \'%').$PSN_NAME).'%\''));
}
if (($SEX != 'ALL'))
{
($query .= (((''.' and SEX=\'').$SEX).'\''));
}
if (($NICK_NAME != ''))
{
($query .= (((''.' and NICK_NAME like \'%').$NICK_NAME).'%\''));
}
if (($DEPT_NAME != ''))
{
($query .= (((''.' and DEPT_NAME like \'%').$DEPT_NAME).'%\''));
}
if (($ADD_DEPT != ''))
{
($query .= (((''.' and ADD_DEPT like \'%').$ADD_DEPT).'%\''));
}
if (($ADD_HOME != ''))
{
($query .= (((''.' and ADD_HOME like \'%').$ADD_HOME).'%\''));
}
if (($TEL_NO_DEPT != ''))
{
($query .= (((''.' and TEL_NO_DEPT like \'%').$TEL_NO_DEPT).'%\''));
}
if (($TEL_NO_HOME != ''))
{
($query .= (((''.' and TEL_NO_HOME like \'%').$TEL_NO_HOME).'%\''));
}
if (($MOBIL_NO != ''))
{
($query .= (((''.' and MOBIL_NO like \'%').$MOBIL_NO).'%\''));
}
if (($NOTES != ''))
{
($query .= (((''.' and NOTES like \'%').$NOTES).'%\''));
}
($query .= field_where_str ('ADDRESS', $_POST, 'ADDRESS.ADD_ID'));
($query .= ' order by GROUP_ID,PSN_NAME asc');
$cursor = exequery ($connection, $query);
$ADD_COUNT = 0;
while ($ROW = mysql_fetch_array ($cursor))
{
$GROUP_ID = $ROW['GROUP_ID'];
if (!find_id ($GROUP_ID_STR, $GROUP_ID))
{
continue;
}
else
{
++$ADD_COUNT;
$ADD_ID = $ROW['ADD_ID'];
$PSN_NAME = $ROW['PSN_NAME'];
$SEX = $ROW['SEX'];
$DEPT_NAME = $ROW['DEPT_NAME'];
$TEL_NO_DEPT = $ROW['TEL_NO_DEPT'];
$MOBIL_NO = $ROW['MOBIL_NO'];
$EMAIL = $ROW['EMAIL'];
$query1 = (((''.'select * from ADDRESS_GROUP where GROUP_ID=\'').$GROUP_ID).'\'');
$cursor1 = exequery ($connection, $query1);
if ($ROW1 = mysql_fetch_array ($cursor1))
{
$GROUP_NAME = $ROW1['GROUP_NAME'];
}
if (($GROUP_ID == 0))
{
$GROUP_NAME = '默认';
}
if (($MOBIL_NO != ''))
{
($MOBIL_NO_STR .= ($MOBIL_NO.','));
}
if (($SEX == '0'))
{
$SEX = '男';
}
else
{
if (($SEX == '1'))
{
$SEX = '女';
}
else
{
$SEX = '';
}
}
if (($ADD_COUNT == 1))
{
echo '
<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
';
}
echo ' <tr class="TableData">
<td nowrap align="center"><a href="javascript:add_detail(\'';
echo $ADD_ID;
echo '\');">';
echo $PSN_NAME;
echo '</a></td>
<td nowrap align="center">';
echo $SEX;
echo '</td>
<td nowrap align="center">';
echo $DEPT_NAME;
echo '</td>
<td nowrap align="center">';
echo $TEL_NO_DEPT;
echo '</td>
<td nowrap align="center"><A href="/general/mobile_sms?TO_ID1=';
echo $MOBIL_NO;
echo ',">';
echo $MOBIL_NO;
echo '</A></td>
<td nowrap align="center"><a href="mailto:';
echo $EMAIL;
echo '">';
echo $EMAIL;
echo '</a></td>
<td nowrap align="center">';
echo $GROUP_NAME;
echo '</a></td>
<td nowrap align="center" width="100">
<a href="javascript:add_detail(\'';
echo $ADD_ID;
echo '\');"> 详情</a>
</td>
</tr>
';
continue;
}
}
if (($ADD_COUNT == 0))
{
message ('', '无符合条件的联系人');
}
else
{
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">手机 <a href="javascript:form1.submit();">群发</a></td>
<td nowrap align="center">电子邮件</td>
<td nowrap align="center">组名</td>
<td nowrap align="cen';
echo 'ter">操作</td>
</thead>
</table>
';
}
echo '<form name="form1" method="post" action="/general/mobile_sms/new/index.php">
<input type="hidden" name="TO_ID1" value="';
echo $MOBIL_NO_STR;
echo '">
</form>
<br>
<div align="center">
<input type="button" value="返回" class="BigButton" onClick="location=\'search.php\';">
</div>
</body>
</html>
';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?