<?php
|
|
namespace app\common\model\plus\bargain;
|
|
use app\common\model\BaseModel;
|
|
/**
|
* 砍价商品模型
|
* @package app\common\model\plus\bargain
|
*/
|
class Product extends BaseModel
|
{
|
protected $name = 'bargain_product';
|
protected $pk = 'bargain_product_id';
|
|
protected $append = ['product_sales', 'status_text'];
|
|
/**
|
* 计算显示销量 (初始销量 + 实际销量)
|
*/
|
public function getProductSalesAttr($value, $data)
|
{
|
return $data['sales_initial'] + $data['total_sales'];
|
}
|
|
/**
|
* 状态
|
*/
|
public function getStatusTextAttr($value, $data)
|
{
|
if($data['status'] == 0){
|
return '待审核';
|
}
|
if($data['status'] == 10){
|
return '通过';
|
}
|
if($data['status'] == 20){
|
return '未通过';
|
}
|
return '';
|
}
|
|
/**
|
*关联商品主表
|
*/
|
public function product()
|
{
|
return $this->hasOne('app\\common\\model\\product\\Product', 'product_id', 'product_id');
|
}
|
|
/**
|
* 详情
|
*/
|
public static function detail($bargain_product_id, $with = [])
|
{
|
return (new static())->with($with)->find($bargain_product_id);
|
}
|
|
/**
|
*关联商品规格表
|
*/
|
public function bargainSku()
|
{
|
return $this->hasMany('app\\common\\model\\plus\\bargain\\BargainSku', 'bargain_product_id', 'bargain_product_id');
|
}
|
|
/**
|
*关联活动表
|
*/
|
public function active()
|
{
|
return $this->belongsTo('app\\common\\model\\plus\\bargain\\Active', 'bargain_activity_id', 'bargain_activity_id');
|
}
|
|
/**
|
* 关联供应商
|
*/
|
public function supplier()
|
{
|
return $this->hasMany('app\\common\\model\\supplier\\Supplier', 'shop_supplier_id', 'shop_supplier_id');
|
}
|
|
/**
|
* 商品ID是否存在
|
*/
|
public static function isExistProductId($productId)
|
{
|
/*return (new static)->where('product_id', '=', $productId)
|
->where('is_delete', '=', 0)
|
->value('bargain_product_id');*/
|
return (new static)->alias('b')->where('b.product_id', '=', $productId)
|
->join('bargain_activity ba', 'ba.bargain_activity_id=b.bargain_activity_id')
|
->where('ba.is_delete', '=', 0)
|
->where('b.is_delete', '=', 0)
|
->value('b.bargain_product_id');
|
}
|
}
|
