/** * 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 sendToZipCode($inputs) { //Create a new text record $messageId = Appointment_Message::create(['lead_id' => $inputs['lead_id'], 'responses' => 0, 'zipcode' => $inputs['zipcode']]); $zipcode = Zipcode::find($inputs['zipcode']); $agents = AgentData::where('zip', $inputs['zipcode'])->groupBy('agent_id')->get([DB::raw("agent_id,zip,agent_id, COUNT(CASE WHEN source IN ('S','B') THEN 1 END) as closings,COUNT(CASE WHEN source IN ('O') THEN 1 END) as office,COUNT(CASE WHEN source IN ('H') THEN 1 END) as home,COUNT(CASE WHEN source IN ('A') THEN 1 END) as other")])->toArray(); $array_pop = $this->filterAgentsForCollection($agents, $zipcode); $agent_collection = Agents::where('mobile_phone', '!=', '')->where('is_active', 1)->where('days_red', '<=', $zipcode->min_red)->orderBy('agent_order', 'ASC')->find($array_pop); $agent_collection->add(['messageId' => $messageId->id]); return $agent_collection; }
public function destroy($id) { Zipcode::find($id)->delete(); $zipcodes = Zipcode::orderBy('name')->paginate(env('ZIPCODE_PAGINATION_MAX')); return view('zipcodes.index'); }