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