<?php

namespace app\models;

/**
 * This is the model class for table "{{%goods_warehouse}}".
 *
 * @property int $id
 * @property int $mall_id
 * @property string $name 商品名称
 * @property string $subtitle 副标题
 * @property string $original_price 原价
 * @property string $cost_price 成本价
 * @property string $detail 商品详情，图文
 * @property string $cover_pic 商品缩略图
 * @property string $pic_url 商品轮播图
 * @property string $video_url 商品视频
 * @property string $unit 单位
 * @property string $created_at
 * @property string $updated_at
 * @property string $deleted_at
 * @property int $is_delete
 * @property string $type 商品类型：goods--实体商品 ecard--电子卡密
 * @property int $ecard_id 卡密id
 * @property GoodsCatRelation[] $goodsCatRelation
 * @property GoodsCats $cats
 * @property Goods[] $goods
 * @property Goods $goodsInfo
 * @property $mchCats
 * @property Ecard $ecard
 */
class GoodsWarehouse extends ModelActiveRecord
{
    const TYPE_VIRTUAL = 'exchange'; //虚拟商品 和兑换中心同名
    /**
     * {@inheritdoc}
     */
    public static function tableName()
    {
        return '{{%goods_warehouse}}';
    }

    /**
     * {@inheritdoc}
     */
    public function rules()
    {
        return [
            [['mall_id', 'name', 'detail', 'pic_url', 'created_at', 'updated_at', 'deleted_at'], 'required'],
            [['mall_id', 'is_delete', 'ecard_id'], 'integer'],
            [['original_price', 'cost_price'], 'number'],
            [['detail', 'pic_url'], 'string'],
            [['created_at', 'updated_at', 'deleted_at'], 'safe'],
            [['name', 'subtitle', 'cover_pic', 'video_url', 'unit', 'type'], 'string', 'max' => 255],
        ];
    }

    /**
     * {@inheritdoc}
     */
    public function attributeLabels()
    {
        return [
            'id' => 'ID',
            'mall_id' => 'Mall ID',
            'name' => '商品名称',
            'subtitle' => '副标题',
            'original_price' => '原价',
            'cost_price' => '成本价',
            'detail' => '商品详情，图文',
            'cover_pic' => '商品缩略图',
            'pic_url' => '商品轮播图',
            'video_url' => '商品视频',
            'unit' => '单位',
            'created_at' => 'Created At',
            'updated_at' => 'Updated At',
            'deleted_at' => 'Deleted At',
            'is_delete' => 'Is Delete',
            'type' => '商品类型：goods--实体商品 ecard--电子卡密',
            'ecard_id' => '卡密id',
        ];
    }

    public function getGoodsCatRelation()
    {
        return $this->hasMany(GoodsCatRelation::className(), ['goods_warehouse_id' => 'id'])->where(['is_delete' => 0]);
    }

    public function getCats()
    {
        return $this->hasMany(GoodsCats::className(), ['id' => 'cat_id'])
            ->where(['mch_id' => 0])
            ->via('goodsCatRelation');
    }

    public function getMchCats()
    {
        return $this->hasMany(GoodsCats::className(), ['id' => 'cat_id'])
            ->where(['>', 'mch_id', 0])
            ->via('goodsCatRelation');
    }

    public function getGoods()
    {
        return $this->hasMany(Goods::className(), ['goods_warehouse_id' => 'id']);
    }

    public function getGoodsInfo()
    {
        return $this->hasOne(Goods::className(), ['goods_warehouse_id' => 'id'])->where(['sign' => ['', 'mch']]);
    }

    public function getEcard()
    {
        return $this->hasOne(Ecard::className(), ['id' => 'ecard_id']);
    }
}