public static function findAllOrdered() { $sql = "SELECT cm.*, cc.name__pl as category_name FROM core_module cm\n\t\t\tJOIN core_category cc ON cc.id = cm.category_id\n\t\t\tORDER BY cc.`ordering`, cm.ordering"; return Module::findBySql($sql)->all(); }
public function beforeValidate() { $sql = "SELECT * FROM core_module WHERE category_id = :categoryId ORDER BY ordering DESC"; /** @var Module $module */ $module = Module::findBySql($sql, [':categoryId' => $this->category_id])->one(); $maxOrdering = is_null($module) ? 1 : $module->ordering + 1; $this->ordering = $maxOrdering + 1; return parent::beforeValidate(); // TODO: Change the autogenerated stub }