public function update(WardRequest $request)
{
$ward = Ward::where('id', $request['wardID'])->first();
$ward->name = $request['name'];
$ward->updated_by = \Auth::user()->id;
$ward->save();
\Session::flash('success', 'well done! Ward ' . $request['name'] . ' has been successfully added!');
return redirect()->back();
}
/**
* List Ward by District id ajax.
*/
public function getWardsByDistrict($district_id)
{
$wards = Ward::where('district_id', $district_id)->orderBy('priority')->get();
return $wards->toArray();
}
public function wards()
{
$wards = Ward::where('subcounty_id', \Input::get('subcounty'))->get();
return $wards;
}
/**
* PROJECT_TYPE vs PROVINCE vs DISTRICT vs WARD
*/
public function project_type_province_district_ward($project_type_key, $province_key, $district_key, $ward_key, Request $request)
{
$ward = Ward::findByKey($ward_key)->first();
if (is_null($ward)) {
$ward = Ward::where('is_publish', 1)->orderBy('priority')->orderBy('created_at', 'desc')->first();
}
$district = $ward->district;
$province = $district->province;
$limit = Config::findByKey('rows_per_page_project')->first()->value;
$project_type = Project_type::findByKey($project_type_key)->first();
if (is_null($project_type)) {
$project_type = Project_type::where('active', 1)->orderBy('priority')->orderBy('created_at', 'desc')->first();
}
$projects = Project::where('project_type_id', $project_type->id)->where('district_id', $district->id)->where('active', 1);
$projects = $projects->orderBy('priority')->orderBy('created_at', 'desc')->paginate($limit);
$searchDescription = $project_type->name . ' ' . $province->name . ' ' . $district->name . ' ' . $ward->name;
$link = route('project_type_province_district_ward', ['project_type_key' => $project_type->key, 'province_key' => $province->key, 'district_key' => $district->key, 'ward_key' => $ward->key]);
$breadcrumb = '<ul class="breadcrumb">
<li class="active"><a href="' . route('homepage') . '">Trang chủ</a></li>
<li class="active"><a href="' . route('projects') . '">Dự án</a></li>
<li class="active"><a href="' . route('project_type', ['project_type_key' => $project_type->key]) . '">' . $project_type->name . '</a></li>
<li class="active"><a href="' . route('project_type_province', ['project_type_key' => $project_type->key, 'province_key' => $province->key]) . '">' . $province->name . '</a></li>
<li class="active"><a href="' . route('project_type_province_district', ['project_type_key' => $project_type->key, 'province_key' => $province->key, 'district_key' => $district->key]) . '">' . $district->name . '</a></li>
<li class=""><a href="' . $link . '">' . $ward->name . '</a></li>
</ul>';
$heading = $project_type->name . ' ' . $province->name . ' ' . $district->name . ' ' . $ward->name;
$projectCategory = new ProjectCategory();
$projectsSpecial = $projectCategory->getProjectsByCategoryKey('du-an-noi-bat', 5);
$this->setMetadata($searchDescription);
return view('frontend.sites1.project_search', ['projects' => $projects, 'project_type' => $project_type, 'district' => $district, 'projectsSpecial' => $projectsSpecial, 'search_type' => 'project_type_province_district', 'link' => $link, 'searchDescription' => $searchDescription, 'breadcrumb' => $breadcrumb, 'heading' => $heading]);
}
/**
* 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();
}
