Category Archives: FrameWork

yii2 field is null

нужно

and ('field' = 'value' or 'field' is null)

1	and ('field' = 'value' or 'field' is null)

Реализация

->andWhere(['or', ['field' => $value], ['is', 'field', new Expression('null')]])
->andWhere(['or', ['field' => $value], ['is', 'field', null]]);
->andWhere(['or', ['field' => $value], ['field' => null]]);

->andWhere(['or', ['field' => $value], ['is', 'field', new Expression('null')]])

->andWhere(['or', ['field' => $value], ['is', 'field', null]]);

->andWhere(['or', ['field' => $value], ['field' => null]]);

Docker example for yii2

# https://phptoday.ru/post/gotovim-lokalnuyu-sredu-docker-dlya-razrabotki-na-php
# Версия docker-compose
version: '2'
# Список наших сервисов (контейнеров)
services:
    nginx:
        container_name: nginx
        # используем последний стабильный образ nginx
        image: nginx:latest
        networks:
            application_nerwork:
                ipv4_address: 172.18.18.2
        # маршрутизируем порты
        ports:
            - "80:80"
            - "443:443"
        # монтируем директории, слева директории на основной машине, справа - куда они монтируются в контейнере
        volumes:
            - ./hosts:/etc/nginx/conf.d
            - ./www:/var/www
            - ./logs:/var/log/nginx
        # nginx должен общаться с php контейнером
        links:
            - php
    php:
        container_name: php
        # у нас свой образ для PHP, указываем путь к нему и говорим что его надо собрать
        build: ./images/php
        networks:
            application_nerwork:
                ipv4_address: 172.18.18.3
        # этот образ будет общаться с mysql
        links:
            - mariadb
        depends_on:
            - mariadb
        # монтируем директорию с проектами
        volumes:
            - ./www:/var/www
    mariadb:
        container_name: mariadb
        image: mariadb:10.3
        expose:
            - 3312
        networks:
            application_nerwork:
                ipv4_address: 172.18.18.4
        ports:
          - 3312:3306
        volumes:
          - ./mariadb:/var/lib/mysql
        environment:
            MYSQL_ROOT_PASSWORD: root_password_security
    phpmyadmin:
        container_name: phpmyadmin
        image: phpmyadmin/phpmyadmin
        networks:
            application_nerwork:
                ipv4_address: 172.18.18.5
        ports:
          - 8765:80
        environment:
            MYSQL_ROOT_PASSWORD: root_password_security
        links:
          - mariadb:db
        depends_on:
          - mariadb

networks:
    application_nerwork:
        driver: bridge
        driver_opts:
          com.docker.network.enable_ipv6: "false"
        ipam:
          driver: default
          config:
          - subnet: 172.18.18.0/24
            gateway: 172.18.18.1

# https://phptoday.ru/post/gotovim-lokalnuyu-sredu-docker-dlya-razrabotki-na-php

# Версия docker-compose

version: '2'

# Список наших сервисов (контейнеров)

services:

nginx:

container_name: nginx

# используем последний стабильный образ nginx

image: nginx:latest

networks:

application_nerwork:

ipv4_address: 172.18.18.2

# маршрутизируем порты

ports:

- "80:80"

- "443:443"

# монтируем директории, слева директории на основной машине, справа - куда они монтируются в контейнере

volumes:

- ./hosts:/etc/nginx/conf.d

- ./www:/var/www

- ./logs:/var/log/nginx

# nginx должен общаться с php контейнером

links:

- php

php:

container_name: php

# у нас свой образ для PHP, указываем путь к нему и говорим что его надо собрать

build: ./images/php

networks:

application_nerwork:

ipv4_address: 172.18.18.3

# этот образ будет общаться с mysql

links:

- mariadb

depends_on:

- mariadb

# монтируем директорию с проектами

volumes:

- ./www:/var/www

mariadb:

container_name: mariadb

image: mariadb:10.3

expose:

- 3312

networks:

application_nerwork:

ipv4_address: 172.18.18.4

ports:

- 3312:3306

volumes:

- ./mariadb:/var/lib/mysql

environment:

MYSQL_ROOT_PASSWORD: root_password_security

phpmyadmin:

container_name: phpmyadmin

image: phpmyadmin/phpmyadmin

networks:

application_nerwork:

ipv4_address: 172.18.18.5

ports:

- 8765:80

environment:

MYSQL_ROOT_PASSWORD: root_password_security

links:

- mariadb:db

depends_on:

- mariadb

networks:

application_nerwork:

driver: bridge

driver_opts:

com.docker.network.enable_ipv6: "false"

ipam:

driver: default

config:

- subnet: 172.18.18.0/24

gateway: 172.18.18.1

server {
    server_name yii2docker.dev;

    error_log  /var/log/nginx/error.log;
    access_log /var/log/nginx/access.log;

    root /var/www/yii2docker.dev/web;
    index index.php;

    location ~ \.php$ {
        try_files $uri =404;
        fastcgi_split_path_info ^(.+\.php)(/.+)$;
        fastcgi_pass php:9000;
        fastcgi_index index.php;
        include fastcgi_params;
        fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
        fastcgi_param PATH_INFO $fastcgi_path_info;
    }

    location / {
        # Перенаправляем все запросы к несуществующим директориям и файлам на index.php
        try_files $uri $uri/ /index.php?$args;
    }

    location ~ /\.(ht|svn|git) {
        deny all;
    }
}

server {

server_name yii2docker.dev;

error_log /var/log/nginx/error.log;

access_log /var/log/nginx/access.log;

root /var/www/yii2docker.dev/web;

index index.php;

location ~ \.php$ {

try_files $uri =404;

fastcgi_split_path_info ^(.+\.php)(/.+)$;

fastcgi_pass php:9000;

fastcgi_index index.php;

include fastcgi_params;

fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;

fastcgi_param PATH_INFO $fastcgi_path_info;

}

location / {

# Перенаправляем все запросы к несуществующим директориям и файлам на index.php

try_files $uri $uri/ /index.php?$args;

}

location ~ /\.(ht|svn|git) {

deny all;

}

FROM php:7.1-fpm-alpine

# intl, zip, soap
RUN apk add --update --no-cache libintl icu icu-dev libxml2-dev \
    && docker-php-ext-install intl zip soap

# mysqli, pdo, pdo_mysql
RUN docker-php-ext-install mysqli pdo pdo_mysql

# mcrypt, gd, iconv
RUN apk add --update --no-cache freetype-dev libjpeg-turbo-dev libmcrypt-dev libpng-dev \
    && docker-php-ext-install iconv mcrypt \
    && docker-php-ext-configure gd --with-freetype-dir=/usr/include/ --with-jpeg-dir=/usr/include/ \
    && docker-php-ext-install gd

# gmp, bcmath
RUN apk add --update --no-cache gmp gmp-dev \
    && docker-php-ext-install gmp bcmath

# redis, apcu
RUN docker-php-source extract \
    && apk add --no-cache --virtual .phpize-deps-configure $PHPIZE_DEPS \
    && pecl install redis \
    && pecl install apcu \
    && docker-php-ext-enable redis apcu \
    && apk del .phpize-deps-configure \
    && docker-php-source delete

# imagick
RUN apk add --update --no-cache autoconf g++ imagemagick-dev libtool make pcre-dev \
    && pecl install imagick \
    && docker-php-ext-enable imagick \
    && apk del autoconf g++ libtool make pcre-dev

# git client, mysql-client
RUN apk add --update --no-cache git mysql-client

# pcntl
RUN docker-php-ext-install pcntl

RUN sed -i -e 's/listen.*/listen = 0.0.0.0:9000/' /usr/local/etc/php-fpm.conf

RUN echo "expose_php=0" > /usr/local/etc/php/php.ini

WORKDIR /var/www

CMD ["php-fpm"]

FROM php:7.1-fpm-alpine

# intl, zip, soap

RUN apk add --update --no-cache libintl icu icu-dev libxml2-dev \

&& docker-php-ext-install intl zip soap

# mysqli, pdo, pdo_mysql

RUN docker-php-ext-install mysqli pdo pdo_mysql

# mcrypt, gd, iconv

RUN apk add --update --no-cache freetype-dev libjpeg-turbo-dev libmcrypt-dev libpng-dev \

&& docker-php-ext-install iconv mcrypt \

&& docker-php-ext-configure gd --with-freetype-dir=/usr/include/ --with-jpeg-dir=/usr/include/ \

&& docker-php-ext-install gd

# gmp, bcmath

RUN apk add --update --no-cache gmp gmp-dev \

&& docker-php-ext-install gmp bcmath

# redis, apcu

RUN docker-php-source extract \

&& apk add --no-cache --virtual .phpize-deps-configure $PHPIZE_DEPS \

&& pecl install redis \

&& pecl install apcu \

&& docker-php-ext-enable redis apcu \

&& apk del .phpize-deps-configure \

&& docker-php-source delete

# imagick

RUN apk add --update --no-cache autoconf g++ imagemagick-dev libtool make pcre-dev \

&& pecl install imagick \

&& docker-php-ext-enable imagick \

&& apk del autoconf g++ libtool make pcre-dev

# git client, mysql-client

RUN apk add --update --no-cache git mysql-client

# pcntl

RUN docker-php-ext-install pcntl

RUN sed -i -e 's/listen.*/listen = 0.0.0.0:9000/' /usr/local/etc/php-fpm.conf

RUN echo "expose_php=0" > /usr/local/etc/php/php.ini

WORKDIR /var/www

CMD ["php-fpm"]

в config/db host прописываем IP mariadb или название контейнера в данном случае mariadb

pjax reload containter

$.pjax.reload({container: '#pjax-shops-list', timeout: 5000, data: {city:id}, replace:false});

1	$.pjax.reload({container: '#pjax-shops-list', timeout: 5000, data: {city:id}, replace:false});

yii2 scroll pagination

'pager'        => [
    'class'             => ScrollPager::class,
    'enabledExtensions' => [
        ScrollPager::EXTENSION_SPINNER,
        ScrollPager::EXTENSION_PAGING,
    ],
    'eventOnReady' => "function(){ itemsInCategory(); }",
    'eventOnRendered' => "function(){ itemsInCategory(); }",
    'negativeMargin'    => -1000,
]

'pager' => [

'class' => ScrollPager::class,

'enabledExtensions' => [

ScrollPager::EXTENSION_SPINNER,

ScrollPager::EXTENSION_PAGING,

'eventOnReady' => "function(){ itemsInCategory(); }",

'eventOnRendered' => "function(){ itemsInCategory(); }",

'negativeMargin' => -1000,

]

Yii2 kartik select2 в админке(GridView) и в форме(ActiveForm)

Для Админки в GridView используем

[
    'attribute'     => 'prop_id',
    'enableSorting' => true,
    'filter'        => Select2::widget([
        'name'       => Html::getInputName($searchModel, 'prop_id'),
        'value'      => $searchModel->prop_id,
        'theme'      => Select2::THEME_DEFAULT,
        'data'       => $dataFilter['properties'],
    ]),
   'value'         => function (ShopFilter $model) {
       return $model->propertyName;
   },
    'headerOptions' => [
        'width' => 300,
    ],
],

[

'attribute' => 'prop_id',

'enableSorting' => true,

'filter' => Select2::widget([

'name' => Html::getInputName($searchModel, 'prop_id'),

'value' => $searchModel->prop_id,

'theme' => Select2::THEME_DEFAULT,

'data' => $dataFilter['properties'],

]),

'value' => function (ShopFilter $model) {

return $model->propertyName;

'headerOptions' => [

'width' => 300,

Для Формы (ActiveForm)

<?php
    echo $form->field($model,'type', ['options' => ['class' => 'col-md-2']])->widget(Select2::class, [
        'theme' => Select2::THEME_DEFAULT,
        'value'      => $model->type,
        'hideSearch' => true,
        'data' => [
            'news_company' => 'Компания',
            'news_assortment' => 'Ассортимент'
        ]
    ]);
?>

<?php

echo $form->field($model,'type', ['options' => ['class' => 'col-md-2']])->widget(Select2::class, [

'theme' => Select2::THEME_DEFAULT,

'value' => $model->type,

'hideSearch' => true,

'data' => [

'news_company' => 'Компания',

'news_assortment' => 'Ассортимент'

]

]);

Скорость исполнения скриптов(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 прелоудер/preloader для формы

$('#auth-form').on('ajaxBeforeSend', function (event, jqXHR, settings) {
    $('section.authForm .loader').show();
}).on('ajaxComplete', function (event, jqXHR, textStatus) {
    $('section.authForm .loader').hide();
});

$('#auth-form').on('ajaxBeforeSend', function (event, jqXHR, settings) {

$('section.authForm .loader').show();

}).on('ajaxComplete', function (event, jqXHR, textStatus) {

$('section.authForm .loader').hide();

});

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

Yii2 получить класс/имя модели

Способ 1

$model = new Test();
$modelName = \yii\helpers\StringHelper::basename(get_class($model));

var_dump($modelName); // Test

$model = new Test();

$modelName = \yii\helpers\StringHelper::basename(get_class($model));

var_dump($modelName); // Test

Способ 2

$model = new Test;
$modelName = (new \ReflectionClass($model))->getShortName();

var_dump($modelName); // Test

$model = new Test;

$modelName = (new \ReflectionClass($model))->getShortName();

var_dump($modelName); // Test

Для форм можно получить таким образом

Html::getInputName($searchModel, 'popular'); // ShopBrand[popular]
Html::getInputId($searchModel, 'popular');   // shopbrand-popular

1 2	Html::getInputName($searchModel, 'popular'); // ShopBrand[popular] Html::getInputId($searchModel, 'popular'); // shopbrand-popular

Yii2 GridView адаптив

Для адаптивных колонок в yii2 GridView нужно добавить следующий код в виджет

'tableOptions' => [
    'class' => 'table table-striped',
],
'options' => [
    'class' => 'table-responsive',
],

'tableOptions' => [

'class' => 'table table-striped',

'options' => [

'class' => 'table-responsive',

Полный пример

GridView::widget([
    'dataProvider' => $dataProvider,
    'filterModel'  => $searchModel,
    'tableOptions' => [
        'class' => 'table table-striped',
    ],
    'options' => [
        'class' => 'table-responsive',
    ],
    'columns'      => [
        ['class' => 'yii\grid\SerialColumn'],

        'id',
        'name',
        'path',
        [
            'attribute'     => 'popular',
            'filter'        => Select2::widget([
                'name'       => 'ShopBrandSearch[popular]',
                'value'      => $searchModel->popular,
                'hideSearch' => true,
                'theme'      => Select2::THEME_DEFAULT,
                'data'       => [
                    null => 'Все',
                    '1'  => 'Да',
                    '0'  => 'Нет',
                ],
            ]),
            'value'         => function ($model) {
                return $model->popular == true ? 'Да' : 'Нет';
            },
            'headerOptions' => [
                'width' => 130,
            ],
        ],

        [
            'class' => 'yii\grid\ActionColumn',
            'template' => '{view} {update}'
        ],
    ],
]);

GridView::widget([

'dataProvider' => $dataProvider,

'filterModel' => $searchModel,

'tableOptions' => [

'class' => 'table table-striped',

'options' => [

'class' => 'table-responsive',

'columns' => [

['class' => 'yii\grid\SerialColumn'],

'id',

'name',

'path',

[

'attribute' => 'popular',

'filter' => Select2::widget([

'name' => 'ShopBrandSearch[popular]',

'value' => $searchModel->popular,

'hideSearch' => true,

'theme' => Select2::THEME_DEFAULT,

'data' => [

null => 'Все',

'1' => 'Да',

'0' => 'Нет',

]),

'value' => function ($model) {

return $model->popular == true ? 'Да' : 'Нет';

'headerOptions' => [

'width' => 130,

[

'class' => 'yii\grid\ActionColumn',

'template' => '{view} {update}'

]);