Файл: upload/pages/home/home.php
Строк: 25
<?php
$seals = DataResult(dbquery("SELECT COUNT(*) FROM `work_processed` WHERE `creator` = ? AND `stade` = '2'", [$user['id']]), 0);
$buys = DataResult(dbquery("SELECT COUNT(*) FROM `work_processed` WHERE `worker` = ? AND `stade` = '2'", [$user['id']]), 0);
$category = [];
$q = dbquery("SELECT * FROM `category` ORDER BY `id`");
while ($row = FetchAssoc($q)) {
$category[] = [
'id' => $row['id'],
'name' => $row['name'],
'image' => GetCategoryImage($row['k_image'])
];
}
$max_works = 30;
$week_time = time() - 604800;
$works = [];
$q = dbquery("SELECT * FROM works WHERE time_work > ? ORDER BY id DESC LIMIT 0, $max_works", [$week_time]);
$k_post = DataResult(dbquery("SELECT COUNT(*) FROM `works` WHERE `time_work` > ?", [$week_time]), 0);
while ($work = FetchAssoc($q)) {
// Передаём данные в компонент
$GLOBALS['work'] = $work;
$GLOBALS['user'] = $user;
// Подключаем компонент, который создаёт $work_item
require ($_SERVER['DOCUMENT_ROOT'] . '/core/elements/work-box.php');
// Добавляем HTML в массив
$works[] = $work_item;
}
$page_html = $view->render('pages/home/home.html', [
'home' => homeLink(),
'user' => $user,
'buys' => $buys,
'avatar' => GetAvatar($user['avatar']),
'seals' => $seals,
'categories'=> $category,
'works' => $works,
'k_post' => $k_post,
'max_works' => $max_works,
'rating_num' => rating_num_worker($user['id']),
'rating_star' => rating_star_worker($user['id'])
]);
?>
<script>
$(document).on('click', '#load-more-week', function() {
let btn = $(this);
let offset = parseInt(btn.data('offset'));
$.ajax({
url: '/core/ajax/home/load_more_home_work.php',
type: 'POST',
dataType: 'json',
data: { offset: offset },
success: function(res) {
$('.works-list-week').append(res.html);
if (!res.show_more) {
btn.remove();
} else {
btn.data('offset', offset + 30);
}
}
});
});
</script>