Файл: upload/pages/deals/view-deals.php
Строк: 35
<?php
require_once ($_SERVER['DOCUMENT_ROOT'] . '/core/core.php');
if ($users_perms['manage_deal'] != 1) {
RedirectToPage('/');
exit();
}
$creator = intval($_GET['creator']);
$worker = intval($_GET['worker']);
$breadcrumbs = generateBreadcrumbs([
['/', 'Главная'],
['#', 'Сделки сторон']
]);
$max = 30;
// Количество сделок
$work_num = DataResult(
dbquery("
SELECT COUNT(*)
FROM work_processed
WHERE (worker = ? AND creator = ?) OR (worker = ? AND creator = ?)
", [$worker, $creator, $creator, $worker]),
0
);
$k_page = k_page($work_num, $max);
$page = page($k_page);
$start = $max * $page - $max;
// Получаем сделки
$q = dbquery("
SELECT *
FROM work_processed
WHERE (worker = ? AND creator = ?) OR (worker = ? AND creator = ?)
ORDER BY time_work DESC
LIMIT ?, ?
", [$worker, $creator, $creator, $worker, $start, $max]);
$deals = [];
while ($wp = FetchAssoc($q)) {
$deal_ticket = FetchAssoc(
dbquery("SELECT * FROM tickets WHERE deal = ? AND stade = '0'", [$wp['id']])
);
$ank_creator = FetchAssoc(
dbquery("SELECT * FROM users WHERE id = ?", [$wp['creator']])
);
$ank_worker = FetchAssoc(
dbquery("SELECT * FROM users WHERE id = ?", [$wp['worker']])
);
$work = FetchAssoc(
dbquery("SELECT * FROM works WHERE id = ?", [$wp['k_work']])
);
$deals[] = [
'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_worker['id'] ?? null),
'creator' => nick($ank_creator['id'] ?? null)
];
}
$pagination = '';
if ($k_page > 1) {
$pagination = str(homeLink() . '/deal-view/' . $creator . '/' . $worker . '/?', $k_page, $page);
}
$page_html = $view->render('pages/deals/view-deals.html', [
'breadcrumbs_html' => $breadcrumbs['html'],
'breadcrumbs_json' => $breadcrumbs['json_ld'],
'deals' => $deals,
'pagination' => $pagination,
'home' => homeLink()
]);
require_once ($_SERVER['DOCUMENT_ROOT'] . '/layout.php');
?>