⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 search.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=\"query.p";
echo "hp\"></a>\r\n\t  <a href=\"query.php\"><img src=\"/images/button/return.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=\"5%\" nowrap >选择</td>\r\n    <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    <td width=\"7%\" nowrap >操作</td>\r\n  </tr>\r\n  ";
$sql = "SELECT * FROM sms_tb_msg stm,sms_msg_log sml WHERE stm.RegID=sml.REGID ";
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>&nbsp;\r\n        <input type=\"checkbox\" name=\"msms_select\" value=\"";
	echo $RegID;
	echo "\" onClick=\"check_one(self);\">    </td>\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<td><a onClick=\"return confirm('您确定删除吗?')\" href=\"do.php?RegID=";
	echo $RegID;
	echo "&f=delete&option=search\">删除</a></td>\r\n  </tr>\r\n  ";
}
echo "</form>\r\n</table>\r\n<table width=\"100%\" cellpadding=\"5\" cellspacing=\"0\" >\r\n  <tr class=\"TableLine2\">\r\n    <td><input type=\"checkbox\" name=\"allbox\" ";
if ( 0 < $total_page_nums )
{
	echo "onClick=\"check_all();\"";
}
echo ">\r\n      全部选中 \r\n    <input type=\"button\"  value=\"删除\" class=\"SmallButton\" ";
if ( 0 < $total_page_nums )
{
	echo "onClick=\"delete_msms();\"";
}
echo " title=\"删除所选短信\"></td>\r\n    <td width=\"20%\">&nbsp;</td>\r\n  </tr>\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'].$valurl );
echo "</td>\r\n  </tr>\r\n</table>\r\n</body>\r\n</html>\r\n";
echo "<s";
echo "cript>\r\nfunction check_all()\r\n{\r\n for (i=0;i<document.all(\"msms_select\").length;i++)\r\n {\r\n   if(document.all(\"allbox\").checked)\r\n      document.all(\"msms_select\").item(i).checked=true;\r\n   else\r\n      document.all(\"msms_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(\"msms_select\").checked=true;\r\n   else\r\n      document.all(\"msms_sele";
echo "ct\").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\n\r\n\r\nfunction delete_msms()\r\n{\r\n  delete_str=\"\";\r\n  for(i=0;i<document.all(\"msms_select\").length;i++)\r\n  {\r\n\r\n      el=document.all(\"msms_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    ";
echo "  el=document.all(\"msms_select\");\r\n      if(el.checked)\r\n      {  val=el.value;\r\n         delete_str+=val + \",\";\r\n      }\r\n  }\r\n\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    url=\"do.php?id_str=\"+ delete_str +\"";
echo $valurl;
echo "&cur_page=";
echo $_REQUEST['cur_page'];
echo "&sens=";
echo $_REQUEST['sens'];
echo "&order=";
echo $_REQUEST['order'];
echo "&f=delete&option=search\";\r\n    location=url;\r\n  }\r\n}\r\n\r\n\r\n\r\n</script>\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 );
}
?>

⌨️ 快捷键说明

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