public function updateRequirements(Request $request) { $areaCode = Volunteers::where('id', session('volunteerId'))->first()->areaCode; $requirements = new Requirements(); $requirements->volunteerId = session('volunteerId'); $requirements->areaCode = $areaCode; $requirements->requirement = $request->get('item'); $requirements->quantity = $request->get('quantity'); $requirements->save(); return json_encode(["item" => $request->get('item'), "quantity" => $request->get('quantity')]); }
public function getReq($city) { $areas = Areas::where('city', $city)->get(); $data = []; $i = 0; foreach ($areas as $area) { $requirementsPerArea = Requirements::where('areaCode', $area->id)->get(); foreach ($requirementsPerArea as $req) { $data[$i]['areaName'] = $area->area; $data[$i]['requirements'] = $req->requirement; $volunteer = Volunteers::where('id', $req->volunteerId)->first(); $data[$i]['name'] = $volunteer->username; $data[$i]['contact'] = $volunteer->contact; $i++; } } return view('user.city')->with('data', $data); }
public function volunteerProject($id) { //Add volunteered projects to the database $user = Auth::user(); $name = $user->name; $user_id = $user->id; $project = Project::where("id", $id)->get(); $project_id = $project[0]->id; $project_name = $project[0]->name; $volunteer = new Volunteers(); $volunteer->user_id = $user_id; $volunteer->user = $name; $volunteer->project_id = $project_id; $volunteer->project_name = $project_name; $volunteer->save(); $volunteer = Volunteers::where('user', $name)->get(); //Get volunteered projects $volunteered = array(); //Create array to store volunteered project ids foreach ($volunteer as $vol) { array_push($volunteered, $vol->project_id); //Save each volunteered project id to the array } $projectV = Project::whereNotIn('id', $volunteered)->get(); //Get projects which are not volunteered return view('pages.ViewProjectsLecturer', compact('projectV', 'volunteer')); //Show volunteering projects }