/** * Store a newly created resource in storage. * * @return \Illuminate\Http\Response */ public function store(SiteIssueRequest $request) { // Check authorisation and throw 404 if not if (!Auth::user()->allowedTo('add', 'issue.report')) { return view('errors/404'); } $issue_request = $request->except('action'); $site = Site::findOrFail($issue_request['site_id']); $issue = SiteIssue::create($issue_request); //Create action taken + attach image to issue if ($issue) { $action_request = $request->only('action'); $action = $issue->actions()->save(new SiteIssueAction($action_request)); // Handle attached Photo or Video if ($request->hasFile('media')) { $issue->saveAttachedMedia($request->file('media')); } // Email issue $issue->emailIssue($action); } Toastr::success("Lodged safety issue"); $worksite = Site::findOrFail($issue_request['site_id']); return view('pages/home', compact('worksite')); }
/** * Migrate Issues */ public function issues() { echo "<h1>Migrating Site Actions</h1>"; $issues = zAction::all(); $issues->each(function ($issue) { echo "<b>" . $issue->jobnum . "</b>({$issue->sub_id})<br>"; if ($issue->jobnum) { if ($issue->jobnum == '003') { $issue->jobnum = '0003'; } $site = Site::where('code', $issue->jobnum)->first(); $user = User::where('username', $issue->sub_id)->first(); $status = '1'; if ($issue->resolved == "y") { $status = '0'; } $req = '1'; if ($issue->codreq == "y") { $req = '0'; } $newIssue = SiteIssue::create(array('site_id' => $site->id, 'reason' => reformatOldStr($issue->reason), 'action_required' => $req, 'notes' => reformatOldStr($issue->notes), 'resolved_date' => $issue->resdate, 'status' => $status, 'created_at' => $issue->date, 'updated_at' => $issue->date, 'created_by' => $user->id)); if ($issue->photo) { list($s, $u, $photo) = explode('_', $issue->photo, 3); $newIssue->photo = 'issue-' . $site->code . '-' . $newIssue->id . '-' . $user->id . '-' . $photo; $newIssue->save(); // Copy file to new location if (file_exists('filebankOrig/photos/' . $issue->photo)) { $dir = 'filebank/site/' . $site->id . '/issue/'; $newfile = $dir . $newIssue->photo; if (!file_exists($dir)) { mkdir($dir, 0777, true); echo "created directory {$dir} <br>"; } if (!file_exists($newfile)) { echo "copying to {$newfile}<br>"; if (!copy('filebankOrig/photos/' . $issue->photo, $newfile)) { echo "*** FAILED to copy {$issue->photo}...\n"; } } } } $newIssueAction = SiteIssueAction::create(array('issue_id' => $newIssue->id, 'action' => reformatOldStr($issue->sub_action), 'created_by' => $user->id, 'created_at' => $issue->date, 'updated_at' => $issue->date)); $site_super = $site->supervisors->pluck('id')->toArray(); if ($issue->cod_action) { $newIssueAction2 = SiteIssueAction::create(array('issue_id' => $newIssue->id, 'action' => reformatOldStr($issue->cod_action), 'created_by' => $site_super[0], 'created_at' => $issue->date, 'updated_at' => $issue->date)); } if ($issue->notes) { $newIssueAction3 = SiteIssueAction::create(array('issue_id' => $newIssue->id, 'action' => reformatOldStr($issue->notes), 'created_by' => $site_super[0], 'created_at' => $issue->resdate, 'updated_at' => $issue->resdate)); } } }); echo "<h1>Completed</h1>"; }