<?php

namespace common\models;

use backend\models\Importers;
use Yii;

/**
 * This is the model class for table "w_margins_groups".
 *
 * @property integer $id
 * @property integer $importer_id
 * @property integer $margin_id
 * @property string $group
 * @property double $koef
 * @property string $timestamp
 */
class MarginsGroups extends \yii\db\ActiveRecord
{
    /**
     * @inheritdoc
     */
    public static function tableName()
    {
        return 'w_margins_groups';
    }

    /**
     * @inheritdoc
     */
    public function rules()
    {
        return [
            [['importer_id', 'margin_id', 'group', 'koef'], 'required'],
            [['importer_id', 'margin_id'], 'integer'],
            [['koef'], 'number'],
            [['timestamp'], 'safe'],
            [['group'], 'string', 'max' => 200],
            [['importer_id', 'margin_id', 'group'], 'unique', 'targetAttribute' => ['importer_id', 'margin_id', 'group'], 'message' => 'The combination of Importer ID, Margin ID and Group has already been taken.']
        ];
    }

    /**
     * @inheritdoc
     */
    public function attributeLabels()
    {
        return [
            'id' => 'ID',
            'importer_id' => 'Поставщик',
            'margin_id' => 'Тип цены',
            'group' => 'ГРУППА',
            'koef' => 'Коэффициент',
            'timestamp' => 'ДАТА',
        ];
    }

    public function beforeSave($insert)
    {
        if (parent::beforeSave($insert)) {
            $this->timestamp = date("Y-m-d H:i:s");
            return true;
        } else {
            return false;
        }
    }

    public function getImporters()
    {
        return $this->hasOne(Importers::className(), ['id' => 'importer_id']);
    }

    public function getMargins()
    {
        return $this->hasOne(Margins::className(), ['id' => 'margin_id']);
    }
}