📄 index.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
$CUR_TIME = date( "Y-m-d H:i:s", time( ) );
$ITEMS_IN_PAGE = 15;
if ( !isset( $start ) )
{
$start = 0;
}
echo "\r\n<html>\r\n<head>\r\n<title>短信息</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n<link rel=\"stylesheet\" type=\"text/css\" href=\"/theme/";
echo $LOGIN_THEME;
echo "/sms.css\">\r\n<script src=\"/inc/mytable.js\"></script>\r\n<script Language=JavaScript>\r\nwindow.setTimeout('this.location.reload();',60000);\r\nfunction show_msg(SMS_ID, start)\r\n{\r\n\tif(\$('tr'+SMS_ID).style.display=='block')\r\n\t{\r\n\t \$('tr'+SMS_ID).style.display='none'\r\n\t \$('img'+SMS_ID).src=\"/images/collapsed.gif\";\r\n\t return;\r\n\t}\r\n\t\$('tr'+SMS_ID).style.display='block';\r\n\t\$('img'+SMS_ID).src=\"/images/expanded.gif\";\r\n\tif(\$('msg'+SMS_ID).innerHTML.toLowerCase().indexOf(\"</div>\")>0)\r\n\t return;\r\n\t\r\n\t\$('msg'+SMS_ID).innerHTML=\"<img src='/images/loading.gif' height='20' width='20' align='absMiddle'> 加载中，请稍候……\";\r\n\r\n\tvar req=getXMLHttpObj();\r\n\treq.open(\"GET\",\"../show_msg.php?SMS_ID=\"+SMS_ID+\"&start=\"+start,true);\r\n\treq.onreadystatechange=function(){if(req.readyState==4)\$(\"msg\"+SMS_ID).innerHTML=req.responseText;};\r\n\treq.send(null);\r\n}\r\nfunction delete_all(DEL_TYPE)\r\n{\r\n if(DEL_TYPE==1)\r\n msg=\"确认要删除所有已接收的短信息吗？\";\r\n else\r\n msg=\"确认要删除所有已发送的短信息吗？\";\r\n if(window.confirm(msg))\r\n {\r\n URL=\"../delete_all.php?CUR_TIME=";
echo $CUR_TIME;
echo "&DEL_TYPE=\"+DEL_TYPE;\r\n window.location=URL;\r\n }\r\n}\r\nfunction check_all()\r\n{\r\n for (i=0;i<document.all(\"email_select\").length;i++)\r\n {\r\n if(document.all(\"allbox\").checked)\r\n document.all(\"email_select\").item(i).checked=true;\r\n else\r\n document.all(\"email_select\").item(i).checked=false;\r\n }\r\n\r\n if(i==0)\r\n {\r\n if(document.all(\"allbox\").checked)\r\n document.all(\"email_select\").checked=true;\r\n else\r\n document.all(\"email_select\").checked=false;\r\n }\r\n}\r\n\r\nfunction check_one(el)\r\n{\r\n if(!el.checked)\r\n document.all(\"allbox\").checked=false;\r\n}\r\n\r\nfunction get_checked()\r\n{\r\n delete_str=\"\";\r\n for(i=0;i<document.all(\"email_select\").length;i++)\r\n {\r\n\r\n el=document.all(\"email_select\").item(i);\r\n if(el.checked)\r\n { val=el.value;\r\n delete_str+=val + \",\";\r\n }\r\n }\r\n\r\n if(i==0)\r\n {\r\n el=document.all(\"email_select\");\r\n if(el.checked)\r\n { val=el.value;\r\n delete_str+=val + \",\";\r\n }\r\n }\r\n return delete_str;\r\n}\r\nfunction delete_mail()\r\n{\r\n delete_str=get_checked();\r\n if(delete_str==\"\")\r\n {\r\n alert(\"要删除短消息，请至少选择其中一条。\");\r\n return;\r\n }\r\n\r\n msg='确认要删除所选短消息么？';\r\n if(window.confirm(msg))\r\n {\r\n form_delete.DELETE_STR.value=delete_str;\r\n form_delete.submit();\r\n }\r\n}\r\nfunction read_status(BODY_ID)\r\n{\r\n URL=\"read_status.php?BODY_ID=\"+BODY_ID+\"&start=";
echo $start;
echo "\";\r\n myleft=(screen.availWidth-400)/2;\r\n mytop=250\r\n mywidth=400;\r\n myheight=300;\r\n window.open(URL,\"read\",\"height=\"+myheight+\",width=\"+mywidth+\",status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=\"+mytop+\",left=\"+myleft+\",resizable=yes\");\r\n}\r\nfunction delete_readed()\r\n{\r\n if(window.confirm(\"确认要删除所有已提醒收信人的短信息吗？\"))\r\n {\r\n window.location=\"delete.php?start=";
echo $start;
echo "\";\r\n }\r\n}\r\nfunction delete_sms(DEL_TYPE)\r\n{\r\n if(window.confirm(\"确认要删除所有收信人已删除的短信息吗？\"))\r\n {\r\n window.location=\"delete_sms.php?start=";
echo $start;
echo "\";\r\n }\r\n}\r\n</script>\r\n\r\n</head>\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n\r\n";
if ( !isset( $TOTAL_ITEMS ) )
{
$query = "SELECT count(*) from SMS,SMS_BODY where SMS.BODY_ID=SMS_BODY.BODY_ID and FROM_ID='".$LOGIN_USER_ID."' and SEND_TIME<='{$CUR_TIME}' and DELETE_FLAG!='2' group by SMS.BODY_ID";
$cursor = exequery( $connection, $query );
$TOTAL_ITEMS = mysql_num_rows( $cursor );
}
if ( $TOTAL_ITEMS == 0 )
{
echo "<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/msg_fwd.gif\" WIDTH=\"16\" HEIGHT=\"16\" align=\"absmiddle\"><span class=\"big3\"> 已发送的短信息</span><br>\r\n </td>\r\n </tr>\r\n</table>\r\n<br>\r\n";
message( "", "无已发送的短信息" );
exit( );
}
$query = "SELECT SMS_ID,FROM_ID,SEND_TIME,SMS_TYPE,CONTENT,REMIND_FLAG,DELETE_FLAG,SMS_BODY.BODY_ID,USER_NAME,AVATAR from SMS,SMS_BODY,USER where SMS.BODY_ID=SMS_BODY.BODY_ID and USER.USER_ID=SMS.TO_ID and FROM_ID='".$LOGIN_USER_ID."' and SEND_TIME<='{$CUR_TIME}' and DELETE_FLAG!='2' group by SMS.BODY_ID order by SEND_TIME desc limit {$start},{$ITEMS_IN_PAGE}";
$cursor = exequery( $connection, $query );
echo "\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/msg_fwd.gif\" WIDTH=\"16\" HEIGHT=\"16\" align=\"absmiddle\"><span class=\"big3\"> 已发送的短信息</span>\r\n </td>\r\n\r\n <td align=\"center\" class=\"small1\">\r\n 共<span class=\"big4\"> ";
echo $TOTAL_ITEMS;
echo "</span> 条短信息\r\n </td>\r\n <td align=\"right\" valign=\"bottom\" class=\"small1\">";
echo page_bar( $start, $TOTAL_ITEMS, $ITEMS_IN_PAGE );
echo "</td>\r\n </tr>\r\n</table>\r\n\r\n\r\n<table class=\"TableList\" width=\"100%\">\r\n <tr class=\"TableHeader\">\r\n <td nowrap align=\"center\">选</td>\r\n <td nowrap align=\"center\">收信人</td>\r\n <td nowrap align=\"center\">内容</td>\r\n <td nowrap align=\"center\">发送时间 <img border=0 src=\"/images/arrow_down.gif\" width=\"11\" height=\"10\"></td>\r\n <td nowrap align=\"center\">状态</td>\r\n <td nowrap align=\"center\">操作</td>\r\n </tr>\r\n";
$SMS_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$SMS_COUNT;
$SMS_ID = $ROW['SMS_ID'];
$TO_ID = $ROW['TO_ID'];
$SEND_TIME = $ROW['SEND_TIME'];
$SMS_TYPE = $ROW['SMS_TYPE'];
$CONTENT = $ROW['CONTENT'];
$TO_NAME = $ROW['USER_NAME'];
$AVATAR = $ROW['AVATAR'];
$REMIND_FLAG = $ROW['REMIND_FLAG'];
$DELETE_FLAG = $ROW['DELETE_FLAG'];
$BODY_ID = $ROW['BODY_ID'];
$CONTENT = htmlspecialchars( $CONTENT );
$SMS_ID_STR = "";
$query = "select SMS_ID from SMS where BODY_ID='".$BODY_ID."' and DELETE_FLAG!='2'";
$cursor1 = exequery( $connection, $query );
$GROUP_COUNT = mysql_num_rows( $cursor1 );
if ( 1 < $GROUP_COUNT )
{
while ( $ROW1 = mysql_fetch_array( $cursor1 ) )
{
$SMS_ID_STR .= $ROW1['SMS_ID'].",";
}
$SMS_ID_STR = substr( $SMS_ID_STR, 0, -1 );
}
if ( $SMS_ID_STR == "" )
{
$SMS_ID_STR = $SMS_ID;
}
if ( $DELETE_FLAG == "0" )
{
if ( $REMIND_FLAG == "0" )
{
$REMIND_IMG = "<img src=\"/images/email_open.gif\" title=\"收信人已读\">";
}
else
{
$REMIND_IMG = "<img src=\"/images/email_new.gif\" title=\"收信人未读\">";
}
}
else
{
$REMIND_IMG = "<img src=\"/images/email_delete.gif\" title=\"收信人已删除\">";
}
$SMS_TYPE_NAME = get_code_name( $SMS_TYPE, "SMS_REMIND" );
if ( $SMS_COUNT % 2 == 1 )
{
$TableLine = "TableLine1";
}
else
{
$TableLine = "TableLine2";
}
echo " <tr class=\"";
echo $TableLine;
echo "\">\r\n <td> <input type=\"checkbox\" name=\"email_select\" value=\"";
echo $SMS_ID_STR;
echo "\" onClick=\"check_one(self);\"></td>\r\n <td nowrap align=\"center\">\r\n";
if ( 1 < $GROUP_COUNT )
{
echo " <a href=\"javascript:read_status('";
echo $BODY_ID;
echo "');\">查看</a>\r\n";
}
else
{
echo " ";
echo $TO_NAME;
}
echo " </td>\r\n <td>\r\n";
if ( $SMS_TYPE == "0" )
{
if ( $GROUP_COUNT == 1 )
{
echo " <img src=\"/images/collapsed.gif\" align=\"absMiddle\" title=\"点击展开消息记录\" onclick=\"show_msg(";
echo $SMS_ID;
echo ");\" style=\"cursor:hand;\" id=\"img";
echo $SMS_ID;
echo "\">\r\n";
}
echo " <img src=\"/images/avatar/";
echo $AVATAR;
echo ".gif\" align=\"absMiddle\" ";
echo avatar_size( $AVATAR );
echo " alt=\"";
echo $SMS_TYPE_NAME;
echo "\">\r\n";
}
else
{
echo " <img src=\"/images/sms_type";
echo $SMS_TYPE;
echo ".gif\" align=\"absMiddle\" width=\"20\" height=\"20\" alt=\"";
echo $SMS_TYPE_NAME;
echo "\">\r\n";
}
echo " ";
echo $CONTENT;
echo " </td>\r\n <td align=\"center\">";
echo $SEND_TIME;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $REMIND_IMG;
echo "</td>\r\n <td nowrap>\r\n";
$query1 = "select SMS2_REMIND_PRIV from SMS2_PRIV";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$SMS2_REMIND_PRIV = $ROW['SMS2_REMIND_PRIV'];
}
if ( $TO_ID != $LOGIN_USER_ID && find_id( $SMS2_REMIND_PRIV, $LOGIN_USER_ID ) )
{
echo " <a href=\"javascript:parent.location='send_mobile_sms.php?SMS_ID=";
echo $SMS_ID;
echo "'\"> 手机短信</a> \r\n";
}
echo " <a href=\"../new/?SMS_ID=";
echo $SMS_ID;
echo "\"> 转发</a>\r\n";
if ( $REMIND_FLAG == 0 )
{
echo " <a href=\"resend.php?SMS_ID=";
echo $SMS_ID;
echo "\"> 重发</a>\r\n";
}
echo " </td>\r\n </tr>\r\n";
if ( $SMS_TYPE == "0" )
{
echo " <tr id=\"tr";
echo $SMS_ID;
echo "\" style=\"display:none;\" class=\"TableData\"><td colspan=\"6\"><div id=\"msg";
echo $SMS_ID;
echo "\" class=\"msg\"></div></td></tr>\r\n";
}
}
echo "\r\n<tr class=\"TableControl\">\r\n<td colspan=\"7\"> <input type=\"checkbox\" name=\"allbox\" id=\"allbox_for\" onClick=\"check_all();\">\r\n <label for=\"allbox_for\">全选</label> \r\n <a href=\"javascript:delete_mail();\" title=\"删除所选短消息\"><img src=\"/images/delete.gif\" align=\"absMiddle\">删除</a> \r\n</td>\r\n</tr>\r\n</table>\r\n<br>\r\n<table class=\"TableBlock\" width=\"100%\" align=\"center\">\r\n <tr>\r\n <td class=\"TableContent\" nowrap align=\"center\" width=\"80\"><b>快捷操作：</b></td>\r\n <td class=\"TableControl\" nowrap> \r\n <a href=\"javascript:delete_readed();\" title=\"\"><img src=\"/images/delete.gif\" align=\"absMiddle\">删除已提醒收信人短信</a> \r\n <a href=\"javascript:delete_sms();\" title=\"\"><img src=\"/images/delete.gif\" align=\"absMiddle\">删除收信人已删除短信</a> \r\n <a href=\"javascript:delete_all(2);\" title=\"删除所有已发送的短信息\"><img src=\"/images/delete.gif\" align=\"absMiddle\">全部删除</a> \r\n </td>\r\n </tr>\r\n</table>\r\n<form name=\"form_delete\" action=\"../delete.php\" method=\"post\">\r\n <input type=\"hidden\" name=\"DELETE_STR\" value=\"\">\r\n <input type=\"hidden\" name=\"DEL_TYPE\" value=\"2\">\r\n <input type=\"hidden\" name=\"start\" value=\"";
echo $start;
echo "\">\r\n</form>\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -