<?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');
|
}
|
}
|
