*/
if (!class_exists("Rss_pi_stats")) {
class Rss_pi_stats {
function show_charts() {
$feeds = get_option("rss_pi_feeds", array());
$oldest_post = $this->get_the_oldest_post();
if ($oldest_post == false) {
// echo 'No Stats';
?>
get_the_newest_post();
$start_time = "";
$end_time = "";
if (
isset($_POST["rss_filter_stats"]) &&
isset($_POST["rss_from_date"]) &&
isset($_POST["rss_till_date"]))
{
$start_time = strtotime(sanitize_text_field($_POST["rss_from_date"]));
$end_time = strtotime(sanitize_text_field($_POST["rss_till_date"]));
} else {
$date_today = date("Y-m-d");// current date
$date_today_unix = strtotime($date_today);
$date_seven_days_unix = strtotime(date("Y-m-d", strtotime($date_today)) . " -7 day");
// for last seven days stats
$start_time = $date_seven_days_unix;
$end_time = $date_today_unix;
/*Old Code working according to first post*/
//$start_time = get_the_time("U", $oldest_post);
//$end_time = get_the_time("U", $newest_post);
}
if ( isset($_POST["rss_filter_stats"]) && $start_time <= 0 || $end_time <= 0 ) {
// echo 'Dates problem';
?>
show_date_pickers(); ?>
365 * 24 * 60 * 60 ) { // a year
// echo 'Range problem';
// return;
?>
$end_time ) {
?>
get_pie_chart_data_between($start_time, $end_time);
$line_feeds_data = $this->get_line_chart_data_between($start_time, $end_time);
$bar_feeds_data = $this->get_bar_chart_data_between($start_time, $end_time);
?>
show_date_pickers();
?>
get_all_dates_between($start_time, $end_time);
$feeds = get_option("rss_pi_feeds", array());
$data = array();
foreach ($feeds["feeds"] as $feed) {
$feedname = $feed["name"];
$feedurl = $feed["url"];
foreach ($dates as $date) {
$key = date("d-m-Y", $date);
$data[$key][$feedname] = $this->get_feedcount_for($feedurl, $date);
}
}
return $data;
}
function get_feedcount_for($feedurl, $date) {
$year = date("Y", $date);
$month = date("m", $date);
$day = date("d", $date);
$parse = parse_url($feedurl);
$url = $parse['host'];
$args = array(
"date_query" => array(
array(
"year" => $year,
"month" => $month,
"day" => $day,
),
'inclusive' => true,
),
'meta_query' => array(
array(
'key' => "rss_pi_source_url",
'value' => $url,
'compare' => 'LIKE',
),
),
'posts_per_page' => -1,
);
$posts = get_posts($args);
return count($posts);
}
function get_all_dates_between($strDateFrom, $strDateTo) {
$aryRange = array();
if ($strDateTo >= $strDateFrom) {
$aryRange[] = $strDateFrom; // first entry
while ($strDateFrom < $strDateTo) {
$strDateFrom+=86400; // add 24 hours
$aryRange[] = $strDateFrom;
}
}
return $aryRange;
}
function get_the_oldest_post() {
$args = array(
'posts_per_page' => 1,
'date_query' => array(
array(
'after' => array(
'year' => 1970,
'month' => 1,
'day' => 1,
),
'inclusive' => false,
),
),
'order' => 'ASC',
'orderby' => 'date',
'meta_key' => 'rss_pi_source_url',
);
$post = get_posts($args);
return isset($post[0]) ? $post[0] : false;
}
function get_the_newest_post() {
$args = array(
'posts_per_page' => 1,
'date_query' => array(
array(
'after' => array(
'year' => 1970,
'month' => 1,
'day' => 1,
),
'inclusive' => false,
),
),
'order' => 'DESC',
'orderby' => 'date',
'meta_key' => 'rss_pi_source_url',
);
$post = get_posts($args);
return isset($post[0]) ? $post[0] : false;
}
function draw_line_charts_js($feeds_data, $feeds) {
?>
var data_line_chart = google.visualization.arrayToDataTable([
$data) {
echo "[ '$date' ,";
$i = 1;
foreach ($data as $d) {
echo "" . $d . ",";
//if last data
if (count($data) == $i) {
echo "], \n";
}
$i++;
} //foreach $data
} //foreach $feeds_data
?>
]);
var options_line_chart = {
title: 'Feeds Imported',
curveType: 'none',
legend: { position: 'bottom' }
};
var chart = new google.visualization.LineChart(document.getElementById('rsspi_chart_line'));
chart.draw(data_line_chart, options_line_chart);
var data_pie_chart = google.visualization.arrayToDataTable([
$import_count) {
echo "['" . $feed . "' , $import_count ], \n";
}
?>
]);
var options_pie_chart = {
title: 'Feeds Share',
is3D: true,
};
var chart = new google.visualization.PieChart(document.getElementById('rsspi_chart_pie'));
chart.draw(data_pie_chart, options_pie_chart);
get_domain($feed["url"]);
$args = array(
"date_query" => array(
"after" => array(
"year" => $s_year,
"month" => $s_month,
"day" => $s_day,
),
"before" => array(
"year" => $e_year,
"month" => $e_month,
"day" => $e_day,
),
'inclusive' => true,
),
'meta_query' => array(
array(
'key' => "rss_pi_source_url",
'value' => $domain,
'compare' => 'LIKE',
),
),
'posts_per_page' => -1,
);
$posts = get_posts($args);
$data[$feed["name"]] = count($posts);
}
return $data;
}
// get_pie_chart_data_between
function get_domain($url) {
$parse = parse_url($url);
$url = $parse['host'];
return $url;
}
function get_bar_chart_data_between($start_time, $end_time) {
$feeds = get_option("rss_pi_feeds", array());
$data = array();
$dates = $this->get_all_dates_between($start_time, $end_time);
foreach ($dates as $date) {
$year = date("Y", $date);
$month = date("m", $date);
$day = date("d", $date);
$args = array(
"date_query" => array(
array(
"year" => $year,
"month" => $month,
"day" => $day,
),
'inclusive' => true,
),
"meta_key" => "rss_pi_source_url",
"posts_per_page" => -1,
);
$posts = get_posts($args);
$date = date("d-m-Y", $date);
$data[$date] = count($posts);
}
return $data;
}
function draw_bar_chart_js($bar_feeds_data, $feeds) {
?>
var data_bar = google.visualization.arrayToDataTable([
['Date', 'Posts Imported' ],
$count) {
echo "['" . $date . "', $count], \n";
}
?>
]);
var bar_options = {
chart: {
title: 'Total posts imported everyday',
subtitle: ''
},
bars: 'vertical' // Required for Material Bar Charts.
};
var bar_chart = new google.charts.Bar(document.getElementById('rsspi_chart_bar'));
bar_chart.draw(data_bar, bar_options);