statistic_service.php

Go to the documentation of this file.

<?php

class Statistic_Service extends oxAdminDetails
{

    public function render()
    {
        parent::render();
        $sSql = "select count(*) from oxlogs where oxshopid = '" . $this->getConfig()->getShopId() . "'";
        $this->_aViewData['iLogCount'] = oxDb::getDb()->getOne($sSql, false, false);

        return "statistic_service.tpl";
    }

    public function cleanup()
    {
        $iTimeFrame = oxRegistry::getConfig()->getRequestParameter("timeframe");
        $dNow = time();
        $iTimestamp = mktime(
            date("H", $dNow),
            date("i", $dNow),
            date("s", $dNow),
            date("m", $dNow),
            date("d", $dNow) - $iTimeFrame,
            date("Y", $dNow)
        );
        $sDeleteFrom = date("Y-m-d H:i:s", $iTimestamp);

        $oDb = oxDb::getDb();
        $oDb->Execute("delete from oxlogs where oxtime < " . $oDb->quote($sDeleteFrom));
    }
}