BuyService.php 61.8 KB
Newer Older
D
v1.2.0  
devil_gong 已提交
1 2 3 4
<?php
// +----------------------------------------------------------------------
// | ShopXO 国内领先企业级B2C免费开源电商系统
// +----------------------------------------------------------------------
D
devil_gong 已提交
5
// | Copyright (c) 2011~2019 http://shopxo.net All rights reserved.
D
v1.2.0  
devil_gong 已提交
6 7 8 9 10 11 12 13
// +----------------------------------------------------------------------
// | Licensed ( http://www.apache.org/licenses/LICENSE-2.0 )
// +----------------------------------------------------------------------
// | Author: Devil
// +----------------------------------------------------------------------
namespace app\service;

use think\Db;
D
devil_gong 已提交
14
use think\facade\Hook;
15 16 17
use app\service\GoodsService;
use app\service\UserService;
use app\service\ResourcesService;
D
devil_gong 已提交
18
use app\service\ConfigService;
D
v1.2.0  
devil_gong 已提交
19 20 21 22 23 24 25 26 27 28 29

/**
 * 购买服务层
 * @author   Devil
 * @blog     http://gong.gg/
 * @version  0.0.1
 * @datetime 2016-12-01T21:51:08+0800
 */
class BuyService
{
    /**
D
devil 已提交
30
     * 购物车添加/更新
D
v1.2.0  
devil_gong 已提交
31 32 33 34 35 36 37
     * @author   Devil
     * @blog    http://gong.gg/
     * @version 1.0.0
     * @date    2018-08-29
     * @desc    description
     * @param   [array]          $params [输入参数]
     */
D
devil 已提交
38
    public static function CartSave($params = [])
D
v1.2.0  
devil_gong 已提交
39 40 41 42 43 44 45 46 47 48 49 50 51
    {
        // 请求参数
        $p = [
            [
                'checked_type'      => 'empty',
                'key_name'          => 'goods_id',
                'error_msg'         => '商品id有误',
            ],
            [
                'checked_type'      => 'empty',
                'key_name'          => 'stock',
                'error_msg'         => '购买数量有误',
            ],
D
devil_gong 已提交
52 53 54 55 56 57
            [
                'checked_type'      => 'min',
                'key_name'          => 'stock',
                'checked_data'      => 1,
                'error_msg'         => '购买数量有误',
            ],
D
v1.2.0  
devil_gong 已提交
58 59 60 61 62 63 64 65 66 67 68 69
            [
                'checked_type'      => 'empty',
                'key_name'          => 'user',
                'error_msg'         => '用户信息有误',
            ],
        ];
        $ret = ParamsChecked($params, $p);
        if($ret !== true)
        {
            return DataReturn($ret, -1);
        }

70 71 72 73 74 75 76
        // 查询用户状态是否正常
        $ret = UserService::UserStatusCheck('id', $params['user']['id']);
        if($ret['code'] != 0)
        {
            return $ret;
        }

D
v1.2.0  
devil_gong 已提交
77 78 79 80 81 82 83 84 85
        // 获取商品
        $goods_id = intval($params['goods_id']);
        $goods = Db::name('Goods')->where(['id'=>$goods_id, 'is_shelves'=>1, 'is_delete_time'=>0])->find();
        if(empty($goods))
        {
            return DataReturn('商品不存在或已删除', -2);
        }

        // 规格处理
86
        $spec = self::GoodsSpecificationsHandle($params);
D
v1.2.0  
devil_gong 已提交
87 88 89 90 91 92 93 94

        // 获取商品基础信息
        $goods_base = GoodsService::GoodsSpecDetail(['id'=>$goods_id, 'spec'=>$spec]);
        if($goods_base['code'] != 0)
        {
            return $goods_base;
        }

D
devil_gong 已提交
95 96 97 98 99 100 101 102 103 104 105
        // 获取商品规格图片
        if(!empty($spec))
        {
            $images = self::BuyGoodsSpecImages($goods_id, $spec);
            if(!empty($images))
            {
                $goods['images'] = $images;
                $goods['images_old'] = ResourcesService::AttachmentPathViewHandle($images);
            }
        }

106 107 108 109 110 111 112 113 114
        // 数量
        $stock = ($goods['buy_max_number'] > 0 && $params['stock'] > $goods['buy_max_number']) ? $goods['buy_max_number'] : $params['stock'];

        // 库存
        if($stock > $goods['inventory'])
        {
            return DataReturn('库存不足', -1);
        }

D
v1.2.0  
devil_gong 已提交
115 116 117 118 119 120
        // 添加购物车
        $data = [
            'user_id'       => $params['user']['id'],
            'goods_id'      => $goods_id,
            'title'         => $goods['title'],
            'images'        => $goods['images'],
D
devil_gong 已提交
121 122
            'original_price'=> $goods_base['data']['spec_base']['original_price'],
            'price'         => $goods_base['data']['spec_base']['price'],
123
            'stock'         => $stock,
D
v1.2.0  
devil_gong 已提交
124 125 126 127 128 129 130 131 132 133 134
            'spec'          => empty($spec) ? '' : json_encode($spec),
        ];

        // 存在则更新
        $where = ['user_id'=>$data['user_id'], 'goods_id'=>$data['goods_id'], 'spec'=>$data['spec']];
        $temp = Db::name('Cart')->where($where)->find();
        if(empty($temp))
        {
            $data['add_time'] = time();
            if(Db::name('Cart')->insertGetId($data) > 0)
            {
135
                return DataReturn('加入成功', 0, self::UserCartTotal($params));
D
v1.2.0  
devil_gong 已提交
136 137 138 139 140 141 142 143
            }
        } else {
            $data['upd_time'] = time();
            $data['stock'] += $temp['stock'];
            if($data['stock'] > $goods['inventory'])
            {
                $data['stock'] = $goods['inventory'];
            }
144 145 146 147
            if($goods['buy_max_number'] > 0 && $data['stock'] > $goods['buy_max_number'])
            {
                $data['stock'] = $goods['buy_max_number'];
            }
D
v1.2.0  
devil_gong 已提交
148 149
            if(Db::name('Cart')->where($where)->update($data))
            {
150
                return DataReturn('加入成功', 0, self::UserCartTotal($params));
D
v1.2.0  
devil_gong 已提交
151 152 153 154 155 156 157 158 159 160 161 162 163 164 165
            }
        }
        
        return DataReturn('加入失败', -100);
    }

    /**
     * 商品规格解析
     * @author   Devil
     * @blog    http://gong.gg/
     * @version 1.0.0
     * @date    2018-09-21
     * @desc    description
     * @param   [array]          $params [输入参数]
     */
D
devil 已提交
166
    public static function GoodsSpecificationsHandle($params = [])
D
v1.2.0  
devil_gong 已提交
167 168 169 170 171 172
    {
        $spec = '';
        if(!empty($params['spec']))
        {
            if(!is_array($params['spec']))
            {
G
gongfuxiang 已提交
173
                $spec = json_decode(htmlspecialchars_decode($params['spec']), true);
D
v1.2.0  
devil_gong 已提交
174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189
            } else {
                $spec = $params['spec'];
            }
        }
        return empty($spec) ? '' : $spec;
    }

    /**
     * 获取购物车列表
     * @author   Devil
     * @blog    http://gong.gg/
     * @version 1.0.0
     * @date    2018-08-29
     * @desc    description
     * @param   [array]          $params [输入参数]
     */
190
    public static function CartList($params = [])
D
v1.2.0  
devil_gong 已提交
191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208
    {
        // 请求参数
        $p = [
            [
                'checked_type'      => 'empty',
                'key_name'          => 'user',
                'error_msg'         => '用户信息有误',
            ],
        ];
        $ret = ParamsChecked($params, $p);
        if($ret !== true)
        {
            return DataReturn($ret, -1);
        }

        $where = (!empty($params['where']) && is_array($params['where'])) ? $params['where'] : [];
        $where['c.user_id'] = $params['user']['id'];

D
devil_gong 已提交
209
        $field = 'c.*, g.inventory_unit, g.is_shelves, g.is_delete_time, g.buy_min_number, g.buy_max_number, g.model';
D
devil_gong 已提交
210
        $data = Db::name('Cart')->alias('c')->join(['__GOODS__'=>'g'], 'g.id=c.goods_id')->where($where)->field($field)->order('c.id desc')->select();
D
v1.2.0  
devil_gong 已提交
211 212 213 214 215 216 217 218 219 220 221

        // 数据处理
        if(!empty($data))
        {
            foreach($data as &$v)
            {
                // 规格
                $v['spec'] = empty($v['spec']) ? null : json_decode($v['spec'], true);

                // 获取商品基础信息
                $goods_base = GoodsService::GoodsSpecDetail(['id'=>$v['goods_id'], 'spec'=>$v['spec']]);
D
Devil 已提交
222
                $v['is_invalid'] = 0;
D
v1.2.0  
devil_gong 已提交
223 224
                if($goods_base['code'] == 0)
                {
D
devil_gong 已提交
225 226 227 228 229 230
                    $v['inventory'] = $goods_base['data']['spec_base']['inventory'];
                    $v['price'] = (float) $goods_base['data']['spec_base']['price'];
                    $v['original_price'] = (float) $goods_base['data']['spec_base']['original_price'];
                    $v['spec_weight'] = $goods_base['data']['spec_base']['weight'];
                    $v['spec_coding'] = $goods_base['data']['spec_base']['coding'];
                    $v['spec_barcode'] = $goods_base['data']['spec_base']['barcode'];
D
devil_gong 已提交
231
                    $v['extends'] = $goods_base['data']['spec_base']['extends'];
D
v1.2.0  
devil_gong 已提交
232
                } else {
D
Devil 已提交
233 234 235 236 237
                    $v['is_invalid'] = 1;
                    $v['inventory'] = 0;
                    $v['spec_weight'] = 0;
                    $v['spec_coding'] = '';
                    $v['spec_barcode'] = '';
D
devil_gong 已提交
238
                    $v['extends'] = '';
D
v1.2.0  
devil_gong 已提交
239 240 241 242 243
                }

                // 基础信息
                $v['goods_url'] = MyUrl('index/goods/index', ['id'=>$v['goods_id']]);
                $v['images_old'] = $v['images'];
244
                $v['images'] = ResourcesService::AttachmentPathViewHandle($v['images']);
245
                $v['total_price'] = $v['stock']* ((float) $v['price']);
D
v1.2.0  
devil_gong 已提交
246
                $v['buy_max_number'] = ($v['buy_max_number'] <= 0) ? $v['inventory']: $v['buy_max_number'];
D
Devil 已提交
247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265

                // 错误处理
                $v['is_error'] = 0;
                $v['error_msg'] = '';
                if($v['is_delete_time'] != 0)
                {
                    $v['is_error'] = 1;
                    $v['error_msg'] = '商品已作废';
                }
                if(empty($v['error_msg']) && $v['is_invalid'] == 1)
                {
                    $v['is_error'] = 1;
                    $v['error_msg'] = '商品已失效';
                }
                if(empty($v['error_msg']) && $v['is_shelves'] != 1)
                {
                    $v['is_error'] = 1;
                    $v['error_msg'] = '商品已下架';
                }
D
v1.2.0  
devil_gong 已提交
266 267 268 269 270 271 272 273 274 275 276 277 278 279 280
            }
        }

        return DataReturn('操作成功', 0, $data);
    }

    /**
     * 购物车删除
     * @author   Devil
     * @blog    http://gong.gg/
     * @version 1.0.0
     * @date    2018-09-14
     * @desc    description
     * @param   [array]          $params [输入参数]
     */
281
    public static function CartDelete($params = [])
D
v1.2.0  
devil_gong 已提交
282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301
    {
        // 请求参数
        $p = [
            [
                'checked_type'      => 'empty',
                'key_name'          => 'id',
                'error_msg'         => '删除数据id有误',
            ],
            [
                'checked_type'      => 'empty',
                'key_name'          => 'user',
                'error_msg'         => '用户信息有误',
            ],
        ];
        $ret = ParamsChecked($params, $p);
        if($ret !== true)
        {
            return DataReturn($ret, -1);
        }

302 303 304 305 306 307 308
        // 查询用户状态是否正常
        $ret = UserService::UserStatusCheck('id', $params['user']['id']);
        if($ret['code'] != 0)
        {
            return $ret;
        }

D
v1.2.0  
devil_gong 已提交
309 310 311 312 313 314 315
        // 删除
        $where = [
            'id'        => explode(',', $params['id']),
            'user_id'   => $params['user']['id']
        ];
        if(Db::name('Cart')->where($where)->delete())
        {
316
            return DataReturn('删除成功', 0, self::UserCartTotal($params));
D
v1.2.0  
devil_gong 已提交
317 318 319 320 321 322 323 324 325 326 327 328 329
        }
        return DataReturn('删除失败或资源不存在', -100);
    }

    /**
     * 购物车数量保存
     * @author   Devil
     * @blog    http://gong.gg/
     * @version 1.0.0
     * @date    2018-09-14
     * @desc    description
     * @param   [array]          $params [输入参数]
     */
330
    public static function CartStock($params = [])
D
v1.2.0  
devil_gong 已提交
331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348
    {
        // 请求参数
        $p = [
            [
                'checked_type'      => 'empty',
                'key_name'          => 'id',
                'error_msg'         => '数据id有误',
            ],
            [
                'checked_type'      => 'empty',
                'key_name'          => 'goods_id',
                'error_msg'         => '商品id有误',
            ],
            [
                'checked_type'      => 'empty',
                'key_name'          => 'stock',
                'error_msg'         => '购买数量有误',
            ],
D
devil_gong 已提交
349 350 351 352 353 354
            [
                'checked_type'      => 'min',
                'key_name'          => 'stock',
                'checked_data'      => 1,
                'error_msg'         => '购买数量有误',
            ],
D
v1.2.0  
devil_gong 已提交
355 356 357 358 359 360 361 362 363 364 365 366
            [
                'checked_type'      => 'empty',
                'key_name'          => 'user',
                'error_msg'         => '用户信息有误',
            ],
        ];
        $ret = ParamsChecked($params, $p);
        if($ret !== true)
        {
            return DataReturn($ret, -1);
        }

367 368 369 370 371 372 373
        // 查询用户状态是否正常
        $ret = UserService::UserStatusCheck('id', $params['user']['id']);
        if($ret['code'] != 0)
        {
            return $ret;
        }

374
        // 条件
D
v1.2.0  
devil_gong 已提交
375 376 377 378 379
        $where = [
            'id'        => intval($params['id']),
            'goods_id'  => intval($params['goods_id']),
            'user_id'   => intval($params['user']['id']),
        ];
380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399

        // 数量
        $stock = intval($params['stock']);

        // 获取购物车数据
        $cart = Db::name('Cart')->where($where)->select();
        if(empty($cart))
        {
            return DataReturn('请先加入购物车', -1);
        }
        $cart[0]['stock'] = $stock;

        // 商品校验
        $check = self::BuyGoodsCheck(['goods'=>$cart]);
        if($check['code'] != 0)
        {
            return $check;
        }

        // 更新数据
D
v1.2.0  
devil_gong 已提交
400
        $data = [
401
            'stock'     => $stock,
D
v1.2.0  
devil_gong 已提交
402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419
            'upd_time'  => time(),
        ];
        if(Db::name('Cart')->where($where)->update($data))
        {
            return DataReturn('更新成功', 0);
        }
        return DataReturn('更新失败', -100);
    }

    /**
     * 下订单 - 正常购买
     * @author   Devil
     * @blog    http://gong.gg/
     * @version 1.0.0
     * @date    2018-09-21
     * @desc    description
     * @param   [array]          $params [输入参数]
     */
420
    public static function BuyGoods($params = [])
D
v1.2.0  
devil_gong 已提交
421 422 423 424 425 426 427 428
    {
        // 请求参数
        $p = [
            [
                'checked_type'      => 'empty',
                'key_name'          => 'stock',
                'error_msg'         => '购买数量有误',
            ],
D
devil_gong 已提交
429 430 431 432 433 434
            [
                'checked_type'      => 'min',
                'key_name'          => 'stock',
                'checked_data'      => 1,
                'error_msg'         => '购买数量有误',
            ],
D
v1.2.0  
devil_gong 已提交
435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463
            [
                'checked_type'      => 'empty',
                'key_name'          => 'goods_id',
                'error_msg'         => '商品id有误',
            ],
            [
                'checked_type'      => 'isset',
                'key_name'          => 'spec',
                'error_msg'         => '规格参数有误',
            ],
            [
                'checked_type'      => 'empty',
                'key_name'          => 'user',
                'error_msg'         => '用户信息有误',
            ],
        ];
        $ret = ParamsChecked($params, $p);
        if($ret !== true)
        {
            return DataReturn($ret, -1);
        }

        // 获取商品
        $p = [
            'where' => [
                'id'                => intval($params['goods_id']),
                'is_delete_time'    => 0,
                'is_shelves'        => 1,
            ],
D
devil_gong 已提交
464
            'field' => 'id, id AS goods_id, title, images, inventory_unit, buy_min_number, buy_max_number, model',
D
v1.2.0  
devil_gong 已提交
465
        ];
466 467
        $ret = GoodsService::GoodsList($p);
        if(empty($ret['data'][0]))
D
v1.2.0  
devil_gong 已提交
468 469 470 471 472
        {
            return DataReturn('资源不存在或已被删除', -10);
        }

        // 规格
473
        $ret['data'][0]['spec'] = self::GoodsSpecificationsHandle($params);
D
v1.2.0  
devil_gong 已提交
474 475

        // 获取商品基础信息
476
        $goods_base = GoodsService::GoodsSpecDetail(['id'=>$ret['data'][0]['goods_id'], 'spec'=>$ret['data'][0]['spec']]);
D
v1.2.0  
devil_gong 已提交
477 478
        if($goods_base['code'] == 0)
        {
D
devil_gong 已提交
479 480 481 482 483 484
            $ret['data'][0]['inventory'] = $goods_base['data']['spec_base']['inventory'];
            $ret['data'][0]['price'] = (float) $goods_base['data']['spec_base']['price'];
            $ret['data'][0]['original_price'] = (float) $goods_base['data']['spec_base']['original_price'];
            $ret['data'][0]['spec_weight'] = $goods_base['data']['spec_base']['weight'];
            $ret['data'][0]['spec_coding'] = $goods_base['data']['spec_base']['coding'];
            $ret['data'][0]['spec_barcode'] = $goods_base['data']['spec_base']['barcode'];
D
devil_gong 已提交
485
            $ret['data'][0]['extends'] = $goods_base['data']['spec_base']['extends'];
D
v1.2.0  
devil_gong 已提交
486 487 488 489
        } else {
            return $goods_base;
        }

D
devil_gong 已提交
490 491 492 493 494 495
        // 获取商品规格图片
        if(!empty($ret['data'][0]['spec']))
        {
            $images = self::BuyGoodsSpecImages($ret['data'][0]['goods_id'], $ret['data'][0]['spec']);
            if(!empty($images))
            {
G
gongfuxiang 已提交
496 497
                $ret['data'][0]['images'] = ResourcesService::AttachmentPathViewHandle($images);
                $ret['data'][0]['images_old'] = $images;
D
devil_gong 已提交
498 499 500
            }
        }

D
v1.2.0  
devil_gong 已提交
501
        // 数量/小计
502
        $ret['data'][0]['stock'] = $params['stock'];
503
        $ret['data'][0]['total_price'] = $params['stock']* ((float) $ret['data'][0]['price']);
D
v1.2.0  
devil_gong 已提交
504

D
devil_gong 已提交
505
        return DataReturn('操作成功', 0, $ret['data']);
D
v1.2.0  
devil_gong 已提交
506 507 508 509 510 511 512 513 514 515 516
    }

    /**
     * 下订单 - 购物车
     * @author   Devil
     * @blog    http://gong.gg/
     * @version 1.0.0
     * @date    2018-09-21
     * @desc    description
     * @param   [array]          $params [输入参数]
     */
517
    public static function BuyCart($params = [])
D
v1.2.0  
devil_gong 已提交
518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540 541 542 543
    {
        // 请求参数
        $p = [
            [
                'checked_type'      => 'empty',
                'key_name'          => 'ids',
                'error_msg'         => '购物车id有误',
            ],
            [
                'checked_type'      => 'empty',
                'key_name'          => 'user',
                'error_msg'         => '用户信息有误',
            ],
        ];
        $ret = ParamsChecked($params, $p);
        if($ret !== true)
        {
            return DataReturn($ret, -1);
        }

        // 获取购物车数据
        $params['where'] = [
            'g.is_delete_time'  => 0,
            'g.is_shelves'      => 1,
            'c.id'              => explode(',', $params['ids']),
        ];
544
        return self::CartList($params);
D
v1.2.0  
devil_gong 已提交
545 546
    }

D
devil_gong 已提交
547 548 549 550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573 574 575 576 577 578 579 580 581 582 583 584 585 586 587 588 589 590 591 592
    /**
     * 获取规格图片
     * @author  Devil
     * @blog    http://gong.gg/
     * @version 1.0.0
     * @date    2019-08-02
     * @desc    description
     * @param   [int]          $goods_id [商品id]
     * @param   [string]       $spec     [图片地址或空字符串]
     */
    public static function BuyGoodsSpecImages($goods_id, $spec)
    {
        if(!empty($spec))
        {
            $data = Db::name('GoodsSpecType')->where(['goods_id'=>$goods_id])->field('name,value')->select();
            if(!empty($data))
            {
                $spec_images = [];
                foreach($data as $v)
                {
                    if(!empty($v['value']))
                    {
                        foreach(json_decode($v['value'], true) as $vs)
                        {
                            if(!empty($vs['images']))
                            {
                                $spec_images[$v['name']][$vs['name']] = $vs['images'];
                            }
                        }
                    }
                }
                if(!empty($spec_images))
                {
                    foreach($spec as $v)
                    {
                        if(array_key_exists($v['type'], $spec_images) && array_key_exists($v['value'], $spec_images[$v['type']]))
                        {
                            return $spec_images[$v['type']][$v['value']];
                        }
                    }
                }
            }
        }
        return '';
    }

D
v1.2.0  
devil_gong 已提交
593 594 595 596 597 598 599 600
    /**
     * 下订单购物车删除
     * @author   Devil
     * @blog     http://gong.gg/
     * @version  1.0.0
     * @datetime 2018-10-12T00:42:49+0800
     * @param   [array]          $params [输入参数]
     */
601
    public static function BuyCartDelete($params = [])
D
v1.2.0  
devil_gong 已提交
602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 617
    {
        if(isset($params['buy_type']) && $params['buy_type'] == 'cart' && !empty($params['ids']))
        {
            Db::name('Cart')->where(['id'=>explode(',', $params['ids'])])->delete();
        }
    }

    /**
     * 根据购买类型获取商品列表
     * @author   Devil
     * @blog    http://gong.gg/
     * @version 1.0.0
     * @date    2018-09-26
     * @desc    description
     * @param   [array]          $params [输入参数]
     */
618
    public static function BuyTypeGoodsList($params = [])
D
v1.2.0  
devil_gong 已提交
619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 638 639 640
    {
        if(isset($params['buy_type']))
        {
            switch($params['buy_type'])
            {
                // 正常购买
                case 'goods' :
                    $ret = BuyService::BuyGoods($params);
                    break;

                // 购物车
                case 'cart' :
                    $ret = BuyService::BuyCart($params);
                    break;

                // 默认
                default :
                    $ret = DataReturn('参数有误', -1);
            }
        } else {
            $ret = DataReturn('参数有误', -1);
        }
D
devil_gong 已提交
641 642 643 644 645 646 647

        // 数据组装
        if($ret['code'] == 0)
        {
            // 商品数据
            $goods = $ret['data'];

D
devil 已提交
648 649
            // 站点模式 0销售, 2自提, 4销售+自提, 则其它正常模式
            $common_site_type = MyC('common_site_type', 0, true);
D
devil 已提交
650
            $site_model = ($common_site_type == 4) ? (isset($params['site_model']) ? intval($params['site_model']) : 0) : $common_site_type;
D
devil 已提交
651 652

            // 数据处理
D
devil_gong 已提交
653 654
            $address = null;
            $extraction_address = [];
D
devil 已提交
655 656 657

            // 站点模式 - 用户收货地址(未选择则取默认地址)
            // 销售, 销售+自提(指定为销售)
D
devil 已提交
658
            if($site_model == 0)
D
devil_gong 已提交
659
            {
D
devil 已提交
660 661 662 663 664 665 666 667 668 669 670 671 672
                $address_params = [
                    'user'  => $params['user'],
                ];
                if(!empty($params['address_id']))
                {
                    $address_params['where'] = ['id' => $params['address_id']];
                }
                $ads = UserService::UserDefaultAddress($address_params);
                if(!empty($ads['data']))
                {
                    $address = $ads['data'];
                }
            }
D
devil_gong 已提交
673

D
devil 已提交
674 675
            // 自提模式 - 自提点地址
            // 自提, 销售+自提(指定为自提)
D
devil 已提交
676
            if($site_model == 2)
D
devil 已提交
677 678 679 680 681 682 683 684 685 686
            {
                $extraction = self::SiteExtractionAddress($params);
                if(!empty($extraction['data']['data_list']))
                {
                    $extraction_address = $extraction['data']['data_list'];
                }
                if(!empty($extraction['data']['default']))
                {
                    $address = $extraction['data']['default'];
                }
D
devil_gong 已提交
687 688 689 690 691
            }

            // 商品/基础信息
            $total_price = empty($goods) ? 0 : array_sum(array_column($goods, 'total_price'));
            $base = [
D
devil_gong 已提交
692 693 694 695 696 697 698 699 700 701 702 703 704 705 706 707 708 709 710 711 712 713
                // 总价
                'total_price'           => $total_price,

                // 订单实际支付金额(已减去优惠金额, 已加上增加金额)
                'actual_price'          => $total_price,

                // 优惠金额
                'preferential_price'    => 0.00,

                // 增加金额
                'increase_price'        => 0.00,

                // 商品数量
                'goods_count'           => count($goods),

                // 规格重量总计
                'spec_weight_total'     => empty($goods) ? 0 : array_sum(array_map(function($v) {return $v['spec_weight']*$v['stock'];}, $goods)),

                // 购买总数
                'buy_count'             => empty($goods) ? 0 : array_sum(array_column($goods, 'stock')),

                // 默认地址
D
devil_gong 已提交
714 715 716 717
                'address'               => $address,

                // 自提地址列表
                'extraction_address'    => $extraction_address,
D
devil 已提交
718 719 720

                // 站点模式
                'site_model'            => $site_model,
D
devil_gong 已提交
721 722 723 724 725 726 727
            ];

            // 扩展展示数据
            // name 名称
            // price 金额
            // type 类型(0减少, 1增加)
            // tips 提示信息
D
devil_gong 已提交
728 729
            // business 业务类型(内容格式不限)
            // ext 扩展数据(内容格式不限)
D
devil_gong 已提交
730
            $extension_data = [
D
devil_gong 已提交
731
                // [
D
devil_gong 已提交
732 733 734 735 736 737
                //     'name'       => '感恩节9折',
                //     'price'      => 23,
                //     'type'       => 0,
                //     'tips'       => '-¥23元',
                //     'business'   => null,
                //     'ext'        => null,
D
devil_gong 已提交
738
                // ],
D
devil_gong 已提交
739 740 741 742 743 744 745 746
            ];

            // 返回数据
            $result = [
                'goods'             => $goods,
                'base'              => $base,
                'extension_data'    => $extension_data,
            ];
D
devil_gong 已提交
747 748 749

            // 生成订单数据处理钩子
            $hook_name = 'plugins_service_buy_handle';
D
devil_gong 已提交
750
            $ret = HookReturnHandle(Hook::listen($hook_name, [
D
devil_gong 已提交
751 752 753 754
                'hook_name'     => $hook_name,
                'is_backend'    => true,
                'params'        => &$params,
                'data'          => &$result,
D
devil_gong 已提交
755
            ]));
D
devil_gong 已提交
756 757 758 759 760
            if(isset($ret['code']) && $ret['code'] != 0)
            {
                return $ret;
            }

D
Devil 已提交
761 762 763 764 765 766
            // 返回数据再次处理,防止插件处理不够完善
            $result['base']['total_price'] = PriceNumberFormat($result['base']['total_price']);
            $result['base']['actual_price'] = PriceNumberFormat($result['base']['actual_price']);
            $result['base']['preferential_price'] = PriceNumberFormat($result['base']['preferential_price']);
            $result['base']['increase_price'] = PriceNumberFormat($result['base']['increase_price']);

D
devil_gong 已提交
767 768 769
            return DataReturn('操作成功', 0, $result);
        }

D
v1.2.0  
devil_gong 已提交
770 771 772 773 774 775 776 777 778 779 780 781
        return $ret;
    }

    /**
     * 购买商品校验
     * @author   Devil
     * @blog    http://gong.gg/
     * @version 1.0.0
     * @date    2018-09-26
     * @desc    description
     * @param   [array]          $params [输入参数]
     */
782
    public static function BuyGoodsCheck($params = [])
D
v1.2.0  
devil_gong 已提交
783 784 785 786 787 788 789 790 791 792 793 794 795 796 797 798 799 800 801
    {
        // 请求参数
        $p = [
            [
                'checked_type'      => 'empty',
                'key_name'          => 'goods',
                'error_msg'         => '商品信息有误',
            ]
        ];
        $ret = ParamsChecked($params, $p);
        if($ret !== true)
        {
            return DataReturn($ret, -1);
        }

        // 数据校验
        foreach($params['goods'] as $v)
        {
            // 获取商品信息
802 803 804 805 806
            $goods = Db::name('Goods')->field('id,title,price,is_shelves,inventory,buy_min_number,buy_max_number')->find($v['goods_id']);
            if(empty($goods))
            {
                return DataReturn('['.$v['goods_id'].']商品不存在', -1);
            }
D
v1.2.0  
devil_gong 已提交
807 808 809 810 811

            // 规格
            $goods_base = GoodsService::GoodsSpecDetail(['id'=>$v['goods_id'], 'spec'=>isset($v['spec']) ? $v['spec'] : []]);
            if($goods_base['code'] == 0)
            {
D
devil_gong 已提交
812 813
                $goods['price'] = $goods_base['data']['spec_base']['price'];
                $goods['inventory'] = $goods_base['data']['spec_base']['inventory'];
D
v1.2.0  
devil_gong 已提交
814 815 816 817 818 819 820
            } else {
                return $goods_base;
            }

            // 基础判断
            if($goods['is_shelves'] != 1)
            {
821
                return DataReturn('商品已下架['.$goods['title'].']', -1);
D
v1.2.0  
devil_gong 已提交
822 823 824
            }
            if($v['stock'] > $goods['inventory'])
            {
825
                return DataReturn('购买数量超过商品库存数量['.$goods['title'].']['.$v['stock'].'>'.$goods['inventory'].']', -1);
D
v1.2.0  
devil_gong 已提交
826 827 828
            }
            if($goods['buy_min_number'] > 1 && $v['stock'] < $goods['buy_min_number'])
            {
829
                return DataReturn('低于商品起购数量['.$goods['title'].']['.$v['stock'].'<'.$goods['buy_min_number'].']', -1);
D
v1.2.0  
devil_gong 已提交
830
            }
831
            if($goods['buy_max_number'] > 0 && $v['stock'] > $goods['buy_max_number'])
D
v1.2.0  
devil_gong 已提交
832
            {
833
                return DataReturn('超过商品限购数量['.$goods['title'].']['.$v['stock'].'>'.$goods['buy_max_number'].']', -1);
D
v1.2.0  
devil_gong 已提交
834 835 836
            }
        }

D
devil_gong 已提交
837
        return DataReturn('操作成功', 0);
D
v1.2.0  
devil_gong 已提交
838 839 840 841 842 843 844 845 846 847 848
    }

    /**
     * 订单添加
     * @author   Devil
     * @blog    http://gong.gg/
     * @version 1.0.0
     * @date    2018-09-26
     * @desc    description
     * @param   [array]          $params [输入参数]
     */
D
devil_gong 已提交
849
    public static function OrderInsert($params = [])
D
v1.2.0  
devil_gong 已提交
850
    {
D
devil_gong 已提交
851
        // 站点类型,是否开启了展示型
D
devil_gong 已提交
852 853
        $common_site_type = MyC('common_site_type', 0, true);
        if($common_site_type == 1)
D
devil_gong 已提交
854 855 856 857
        {
            return DataReturn('展示型不允许提交订单', -1);
        }

D
devil 已提交
858 859 860
        // 销售+自提, 用户自选站点类型
        $site_model = ($common_site_type == 4) ? (isset($params['site_model']) ? intval($params['site_model']) : 0) : $common_site_type;

D
v1.2.0  
devil_gong 已提交
861 862 863 864 865 866 867 868
        // 请求参数
        $p = [
            [
                'checked_type'      => 'empty',
                'key_name'          => 'user',
                'error_msg'         => '用户信息有误',
            ],
        ];
D
devil_gong 已提交
869

D
devil 已提交
870 871
        // // 销售型,自提点,销售+自提 则校验地址
        if(in_array($site_model, [0,2]))
D
devil_gong 已提交
872 873 874 875 876 877 878 879 880
        {
            $p[] = [
                'checked_type'      => 'isset',
                'key_name'          => 'address_id',
                'error_msg'         => '请选择地址',
            ];
        }

        // 非预约模式则校验支付方式
D
v1.2.0  
devil_gong 已提交
881 882 883 884 885 886 887 888 889 890 891 892 893 894
        if(MyC('common_order_is_booking', 0) != 1)
        {
            $p[] = [
                'checked_type'      => 'empty',
                'key_name'          => 'payment_id',
                'error_msg'         => '支付方式有误',
            ];
        }
        $ret = ParamsChecked($params, $p);
        if($ret !== true)
        {
            return DataReturn($ret, -1);
        }

895 896 897 898 899 900 901
        // 查询用户状态是否正常
        $ret = UserService::UserStatusCheck('id', $params['user']['id']);
        if($ret['code'] != 0)
        {
            return $ret;
        }

D
v1.2.0  
devil_gong 已提交
902
        // 清单商品
D
devil_gong 已提交
903
        $params['is_order_submit'] = 1;
D
devil_gong 已提交
904 905
        $buy = self::BuyTypeGoodsList($params);
        if(!isset($buy['code']) || $buy['code'] != 0)
D
v1.2.0  
devil_gong 已提交
906
        {
D
devil_gong 已提交
907
            return $buy;
D
v1.2.0  
devil_gong 已提交
908
        }
D
devil_gong 已提交
909
        $check = self::BuyGoodsCheck(['goods'=>$buy['data']['goods']]);
910
        if($check['code'] != 0)
D
v1.2.0  
devil_gong 已提交
911 912 913 914
        {
            return $check;
        }

D
devil 已提交
915
        // 销售型,自提点,销售+自提 地址处理
D
devil_gong 已提交
916
        $address = [];
D
devil 已提交
917
        if(in_array($site_model, [0,2]))
D
v1.2.0  
devil_gong 已提交
918
        {
D
devil_gong 已提交
919 920 921 922 923 924
            if(empty($buy['data']['base']['address']))
            {
                return DataReturn('地址有误', -1);
            } else {
                $address = $buy['data']['base']['address'];
            }
D
v1.2.0  
devil_gong 已提交
925 926
        }

D
devil_gong 已提交
927
        // 订单主信息
D
v1.2.0  
devil_gong 已提交
928 929 930
        $order = [
            'order_no'              => date('YmdHis').GetNumberCode(6),
            'user_id'               => $params['user']['id'],
D
devil_gong 已提交
931
            'user_note'             => isset($params['user_note']) ? str_replace(['"', "'"], '', strip_tags($params['user_note'])) : '',
D
v1.2.0  
devil_gong 已提交
932
            'status'                => (intval(MyC('common_order_is_booking', 0)) == 1) ? 0 : 1,
D
devil_gong 已提交
933 934 935 936
            'preferential_price'    => ($buy['data']['base']['preferential_price'] <= 0.00) ? 0.00 : $buy['data']['base']['preferential_price'],
            'increase_price'        => ($buy['data']['base']['increase_price'] <= 0.00) ? 0.00 : $buy['data']['base']['increase_price'],
            'price'                 => ($buy['data']['base']['total_price'] <= 0.00) ? 0.00 : $buy['data']['base']['total_price'],
            'total_price'           => ($buy['data']['base']['actual_price'] <= 0.00) ? 0.00 : $buy['data']['base']['actual_price'],
D
devil_gong 已提交
937
            'extension_data'        => empty($buy['data']['extension_data']) ? '' : json_encode($buy['data']['extension_data']),
D
v1.2.0  
devil_gong 已提交
938
            'payment_id'            => isset($params['payment_id']) ? intval($params['payment_id']) : 0,
G
gongfuxiang 已提交
939
            'buy_number_count'      => array_sum(array_column($buy['data']['goods'], 'stock')),
D
devil_gong 已提交
940
            'client_type'           => (APPLICATION_CLIENT_TYPE == 'pc' && IsMobile()) ? 'h5' : APPLICATION_CLIENT_TYPE,
D
devil 已提交
941
            'order_model'           => $site_model,
D
v1.2.0  
devil_gong 已提交
942 943 944 945 946 947
            'add_time'              => time(),
        ];
        if($order['status'] == 1)
        {
            $order['confirm_time'] = time();
        }
D
devil_gong 已提交
948

D
devil_gong 已提交
949 950
        // 订单添加前钩子
        $hook_name = 'plugins_service_buy_order_insert_begin';
D
devil_gong 已提交
951
        $ret = HookReturnHandle(Hook::listen($hook_name, [
D
devil_gong 已提交
952 953 954
            'hook_name'     => $hook_name,
            'is_backend'    => true,
            'order'         => &$order,
D
devil_gong 已提交
955
            'goods'         => &$buy['data']['goods'],
D
devil_gong 已提交
956 957
            'params'        => $params,
            
D
devil_gong 已提交
958
        ]));
D
devil_gong 已提交
959 960 961 962 963
        if(isset($ret['code']) && $ret['code'] != 0)
        {
            return $ret;
        }

D
v1.2.0  
devil_gong 已提交
964 965 966 967 968 969 970
        // 开始事务
        Db::startTrans();

        // 订单添加
        $order_id = Db::name('Order')->insertGetId($order);
        if($order_id > 0)
        {
D
devil_gong 已提交
971
            foreach($buy['data']['goods'] as $k=>$v)
D
v1.2.0  
devil_gong 已提交
972
            {
D
devil_gong 已提交
973
                // 添加订单详情数据,data返回自增id
D
devil_gong 已提交
974
                $detail_ret = self::OrderDetailInsert($order_id, $params['user']['id'], $v);
D
devil_gong 已提交
975
                if($detail_ret['code'] == 0)
D
v1.2.0  
devil_gong 已提交
976
                {
D
devil_gong 已提交
977 978
                    $buy['data']['goods'][$k]['id'] = $detail_ret['data'];
                } else {
D
v1.2.0  
devil_gong 已提交
979
                    Db::rollback();
D
devil_gong 已提交
980 981 982
                    return $ret;
                }

D
devil_gong 已提交
983
                // 订单模式 - 虚拟信息添加
D
devil 已提交
984
                if($site_model == 3)
D
devil_gong 已提交
985 986 987 988 989 990 991
                {
                    $ret = self::OrderFictitiousValueInsert($order_id, $detail_ret['data'], $params['user']['id'], $v['goods_id']);
                    if($ret['code'] != 0)
                    {
                        Db::rollback();
                        return $ret;
                    }
D
v1.2.0  
devil_gong 已提交
992 993
                }
            }
D
devil_gong 已提交
994

D
devil_gong 已提交
995
            // 订单模式处理
D
devil 已提交
996 997
            // 销售型模式,自提模式,销售+自提
            if(in_array($site_model, [0,2]))
D
devil_gong 已提交
998
            {
D
devil_gong 已提交
999 1000
                // 添加订单(收货|取货)地址
                if(!empty($address))
D
devil_gong 已提交
1001
                {
D
devil_gong 已提交
1002
                    $ret = self::OrderAddressInsert($order_id, $params['user']['id'], $address);
D
devil_gong 已提交
1003 1004 1005 1006 1007 1008 1009 1010
                    if($ret['code'] != 0)
                    {
                        Db::rollback();
                        return $ret;
                    }
                }

                // 自提模式 添加订单取货码
D
devil 已提交
1011
                if($site_model == 2)
D
devil_gong 已提交
1012 1013 1014 1015 1016 1017 1018
                {
                    $ret = self::OrderExtractionCcodeInsert($order_id, $params['user']['id']);
                    if($ret['code'] != 0)
                    {
                        Db::rollback();
                        return $ret;
                    }
D
devil_gong 已提交
1019 1020
                }
            }
D
v1.2.0  
devil_gong 已提交
1021 1022 1023 1024 1025 1026 1027 1028
        } else {
            Db::rollback();
            return DataReturn('订单添加失败', -1);
        }

        // 库存扣除
        if($order['status'] == 1)
        {
1029
            $ret = self::OrderInventoryDeduct(['order_id'=>$order_id, 'order_data'=>$order]);
D
v1.2.0  
devil_gong 已提交
1030 1031 1032 1033 1034 1035 1036 1037
            if($ret['code'] != 0)
            {
                // 事务回滚
                Db::rollback();
                return DataReturn($ret['msg'], -10);
            }
        }

D
devil_gong 已提交
1038 1039 1040 1041 1042 1043 1044 1045 1046 1047 1048 1049 1050 1051 1052 1053 1054 1055
        // 订单添加成功钩子
        $hook_name = 'plugins_service_buy_order_insert_end';
        $ret = HookReturnHandle(Hook::listen($hook_name, [
            'hook_name'     => $hook_name,
            'is_backend'    => true,
            'order_id'      => $order_id,
            'order'         => $order,
            'goods'         => $buy['data']['goods'],
            'address'       => $address,
            'params'        => $params,
        ]));
        if(isset($ret['code']) && $ret['code'] != 0)
        {
            // 事务回滚
            Db::rollback();
            return $ret;
        }

D
v1.2.0  
devil_gong 已提交
1056 1057 1058 1059
        // 订单提交成功
        Db::commit();

        // 删除购物车
1060
        self::BuyCartDelete($params);
D
v1.2.0  
devil_gong 已提交
1061

D
devil 已提交
1062 1063 1064
        // 获取数据库订单信息
        $order = Db::name('Order')->find($order_id);

D
devil_gong 已提交
1065 1066 1067 1068 1069 1070 1071
        // 订单添加成功钩子, 不校验返回值
        $hook_name = 'plugins_service_buy_order_insert_success';
        Hook::listen($hook_name, [
            'hook_name'     => $hook_name,
            'is_backend'    => true,
            'order_id'      => $order_id,
            'order'         => $order,
D
devil_gong 已提交
1072 1073
            'goods'         => $buy['data']['goods'],
            'address'       => $address,
D
devil_gong 已提交
1074 1075 1076
            'params'        => $params,
        ]);

D
v1.2.0  
devil_gong 已提交
1077 1078
        // 返回信息
        $result = [
D
devil_gong 已提交
1079
            'order'     => $order,
D
v1.2.0  
devil_gong 已提交
1080 1081 1082 1083 1084 1085 1086 1087 1088 1089 1090 1091 1092 1093 1094 1095 1096 1097 1098 1099 1100 1101 1102 1103 1104 1105
            'jump_url'  => MyUrl('index/order/index'),
        ];


        // 获取订单信息
        switch($order['status'])
        {
            // 预约成功
            case 0 :
                $msg = '预约成功';
                break;

            // 提交成功
            case 1 :
                $msg = '提交成功';
                $result['jump_url'] = MyUrl('index/order/pay', ['id'=>$order_id]);
                break;

            // 默认操作成功
            default :
                $msg = '操作成功';
        }

        return DataReturn($msg, 0, $result);
    }

D
devil_gong 已提交
1106 1107 1108 1109 1110 1111 1112 1113 1114 1115 1116 1117 1118 1119 1120 1121 1122 1123 1124 1125 1126 1127 1128 1129 1130 1131 1132 1133 1134 1135 1136 1137 1138
    /**
     * 订单详情添加
     * @author  Devil
     * @blog    http://gong.gg/
     * @version 1.0.0
     * @date    2019-11-20
     * @desc    description
     * @param   [int]          $order_id    [订单id]
     * @param   [int]          $user_id     [用户id]
     * @param   [array]        $detail      [商品详情数据]
     */
    private static function OrderDetailInsert($order_id, $user_id, $detail)
    {
        $data = [
            'order_id'          => $order_id,
            'user_id'           => $user_id,
            'goods_id'          => $detail['goods_id'],
            'title'             => $detail['title'],
            'images'            => $detail['images_old'],
            'original_price'    => $detail['original_price'],
            'price'             => $detail['price'],
            'total_price'       => PriceNumberFormat($detail['stock']*$detail['price']),
            'spec'              => empty($detail['spec']) ? '' : json_encode($detail['spec']),
            'spec_weight'       => empty($detail['spec_weight']) ? 0.00 : (float) $detail['spec_weight'],
            'spec_coding'       => empty($detail['spec_coding']) ? '' : $detail['spec_coding'],
            'spec_barcode'      => empty($detail['spec_barcode']) ? '' : $detail['spec_barcode'],
            'buy_number'        => intval($detail['stock']),
            'model'             => $detail['model'],
            'add_time'          => time(),
        ];

        // 订单详情添加前钩子
        $hook_name = 'plugins_service_buy_order_detail_insert_begin';
D
devil_gong 已提交
1139
        $ret = HookReturnHandle(Hook::listen($hook_name, [
D
devil_gong 已提交
1140 1141 1142 1143 1144
            'hook_name'     => $hook_name,
            'is_backend'    => true,
            'user_id'       => $user_id,
            'order_id'      => $order_id,
            'data'          => &$data,
D
devil_gong 已提交
1145
        ]));
D
devil_gong 已提交
1146 1147 1148 1149 1150 1151 1152 1153 1154 1155 1156 1157
        if(isset($ret['code']) && $ret['code'] != 0)
        {
            return $ret;
        }

        // 添加订单详情数据
        $order_detail_id = Db::name('OrderDetail')->insertGetId($data);
        if($order_detail_id > 0)
        {
            return DataReturn('添加成功', 0, $order_detail_id);
        }
        return DataReturn('订单详情添加失败', -1);
D
devil_gong 已提交
1158 1159 1160 1161 1162 1163 1164 1165 1166 1167 1168 1169 1170 1171 1172 1173 1174 1175 1176 1177 1178 1179 1180
    }

    /**
     * 订单关联自提取货码添加
     * @author  Devil
     * @blog    http://gong.gg/
     * @version 1.0.0
     * @date    2019-11-20
     * @desc    description
     * @param   [int]          $order_id            [订单id]
     * @param   [int]          $user_id             [用户id]
     */
    private static function OrderExtractionCcodeInsert($order_id, $user_id)
    {
        $data = [
            'order_id'      => $order_id,
            'user_id'       => $user_id,
            'code'          => GetNumberCode(4),
            'add_time'      => time(),
        ];

        // 订单取货码添加前钩子
        $hook_name = 'plugins_service_buy_order_extraction_code_insert_begin';
D
devil_gong 已提交
1181
        $ret = HookReturnHandle(Hook::listen($hook_name, [
D
devil_gong 已提交
1182 1183 1184 1185 1186
            'hook_name'             => $hook_name,
            'is_backend'            => true,
            'user_id'               => $user_id,
            'order_id'              => $order_id,
            'data'                  => &$data,
D
devil_gong 已提交
1187
        ]));
D
devil_gong 已提交
1188 1189 1190 1191 1192 1193 1194 1195 1196 1197 1198
        if(isset($ret['code']) && $ret['code'] != 0)
        {
            return $ret;
        }

        // 添加订单虚拟数据
        if(Db::name('OrderExtractionCode')->insertGetId($data) > 0)
        {
            return DataReturn('添加成功', 0);
        }
        return DataReturn('订单取货码添加失败', -1);
D
devil_gong 已提交
1199 1200 1201 1202 1203 1204 1205 1206 1207 1208 1209 1210 1211 1212 1213 1214 1215 1216 1217 1218 1219 1220 1221 1222 1223 1224
    }

    /**
     * 订单关联虚拟销售数据添加
     * @author  Devil
     * @blog    http://gong.gg/
     * @version 1.0.0
     * @date    2019-11-20
     * @desc    description
     * @param   [int]          $order_id            [订单id]
     * @param   [int]          $order_detail_id     [订单详情id]
     * @param   [int]          $user_id             [用户id]
     * @param   [int]          $goods_id            [商品id]
     */
    private static function OrderFictitiousValueInsert($order_id, $order_detail_id, $user_id, $goods_id)
    {
        $data = [
            'order_id'              => $order_id,
            'order_detail_id'       => $order_detail_id,
            'user_id'               => $user_id,
            'value'                 => Db::name('Goods')->where(['id'=>$goods_id])->value('fictitious_goods_value'),
            'add_time'              => time(),
        ];

        // 订单虚拟数据添加前钩子
        $hook_name = 'plugins_service_buy_order_fictitious_insert_begin';
D
devil_gong 已提交
1225
        $ret = HookReturnHandle(Hook::listen($hook_name, [
D
devil_gong 已提交
1226 1227 1228 1229 1230 1231 1232
            'hook_name'             => $hook_name,
            'is_backend'            => true,
            'user_id'               => $user_id,
            'order_id'              => $order_id,
            'order_detail_id'       => $order_detail_id,
            'goods_id'              => $goods_id,
            'data'                  => &$data,
D
devil_gong 已提交
1233
        ]));
D
devil_gong 已提交
1234 1235 1236 1237 1238 1239 1240 1241 1242 1243 1244 1245 1246 1247 1248 1249 1250 1251 1252 1253 1254 1255 1256 1257
        if(isset($ret['code']) && $ret['code'] != 0)
        {
            return $ret;
        }

        // 添加订单虚拟数据
        if(Db::name('OrderFictitiousValue')->insertGetId($data) > 0)
        {
            return DataReturn('添加成功', 0);
        }
        return DataReturn('订单虚拟信息添加失败', -1);
    }

    /**
     * 订单关联地址添加
     * @author  Devil
     * @blog    http://gong.gg/
     * @version 1.0.0
     * @date    2019-11-20
     * @desc    description
     * @param   [int]          $order_id [订单id]
     * @param   [int]          $user_id  [用户id]
     * @param   [array]        $address  [地址]
     */
D
devil_gong 已提交
1258
    private static function OrderAddressInsert($order_id, $user_id, $address)
D
devil_gong 已提交
1259
    {
D
devil 已提交
1260 1261 1262 1263 1264 1265 1266 1267 1268 1269 1270 1271 1272 1273 1274
        // 坐标处理
        if(in_array(APPLICATION_CLIENT_TYPE, config('shopxo.coordinate_transformation')))
        {
            // 坐标转换 火星(高德,谷歌,腾讯坐标) 转 百度
            if(isset($address['lng']) && isset($address['lat']) && $address['lng'] > 0 && $address['lat'] > 0)
            {
                $map = \base\GeoTransUtil::GcjToBd($address['lng'], $address['lat']);
                if(isset($map['lng']) && isset($map['lat']))
                {
                    $address['lng'] = $map['lng'];
                    $address['lat'] = $map['lat'];
                }
            }
        }

D
devil_gong 已提交
1275 1276
        // 订单收货地址
        $data = [
D
devil_gong 已提交
1277 1278
            'order_id'      => $order_id,
            'user_id'       => $user_id,
D
devil_gong 已提交
1279
            'address_id'    => isset($address['id']) ? intval($address['id']) : 0,
D
devil_gong 已提交
1280
            'alias'         => isset($address['alias']) ? $address['alias'] : '',
D
devil_gong 已提交
1281 1282 1283 1284 1285 1286 1287 1288 1289 1290 1291 1292
            'name'          => isset($address['name']) ? $address['name'] : '',
            'tel'           => isset($address['tel']) ? $address['tel'] : '',
            'province'      => isset($address['province']) ? intval($address['province']) : 0,
            'city'          => isset($address['city']) ? intval($address['city']) : 0,
            'county'        => isset($address['county']) ? intval($address['county']) : 0,
            'address'       => isset($address['address']) ? $address['address'] : '',
            'province_name' => isset($address['province_name']) ? $address['province_name'] : '',
            'city_name'     => isset($address['city_name']) ? $address['city_name'] : '',
            'county_name'   => isset($address['county_name']) ? $address['county_name'] : '',
            'lng'           => isset($address['lng']) ? (float) $address['lng'] : '0.0000000000',
            'lat'           => isset($address['lat']) ? (float) $address['lat'] : '0.0000000000',
            'add_time'      => time(),
D
devil_gong 已提交
1293 1294 1295
        ];
        
        // 订单地址添加前钩子
D
devil_gong 已提交
1296
        $hook_name = 'plugins_service_buy_order_address_insert_begin';
D
devil_gong 已提交
1297
        $ret = HookReturnHandle(Hook::listen($hook_name, [
D
devil_gong 已提交
1298 1299 1300 1301 1302
            'hook_name'     => $hook_name,
            'is_backend'    => true,
            'user_id'       => $user_id,
            'order_id'      => $order_id,
            'data'          => &$data,
D
devil_gong 已提交
1303
        ]));
D
devil_gong 已提交
1304 1305 1306 1307 1308 1309
        if(isset($ret['code']) && $ret['code'] != 0)
        {
            return $ret;
        }

        // 添加订单地址
D
devil_gong 已提交
1310
        if(Db::name('OrderAddress')->insertGetId($data) > 0)
D
devil_gong 已提交
1311 1312 1313
        {
            return DataReturn('添加成功', 0);
        }
D
devil_gong 已提交
1314
        return DataReturn('订单地址添加失败', -1);
D
devil_gong 已提交
1315 1316
    }

D
v1.2.0  
devil_gong 已提交
1317 1318 1319 1320 1321 1322 1323 1324 1325
    /**
     * 购物车总数
     * @author   Devil
     * @blog    http://gong.gg/
     * @version 1.0.0
     * @date    2018-09-29
     * @desc    description
     * @param   [array]          $where [条件]
     */
1326
    public static function CartTotal($where = [])
D
v1.2.0  
devil_gong 已提交
1327 1328 1329 1330 1331 1332 1333 1334 1335 1336 1337 1338
    {
        return (int) Db::name('Cart')->where($where)->count();
    }

    /**
     * 用户购物车总数
     * @author   Devil
     * @blog    http://gong.gg/
     * @version 1.0.0
     * @date    2018-09-29
     * @desc    description
     * @param   [array]          $params [输入参数]
D
devil 已提交
1339
     * @return  [int|string]             [超过99则返回 99+]
D
v1.2.0  
devil_gong 已提交
1340
     */
1341
    public static function UserCartTotal($params = [])
D
v1.2.0  
devil_gong 已提交
1342 1343 1344 1345 1346 1347 1348 1349 1350 1351 1352 1353 1354 1355
    {
        // 请求参数
        $p = [
            [
                'checked_type'      => 'empty',
                'key_name'          => 'user',
                'error_msg'         => '用户信息有误',
            ],
        ];
        $ret = ParamsChecked($params, $p);
        if($ret !== true)
        {
            return 0;
        }
D
devil 已提交
1356 1357 1358 1359

        // 获取购物车总数
        $total = self::CartTotal(['user_id'=>$params['user']['id']]);
        return ($total > 99) ? '99+' : $total;
D
v1.2.0  
devil_gong 已提交
1360 1361
    }

D
devil 已提交
1362
    /**
D
devil 已提交
1363
     * 订单支付前校验
D
devil 已提交
1364 1365 1366 1367 1368 1369 1370
     * @author   Devil
     * @blog    http://gong.gg/
     * @version 1.0.0
     * @date    2018-11-09
     * @desc    description
     * @param   [array]          $params [输入参数]
     */
D
devil 已提交
1371
    public static function OrderPayBeginCheck($params = [])
D
devil 已提交
1372 1373 1374 1375 1376 1377 1378 1379 1380 1381 1382 1383 1384 1385 1386 1387 1388 1389 1390 1391 1392 1393 1394 1395 1396 1397 1398 1399 1400 1401 1402 1403 1404 1405 1406 1407 1408 1409
    {
        // 请求参数
        $p = [
            [
                'checked_type'      => 'empty',
                'key_name'          => 'order_id',
                'error_msg'         => '订单id有误',
            ],
            [
                'checked_type'      => 'empty',
                'key_name'          => 'order_data',
                'error_msg'         => '订单更新数据不能为空',
            ],
            [
                'checked_type'      => 'is_array',
                'key_name'          => 'order_data',
                'error_msg'         => '订单更新数据有误',
            ]
        ];
        $ret = ParamsChecked($params, $p);
        if($ret !== true)
        {
            return DataReturn($ret, -1);
        }

        // 是否扣除库存
        $common_is_deduction_inventory = MyC('common_is_deduction_inventory', 0);
        if($common_is_deduction_inventory != 1)
        {
            return DataReturn('未开启扣除库存', 0);
        }

        // 获取订单商品
        $order_detail = Db::name('OrderDetail')->field('id,goods_id,buy_number,spec')->where(['order_id'=>$params['order_id']])->select();
        if(!empty($order_detail))
        {
            foreach($order_detail as $v)
            {
D
devil 已提交
1410 1411 1412 1413 1414 1415 1416 1417 1418 1419 1420 1421 1422 1423
                // 获取商品
                $goods = Db::name('Goods')->field('is_shelves,is_deduction_inventory,inventory,title')->find($v['goods_id']);
                if(empty($goods))
                {
                    return DataReturn('商品不存在', -10);
                }

                // 商品状态
                if($goods['is_shelves'] != 1)
                {
                    return DataReturn('商品已下架['.$goods['title'].']', -10);
                }

                // 库存
D
devil 已提交
1424 1425 1426 1427 1428
                if(isset($goods['is_deduction_inventory']) && $goods['is_deduction_inventory'] == 1)
                {
                    // 先判断商品库存是否不足
                    if($goods['inventory'] < $v['buy_number'])
                    {
D
devil 已提交
1429
                        return DataReturn('库存不足['.$goods['title'].'('.$goods['inventory'].'<'.$v['buy_number'].')]', -10);
D
devil 已提交
1430 1431 1432 1433 1434 1435 1436 1437 1438 1439 1440
                    }

                    // 规格库存
                    $spec = empty($v['spec']) ? '' : json_decode($v['spec'], true);
                    $base = GoodsService::GoodsSpecDetail(['id'=>$v['goods_id'], 'spec'=>$spec]);
                    if($base['code'] == 0)
                    {
                        // 先判断商品规格库存是否不足
                        $inventory = Db::name('GoodsSpecBase')->where(['id'=>$base['data']['spec_base']['id'], 'goods_id'=>$v['goods_id']])->value('inventory');
                        if($inventory < $v['buy_number'])
                        {
D
devil 已提交
1441
                            return DataReturn('库存不足['.$goods['title'].'('.$inventory.'<'.$v['buy_number'].')]', -10);
D
devil 已提交
1442 1443 1444 1445 1446 1447 1448 1449 1450 1451 1452
                        }
                    } else {
                        return $base;
                    }
                }
            }
            return DataReturn('校验成功', 0);
        }
        return DataReturn('没有需要扣除库存的数据', 0);
    }

D
v1.2.0  
devil_gong 已提交
1453 1454 1455 1456 1457 1458 1459 1460 1461
    /**
     * 库存扣除
     * @author   Devil
     * @blog    http://gong.gg/
     * @version 1.0.0
     * @date    2018-11-09
     * @desc    description
     * @param   [array]          $params [输入参数]
     */
1462
    public static function OrderInventoryDeduct($params = [])
D
v1.2.0  
devil_gong 已提交
1463 1464 1465 1466 1467 1468 1469 1470 1471 1472 1473 1474 1475 1476 1477 1478 1479 1480 1481 1482 1483 1484 1485 1486 1487 1488 1489 1490 1491 1492 1493 1494 1495 1496 1497 1498 1499 1500 1501 1502 1503 1504 1505 1506 1507 1508 1509 1510 1511 1512 1513 1514 1515 1516 1517 1518 1519 1520 1521 1522 1523 1524
    {
        // 请求参数
        $p = [
            [
                'checked_type'      => 'empty',
                'key_name'          => 'order_id',
                'error_msg'         => '订单id有误',
            ],
            [
                'checked_type'      => 'empty',
                'key_name'          => 'order_data',
                'error_msg'         => '订单更新数据不能为空',
            ],
            [
                'checked_type'      => 'is_array',
                'key_name'          => 'order_data',
                'error_msg'         => '订单更新数据有误',
            ]
        ];
        $ret = ParamsChecked($params, $p);
        if($ret !== true)
        {
            return DataReturn($ret, -1);
        }

        // 是否扣除库存
        $common_is_deduction_inventory = MyC('common_is_deduction_inventory', 0);
        if($common_is_deduction_inventory != 1)
        {
            return DataReturn('未开启扣除库存', 0);
        }

        // 扣除库存规则
        $common_deduction_inventory_rules = MyC('common_deduction_inventory_rules', 1);
        switch($common_deduction_inventory_rules)
        {
            // 订单确认成功
            case 0 :
                if($params['order_data']['status'] != 1)
                {
                    return DataReturn('当前订单状态未操作确认-不扣除库存['.$params['order_id'].']', 0);
                }
                break;

            // 订单支付成功
            case 1 :
                if($params['order_data']['status'] != 2)
                {
                    return DataReturn('当前订单状态未操作支付-不扣除库存['.$params['order_id'].']', 0);
                }
                break;

            // 订单发货
            case 2 :
                if($params['order_data']['status'] != 3)
                {
                    return DataReturn('当前订单状态未操作发货-不扣除库存['.$params['order_id'].']', 0);
                }
                break;
        }

        // 获取订单商品
D
Devil 已提交
1525
        $order_detail = Db::name('OrderDetail')->field('id,goods_id,buy_number,spec')->where(['order_id'=>$params['order_id']])->select();
D
v1.2.0  
devil_gong 已提交
1526 1527 1528 1529 1530
        if(!empty($order_detail))
        {
            foreach($order_detail as $v)
            {
                // 查看是否已扣除过库存,避免更改模式导致重复扣除
D
Devil 已提交
1531
                $temp = Db::name('OrderGoodsInventoryLog')->where(['order_id'=>$params['order_id'], 'order_detail_id'=>$v['id'], 'goods_id'=>$v['goods_id']])->find();
D
v1.2.0  
devil_gong 已提交
1532 1533
                if(empty($temp))
                {
D
devil 已提交
1534
                    $goods = Db::name('Goods')->field('is_deduction_inventory,inventory,title')->find($v['goods_id']);
D
v1.2.0  
devil_gong 已提交
1535 1536
                    if(isset($goods['is_deduction_inventory']) && $goods['is_deduction_inventory'] == 1)
                    {
D
devil 已提交
1537
                        // 先判断商品库存是否不足
D
devil 已提交
1538
                        if($goods['inventory'] < $v['buy_number'])
D
devil 已提交
1539
                        {
D
devil 已提交
1540
                            return DataReturn('商品库存不足['.$goods['title'].'('.$goods['inventory'].'<'.$v['buy_number'].')]', -10);
D
devil 已提交
1541 1542
                        }

D
v1.2.0  
devil_gong 已提交
1543 1544 1545
                        // 扣除操作
                        if(!Db::name('Goods')->where(['id'=>$v['goods_id']])->setDec('inventory', $v['buy_number']))
                        {
D
Devil 已提交
1546
                            return DataReturn('商品库存扣减失败['.$params['order_id'].'-'.$v['id'].'-'.$v['goods_id'].'('.$goods['inventory'].'-'.$v['buy_number'].')]', -10);
D
v1.2.0  
devil_gong 已提交
1547 1548 1549 1550 1551 1552 1553
                        }

                        // 扣除规格库存
                        $spec = empty($v['spec']) ? '' : json_decode($v['spec'], true);
                        $base = GoodsService::GoodsSpecDetail(['id'=>$v['goods_id'], 'spec'=>$spec]);
                        if($base['code'] == 0)
                        {
D
devil 已提交
1554 1555 1556 1557
                            // 先判断商品规格库存是否不足
                            $inventory = Db::name('GoodsSpecBase')->where(['id'=>$base['data']['spec_base']['id'], 'goods_id'=>$v['goods_id']])->value('inventory');
                            if($inventory < $v['buy_number'])
                            {
D
devil 已提交
1558
                                return DataReturn('商品规格库存不足['.$goods['title'].'('.$inventory.'<'.$v['buy_number'].']', -10);
D
devil 已提交
1559 1560
                            }

D
v1.2.0  
devil_gong 已提交
1561
                            // 扣除规格操作
D
devil_gong 已提交
1562
                            if(!Db::name('GoodsSpecBase')->where(['id'=>$base['data']['spec_base']['id'], 'goods_id'=>$v['goods_id']])->setDec('inventory', $v['buy_number']))
D
v1.2.0  
devil_gong 已提交
1563 1564 1565 1566 1567 1568 1569 1570 1571 1572
                            {
                                return DataReturn('规格库存扣减失败['.$params['order_id'].'-'.$v['goods_id'].'('.$goods['inventory'].'-'.$v['buy_number'].')]', -10);
                            }
                        } else {
                            return $base;
                        }

                        // 扣除日志添加
                        $log_data = [
                            'order_id'              => $params['order_id'],
D
Devil 已提交
1573
                            'order_detail_id'       => $v['id'],
D
v1.2.0  
devil_gong 已提交
1574 1575 1576 1577 1578 1579 1580 1581 1582 1583 1584 1585 1586 1587 1588 1589 1590 1591 1592 1593 1594 1595 1596 1597 1598 1599 1600
                            'goods_id'              => $v['goods_id'],
                            'order_status'          => $params['order_data']['status'],
                            'original_inventory'    => $goods['inventory'],
                            'new_inventory'         => Db::name('Goods')->where(['id'=>$v['goods_id']])->value('inventory'),
                            'add_time'              => time(),
                        ];
                        if(Db::name('OrderGoodsInventoryLog')->insertGetId($log_data) <= 0)
                        {
                            return DataReturn('库存扣减日志添加失败['.$params['order_id'].'-'.$v['goods_id'].']', -100);
                        }
                    }
                }
            }
            return DataReturn('操作成功', 0);
        }
        return DataReturn('没有需要扣除库存的数据', 0);
    }

    /**
     * 库存回滚
     * @author   Devil
     * @blog    http://gong.gg/
     * @version 1.0.0
     * @date    2018-11-09
     * @desc    description
     * @param   [array]          $params [输入参数]
     */
1601
    public static function OrderInventoryRollback($params = [])
D
v1.2.0  
devil_gong 已提交
1602 1603 1604 1605 1606 1607 1608 1609 1610 1611 1612 1613 1614 1615 1616 1617 1618 1619 1620 1621 1622 1623 1624 1625 1626 1627
    {
        // 请求参数
        $p = [
            [
                'checked_type'      => 'empty',
                'key_name'          => 'order_id',
                'error_msg'         => '订单id有误',
            ],
            [
                'checked_type'      => 'empty',
                'key_name'          => 'order_data',
                'error_msg'         => '订单更新数据不能为空',
            ],
            [
                'checked_type'      => 'is_array',
                'key_name'          => 'order_data',
                'error_msg'         => '订单更新数据有误',
            ]
        ];
        $ret = ParamsChecked($params, $p);
        if($ret !== true)
        {
            return DataReturn($ret, -1);
        }

        // 订单状态
G
gongfuxiang 已提交
1628
        if(isset($params['order_data']['status']))
D
v1.2.0  
devil_gong 已提交
1629
        {
G
gongfuxiang 已提交
1630 1631 1632 1633
            if(!in_array($params['order_data']['status'], [5,6]))
            {
                return DataReturn('当前订单状态不允许回滚库存['.$params['order_id'].'-'.$params['order_data']['status'].']', 0);
            }
D
v1.2.0  
devil_gong 已提交
1634 1635
        }

D
devil_gong 已提交
1636 1637 1638 1639 1640 1641 1642 1643
        // 是否指定商品和数量
        $appoint_buy_number = empty($params['appoint_buy_number']) ? 0 : intval($params['appoint_buy_number']);
        $detail_where = ['order_id' => $params['order_id']];
        if(!empty($params['appoint_order_detail_id']))
        {
            $detail_where['id'] = intval($params['appoint_order_detail_id']);
        }

D
v1.2.0  
devil_gong 已提交
1644
        // 获取订单商品
D
devil_gong 已提交
1645
        $order_detail = Db::name('OrderDetail')->field('goods_id,buy_number,spec')->where($detail_where)->select();
D
v1.2.0  
devil_gong 已提交
1646 1647 1648 1649 1650 1651 1652 1653
        if(!empty($order_detail))
        {
            foreach($order_detail as $v)
            {
                // 查看是否已扣除过库存
                $temp = Db::name('OrderGoodsInventoryLog')->where(['order_id'=>$params['order_id'], 'goods_id'=>$v['goods_id'], 'is_rollback'=>0])->find();
                if(!empty($temp))
                {
D
devil_gong 已提交
1654 1655 1656
                    // 数量
                    $buy_number = ($appoint_buy_number == 0) ? $v['buy_number'] : $appoint_buy_number;

D
v1.2.0  
devil_gong 已提交
1657
                    // 回滚操作
D
devil_gong 已提交
1658
                    if(!Db::name('Goods')->where(['id'=>$v['goods_id']])->setInc('inventory', $buy_number))
D
v1.2.0  
devil_gong 已提交
1659 1660 1661 1662
                    {
                        return DataReturn('商品库存回滚失败['.$params['order_id'].'-'.$v['goods_id'].']', -10);
                    }

D
devil_gong 已提交
1663
                    // 回滚规格库存
D
v1.2.0  
devil_gong 已提交
1664 1665 1666 1667
                    $spec = empty($v['spec']) ? '' : json_decode($v['spec'], true);
                    $base = GoodsService::GoodsSpecDetail(['id'=>$v['goods_id'], 'spec'=>$spec]);
                    if($base['code'] == 0)
                    {
D
devil_gong 已提交
1668
                        // 回滚规格操作
D
devil_gong 已提交
1669
                        if(!Db::name('GoodsSpecBase')->where(['id'=>$base['data']['spec_base']['id'], 'goods_id'=>$v['goods_id']])->setInc('inventory', $buy_number))
D
v1.2.0  
devil_gong 已提交
1670 1671 1672 1673 1674 1675 1676 1677 1678 1679 1680 1681 1682 1683 1684 1685 1686 1687 1688 1689 1690 1691
                        {
                            return DataReturn('规格库存回滚失败['.$params['order_id'].'-'.$v['goods_id'].']', -10);
                        }
                    } else {
                        return $base;
                    }

                    // 回滚日志更新
                    $log_data = [
                        'is_rollback'   => 1,
                        'rollback_time' => time(),
                    ];
                    if(!Db::name('OrderGoodsInventoryLog')->where(['id'=>$temp['id']])->update($log_data))
                    {
                        return DataReturn('库存回滚日志更新失败['.$temp['id'].'-'.$params['order_id'].']', -100);
                    }
                }
            }
            return DataReturn('操作成功', 0);
        }
        return DataReturn('没有需要回滚的数据', 0);
    }
D
devil_gong 已提交
1692 1693 1694 1695 1696 1697 1698 1699 1700 1701 1702 1703 1704 1705 1706 1707 1708 1709

    /**
     * 自提点地址选中地址获取
     * @author  Devil
     * @blog    http://gong.gg/
     * @version 1.0.0
     * @date    2019-11-18
     * @desc    description
     * @param   [int]       $params['address_id'] [自提点地址索引值]
     * @param   [array]     $params['address_id'] [自提点地址列表]
     */
    public static function SiteExtractionAddress($params = [])
    {
        // 自提地址列表
        $address = ConfigService::SiteTypeExtractionAddressList();

        // 选中地址处理
        $default = null;
D
devil 已提交
1710
        if(isset($params['address_id']) && $params['address_id'] !== null && !empty($address['data']) && is_array($address['data']))
D
devil_gong 已提交
1711 1712 1713 1714 1715 1716 1717
        {
            if(isset($address['data'][$params['address_id']]))
            {
                $default = $address['data'][$params['address_id']];
            }
        }

D
devil 已提交
1718 1719 1720 1721 1722 1723 1724 1725 1726 1727 1728 1729 1730
        // 默认地址
        if(empty($default) && !empty($address['data']))
        {
            foreach($address['data'] as $v)
            {
                if(isset($v['is_default']) && $v['is_default'] == 1)
                {
                    $default = $v;
                    break;
                }
            }
        }

D
devil_gong 已提交
1731 1732 1733 1734 1735
        // 返回数据
        $result = [
            'data_list'     => $address['data'],
            'default'       => $default,
        ];
D
devil_gong 已提交
1736 1737 1738 1739 1740 1741 1742 1743 1744 1745

        // 自提点地址数据钩子
        $hook_name = 'plugins_service_site_extraction_address_handle';
        $ret = Hook::listen($hook_name, [
            'hook_name'     => $hook_name,
            'is_backend'    => true,
            'params'        => $params,
            'data'          => &$result,
        ]);

D
devil_gong 已提交
1746 1747
        return DataReturn('操作成功', 0, $result);
    }
D
v1.2.0  
devil_gong 已提交
1748 1749
}
?>