The custom ActiveRecord class not working when i call the find() method from view?

Question

I am overriding the find method and add the where condition globally thats working fine here is my code

class Order extends \common\components\ActiveRecord

\common\components\ActiveRecord

namespace common\components;
use Yii;

use yii\db\ActiveRecord as BaseActiveRecord;

class ActiveRecord extends BaseActiveRecord{
    public static function find() {
        return parent::find()
           ->where(['=',static::tableName().'.company_id',Yii::$app->user->identity->company_id])
           ->andWhere(['=',static::tableName().'.branch_id',Yii::$app->user->identity->branch_id]);
    }
}

The find is not working when i call the model from view like this

 echo  \common\models\Order::find()->where(['status'=>'0'])->count();

Because you're overriting `where()` conditions, in your query change `where(['status' => '0'])` to `->andWhere(['status' => 0])` — Yupik, Mar 20 '18 at 06:43
@Yupik oo yes so its mean i need to replace the where from all the application — rajwa766, Mar 20 '18 at 06:48

score 2 · Accepted Answer · answered Mar 20 '18 at 10:09

Since you're using where() inside the find function that you're using in ActiveRecord and then where() in this statement

echo  \common\models\Order::find()->where(['status'=>'0'])->count();

the second ends up overriding the first

What you need to do is to use andWhere() in all the cases where you need the original conditions that you put in ActiveRecord to work. Try thus:

echo  \common\models\Order::find()->andWhere(['status'=>'0'])->count();

This should work.

And again remember, use andWhere() in all places where the original condition needs to be applied

Insane Skull · Answer 2 · 2018-03-20T06:50:50.527

1

Use andWhere() so your default condition not get overridden :

class ActiveRecord extends BaseActiveRecord {
    public static function find() {
        return parent::find()
            ->andWhere(['=',static::tableName().'.company_id',Yii::$app->user->identity->company_id])
            ->andWhere(['=',static::tableName().'.branch_id',Yii::$app->user->identity->branch_id]);
    }
}

edited Mar 20 '18 at 06:50

answered Mar 20 '18 at 06:49

Insane Skull

9,220
9
44
63

If there is no where conditon what happen with the query..? – rajwa766 Mar 20 '18 at 06:50
Nothing. Still these condition get applied. – Insane Skull Mar 20 '18 at 06:51
@Insame Skull ! – rajwa766 Mar 20 '18 at 06:51
@Sajid https://github.com/yiisoft/yii2/blob/master/framework/db/QueryTrait.php#L101 – Insane Skull Mar 20 '18 at 06:53
if where is false in any query then ..? – rajwa766 Mar 20 '18 at 06:53
@Insame Skull not working i need to replace the where to and where in find()->andWhere – rajwa766 Mar 20 '18 at 07:01
@Sajid `andWhere()` automatically converted to where, if there is no where condition. – Insane Skull Mar 20 '18 at 10:00
Hello the where condition in my local condition overide this globla condition when i use the find()->where(['id'=>87]) in local mode the above condition ger ignored – rajwa766 Mar 22 '18 at 07:53
@Sajid https://github.com/yiisoft/yii2/blob/master/framework/db/QueryTrait.php#L101 according to this it's not possible it will not override where. – Insane Skull Mar 22 '18 at 08:53

score 1 · Answer 3 · answered Mar 20 '18 at 09:57

Try to change with onCondition()

class ActiveRecord extends BaseActiveRecord {
   public static function find() {
     return parent::find()
        ->onCondition([
        ['=',static::tableName().'.company_id',Yii::$app->user->identity->company_id],
        ['=',static::tableName().'.branch_id',Yii::$app->user->identity->branch_id]
     ]);
   }
}

The custom ActiveRecord class not working when i call the find() method from view?

3 Answers3