Hi.
How change status from 1 to 0 in table seats when i do reservation and choose a seat from this table and insert in table booking?
All the seats is in a separate table. I call this seats with ajax when choose the date for trip. All the seats show depend what date i choose.
public function bookingForm ( Request $request){
//dd($request);
$request->validate([
'addperson.*.name' => 'required',
'addperson.*.phone' => 'required',
'addperson.*.email' => 'required',
'addperson.*.date' => 'required',
'addperson.*.stationroute' => 'required',
'addperson.*.pricestation' => 'required',
],[
'addperson.*.name.required' => 'Introduceți Numele și Prenumele.',
'addperson.*.phone.required' => 'Introduceți Telefonul Mobile.',
'addperson.*.email.required' => 'Introduceți Email.',
'addperson.*.date.required' => 'Alegeți data și ora.',
'addperson.*.stationroute.required' => 'Alegeți destinația.',
'addperson.*.pricestation.required' => 'Alegeți prețul conform vîrstei dumneavoastre.',
]);
foreach ($request->addperson as $key => $value) {
BookingNow::create([
'route_id' => $value['route_id'],
'user_id'=> $user_id = auth()->user()->id,
'name' => $value['name'],
'description' => $value['description'],
'seat_no' => $value['seat_no'],
'phone' => $value['phone'],
'email' => $value['email'],
'date' => $value['date'],
'hour' => $value['hour'],
'stationroute' => $value['stationroute'],
'pricestation' => $value['pricestation'],
]);
}
Session::flash('success','Rezervarea a fost adaugat cu success');
return redirect()->back();
}