/** * Store a newly created resource in storage. * * @return \Illuminate\Http\Response */ public function store(SiteAccidentRequest $request) { // Check authorisation and throw 404 if not if (!Auth::user()->allowedTo('add', 'accident.report')) { return view('errors/404'); } $accident_request = $request->all(); // Format date from datetime picker to mysql format $date = new Carbon(preg_replace('/-/', '', $request->get('date'))); $accident_request['date'] = $date->format('Y-m-d H:i:s'); // Create Site Accident $accident = SiteAccident::create($accident_request); // Email accident $accident->emailAccident(); Toastr::success("Lodged accident report"); $worksite = Site::find($accident_request['site_id']); return view('pages/home', compact('worksite')); }
/** * Migrate Accidents */ public function accidents() { echo "<h1>Migrating Accidents</h1>"; $accidents = zAccident::all(); $accidents->each(function ($accident) { echo "<b>" . $accident->name . "</b>({$accident->jobnum})<br>"; $site = Site::where('code', $accident->jobnum)->first(); $user = User::where('username', $accident->createdby)->first(); $status = '1'; if ($accident->resolved == "y") { $status = '0'; } $newAccident = SiteAccident::create(array('site_id' => $site->id, 'date' => $accident->date, 'name' => $accident->name, 'age' => $accident->age, 'location' => reformatOldStr($accident->location), 'nature' => reformatOldStr($accident->nature), 'occupation' => reformatOldStr($accident->occupation), 'referred' => $accident->referred, 'damage' => $accident->damage, 'info' => reformatOldStr($accident->info), 'action' => reformatOldStr($accident->action), 'occupation' => reformatOldStr($accident->occupation), 'notes' => reformatOldStr($accident->notes), 'created_at' => $accident->created, 'created_by' => $user->id, 'updated_at' => $accident->created, 'updated_by' => $user->id, 'status' => $status, 'resolved_date' => $accident->resdate)); }); echo "<h1>Completed</h1>"; }