zhongshen_project/addon/cashier/storeapi/controller/Goods.php

<?php
/**
 * Niushop商城系统 - 团队十年电商经验汇集巨献!
 * =========================================================
 * Copy right 2019-2029 上海牛之云网络科技有限公司, 保留所有权利。
 * ----------------------------------------------
 * 官方网址: https://www.niushop.com
 * 这不是一个自由软件！您只能在不用于商业目的的前提下对程序代码进行修改和使用。
 * 任何企业和个人不允许对程序代码以任何形式任何目的再发布。
 * =========================================================
 */

namespace addon\cashier\storeapi\controller;

use addon\weighgoods\model\WeighGoods as WeighGoodsModel;
use app\model\goods\Goods as GoodsModel;
use app\model\goods\GoodsCategory;
use app\model\storegoods\StoreGoods as StoreGoodsModel;
use app\storeapi\controller\BaseStoreApi;
use think\facade\Db;

/**
 * 活动管理控制器
 * Class Activity
 * @package addon\shop\storeapi\controller
 */
class Goods extends BaseStoreApi
{
    /**
     * 获取商品分类的组织
     * @return false|string
     */
    public function category()
    {
        $level = $this->params[ 'level' ] ?? 1;
        $service_category_model = new GoodsCategory();
        $condition = [
            [ 'is_show', '=', 0 ],
            [ 'level', '<=', $level ],
            [ 'site_id', '=', $this->site_id ]
        ];
        $list = $service_category_model->getCategoryTree($condition, 'pid,category_id,category_name,image,level', 'sort asc,category_id desc');

        return $this->response($list);
    }

    public function page()
    {
        $page_index = $this->params[ 'page' ] ?? 1;
        $page_size = 10;
        $page_size = $this->params[ 'page_size' ] ?? PAGE_LIST_ROWS;
        $goods_category = $this->params[ 'category' ] ?? 'all';
        $search_text = $this->params[ 'search_text' ] ?? '';
        $goods_class = $this->params[ 'goods_class' ] ?? 'all';
        $status = $this->params[ 'status' ] ?? 1;
        $sku_no = $this->params[ 'sku_no' ] ?? '';
        $start_price = $this->params[ 'start_price' ] ?? 0;
        $end_price = $this->params[ 'end_price' ] ?? 0;

        $model = new GoodsModel();
        $condition = [
            [ 'g.site_id', '=', $this->site_id ],
            [ 'g.is_delete', '=', 0 ],
            [ 'g.goods_state', '=', 1 ],
            [ 'g.sale_store', 'like', [ '%all%', '%,' . $this->store_id . ',%' ], 'or' ],
            [ '', 'exp', Db::raw("(g.sale_channel = 'all' OR g.sale_channel = 'offline')") ]
        ];

        if ($goods_class !== 'all') {
            $condition[] = [ 'g.goods_class', 'in', $goods_class ];
        } else {
            $condition[] = [ 'g.goods_class', 'in', '1,4,5,6' ];
        }

        if ($goods_category != 'all') $condition[] = [ 'g.category_id', 'like', "%,{$goods_category},%" ];

        if (!empty($search_text)) $condition[] = [ 'g.goods_name', 'like', "%{$search_text}%" ];

        if ($status !== 'all') {
            $condition[] = [ 'sg1.status', '=', $status ];
        }

        if (!empty($sku_no)) {
            $goods_sku_list = $model->getGoodsSkuList([ [ 'sku_no', 'like', '%' . $sku_no . '%' ] ], 'goods_id')[ 'data' ];
            $goods_id_arr = array_unique(array_column($goods_sku_list, 'goods_id'));
            $condition[] = [ 'g.goods_id', 'in', $goods_id_arr ];
        }

        if (!empty($start_price)) {
            $condition[] = [ 'g.price', '>=', $start_price ];
        }
        if (!empty($end_price)) {
            $condition[] = [ 'g.price', '<=', $end_price ];
        }

        $field = 'g.goods_id,g.goods_name,g.goods_class,g.goods_class_name,g.introduction,g.goods_image,g.goods_state,g.sku_id,g.price,gs.discount_price,g.goods_spec_format,g.is_unify_price, 
        IFNULL(IF(g.is_unify_price = 1,g.price,sg1.price), g.price) as price, IFNULL(IF(g.is_unify_price = 1,gs.discount_price,sg1.price), gs.discount_price) as discount_price,
    IFNULL(sg1.price, 0) as store_price,IFNULL(sg1.status, 0) as store_status';
        $join = [
            [ 'goods_sku gs', 'gs.sku_id = g.sku_id', 'left' ],
            [ 'store_goods sg1', 'g.goods_id=sg1.goods_id and sg1.store_id=' . $this->store_id, 'left' ],
        ];
        //todo  这部分可以封装
        $stock_store_id = ( new \app\model\store\Store() )->getStoreStockTypeStoreId([ 'store_id' => $this->store_id ])[ 'data' ] ?? 0;
        if ($stock_store_id == $this->store_id) {
            $field .= ', IFNULL(sg1.stock, 0) as stock';
        } else {
            $join[] = [ 'store_goods sg2', 'g.goods_id = sg2.goods_id and sg2.store_id=' . $stock_store_id, 'left' ];
            $field .= ', IFNULL(sg2.stock, 0) as stock';
        }
        
        // $total_count = $model->getGoodsTotalCount($condition , $field, 'g', $join);
         
        $data = $model->getGoodsPageList($condition, $page_index, $page_size, 'g.sort asc,g.create_time desc', $field, 'g', $join);
        // $total_num = $data['count'];
        // $data['total_num'] = $total_num;

        if($data['data']){
            $total_count = $data['data']['count'];
            if($total_count>36){
                $page_size = ceil($total_count/4);
                $data = $model->getGoodsPageList($condition, $page_index, $page_size, 'g.sort asc,g.create_time desc', $field, 'g', $join);
            }
        }
        return $this->response($data);
    }

    /**
     * 商品详情
     * @return false|string
     */
    public function detail()
    {
        $goods_id = $this->params[ 'goods_id' ] ?? 0;
        $goods_model = new GoodsModel();
        $field = 'g.goods_id, g.goods_name, g.introduction,g.goods_class,g.is_virtual, g.goods_class_name, g.goods_image, g.goods_state, g.sku_id, g.price, g.unit, g.cost_price, g.category_id, g.brand_name,g.is_unify_price,
         sg1.price as store_price, sg1.cost_price as store_cost_price, sg1.status as store_status';

        $join = [
            [ 'store_goods sg1', 'g.goods_id=sg1.goods_id and sg1.store_id=' . $this->store_id, 'left' ],
        ];

        //todo  这部分可以封装
        $stock_store_id = ( new \app\model\store\Store() )->getStoreStockTypeStoreId([ 'store_id' => $this->store_id ])[ 'data' ] ?? 0;
        if ($stock_store_id == $this->store_id) {
            $field .= ',sg1.stock';
        } else {
            $join[] = [ 'store_goods sg2', 'g.goods_id = sg2.goods_id and sg2.store_id=' . $stock_store_id, 'left' ];
            $field .= ', sg2.stock';
        }
        $condition = [
            [ 'g.site_id', '=', $this->site_id ],
            [ 'g.is_delete', '=', 0 ],
            [ 'g.goods_state', '=', 1 ],
            [ 'g.goods_id', '=', $goods_id ],
            [ 'g.sale_store', 'like', [ '%all%', '%,' . $this->store_id . ',%' ], 'or' ],
            [ '', 'exp', Db::raw("(g.sale_channel = 'all' OR g.sale_channel = 'offline')") ]
        ];
        $goods_info = $goods_model->getGoodsInfo($condition, $field, 'g', $join)[ 'data' ];

        if (empty($goods_info)) return $this->response($goods_model->error(null, '商品信息缺失'));

        //查询商品规格
        $sku_filed = 'sku.sku_id,sku.sku_name,sku.sku_no,sku.price,sku.discount_price,sku.cost_price,sku.sku_image,sku.sku_images,sku.spec_name,sku.unit,
            IF(sku.is_unify_price = 1,sku.discount_price,sgs1.price) as store_price, sgs1.cost_price as store_cost_price, sgs1.status as store_status';
        $join = [
            [ 'store_goods_sku sgs1', 'sku.sku_id=sgs1.sku_id and sgs1.store_id=' . $this->store_id, 'left' ],
        ];

        if ($stock_store_id == $this->store_id) {
            $sku_filed .= ', sgs1.stock';
        } else {
            $join[] = [ 'store_goods_sku sgs2', 'sku.sku_id = sgs2.sku_id and sgs2.store_id=' . $stock_store_id, 'left' ];
            $sku_filed .= ', sgs2.stock';
        }
        $goods_info[ 'sku_list' ] = $goods_model->getGoodsSkuList([ [ 'sku.goods_id', '=', $goods_id ], [ 'sku.site_id', '=', $this->site_id ] ], $sku_filed, 'sku.sku_id asc', 0, 'sku', $join)[ 'data' ];

        return $this->response($goods_model->success($goods_info));
    }

    /**
     * 上下架
     */
    public function setStatus()
    {
        $goods_id = $this->params[ 'goods_id' ] ?? 0;
        $status = $this->params[ 'status' ] ?? 0;
        $model = new StoreGoodsModel();
        $res = $model->modifyGoodsState($goods_id, $status, $this->site_id, $this->store_id);
        return $this->response($res);
    }

    /**
     * 商品编辑
     */
    public function editGoods()
    {
        $goods_sku_array = isset($this->params[ 'goods_sku_list' ]) ? json_decode($this->params[ 'goods_sku_list' ], true) : [];
        $model = new StoreGoodsModel();
        $res = $model->editStoreGoods($goods_sku_array, $this->site_id, $this->store_id, $this->uid);
        return $this->response($res);
    }

    /**
     * 获取商品规格
     */
    public function skuList()
    {
        $goods_id = $this->params[ 'goods_id' ] ?? 0;

        $sku_filed = 'sku.goods_id,sku.sku_id,sku.sku_name,sku.goods_name,sku.sku_no,sku.sku_image,sku.sku_images,sku.spec_name,sku.goods_spec_format,sku.unit,IFNULL(IF(g.is_unify_price = 1,sku.price,sgs.price), sku.price) as price,g.goods_class';
        $join = [
            [ 'goods g', 'sku.goods_id=g.goods_id', 'inner' ],
            [ 'store_goods_sku sgs', 'sku.sku_id=sgs.sku_id and sgs.store_id=' . $this->store_id, 'inner' ],
        ];
        $stock_store_id = ( new \app\model\store\Store() )->getStoreStockTypeStoreId([ 'store_id' => $this->store_id ])[ 'data' ] ?? 0;
        if ($stock_store_id == $this->store_id) {
            $sku_filed .= ', IFNULL(sgs.stock, 0) as stock';
        } else {
            $join[] = [ 'store_goods_sku sgs2', 'sku.sku_id = sgs2.sku_id and sgs2.store_id=' . $stock_store_id, 'left' ];
            $sku_filed .= ', IFNULL(sgs2.stock, 0) as stock';
        }
        $goods_model = new GoodsModel();
        $sku_list = $goods_model->getGoodsSkuList([ [ 'sku.goods_id', '=', $goods_id ], [ 'sku.site_id', '=', $this->site_id ] ], $sku_filed, 'sku.sku_id asc', 0, 'sku', $join)[ 'data' ];
        return $this->response($this->success($sku_list));
    }

    /**
     * 查询sku信息
     * @return false|string
     */
    public function skuInfo()
    {
        $sku_id = $this->params[ 'sku_id' ] ?? 0;
        $sku_no = $this->params[ 'sku_no' ] ?? '';

        $condition = [
            [ 'sku.site_id', '=', $this->site_id ],
            [ 'sku.is_delete', '=', 0 ]
        ];
        if ($sku_id) $condition[] = [ 'sku.sku_id', '=', $sku_id ];

        $weigh_int = '0'; // 称重个位数
        $weigh_decimal = '0'; // 称重小数点位数

        // 检测是否存在称重商品插件
        if (!empty($sku_no)) {
            if (addon_is_exit('weighgoods') == 1) {
                $weigh_goods_model = new WeighGoodsModel();
                $weigh_config = $weigh_goods_model->getWeighConfig($this->site_id)[ 'data' ][ 'value' ];
                $prefix_len = strlen($weigh_config[ 'prefix' ]); // 标识码长度
                $prefix = substr($sku_no, 0, $prefix_len); // 标识码，区分电子秤

                // 检测是否为电子秤条码规则
                if ($prefix == $weigh_config[ 'prefix' ]) {
                    $goods_code = substr($sku_no, $prefix_len, $weigh_config[ 'goods_code' ]);// 商品编码位数
                    $weigh_int = substr($sku_no, $prefix_len + $weigh_config[ 'goods_code' ], $weigh_config[ 'weigh_int' ]); // 重量个位数
                    $weigh_decimal = substr($sku_no, $prefix_len + $weigh_config[ 'goods_code' ] + $weigh_config[ 'weigh_int' ], $weigh_config[ 'weigh_decimal' ]); // 重量小数点位数
                    $sku_no = $goods_code;
                }
            }
            $condition[] = [ 'sku.sku_no', '=', $sku_no ];
        }

        $sku_filed = 'g.goods_class,sku.goods_id,sku.sku_id,sku.sku_name,sku.goods_name,sku.sku_no,sku.sku_image,sku.sku_images,sku.spec_name,sku.goods_spec_format,sku.unit,IFNULL(IF(g.is_unify_price = 1,sku.price,sgs.price), sku.price) as price,sku.cost_price';
        $join = [
            [ 'goods g', 'sku.goods_id=g.goods_id', 'inner' ],
            [ 'store_goods_sku sgs', 'sku.sku_id=sgs.sku_id and sgs.store_id=' . $this->store_id, 'inner' ],
        ];
        $stock_store_id = ( new \app\model\store\Store() )->getStoreStockTypeStoreId([ 'store_id' => $this->store_id ])[ 'data' ] ?? 0;
        if ($stock_store_id == $this->store_id) {
            $sku_filed .= ', IFNULL(sgs.stock, 0) as stock, IFNULL(sgs.real_stock, 0) as real_stock';
        } else {
            $join[] = [ 'store_goods_sku sgs2', 'sku.sku_id = sgs2.sku_id and sgs2.store_id=' . $stock_store_id, 'left' ];
            $sku_filed .= ', IFNULL(sgs2.stock, 0) as stock, IFNULL(sgs2.real_stock, 0) as real_stock';
        }
        $goods_model = new GoodsModel();
        $sku_info = $goods_model->getGoodsSkuInfo($condition, $sku_filed, 'sku', $join);
        if (!empty($sku_info[ 'data' ])) {
            $sku_info[ 'data' ][ 'weigh' ] = numberFormat($weigh_int) . '.' . numberFormat($weigh_decimal);
        }
        return $this->response($sku_info);
    }

}