📄 export.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/check_type.php" );
include_once( "inc/utility_all.php" );
ob_end_clean( );
header( "Cache-control: private" );
header( "Content-type: application/vnd.ms-excel" );
header( "Content-Disposition: attachment; filename= 内部短消息.xls" );
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>\r\n\r\n";
if ( $BEGIN_DATE != "" )
{
$TIME_OK = is_date_time( $BEGIN_DATE );
if ( !$TIME_OK )
{
message( "错误", "起始日期格式不对，应形如 1999-1-2 14:55:20" );
button_back( );
exit( );
}
}
if ( $END_DATE != "" )
{
$TIME_OK = is_date_time( $END_DATE );
if ( !$TIME_OK )
{
message( "错误", "截止日期格式不对，应形如 1999-1-2 14:55:20" );
button_back( );
exit( );
}
}
if ( $END_DATE != "" && $BEGIN_DATE != "" && $END_DATE < $BEGIN_DATE )
{
message( "错误", "截止时间不能晚于起始时间!" );
button_back( );
exit( );
}
if ( $TO_ID != "" )
{
$TO_ID = "'".str_replace( ",", "','", substr( $TO_ID, 0, -1 ) )."'";
}
if ( $TO_ID != "" )
{
$query1 .= " and ".$TYPE." in ({$TO_ID})";
}
if ( $BEGIN_DATE != "" )
{
$query1 .= " and SEND_TIME>='".$BEGIN_DATE."'";
}
if ( $END_DATE != "" )
{
$query1 .= " and SEND_TIME<='".$END_DATE."'";
}
if ( $SMS_TYPE != "" )
{
$query1 .= " and SMS_TYPE='".$SMS_TYPE."'";
}
if ( $CONTENT != "" )
{
$query1 .= " and CONTENT like '%".$CONTENT."%'";
}
if ( $TYPE == "TO_ID" )
{
$TYPE_OTHER = "FROM_ID";
$TITLE = "收信人";
$query1 .= " and DELETE_FLAG!='2'";
}
else
{
$TYPE_OTHER = "TO_ID";
$TITLE = "发送人";
$query1 .= " and DELETE_FLAG!='1'";
}
if ( $ORDER_BY == "FROM_TO" )
{
$ORDER_BY = $TYPE;
}
$query = "select * from SMS,SMS_BODY where SMS.BODY_ID=SMS_BODY.BODY_ID and ".$TYPE_OTHER."='{$LOGIN_USER_ID}'".$query1.( " order by ".$ORDER_BY." {$SEQ}" );
echo "<table border=\"1\" cellspacing=\"0\" width=\"95%\" cellpadding=\"3\">\r\n <tr style=\"BACKGROUND: #D3E5FA; color: #000000; font-weight: bold;\">\r\n <td nowrap align=\"center\">类别</td>\r\n <td nowrap align=\"center\">";
echo $TITLE;
echo "</td>\r\n <td nowrap align=\"center\">内容</td>\r\n <td nowrap align=\"center\">发送时间</td>\r\n <td nowrap align=\"center\">提醒</td>\r\n </tr>\r\n";
$cursor = exequery( $connection, $query );
$SMS_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$SMS_COUNT;
$SMS_ID = $ROW['SMS_ID'];
$FROM_ID = $ROW['FROM_ID'];
$TO_ID = $ROW['TO_ID'];
$SEND_TIME = $ROW['SEND_TIME'];
$SMS_TYPE = $ROW['SMS_TYPE'];
$CONTENT = $ROW['CONTENT'];
$CONTENT = htmlspecialchars( $CONTENT );
$REMIND_FLAG = $ROW['REMIND_FLAG'];
if ( $REMIND_FLAG == "0" )
{
$REMIND_FLAG_DESC = "否";
}
else
{
$REMIND_FLAG_DESC = "是";
}
$query1 = "SELECT * from USER where USER_ID='".$FROM_ID."'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$FROM_NAME = $ROW['USER_NAME'];
$FROM_AVATAR = $ROW['AVATAR'];
}
$query1 = "SELECT * from USER where USER_ID='".$TO_ID."'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$TO_NAME = $ROW['USER_NAME'];
$TO_AVATAR = $ROW['AVATAR'];
}
$SMS_TYPE_NAME = get_code_name( $SMS_TYPE, "SMS_REMIND" );
if ( $SMS_COUNT % 2 == 1 )
{
$TableLine = "TableLine1";
}
else
{
$TableLine = "TableLine2";
}
if ( $TYPE == "TO_ID" )
{
$AVATAR = $TO_AVATAR;
}
else
{
$AVATAR = $FROM_AVATAR;
}
echo " <tr>\r\n <td align=\"center\">";
echo $SMS_TYPE_NAME;
echo "</td>\r\n <td nowrap align=\"center\">";
if ( $TYPE == "TO_ID" )
{
echo $TO_NAME;
}
else
{
echo $FROM_NAME;
}
echo "</td>\r\n <td>";
echo $CONTENT;
echo "</td>\r\n <td align=\"center\">";
echo $SEND_TIME;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $REMIND_FLAG_DESC;
echo "</td>\r\n </tr>\r\n";
}
echo "</table>\r\n\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -