/**
* 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';
}
