/** * @param string|int $teacher_name * @param string $cond * @return array * @throws ApiException */ public static function getAllByTeacherNameOrTeacherId($teacher_name, $cond = "") { $result = array(); //hide some properties $hideFilter = array('group_id' => true); Registry::set('LessonModelHideFilter', $hideFilter); $teacher_name = urldecode(trim($teacher_name)); /** @var PDO $db */ $db = Registry::get('db'); $teacher_id = $db->query("\r\n SELECT teacher_id FROM " . TeacherModel::TABLE . "\r\n WHERE (teacher_name = " . $db->quote($teacher_name) . " OR teacher_id = " . $db->quote($teacher_name) . ")\r\n ")->fetchColumn(); $count = 0; if ($teacher_id) { $count = $db->query("\r\n SELECT COUNT(*) FROM " . LessonModel::TABLE . " AS t1\r\n JOIN " . TeacherModel::RELATION_TABLE . " as t2 USING(" . LessonModel::PRIMARY_KEY . ")\r\n WHERE t2." . TeacherModel::PRIMARY_KEY . " = '" . abs(intval($teacher_id)) . "' {$cond}\r\n ")->fetchColumn(); } if ($count > 0) { $query = $db->query("\r\n SELECT *\r\n FROM " . LessonModel::TABLE . " AS t1\r\n JOIN " . TeacherModel::RELATION_TABLE . " as t2 USING(" . LessonModel::PRIMARY_KEY . ")\r\n WHERE t2." . TeacherModel::PRIMARY_KEY . " = '" . abs(intval($teacher_id)) . "' {$cond}\r\n GROUP BY t1.day_number,t1.lesson_number,t1.lesson_week\r\n ORDER BY t1.lesson_week,t1.day_number,t1.lesson_number ASC\r\n "); while ($data = $query->fetch(PDO::FETCH_ASSOC)) { $lessonModel = new LessonModel(); $lessonModel->unpack($data); //$lessonModel->teachers = TeacherModel::getAllByLessonId($lessonModel->lesson_id); //load rooms $lessonModel->rooms = RoomModel::getAllByLessonId($lessonModel->lesson_id); //load groups $q = $db->query("\r\n SELECT t1.* FROM " . GroupModel::TABLE . " as t1\r\n JOIN " . LessonModel::TABLE . " as t2 USING(" . GroupModel::PRIMARY_KEY . ")\r\n WHERE t2.day_number = '" . $lessonModel->day_number . "'\r\n AND t2.lesson_number = '" . $lessonModel->lesson_number . "'\r\n AND t2.teacher_name = " . $db->quote($lessonModel->teacher_name) . "\r\n AND t2.lesson_week = '" . $lessonModel->lesson_week . "'\r\n "); $groupsRes = array(); while ($groupsData = $q->fetch(PDO::FETCH_ASSOC)) { $group = new GroupModel(); $group->unpack($groupsData); $groupsRes[] = $group->toArray(); } $m = $lessonModel->toArray(); $m["groups"] = $groupsRes; $result[] = $m; } } else { throw new ApiException("Lessons not found"); } return $result; }