Schedule::find()->joinWith([‘frequency’=>function($query){ $query->where(‘frequency.cycle=0’);}])->where(‘schedulingDate=:schedulingDate’,array(‘schedulingDate’=>date(‘Y-m-d’,time())))->all();
这样执行后 frequency.cycle=0 没有添加在查询语句,怎样让它生效?
以下是执行效果:
SELECT _record_schedule.* FROM _record_schedule LEFT JOIN _record_frequency ON _record_schedule.frequencyId = _record_frequency.id WHERE ‘2014-03-01’=:‘2014-03-01’