📄 search.php
字号:
<?
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 check_all()
{
for (i=0;i<document.all("email_select").length;i++)
{
if(document.all("allbox").checked)
document.all("email_select").item(i).checked=true;
else
document.all("email_select").item(i).checked=false;
}
if(i==0)
{
if(document.all("allbox").checked)
document.all("email_select").checked=true;
else
document.all("email_';
echo 'select").checked=false;
}
}
function check_one(el)
{
if(!el.checked)
document.all("allbox").checked=false;
}
function delete_mail()
{
delete_str="";
for(i=0;i<document.all("email_select").length;i++)
{
el=document.all("email_select").item(i);
if(el.checked)
{ val=el.value;
delete_str+=val + ",";
}
}
if(i==0)
{
';
echo 'el=document.all("email_select");
if(el.checked)
{ val=el.value;
delete_str+=val + ",";
}
}
if(delete_str=="")
{
alert("要删除手机短信，请至少选择其中一条。");
return;
}
msg=\'确认要删除所选手机短信么？\';
if(window.confirm(msg))
{
url="delete_sms.php?DELETE_STR="+ delete_str;
location=url;
}
}
</script>
</head>
<bod';
echo 'y class="bodycolor" topmargin="5">
';
if (($BEGIN_DATE != ''))
{
$TIME_OK = is_date_time ($BEGIN_DATE);
if (!$TIME_OK)
{
message ('错误', '起始时间格式不对，应形如 1999-1-2 14:55:20');
button_back ();
exit ();
}
}
if (($END_DATE != ''))
{
$TIME_OK = is_date_time ($END_DATE);
if (!$TIME_OK)
{
message ('错误', '截止时间格式不对，应形如 1999-1-2 14:55:20');
button_back ();
exit ();
}
}
if (($BEGIN_DATE == ''))
{
$query = (((''.'SELECT * from SMS2 where SEND_TIME<=\'').$END_DATE).'\'');
}
else
{
if (($END_DATE == ''))
{
$query = (((''.'SELECT * from SMS2 where SEND_TIME>=\'').$BEGIN_DATE).'\'');
}
else
{
$query = (((((''.'SELECT * from SMS2 where SEND_TIME>=\'').$BEGIN_DATE).'\' and SEND_TIME<=\'').$END_DATE).'\'');
}
}
if (($SEND_FLAG != 'ALL'))
{
($query .= (((''.' and SEND_FLAG=\'').$SEND_FLAG).'\''));
}
($query .= (((''.' and FROM_ID=\'').$LOGIN_USER_ID).'\''));
if (($PHONE != ''))
{
($query .= (((''.' and PHONE like \'%').$PHONE).'%\''));
}
if (($CONTENT != ''))
{
($query .= (((''.' and CONTENT like \'%').$CONTENT).'%\''));
}
if (($DELETE_FLAG == 1))
{
$query = (str_replace ('SELECT * from', 'delete from', $query).' and SEND_FLAG!=\'1\'');
exequery ($connection, $query);
message ('提示', '指定范围内的手机短信记录已删除！');
button_back ();
exit ();
}
echo '
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/menu/mobile_sms.gif" WIDTH="22" HEIGHT="20" align="absmiddle">';
echo '<s';
echo 'pan class="big3"> 短信发送查询结果 （最多显示500条记录）</span>
<input type="button" class="BigButton" value="刷新" onclick="location.reload();">
</td>
</tr>
</table>
';
$query1 = 'select * from USER where MOBIL_NO<>\'\'';
$cursor = exequery ($connection, $query1);
while ($ROW = mysql_fetch_array ($cursor))
{
$USER_NAME = $ROW['USER_NAME'];
$MOBIL_NO = $ROW['MOBIL_NO'];
$MOBIL_NO_HIDDEN = $ROW['MOBIL_NO_HIDDEN'];
$PHONE_ARRAY[$MOBIL_NO][0] = $USER_NAME;
$PHONE_ARRAY[$MOBIL_NO][1] = $MOBIL_NO_HIDDEN;
}
($query .= ' order by SEND_TIME desc,SMS_ID desc');
$cursor = exequery ($connection, $query);
$SMS_COUNT = 0;
while ($ROW = mysql_fetch_array ($cursor))
{
++$SMS_COUNT;
if ((500 < $SMS_COUNT))
{
break;
}
$SMS_ID = $ROW['SMS_ID'];
$PHONE = $ROW['PHONE'];
$CONTENT = $ROW['CONTENT'];
$SEND_TIME = $ROW['SEND_TIME'];
$SEND_FLAG = $ROW['SEND_FLAG'];
switch ($SEND_FLAG)
{
case '0':
{
$SEND_FLAG_DESC = '未发送';
break;
}
case '1':
{
$SEND_FLAG_DESC = '发送成功';
break;
}
case '2':
{
$SEND_FLAG_DESC = '发送失败';
break;
}
}
if (($SMS_COUNT == 1))
{
echo ' <table border="0" cellspacing="1" width="100%" class="small" bgcolor="#000000" cellpadding="3">
<tr 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">发送时间 <img border=0 src="/images/arrow_down.gif" width="11" ';
echo 'height="10"></td>
<td nowrap align="center">状态</td>
</tr>
';
}
if ((($SMS_COUNT % 2) == 1))
{
$TableLine = 'TableLine1';
}
else
{
$TableLine = 'TableLine2';
}
echo ' <tr class="';
echo $TableLine;
echo '">
<td> ';
if (($SEND_FLAG != '1'))
{
echo '<input type="checkbox" name="email_select" value="';
echo $SMS_ID;
echo '" onClick="check_one(self);">';
}
echo '</td>
<td nowrap align="center">';
echo $PHONE_ARRAY[$PHONE][0];
echo ' <td nowrap align="center">';
if (($PHONE_ARRAY[$PHONE][1] == 0))
{
echo $PHONE;
}
else
{
echo '不公开';
}
echo '</td>
<td>';
echo $CONTENT;
echo '</td>
<td nowrap align="center">';
echo $SEND_TIME;
echo '</td>
<td nowrap align="center">';
echo $SEND_FLAG_DESC;
echo '</td>
</tr>
';
}
if (($SMS_COUNT == 0))
{
message ('', '无符合条件的手机短信记录');
}
else
{
echo '<s';
echo 'cript>
if(document.all("email_select"))
{
document.write("<tr class=\'TableControl\'><td colspan=\'7\'> <input type=\'checkbox\' name=\'allbox\' id=\'allbox_for\' onClick=\'check_all();\'><label for=\'allbox_for\'>全选</label> <input type=\'button\' value=\'删除\' class=\'SmallButton\' onClick=\'delete_mail();\' title=\'删除所选手机短信\'></td></tr>");
document.close();
}
</script>
</table>
';
message ('', (((''.'共 ').$SMS_COUNT).' 条记录'));
}
button_back ();
echo '
</body>
</html>
';
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -