mardi 13 octobre 2015

Add random values to table rows when saving data - mysql /laravel

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