📄 sms_show_content.php
字号:
<?php
function page( $sql, $per_page = 20 )
{
global $cur_page;
global $total_page_nums;
global $last_page;
global $next_page;
global $num;
$result = mysql_query( $sql );
$num = mysql_num_rows( $result );
$total_page_nums = ceil( $num / $per_page );
if ( $_POST[go] )
{
$cur_page = $_POST[curpage];
}
else
{
$cur_page = $_GET[cur_page];
}
if ( !isset( $cur_page ) )
{
$cur_page = 1;
}
$last_page = $cur_page - 1;
if ( $last_page < 1 )
{
$last_page = 1;
}
$next_page = $cur_page + 1;
if ( $total_page_nums < $next_page )
{
$next_page = $total_page_nums;
}
$pages = ( $cur_page - 1 ) * $per_page;
$sql .= " limit {$pages},".$per_page;
return $sql;
}
function disp( $key = "" )
{
global $cur_page;
global $total_page_nums;
global $last_page;
global $next_page;
global $num;
if ( $cur_page == 1 || $total_page_nums == 1 || $num == 0 )
{
$str_page_up = "<span style='color:999999;'>上一条</span> ";
$str_index = "<span style='color:999999;'>首条</span> ";
}
else
{
$str_page_up = "<a href='".$_SERVER['SCRIPT_NAME']."?cur_page={$last_page}&".$key."'>上一条</a> ";
$str_index = "<a href='".$_SERVER['SCRIPT_NAME']."?cur_page=1&".$key."'>首条</a> ";
}
if ( $cur_page == $total_page_nums || $total_page_nums == 1 || $num == 0 )
{
$str_page_down = "<span style='color:999999;'>下一条</span> ";
$str_end = "<span style='color:999999;'>末条</span>";
}
else
{
$str_page_down = "<a href='".$_SERVER['SCRIPT_NAME']."?cur_page={$next_page}&".$key."'>下一条</a> ";
$str_end = "<a href='".$_SERVER['SCRIPT_NAME']."?cur_page={$total_page_nums}&".$key."'>末条</a>";
}
$control .= $str_index;
$control .= $str_page_up;
$control .= $str_page_down;
$control .= $str_end;
echo $control;
}
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
if ( !$_REQUEST['cur_page'] )
{
$cur_page = 1;
}
else
{
$cur_page = $_REQUEST['cur_page'];
}
echo "<html>\r\n<head>\r\n<title>短信提醒</title>\r\n</head>\r\n\r\n";
$connection = openconnection( );
$CUR_TIME = date( "Y-m-d H:i:s", time( ) );
$query = "SELECT * from SMS where TO_ID='{$LOGIN_USER_ID}' and REMIND_FLAG='1' and SEND_TIME<='{$CUR_TIME}' order by SEND_TIME";
$query = page( $query, 1 );
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$SMS_ID = $ROW['SMS_ID'];
$FROM_ID = $ROW['FROM_ID'];
$SEND_TIME = $ROW['SEND_TIME'];
$SMS_TYPE = $ROW['SMS_TYPE'];
$CONTENT = $ROW['CONTENT'];
$REMIND_FLAG = $ROW['REMIND_FLAG'];
if ( $REMIND_FLAG == "0" )
{
$REMIND_FLAG = "否";
}
else
{
$REMIND_FLAG = "是";
}
$query1 = "SELECT * from USER where USER_ID='{$FROM_ID}'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$FROM_NAME = $ROW['USER_NAME'];
$DEPT_ID = $ROW['DEPT_ID'];
$DEPT_NAME = dept_long_name( $DEPT_ID );
$AVATAR = $ROW['AVATAR'];
}
$CONTENT = str_replace( "<", "<", $CONTENT );
$CONTENT = str_replace( ">", ">", $CONTENT );
$CONTENT = stripslashes( $CONTENT );
switch ( $SMS_TYPE )
{
case "0" :
$SMS_TYPE_NAME = "个人短信";
break;
case "1" :
$SMS_TYPE_NAME = "公告通知提醒";
break;
case "2" :
$SMS_TYPE_NAME = "邮件提醒";
break;
case "3" :
$SMS_TYPE_NAME = "网络会议提醒";
break;
case "4" :
$SMS_TYPE_NAME = "工资上报提醒";
break;
case "5" :
$SMS_TYPE_NAME = "日程安排提醒";
break;
case "6" :
$SMS_TYPE_NAME = "考勤批示提醒";
break;
case "7" :
$SMS_TYPE_NAME = "工作流提醒";
break;
case "8" :
$SMS_TYPE_NAME = "会议申请提醒";
break;
case "9" :
$SMS_TYPE_NAME = "车辆申请提醒";
}
}
echo "<s";
echo "cript>\r\nTimeStart\t= 10;\r\ntimer2\t\t= null;\r\n\r\nfunction MyTimer()\r\n{\r\n\tif(TimeStart == 0)\r\n\t\tparent.window.close();\r\n\r\n\tparent.TimeShow.innerHTML\t= TimeStart--;\r\n}\r\n</script>\r\n\r\n<body onLoad=\"timer2=window.setInterval('MyTimer()', 1000);\" onmousemove=\"window.clearInterval(timer2);\" onmouseout=\"timer2=window.setInterval('MyTimer()', 1000);\" style=\"background-color: transparent\" class=\"bodycolor\" topmarg";
echo "in=\"0\" leftmargin=\"0\">\r\n<table border=\"0\" width=\"100%\" cellpadding=\"0\" cellspacing=\"1\" align=\"center\">\r\n\t<tr class=\"tablehead2\">\r\n\t\t<td>\r\n\t\t<a href=\"sms_submit.php?SMS_ID=";
echo $SMS_ID;
echo "&DEL=0'\"><img src=\"/images/button/iknow.gif\" alt=\"我知道了\" border=\"0\"></a>\r\n\t\t";
if ( $SMS_TYPE < 3 )
{
echo "\t\t<a href=\"sms_submit.php?SMS_ID=";
echo $SMS_ID;
echo "&DEL=0&TO_ID=";
echo $FROM_ID;
echo "&TO_NAME=";
echo $FROM_NAME;
echo "\"><img src=\"/images/button/replysms.gif\" alt=\"回复短信\" border=\"0\"></a>\r\n\t\t";
}
echo "\t\t<a href=\"sms_submit.php?SMS_ID=";
echo $SMS_ID;
echo "&DEL=1\"><img src=\"/images/button/delsms.gif\" alt=\"删除短信\" border=\"0\"></a>\r\n\t\t</td>\r\n\t</tr>\r\n</table>\r\n<table border=\"0\" width=\"100%\" cellpadding=\"3\" cellspacing=\"1\">\r\n <tr>\r\n <td align=\"center\" nowrap width=50 class=\"TableLine2\"><b>类别</b></td>\r\n <td class=\"TableLine1\">\r\n <b>";
echo $SMS_TYPE_NAME;
echo "</b>\r\n </td>\r\n <td align=\"center\" nowrap width=50 class=\"TableLine2\"><b>来自</b></td>\r\n <td nowrap class=\"TableLine1\"><u title=\"部门：";
echo $DEPT_NAME;
echo "\" style=\"cursor:hand\">";
echo $FROM_NAME;
echo "</u></td>\r\n </tr>\r\n <tr>\r\n <td align=\"center\" nowrap width=50 class=\"TableLine2\"><b>时间</td>\r\n <td nowrap colspan=\"3\" class=\"TableLine1\">";
echo $SEND_TIME;
echo "</td>\r\n </tr>\r\n <tr>\r\n <td align=\"center\" nowrap width=50 class=\"TableLine2\" valign=\"top\"><b>内容</b></td>\r\n <td colspan=\"3\" class=\"TableLine1\">\r\n <textarea cols=\"30\" name=\"CONTENT\" rows=\"4\" readonly class=\"BigInput\" wrap=\"on\">";
echo $CONTENT;
echo " </textarea>\r\n </td>\r\n </tr>\r\n\t<tr>\r\n\t\t<td align='center' class=\"TableLine2\" colspan='4'>";
disp( "CUR_TIME=".$CUR_TIME );
echo "</td>\r\n\t</tr>\r\n</table>\r\n";
if ( 0 < ( $n = $_REQUEST['cur_page'] - $total_page_nums ) )
{
$cur_page = $_REQUEST['cur_page'] - $n;
header( "location:".$_SERVER['PHP_SELF']."?&cur_page=".$cur_page );
}
echo "</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -