$query = Model::query();
if($from) {
$query->whereDate('created_at', '>=', $from);
}
if($to) {
$query->whereDate('created_at', '<=', $to);
}
$result = $query->get();
$news = News::select('news.*')
->leftJoin('categories AS a', 'a.id', '=', 'news.category_id')
->leftJoin('categories AS b', 'b.id', '=', 'a.parent_id')
->orderByRaw('IF(b.id IS NULL, a.name, b.name)')
->orderByRaw('IF(b.id IS NULL, NULL, a.name)')
->orderBy('news.name')
->paginate($limit);
@if(($t = $City->users_active_count) > 0)
Количество активных: {{$t}}
@endif
['X-Requested-With'] = 'XMLHttpRequest'