芝麻web文件管理V1.00

编辑当前文件:/www/wwwroot/shphe-en.com/globalso-xml-data.php

<?php
header("Content-type:text/xml;charset=utf-8");
echo "<?xml version='1.0' encoding='UTF-8'?>";
$origin = isset($_SERVER['HTTP_ORIGIN'])? $_SERVER['HTTP_ORIGIN'] : '';  
$allow_origin = array(  
    'https://www.quanqiusou.cn',
    'http://www.quanqiusou.cn',
);  
if(in_array($origin, $allow_origin)){  
    header('Access-Control-Allow-Origin:'.$origin);  
    header('Access-Control-Allow-Methods:POST');  
    header('Access-Control-Allow-Headers:x-requested-with,content-type');  
}

header('Access-Control-Allow-Methods:GET,PUT,DELETE,POST');  
header('Access-Control-Allow-Credentials:true'); 
require_once( dirname(__FILE__) . '/wp-load.php' );

$project_name = home_url();
$yesterday = date('Y-m-d',time()-60*60*24);
$res_y = $wpdb->get_row("select pv,uv,ip from wp_stats_day_count where day='$yesterday'",ARRAY_A);
$y_allip = (int)$res_y['ip'];
$y_allpv = (int)$res_y['pv'];
$res_y_g = $wpdb->get_row("select count(id) as num from wp_stats_day_ip where day='$yesterday' and (referrer like '%google%' or referrer like '%bing%' or referrer like '%yahoo%' or referrer like '%yandex%')",ARRAY_A);
$y_googleip = (int)$res_y_g['num'];

$today = date('Y-m-d');
$res_t = $wpdb->get_row("select pv,uv,ip from wp_stats_day_count where day ='$today'",ARRAY_A);
$t_allip = (int)$res_t['ip'];
$t_allpv = (int)$res_t['pv'];
$res_t_g = $wpdb->get_row("select count(id) as num from wp_stats_day_ip where day ='$today' and (referrer like '%google%' or referrer like '%bing%' or referrer like '%yahoo%' or referrer like '%yandex%')",ARRAY_A);
$t_googleip = (int)$res_t_g['num'];

$seven_day = date('Y-m-d',time()-60*60*24*6);
$res_seven_g = $wpdb->get_row("select count(id) as num from wp_stats_day_ip where day='$seven_day' and (referrer like '%google%' or referrer like '%bing%' or referrer like '%yahoo%' or referrer like '%yandex%')",ARRAY_A);
$seven_googleip = (int)$res_seven_g['num'];

$six_day = date('Y-m-d',time()-60*60*24*5);
$res_six_g = $wpdb->get_row("select count(id) as num from wp_stats_day_ip where day='$six_day' and (referrer like '%google%' or referrer like '%bing%' or referrer like '%yahoo%' or referrer like '%yandex%')",ARRAY_A);
$six_googleip = (int)$res_six_g['num'];

$five_day = date('Y-m-d',time()-60*60*24*4);
$res_five_g = $wpdb->get_row("select count(id) as num from wp_stats_day_ip where day='$five_day' and ((referrer like '%google%' or referrer like '%bing%' or referrer like '%yahoo%' or referrer like '%yandex%') or referrer like '%bing%' or referrer like '%yahoo%' or referrer like '%yandex%')",ARRAY_A);
$five_googleip = (int)$res_five_g['num'];

$four_day = date('Y-m-d',time()-60*60*24*3);
$res_four_g = $wpdb->get_row("select count(id) as num from wp_stats_day_ip where day='$four_day' and ((referrer like '%google%' or referrer like '%bing%' or referrer like '%yahoo%' or referrer like '%yandex%') or referrer like '%bing%' or referrer like '%yahoo%' or referrer like '%yandex%')",ARRAY_A);
$four_googleip = (int)$res_four_g['num'];

$three_day = date('Y-m-d',time()-60*60*24*2);
$res_three_g = $wpdb->get_row("select count(id) as num from wp_stats_day_ip where day='$three_day' and (referrer like '%google%' or referrer like '%bing%' or referrer like '%yahoo%' or referrer like '%yandex%')",ARRAY_A);
$three_googleip = (int)$res_three_g['num'];

$res_xp = $wpdb->get_row("select count(*) as total from wp_cf7_data",ARRAY_A);
$xunpan = (int)$res_xp['total'];

$wpcf7_contact = $wpdb->get_results("select * from wp_cf7_data_entry e left join wp_cf7_data d on e.data_id = d.id where e.cf7_id=19 AND e.name ='Email'");   
$wpcf7_contact_price = $wpdb->get_results("select * from wp_cf7_data_entry e left join wp_cf7_data d on e.data_id = d.id where e.cf7_id=20 AND e.name ='Email'");
$wpcf7_contact_all = array_merge($wpcf7_contact,$wpcf7_contact_price);
$red_flag =0;
$orange_flag =0;
$blue_flag =0;
$last_1_days_arr = array(date('Y-m-d',strtotime('-1 days')));
$last_3_days_arr = array(date('Y-m-d',strtotime('-2 days')),date('Y-m-d',strtotime('-3 days')),date('Y-m-d',strtotime('-4 days')),date('Y-m-d',strtotime('-5 days')),date('Y-m-d',strtotime('-6 days')));

$cun_month = date('m');
for($month_i=1;$month_i<=12;$month_i++){
    if($month_i<=$cun_month){
        $ar_month[$month_i] = date('Y').'-'.str_pad($month_i,'2','0',STR_PAD_LEFT);
    }else{
        $ar_month[$month_i] = date('Y',strtotime("-1 year")).'-'.str_pad($month_i,'2','0',STR_PAD_LEFT);
    }
}

foreach($wpcf7_contact_all as $v){
	if(date('Y-m-d',strtotime($v->created)) ==date('Y-m-d')){
		$red_flag = 1;
	}
	if(in_array(date('Y-m-d',strtotime($v->created)),$last_1_days_arr)){
		$orange_flag = 1;
	}
	if(in_array(date('Y-m-d',strtotime($v->created)),$last_3_days_arr)){
		$blue_flag = 1;
	}	
}
$wpcf7_contact_form_num = count($wpcf7_contact) + count($wpcf7_contact_price);
$color = '';
if($red_flag){
	$color = $red_flag?"red":'';
}elseif($orange_flag){
	$color = $orange_flag?"orange":"";
}else{
	$color = $blue_flag?"blue":"";
}
if(!$color){
	$color = 'black';
}

$res_com = $wpdb->get_row("select count(*) as total from wp_comments",ARRAY_A);
$comments = (int)$res_com['total'];
$count_posts = wp_count_posts();
$products = $count_posts->publish;;
$news = count(query_posts(array( 'post_type' => 'news','posts_per_page'=>-1)));

echo "<root project-name='".$project_name."'>";
echo "<date value='".$today."'>";
echo "<y-allip>".$y_allip."</y-allip>";
echo "<y-allpv>".$y_allpv."</y-allpv>";

echo "<t-allip>".$t_allip."</t-allip>";
echo "<t-allpv>".$t_allpv."</t-allpv>";

echo "<t-googleip>".$t_googleip."</t-googleip>";
echo "<y-googleip>".$y_googleip."</y-googleip>";
echo "<three_googleip>".$three_googleip."</three_googleip>";
echo "<four_googleip>".$four_googleip."</four_googleip>";
echo "<five_googleip>".$five_googleip."</five_googleip>";
echo "<six_googleip>".$six_googleip."</six_googleip>";
echo "<seven_googleip>".$seven_googleip."</seven_googleip>";

echo "<xunpan>".$xunpan."</xunpan>";
echo "<color>".$color."</color>";
echo "<comments>".$comments."</comments>";
echo "<products>".$products."</products>";
echo "<news>".$news."</news>";
foreach ($ar_month as $v){
    $start = $v.'-01 00:00:00';
    $end = $v.'-31 23:59:59';
    $res_t = $wpdb->get_row("select count(*) as cnt from wp_cf7_data where created>='".$start."' and created <='".$end."'",ARRAY_A);
    echo "<xp-".$v.">".$res_t['cnt']."</xp-".$v.">";
}
echo "</date>";
echo "</root>";
?>