?? search_export.php
字號(hào):
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
include_once( "inc/check_type.php" );
$EXCEL_OUT = "發(fā)布人,類型,標(biāo)題,發(fā)布時(shí)間,生效日期,終止日期,狀態(tài),附件名稱";
$EXCEL_OUT .= "\n";
$CUR_DATE = date( "Y-m-d", time( ) );
if ( $SEND_TIME_MIN != "" )
{
$TIME_OK = is_date( $SEND_TIME_MIN );
if ( !$TIME_OK )
{
message( "錯(cuò)誤", "\"發(fā)布日期\"的格式不對(duì),應(yīng)形如 ".$CUR_DATE );
button_back( );
exit( );
}
$SEND_TIME_MIN .= " 00:00:00";
}
if ( $SEND_TIME_MAX != "" )
{
$TIME_OK = is_date( $SEND_TIME_MAX );
if ( !$TIME_OK )
{
message( "錯(cuò)誤", "\"發(fā)布日期\"的格式不對(duì),應(yīng)形如 ".$CUR_DATE );
button_back( );
exit( );
}
$SEND_TIME_MAX .= " 23:59:59";
}
$CONDITION_STR = "";
if ( $SUBJECT != "" )
{
$CONDITION_STR .= " and SUBJECT like '%".$SUBJECT."%'";
}
if ( $CONTENT != "" )
{
$CONDITION_STR .= " and CONTENT like '%".$CONTENT."%'";
}
if ( $SEND_TIME_MIN != "" )
{
$CONDITION_STR .= " and SEND_TIME>='".$SEND_TIME_MIN."'";
}
if ( $SEND_TIME_MAX != "" )
{
$CONDITION_STR .= " and SEND_TIME<='".$SEND_TIME_MAX."'";
}
if ( $FORMAT != "" )
{
$CONDITION_STR .= " and FORMAT='".$FORMAT."'";
}
if ( $TYPE_ID != "" )
{
$CONDITION_STR .= " and TYPE_ID='".$TYPE_ID."'";
}
if ( $PUBLISH != "" )
{
$CONDITION_STR .= " and PUBLISH='".$PUBLISH."'";
}
if ( $TOP != "" )
{
$CONDITION_STR .= " and TOP='".$TOP."'";
}
if ( $TO_ID != "" )
{
$CONDITION_STR .= " and find_in_set(FROM_ID,'".$TO_ID."')";
}
if ( $STAT != "" )
{
if ( $STAT == 1 )
{
$CONDITION_STR .= " and BEGIN_DATE>'".$CUR_DATE."'";
}
else if ( $STAT == 2 )
{
$CONDITION_STR .= " and BEGIN_DATE<='".$CUR_DATE."' and (END_DATE='0000-00-00' or END_DATE>='{$CUR_DATE}')";
}
else if ( $STAT == 3 )
{
$CONDITION_STR .= " and END_DATE!='0000-00-00' and END_DATE<='".$CUR_DATE."'";
}
}
if ( $LOGIN_USER_PRIV != "1" )
{
$query = "SELECT * from NOTIFY where FROM_ID='".$LOGIN_USER_ID."'";
}
else
{
$query = "SELECT * from NOTIFY where 1=1";
}
$query .= $CONDITION_STR." order by TOP desc, SEND_TIME desc";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$NOTIFY_ID = $ROW['NOTIFY_ID'];
$FROM_ID = $ROW['FROM_ID'];
$SUBJECT = $ROW['SUBJECT'];
$TYPE_ID = $ROW['TYPE_ID'];
$PUBLISH = $ROW['PUBLISH'];
$SUBJECT = htmlspecialchars( $SUBJECT );
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
if ( $PUBLISH == "0" )
{
$PUBLISH_DESC = "<font color=red>未發(fā)布</font>";
}
else
{
$PUBLISH_DESC = "";
}
$SEND_TIME = $ROW['SEND_TIME'];
$BEGIN_DATE = $ROW['BEGIN_DATE'];
$END_DATE = $ROW['END_DATE'];
$BEGIN_DATE = strtok( $BEGIN_DATE, " " );
$END_DATE = strtok( $END_DATE, " " );
if ( $END_DATE == "0000-00-00" )
{
$END_DATE = "";
}
$query1 = "select USER_NAME,DEPT_ID from USER where USER_ID='".$FROM_ID."'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$FROM_NAME = $ROW['USER_NAME'];
$DEPT_ID = $ROW['DEPT_ID'];
}
$DEPT_NAME = dept_long_name( $DEPT_ID );
$TYPE_NAME = get_code_name( $TYPE_ID, "NOTIFY" );
if ( compare_date( $CUR_DATE, $BEGIN_DATE ) < 0 )
{
$NOTIFY_STATUS = 1;
$NOTIFY_STATUS_STR = "待生效";
}
else
{
$NOTIFY_STATUS = 2;
$NOTIFY_STATUS_STR = "生效";
}
if ( ( $END_DATE != "" || $PUBLISH == "0" ) && 0 < compare_date( $CUR_DATE, $END_DATE ) )
{
$NOTIFY_STATUS = 3;
$NOTIFY_STATUS_STR = "終止";
}
if ( $PUBLISH == "0" )
{
$NOTIFY_STATUS_STR = "";
}
$EXCEL_OUT .= "\"".$FROM_NAME."\",\"".$TYPE_NAME."\",\"".$SUBJECT."\",\"".$SEND_TIME."\",\"".$BEGIN_DATE."\",\"".$END_DATE."\",\"".$NOTIFY_STATUS_STR."\",\"".$ATTACHMENT_NAME."\"";
$EXCEL_OUT .= "\n";
}
ob_end_clean( );
header( "Cache-control: private" );
header( "Content-type: application/vnd.ms-excel" );
header( "Accept-Ranges: bytes" );
header( "Accept-Length: ".strlen( $EXCEL_OUT ) );
header( "Content-Disposition: attachment; filename=公告通知.csv" );
echo $EXCEL_OUT;
?>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -