/**
* Display the specified resource.
*
* @param int $id
* @return Response
*/
public function show($id)
{
$county = County::find(intval($id));
$region = Region::find(intval($county['region_id']));
$items = Municipality::where('county_id', intval($id))->get();
return view('poi.county.show')->with('county', $county)->with('region', $region)->with('items', $items);
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update(MunicipalityRequest $request)
{
$municipality = Municipality::where('id', $request['municipalityID'])->first();
$municipality->name = $request['name'];
$municipality->updated_by = \Auth::user()->id;
$municipality->save();
\Session::flash('success', 'well done! Municipality ' . $request['name'] . ' has been successfully added!');
return redirect()->back();
}
/**
* Store a newly created resource in storage.
*
* @param Request $request
* @return Response
*/
public function store(UserRequest $request, User $user)
{
/* New User Table */
$user->name = $request['Fname'];
$user->surname = $request['Sname'];
$user->cellphone = $request['Cell1'];
$user->username = $request['Email'];
$user->email = $request['Cell1'];
$position = Position::where('slug', '=', $request['Position'])->first();
$user->position = $position->id;
$province = Province::where('slug', '=', $request['Province'])->first();
$user->province = $province->id;
$district = District::where('slug', '=', $request['District'])->first();
$user->district = $district->id;
$municipalityIds = array();
foreach ($request['Municipality'] as $municipalityName) {
$municipality = Municipality::where('slug', '=', $municipalityName)->first();
$municipalityIds[] = $municipality->id;
}
$user->municipality = implode(",", $municipalityIds);
$department = Department::where('slug', '=', $request['Department'])->first();
$user->department = $department->id;
$password = rand(1000, 99999);
$user->password = \Hash::make($password);
$user->api_key = uniqid();
$user->status = 1;
$user->role = 2;
$user->save();
\Session::flash('success', $request['Fname'] . ' ' . $request['Sname'] . ' has been added successfully!');
$data = array('name' => $user->name, 'username' => $user->email, 'password' => $password);
\Mail::send('emails.registrationConfirmation', $data, function ($message) use($user) {
$message->from('*****@*****.**', 'Siyaleader');
$message->to($user->username)->subject("Siyaleader User Registration Confirmation: " . $user->name);
});
return redirect('list-users');
}
public function getAuthenticatedUser()
{
try {
if (!($user = JWTAuth::parseToken()->authenticate())) {
return response()->json(['user_not_found'], 404);
}
} catch (Tymon\JWTAuth\Exceptions\TokenExpiredException $e) {
return response()->json(['token_expired'], $e->getStatusCode());
} catch (Tymon\JWTAuth\Exceptions\TokenInvalidException $e) {
return response()->json(['token_invalid'], $e->getStatusCode());
} catch (Tymon\JWTAuth\Exceptions\JWTException $e) {
return response()->json(['token_absent'], $e->getStatusCode());
}
$user['provname'] = Province::where('provcode', '=', $user['provcode'])->get(array('provname'));
$user['cityname'] = Municipality::where('citycode', '=', $user['citycode'])->get(array('city_name'));
$user['provname'] = $user['provname'][0]['provname'];
$user['cityname'] = $user['cityname'][0]['city_name'];
// the token is valid and we have found the user via the sub claim
return response()->json(compact('user'));
}
|--------------------------------------------------------------------------
| END REPORTS ROUTING
|--------------------------------------------------------------------------
|
*/
$router->resource('users', 'UserController');
Route::get('/api/dropdown/{to}/{from}', function ($to, $from) {
$name = Input::get('option');
if ($from == 'province') {
$object = Province::where('slug', '=', $name)->first();
}
if ($from == 'district') {
$object = District::where('slug', '=', $name)->first();
}
if ($from == 'municipality') {
$object = Municipality::where('slug', '=', $name)->first();
}
$listing = DB::table($to)->where($from, $object->id)->lists('name', 'slug');
return $listing;
});
Route::get('/api/dropdownDepartment/{to}/{from}', function ($to, $from) {
$name = Input::get('option');
if ($from == 'department') {
$object = Department::where('slug', '=', $name)->first();
$listing = DB::table('categories')->where('department', '=', $object->id)->lists('name', 'slug');
}
if ($from == 'category') {
$object = Category::where('slug', '=', $name)->first();
$listing = DB::table('sub_categories')->where('category', '=', $object->id)->lists('name', 'slug');
}
if ($from == 'sub_category') {
/**
* Store a newly created resource in storage.
*
* @param Request $request
* @return Response
*/
public function captureCase(Request $request)
{
$reporter = $request['caseReporter'];
$caseSeverity = $request['caseSeverity'];
$userObj = User::where('username', '=', $reporter)->first();
if (sizeof($userObj) <= 0) {
$userAddressbookObj = addressbook::where('email', '=', $reporter)->first();
}
$user = sizeof($userObj) <= 0 ? $userAddressbookObj->id : $userObj->id;
$addressbook = sizeof($userObj) <= 0 ? 1 : 0;
$userName = sizeof($userObj) <= 0 ? $userAddressbookObj->FirstName : $userObj->name;
$userSurname = sizeof($userObj) <= 0 ? $userAddressbookObj->Surname : $userObj->surname;
$userEmail = sizeof($userObj) <= 0 ? $userAddressbookObj->email : $userObj->username;
$cell = sizeof($userObj) <= 0 ? $userAddressbookObj->cellphone : $userObj->email;
$caseDescription = $request['caseDescription'];
$precinctObj = Municipality::where('slug', '=', $request['caseMunicipality'])->first();
$categoryObj = Category::where('slug', '=', $request['caseCategory'])->first();
$subCategoryObj = SubCategory::where('slug', '=', $request['caseSubCategory'])->first();
if ($request['caseSubSubCategory'] > 0) {
$subSubCategoryObj = SubSubCategory::where('slug', '=', $request['caseSubSubCategory'])->first();
$subSubCategory = $subSubCategoryObj->id;
} else {
$subSubCategory = 0;
}
$gps = explode(",", $request['GPS']);
$caseObj = new CaseReport();
$caseObj->description = htmlentities($caseDescription);
$caseObj->user = \Auth::user()->id;
$caseObj->reporter = $user;
$caseObj->addressbook = $addressbook;
$caseObj->precinct = $precinctObj->id;
$caseObj->category = $categoryObj->id;
$caseObj->sub_category = $subCategoryObj->id;
$caseObj->sub_sub_category = $subSubCategory;
$caseObj->gps_lat = $gps[0];
$caseObj->gps_lng = $gps[1];
$caseObj->severity = $caseSeverity;
$caseObj->status = "Pending";
$caseObj->save();
$data = array('name' => $userName, 'caseID' => $caseObj->id, 'caseDesc' => $caseObj->description);
$caseOwner = new CaseOwner();
$caseOwner->user = $user;
$caseOwner->caseId = $caseObj->id;
$caseOwner->type = 0;
$caseOwner->active = 1;
$caseOwner->save();
\Mail::send('emails.sms', $data, function ($message) use($userEmail) {
$message->from('*****@*****.**', 'Siyaleader');
$message->to($userEmail)->subject("Siyaleader Notification - New Case Reported:");
});
if ($caseSeverity <= 4) {
$severityData = array('severity' => $caseObj->severity, 'name' => $userName . ' ' . $userSurname, 'cell' => $cell, 'category' => $categoryObj->name, 'caseId' => $caseObj->id);
\Mail::send('emails.severity', $severityData, function ($message) {
$message->from('*****@*****.**', 'Siyaleader');
$message->to('*****@*****.**')->subject("SEVERE");
});
$criticalTeam = CriticalTeam::all();
foreach ($criticalTeam as $critical) {
$caseOwner = new CaseOwner();
$caseOwner->user = $critical->user;
$caseOwner->caseId = $caseObj->id;
$caseOwner->type = 5;
//Critical Team
$caseOwner->active = 1;
$caseOwner->save();
\Mail::send('emails.severity', $severityData, function ($message) use($critical) {
$userObj = User::find($critical->user);
$message->from('*****@*****.**', 'Siyaleader');
$message->to($userObj->username)->subject("Siyaleader Notification - New Severe Case Reported:");
});
}
}
if ($subSubCategory > 0) {
$subSubCatResponders = CaseResponder::where('sub_sub_category', '=', $subSubCategory)->first();
if (sizeof($subSubCatResponders) > 0) {
if ($subSubCatResponders->firstResponder) {
$firstResponderUser = User::find($subSubCatResponders->firstResponder);
$caseOwner = new CaseOwner();
$caseOwner->user = $subSubCatResponders->firstResponder;
$caseOwner->caseId = $caseObj->id;
$caseOwner->type = 1;
$caseOwner->active = 1;
$caseOwner->save();
$data = array('name' => $firstResponderUser->name, 'caseID' => $caseObj->id, 'caseDesc' => $caseObj->description, 'caseReporter' => $caseObj->description);
\Mail::send('emails.responder', $data, function ($message) use($firstResponderUser) {
$message->from('*****@*****.**', 'Siyaleader');
$message->to($firstResponderUser->username)->subject("Siyaleader Notification - New Case Reported:");
});
}
if ($subSubCatResponders->secondResponder) {
$secondResponderUser = User::find($subSubCatResponders->secondResponder);
$caseOwner = new CaseOwner();
$caseOwner->user = $subSubCatResponders->secondResponder;
$caseOwner->caseId = $caseObj->id;
$caseOwner->type = 2;
$caseOwner->active = 1;
$caseOwner->save();
$data = array('name' => $secondResponderUser->name, 'caseID' => $caseObj->id, 'caseDesc' => $caseObj->description, 'caseReporter' => $caseObj->description);
\Mail::send('emails.responder', $data, function ($message) use($secondResponderUser) {
$message->from('*****@*****.**', 'Siyaleader');
$message->to($secondResponderUser->username)->subject("Siyaleader Notification - New Case Reported:");
});
}
if ($subSubCatResponders->thirdResponder) {
$thirdResponderUser = User::find($subSubCatResponders->thirdResponder);
$caseOwner = new CaseOwner();
$caseOwner->user = $subSubCatResponders->thirdResponder;
$caseOwner->caseId = $caseObj->id;
$caseOwner->type = 3;
$caseOwner->active = 1;
$caseOwner->save();
$data = array('name' => $thirdResponderUser->name, 'caseID' => $caseObj->id, 'caseDesc' => $caseObj->description, 'caseReporter' => $caseObj->description);
\Mail::send('emails.responder', $data, function ($message) use($thirdResponderUser) {
$message->from('*****@*****.**', 'Siyaleader');
$message->to($thirdResponderUser->username)->subject("Siyaleader Notification - New Case Reported:");
});
}
}
}
if ($subSubCategory == 0) {
$subCatResponders = CaseResponder::where('sub_category', '=', $subCategoryObj->id)->first();
if (sizeof($subCatResponders) > 0) {
if ($subCatResponders->firstResponder) {
$firstResponderUser = User::find($subCatResponders->firstResponder);
$caseOwner = new CaseOwner();
$caseOwner->user = $subCatResponders->firstResponder;
$caseOwner->caseId = $caseObj->id;
$caseOwner->type = 1;
$caseOwner->active = 1;
$caseOwner->save();
$data = array('name' => $firstResponderUser->name, 'caseID' => $caseObj->id, 'caseDesc' => $caseObj->description, 'caseReporter' => $caseObj->description);
\Mail::send('emails.responder', $data, function ($message) use($firstResponderUser) {
$message->from('*****@*****.**', 'Siyaleader');
$message->to($firstResponderUser->username)->subject("Siyaleader Notification - New Case Reported:");
});
}
if ($subCatResponders->secondResponder) {
$secondResponderUser = User::find($subCatResponders->secondResponder);
$caseOwner = new CaseOwner();
$caseOwner->user = $subCatResponders->secondResponder;
$caseOwner->caseId = $caseObj->id;
$caseOwner->type = 2;
$caseOwner->active = 1;
$caseOwner->save();
$data = array('name' => $secondResponderUser->name, 'caseID' => $caseObj->id, 'caseDesc' => $caseObj->description, 'caseReporter' => $caseObj->description);
\Mail::send('emails.responder', $data, function ($message) use($secondResponderUser) {
$message->from('*****@*****.**', 'Siyaleader');
$message->to($secondResponderUser->username)->subject("Siyaleader Notification - New Case Reported:");
});
}
if ($subCatResponders->thirdResponder) {
$thirdResponderUser = User::find($subCatResponders->thirdResponder);
$caseOwner = new CaseOwner();
$caseOwner->user = $subCatResponders->thirdResponder;
$caseOwner->caseId = $caseObj->id;
$caseOwner->type = 3;
$caseOwner->active = 1;
$caseOwner->save();
$data = array('name' => $thirdResponderUser->name, 'caseID' => $caseObj->id, 'caseDesc' => $caseObj->description, 'caseReporter' => $caseObj->description);
\Mail::send('emails.responder', $data, function ($message) use($thirdResponderUser) {
$message->from('*****@*****.**', 'Siyaleader');
$message->to($thirdResponderUser->username)->subject("Siyaleader Notification - New Case Reported:");
});
}
}
}
return redirect()->back();
}
/**
* Display the specified resource.
*
* @param int $id
* @return Response
*/
public function show($provcode)
{
return Municipality::where('provcode', '=', $provcode)->get();
}
/**
* 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';
}
/**
* Update the specified resource in storage.
*
* @param Request $request
* @param int $id
* @return Response
*/
public function update(UpdateUserRequest $request)
{
$user = User::where('id', $request['userID'])->first();
$role = UserRole::where('slug', '=', $request['role'])->first();
$user->role = $role->id;
$title = Title::where('slug', '=', $request['title'])->first();
$user->title = $title->id;
$user->name = $request['name'];
$user->surname = $request['area'];
$user->id_number = $request['id_number'];
$user->alt_cellphone = $request['alt_cellphone'];
$user->alt_email = $request['alt_email'];
$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->area = $request['area'];
$user->updated_by = \Auth::user()->id;
$user->updated_at = \Carbon\Carbon::now('Africa/Johannesburg')->toDateTimeString();
$user->save();
\Session::flash('success', 'well done! User ' . $request['name'] . ' has been successfully updated!');
return redirect()->back();
}
