📄 search.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_file.php" );
include_once( "inc/check_type.php" );
if ( $BOX == "1" )
{
$BOX_NAME = "收件箱";
}
if ( $BOX == "2" )
{
$BOX_NAME = "已发送";
}
if ( $BOX == "3" )
{
$BOX_NAME = "已删除";
}
echo "<html>\r\n<head>\r\n<title>传真查询结果</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n<script src=\"/inc/js/attach.js\"></script>\r\n<script>\r\nfunction check_all()\r\n{\r\n for (i=0;i<document.all(\"fax_select\").length;i++)\r\n {\r\n if(document.all(\"allbox\").checked)\r\n document.all(\"fax_select\").item(i).checked=true;\r\n else\r\n document.all(\"fax_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(\"fax_select\").checked=true;\r\n else\r\n document.all(\"fax_select\").checked=false;\r\n }\r\n}\r\n\r\nfunction get_checked()\r\n{\r\n checked_str=\"\";\r\n for(i=0;i<document.all(\"fax_select\").length;i++)\r\n {\r\n el=document.all(\"fax_select\").item(i);\r\n if(el.checked)\r\n {\r\n val=el.value;\r\n checked_str+=val + \",\";\r\n }\r\n }\r\n\r\n if(i==0)\r\n {\r\n el=document.all(\"fax_select\");\r\n if(el.checked)\r\n { val=el.value;\r\n checked_str+=val + \",\";\r\n }\r\n }\r\n return checked_str;\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 delete_fax()\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 msg='您只能删除您具有管理权限帐户下的传真，确认要删除这些信息吗？';\r\n if(window.confirm(msg))\r\n {\r\n form_delete.DELETE_STR.value=delete_str;\r\n form_delete.action=\"delete.php\";\r\n form_delete.submit();\r\n }\r\n}\r\n</script>\r\n</head>\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/menu/infofind.gif\" WIDTH=\"22\" HEIGHT=\"20\" align=\"absmiddle\"><span class=\"big3\">";
echo $BOX_NAME;
echo "--查询结果</span>\r\n </td>\r\n </tr>\r\n</table>\r\n";
$CUR_TIME = date( "Y-m-d H:i:s", time( ) );
if ( $SEND_TIME_MIN != "" )
{
$TIME_OK = is_date_time( $SEND_TIME_MIN );
if ( !$TIME_OK )
{
message( "错误", "\"发布日期\"的格式不对，应形如 ".$CUR_TIME );
button_back( );
exit( );
}
}
if ( $SEND_TIME_MAX != "" )
{
$TIME_OK = is_date_time( $SEND_TIME_MAX );
if ( !$TIME_OK )
{
message( "错误", "\"发布日期\"的格式不对，应形如 ".$CUR_TIME );
button_back( );
exit( );
}
}
if ( $BOX == "2" )
{
$query = "SELECT * from EFAX_SEND_BOX where USER_ID='".$LOGIN_USER_ID."'";
if ( $SEND_TIME_MIN != "" )
{
$query .= " and SEND_TIME>='".$SEND_TIME_MIN."'";
}
if ( $SEND_TIME_MAX != "" )
{
$query .= " and SEND_TIME<='".$SEND_TIME_MAX."'";
}
if ( $FROM_NO != "" )
{
$query .= " and FAX_NO like '%".$FROM_NO."%'";
}
if ( $TO_NO != "" )
{
$query .= " and RECEIVE_NO like '%".$TO_NO."%'";
}
}
else
{
$FAX_NAME = "";
$query = "select NAME from EFAX_ACCOUNT where find_in_set('".$LOGIN_USER_ID."',RECEIVE_PRIV)";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$FAX_NAME .= "'".$ROW['NAME']."',";
}
if ( $FAX_NAME == "" )
{
message( "提示", "未找到符合条件的传真！" );
button_back( );
exit( );
}
if ( substr( $FAX_NAME, strlen( $FAX_NAME ) - 1, 1 ) == "," )
{
$FAX_NAME = substr( $FAX_NAME, 0, -1 );
}
$query = "SELECT * from EFAX_RECEIVE_BOX where FAX_NAME in (".$FAX_NAME.")";
if ( $SEND_TIME_MIN != "" )
{
$query .= " and RECEIVE_TIME>='".$SEND_TIME_MIN."'";
}
if ( $SEND_TIME_MAX != "" )
{
$query .= " and RECEIVE_TIME<='".$SEND_TIME_MAX."'";
}
if ( $FROM_NO != "" )
{
$query .= " and SEND_NO like '%".$FROM_NO."%'";
}
if ( $TO_NO != "" )
{
$query .= " and FAX_NO like '%".$TO_NO."%'";
}
if ( $READ_FLAG != "" )
{
$query .= " and ISDONWLOAD='".$READ_FLAG."'";
}
if ( $BOX == "3" )
{
$query .= " and STATE='-1'";
}
else
{
$query .= " and STATE<>'-1'";
}
}
$cursor = exequery( $connection, $query );
$LETER_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$LETER_COUNT;
if ( $LETER_COUNT == 1 )
{
echo "<br>\r\n<table class=\"TableList\" width=\"100%\">\r\n <tr class=\"TableHeader\">\r\n <td nowrap align=\"center\">选择</td>\r\n ";
if ( $BOX != "2" )
{
echo " <td nowrap align=\"center\">状态</td>\r\n ";
}
echo " <td nowrap align=\"center\">发送方号码</td>\r\n <td nowrap align=\"center\">接收方号码</td>\r\n <td nowrap align=\"center\">";
if ( $BOX == "2" )
{
echo "发送时间";
}
else
{
echo "接收时间";
}
echo "</td>\r\n <td nowrap align=\"center\">详情</td>\r\n </tr>\r\n ";
}
if ( $BOX == "2" )
{
$ID = $ROW['ID'];
$SEND_NO = $ROW['FAX_NO'];
$FAX_NO = $ROW['RECEIVE_NO'];
$FAX_TIME = $ROW['SEND_TIME'];
$ATTACHMENT_URL = $ROW['ATTACHMENT_URL'];
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
$temp = attach_link( $ATTACHMENT_ID, $ATTACHMENT_NAME, 0, 1, 1 );
}
else
{
$ID = $ROW['ID'];
$SEND_NO = $ROW['SEND_NO'];
$FAX_NO = $ROW['FAX_NO'];
$FAX_TIME = $ROW['RECEIVE_TIME'];
$ATTACHMENT_URL = $ROW['FAX_URL'];
$ISDONWLOAD = $ROW['ISDONWLOAD'];
}
if ( $LETER_COUNT % 2 == 1 )
{
$TableLine = "TableLine1";
}
else
{
$TableLine = "TableLine2";
}
echo " <tr class=\"";
echo $TableLine;
echo "\">\r\n <td nowrap align=\"center\"><input type=\"checkbox\" name=\"fax_select\" value=\"";
echo $ID;
echo "\" onClick=\"check_one(self);\"></td>\r\n ";
if ( $BOX != "2" )
{
echo " <td nowrap align=\"center\">";
if ( $ISDONWLOAD == "0" )
{
echo "未读";
}
else
{
echo "已读";
}
echo "</td>\r\n ";
}
echo " <td nowrap align=\"center\">";
echo $SEND_NO;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $FAX_NO;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $FAX_TIME;
echo "</td>\r\n <td nowrap align=\"";
if ( $BOX == "2" )
{
echo "left";
}
else
{
echo "center";
}
echo "\">";
if ( $BOX == "2" )
{
echo $temp;
}
else
{
echo "<a href='../receive/update.php?UPDATE_STR=";
echo $ID;
echo "&DOWNLOAD=1'><img src='/images/downloadfax.gif' alt='下载传真'></a>";
}
echo "</td>\r\n </tr>\r\n";
}
if ( 0 < $LETER_COUNT )
{
echo "<tr class=\"TableControl\">\r\n<td colspan=\"10\">\r\n <input type=\"checkbox\" name=\"allbox\" id=\"allbox_for\" onClick=\"check_all();\">\r\n <label for=\"allbox_for\">全选</label> \r\n <a href=\"javascript:delete_fax();\" title=\"删除所选传真\"><img src=\"/images/delete.gif\" align=\"absMiddle\">删除</a> \r\n</td>\r\n</tr>\r\n</table>\r\n";
}
else
{
message( "提示", "未找到符合条件的传真！" );
button_back( );
exit( );
}
echo "<br>\r\n<div align=\"center\">\r\n <input type=\"button\" value=\"返回\" class=\"BigButton\" onClick=\"location='index.php';\">\r\n</div>\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=\"BOX\" value=\"";
echo $BOX;
echo "\">\r\n <input type=\"hidden\" name=\"SEND_TIME_MIN\" value=\"";
echo $SEND_TIME_MIN;
echo "\">\r\n <input type=\"hidden\" name=\"SEND_TIME_MAX\" value=\"";
echo $SEND_TIME_MAX;
echo "\">\r\n <input type=\"hidden\" name=\"FROM_NO\" value=\"";
echo $FROM_NO;
echo "\">\r\n <input type=\"hidden\" name=\"TO_NO\" value=\"";
echo $TO_NO;
echo "\">\r\n <input type=\"hidden\" name=\"READ_FLAG\" value=\"";
echo $READ_FLAG;
echo "\">\r\n</form>\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -