input('province_id');
session()->put('province', $province);
$district = $request->input('district_id');
session()->put('district', $district);
$locallevel = $request->input('locallevel_id');
session()->put('locallevel', $locallevel);
$specializations = $request->input('specialization');
session()->put('specializations', $specializations);
$results = [];
if ($province || $district || $locallevel || $specializations) {
// Start with a base query
$query = Members::query();
// Add conditions for selected fields
if ($province) {
$query->where('province_id', $province);
}
if ($district) {
$query->where('district_id', $district);
}
if ($locallevel) {
$query->where('locallevel_id', $locallevel);
}
if ($specializations) {
$query->where('specialization_id', $specializations);
}
$results = $query->distinct()->select('level_id')->get();
session()->put('report-back', route('summarizereport'));
$showingReport = true;
}
return view('reports.summarizereports', compact('showingReport', 'results', 'provinces', 'districts', 'locallevels', 'specialization'));
}
public function summarizedetail($id, $hash)
{
// check hash authenticity
if (!checkHash($id, $hash)) {
return back()->with('error', 'INACCESSABLE !');
}
$level = Level::findOrFail($id);
$province = session('province');
$district = session('district');
$locallevel = session('locallevel');
$specializations = session('specializations');
$results = [];
if ($province || $district || $locallevel || $specializations) {
$query = Members::query();
if ($province) {
$query->where('province_id', $province);
}
if ($district) {
$query->where('district_id', $district);
}
if ($locallevel) {
$query->where('locallevel_id', $locallevel);
}
if ($specializations) {
$query->where('specialization_id', $specializations);
}
// Execute the query
$results = $query->where('level_id', $id)->get();
}
return view('reports.summarizereportdetail', compact('results', 'level'));
}
}