mysql - Yii 按关系条件过滤模型的范围

Question

我有一个与 ScheduleElement 具有 HAS_MANY 关系的模型组。需要创建过滤组的范围:对于 ScheduleElement 的所有字段组合，组必须至少有一个 ScheduleElement:week_number (1-2)、week_day (1-7)、semester_id = 1

Answer 1

我自己找到了解决方案，源代码:https://github.com/sc0rp1d/schedule/blob/e510ad72b95e9491af9ff2f5692d9b0e469140f7/models/Group.php#L95

public function filled($bool = true)
    {
    $schedule_table = ScheduleElement::model()->tableName();
    $semester = Semesters::model()->actual();
    $criteria = $this->getDbCriteria();
    $criteria->params[':semester_id'] = $semester->id;
    for ($i = 1; $i <= 2; $i++) {
        for ($j = 1; $j <= 6; $j++) {
            $sql = "(SELECT COUNT(*) FROM `$schedule_table` 
                WHERE `$schedule_table`.`week_number` = $i 
                AND `$schedule_table`.`week_day` = $j 
                AND `$schedule_table`.`group_id` = `t`.`id` 
                AND `$schedule_table`.`semester_id` = :semester_id) " 
                . ($bool ? ">" : "=") . " 0";
            $criteria->addCondition($sql, $bool ? 'AND' : 'OR');
        }
    }
    return $this;
}