Файл: page/shop/leaders.php
Строк: 26
<?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");
?>