[FIXED] Yii 2 can rewrite WHERE condition from model?

Issue

I have some where condition in my model . Its check is field active or no.

Now I need to write a join relation. But I need to remove where condition. Is it possible?

My model.

  ...
  public static function find() {
     return (new AssetgroupsQuery(get_called_class()))->active();
  }

My relation

public function getAssetgroup(): \app\models\AssetgroupsQuery {
    return $this->hasOne(Assetgroups::class, ['asg_id' => 'ass_group'])->andOnCondition(['asg_active' => '1'])
        ->viaTable('assets', ['ass_id' => 'log_ass_id',]);
}

I need to got all active assets and join, if asset is empty I need to got null fields, but model where condition added to my current sql query and remove all fields which assets are null. I try to add some where Condition to remove old where, but it don't work.

Can you help me?

Solution

You can reset existing conditions by using where(null).

On relation level:

public function getAssetgroup(): \app\models\AssetgroupsQuery {
    return $this->hasOne(Assetgroups::class, ['asg_id' => 'ass_group'])
        ->andOnCondition(['asg_active' => '1'])
        ->where(null)
        ->viaTable('assets', ['ass_id' => 'log_ass_id',]);
}

Or directly on join:

$query = MyModel::find()
    ->joinWith([
        'assetgroup' => function (ActiveQuery $query) {
            $query->where(null);
        },
    ])

Answered By - rob006