zhongshen_project/addon/store/model/StoreGoods.php

<?php
/**
 * Niushop商城系统 - 团队十年电商经验汇集巨献!
 * =========================================================
 * Copy right 2019-2029 杭州牛之云科技有限公司, 保留所有权利。
 * ----------------------------------------------
 * 官方网址: https://www.niushop.com
 * =========================================================
 */

namespace addon\store\model;

use app\model\BaseModel;

class StoreGoods extends BaseModel
{
    /**
     * 商品编辑之后
     */
    public function goodsEditAfter($goods_id, $site_id)
    {

//        $store_list = model('store')->getList([ [ 'site_id', '=', $site_id ] ], 'store_id');
//        if (!empty($store_list)) {
//            $goods_sku = model('goods_sku')->getColumn([ [ 'goods_id', '=', $goods_id ] ], 'sku_id');
//            model('store_goods_sku')->startTrans();
//            try {
//                foreach ($store_list as $v) {
//                    $store_id = $v[ 'store_id' ];
//                    $store_goods_sku = model('store_goods_sku')->getColumn([ [ 'store_id', '=', $store_id ], [ 'goods_id', '=', $goods_id ] ], 'sku_id');
//                    if (!empty($store_goods_sku)) {
//
//                        model('store_goods_sku')->delete([ [ 'store_id', '=', $store_id ], [ 'goods_id', '=', $goods_id ], [ 'sku_id', 'not in', $goods_sku ] ]);
//                        $stock = model('store_goods_sku')->getSum([ [ 'store_id', '=', $store_id ], [ 'goods_id', '=', $goods_id ] ], 'stock');
//                        model('store_goods')->update([ 'stock' => $stock ], [ [ 'store_id', '=', $store_id ], [ 'goods_id', '=', $goods_id ] ]);
//                    }
//                }
//
//                model('store_goods_sku')->commit();
        return $this->success();
//            } catch (\Exception $e) {
//                model('store_goods_sku')->rollback();
//                return $this->error('', $e->getMessage());
//            }
//        }
    }

    /**
     * 门店详情
     * @param $condition
     * @param string $fields
     * @return array
     */
    public function getStoreGoodsInfo($condition, $fields = '*')
    {
        $info = model('store_goods')->getInfo($condition, $fields);
        if (!empty($info)) {
            if (isset($info[ 'stock' ])) {
                $info[ 'stock' ] = numberFormat($info[ 'stock' ]);
            }
            if (isset($info[ 'sale_num' ])) {
                $info[ 'sale_num' ] = numberFormat($info[ 'sale_num' ]);
            }
            if (isset($info[ 'real_stock' ])) {
                $info[ 'real_stock' ] = numberFormat($info[ 'real_stock' ]);
            }
        }
        return $this->success($info);
    }

    /**
     * 获取门店商品列表
     * @param array $condition
     * @param string $field
     * @param string $order
     * @param string $limit
     */
    public function getStoreGoodsList($condition = [], $field = '*', $order = '', $limit = null)
    {
        $list = model('store_goods')->getList($condition, $field, $order, '', '', '', $limit);
        foreach ($list as &$v) {
            $v[ 'store_goods_skus' ] = model('store_goods_sku')->getList([
                [ 'store_id', '=', $v[ 'store_id' ] ],
                [ 'goods_id', '=', $v[ 'goods_id' ] ]
            ], 'sku_id,goods_id,stock,sale_num');

            if (isset($v[ 'stock' ])) {
                $v[ 'stock' ] = numberFormat($v[ 'stock' ]);
            }
            if (isset($v[ 'sale_num' ])) {
                $v[ 'sale_num' ] = numberFormat($v[ 'sale_num' ]);
            }
            if (isset($v[ 'real_stock' ])) {
                $v[ 'real_stock' ] = numberFormat($v[ 'real_stock' ]);
            }
        }
        return $this->success($list);
    }

}