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