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’