<?php

if ( $_SESSION['dostup'] != 'a' && $_SESSION['dostup'] != 'e' && $_SESSION['dostup'] != 'c' ) header( 'Location: /login/' );// && $dostup!='m'
ini_set('display_errors', 0 );
class modClass
{
    public static $catID = 0; // int
    /*  ----------------------------------------------------------------------
        30.08.2024
        Получаем статистику скорости
    ----------------------------------------------------------------------  */
    static function getSpeed($mod)
    {
        $nedelya=time()-(2419200*4);
        $massiv=\DBmysql::getAll("SELECT round(AVG(`speed`), 2) AS `speed`, `t` FROM `speed` WHERE `t`>? AND `content_type`=? AND `site`=? GROUP BY(`d`)", [$nedelya, $mod, $_SERVER['SERVER_NAME']]);
        $count=count($massiv);
        for ($i=0; $i<$count; $i++)$res.="{ x: new Date(" . date("Y", $massiv[$i]['t']) . ", " . date("m", $massiv[$i]['t']) . ", " . date("d",$massiv[$i]['t']) . "),  y: " . $massiv[$i]['speed'] . " },";
        $res = substr($res, 0, -1);
        return $res;
    }
}
$smarty -> assign( 'g_tovar_show', modClass::getSpeed('tovar_show'));
$smarty -> assign( 'g_tovar_cat', modClass::getSpeed('tovar_cat'));
$smarty -> assign( 'g_main', modClass::getSpeed('main'));
$smarty -> assign( 'g_admin', modClass::getSpeed('admin'));
$smarty -> assign( 'g_sitemap', modClass::getSpeed('qsitemap'));
$smarty -> assign( 'g_robots', modClass::getSpeed('robots'));
$smarty -> assign( 'g_rss', modClass::getSpeed('rss'));
$smarty -> assign( 'g_find', modClass::getSpeed('new_find'));
$smarty -> assign( 'g_page', modClass::getSpeed('page'));
/*  ----------------------------------------------------------------------
    14.12.2022
    Читаем заметки
----------------------------------------------------------------------  */
$zametka = \DBmysql::getValue( 'SELECT `txt` FROM `zametka` WHERE `user_id`=' . $_SESSION['user_id'] );
$smarty -> assign( 'zametka', $zametka );
/*  ----------------------------------------------------------------------
    14.12.2022
    Получаем инфу о пользователе
----------------------------------------------------------------------  */
$smarty -> assign( 'userInfo', \core::getUserInfo( $_SESSION['user_id'] ) );
/*  ----------------------------------------------------------------------
    14.12.2022
    Получаем список задач
----------------------------------------------------------------------  */
$tasks = \DBmysql::getAll( "SELECT * FROM `tasks` WHERE `site`=? ORDER BY `id` DESC LIMIT 10", $_SERVER['SERVER_NAME'] );
$smarty -> assign( 'tasks', $tasks );
/*  ----------------------------------------------------------------------
    14.12.2022
    Получаем список разработчиков
----------------------------------------------------------------------  */
$coders = \DBmysql::getAll( "SELECT * FROM `users` WHERE `dostup`='a' OR `dostup`='c' ORDER BY `fio`" );
$smarty -> assign( 'coders', $coders );
/*  ----------------------------------------------------------------------
    26.12.2022
    Товар без картинок
----------------------------------------------------------------------  */
$tovarBezImg = \DBmysql::getAll( "SELECT count(*) FROM `tovar` WHERE (`countImg`=0 OR `countImg`='' OR `countImg` ISNULL) AND `status`=1" );
$smarty -> assign( 'tovarBezImg', $tovarBezImg[0]['count(*)'] );
?>