Files

68 lines
2.7 KiB
PHP
Raw Permalink Normal View History

2026-11-17 16:15:01 -05:00
<?php
class gdsrDBChart {
function prepare_data_daily($data) {
$i = 0;
$rating = $votes = $ticks = array();
foreach ($data as $day => $values) {
$ticks[] = sprintf("[%s, '%s']", $i, (floor($i / 4) == $i / 4) ? $day : "");
$rating[] = sprintf("[%s, %s]", $i, $values["rating"]);
$votes[] = sprintf("[%s, %s]", $i, $values["votes"]);
$i++;
}
return sprintf("var gdr_rating = [%s]; var gdr_votes = [%s]; var gdr_ticks = [%s];",
join(", ", $rating), join(", ", $votes), join(", ", $ticks));
}
function votes_counter($vote_type = 'article') {
global $wpdb, $table_prefix;
$sql = sprintf("SELECT vote, count(*) as counter FROM %sgdsr_votes_log where vote_type = '%s' group by vote order by vote desc", $table_prefix, $vote_type);
return $wpdb->get_results($sql);
}
function trends_daily($id, $vote_type = 'article', $show = "", $days = 30) {
global $wpdb, $table_prefix;
$mysql4_strtodate = "date_add(vote_date, interval 0 day)";
$mysql5_strtodate = "str_to_date(vote_date, '%Y-%m-%d')";
$strtodate = "";
$voters = $votes = 0;
switch(gdFunctionsGDSR::mysql_version()) {
case "4":
$strtodate = $mysql4_strtodate;
break;
case "5":
default:
$strtodate = $mysql5_strtodate;
break;
}
$sql = sprintf("SELECT user_voters, user_votes, visitor_voters, visitor_votes, %s as vote_date FROM %sgdsr_votes_trend where vote_type = '%s' and id = %s and %s between DATE_SUB(NOW(), INTERVAL %s DAY) AND NOW() order by vote_date asc",
$strtodate, $table_prefix, $vote_type, $id, $strtodate, $days);
$results = $wpdb->get_results($sql);
$data = array();
for ($i = $days; $i > 0; $i--) {
$day = date('Y-m-d', mktime(0, 0, 0, date("m"), date("d") - $i, date("Y")));
$data[$day] = array("votes" => 0, "rating" => 0);
}
foreach ($results as $row) {
if ($show == "user") {
$voters = $row->user_voters;
$votes = $row->user_votes;
}
else if ($show == "visitor") {
$voters = $row->visitor_voters;
$votes = $row->visitor_votes;
}
else {
$voters = $row->visitor_voters + $row->user_voters;
$votes = $row->visitor_votes + $row->user_votes;
}
$data[$row->vote_date]["rating"] = $voters > 0 ? number_format($votes / $voters, 1) : 0;
$data[$row->vote_date]["votes"] = $voters;
}
return $data;
}
}
?>