<?php

namespace common\models;

use Yii;

/**
 * This is the model class for table "product_variant".
 *
 * @property integer $product_variant_id
 * @property integer $product_id
 * @property string $name
 * @property string $sku
 * @property double $price
 * @property double $price_old
 * @property double $stock
 * @property integer $product_unit_id
 *
 * @property OrderItems[] $orderItems
 * @property ProductUnit $productUnit
 */
class ProductVariant extends \yii\db\ActiveRecord
{
    /**
     * @inheritdoc
     */
    public static function tableName()
    {
        return 'product_variant';
    }

    /**
     * @inheritdoc
     */
    public function rules()
    {
        return [
            [['product_id', 'sku'], 'required'],
            [['product_id', 'product_unit_id'], 'integer'],
            [['price', 'price_old', 'stock'], 'number'],
            [['name', 'sku'], 'string', 'max' => 255],
            [['product_unit_id'], 'exist', 'skipOnError' => true, 'targetClass' => ProductUnit::className(), 'targetAttribute' => ['product_unit_id' => 'product_unit_id']],
        ];
    }

    /**
     * @inheritdoc
     */
    public function attributeLabels()
    {
        return [
            'product_variant_id' => Yii::t('app', 'Product Variant ID'),
            'product_id' => Yii::t('app', 'Product ID'),
            'name' => Yii::t('app', 'Name'),
            'sku' => Yii::t('app', 'Sku'),
            'price' => Yii::t('app', 'Price'),
            'price_old' => Yii::t('app', 'Price Old'),
            'stock' => Yii::t('app', 'Stock'),
            'product_unit_id' => Yii::t('app', 'Product Unit ID'),
        ];
    }

    /**
     * @return \yii\db\ActiveQuery
     */
    public function getOrderItems()
    {
        return $this->hasMany(OrderItems::className(), ['item_id' => 'product_variant_id']);
    }

    /**
     * @return \yii\db\ActiveQuery
     */
    public function getProductUnit()
    {
        return $this->hasOne(ProductUnit::className(), ['product_unit_id' => 'product_unit_id']);
    }
}