<?php

namespace app\common\model\plus\groupbuy;

use app\common\model\BaseModel;

/**
 * 团购商品模型
 */
class Product extends BaseModel
{
    protected $name = 'groupbuy_product';
    protected $pk = 'groupbuy_product_id';

    public function active()
    {
        return $this->belongsTo('app\\common\\model\\plus\\groupbuy\\Active', 'groupbuy_active_id', 'groupbuy_active_id');
    }
    /**
     * 关联商品表
     */
    public function product()
    {
        return $this->belongsTo('app\\common\\model\\product\\Product', 'product_id', 'product_id');
    }

    /**
     * 关联团购SKU表
     */
    public function groupbuySku()
    {
        return $this->hasMany('app\\common\\model\\plus\\groupbuy\\ProductSku', 'groupbuy_product_id', 'groupbuy_product_id');
    }

    /**
     * 关联供应商
     */
    public function supplier()
    {
        return $this->hasMany('app\\common\\model\\supplier\\Supplier', 'shop_supplier_id', 'shop_supplier_id');
    }

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

    /**
     * 判断商品ID是否存在
     */
    public static function isExistProductId($productId)
    {
        return (new static)->alias('a')->where('a.product_id', '=', $productId)
            ->join('groupbuy_active ga', 'ga.groupbuy_active_id=a.groupbuy_active_id')
            ->where('ga.is_delete', '=', 0)
            ->where('a.is_delete', '=', 0)
            ->value('a.groupbuy_product_id');
    }

    /**
     * 根据商品ID获取团购商品
     */
    public static function getByProductId($productId)
    {
        return (new static())->where('product_id', '=', $productId)
            ->where('is_delete', '=', 0)
            ->where('state', '=', 10)
            ->find();
    }
}