/** * Schedule a piece of equipment. * * @param $event_id * @param $inventory_id */ public function schedule() { if (!Sentry::getUser()) { return Redirect::route('sessions.create'); } $validator = Validator::make($data = Input::all(), EventEquipment::$rules); if ($validator->fails()) { return Redirect::back()->withErrors($validator)->withInput(); } /* * * coming up with a better solution to this problem. might take a while but what ever $_startdate = 0; $_enddate = 0; $equipment = EventEquipment::where('id', '=', $data['equipment_id'])->get(); echo "<pre>"; foreach($equipment as $e){ $date = EventDate::where('id', '=', $e->date_id)->first(); if($_startdate < $date->startdate){ $_startdate = $date->startdate; } if($_enddate < $date->enddate){ $_enddate = $date->enddate; } } $newdate = EventDate::where('id', '=', $data['date_id'])->first(); $startdate = $newdate->startdate; $enddate = $newdate->enddate; print_r($_startdate . ' -- '. $startdate); echo "\n---\n"; print_r($_enddate . ' -- '. $enddate); if((($_startdate <= $enddate) && ($_startdate >= $startdate)) || (($_enddate <= $enddate) && ($_enddate >= $startdate)) ) { echo "dates overlap"; if(Inventory::where('id', '=', $data['equipment_id'])->first()->quantity > EventEquipment::where('equipment_id', '=', $data['equipment_id'])->first()->quantity) { echo "inventory avaliable"; #EventEquipment::create($data); #return Redirect::route('events.index'); }else{ echo "inventory not avaliable"; } }else{ #EventEquipment::create($data); #return Redirect::route('events.index'); echo "dates dont overlap"; } */ EventEquipment::create($data); return Redirect::back(); }