📄 mylist.php

📁 泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5自动注册文件。
💻 PHP
字号:
<?php

function getusername( $userid )
{
	global $connection;
	$sql = "SELECT USER_NAME FROM user WHERE USER_ID='{$userid}'";
	$rs = exequery( $connection, $sql );
	$row = mysql_fetch_array( $rs );
	$username = $row['USER_NAME'];
	return $username;
}

include_once( "inc/auth.php" );
include_once( "inc/function_page_01.php" );
include_once( "ikernel/utility.php" );
include_once( "inc/utility_all.php" );
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</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n\r\n\r\n<table border=\"0\" width=\"100%\" cellspacing=\"1\" cellpadding=\"0\" class=\"small\">\r\n  <tr>\r\n    <td class=\"tablehead1\"><img src=\"/images/menu/mobile_sms.gif\" align=\"absmiddle\">  接收的手机短信</td>\r\n  <tr class=\"tableline2\">\r\n\t<td><a href=\"myquery.ph";
echo "p\"><img src=\"/images/button/searchsms.gif\" border=\"0\" title=\"短信查询\"></a>\r\n\t<a href=\"mylist.php\"><img src=\"/images/button/inceptsms.gif\" border=0></a> <a href=\"mylist_send.php\"><img src=\"/images/button/sendendsms.gif\" border=0></a></td>\r\n  </tr>\r\n</table>\r\n<br>\r\n<table border=\"0\" cellspacing=\"1\" width=\"100%\" class=\"small\" cellpadding=\"5\">\r\n<form action=\"do.php\" method=\"get\" name=\"smsform\">\r\n  <tr class=\"TableH";
echo "eader\">\r\n    ";
$sens = $_REQUEST['sens'] ? 0 : 1;
$sensimg = $_REQUEST['sens'] ? "arrow_up.gif" : "arrow_down.gif";
$sensimg = "/images/".$sensimg;
$sufurl = $_SERVER['PHP_SELF']."?sens=".$sens;
echo "    <td width=\"15%\" nowrap ><a href=\"";
echo $sufurl;
echo "&order=fromid\">发送人</a>/<a href=\"";
echo $sufurl;
echo "&order=fromno\">手机号</a>\r\n        ";
if ( $_REQUEST['order'] == "fromno" || $_REQUEST['order'] == "fromid" )
{
	echo "<img src='".$sensimg."'>";
}
echo "</td>\r\n    <td nowrap ><a href=\"";
echo $sufurl;
echo "&order=content\">短信内容</a>\r\n        ";
if ( $_REQUEST['order'] == "content" )
{
	echo "<img src='".$sensimg."'>";
}
echo "</td>\r\n    <td  width=\"15%\" ><a href=\"";
echo $sufurl;
echo "&order=date\">接收时间</a>\r\n        ";
if ( $_REQUEST['order'] == "date" )
{
	echo "<img src='".$sensimg."'>";
}
echo "</td>\r\n    </tr>\r\n  ";
$sql = "SELECT * FROM sms_tb_msg stm,sms_msg_log sml WHERE stm.RegID=sml.REGID AND sml.TO_ID LIKE '".$_SESSION['LOGIN_USER_ID']."' AND Msg_Status<>'R'";
switch ( $_REQUEST['order'] )
{
case "status" :
	$sql .= " ORDER BY stm.Msg_Status";
	break;
case "fromno" :
	$sql .= " ORDER BY sml.FROM_NO";
	break;
case "fromid" :
	$sql .= " ORDER BY sml.FROM_ID";
	break;
case "tono" :
	$sql .= " ORDER BY sml.TO_NO";
	break;
case "toid" :
	$sql .= " ORDER BY sml.TO_ID";
	break;
case "content" :
	$sql .= " ORDER BY stm.Content";
	break;
case "date" :
	$sql .= " ORDER BY sml.SEND_TIME";
	break;
default :
	$sql .= " ORDER BY stm.RegID";
	break;
}
$sql .= $_REQUEST['sens'] ? " ASC" : " DESC";
$sql = page( $sql, 10 );
$rs = exequery( $connection, $sql );
$msmsc = 0;
while ( $row = mysql_fetch_array( $rs ) )
{
	$RegID = $row['RegID'];
	$From_Mobile = $row['FROM_NO'];
	$To_Mobile = $row['TO_NO'];
	$Content = $row['Content'];
	$Finish_DateTime = $row['SEND_TIME'];
	$Msg_Status = $row['Msg_Status'];
	$FROM_ID = $row['FROM_ID'];
	$TO_ID = $row['TO_ID'];
	$FROM_NAME = getusername( $FROM_ID );
	$TO_NAME = getusername( $TO_ID );
	if ( $Finish_DateTime == "" )
	{
		$strDate = "";
	}
	else
	{
		$strDate = date( "Y-m-d H:i:s", strtotime( $Finish_DateTime ) );
	}
	switch ( $Msg_Status )
	{
	case "Y" :
		$strMsgSt = "已发";
		break;
	case "R" :
		$strMsgSt = "接收";
		break;
	case "N" :
		$strMsgSt = "待发";
		break;
	case "F" :
		$strMsgSt = "无效";
		break;
	default :
		$strMsgSt = "未知";
	}
	++$msmsc;
	if ( $msmsc % 2 == 1 )
	{
		$TableLine = "TableLine1";
	}
	else
	{
		$TableLine = "TableLine2";
	}
	echo "  <tr class=\"";
	echo $TableLine;
	echo "\">\r\n    <td>";
	echo $FROM_NAME;
	echo $From_Mobile;
	echo "</td>\r\n\r\n    <td>";
	echo $Content;
	echo "</td>\r\n    <td>";
	echo $strDate;
	echo "</td>\r\n\t</tr>\r\n  ";
}
echo "</form>\r\n</table>\r\n<table width=\"100%\"  border=\"0\" cellspacing=\"2\" cellpadding=\"2\">\r\n  <tr>\r\n    <td align=\"right\">";
disp( "sens=".$_REQUEST['sens']."&order=".$_REQUEST['order'] );
echo "</td>\r\n  </tr>\r\n</table>\r\n</body>\r\n</html>\r\n\r\n";
if ( 0 < ( $n = $_REQUEST['cur_page'] - $total_page_nums ) )
{
	$cur_page = $_REQUEST['cur_page'] - $n;
	header( "location:".$_SERVER['PHP_SELF']."?&order=".$_REQUEST['order']."&sens=".$_REQUEST['sens']."&cur_page=".$cur_page );
}
?>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -