input('district_id');
$locallevel = $request->input('locallevel_id');
$ward = $request->input('ward');
$results = [];
$dist = [];
$lole = [];
$query = Members::query();
if ($district || $locallevel || $ward) {
if ($district) {
$query = $query->where('district_id', $district);
$dist = District::find($district);
}
if ($locallevel) {
$query = $query->where('locallevel_id', $locallevel);
$lole = Locallevel::find($locallevel);
}
if ($ward) {
$query->where('ward', UTF8toEng($ward));
}
$results = $query->where('certificate_status', '1')
->where('level_id', '!=', '5')
->orderBy('reg_no', 'asc')
->get();
session()->put('report-back', make_route('election-reports.param'));
$showingReport = true;
}
return view('reports.electionparam', compact('showingReport', 'locallevels', 'districts', 'results', 'dist', 'lole', 'ward'));
}
}