<?php

namespace app\common\model\plus\groupbuy;

use app\common\model\BaseModel;

/**
 * 团购商品SKU模型
 */
class ProductSku extends BaseModel
{
    protected $name = 'groupbuy_product_sku';
    protected $pk = 'groupbuy_product_sku_id';

    /**
     * 关联商品规格表
     */
    public function productSku()
    {
        return $this->belongsTo('app\\common\\model\\product\\ProductSku', 'product_sku_id', 'product_sku_id');
    }

    /**
     * 获取团购商品SKU详情
     */
    public static function detail($groupbuy_product_sku_id)
    {
        return (new static())->where('groupbuy_product_sku_id', '=', $groupbuy_product_sku_id)->find();
    }

    /**
     * 根据团购商品ID获取所有SKU
     */
    public static function getAllByGroupbuyProductId($groupbuy_product_id)
    {
        return (new static())->where('groupbuy_product_id', '=', $groupbuy_product_id)->select();
    }
}