/** * Show the form for editing the specified resource. * * @param int $id * @return Response */ public function edit($id) { $destinationFolder = 'files/case_' . $id; if (!\File::exists($destinationFolder)) { $createDir = \File::makeDirectory($destinationFolder, 0777, true); } $caseObj = CaseReport::find($id); if ($caseObj->sub_sub_category == 0) { $case = \DB::table('cases')->join('municipalities', 'cases.precinct', '=', 'municipalities.id')->join('categories', 'cases.category', '=', 'categories.id')->join('sub-categories', 'cases.sub_category', '=', 'sub-categories.id')->join('users', 'cases.user', '=', 'users.id')->where('cases.id', '=', $id)->select(\DB::raw("\n cases.id,\n cases.description,\n cases.created_at,\n cases.status,cases.img_url,\n CONCAT(users.`name`, ' ', users.`surname`) as capturer,\n IF(`cases`.`addressbook` = 1,(SELECT CONCAT(`FirstName`, ' ', `Surname`) FROM `addressbook` WHERE `addressbook`.`id`= `cases`.`reporter`), (SELECT CONCAT(users.`name`, ' ', users.`surname`) FROM `users` WHERE `users`.`id`= `cases`.`reporter`)) as reporter,\n (select `created_at` from `caseActivities` where `caseId` = `cases`.`id` order by `created_at` desc limit 1) as last_at,\n users.email as reporterCell,\n municipalities.name as department,\n categories.name as category,\n `sub-categories`.name as sub_category,\n `cases`.sub_sub_category as sub_sub_category "))->get(); } else { $case = \DB::table('cases')->join('municipalities', 'cases.precinct', '=', 'municipalities.id')->join('categories', 'cases.category', '=', 'categories.id')->join('sub-categories', 'cases.sub_category', '=', 'sub-categories.id')->join('sub-sub-categories', 'cases.sub_sub_category', '=', 'sub-sub-categories.id')->join('users', 'cases.user', '=', 'users.id')->where('cases.id', '=', $id)->select(\DB::raw("\n cases.id,\n cases.description,\n cases.created_at,\n cases.status,\n cases.img_url,CONCAT(users.`name`, ' ', users.`surname`) as capturer,\n IF(`cases`.`addressbook` = 1,(SELECT CONCAT(`FirstName`, ' ', `Surname`) FROM `addressbook` WHERE `addressbook`.`id`= `cases`.`reporter`), (SELECT CONCAT(users.`name`, ' ', users.`surname`) FROM `users` WHERE `users`.`id`= `cases`.`reporter`)) as reporter,\n (select `created_at` from `caseActivities` where `caseId` = `cases`.`id` order by `created_at` desc limit 1) as last_at,\n users.email as reporterCell,\n municipalities.name as department,\n categories.name as category,\n `sub-categories`.name as sub_category,\n `sub-sub-categories`.name as sub_sub_category\n\n "))->get(); } return $case; }
/** * Update the specified resource in storage. * * @param Request $request * @param int $id * @return Response */ public function captureCaseUpdate(CaseRequest $request) { $houseHolderId = $request['hseHolderId']; $userRole = UserRole::where('name', '=', 'House Holder')->first(); if ($houseHolderId < 1) { $user = new User(); $user->role = $userRole->id; $user->name = $request['name']; $user->surname = $request['surname']; $user->cellphone = $request['cellphone']; $user->id_number = $request['id_number']; $user->position = $request['position']; $user->title = $request['title']; $user->house_number = $request['house_number']; $user->email = $request['cellphone'] . "@siyaleader.net"; $user->created_by = \Auth::user()->id; $language = Language::where('slug', '=', $request['language'])->first(); $user->language = $language->id; $province = Province::where('slug', '=', $request['province'])->first(); $user->province = $province->id; $district = District::where('slug', '=', $request['district'])->first(); $user->district = $district->id; $municipality = Municipality::where('slug', '=', $request['municipality'])->first(); $user->municipality = $municipality->id; $ward = Ward::where('slug', '=', $request['ward'])->first(); $user->ward = $ward->id; $user->save(); } $casePriority = CasePriority::where('slug', '=', $request['priority'])->first(); $case = CaseReport::find($request['caseID']); $case->description = $request['description']; $case->priority = $casePriority->id; $case->updated_by = \Auth::user()->id; $case->updated_at = \Carbon\Carbon::now('Africa/Johannesburg')->toDateTimeString(); $case->save(); return 'ok'; }