📄 search_submit.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/check_type.php");
?>
<html>
<head>
<title>联系人查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script>
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;
window.location=URL;
}
}
function check_all()
{
for (i=0;i<document.all("address_select").length;i++)
{
if(allbox.checked)
document.all("address_select").item(i).checked=true;
else
document.all("address_select").item(i).checked=false;
}
if(i==0)
{
if(allbox.checked)
document.all("address_select").checked=true;
else
document.all("address_select").checked=false;
}
}
function check_one(el)
{
if(!el.checked)
allbox.checked=false;
}
function delete_address()
{
delete_str="";
for(i=0;i<document.all("address_select").length;i++)
{
el=document.all("address_select").item(i);
if(el.checked)
{ val=el.value;
delete_str+=val + ",";
}
}
if(i==0)
{
el=document.all("address_select");
if(el.checked)
{ val=el.value;
delete_str+=val + ",";
}
}
if(delete_str=="")
{
alert("要删除联系人，请至少选择其中一个。");
return;
}
msg='确认要删除所选联系人么？';
if(window.confirm(msg))
{
url="delete.php?DELETE_STR="+ delete_str;
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"><span class="big3"> 查询结果</span>
</td>
</tr>
</table>
<br>
<?
//============================ 显示查询结果 =======================================
$query = "SELECT * from ADDRESS where USER_ID='$LOGIN_USER_ID'";
if($GROUP_ID!="ALL")
$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($NOTES!="")
$query .= " and NOTES like '%$NOTES%'";
$query.=" order by GROUP_ID,PSN_NAME asc";
$cursor= exequery($connection,$query);
$ADD_COUNT=0;
while($ROW=mysql_fetch_array($cursor))
{
$ADD_COUNT++;
$ADD_ID=$ROW["ADD_ID"];
$GROUP_ID=$ROW["GROUP_ID"];
$PSN_NAME=$ROW["PSN_NAME"];
$SEX=$ROW["SEX"];
$DEPT_NAME=$ROW["DEPT_NAME"];
$TEL_NO_DEPT=$ROW["TEL_NO_DEPT"];
$TEL_NO_HOME=$ROW["TEL_NO_HOME"];
$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.",";
switch($SEX)
{
case "0":
$SEX="男";
break;
case "1":
$SEX="女";
break;
}
if($ADD_COUNT==1)
{
?>
<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
<?
}
?>
<tr class="TableData">
<td> <input type="checkbox" name="address_select" value="<?=$ADD_ID?>" onClick="check_one(self);"></td>
<td nowrap align="center"><a href="javascript:add_detail('<?=$ADD_ID?>');"><?=$PSN_NAME?></a></td>
<td nowrap align="center"><?=$SEX?></td>
<td nowrap align="center"><?=$DEPT_NAME?></td>
<td nowrap align="center"><?=$TEL_NO_DEPT?></td>
<td nowrap align="center"><?=$TEL_NO_HOME?></td>
<td nowrap align="center"><A href="/general/mobile_sms?TO_ID1=<?=$MOBIL_NO?>,"><?=$MOBIL_NO?></A></td>
<td nowrap align="center"><a href="mailto:<?=$EMAIL?>"><?=$EMAIL?></a></td>
<td nowrap align="center"><?=$GROUP_NAME?></a></td>
<td nowrap align="center" width="100">
<a href="javascript:add_detail('<?=$ADD_ID?>');"> 详情</a>
<a href="edit.php?ADD_ID=<?=$ADD_ID?>"> 编辑</a>
<a href="javascript:delete_add(<?=$ADD_ID?>);"> 删除</a>
</td>
</tr>
<?
}
if($ADD_COUNT==0)
{
Message("","无符合条件的联系人");
}
else
{
?>
<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>
<td nowrap align="center">手机 <a href="javascript:form1.submit();">群发</a></td>
<td nowrap align="center">电子邮件</td>
<td nowrap align="center">组名</td>
<td nowrap align="center">操作</td>
</thead>
<tr class="TableControl">
<td colspan="10">
<table width="100%" class="small">
<tr>
<td>
<input type="checkbox" name="allbox" id="allbox_for" onClick="check_all();"><label for="allbox_for">全选</label>
<input type="button" value="删除" class="SmallButton" onClick="delete_address();">
</tr>
</table>
</td>
</tr>
<?
}
?>
</table>
<form name="form1" method="post" action="/general/mobile_sms/new/index.php">
<input type="hidden" name="TO_ID1" value="<?=$MOBIL_NO_STR?>">
</form>
<br>
<div align="center">
<input type="button" value="返回" class="BigButton" onClick="location='search.php';">
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -