<?php
$title = 'Лидеры продаж';
require_once($_SERVER["DOCUMENT_ROOT"]."/inc/head.php");
if ($sys['modules']['shop'] == 1) {

    echo '<div class="title">Лидеры продаж ('.$count_sellers.')</div>';

    if ($count_sellers == 0) {
        echo '<div class="menu">Продавцов нет.</div>';
    } else {

        $page = new Pagination($count_sellers, 10);

        $data = $connect->prepare("select *, count(*) as `count`, sum(`sum`) as `summa` from `purchase` group by `seller` order by `summa` desc, `count` desc limit :start, 10");
        $data->bindValue(':start', $page->start, PDO::PARAM_INT);
        $data->execute();
        $sql = $data->fetchAll();

        foreach ($sql as $row) {

            echo '<div class="menu">
            Продавец: '.profileLink($row['seller']).'<br/>
            Количество сделок: '.$row['count'].'<br/>
            На общую сумму: '.rub($row['summa']).'<br/>
            </div>';

        }

        $page->navigation();

    }

    echo '<div class="forlink"><a href="/shop" class="links"><img src="/img/shop.png" alt="">Магазин скриптов</a></div>';

} else {
    header('Location: /');
}

require($_SERVER["DOCUMENT_ROOT"]."/inc/foot.php");

?>