<?php

namespace app\models;

use app\plugins\mch\models\Mch;
use app\plugins\mch\models\MchGoods;
use Yii;

/**
 * This is the model class for table "{{%goods}}".
 *
 * @property int $id
 * @property int $mall_id
 * @property int $mch_id
 * @property int $goods_warehouse_id
 * @property int $status 上架状态：0=下架，1=上架
 * @property string $price 售价
 * @property int $use_attr 是否使用规格：0=不使用，1=使用
 * @property string $attr_groups 商品规格组
 * @property int $virtual_sales 已出售量
 * @property string $created_at
 * @property string $updated_at
 * @property string $deleted_at
 * @property int $is_delete
 * @property int $sort 排序
 * @property int $goods_stock 商品总库存
 * @property int $confine_count 购物数量限制
 * @property int $shipping_id 包邮模板ID
 * @property int $freight_id 运费模板ID
 * @property int $give_integral 赠送积分
 * @property int $give_integral_type 赠送积分类型1.固定值 |2.百分比
 * @property int $give_balance 赠送余额
 * @property int $give_balance_type 赠送余额类型1.固定值 |2.百分比
 * @property int $forehead_integral 可抵扣积分
 * @property int $forehead_integral_type 可抵扣积分类型1.固定值 |2.百分比
 * @property int $accumulative 允许多件累计折扣
 * @property int $individual_share 是否单独分销设置：0=否，1=是
 * @property int $attr_setting_type 分销设置类型 0.普通设置|1.详细设置
 * @property int $is_level 是否享受会员价购买
 * @property int $is_level_alone 是否单独设置会员价
 * @property int $share_type 佣金配比 0--固定金额 1--百分比
 * @property string $sign 商品标示用于区分商品属于什么模块
 * @property string $app_share_pic 自定义分享图片
 * @property string $app_share_title 自定义分享标题
 * @property int $is_default_services 默认服务 0.否|1.是
 * @property int $payment_people 支付人数
 * @property int $payment_num 支付件数
 * @property string $payment_amount 支付金额
 * @property int $payment_order 支付订单数
 * @property int $form_id 自定义表单id  0--表示默认表单 -1--表示不使用表单
 * @property int $confine_order_count
 * @property int $is_area_limit 是否单独区域购买
 * @property string $area_limit
 * @property int $sales 商品实际销量
 * @property int $limit_buy_status 限购状态0--关闭 1--开启
 * @property string $limit_buy_type 限购类型 day--每天 week--每周 month--每月 all--永久
 * @property int $limit_buy_value 限购数量
 * @property int $min_number 起售数量
 * @property int $is_setting_show_and_buy_auth 是否单独设置浏览和购买权限
 * @property string $show_goods_auth 会员等级浏览权限
 * @property string $buy_goods_auth 会员等级购买权限
 * @property int $is_setting_send_type 是否单独设置发货方式0--否 1--是
 * @property string $send_type 发货方式
 * @property int $is_time 是否单独设置销售时间
 * @property string $sell_begin_time 开售时间
 * @property string $sell_end_time 结束时间
 *
 * @property GoodsShare[] $share
 * @property GoodsAttr[] $attr
 * @property GoodsCards[] $cards
 * @property Coupon[] $coupons
 * @property GoodsServices[] $services
 * @property GoodsWarehouse $goodsWarehouse
 * @property MallGoods $mallGoods
 * @property MchGoods $mchGoods
 * @property Mch $mch
 *
 * @property string $name 商品名称
 * @property string $subtitle 副标题
 * @property string $originalPrice 原价
 * @property string $costPrice 成本价
 * @property string $detail 商品详情，图文
 * @property string $coverPic 商品缩略图
 * @property string $picUrl 商品轮播图
 * @property string $videoUrl 商品视频
 * @property string $unit 单位
 * @property string $pageUrl 商品跳转链接
 * @property GoodsShare $shareLevel
 * @property GoodsCardRelation $goodsCardRelation
 * @property int $detail_count 商品详情浏览量
 * @property GoodsCouponRelation $goodsCouponRelation
 * @property string $guarantee_title 商品服务标题
 * @property string $guarantee_pic 商品服务标识
 * @property string $param_name 参数名称
 * @property string $param_content 参数内容
 */
class Goods extends ModelActiveRecord
{
    // 商品编辑事件
    const EVENT_EDIT = 'goodsEdit';
    // 商品删除事件
    const EVENT_DESTROY = 'goodsDestroy';
    // 商品上下架事件
    const EVENT_STATUS = 'goodsStatus';

    /**
     * {@inheritdoc}
     */
    public static function tableName()
    {
        return '{{%goods}}';
    }

    /**
     * {@inheritdoc}
     */
    public function rules()
    {
        return [
            [['mall_id', 'goods_warehouse_id', 'attr_groups', 'freight_id', 'created_at', 'updated_at',
                'deleted_at'], 'required'],
            [['mall_id', 'mch_id', 'goods_warehouse_id', 'status', 'use_attr', 'goods_stock', 'virtual_sales',
                'confine_count', 'shipping_id', 'freight_id', 'give_integral', 'give_integral_type',
                'forehead_integral_type', 'accumulative', 'individual_share', 'attr_setting_type', 'is_level',
                'is_level_alone', 'share_type', 'is_default_services', 'sort', 'is_delete', 'payment_people',
                'payment_num', 'payment_order', 'confine_order_count', 'is_area_limit', 'form_id', 'sales',
                'detail_count', 'give_balance_type', 'limit_buy_status', 'limit_buy_value', 'min_number',
                'is_setting_show_and_buy_auth', 'is_setting_send_type', 'is_time'], 'integer'],
            [['price', 'forehead', 'forehead_integral', 'payment_amount', 'give_balance'], 'number'],
            [['attr_groups', 'area_limit', 'param_content', 'show_goods_auth', 'buy_goods_auth',
                'send_type'], 'string'],
            [['created_at', 'updated_at', 'deleted_at', 'sell_begin_time', 'sell_end_time'], 'safe'],
            [['sign', 'app_share_pic', 'param_name'], 'string', 'max' => 255],
            [['app_share_title'], 'string', 'max' => 65],
            [['guarantee_title'], 'string', 'max' => 64],
            [['guarantee_pic'], 'string', 'max' => 2048],
            [['limit_buy_type'], 'string', 'max' => 50],
        ];
    }

    /**
     * {@inheritdoc}
     */
    public function attributeLabels()
    {
        return [
            'id' => 'ID',
            'mall_id' => 'Mall ID',
            'mch_id' => 'Mch ID',
            'goods_warehouse_id' => 'Goods Warehouse ID',
            'status' => '上架状态：0=下架，1=上架',
            'price' => '售价',
            'use_attr' => '是否使用规格：0=不使用，1=使用',
            'attr_groups' => '商品规格组',
            'virtual_sales' => '已出售量',
            'created_at' => 'Created At',
            'updated_at' => 'Updated At',
            'deleted_at' => 'Deleted At',
            'is_delete' => 'Is Delete',
            'sort' => '排序',
            'goods_stock' => '商品总库存',
            'confine_count' => '购物数量限制',
            'shipping_id' => '包邮模板ID',
            'freight_id' => '运费模板ID',
            'give_integral' => '赠送积分',
            'give_integral_type' => '赠送积分类型1.固定值 |2.百分比',
            'give_balance' => '赠送余额',
            'give_balance_type' => '赠送余额类型1.固定值 |2.百分比',
            'forehead_integral' => '可抵扣积分',
            'forehead_integral_type' => '可抵扣积分类型1.固定值 |2.百分比',
            'accumulative' => '允许多件累计折扣',
            'individual_share' => '是否单独分销设置：0=否，1=是',
            'attr_setting_type' => '分销设置类型 0.普通设置|1.详细设置',
            'is_level' => '是否享受会员价购买',
            'is_level_alone' => '是否单独设置会员价',
            'share_type' => '佣金配比 0--固定金额 1--百分比',
            'sign' => '商品标示用于区分商品属于什么模块',
            'app_share_pic' => '自定义分享图片',
            'app_share_title' => '自定义分享标题',
            'is_default_services' => '默认服务 0.否|1.是',
            'payment_people' => '支付人数',
            'payment_num' => '支付件数',
            'payment_amount' => '支付金额',
            'payment_order' => '支付订单数',
            'form_id' => '自定义表单id  0--表示默认表单 -1--表示不使用表单',
            'confine_order_count' => '限单数量',
            'sales' => '商品实际销量',
            'detail_count' => '商品详情浏览量',
            'guarantee_title' => '商品服务标题',
            'guarantee_pic' => '商品服务标识',
            'param_name' => '参数名称',
            'param_content' => '参数内容',
            'limit_buy_status' => '限购状态0--关闭 1--开启',
            'limit_buy_type' => '限购类型 day--每天 week--每周 month--每月 all--永久',
            'limit_buy_value' => '限购数量',
            'min_number' => '起售数量',
            'is_setting_show_and_buy_auth' => '是否单独设置浏览和购买权限',
            'show_goods_auth' => '会员等级浏览权限',
            'buy_goods_auth' => '会员等级购买权限',
            'is_setting_send_type' => '是否单独设置发货方式0--否 1--是',
            'send_type' => '发货方式',
            'is_time' => '是否单独设置销售时间',
            'sell_begin_time' => '开售时间',
            'sell_end_time' => '结束时间',
        ];
    }

    public function getServices()
    {
        return $this->hasMany(GoodsServices::className(), ['id' => 'service_id'])
            ->viaTable(GoodsServiceRelation::tableName(), ['goods_id' => 'id'], function ($query) {
                $query->andWhere(['is_delete' => 0]);
            })->andWhere(['is_delete' => 0])->orderBy(['sort' => SORT_ASC]);
    }

    public function getCards()
    {
        return $this->hasMany(GoodsCards::className(), ['id' => 'card_id'])
            ->viaTable(GoodsCardRelation::tableName(), ['goods_id' => 'id'], function ($query) {
                $query->andWhere(['is_delete' => 0]);
            })->andWhere(['is_delete' => 0]);
    }

    public function getGoodsCardRelation()
    {
        return $this->hasMany(GoodsCardRelation::className(), ['goods_id' => 'id'])->andWhere(['is_delete' => 0]);
    }

    public function getCoupons()
    {
        return $this->hasMany(Coupon::className(), ['id' => 'coupon_id'])
            ->viaTable(GoodsCouponRelation::tableName(), ['goods_id' => 'id'], function ($query) {
                $query->andWhere(['is_delete' => 0]);
            })->andWhere(['is_delete' => 0]);
    }

    public function getGoodsCouponRelation()
    {
        return $this->hasMany(GoodsCouponRelation::className(), ['goods_id' => 'id'])->andWhere(['is_delete' => 0]);
    }

    public function getAttr()
    {
        return $this->hasMany(GoodsAttr::className(), ['goods_id' => 'id'])->andWhere([
            'is_delete' => 0,
        ]);
    }

    public function getCart()
    {
        return $this->hasMany(Cart::className(), ['goods_id' => 'id']);
    }

    public function getMch()
    {
        return $this->hasOne(Mch::className(), ['id' => 'mch_id']);
    }

    /**
     * 将规格组重新排列组合成一维数组
     * 键名为 attr_id:attr_id 例如 1:2
     * @param $arr null|string|array
     * @return array
     */
    public function resetAttr($arr = null)
    {
        if (!$arr) {
            $arr = Yii::$app->serializer->decode($this->attr_groups);
        }
        if (is_string($arr)) {
            $arr = Yii::$app->serializer->decode($arr);
        }
        if (!(is_array($arr) || is_object($arr))) {
            $arr = Yii::$app->serializer->decode($arr);
        }
        $result = [];
        foreach ($arr as $item) {
            $newItem = [];
            $result2 = [];
            foreach ($item['attr_list'] as $value) {
                $result1 = [];
                $str = $value['attr_id'];
                $newItem[$str] = [
                    [
                        'attr_group_name' => $item['attr_group_name'],
                        'attr_group_id' => $item['attr_group_id'],
                        'attr_id' => $value['attr_id'],
                        'attr_name' => $value['attr_name'],
                    ]
                ];
                if (count($result) > 0) {
                    foreach ($result as $key2 => $item2) {
                        $str2 = $key2 . ':' . $str;
                        $result1[$str2] = array_merge($item2, $newItem[$str]);
                    }
                    $result2 = array_merge($result2, $result1);
                } else {
                    $result2 = $newItem;
                }
            }
            $result = $result2;
        }
        return $result;
    }

    /**
     * 单个sing_id获取相应规格
     * @param $signId
     * @param null|string|array $arr
     * @return mixed
     */
    public function signToAttr($signId, $arr = null)
    {
        $attrGroupList = $this->resetAttr($arr);
        return $attrGroupList[$signId];
    }

    public function getShare()
    {
        return $this->hasMany(GoodsShare::className(), ['goods_id' => 'id'])->where(['is_delete' => 0, 'level' => 0]);
    }

    public function getMchGoods()
    {
        return $this->hasOne(MchGoods::className(), ['goods_id' => 'id']);
    }

    public function getGoodsWarehouse()
    {
        return $this->hasOne(GoodsWarehouse::className(), ['id' => 'goods_warehouse_id']);
    }

    public function getMallGoods()
    {
        return $this->hasOne(MallGoods::className(), ['goods_id' => 'id']);
    }

    public function getName()
    {
        return $this->goodsWarehouse->name;
    }

    public function getSubtitle()
    {
        return $this->goodsWarehouse->subtitle;
    }

    public function getOriginalPrice()
    {
        return $this->goodsWarehouse->original_price;
    }

    public function getCostPrice()
    {
        return $this->goodsWarehouse->cost_price;
    }

    public function getDetail()
    {
        return $this->goodsWarehouse->detail;
    }

    public function getCoverPic()
    {
        return $this->goodsWarehouse->cover_pic;
    }

    public function getPicUrl()
    {
        return $this->goodsWarehouse->pic_url;
    }

    public function getVideoUrl()
    {
        return $this->goodsWarehouse->video_url;
    }

    public function getUnit()
    {
        return $this->goodsWarehouse->unit;
    }

    public function getPrice()
    {
        return $this->price;
    }

    public function getSales()
    {
        return $this->sales;
    }

    /**
     * @return string
     */
    public function getPageUrl()
    {
        try {
            if ($this->mch_id) {
                $plugins = \Yii::$app->plugin->getPlugin('mch');
            } elseif ($this->sign) {
                $plugins = \Yii::$app->plugin->getPlugin($this->sign);
            } else {
                throw new \Exception('商城商品');
            }
            if (!method_exists($plugins, 'getGoodsUrl')) {
                throw new \Exception('不存在getGoodsUrl方法');
            }
            $pageUrl = $plugins->getGoodsUrl(['id' => $this->id, 'mch_id' => $this->mch_id]);
        } catch (\Exception $exception) {
            $pageUrl = '/pages/goods/goods?id=' . $this->id;
        }
        return $pageUrl;
    }

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