public function postAddResident(Request $http) { $resident = Resident::find($http->resident_id); $residence = Residence::find($http->residence_id); $query = 'select * from calcdb.residence_resident where resident_id = ? and residence_id = ?'; $statement = DB::select($query, array($resident->id, $residence->id)); // Create relationship between residence and newly added resident $residence->residents()->attach($resident->id); return response()->json(['status' => 200, 'query' => $query]); }
public function getRoomUsers($confId, $resId, $roomName) { if (!Entrust::can(PermissionNames::ConferenceRoomEdit($confId))) { return response("", 403); } $res = Residence::find($resId); if (is_null($res) || $res->conferenceID != $confId) { return response("", 404); } return $this->findRoomUsers($resId, $roomName); }
/** * Show the form for creating a new resource. * * @return \Illuminate\Http\Response */ public function create($id) { $residence = Residence::find($id); return view('bills.create', compact('residence')); }
public function createRoomSet(Request $req, $confId, $residenceId) { if (!Entrust::can(PermissionNames::ConferenceRoomEdit($confId))) { return response("", 403); } return DB::transaction(function () use($req, $confId, $residenceId) { $res = Residence::find($residenceId); if (is_null($res) || $res->conferenceID != $confId) { return response("", 404); } $responses = []; foreach ($req->all() as $request) { $this->validateRoomSet($request); if (isset($request['typeID'])) { $type = $request['typeID']; } else { $tyVal = new RoomType(); $tyVal->name = $request['type']['name']; $tyVal->capacity = $request['type']['capacity']; $tyVal->accessible = $request['type']['accessible']; $tyVal->save(); $type = $tyVal->id; } $set = new RoomSet(); $set->typeID = $type; $set->residenceID = $residenceId; $set->name = $request['name']; $set->save(); $responses[] = ['name' => $set->name, 'id' => $set->id, 'typeID' => $type]; } Log::info("Created " . sizeof($responses) . " new room sets in residence {$res->name} for conference {$confId}"); return response()->json($responses); }); }