You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
132 lines
4.2 KiB
132 lines
4.2 KiB
<?php
|
|
|
|
namespace addons\shopro\model;
|
|
|
|
use think\Model;
|
|
use addons\shopro\exception\Exception;
|
|
use addons\shopro\model\GoodsSku;
|
|
use addons\shopro\model\GoodsSkuPrice;
|
|
use traits\model\SoftDelete;
|
|
|
|
/**
|
|
* 商品模型
|
|
*/
|
|
class ScoreGoodsSkuPrice extends Model
|
|
{
|
|
use SoftDelete;
|
|
|
|
// 表名,不含前缀
|
|
protected $name = 'shopro_score_goods_sku_price';
|
|
// 自动写入时间戳字段
|
|
protected $autoWriteTimestamp = 'int';
|
|
// 定义时间戳字段名
|
|
protected $createTime = 'createtime';
|
|
protected $updateTime = 'updatetime';
|
|
protected $deleteTime = 'deletetime';
|
|
|
|
protected $hidden = ['createtime', 'updatetime', 'deletetime'];
|
|
|
|
// 追加属性
|
|
protected $append = [
|
|
|
|
];
|
|
|
|
|
|
|
|
public static function getGoodsList($params)
|
|
{
|
|
$keyword = $params['keyword'] ?? '';
|
|
|
|
// 获取所有积分商品
|
|
$goods_ids = ScoreGoodsSkuPrice::field('goods_id')->where('status', 'up')->group('goods_id')->column('goods_id');
|
|
|
|
$goods = Goods::where('id', 'in', $goods_ids);
|
|
|
|
if (!empty($keyword)) {
|
|
$goods = $goods->where('title|subtitle','like','%'. $keyword .'%');
|
|
}
|
|
|
|
$goods = $goods->with('scoreGoodsSkuPrice')->paginate(10);
|
|
|
|
$data = $goods->items();
|
|
foreach ($data as $key => $g) {
|
|
if (count($g['score_goods_sku_price'])) {
|
|
$g['price'] = $g['score_goods_sku_price'][0]['score'] . '积分';
|
|
if ($g['score_goods_sku_price'][0]['price'] > 0) {
|
|
$g['price'] .= '+￥' . $g['score_goods_sku_price'][0]['price'];
|
|
}
|
|
|
|
// 销量
|
|
$g['sales'] = array_sum(array_column($g['score_goods_sku_price'], 'sales'));
|
|
$g['stock'] = array_sum(array_column($g['score_goods_sku_price'], 'stock'));
|
|
}
|
|
$data[$key] = $g;
|
|
}
|
|
// $collection = collection($goods->items());
|
|
// $data = $collection->hidden(Goods::$list_hidden);
|
|
$goods->data = $data;
|
|
|
|
return $goods;
|
|
}
|
|
|
|
|
|
public static function getGoodsDetail($id)
|
|
{
|
|
$detail = Goods::where('id', $id)->find();
|
|
|
|
if (!$detail) {
|
|
new Exception('商品不存在或已下架');
|
|
}
|
|
// 增加商品附加数据, 活动默认全是 null
|
|
$detail = $detail->append(['service', 'sku', 'coupons']);
|
|
$detail->activity = null;
|
|
$detail->activity_type = null;
|
|
|
|
$score_sku_price = self::where([
|
|
'status' => 'up',
|
|
])->select();
|
|
|
|
$sku_price = GoodsSkuPrice::where([
|
|
'goods_id' => $detail['id'],
|
|
// 'status' => 'up', // 商品规格的上下架，不控制积分规格的上下架
|
|
])->select();
|
|
|
|
$new_sku_price = [];
|
|
foreach ($sku_price as $s => $k) {
|
|
foreach ($score_sku_price as $c) {
|
|
if ($k['id'] == $c['sku_price_id']) {
|
|
$new_sku_price[$s] = $k;
|
|
$new_sku_price[$s]['stock'] = $c['stock'];
|
|
$new_sku_price[$s]['sales'] = $c['sales'];
|
|
$new_sku_price[$s]['price'] = $c['price'];
|
|
$new_sku_price[$s]['score'] = $c['score'];
|
|
|
|
$new_sku_price[$s]['price_text'] = $c['score'] . '积分';
|
|
if ($c['price'] > 0) {
|
|
$new_sku_price[$s]['price_text'] .= '+￥' . $c['price'];
|
|
}
|
|
|
|
// 记录对应活动的规格的记录
|
|
$new_sku_price[$s]['item_goods_sku_price'] = $c;
|
|
break;
|
|
}
|
|
}
|
|
}
|
|
|
|
$sku_price = array_values($new_sku_price);
|
|
|
|
if (!count($sku_price)) {
|
|
new Exception('商品规格不存在或已下架');
|
|
}
|
|
|
|
$detail->price = $sku_price[0]['score'] . '积分';
|
|
if ($sku_price[0]['price'] > 0) {
|
|
$detail->price .= '+￥' . $sku_price[0]['price'];
|
|
}
|
|
$detail->sku_price = $sku_price;
|
|
$detail->sales = array_sum(array_column($sku_price, 'sales'));
|
|
$detail->stock = array_sum(array_column($sku_price, 'stock'));
|
|
|
|
return $detail;
|
|
}
|
|
}
|
|
|