124 lines
5.3 KiB
PHP
124 lines
5.3 KiB
PHP
<?php
|
|
/**
|
|
* ThinkShop商城系统 - 团队十年电商经验汇集巨献!
|
|
* =========================================================
|
|
* Copy right 2019-2029 成都云之牛科技有限公司, 保留所有权利。
|
|
* ----------------------------------------------
|
|
* 官方网址: https://www.cdcloudshop.com
|
|
* =========================================================
|
|
*/
|
|
|
|
namespace addon\cardservice\api\controller;
|
|
|
|
use app\api\controller\BaseApi;
|
|
use app\model\goods\Goods;
|
|
use app\model\goods\GoodsService;
|
|
use app\model\web\Config as ConfigModel;
|
|
use addon\cardservice\model\ServiceGoods;
|
|
|
|
/**
|
|
* 服务
|
|
*/
|
|
class Service extends BaseApi
|
|
{
|
|
|
|
public function detail()
|
|
{
|
|
$sku_id = isset($this->params[ 'sku_id' ]) ? $this->params[ 'sku_id' ] : 0;
|
|
$goods_id = isset($this->params[ 'goods_id' ]) ? $this->params[ 'goods_id' ] : 0;
|
|
$goods = new Goods();
|
|
if (empty($sku_id) && !empty($goods_id)) {
|
|
$sku_id = $goods->getGoodsInfo([ [ 'goods_id', '=', $goods_id ] ], 'sku_id')[ 'data' ][ 'sku_id' ] ?? 0;
|
|
}
|
|
if (empty($sku_id) && empty($goods_id)) {
|
|
return $this->response($this->error('', 'REQUEST_ID'));
|
|
}
|
|
|
|
$goods_sku_detail = $goods->getGoodsSkuDetail($sku_id, $this->site_id, "")[ 'data' ];
|
|
|
|
if (empty($goods_sku_detail) || $goods_sku_detail['goods_class'] != (new ServiceGoods())->getGoodsClass()['id']) return $this->response($this->error());
|
|
|
|
$goods_sku_detail[ 'purchased_num' ] = 0; // 该商品已购数量
|
|
$res[ 'goods_sku_detail' ] = $goods_sku_detail;
|
|
|
|
// 商品服务
|
|
$goods_service = new GoodsService();
|
|
$goods_service_list = $goods_service->getServiceList([ [ 'site_id', '=', $this->site_id ], [ 'id', 'in', $res[ 'goods_sku_detail' ][ 'goods_service_ids' ] ] ], 'service_name,desc,icon');
|
|
$res[ 'goods_sku_detail' ][ 'goods_service' ] = $goods_service_list[ 'data' ];
|
|
|
|
return $this->response($this->success($res));
|
|
}
|
|
|
|
/**
|
|
* 列表信息
|
|
*/
|
|
public function page()
|
|
{
|
|
$page = isset($this->params[ 'page' ]) ? $this->params[ 'page' ] : 1;
|
|
$page_size = isset($this->params[ 'page_size' ]) ? $this->params[ 'page_size' ] : PAGE_LIST_ROWS;
|
|
$goods_id_arr = isset($this->params[ 'goods_id_arr' ]) ? $this->params[ 'goods_id_arr' ] : '';//goods_id数组
|
|
$keyword = isset($this->params[ 'keyword' ]) ? trim($this->params[ 'keyword' ]) : '';//关键词
|
|
$service_category = isset($this->params[ 'service_category' ]) ? $this->params[ 'service_category' ] : 0;//分类
|
|
$is_free_shipping = isset($this->params[ 'is_free_shipping' ]) ? $this->params[ 'is_free_shipping' ] : 0;//是否免邮
|
|
$order = isset($this->params[ 'order' ]) ? $this->params[ 'order' ] : "";//排序（综合、销量、价格）
|
|
$sort = isset($this->params[ 'sort' ]) ? $this->params[ 'sort' ] : "";//升序、降序
|
|
|
|
$condition = [];
|
|
$condition[] = [ 'gs.site_id', '=', $this->site_id ];
|
|
$condition[] = [ 'g.goods_class', '=', (new ServiceGoods())->getGoodsClass()['id'] ];
|
|
|
|
if (!empty($goods_id_arr)) {
|
|
$condition[] = [ 'gs.goods_id', 'in', $goods_id_arr ];
|
|
}
|
|
if (!empty($service_category)) {
|
|
$condition[] = [ 'g.service_category', 'like', '%,'.$service_category.',%' ];
|
|
}
|
|
|
|
if (!empty($keyword)) {
|
|
$condition[] = [ 'g.goods_name|gs.sku_name|gs.keywords', 'like', '%' . $keyword . '%' ];
|
|
}
|
|
|
|
if (!empty($is_free_shipping)) {
|
|
$condition[] = [ 'gs.is_free_shipping', '=', $is_free_shipping ];
|
|
}
|
|
|
|
// 非法参数进行过滤
|
|
if ($sort != "desc" && $sort != "asc") {
|
|
$sort = "";
|
|
}
|
|
|
|
// 非法参数进行过滤
|
|
if ($order != '') {
|
|
if ($order != "sale_num" && $order != "discount_price") {
|
|
$order = 'gs.sort';
|
|
} elseif ($order == "sale_num") {
|
|
$order = 'sale_sort';
|
|
} else {
|
|
$order = 'gs.' . $order;
|
|
}
|
|
$order_by = $order . ' ' . $sort;
|
|
} else {
|
|
|
|
$config_model = new ConfigModel();
|
|
$sort_config = $config_model->getGoodsSort($this->site_id);
|
|
$sort_config = $sort_config[ 'data' ][ 'value' ];
|
|
|
|
$order_by = 'g.sort ' . $sort_config[ 'type' ] . ',g.create_time desc';
|
|
}
|
|
|
|
$condition[] = [ 'g.goods_state', '=', 1 ];
|
|
$condition[] = [ 'g.is_delete', '=', 0 ];
|
|
$alias = 'gs';
|
|
|
|
$field = 'gs.is_consume_discount,gs.discount_config,gs.discount_method,gs.member_price,gs.goods_id,gs.sort,gs.sku_id,gs.sku_name,gs.price,gs.market_price,gs.discount_price,gs.stock,(g.sale_num + g.virtual_sale) as sale_num,(gs.sale_num + gs.virtual_sale) as sale_sort,gs.sku_image,gs.goods_name,gs.site_id,gs.is_free_shipping,gs.introduction,gs.promotion_type,g.goods_image,g.promotion_addon,gs.is_virtual,g.goods_spec_format,g.recommend_way,gs.max_buy,gs.min_buy,gs.unit,gs.is_limit,gs.limit_type,g.label_name,g.stock_show,g.sale_show,g.market_price_show,g.barrage_show,g.sale_channel,g.sale_store';
|
|
$join = [
|
|
[ 'goods g', 'gs.sku_id = g.sku_id', 'inner' ]
|
|
];
|
|
|
|
$goods = new Goods();
|
|
$list = $goods->getGoodsSkuPageList($condition, $page, $page_size, $order_by, $field, $alias, $join);
|
|
|
|
return $this->response($list);
|
|
}
|
|
|
|
} |