public function index(Request $request) { $sMissing = $request->get('missing_cmpd'); $query = HouseholdAddress::query(); if ($sMissing) { $query->missingCmpdInfo(); } return $query->get(); }
public function cmpdAddressInfo() { $count_incomplete = HouseholdAddress::query()->missingCmpdInfo()->count(); return view('admin.tools.cmpd_address_info', ['count_incomplete' => $count_incomplete]); }