withCount('members')->get();
$levelName = Level::orderBy('id')->withCount('members')->get();
$provinces = Province::pluck('province', 'id');
$districts = District::pluck('district_name', 'id');
$locallevels = Locallevel::pluck('local_name', 'id');
$showingReport = false;
// Retrieve selected data from the form
$province = $request->input('province_id');
$district = $request->input('district_id');
$locallevel = $request->input('locallevel_id');
$results = [];
if ($province || $district || $locallevel) {
// 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);
}
// Execute the query
$results = $query->get();
session()->put('report-back', route('sumreports'));
$showingReport = true;
}
// Pass the results to the view
return view('reports.sum-reports', compact('showingReport', 'results', 'provinces', 'districts', 'locallevels'));
}
public function showAllMembers()
{
$members = Members::all();
return view('reports.all_members', compact('members'));
}
}