/** * @param $lesson_id * @return array */ public static function getAllByLessonId($lesson_id) { $lesson_id = abs(intval($lesson_id)); /** @var PDO $db */ $db = Registry::get('db'); $result = array(); $sth = $db->query("\r\n SELECT t1.* FROM " . RoomModel::TABLE . " as t1\r\n JOIN " . RoomModel::RELATION_TABLE . " as t2 USING(" . RoomModel::PRIMARY_KEY . ")\r\n JOIN " . LessonModel::TABLE . " as t3 USING(" . LessonModel::PRIMARY_KEY . ")\r\n WHERE t3." . LessonModel::PRIMARY_KEY . " = '{$lesson_id}'\r\n "); while ($data = $sth->fetch(PDO::FETCH_ASSOC)) { $room = new RoomModel(); $room->unpack($data); $result[] = $room->toArray(); } return $result; }