$time_end = $date->format("U");
$day_end = $date->format("Y-m-d");
$date->modify("-30 days");
$date->setTime(0, 0, 0);
$time_start = $date->format("U");
$stats = array();
while (true) {
$day = $date->format("Y-m-d");
$stats[$day] = 0;
$date->modify("+1 day");
if ($day == $day_end) {
break;
}
}
// hent statistikk
$result = \Kofradia\DB::get()->query("\n\tSELECT DATE(FROM_UNIXTIME(poker_time_start)) AS day, SUM(CONVERT(poker_prize - poker_cash, SIGNED) * IF((poker_winner = 1 AND poker_starter_up_id = up_id) OR (poker_winner = 2 AND poker_challenger_up_id = up_id), 1, -1)) sum_result\n\tFROM poker, users_players\n\tWHERE poker_time_start >= {$time_start} AND poker_time_start <= {$time_end} AND up_u_id = {$u_id} AND (up_id = poker_starter_up_id OR up_id = poker_challenger_up_id) AND poker_state = 4\n\tGROUP BY DATE(FROM_UNIXTIME(poker_time_start))");
while ($row = $result->fetch()) {
$stats[$row['day']] = (double) $row['sum_result'];
}
$ofc = new OFC();
$ofc->title(new OFC_Title("Pokerstatistikk for {$up_name} siste 30 dager"));
$bar = new OFC_Charts_Area();
$bar->text("Resultat av poker");
$bar->dot_style()->type("solid-dot")->dot_size(3)->halo_size(2)->tip("#x_label#<br>#val# kr");
$bar->values(array_values($stats));
$bar->colour(OFC_Colours::$colours[0]);
$ofc->add_element($bar);
$ofc->axis_x()->label()->steps(2)->rotate(330)->labels(array_keys($stats));
$ofc->axis_y()->set_numbers(min(0, min($stats)), max($stats));
$ofc->dark_colors();
echo $ofc;
/** Vis oversikt over statistikk */
protected static function show_stats()
{
// hent litt statistikk
$result = \Kofradia\DB::get()->query("SELECT COUNT(su_id) FROM support");
$totalt = $result->fetchColumn(0);
// hent spillere med status..
$result = \Kofradia\DB::get()->query("SELECT up_id, up_name, up_access_level, up_last_online FROM users_players WHERE up_access_level > 1 ORDER BY up_name");
$players = array();
$last_online = array();
while ($row = $result->fetch()) {
if ($row['up_access_level'] == 4) {
$level = 3;
} elseif ($row['up_access_level'] == 6) {
$level = 3;
} elseif ($row['up_access_level'] == 8) {
$level = 7;
} else {
$level = $row['up_access_level'];
}
$players[$level][] = $row;
$last_online[$row['up_id']] = $row['up_last_online'];
}
// hent antall besvarelser per bruker
$result = \Kofradia\DB::get()->query("\n\t\t\tSELECT sum_up_id, COUNT(sum_id) num_sum, MAX(sum_time) max_sum_time, m.up_last_online, m.up_access_level\n\t\t\tFROM support\n\t\t\t\tJOIN support_messages ON sum_su_id = su_id\n\t\t\t\tJOIN users_players s ON s.up_id = su_up_id\n\t\t\t\tJOIN users_players m ON m.up_id = sum_up_id AND m.up_u_id != s.up_u_id\n\t\t\tGROUP BY sum_up_id");
$reply_users = array();
while ($row = $result->fetch()) {
if ($row['max_sum_time'] < time() - 2592000 && ($row['up_access_level'] == 0 || $row['up_access_level'] == 1)) {
continue;
}
$reply_users[$row['sum_up_id']] = $row['num_sum'];
$last_online[$row['sum_up_id']] = $row['up_last_online'];
}
// vis oversikt
echo '
<table class="table center" style="width: 400px">
<thead>
<tr>
<th colspan="3">Besvarte henvendelser</th>
</tr>
</thead>
<tbody>
<tr>
<td colspan="2">Antall henvendelser totalt</td>
<td>' . game::format_number($totalt) . ' stk</td>
</tr>
<tr>
<th colspan="3">Administratorer</th>
</tr>' . self::show_stats_users($players, 7, $reply_users, $last_online) . '
<tr>
<th colspan="3">Seniormoderatorer</th>
</tr>' . self::show_stats_users($players, 11, $reply_users, $last_online) . '
<tr>
<th colspan="3">Moderatorer</th>
</tr>' . self::show_stats_users($players, 5, $reply_users, $last_online) . '
<tr>
<th colspan="3">Forummoderatorer</th>
</tr>' . self::show_stats_users($players, 3, $reply_users, $last_online);
// noen andre folk?
if (count($reply_users) > 0) {
echo '
<tr>
<th colspan="3">Andre brukere</th>
</tr>';
$i = 0;
foreach ($reply_users as $player => $ant) {
echo '
<tr' . (++$i % 2 == 0 ? ' class="color"' : '') . '>
<td><user id="' . $player . '" /></td>
<td class="r">' . game::format_number($ant) . '</td>
<td class="r">' . game::timespan($last_online[$player], game::TIME_ABS) . '</td>
</tr>';
}
}
echo '
</tbody>
</table>';
// statistikk for de siste 30 ukene
$uker = 30;
$limit = 7 * $uker;
$result = \Kofradia\DB::get()->query("\n\t\t\tSELECT num_su, num_sum, date_sum\n\t\t\tFROM\n\t\t\t\t(SELECT COUNT(sum_id) num_sum, DATE(FROM_UNIXTIME(sum_time)) date_sum\n\t\t\t\t\tFROM support_messages\n\t\t\t\t\tGROUP BY DATE(FROM_UNIXTIME(sum_time))\n\t\t\t\t\tORDER BY date_sum DESC\n\t\t\t\t\tLIMIT {$limit}) ref_sum\n\t\t\t\tLEFT JOIN\n\t\t\t\t(SELECT COUNT(su_id) num_su, DATE(FROM_UNIXTIME(su_time)) date_su\n\t\t\t\t\tFROM support\n\t\t\t\t\tGROUP BY DATE(FROM_UNIXTIME(su_time))\n\t\t\t\t\tORDER BY date_su DESC\n\t\t\t\t\tLIMIT {$limit}) ref_su ON date_sum = date_su\n\t\t\tORDER BY date_sum DESC\n\t\t\tLIMIT {$limit}");
$data = array();
$d = ess::$b->date->get();
for ($i = 0; $i < $uker; $i++) {
$w = $d->format("o-W");
$data['labels'][$w] = $w;
$data['sum'][$w] = 0;
$data['su'][$w] = 0;
$d->modify("-1 week");
}
while ($row = $result->fetch()) {
$w = ess::$b->date->parse($row['date_sum'])->format("o-W");
if (!isset($data['labels'][$w])) {
continue;
}
$data['sum'][$w] += (int) $row['num_sum'];
$data['su'][$w] += (int) $row['num_su'];
}
// reverser så nyeste kommer sist
$data['labels'] = array_reverse($data['labels']);
$data['sum'] = array_reverse($data['sum']);
$data['su'] = array_reverse($data['su']);
$ofc = new OFC();
$bar = new OFC_Charts_Area();
$bar->text("Antall meldinger");
$bar->dot_style()->type("solid-dot")->dot_size(3)->halo_size(2)->tip("#x_label#<br>#val# meldinger");
$bar->values(array_values($data['sum']));
$bar->colour(OFC_Colours::$colours[1]);
$ofc->add_element($bar);
$bar = new OFC_Charts_Area();
$bar->text("Antall henvendelser");
$bar->dot_style()->type("solid-dot")->dot_size(3)->halo_size(2)->tip("#x_label#<br>#val# henvendelser");
$bar->values(array_values($data['su']));
$bar->colour(OFC_Colours::$colours[0]);
$ofc->add_element($bar);
$ofc->axis_x()->label()->steps(2)->rotate(330)->labels(array_values($data['labels']));
$ofc->axis_y()->set_numbers(0, max(max($data['sum']), max($data['su'])));
$ofc->dark_colors();
ess::$b->page->add_js('
function open_flash_chart_data()
{
return ' . js_encode((string) $ofc) . ';
}');
ess::$b->page->add_js_file(LIB_HTTP . '/swfobject/swfobject.js');
ess::$b->page->add_js_domready('swfobject.embedSWF("' . LIB_HTTP . '/ofc/open-flash-chart.swf", "stats_support", "100%", 250, "9.0.0");');
echo '
<div class="bg1_c small">
<h2 class="bg1">Statistikk over henvendelser til support<span class="left2"></span><span class="right2"></span></h2>
<div class="bg1" style="padding: 10px">
<div id="stats_support"></div>
</div>
</div>';
}