Файл: upload/pages/user/buys.php
Строк: 28
<?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 worker = ?", [$user['id']]),
0
);
$k_page = k_page($work_num, $max);
$page = page($k_page);
$start = $max * $page - $max;
$q = dbquery("
SELECT *
FROM work_processed
WHERE worker = ?
ORDER BY time_work DESC
LIMIT ?, ?
", [$user['id'], $start, $max]);
$buys = [];
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['creator']])
);
$work = FetchAssoc(
dbquery("SELECT * FROM works WHERE id = ?", [$wp['k_work']])
);
$buys[] = [
'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),
'worker' => nick($ank['id'] ?? null)
];
}
$pagination = '';
if ($k_page > 1) {
$pagination = str(homeLink() . '/buys?', $k_page, $page);
}
$page_html = $view->render('pages/user/buys.html', [
'breadcrumbs_html' => $breadcrumbs['html'],
'breadcrumbs_json' => $breadcrumbs['json_ld'],
'buys' => $buys,
'pagination' => $pagination,
'home' => homeLink()
]);
require_once ($_SERVER['DOCUMENT_ROOT'] . '/layout.php');
?>