<?php

namespace app\models;

use yii;

/**
 * @property int            id
 * @property int            typeId
 * @property string         internalTypeId
 * @property null,string    forceSingleNode         (null|"y")
 * @property string         typeCode
 * @property string         typeName
 * @property string         typeCanEdit             ("y"|"n")
 * @property string         typeSorter
 * @property string         name
 * @property string         sorter
 * @property string         typeSearchAnd
 * @property string         canSearch               ("y"|"n")
 * @property string         canSearchRaw            ("y"|"n")
 * @property string         displayInObject         ("y"|"n")
 * @property string         displayInObjectRaw      ("y"|"n")
 * @property string         displayInObjectList     ("y"|"n")
 * @property string         displayInObjectListRaw  ("y"|"n")
 * @property string         factor                  (0..1)
 * @property string         attributeDataType
 * @property string         attributeNames
 * @property string         uofmPre
 * @property string         uofmPost
 * @property string         attributeCode
 * @property string         required                ("y"|"n")
 * @property string         sortable                ("y"|"n")
 * @property string         typeCanHavePhoto        ("y"|"n")
 * @property string         typeCanSearch           ("y"|"n")
 * @property string         typeDisplayInObject     ("y"|"n")
 * @property string         typeDisplayInObjectList ("y"|"n")
 * @property string         typeRequiredForObject   ("y"|"n")
 * @property string         enabled
 * @property string         languageId
 * @property string         added
 * @property string         changed
 * @property string         tagNames
 */
class AdminAttribute extends AdminAbstract
{
    const USE_VIEW = true;
    const ENABLE_TRANSLATE = true;
    const TAG_LINK_TYPE = 'owns';

    protected $_saveViaDbFunction = true;
    protected $_saveViaDbFunctionItem = 'attribute';
    protected $_notNullFields = ['decimalRound'];

    protected $_attributeInsertViaDbFunctionColumn = [
        'text'     => ['typeId', 'typeCode', 'name', 'sorter', 'canSearchRaw', 'displayInObjectRaw', 'displayInObjectListRaw', 'factor',
                       'enabled', 'attributeCode', 'required', 'sortable', 'uofmPre', 'uofmPost', 'long'],
        'numeric'  => ['typeId', 'typeCode', 'name', 'sorter', 'canSearchRaw', 'displayInObjectRaw', 'displayInObjectListRaw', 'factor',
                       'enabled', 'attributeCode', 'required', 'sortable', 'uofmPre', 'uofmPost', 'decimalMin', 'decimalMax', 'decimalRound'],
        'datetime' => ['typeId', 'typeCode', 'name', 'sorter', 'canSearchRaw', 'displayInObjectRaw', 'displayInObjectListRaw', 'factor',
                       'enabled', 'attributeCode', 'required', 'sortable', 'uofmPre', 'uofmPost', 'datetimeStorageId']
    ];

    protected $_attributeUpdateViaDbFunctionColumn = [
        'text'     => ['id', 'sorter', 'canSearchRaw', 'displayInObjectRaw', 'displayInObjectListRaw', 'factor', 'enabled', 'attributeCode', 'required', 'sortable', 'long'],
        'numeric'  => ['id', 'sorter', 'canSearchRaw', 'displayInObjectRaw', 'displayInObjectListRaw', 'factor', 'enabled', 'attributeCode', 'required', 'sortable', 'decimalMin', 'decimalMax', 'decimalRound'],
        'datetime' => ['id', 'sorter', 'canSearchRaw', 'displayInObjectRaw', 'displayInObjectListRaw', 'factor', 'enabled', 'attributeCode', 'required', 'sortable', 'datetimeStorageId']
    ];


    protected $_updateViaDbFunctionResetColumn = ['canSearchRaw', 'displayInObjectRaw', 'displayInObjectListRaw', 'decimalMin', 'decimalMax'];

    public $type;

    public $dataType;

    //властивості атрибуту типу "text"
    public $long;

    //властивості атрибуту типу "numeric"
    public $decimalMax;
    public $decimalMin;
    public $decimalRound;

    //властивості атрибуту типу "datetime"
    public $datetimeStorageId;

    public function scenarios()
    {
        return [
            'insert'  => ['name', 'typeId', 'canSearchRaw', 'enabled', 'uofmPre', 'uofmPost'],
            'update'  => ['name', 'typeId', 'canSearchRaw', 'enabled', 'uofmPre', 'uofmPost']
        ];
    }

    public static function tableNameLocale()
    {
        return 'attributeTL';
    }

    public function beforeSave($insert)
    {
        if (!$this->dataType) {
            $this->dataType = $this->getAttribute('attributeDataType');
        }
        if (in_array($this->dataType, ['text', 'numeric', 'datetime'])) {
            $this->_insertViaDbFunctionColumn = $this->_attributeInsertViaDbFunctionColumn[$this->dataType];
            $this->_updateViaDbFunctionColumn = $this->_attributeUpdateViaDbFunctionColumn[$this->dataType];
            $this->_saveViaDbFunctionItemTemplate['insert'] .= ucfirst($this->dataType);
            $this->_saveViaDbFunctionItemTemplate['update'] .= ucfirst($this->dataType);
        }
        return parent::beforeSave($insert);
    }

    protected static function _getContentFields()
    {
        return array_merge(['name'], parent::_getContentFields());
    }

    public function getAdditionalAttributes()
    {
        $result = [];
        $query = static::createQuery()
            ->from(['attributeTL'])
            ->andWhere(['id' => $this->getAttribute('id')])
        ;
        $contentAttributes = $query->createCommand()->queryAll();
        foreach ($contentAttributes as $contentAttribute) {
            $result['uofmPre_' . $contentAttribute['languageId']] = $contentAttribute['uofmPre'];
            $result['uofmPost_' . $contentAttribute['languageId']] = $contentAttribute['uofmPost'];
        }
        $query = static::createQuery()
            ->from(['attributeV'])
            ->select(['`textIsLong` `long`', '`datetimeStorageId` `storageId`', '`decimalMin` `min`',
                '`decimalMax` `max`', '`decimalRound` `round`'])
            ->andWhere(['id' => $this->getAttribute('id')])
        ;
        $result = array_merge($result, $query->createCommand()->queryOne());
        $result['min'] = isset($result['min']) ? (float) $result['min'] : null;
        $result['max'] = isset($result['max']) ? (float) $result['max'] : null;
        $result['round'] = isset($result['round']) ? (int) $result['round'] : null;
        return $result;
    }

}