/** * Store a newly created resource in storage. * * @param Request $request * @return Response */ public function store(Request $request) { $this->validate($request, ['numbers' => 'required|max:255', 'letters' => 'required|max:255', 'housenr' => 'required|max:255']); $zipcode = Zipcode::where('pnum', $request->input('numbers'))->where('pchar', $request->input('letters'))->firstOrFail(); switch ($zipcode->numbertype) { case 'even': if ($request->input('housenr') % 2 == 0) { if ($this->between($request->input('housenr'), $zipcode->minnumber, $zipcode->maxnumber)) { return response()->json($zipcode); } else { return redirect::back()->with('error', 'uw huisnr bestaat niet i.c.m. deze postcode'); } } break; case 'odd': if ($request->input('housenr') % 2 == 1) { if ($this->between($request->input('housenr'), $zipcode->minnumber, $zipcode->maxnumber)) { return response()->json($zipcode); } else { return redirect::back()->with('error', 'uw huisnr bestaat niet i.c.m. deze postcode'); } } break; case 'mixed': if ($this->between($request->input('housenr'), $zipcode->minnumber, $zipcode->maxnumber)) { return response()->json($zipcode); } else { return redirect::back()->with('error', 'uw huisnr bestaat niet i.c.m. deze postcode'); } break; default: return redirect::back()->with('error', 'uw huisnr bestaat niet i.c.m. deze postcode'); } }
public function search(Request $request) { $token = $request->get('token'); $zipcodes = Zipcode::where('zipcode', 'LIKE', '%' . $token . '%')->orWhere('city', 'LIKE', '%' . $token . '%')->orWhere('state', 'LIKE', '%' . $token . '%')->orWhere('state_name', 'LIKE', '%' . $token . '%')->orWhere('county', 'LIKE', '%' . $token . '%')->orWhere('country', 'LIKE', '%' . $token . '%')->orderBy('zipcode')->paginate(env('ZIPCODE_PAGINATION_MAX')); return view('zipcodes.index')->with('zipcodes', $zipcodes); }