📄 mysearch.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>\r\n\t  <a href=\"myquery.php\">";
echo "<img src=\"/images/button/return.gif\" border=\"0\"> </a><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=\"TableHeader\">\r\n    ";
$sens = $_REQUEST['sens'] ? 0 : 1;
$sensimg = $_REQUEST['sens'] ? "arrow_up.gif" : "arrow_down.gif";
$sensimg = "/images/".$sensimg;
$valurl = "&FROM_ID=".$_REQUEST['FROM_ID']."&TO_ID=".$_REQUEST['TO_ID']."&FROM_NO=".$_REQUEST['FROM_NO']."&TO_NO=".$_REQUEST['TO_NO']."&Msg_Status=".$_REQUEST['Msg_Status']."&BEGIN_DATE=".$_REQUEST['BEGIN_DATE']."&END_DATE=".$_REQUEST['END_DATE']."&CONTENT=".$_REQUEST['CONTENT']."";
$sufurl = $_SERVER['PHP_SELF']."?sens=".$sens.$valurl;
echo "    <td width=\"7%\" nowrap ><a href=\"";
echo $sufurl;
echo "&order=status\">状态</a>\r\n        ";
if ( $_REQUEST['order'] == "status" )
{
	echo "<img src='".$sensimg."'>";
}
echo "</td>\r\n    <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 width=\"15%\" ><a href=\"";
echo $sufurl;
echo "&order=toid\">接收人</a>/<a href=\"";
echo $sufurl;
echo "&order=tono\">手机号</a>\r\n        ";
if ( $_REQUEST['order'] == "tono" || $_REQUEST['order'] == "toid" )
{
	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 ";
if ( $_REQUEST['type'] == "" )
{
	$sql .= " AND (sml.FROM_ID LIKE '".$_SESSION['LOGIN_USER_ID']."' OR  sml.TO_ID LIKE '".$_SESSION['LOGIN_USER_ID']."')";
}
if ( $_REQUEST['type'] == "send" )
{
	$sql .= " AND sml.FROM_ID LIKE '".$_SESSION['LOGIN_USER_ID']."' ";
}
if ( $_REQUEST['type'] == "incept" )
{
	$sql .= " AND sml.TO_ID LIKE '".$_SESSION['LOGIN_USER_ID']."' ";
}
if ( $_REQUEST['FROM_ID'] )
{
	$strFromid = substr( $_REQUEST['FROM_ID'], 0, -1 );
	$strFromid = str_replace( ",", "','", $strFromid );
	$strFromid = "'".$strFromid."'";
	$sql .= "AND sml.FROM_ID IN (".$strFromid.") ";
}
if ( $_REQUEST['TO_ID'] )
{
	$strToid = substr( $_REQUEST['TO_ID'], 0, -1 );
	$strToid = str_replace( ",", "','", $strToid );
	$strToid = "'".$strToid."'";
	$sql .= "AND sml.TO_ID IN (".$strToid.") ";
}
if ( $_REQUEST['FROM_NO'] )
{
	$sql .= "AND sml.FROM_NO LIKE '%".$_REQUEST['FROM_NO']."%' ";
}
if ( $_REQUEST['TO_NO'] )
{
	$sql .= "AND sml.TO_NO LIKE '%".$_REQUEST['TO_NO']."%' ";
}
if ( $_REQUEST['Msg_Status'] )
{
	$sql .= "AND stm.Msg_Status LIKE '".$Msg_Status."' ";
}
if ( $_REQUEST['BEGIN_DATE'] )
{
	$sql .= "AND (TO_DAYS(DATE_FORMAT(sml.SEND_TIME,'%Y-%m-%d'))>TO_DAYS('".$_REQUEST['BEGIN_DATE']."') OR TO_DAYS(DATE_FORMAT(sml.SEND_TIME,'%Y-%m-%d'))=TO_DAYS('".$_REQUEST['BEGIN_DATE']."')) ";
}
if ( $_REQUEST['END_DATE'] )
{
	$sql .= "AND (TO_DAYS(DATE_FORMAT(sml.SEND_TIME,'%Y-%m-%d'))<TO_DAYS('".$_REQUEST['END_DATE']."') OR TO_DAYS(DATE_FORMAT(sml.SEND_TIME,'%Y-%m-%d'))=TO_DAYS('".$_REQUEST['END_DATE']."')) ";
}
if ( $_REQUEST['CONTENT'] )
{
	$sql .= "AND stm.Content LIKE '%".$_REQUEST['CONTENT']."%' ";
}
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 align=\"center\" >";
	echo $strMsgSt;
	echo "</td>\r\n    <td>";
	echo $FROM_NAME;
	echo $From_Mobile;
	echo "</td>\r\n\r\n    <td>";
	echo $TO_NAME;
	echo $To_Mobile;
	echo "</td>\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']."&type=".$_REQUEST['type']."&order=".$_REQUEST['order'].$valurl );
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']."?".$valurl."&order=".$_REQUEST['order']."&sens=".$_REQUEST['sens']."&cur_page=".$cur_page );
}
echo "</html>\r\n";
?>
⌨️ 快捷键说明

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