<?php

namespace app\common\model\product;

use app\common\model\BaseModel;

/**
 * 商品多分类模型
 */
class ProductCategory extends BaseModel
{
  protected $name = 'product_category';
  protected $pk = 'product_category_id';

  /**
     * 关联商品分类表
     */
    public function category()
    {
        return $this->belongsTo('app\\common\\model\\product\\Category', 'categary_id', 'categary_id');
    }

    /**
     * 根据
     */
    public static function getProductIds($category_id)
    {
        return (new self)->where('category_id', '=', $category_id)->column('product_id');
    }

    /**
     * 根据多个分类获取商品
     */
    public static function getProductIdsByCategorys($category_ids)
    {
        return (new self)->where('category_id', 'in', $category_ids)->column('product_id');
    }

    /**
     * 获取商品所有分类
     */
    public static function getProductCategoryIds($product_id)
    {
        return (new ProductCategory)->where('product_id', '=', $product_id)
            ->column('category_id');
    }
}