{{$page->title ?? 'Tittle'}}
@php
$locale = App::currentLocale() ?? 'en';
$locale = in_array($locale,['en','si','ta'])? $locale : 'en';
$category = $page->category_id;
$pdfs = collect(Post::leftJoin('post_pdfs','posts.id', '=', 'post_pdfs.post_id')
->whereHas('categories', function($q) use($category){
$q->where('category_id', $category);
})
->select('post_pdfs.pdf')->selectRaw('posts.title_'.$locale.' as name')->selectRaw('YEAR(posts.display_at) as year')
->selectRaw('CONCAT(DATE_FORMAT(SUBDATE(posts.display_at, WEEKDAY(posts.display_at)),"%d")," - ",DATE_FORMAT((ADDDATE(posts.display_at, (6 - WEEKDAY(posts.display_at)))),"%d")) as weekrange')
->selectRaw('week(posts.display_at) as week')
->orderBy('posts.display_at', 'DESC')
->get())
->toArray();
$data=[];
foreach($pdfs as $key =>$pdf){
$data[$pdf['year']][] = $pdf;
}
@endphp
@foreach($data as $year => $records)
@php
$records = collect($records)->sortBy('week')->toArray();
@endphp
Weekly Epidemiological Report - {{$year}}
@foreach($records as $k => $record)
-
Download
@endforeach
@endforeach
 }})
@endforeach