mootensai/yii2-before-query

Add before query or before find event on Yii 2 models

yii2-before-query

Add before query event on Yii 2 models, _(*1)

Installation

The preferred way to install this extension is through composer., _(*2)

Either run, _(*3)

$ composer require mootensai/yii2-before-query "dev-master"

or add, _(*4)

"mootensai/yii2-before-query": "dev-master"

to the require section of your composer.json file., _(*5)

1. Base Trait Before Query

namespace common\traits\base;
trait BeforeQueryTrait{

    public static function find() {
        $obj = new static;
        $class = new \ReflectionClass($obj);
        $condition = [];
        foreach ($class->getProperties(\ReflectionProperty::IS_STATIC) as $property) {
            if(strpos($property->getName(),'BEFORE_QUERY') !== false && is_array($property->getValue($obj))){
                $condition = array_merge($condition, $property->getValue($obj));
            }
        }
        return parent::find()->andFilterWhere($condition);
    }
}

2. Add new property on model

Next, you can add new property on your model like this :, _(*6)

class MyClass extends \yii\db\ActiveRecord{
    use \common\traits\base\BeforeQueryTrait;
    public static $BEFORE_QUERY = ['myColumn' => 'myValue'];
}

NB : the content of your public static $BEFORE_QUERY can be learn here, _(*7)

http://www.yiiframework.com/doc-2.0/yii-db-queryinterface.html#where%28%29-detail, _(*8)

3. You can create a new trait.

For example, i've created Soft Delete Boolean Trait :, _(*9)

trait SoftDeleteBoolTrait{
    public static $BEFORE_QUERY_SOFT_DELETE = ['isdeleted' => 0];

    public function deleteSoft() {
        $col = key(static::$BEFORE_QUERY_SOFT_DELETE);
        $this->{$col} = 1;
        return $this->save(false,[$col]);
    }

    public static function restore($id) {
        $col = key(static::$BEFORE_QUERY_SOFT_DELETE);
        $model = parent::findOne($id, 1);
        $model->{$col} = 0;
        $model->save(false,[$col]);
    }
}

Use it on model :, _(*10)

class MyClass extends \yii\db\ActiveRecord{
    use \mootensai\beforequery\base\BeforeQueryTrait;
    use \mootensai\beforequery\traits\SoftDeleteBoolTrait;
}