Файл: upload/pages/user/sales.php
Строк: 30
<?php
require_once ($_SERVER['DOCUMENT_ROOT'] . '/core/core.php');
if (!isset($user['id'])) {
showAlert('Ошибка', 'fail', 'Сперва необходимо авторизоваться');
RedirectToPage('/');
exit();
}
$breadcrumbs = generateBreadcrumbs([
['/', 'Главная'],
['#', 'Ваши продажи']
]);
$max = 30;
$work_num = DataResult(
dbquery("SELECT COUNT(*) FROM work_processed WHERE creator = ?", [$user['id']]),
0
);
$k_page = k_page($work_num, $max);
$page = page($k_page);
$start = $max * $page - $max;
// Сумма на удержании
$hold_sum = DataResult(
dbquery("SELECT SUM(k_money) FROM work_processed WHERE creator = ? AND stade = '1'", [$user['id']]),
0
);
// Получаем продажи
$q = dbquery("
SELECT *
FROM work_processed
WHERE creator = ?
ORDER BY time_work DESC
LIMIT ?, ?
", [$user['id'], $start, $max]);
$sales = [];
while ($wp = FetchAssoc($q)) {
$deal_ticket = FetchAssoc(
dbquery("SELECT * FROM tickets WHERE deal = ? AND stade = '0'", [$wp['id']])
);
$ank = FetchAssoc(
dbquery("SELECT * FROM users WHERE id = ?", [$wp['worker']])
);
$work = FetchAssoc(
dbquery("SELECT * FROM works WHERE id = ?", [$wp['k_work']])
);
$sales[] = [
'id' => $wp['id'],
'name' => $work['name_work'] ?? '-',
'money' => $wp['k_money'],
'time' => vremja($wp['time_work']),
'status' => WorkStatus($wp['stade']) . DealTicket($deal_ticket['id'] ?? null),
'customer' => nick($ank['id'] ?? null),
'commission' => $wp['deal_commiss'] ?? '-'
];
}
$pagination = '';
if ($k_page > 1) {
$pagination = str(homeLink() . '/sales?', $k_page, $page);
}
$page_html = $view->render('pages/user/sales.html', [
'breadcrumbs_html' => $breadcrumbs['html'],
'breadcrumbs_json' => $breadcrumbs['json_ld'],
'sales' => $sales,
'hold_sum' => $hold_sum,
'pagination' => $pagination,
'home' => homeLink()
]);
require_once ($_SERVER['DOCUMENT_ROOT'] . '/layout.php');
?>