{{$page->title ?? 'Tittle'}}
@php
$locale = App::currentLocale() ?? 'en';
$locale = in_array($locale,['en','si','ta'])? $locale : 'en';
$category = $page->category_id;
$pdfs = 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('QUARTER(posts.display_at) as quarter')
->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('quater')->toArray();
@endphp
Quaterly Epidemiological Report - {{$year}}
@foreach($records as $k => $record)
-
Download
@endforeach
@endforeach
 }})
@endforeach