/**
* Получение списка материалов заданного этапа
* @param int $stageId
* @return arrays
*/
static function getList($stageId = NULL)
{
$result = parent::getList("SELECT * FROM `" . self::TABLE . "` WHERE `stage_id`=" . intval($stageId));
$l10nList = MaterialL10n::getListByIds(array_keys($result));
foreach (array_keys($result) as $materialId) {
$result[$materialId]->l10n = $l10nList[$materialId];
}
return $result;
}
/**
* Получение списка этапов заданного урока
* @param unknown $lessonId
* @return array
*/
static function getList($lessonId = NULL)
{
$result = parent::getList("SELECT * FROM `" . self::TABLE . "` WHERE `lesson_id`=" . intval($lessonId) . " ORDER BY `" . self::ORDER_FIELD_NAME . "`");
$l10nList = StageL10n::getListByIds(array_keys($result));
foreach ($result as $stageId => $stage) {
$result[$stageId]->l10n = $l10nList[$stageId];
}
return $result;
}
static function getList($mode = self::VISIBLE)
{
$db = Registry::getInstance()->get(self::DB);
if ($mode == self::VISIBLE) {
$sql = "SELECT * FROM `" . self::TABLE . "` WHERE `state`=" . self::VISIBLE . " ORDER BY `" . self::ORDER_FIELD_NAME . "`";
} else {
$sql = "SELECT * FROM `" . self::TABLE . "` ORDER BY `" . self::ORDER_FIELD_NAME . "`";
}
$result = parent::getList($sql);
$l10nList = CourseL10n::getListByIds(array_keys($result));
foreach ($result as $courseId => $course) {
if (isset($l10nList[$courseId])) {
$l10n = $l10nList[$courseId];
} else {
$l10n = new CourseL10n($l10nList[$courseId]->id);
}
$result[$courseId]->l10n = $l10n;
}
return $result;
}
static function getList($fake = NULL)
{
return parent::getList("SELECT * FROM `" . self::TABLE . "` ORDER BY `" . self::ORDER_FIELD_NAME . "`");
}
/**
* Получение списка редиректов в виде массива объектов
* @return multitype:\common\Redirect[]
*/
static function getList($mode = NULL)
{
return parent::getList("SELECT * FROM `" . self::TABLE . "`" . ($mode == self::ACTIVE ? ' WHERE `active`=' . self::ACTIVE : '') . " ORDER BY `" . self::ORDER_FIELD_NAME . "`");
}
