/** * Create a new RoomChangeParticipant * * @param RoomChangeRequest $request * @param Student $student * @param HMS_Bed $fromBed */ public function __construct(RoomChangeRequest $request, Student $student, HMS_Bed $fromBed) { $this->id = 0; $this->request_id = $request->getId(); $this->banner_id = $student->getBannerId(); $this->from_bed = $fromBed->getId(); // Set initial state $this->setState(new ParticipantStateNew($this, time(), null, UserStatus::getUsername())); }
public static function getParticipantByRequestStudent(RoomChangeRequest $request, Student $student) { $db = PdoFactory::getPdoInstance(); $query = "SELECT * FROM hms_room_change_curr_participant WHERE request_id = :request_id and banner_id = :bannerId"; $stmt = $db->prepare($query); $params = array('request_id' => $request->getId(), 'bannerId' => $student->getBannerId()); $stmt->execute($params); $stmt->setFetchMode(PDO::FETCH_CLASS, 'RoomChangeParticipantRestored'); return $stmt->fetch(); }
public static function getCurrentState(RoomChangeRequest $request) { $db = PdoFactory::getPdoInstance(); $query = "SELECT * FROM hms_room_change_curr_request WHERE id = :requestId"; $stmt = $db->prepare($query); $stmt->execute(array('requestId' => $request->getId())); $result = $stmt->fetch(PDO::FETCH_ASSOC); $className = 'RoomChangeState' . $result['state_name']; return new $className($request, $result['effective_date'], $result['effective_until_date'], $result['committed_by']); }