I have a table, there I want to save check list values where 12 types with releavant values to them.
ex:
type : 1 value :a
type : 2 value :c
type : 3 value :c
Likewise 12 types, so I want to add 1 to 12 values manually. How to proceed it with a loop?
My controller:
if (Config::get('app.key') == $app_key) {
$driver = $request->driver;
$bus = $request->bus;
$shift_start = $request->shift_start;
$shift_end = $request->shift_end;
$run_type = $request->run_type;
$time_change_reason = $request->time_change_reason;
$week = $request->week;
$timesheet_date = $request->timesheet_date;
$shift_no = $request->shift_no;
$pre_departure_type = $request->pre_departure_type;
$value = $request->value;
$week_id = Week::select('id')->where('week_starting_date','=',$week)->first();
$driver_id = User::select('id')->where('username','=',$driver)->first();
$timesheet_id = Timesheets::select('id')->where('date','=',$timesheet_date)->first();
$find_shift = Shifts::select('id')->where('user_id','=',$driver_id->id)->where('week_id','=',$week_id->id)
->where('time_sheet_id','=',$timesheet_id->id)->first();
if ($find_shift) {
//update shift
// $Shift = new Shifts();
$Shift = Shifts::find($find_shift->id);
$Shift->week_id = $week_id->id;
$Shift->user_id = $driver_id->id;
$Shift->time_sheet_id = $timesheet_id->id;
$Shift->bus_no = $bus;
$Shift->shift_no= $shift_no;
$Shift->shift_start_time = $shift_start;
$Shift->shift_end_time = $shift_end;
$Shift->run_type = $run_type;
$Shift->time_change_reason = $shift_start;
$Shift->shift_end_time = $time_change_reason;
$Shift->shift_confirmation= 1;
$Shift->save();
//add checklist :: CHECK LIST BELOW
$DriverPreDepartureItems = new DriverPreDepartureItems();
$DriverPreDepartureItems->user_id = $driver_id->id;
$DriverPreDepartureItems->shift_id = $find_shift->id;
// there are 10 departure types //
$DriverPreDepartureItems->pre_departure_type = $pre_departure_type;
$DriverPreDepartureItems->value = $value;
// there are 10 departure types //
$DriverPreDepartureItems->save();
return $Shift;
}
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire