// common/components/grid/CombinedDataColumn.php

namespace common\components\grid;

use yii\grid\DataColumn;

/**
 * Renders several attributes in one grid column
 */
class CombinedDataColumn extends DataColumn
{
    /* @var $labelTemplate string */
    public $labelTemplate = null;

    /* @var $valueTemplate string */
    public $valueTemplate = null;

    /* @var $attributes string[] | null */
    public $attributes = null;

    /* @var $formats string[] | null */
    public $formats = null;

    /* @var $values string[] | null */
    public $values = null;

    /* @var $labels string[] | null */
    public $labels = null;

    /* @var $sortLinksOptions string[] | null */
    public $sortLinksOptions = null;


    /**
     * Sets parent object parameters for current attribute
     * @param $key string Key of current attribute
     * @param $attribute string Current attribute
     */
    protected function setParameters($key, $attribute)
    {
        list($attribute, $format) = array_pad(explode(':', $attribute), 2, null);

        $this->attribute = $attribute;

        if (isset($format)) {
            $this->format = $format;
        } else if (isset($this->formats[$key])) {
            $this->format = $this->formats[$key];
        } else {
            $this->format = null;
        }

        if (isset($this->labels[$key])) {
            $this->label = $this->labels[$key];
        } else {
            $this->label = null;
        }

        if (isset($this->sortLinksOptions[$key])) {
            $this->sortLinkOptions = $this->sortLinksOptions[$key];
        } else {
            $this->sortLinkOptions = [];
        }

        if (isset($this->values[$key])) {
            $this->value = $this->values[$key];
        } else {
            $this->value = null;
        }
    }

    /**
     * Sets parent object parameters and calls parent method for each attribute, then renders combined cell content
     * @inheritdoc
     */
    protected function renderHeaderCellContent()
    {
        if (!is_array($this->attributes)) {
            return parent::renderHeaderCellContent();
        }

        $labels = [];
        foreach ($this->attributes as $i => $attribute) {
            $this->setParameters($i, $attribute);
            $labels['{'.$i.'}'] = parent::renderHeaderCellContent();
        }

        if ($this->labelTemplate === null) {
            return implode('<br>', $labels);
        } else {
            return strtr($this->labelTemplate, $labels);
        }
    }

    /**
     * Sets parent object parameters and calls parent method for each attribute, then renders combined cell content
     * @inheritdoc
     */
    protected function renderDataCellContent($model, $key, $index)
    {
        if (!is_array($this->attributes)) {
            return parent::renderDataCellContent($model, $key, $index);
        }

        $values = [];
        foreach ($this->attributes as $i => $attribute) {
            $this->setParameters($i, $attribute);
            $values['{'.$i.'}'] = parent::renderDataCellContent($model, $key, $index);
        }

        if ($this->valueTemplate === null) {
            return implode('<br>', $values);
        } else {
            return strtr($this->valueTemplate, $values);
        }
    }
}

// common/components/bootstrap/Nav.php

namespace common\components\bootstrap;

use Yii;
use yii\bootstrap\Nav as YiiBootstrapNav;

/**
 * @inheritdoc
 */
class Nav extends YiiBootstrapNav
{
    /**
     * Adds additional check - directly compare item URL and request URL.
     * Used to make an item active when item URL is handled by module routing
     *
     * @inheritdoc
     */
    protected function isItemActive($item)
    {
        if (parent::isItemActive($item)) {
            return true;
        }

        if (!isset($item['url'])) {
            return false;
        }

        $route = null;
        $itemUrl = $item['url'];

        if (is_array($itemUrl) && isset($itemUrl[0])) {
            $route = $itemUrl[0];
            if ($route[0] !== '/' && Yii::$app->controller) {
                $route = Yii::$app->controller->module->getUniqueId() . '/' . $route;
            }
        } else {
            $route = $itemUrl;
        }

        $requestUrl = Yii::$app->request->getUrl();
        $isActive = ($route === $requestUrl || (Yii::$app->homeUrl . $route) === '/' . $requestUrl);

        return $isActive;
    }
}

php yii migrate --migrationPath=@vendor/yiisoft/yii2/web/migrations
php yii migrate --migrationPath=@yii/rbac/migrations
php yii migrate

// product_user
$this->addColumn('{{%product}}',
    'user_id', $this->integer()->after('id')
);
$this->addForeignKey('fk_product_user', '{{%product}}', 'user_id', '{{%user}}', 'id');


// product_category
$this->createTable('{{%category}}', [
    'id' => $this->primaryKey(),
    'name' => $this->string(100),
]);

$this->addColumn('{{%product}}',
    'category_id', $this->integer()->after('user_id')
);
$this->addForeignKey('fk_product_category', '{{%product}}', 'category_id', '{{%category}}', 'id');

// common/components/db/Connection.php

namespace common\components\db;

use Yii;
use yii\db\Connection as BaseConnection;

/**
 * Allows to add mapping between internal table name used in application and real table name
 * Can be used to set different prefixes for tables from different modules, just to group them in DB
 */
class Connection extends BaseConnection
{
    /**
     * @var array Mapping between internal table name used in application and real table name
     * Can be used to add different prefixes for tables from different modules
     * Example: 'tableMap' => ['%session' => '%__web__session']
     */
    public $tableMap = [];


    /**
     * @inheritdoc
     */
    public function quoteSql($sql)
    {
        return preg_replace_callback(
            '/(\\{\\{(%?[\w\-\. ]+%?)\\}\\}|\\[\\[([\w\-\. ]+)\\]\\])/',
            function ($matches) {
                if (isset($matches[3])) {
                    return $this->quoteColumnName($matches[3]);
                } else {
                    return $this->getRealTableName($matches[2]);
                }
            },
            $sql
        );
    }

    /**
     * Returns real table name which is used in database
     * @param $tableName string
     * @param $useMapping bool
     */
    public function getRealTableName($tableName, $useMapping = true)
    {
        $tableName = ($useMapping && isset($this->tableMap[$tableName]) ? $this->tableMap[$tableName] : $tableName);
        $tableName = str_replace('%', $this->tablePrefix, $this->quoteTableName($tableName));

        return $tableName;
    }
}

// common/components/db/mysql/Schema.php

namespace common\components\db\mysql;

use yii\db\mysql\Schema as BaseSchema;

/**
 * @inheritdoc
 */
class Schema extends BaseSchema
{
    /**
     * @inheritdoc
     * Also gets real table name from database connection object before replacing table prefix
     */
    public function getRawTableName($name)
    {
        if (strpos($name, '{{') !== false) {
            $name = preg_replace('/\\{\\{(.*?)\\}\\}/', '\1', $name);
            $name = $this->db->getRealTableName($name);

            return $name;
        } else {
            return $name;
        }
    }
}

// common/widgets/DatePicker.php

namespace common\widgets;

use Yii;
use yii\helpers\Html;
use yii\helpers\FormatConverter;
use yii\base\InvalidParamException;

/**
 * Extended DatePicker, allows to set different formats for sending and displaying value
 */
class DatePicker extends \kartik\date\DatePicker
{
    public $saveDateFormat = 'php:Y-m-d';

    private $savedValueInputID = '';
    private $attributeValue = null;


    public function __construct($config = [])
    {
        $defaultOptions = [
            'type' => static::TYPE_COMPONENT_APPEND,
            'convertFormat' => true,
            'pluginOptions' => [
                'autoclose' => true,
                'format' => Yii::$app->formatter->dateFormat,
            ],
        ];
        $config = array_replace_recursive($defaultOptions, $config);

        parent::__construct($config);
    }

    public function init()
    {
        if ($this->hasModel()) {
            $model = $this->model;
            $attribute = $this->attribute;
            $value = $model->$attribute;

            $this->model = null;
            $this->attribute = null;
            $this->name = Html::getInputName($model, $attribute);
            $this->attributeValue = $value;

            if ($value) {
                try {
                    $this->value = Yii::$app->formatter->asDateTime($value, $this->pluginOptions['format']);
                } catch (InvalidParamException $e) {
                    $this->value = null;
                }
            }
        }

        return parent::init();
    }

    protected function parseMarkup($input)
    {
        $res = parent::parseMarkup($input);

        $res .= $this->renderSavedValueInput();
        $this->registerScript();

        return $res;
    }

    protected function renderSavedValueInput()
    {
        $value = $this->attributeValue;

        if ($value !== null && $value !== '') {
            // format value according to saveDateFormat
            try {
                $value = Yii::$app->formatter->asDate($value, $this->saveDateFormat);
            } catch(InvalidParamException $e) {
                // ignore exception and keep original value if it is not a valid date
            }
        }

        $this->savedValueInputID = $this->options['id'].'-saved-value';

        $options = $this->options;
        $options['id'] = $this->savedValueInputID;
        $options['value'] = $value;

        // render hidden input
        if ($this->hasModel()) {
            $contents = Html::activeHiddenInput($this->model, $this->attribute, $options);
        } else {
            $contents = Html::hiddenInput($this->name, $value, $options);
        }

        return $contents;
    }

    protected function registerScript()
    {
        $language = $this->language ? $this->language : Yii::$app->language;

        $format = $this->saveDateFormat;
        $format = strncmp($format, 'php:', 4) === 0 ? substr($format, 4) :
            FormatConverter::convertDateIcuToPhp($format, $type);
        $saveDateFormatJs = static::convertDateFormat($format);


        $containerID = $this->options['data-datepicker-source'];
        $hiddenInputID = $this->savedValueInputID;
        $script = "
            $('#{$containerID}').on('changeDate', function(e) {
                var savedValue = e.format(0, '{$saveDateFormatJs}');
                $('#{$hiddenInputID}').val(savedValue).trigger('change');
            }).on('clearDate', function(e) {
                var savedValue = e.format(0, '{$saveDateFormatJs}');
                $('#{$hiddenInputID}').val(savedValue).trigger('change');
            });

            $('#{$containerID}').data('datepicker').update();
            $('#{$containerID}').data('datepicker')._trigger('changeDate');
        ";
        $view = $this->getView();
        $view->registerJs($script);
    }
}

// common/widgets/DateTimePicker.php

namespace common\widgets;

use Yii;
use yii\helpers\Html;
use yii\helpers\FormatConverter;
use yii\base\InvalidParamException;

/**
 * Extended DateTimePicker, allows to set different formats for sending and displaying value
 */
class DateTimePicker extends \kartik\datetime\DateTimePicker
{
    public $saveDateFormat = 'php:Y-m-d H:i';
    public $removeButtonSelector = '.kv-date-remove';

    private $savedValueInputID = '';
    private $attributeValue = null;


    public function __construct($config = [])
    {
        $defaultOptions = [
            'type' => static::TYPE_COMPONENT_APPEND,
            'convertFormat' => true,
            'pluginOptions' => [
                'autoclose' => true,
                'format' => Yii::$app->formatter->datetimeFormat,
                'pickerPosition' => 'top-left',
            ],
        ];
        $config = array_replace_recursive($defaultOptions, $config);

        parent::__construct($config);
    }

    public function init()
    {
        if ($this->hasModel()) {
            $model = $this->model;
            $attribute = $this->attribute;
            $value = $model->$attribute;

            $this->model = null;
            $this->attribute = null;
            $this->name = Html::getInputName($model, $attribute);
            $this->attributeValue = $value;

            if ($value) {
                try {
                    $this->value = Yii::$app->formatter->asDateTime($value, $this->pluginOptions['format']);
                } catch (InvalidParamException $e) {
                    $this->value = null;
                }
            }
        }

        return parent::init();
    }

    public function registerAssets()
    {
        $format = $this->saveDateFormat;
        $format = strncmp($format, 'php:', 4) === 0
            ? substr($format, 4)
            : FormatConverter::convertDateIcuToPhp($format, $type);
        $saveDateFormatJs = static::convertDateFormat($format);


        $this->savedValueInputID = $this->options['id'].'-saved-value';

        $this->pluginOptions['linkField'] = $this->savedValueInputID;
        $this->pluginOptions['linkFormat'] = $saveDateFormatJs;

        return parent::registerAssets();
    }

    protected function parseMarkup($input)
    {
        $res = parent::parseMarkup($input);

        $res .= $this->renderSavedValueInput();
        $this->registerScript();

        return $res;
    }

    protected function renderSavedValueInput()
    {
        $value = $this->attributeValue;

        if ($value !== null && $value !== '') {
            // format value according to saveDateFormat
            try {
                $value = Yii::$app->formatter->asDateTime($value, $this->saveDateFormat);
            } catch(InvalidParamException $e) {
                // ignore exception and keep original value if it is not a valid date
            }
        }

        $options = $this->options;
        $options['id'] = $this->savedValueInputID;
        $options['value'] = $value;

        // render hidden input
        if ($this->hasModel()) {
            $contents = Html::activeHiddenInput($this->model, $this->attribute, $options);
        } else {
            $contents = Html::hiddenInput($this->name, $value, $options);
        }

        return $contents;
    }

    protected function registerScript()
    {
        $containerID = $this->options['id'] . '-datetime';
        $hiddenInputID = $this->savedValueInputID;

        if ($this->removeButtonSelector) {
            $script = "
                $('#{$containerID}').find('{$this->removeButtonSelector}').on('click', function(e) {
                    $('#{$containerID}').find('input').val('').trigger('change');
                    $('#{$containerID}').data('datetimepicker').reset();

                    $('#{$containerID}').trigger('changeDate', {
                        type: 'changeDate',
                        date: null,
                    });
                });

                $('#{$containerID}').trigger('changeDate', {
                    type: 'changeDate',
                    date: null,
                });
            ";

            $view = $this->getView();
            $view->registerJs($script);
        }
    }
}

.input-group.date .kv-date-remove,
.input-group.date .kv-date-calendar {
    color: #626262;
}

.input-group.date .kv-date-remove-custom {
    position: absolute;
    z-index: 3;
    color: #000;
    opacity: 0.4;
    font-size: 16px;
    font-weight: 700;
    line-height: 0.6;
    right: 50px;
    top: 14px;
    cursor: pointer;
}

.input-group.date .kv-date-remove-custom:hover {
    opacity: 0.6;
}

.input-group.date input {
    padding-right: 30px;
}

.input-group.date .input-group-addon.kv-date-calendar + .kv-date-remove-custom {
    left: 50px;
    right: auto;
}

.input-group.date .input-group-addon.kv-date-calendar + .kv-date-remove-custom + input {
    padding-left: 32px;
}

<?php
// frontend/views/product/_search.php

$dateTimePickerOptions = [
    'removeButton' => '<span class="kv-date-remove kv-date-remove-custom">?</span>',
    'removeButtonSelector' => '.kv-date-remove-custom',
    'pluginEvents' => [
        'changeDate' => "function(e) {
            var isEmpty = ($(this).find('input').val() == '');
            $(this).find('.kv-date-remove-custom').toggle(!isEmpty);
        }",
    ],
];
?>
<?= $form->field($model, 'created_from')->widget(DateTimePicker::classname(), $dateTimePickerOptions) ?>

// common/components/InputTimezoneConverter.php

namespace common\components;

use Yii;
use yii\i18n\Formatter;

/**
 * Allows to convert time values in user timezone (usually from input fields)
 * into appplication timezone which is used in models
 * Conversion from application timezone into user timezone
 * is usulally done by Yii::$app->formatter->asDatetime()
 */
class InputTimezoneConverter
{
    /** @var Formatter */
    private $formatter = null;


    public function __construct($formatter = null)
    {
        if ($formatter === null) {
            // we change formatter configuration so we need to clone it
            $formatter = clone(Yii::$app->formatter);
        }
        $this->formatter = $formatter;
        $this->formatter->datetimeFormat = 'php:Y-m-d H:i:s';

        // swap timeZone and defaultTimeZone of default formatter configuration
        // to perform conversion back to default timezone

        $timeZone = $this->formatter->timeZone;
        $this->formatter->timeZone = $this->formatter->defaultTimeZone;
        $this->formatter->defaultTimeZone = $timeZone;
    }

    /**
     * @param $value string
     */
    public function convertValue($value)
    {
        if ($value === null || $value === '') {
            return $value;
        }

        return $this->formatter->asDatetime($value);
    }
}

// common/widgets/Script.php

namespace common\widgets;

use Yii;
use yii\web\View;

/**
 * Allows to write javascript in view inside '<script></script>' tags and render it at the end of body together with other scripts
 * '<script></script>' tags are removed from result output
 */
class Script extends \yii\base\Widget
{
    /** @var string Script position, used in registerJs() function */
    public $position = View::POS_READY;


    /**
     * @inheritdoc
     */
    public function init()
    {
        parent::init();
        ob_start();
    }

    /**
     * @inheritdoc
     */
    public function run()
    {
        $script = ob_get_clean();
        $script = preg_replace('|^\s*<script>|ui', '', $script);
        $script = preg_replace('|</script>\s*$|ui', '', $script);
        $this->getView()->registerJs($script, $this->position);
    }
}