betadog\yii1\OrderingValueBehavior

Complexity

Total Complexity

6

Size/Duplication

Total Lines	54
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	afterSave()	0	16	3
A	attach()	0	9	1
A	beforeValidate()	0	13	2

<?php

namespace betadog\yii1;

/**
 * Класс для автоматического отслеживания и порядка сортировки элементов
 *
 * TIP: отслежтваемую колонку не надо добавлять в rules()
 *
 * Usage:
 *
<pre>
public function behaviors()
{
    return [
        'orderingAttribute' => [
            'class'      => 'betadog\\yii1\\OrderingValueBehavior',
            // колонка по которой осуществляется сортировка
            'columnName' => 'ordering',
            // на какое место ставится новый элемент
            'position'   => \betadog\yii1\OrderingValueBehavior::POSITION_END
        ],
    ];
}
</pre>
 */
class OrderingValueBehavior extends \CActiveRecordBehavior
{
    const POSITION_START = 0;
    const POSITION_END   = 1;

    /** @var string */
    public $columnName;

    /** @var int */
    public $position = self::POSITION_START;

    public function attach($owner)
    {
        $validator = \CValidator::createValidator('numerical', $owner, $this->columnName, [
            'integerOnly' => true,
            'allowEmpty'  => false,
        ]);
        $owner->validatorList->add($validator);

        parent::attach($owner);
    }

    public function beforeValidate($event)
    {
        /** @var \CActiveRecord $owner */
        $owner = $this->getOwner();

        if ($owner->getIsNewRecord()) {
            $fieldName = \Yii::app()->db->quoteColumnName($this->columnName);
            $position  = \Yii::app()->db->createCommand()
                ->select("MAX($fieldName)")
                ->from($owner->tableName())
                ->queryScalar();

            $owner->{$this->columnName} = $position + 1;
        }
    }

    public function afterSave($event)
    {
        /** @var \CActiveRecord $owner */
        $owner = $this->getOwner();

        /**
         * self::POSITION_END set in validator
         */
        if ($owner->getIsNewRecord() && self::POSITION_START == $this->position) {
            $fieldName   = \Yii::app()->db->quoteColumnName($this->columnName);
            $minPosition = \Yii::app()->db->createCommand()
                ->select("MIN($fieldName)")
                ->from($owner->tableName())
                ->queryScalar();
            \Yii::app()->db->createCommand()->update($owner->tableName(), [$this->columnName => new \CDbExpression("{$fieldName} + 1")]);
            \Yii::app()->db->createCommand()->update($owner->tableName(), [$this->columnName => $minPosition], 'id = :id', [':id' => $owner->id]);
        }
    }
}