backend/models/Importers.php

<?php
namespace backend\models;
use Yii;
use backend\components\base\BaseActiveRecord;
/**
 * This is the model class for table "{{%importer}}".
 *
 * @property integer $id
 * @property string $code
 * @property string $name
 * @property string $name_price
 * @property string $currency_id
 * @property string $delivery
 * @property string $email
 * @property string $info
 * @property integer $active
 * @property integer $PARSER_IS_ACTIVE
 * @property string $PARSER_COLUMN_COUNT
 * @property string $PARSER_FIELD_BRAND
 * @property string $PARSER_FIELD_ARTICLE
 * @property integer $PARSER_FIELD_ARTICLE_PREFIX
 * @property string $PARSER_FIELD_PRICE
 * @property string $PARSER_FIELD_DESCR
 * @property string $PARSER_FIELD_BOX
 * @property string $PARSER_FIELD_ADD_BOX
 * @property string $PARSER_FIELD_GROUP_RG
 * @property string $PARSER_FIELD_SIGN
 * @property double $PARSER_FIELD_MULTIPLIER
 * @property string $price_date_update
 */
class Importers extends BaseActiveRecord
{
    public function rules()
    {
        return [
            [['code', 'name', 'currency_id', 'delivery', 'price_date_update'], 'required'],
            [['name_price', 'email', 'PARSER_FIELD_SIGN', 'info'], 'safe'],
            [['currency_id', 'active', 'PARSER_IS_ACTIVE', 'PARSER_COLUMN_COUNT', 'PARSER_FIELD_BRAND', 'PARSER_FIELD_ARTICLE', 'PARSER_FIELD_ARTICLE_PREFIX', 'PARSER_FIELD_PRICE', 'PARSER_FIELD_DESCR', 'PARSER_FIELD_BOX', 'PARSER_FIELD_ADD_BOX', 'PARSER_FIELD_GROUP_RG'], 'integer'],
            [['info'], 'string'],
            [['PARSER_FIELD_MULTIPLIER'], 'number'],
            [['code', 'name', 'name_price', 'delivery', 'email'], 'string', 'max' => 254],
            [['PARSER_FIELD_SIGN'], 'string', 'max' => 1],
         //   [['price_date_update'], 'string', 'max' => 15],
            [['code'], 'unique'],
            [['name'], 'unique']
        ];
    }
    /**
     * @inheritdoc
     */
    public function attributeLabels()
    {
        return [
            'id' => Yii::t('app', 'ID'),
            'code' => Yii::t('app', 'Code'),
            'name' => Yii::t('app', 'Name'),
            'name_price' => Yii::t('app', 'Name Price'),
            'currency_id' => Yii::t('app', 'Currency ID'),
            'delivery' => Yii::t('app', 'Delivery'),
            'email' => Yii::t('app', 'Email'),
            'info' => Yii::t('app', 'Info'),
            'active' => Yii::t('app', 'Active'),
            'PARSER_IS_ACTIVE' => Yii::t('app', 'Parser  Is  Active'),
            'PARSER_COLUMN_COUNT' => Yii::t('app', 'Parser  Column  Count'),
            'PARSER_FIELD_BRAND' => Yii::t('app', 'Parser  Field  Brand'),
            'PARSER_FIELD_ARTICLE' => Yii::t('app', 'Parser  Field  Article'),
            'PARSER_FIELD_ARTICLE_PREFIX' => Yii::t('app', 'Parser  Field  Article  Prefix'),
            'PARSER_FIELD_PRICE' => Yii::t('app', 'Parser  Field  Price'),
            'PARSER_FIELD_DESCR' => Yii::t('app', 'Parser  Field  Descr'),
            'PARSER_FIELD_BOX' => Yii::t('app', 'Parser  Field  Box'),
            'PARSER_FIELD_ADD_BOX' => Yii::t('app', 'Parser  Field  Add  Box'),
            'PARSER_FIELD_GROUP_RG' => Yii::t('app', 'Parser  Field  Group  Rg'),
            'PARSER_FIELD_SIGN' => Yii::t('app', 'Parser  Field  Sign'),
            'PARSER_FIELD_MULTIPLIER' => Yii::t('app', 'Parser  Field  Multiplier'),
            'price_date_update' => Yii::t('app', 'Price Date Update'),
        ];
    }
    public function getKeys ()
    {
        // возьмем только поля описанные в fields() - там как раз наши настройки парсера
        $arr = $this->toArray();
        // отсортируем по ключам с учетом преобразования в число
        asort($arr, SORT_NUMERIC);
        // уберем нулевые колонки
        $arr = array_filter($arr, function($val){
            return $val <> '0';
        });
        // нам нужны именно ключи
        $arr = array_keys($arr);
        return $arr;
    }
    public function fields()
    {
        return [
            'BRAND' => 'PARSER_FIELD_BRAND',
            'ARTICLE' => 'PARSER_FIELD_ARTICLE',
            'PRICE' => 'PARSER_FIELD_PRICE',
            'DESCR' => 'PARSER_FIELD_DESCR',
            'BOX' => 'PARSER_FIELD_BOX',
            'ADD_BOX' => 'PARSER_FIELD_ADD_BOX',
            'GROUP_RG' => 'PARSER_FIELD_GROUP_RG'
        ];
    }
}