Tag Archives: yii2

Скорость исполнения скриптов(action) yii2

    public function afterAction($action, $result)
    {
        parent::afterAction($action, $result);

        $this->output[] = [
            $action->id,
            number_format(Yii::$app->log->logger->elapsedTime, 2)
        ];
    }

    public function __destruct()
    {
        if ($this->interactive && $this->output) {
            $msg = Table::widget([
                'headers' => ['Action', 'Time(sec.)'],
                'rows' => $this->output,
            ]);

            $this->stdout($msg, Console::FG_GREEN);
        }
    }

public function afterAction($action, $result)

{

parent::afterAction($action, $result);

$this->output[] = [

$action->id,

number_format(Yii::$app->log->logger->elapsedTime, 2)

];

}

public function __destruct()

{

if ($this->interactive && $this->output) {

$msg = Table::widget([

'headers' => ['Action', 'Time(sec.)'],

'rows' => $this->output,

]);

$this->stdout($msg, Console::FG_GREEN);

}

Yii2 execution time script console

Yii2 валидация для ЧПУ (slug)

['slug', 'match', 'pattern' => '/^[\w-]+$/',
 'message' => 'Поле может содержать только латинские буквы, цифры, и знаки "_", "-"'
],

['slug', 'match', 'pattern' => '/^[\w-]+$/',

'message' => 'Поле может содержать только латинские буквы, цифры, и знаки "_", "-"'

/**
 * {@inheritdoc}
 */
public function rules()
{
    return [
        [['image'], 'required'],
        [['active', 'sort'], 'integer'],
        [['date_start', 'date_end'], 'safe'],
        [['title', 'image'], 'string', 'max' => 64],
        [['slug', 'link'], 'string', 'max' => 255],
        [['slug'], 'unique'],
        [['title', 'link'], 'trim'],
        ['slug', 'match', 'pattern' => '/^[\w-]+$/',
         'message' => 'Поле может содержать только латинские буквы, цифры, и знаки "_", "-"'
        ],
    ];
}

/**

* {@inheritdoc}

public function rules()

{

return [

[['image'], 'required'],

[['active', 'sort'], 'integer'],

[['date_start', 'date_end'], 'safe'],

[['title', 'image'], 'string', 'max' => 64],

[['slug', 'link'], 'string', 'max' => 255],

[['slug'], 'unique'],

[['title', 'link'], 'trim'],

['slug', 'match', 'pattern' => '/^[\w-]+$/',

'message' => 'Поле может содержать только латинские буквы, цифры, и знаки "_", "-"'

];

}

yii2 slug

LeftJOIN Получить категории

return ShopProduct::find()
    ->select(
        ShopProduct::tableName() . '.name pn, 
        ' . ShopProduct::tableName() . '.path pp, 
        lvl1.name l1n, lvl1.path l1p,
        lvl2.name l2n, lvl2.path l2p, 
        lvl3.name l3n, lvl3.path l3p'
    )
    ->leftJoin(ShopCategory::tableName() . ' lvl1',  ShopProduct::tableName() . '.cat_id = lvl1.id')
    ->leftJoin(ShopCategory::tableName() . ' lvl2', 'lvl1.parent_id = lvl2.id')
    ->leftJoin(ShopCategory::tableName() . ' lvl3', 'lvl2.parent_id = lvl3.id')
    ->where([ShopProduct::tableName() . ".id" => $id])
    ->asArray()
    ->one();

return ShopProduct::find()

->select(

ShopProduct::tableName() . '.name pn,

' . ShopProduct::tableName() . '.path pp,

lvl1.name l1n, lvl1.path l1p,

lvl2.name l2n, lvl2.path l2p,

lvl3.name l3n, lvl3.path l3p'

)

->leftJoin(ShopCategory::tableName() . ' lvl1', ShopProduct::tableName() . '.cat_id = lvl1.id')

->leftJoin(ShopCategory::tableName() . ' lvl2', 'lvl1.parent_id = lvl2.id')

->leftJoin(ShopCategory::tableName() . ' lvl3', 'lvl2.parent_id = lvl3.id')

->where([ShopProduct::tableName() . ".id" => $id])

->asArray()

->one();