cache_stats.php

<?php

use src\Utils\Database\OcDb;
use src\Models\GeoCache\GeoCache;
use src\Models\ApplicationContainer;

require_once(__DIR__.'/lib/common.inc.php');

$loggedUser = ApplicationContainer::GetAuthorizedUser();
if (!$loggedUser) {
    $target = urlencode(tpl_get_current_page());
    tpl_redirect('login.php?target=' . $target);
    exit;
}


        // check for old-style parameters
        if (isset($_REQUEST['cacheid'])) {
            $cache_id = (int) $_REQUEST['cacheid'];
        } else {
            $cache_id = 0;
        }
        $geoCache = new GeoCache(array('cacheId' => $cache_id));
        $tplname = 'cache_stats';
        $content = "";
        $cachename = $geoCache->getCacheName();
        tpl_set_var('cachename', $cachename);
        $cachetime = $geoCache->getDatePlaced()->format('Y');
        $db = OcDb::instance();
        $rsGeneralStatQuery = 'SELECT count(*) count FROM `cache_logs` WHERE cache_logs.deleted=0 AND (type=1 OR type=2) AND cache_id=:1 ';
        $dbResult = $db->multiVariableQueryValue($rsGeneralStatQuery, 0, $cache_id);
        if ($dbResult == 0) {
            $content .= '<p>&nbsp;</p><p style="background-color: #FFFFFF; margin: 0px; padding: 0px; color: rgb(88,144,168); font-weight: bold; font-size: 14px;">' . $cachename . '<br /> <br />nie ma jeszcze statystyki</b></p>';
        } else {
            $content .='<center><p style="background-color: #FFFFFF; margin: 0px; padding: 0px; color: rgb(88,144,168); font-weight: bold; font-size: 14px;">' . tr("stat_geocache") . ': ' . $cachename . '<br /></p>';
            $content .= '<p style="background-color: #FFFFFF; "><img src="graphs/PieGraphcstat.php?cacheid=' . $cache_id . '"  border="0" alt="Statystyka skrzynki" width="400" height="200" /><br /><br />';
            $year = date("Y");
            $content .= '<img src="graphs/BarGraphcstatM.php?cacheid=' . $cache_id . '&amp;t=csm' . $year . '"  border="0" alt="" width="400" height="200" /><br /><br />';
            if ($cachetime != $year) {
                $yearr = $year - 1;
                $content .= '<img src="graphs/BarGraphcstatM.php?cacheid=' . $cache_id . '&amp;t=csm' . $yearr . '"  border="0" alt="" width="400" height="200" /><br /><br />';
            }
            $content .= '<img src="graphs/BarGraphcstat.php?cacheid=' . $cache_id . '&amp;t=csy"  border="0" alt="" width="400" height="200" /><br /><br /><br /></p></center>';
        }
        tpl_set_var('content', $content);
        tpl_set_var('bodyMod', ' bgcolor="#FFFFFF" style="border:none"');

tpl_BuildTemplate(true);