Goods.php
3.7 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
<?php
namespace addons\litestore\controller\api;
use app\common\controller\Api;
use addons\litestore\model\Wxlitestoregoods;
use addons\litestore\model\Litestoregoodsspec;
//http://192.168.123.83/addons/litestore/api.goods/detail
class Goods extends Api
{
protected $noNeedLogin = ['*'];
public function _initialize()
{
parent::_initialize();
}
public function detail()
{
$goods_id = $this->request->request('goods_id');
// 商品详情
$detail = Wxlitestoregoods::detail($goods_id);
$imgs=[];
foreach (explode(",",$detail['images']) as $index => $item) {
$imgs[] = cdnurl($item, true);
}
$detail['imgs_url'] = $imgs;
if (!$detail || $detail['goods_status'] !== '10') {
$this->error('很抱歉，商品信息不存在或已下架');
}
// 规格信息
$specData = $detail['spec_type'] === '20' ? $detail->getManySpecData($detail['spec_rel'], $detail['spec']) : null;
// 这里对规格的img格式化
if($specData!=null){
foreach($specData['spec_list'] as $index => $item){
$specData['spec_list'][$index]["form"]['imgshow'] = $specData['spec_list'][$index]["form"]['spec_image']==='' ? null:cdnurl($specData['spec_list'][$index]["form"]['spec_image'], true);
}
}
$this->success('', [
'detail' => $detail,
'specData' => $specData
]);
}
public function category_list(){
$categoryid = $this->request->request('id');
$page = $this->request->request('page');
$sortType = $this->request->request('types');
$rename = $this->request->request('name');
// 筛选条件
$filter = [];
if($categoryid==-1){
$filter['goods_name'] = ['like', '%' . trim($rename) . '%'];
}else{
$filter['category_id'] = $categoryid;
}
$filter['goods_status'] = '10';
$filter['is_delete'] = '0';
// 排序规则
$sort = [];
if ($sortType === 'normal') {
$sort = ['goods_sort'=> 'desc', 'goods_id' => 'desc'];
} elseif ($sortType === 'sales') {
$sort = ['goods_sales' => 'desc'];
} elseif ($sortType === 'price') {
$sort = ['goods_min_price' => 'asc'];
}
// 商品表名称
$model_temp = new Wxlitestoregoods();
$tableName = $model_temp->getTable();
// 多规格商品 最高价与最低价
$GoodsSpec = new Litestoregoodsspec();
$minPriceSql = $GoodsSpec->field(['MIN(goods_price)'])
->where('goods_id', 'EXP', "= `$tableName`.`goods_id`")->buildSql();
$maxPriceSql = $GoodsSpec->field(['MAX(goods_price)'])
->where('goods_id', 'EXP', "= `$tableName`.`goods_id`")->buildSql();
$listdata = $model_temp->field(['*', '(sales_initial + sales_actual) as goods_sales',
"$minPriceSql AS goods_min_price",
"$maxPriceSql AS goods_max_price"
])->with(['spec'])->where($filter)->order($sort)
->paginate(5, false, [ 'page' => $page ]);
$blistdatarList = [];
foreach ($listdata as $index => $item) {
$blistdatarList[] = ['image' => cdnurl(explode(",",$item['images'])[0], true), 'goods_name' => $item['goods_name'],
'id'=> $item['goods_id'],'goods_min_price'=>$item['goods_min_price'],'goods_max_price'=>$item['goods_max_price'],'goods_sales'=>$item['goods_sales']];
}
$pagedata = $listdata;
$this->success('', [
'listdata' => $blistdatarList,
'pagedata' => $pagedata,
]);
}
}