/** * Store a newly created resource in storage. * * @return \Illuminate\Http\Response */ public function store(CompanyLeaveRequest $request) { if (!Auth::user()->can('edit.company')) { return view('errors.404'); } // Format date from daterange picker to mysql format $leave_request = $request->all(); $leave_request['from'] = Carbon::createFromFormat('d/m/Y H:i', $request->get('from') . '00:00')->toDateTimeString(); $leave_request['to'] = Carbon::createFromFormat('d/m/Y H:i', $request->get('to') . '00:00')->toDateTimeString(); // Create Leave CompanyLeave::create($leave_request); Toastr::success("Created new leave", "Success"); return view('company.leave.list'); }
/** * Migrate Company Leave */ public function companyleave() { echo "<h1>Migrating Company Leave</h1>"; $companyleave = zCompanyLeave::all(); $companyleave->each(function ($leave) { echo "<b>" . $leave->cid . "</b> ({$leave->start_date})<br>"; $lookup = DB::table('z_lookup_company')->where('old', $leave->cid)->get(); $user = User::where('username', $leave->updated_by)->first(); $newLeave = CompanyLeave::create(array('company_id' => $lookup[0]->new, 'from' => $leave->start_date, 'to' => $leave->end_date, 'notes' => reformatOldStr($leave->notes), 'created_by' => $user->id, 'updated_by' => $user->id, 'created_at' => $leave->updated_at, 'updated_at' => $leave->updated_at)); }); echo "<h1>Completed</h1>"; }