审查视图

application/api/controller/Order.php 36.2 KB
李忠强 authored
1 2 3 4 5 6 7
<?php


namespace app\api\controller;


use addons\epay\library\Service;
李忠强 authored
8
use app\api\model\GoodsComment;
李忠强 authored
9
use app\api\model\GoodsSpec;
何书鹏 authored
10
use app\api\model\RiderOrder;
李忠强 authored
11 12 13 14 15 16 17
use app\api\model\SpecValue;
use app\api\model\Third;
use app\api\model\UserAddress;
use app\api\model\UserCoupon;
use app\common\controller\Api;
use think\Db;
use think\exception\PDOException;
李忠强 authored
18
use Yansongda\Pay\Pay;
李忠强 authored
19 20 21 22 23 24

/**
 * 订单
 */
class Order extends Api
{
25
    protected $noNeedLogin = ['friendPay','commentOrderDetail','pay','cancelOrderAction'];
李忠强 authored
26
    protected $noNeedRight = ['*'];
李忠强 authored
27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51

    /**
     * @ApiTitle    (订单列表)
     * @ApiMethod   (POST)
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     * @ApiParams   (name="type", type="integer", required=true, description="类型1全部2待付款3待发货4待收货5待评价")
     * @ApiParams   (name="page", type="integer", required=true, description="页数")
     * @ApiReturn   ({
    'code':'1',
    'msg':'返回成功'
    'data':
        "total": 1, 总条数
        "per_page": 5, 每页数量
        "current_page": 1, 当前页
        "last_page": 1, 最后一页
        "data": [
            {
            "id": 1, 订单id
            "order_no": "adsadasdas", 订单编号
            "discount_price": "0.00", 优惠金额
            "pay_price": "0.00", 实付价格
            "pay_status": "10", 10未支付20已支付
            "freight_status": "10", 10未发货20已发货
            "receipt_status": "10", 10未收货20已收货
            "order_status": "10", 10进行中20已取消30已完成
何书鹏 authored
52
            "comment_status": "10", 评价状态:10=未评价20=已评价
李忠强 authored
53
            "total_sum": 0, 商品总数量
何书鹏 authored
54 55
            "goods": [{
                "goods_id": 1, 商品ID
李忠强 authored
56 57 58 59 60
                "goods_name": "asdasd", 商品名
                "goods_attr": "1", 规格名
                "total_num": 0, 数量
                "total_price": "0.00", 价格
                "image_text": "" 图片
何书鹏 authored
61
                "stock_num": 68, 商品总库存
何书鹏 authored
62
            }],
李忠强 authored
63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91
            "createtime_text": "" 时间
            }
        ]
    })
     */
    public function orderList()
    {
        $type = $this->request->post('type');
        $page = $this->request->post('page',1);
        if (!in_array($type,[1,2,3,4,5])) $this->error('type参数不合法');
        if (!is_numeric($page)) $this->error('页数不合法');
        switch ($type){
            case 1:
                $where = [
                    'fa_litestore_order.status' => 'normal',
                    'fa_litestore_order.user_id' => $this->auth->id,
                ];
                break;
            case 2:
                $where = [
                    'fa_litestore_order.status' => 'normal',
                    'fa_litestore_order.user_id' => $this->auth->id,
                    'fa_litestore_order.pay_status' => '10',
                ];
                break;
            case 3:
                $where = [
                    'fa_litestore_order.status' => 'normal',
                    'fa_litestore_order.user_id' => $this->auth->id,
何书鹏 authored
92
                    'fa_litestore_order.pay_status' => '20',
李忠强 authored
93 94 95 96 97 98 99
                    'fa_litestore_order.freight_status' => '10',
                ];
                break;
            case 4:
                $where = [
                    'fa_litestore_order.status' => 'normal',
                    'fa_litestore_order.user_id' => $this->auth->id,
何书鹏 authored
100 101
                    'fa_litestore_order.pay_status' => '20',
                    'fa_litestore_order.freight_status' => '20',
李忠强 authored
102 103 104 105 106 107 108
                    'fa_litestore_order.receipt_status' => '10',
                ];
                break;
            default :
                $where = [
                    'fa_litestore_order.status' => 'normal',
                    'fa_litestore_order.user_id' => $this->auth->id,
何书鹏 authored
109 110
                    'fa_litestore_order.pay_status' => '20',
                    'fa_litestore_order.freight_status' => '20',
李忠强 authored
111
                    'fa_litestore_order.receipt_status' => '20',
何书鹏 authored
112
                    'fa_litestore_order.comment_status' => '10',
李忠强 authored
113 114 115 116 117 118 119 120 121 122 123 124 125 126
                ];
                break;
        }

        $model = new \app\api\model\Order();
        $list = $model
            ->with(['goods'])
            ->where($where)
            ->order('id','desc')
            ->paginate(5,false,['page'=>$page])
            ->each(function ($item,$key){
                $sum = 0;
                foreach ($item->getRelation('goods')as $key => $value){
                    $sum += $value['total_num'];
何书鹏 authored
127 128 129
                    // 总库存
                    $value['stock_num'] = GoodsSpec::where('goods_id',$value['goods_id'])->sum('stock_num');
                    $value->visible(['goods_id','goods_name','goods_attr','total_num','total_price'])->append(['stock_num']);
李忠强 authored
130 131 132 133 134
                }
                $item['total_sum'] = $sum;
                $item->visible([
                    'goods','total_sum','order_no','id','pay_price',
                    'discount_price','pay_status','order_status','receipt_status',
何书鹏 authored
135
                    'freight_status','comment_status'
李忠强 authored
136 137 138 139 140 141 142
                ]);
            });
        $this->success('订单列表',$list);
    }

    /**
     * @ApiTitle    (下单页面)
143
     * @ApiSummary ([{id:113 goods_id:22 goods_sku_id:106 number:2} {id:114 goods_id:23 goods_sku_id:66 number:2}])
李忠强 authored
144 145 146
     * @ApiMethod   (POST)
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     * @ApiParams   (name="data_json", type="string", required=true, description="下单的商品json数据")
147
     * @ApiParams   (name="id", type="integer", required=false, description="购物车或我常买id 此值不传 json数组注释用")
李忠强 authored
148 149 150 151 152 153 154 155 156
     * @ApiParams   (name="goods_id", type="integer", required=false, description="商品id 此值不传 json数组注释用")
     * @ApiParams   (name="goods_sku_id", type="integer", required=false, description="规格id 此值不传 json数组注释用")
     * @ApiParams   (name="number", type="integer", required=false, description="购买数量 此值不传 json数组注释用")
     * @ApiReturn   ({
    'code':'1',
    'msg':'返回成功'
    'data':
        "list": [
            {
157
            "id": 113, 购物车或我常买id
李忠强 authored
158 159 160 161 162 163 164 165 166 167
            "goods_id": 22, 商品id
            "goods_name": "Mate 20 华为 HUAWEI ", 商品名称
            "spec_type": "20", 20多规格10单规格
            "sku_id": 106, 规格id
            "sku_price": "6099.00", 规格单价
            "sku_name": "极光色 8GB+128GB", 规格名称
            "number": 2, 数量
            "image_text": "", 图片
            },
            {
168
            "id": 114,
李忠强 authored
169 170 171 172 173 174 175 176 177 178 179 180 181 182 183
            "goods_id": 23,
            "goods_name": "MacBook Pro 13寸",
            "spec_type": "20",
            "sku_id": 66,
            "sku_price": "12688.00",
            "sku_name": "天空灰",
            "number": 2,
            "image_text": "",
            }
        ],
        "price": "37574.00" 总价
    })
     */
    public function orderCalculation()
    {
李忠强 authored
184
        $json = $this->request->param('data_json');
李忠强 authored
185
        if (!$json) $this->error('data_json参数不能为空');
李忠强 authored
186
        $json = str_replace('&quot;','"',$json);
李忠强 authored
187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216
//        $json = '[{"goods_id":22,"goods_sku_id":106,"number":2},{"goods_id":23,"goods_sku_id":66,"number":2}]';
        $data = json_decode($json,true);
        $goodsmodel = new \app\api\model\Goods();
        $skumodel = new GoodsSpec();
        $specmodel = new SpecValue();
        $goods_array = []; //商品列表
        $sum_price = 0; //总价格
        foreach ($data as $key => $value){
            if (!is_numeric($value['goods_id']) || !is_numeric($value['goods_sku_id']) || !is_numeric($value['number'])){
                $this->error('参数不合法');
            }
            $goods = $goodsmodel->where('goods_id',$value['goods_id'])->field('goods_id,goods_name,image,spec_type')->find();
            if (!$goods) $this->error('商品不存在');
            $goods->visibleAppend(['image_text']);
            $goods->hidden(['image']);
            $sku = $skumodel->where('goods_spec_id',$value['goods_sku_id'])
                ->field('goods_spec_id,spec_sku_id,goods_price')->find();
            if (!$sku) $this->error('商品规格不存在');
            $sku->unsetAppend();

            $goods['sku_id'] = $sku['goods_spec_id'];
            $goods['sku_price'] = $sku['goods_price'];
            if ($goods['spec_type'] == 10){
                $goods['sku_name'] =''; //规格名
            }else{
                $ids = explode('_',$sku['spec_sku_id']);
                $sku_name = $specmodel->whereIn('id',$ids)->column('spec_value');
                $goods['sku_name'] = implode(' ',$sku_name);  //规格名
            }
            $goods['number'] = $value['number'];
何书鹏 authored
217 218 219
            if(!empty($value['id'])){
                $goods['id'] = $value['id'];
            }
李忠强 authored
220 221 222
            $goods_array[] = $goods;
            $sum_price = bcadd($sum_price,bcmul($sku['goods_price'],$value['number'],2),2);
        }
李忠强 authored
223 224 225 226 227 228 229 230 231 232
        $addressmodel = new UserAddress();
        $address = $addressmodel->where('user_id',$this->auth->id)->where('normal_status','1')->find();
        $express_price = 0;
        if ($address){
            // 计算运费
            $lat1 = $address['lat'];
            $lng1 = $address['lng'];
            $admin_address = Db::name('admin_address')->find();
            $lat2 = $admin_address['lat'];
            $lng2 = $admin_address['lng'];
何书鹏 authored
233
            $express_price = $this->distancePrice($lat1,$lng1,$lat2,$lng2,$sum_price);
李忠强 authored
234 235 236 237 238
            if ($express_price === false)  $express_price = 0;
        }else{
            $address = [];
        }
        $sum_price += $express_price;
李忠强 authored
239
        $this->success('下单页详情',['list'=>$goods_array,'price'=>$sum_price,'order_price'=>$sum_price-$express_price,'express_price'=>$express_price,'address'=>$address]);
李忠强 authored
240 241 242
    }

    /**
李忠强 authored
243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283
     * @ApiTitle    (找人付页面)
     * @ApiMethod   (POST)
     * @ApiParams   (name="order_id", type="integer", required=true, description="订单id")
     * @ApiReturn   ({
    'code':'1',
    'msg':'返回成功'
    'data':
        detail:
            pay_price:实付款
            "goods": [
                {
                "goods_id": 22, 商品id
                "goods_name": "Mate 20 华为 HUAWEI ", 商品名称
                "spec_type": "20", 20多规格10单规格
                "sku_id": 106, 规格id
                "sku_price": "6099.00", 规格单价
                "sku_name": "极光色 8GB+128GB", 规格名称
                "number": 2, 数量
                "image_text": "", 图片
                },
                {
                "goods_id": 23,
                "goods_name": "MacBook Pro 13寸",
                "spec_type": "20",
                "sku_id": 66,
                "sku_price": "12688.00",
                "sku_name": "天空灰",
                "number": 2,
                "image_text": "",
                }
            ],
        "user": 用户信息
    })
     */
    public function friendPay()
    {
        $order_id = $this->request->post('order_id');
        if (!$order_id) $this->error('订单id参数不能为空');
        $ordermodel = new \app\api\model\Order();
        $order = $ordermodel
            ->with(['goods'])
何书鹏 authored
284
            ->where('id',$order_id)
李忠强 authored
285 286 287 288 289 290 291
            ->find();
        $user = \app\api\model\User::get($order['user_id']);
        $user->visible(['nickname']);
        $this->success('下单页详情',['detail'=>$order,'user'=>$user]);
    }

    /**
李忠强 authored
292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311
     * @ApiTitle    (判断库存)
     * @ApiMethod   (POST)
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     * @ApiParams   (name="sku_id", type="integer", required=true, description="规格id")
     * @ApiParams   (name="number", type="integer", required=true, description="购买数量")
     * @ApiReturn   ({
    'code':'1',
    'msg':'SUCCESS'
    'data': code 等于1表示未超出最大值
    })
     */
    public function checkStock()
    {
        $sku_id = $this->request->post('sku_id');
        $number = $this->request->post('number');
        if (!$number) $this->error('请选择购买数量');
        if (!$sku_id) $this->error('请选择规格');
        $model = new GoodsSpec();
        $sku = $model::get($sku_id);
        if (!$sku) $this->error('规格已失效,请重新选择');
312 313
        $cart_number = \app\api\model\Cart::where('sku_id',$sku_id)->sum('number');
        if ($sku['stock_num'] < $number+$cart_number) $this->error('已超出最大库存');
李忠强 authored
314 315 316 317
        $this->success('SUCCESS');
    }

    /**
李忠强 authored
318 319 320 321
     * @ApiTitle    (计算运费)
     * @ApiMethod   (POST)
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     * @ApiParams   (name="address_id", type="integer", required=true, description="地址id")
何书鹏 authored
322
     * @ApiParams   (name="goods_total_price", type="string", required=true, description="商品总价")
李忠强 authored
323 324
     * @ApiReturn   ({
    'code':'1',
李忠强 authored
325
    'msg':'计算运费'
李忠强 authored
326
    'data':
何书鹏 authored
327 328
        "price": "37574.00", 总价
        "delivery_threshold": "20.00", 起送价
李忠强 authored
329 330 331 332 333
    })
     */
    public function freightCalculation()
    {
        $address_id = $this->request->post('address_id');
何书鹏 authored
334
        $goods_total_price = $this->request->post('goods_total_price');
李忠强 authored
335
        if (!$address_id) $this->error('请选择地址');
何书鹏 authored
336
        if (!$goods_total_price) $this->error('请计算商品总价');
李忠强 authored
337 338 339 340 341 342 343 344
        $model = new UserAddress();
        $address = $model::get($address_id);
        if (!$address) $this->error('地址不存在');
        $lat1 = $address['lat'];
        $lng1 = $address['lng'];
        $admin_address = Db::name('admin_address')->find();
        $lat2 = $admin_address['lat'];
        $lng2 = $admin_address['lng'];
何书鹏 authored
345
        $sum_price = $this->distancePrice($lat1,$lng1,$lat2,$lng2,$goods_total_price);
李忠强 authored
346
        if ($sum_price === false) $this->error('地址超出配送距离');
何书鹏 authored
347 348 349 350 351
        $delivery_threshold = Db::name('litestore_rider_rule')->value('delivery_threshold');
        $this->success('计算运费',[
            'price' => $sum_price,
            'delivery_threshold' => $delivery_threshold
        ]);
李忠强 authored
352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379
    }

    /**
     * @ApiTitle    (选择优惠券)
     * @ApiMethod   (POST)
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     * @ApiParams   (name="price", type="float", required=true, description="订单价格")
     * @ApiReturn   ({
    'code':'1',
    'msg':'返回成功'
    "data": [
        {
            "id": 1,
            "user_id": 1,
            "coupon_id": 1,
            "name": "手动阀手动阀",
            "price": "1.00", 优惠券金额
            "full_price": "10.00", 满减金额
            "createtime": 111122244,
            "endtime": 1641869388,
            "status": "0",
            "endtime_text": "2022年01月11日到期"
        }
    ]
    })
     */
    public function chooseCoupon()
    {
何书鹏 authored
380 381 382
        $model = new UserCoupon();

        // 更新已过期状态
何书鹏 authored
383
        $model->where('status','0')->where('user_id',$this->auth->id)->where('endtime','<',time())->update(['status'=>'2']);
何书鹏 authored
384
李忠强 authored
385 386
        $price = $this->request->post('price');
        if (!is_numeric($price)) $this->error('订单价格不合法');
何书鹏 authored
387
李忠强 authored
388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415
        $list = $model
            ->where('status','0')
            ->where('user_id',$this->auth->id)
            ->where('full_price','<',$price)
            ->select();
        $this->success('用户优惠券列表',$list);
    }

    /**
     * @ApiTitle    (下单)
     * @ApiMethod   (POST)
     * @ApiSummary ([{goods_id:22 goods_sku_id:106 number:2} {goods_id:23 goods_sku_id:66 number:2}])
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     * @ApiParams   (name="data_json", type="string", required=true, description="下单的商品json数据")
     * @ApiParams   (name="goods_id", type="integer", required=false, description="商品id 此值不传 json数组注释用")
     * @ApiParams   (name="goods_sku_id", type="integer", required=false, description="规格id 此值不传 json数组注释用")
     * @ApiParams   (name="number", type="integer", required=false, description="购买数量 此值不传 json数组注释用")
     * @ApiParams   (name="coupon_id", type="integer", required=true, description="优惠券id 无优惠券传0")
     * @ApiParams   (name="address_id", type="integer", required=true, description="地址id")
     * @ApiReturn   ({
    'code':'1',
    'msg':'返回成功'
    'data':

    })
     */
    public function addOrder()
    {
李忠强 authored
416 417 418
        $json = $this->request->param('data_json');
        $coupon_id = $this->request->param('coupon_id');
        $address_id = $this->request->param('address_id');
李忠强 authored
419 420 421 422 423 424 425 426 427 428 429 430
        if (!$json) $this->error('data_json参数不能为空');
//        $json = '[{"goods_id":22,"goods_sku_id":106,"number":2},{"goods_id":23,"goods_sku_id":66,"number":2}]';
        $address = Db::name('user_address')
            ->where('id',$address_id)
            ->where('user_id',$this->auth->id)
            ->find();
        if (!$address) $this->error('地址不存在');
        $coupon = [];
        if ($coupon_id > 0){
            $coupon = Db::name('user_coupon')
                ->where('id',$coupon_id)
                ->where('user_id',$this->auth->id)
何书鹏 authored
431
                ->where('status','0')
李忠强 authored
432 433 434
                ->find();
            if (!$coupon) $this->error('优惠券不存在');
        }
李忠强 authored
435
        $json = str_replace('&quot;','"',$json);
李忠强 authored
436 437 438 439 440 441
        $data = json_decode($json,true);
        $goodsmodel = new \app\api\model\Goods();
        $skumodel = new GoodsSpec();
        $ordermodel = new \app\api\model\Order();
        $ordergoodsmodel = new \app\api\model\OrderGoods();
        $orderaddressmodel = new \app\api\model\OrderAddress();
李忠强 authored
442
        $cartmodel = new \app\api\model\Cart();
李忠强 authored
443 444 445 446 447 448 449 450 451 452 453 454 455
        $specmodel = new SpecValue();
        $goods_array = []; //商品列表
        $sum_price = 0; //总价格
        $user_id = $this->auth->id;

        foreach ($data as $key => $value){
            if (!is_numeric($value['goods_id']) || !is_numeric($value['goods_sku_id']) || !is_numeric($value['number'])){
                $this->error('参数不合法');
            }
            $goods = $goodsmodel->where('goods_id',$value['goods_id'])->find();
            if (!$goods) $this->error('商品不存在');
            $sku = $skumodel->where('goods_spec_id',$value['goods_sku_id'])->find();
            if (!$sku) $this->error('商品规格不存在');
李忠强 authored
456
            if ($sku['stock_num'] < $value['number']) $this->error('库存不足');
李忠强 authored
457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492
            if ($goods['spec_type'] == 10){
                $sku_name =''; //规格名
            }else{
                $ids = explode('_',$sku['spec_sku_id']);
                $sku_name = $specmodel->whereIn('id',$ids)->column('spec_value');
                $sku_name = implode(' ',$sku_name);  //规格名
            }

            // 组装订单商品数组
            $goods_array[] = [
                'goods_id' => $goods['goods_id'],
                'goods_name' => $goods['goods_name'],
                'image' => $goods['image'],
                'deduct_stock_type' => $goods['deduct_stock_type'],
                'spec_type' => $goods['spec_type'],
                'spec_sku_id' => $sku['spec_sku_id'],
                'goods_spec_id' => $sku['goods_spec_id'],
                'goods_attr' => $sku_name,
                'content' => $goods['content'],
                'goods_no' => $goods['number'],
                'goods_price' => $sku['goods_price'],
                'goods_weight' => $sku['goods_weight'],
                'total_num' => $value['number'],
                'total_price' => bcmul($sku['goods_price'],$value['number'],2),
                'user_id' => $user_id,
            ];

            $sum_price = bcadd($sum_price,bcmul($sku['goods_price'],$value['number'],2),2);
        }

        // 计算运费
        $lat1 = $address['lat'];
        $lng1 = $address['lng'];
        $admin_address = Db::name('admin_address')->find();
        $lat2 = $admin_address['lat'];
        $lng2 = $admin_address['lng'];
何书鹏 authored
493
        $distance_price = $this->distancePrice($lat1,$lng1,$lat2,$lng2,$sum_price);
李忠强 authored
494 495
        if ($distance_price === false) $this->error('地址超出配送距离');
何书鹏 authored
496
        if ($coupon !== [] && $coupon['full_price'] > $sum_price) $this->error('优惠券不可使用');
李忠强 authored
497
何书鹏 authored
498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514
        // 给骑手佣金
        $rider_rule = Db::name('litestore_rider_rule')->find();
        if ($sum_price < $rider_rule['delivery_threshold']){
            $last_price = $rider_rule['delivery_threshold'] - $sum_price;
            $this->error('差'.$last_price.'元起送');
        }
        $distance = ceil(getDistance($lat1,$lng1,$lat2,$lng2));
        if ($distance > $rider_rule['first']){
            $first_rider_fee = $rider_rule['first_rider_fee'];
            $subdistance = $distance-$rider_rule['first'];
            $count = ceil(bcdiv($subdistance,$rider_rule['additional'],1));
            $second_rider_price = bcmul($count,$rider_rule['additional_rider_fee'],2);
            $rider_price = bcadd($first_rider_fee,$second_rider_price,2);
        }else{
            $rider_price = $rider_rule['first_rider_fee'];
        }
李忠强 authored
515 516 517 518 519 520 521 522 523 524 525 526 527 528 529
        // 订单地址
        $order_address = [
            'name' => $address['username'],
            'phone' => $address['mobile'],
            'address' => $address['address'],
            'detail' => $address['address_detail'],
            'lng' => $address['lng'],
            'lat' => $address['lat'],
            'user_id' => $user_id,
        ];


        $sum_price += $distance_price; // 订单总价
        $order_no = 'LQ-'.time().mt_rand(1000,9999); // 订单号
        $couponprice = isset($coupon['price'])?$coupon['price']:0;  // 优惠价格
何书鹏 authored
530
李忠强 authored
531 532 533 534 535
        // 订单信息
        $order = [
            'order_no' => $order_no,
            'total_price' => $sum_price,  // 订单总价
            'discount_price' => $couponprice,  // 优惠价格
536
            'pay_price' => bcsub($sum_price,$couponprice,2),  // 支付总价
李忠强 authored
537
            'express_price' => $distance_price,  // 骑手费用
538
            'user_id' => $user_id,
何书鹏 authored
539 540
            'user_coupon_id' => $coupon_id > 0 ? $coupon_id : 0,
            'rider_price' => $rider_price
李忠强 authored
541 542 543 544 545 546 547 548
        ];

        // 添加订单
        try {
            Db::startTrans();
            $ordermodel->save($order);
            foreach ($goods_array as $key => &$value){
                $value['order_id'] = $ordermodel->id;
李忠强 authored
549 550 551 552
                // 减少库存
                if ($value['deduct_stock_type'] == 10){
                    $skumodel->where('goods_spec_id',$value['goods_spec_id'])->setDec('stock_num',$value['total_num']);
                }
李忠强 authored
553 554 555 556
            }
            $ordergoodsmodel->saveAll($goods_array);
            $order_address['order_id'] = $ordermodel->id;
            $orderaddressmodel->save($order_address);
李忠强 authored
557 558 559 560 561 562 563 564 565 566 567
            // 删除购物车
            $goodsids = [];
            $skuids = [];
            foreach ($goods_array as $key => $value){
                $goodsids[] = $value['goods_id'];
                $skuids[] = $value['goods_spec_id'];
            }
            $cartmodel->whereIn('goods_id',$goodsids)
                ->whereIn('sku_id',$skuids)
                ->where('user_id',$this->auth->id)
                ->delete();
568 569
            // 如果使用了优惠券,就把优惠券状态变为已使用
            UserCoupon::where('id',$coupon_id)->update(['status'=>'1']);
570
            // 待支付自动关闭
何书鹏 authored
571
            $close_minue = 2;
572
            \think\Queue::later(($close_minue * 60), '\app\api\job\OrderAutoOper@autoClose', ['order_id' => $ordermodel->id], 'temporaryfood');
李忠强 authored
573 574 575 576 577 578 579 580 581 582 583 584 585 586
            Db::commit();
        }catch (PDOException $e){
            Db::rollback();
            $this->error($e->getMessage());
        }

        $this->success('下单成功',$ordermodel->id);
    }

    /**
     * @ApiTitle    (支付订单)
     * @ApiMethod   (POST)
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     * @ApiParams   (name="id", type="integer", required=true, description="订单ID")
何书鹏 authored
587
     * @ApiParams   (name="openid", type="string", required=false, description="代付人openid")
李忠强 authored
588 589 590 591 592 593 594 595
     * @ApiReturn   ({
    'code':'1',
    'msg':'返回成功'
    })
     */
    public function pay()
    {
        $order_id = $this->request->post('id');
何书鹏 authored
596
        $openid = $this->request->post('openid');
何书鹏 authored
597
        empty($order_id) && $this->error('缺少必需参数');
李忠强 authored
598 599 600 601

        $model = new \app\api\model\Order();
        $order = $model::get($order_id);
        if (!$order) $this->error('订单不存在');
何书鹏 authored
602 603
//        $third = Third::get(['user_id'=>$this->auth->id]);
        $third = Third::alias('a')
何书鹏 authored
604
            ->join('user b','b.id = a.user_id')
何书鹏 authored
605
            ->where('a.user_id',$order['user_id'])
何书鹏 authored
606 607
            ->field('a.openid')
            ->find();
何书鹏 authored
608 609
        if (!$third) $this->error('下单人未注册');
李忠强 authored
610 611
        $params = [
            'type'         => 'wechat',
李忠强 authored
612
            'orderid'      => $order['order_no'],
李忠强 authored
613
            'title'        => '订单号-'.$order['order_no'],
何书鹏 authored
614 615
            'amount'       => $order['pay_price'],
//            'amount'       => 0.01,
李忠强 authored
616
            'method'       => 'miniapp',
何书鹏 authored
617
            'openid'       => !empty($openid) ? $openid : $third['openid'],
李忠强 authored
618 619 620 621
            'notifyurl'    => $this->request->domain().'/api/notify/orderNotify/type/wechat',
            'returnurl'    => '',
        ];
        $result = Service::submitOrder($params);
何书鹏 authored
622 623
//        $order->pay_user_id = $this->auth->id;
//        $order->isUpdate()->save();
李忠强 authored
624 625 626
        $this->success('支付信息',$result);
    }
李忠强 authored
627 628 629 630 631 632 633 634 635 636 637 638 639 640 641 642 643

    /**
     * @ApiTitle    (确认收货)
     * @ApiMethod   (POST)
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     * @ApiParams   (name="id", type="integer", required=true, description="订单ID")
     * @ApiReturn   ({
    'code':'1',
    'msg':'返回成功'
    })
     */
    public function takeover()
    {
        $order_id = $this->request->post('id');
        if (!is_numeric($order_id)) $this->error('参数不合法');

        $model = new \app\api\model\Order();
何书鹏 authored
644 645 646 647 648 649 650 651 652 653
        $order = $model->get($order_id);
        empty($order) && $this->error('订单不存在');
        $order['receipt_status'] == '20' && $this->error('订单已收货,请勿重复提交');
        $rider_order = RiderOrder::where('order_id',$order_id)->find();
        empty($rider_order) && $this->error('骑手订单不存在');

        // 修改订单信息
        $order->rider_status = '20'; //送达状态:已送达
        $order->receipt_status = '20'; //收货状态:已收货
        $order->receipt_time = time(); //收货时间
何书鹏 authored
654
        $order->order_status = '30'; //订单状态变为已完成
何书鹏 authored
655 656 657 658 659 660
        $order->save();
        // 修改配送单信息
        $rider_order->status = '2'; //已送达
        $rider_order->sendtime = time(); //送达时间
        $rider_order->save();
        // 发放订单运费
何书鹏 authored
661
        \app\common\model\User::money($order->rider_price,$order->rider_user_id,'订单运费');
何书鹏 authored
662
李忠强 authored
663 664 665 666 667 668 669 670 671 672 673 674 675 676 677 678 679 680 681 682
        $this->success('收货成功');
    }


    /**
     * @ApiTitle    (提醒发货)
     * @ApiMethod   (POST)
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     * @ApiParams   (name="id", type="integer", required=true, description="订单ID")
     * @ApiReturn   ({
    'code':'1',
    'msg':'返回成功'
    })
     */
    public function remind()
    {
        $order_id = $this->request->post('id');
        if (!is_numeric($order_id)) $this->error('参数不合法');

        $model = new \app\api\model\Order();
何书鹏 authored
683
        $model->where('id',$order_id)->update(['remind_status'=>'20']);
李忠强 authored
684 685 686 687 688 689 690 691 692 693 694 695 696 697 698 699 700 701 702
        $this->success('提醒成功');
    }


    /**
     * @ApiTitle    (取消订单)
     * @ApiMethod   (POST)
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     * @ApiParams   (name="id", type="integer", required=true, description="订单ID")
     * @ApiReturn   ({
    'code':'1',
    'msg':'返回成功'
    })
     */
    public function cancelOrder()
    {
        $order_id = $this->request->post('id');
        if (!is_numeric($order_id)) $this->error('参数不合法');
        $model = new \app\api\model\Order();
李忠强 authored
703
        $order = $model->where('id',$order_id)->find();
704 705
        empty($order) && $this->error('订单不存在');
何书鹏 authored
706
        $res = self::cancelOrderAction($order);
707 708 709 710 711 712 713 714 715
        $res['code'] == 0 && $this->error($res['msg']);

        $this->success('取消成功');
    }

    /**
     * 取消订单操作
     * @ApiInternal
     */
何书鹏 authored
716
    public static function cancelOrderAction($order)
717
    {
何书鹏 authored
718
        \think\Log::write('订单数据:'.json_encode($order));
719 720 721
        if($order['freight_status'] == '20'){
            return ['code' => 0,'msg' => '订单已发货无法取消'];
        }
李忠强 authored
722 723
        $goodsmodel = new \app\api\model\OrderGoods();
        $skumodel = new \app\api\model\GoodsSpec();
724 725 726 727 728 729 730 731 732

        Db::startTrans();
        try {
            // 增加库存
            $list = $goodsmodel->where('order_id',$order['id'])->select();
            foreach ($list as $key => $value){
                if ($value['deduct_stock_type'] == 10){
                    $skumodel->where('goods_spec_id',$value['goods_spec_id'])->setInc('stock_num',$value['total_num']);
                }
李忠强 authored
733
            }
734 735 736 737 738

            // 已支付就退款
            if($order['pay_status'] == '20'){
                $config = Service::getConfig('wechat');
                $config['app_id'] = $config['miniapp_id'];
何书鹏 authored
739
                $config['notify_url'] = request()->domain().'api/notify/refund/type/wechat';
740 741 742 743
                $config['return_url'] = '';
                $wechat = Pay::wechat($config);
                $refund_no = 'LQ-'.time().mt_rand(10000,99999);
                $param = [
李忠强 authored
744 745
//            'total_fee' => $order['pay_price'],
//            'refund_fee' => $order['pay_price'],
746 747 748 749 750 751 752 753 754 755 756 757 758 759 760 761 762 763 764 765 766 767 768 769 770
                    'total_fee' => 1,
                    'refund_fee' => 1,
                    'out_trade_no' => $order['order_no'],
                    'out_refund_no' => $refund_no
                ];
                $wechat->refund($param);
                $order->refund_no = $refund_no;
                $order->refund_time = time();
            }
            // 状态变为已取消
            $order->order_status = '20';
            $order->status = 'hidden';
            $order->isUpdate(true)->save();

            // 如果使用了优惠券,就把优惠券状态变为待使用或者已过期
            if($order['user_coupon_id'] > 0){
                $user_coupon = UserCoupon::get($order['user_coupon_id']);
                if($user_coupon){
                    $status = $user_coupon['endtime'] > time() ? '0' : '2';
                    $user_coupon->save(['status'=>$status]);
                }
            }
            Db::commit();
        }catch (PDOException $e){
            Db::rollback();
771
            return ['code' => 0,'msg' => $e->getMessage()];
何书鹏 authored
772
        }
773
        return ['code' => 1,'msg' => '取消成功'];
李忠强 authored
774 775 776
    }

    /**
李忠强 authored
777
     * @ApiTitle    (评价订单详情页)
李忠强 authored
778 779 780 781 782
     * @ApiMethod   (POST)
     * @ApiParams   (name="id", type="integer", required=true, description="订单ID")
     * @ApiReturn   ({
    'code':'1',
    'msg':'返回成功'
李忠强 authored
783 784 785 786 787 788
    'data':
        order_id:订单id
        goods_name:商品名称
        goods_id:商品id
        goods_attr:规格描述
        image_text:商品图片
李忠强 authored
789 790
    })
     */
李忠强 authored
791
    public function commentOrderDetail()
李忠强 authored
792 793 794
    {
        $order_id = $this->request->post('id');
        if (!is_numeric($order_id)) $this->error('订单id参数不合法');
李忠强 authored
795 796 797 798 799 800 801 802 803 804 805 806 807 808 809 810 811 812 813 814 815 816 817 818 819 820 821 822 823 824

        $model = new \app\api\model\OrderGoods();
        $list = $model
            ->where('order_id',$order_id)
            ->field('order_id,goods_name,goods_id,goods_attr,image')
            ->select();

        $this->success('商品列表',$list);
    }

    /**
     * @ApiTitle    (评价订单)
     * @ApiMethod   (POST)
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     * @ApiParams   (name="data_json", type="string", required=true, description="评价数据 json对象")
     * @ApiParams   (name="order_id", type="integer", required=false, description="订单ID 不传")
     * @ApiParams   (name="score", type="integer", required=false, description="评价分数 不传")
     * @ApiParams   (name="comment", type="string", required=false, description="评价内容 不传")
     * @ApiParams   (name="goods_id", type="string", required=false, description="商品id 不传")
     * @ApiParams   (name="images", type="string", required=false, description="评价图片逗号隔开 不传")
     * @ApiReturn   ({
    'code':'1',
    'msg':'返回成功'
    })
     */
    public function commentOrder()
    {
        $data = $this->request->post('data_json');
        if (!$data) $this->error('data_json参数缺失');
何书鹏 authored
825
        $data = json_decode(htmlspecialchars_decode($data),true);
李忠强 authored
826 827 828 829 830 831 832 833 834 835 836 837 838 839 840 841 842 843 844 845
        $params = [];
        $orderids = [];
        foreach ($data as $key => $value){
            if (!is_numeric($value['order_id'])) $this->error('订单id参数不合法');
            if (!is_numeric($value['goods_id'])) $this->error('商品id参数不合法');
            if (!is_numeric($value['score']) || $value['score']>5 || $value['score']<1) $this->error('评价分数不合法');
            if (!$value['comment']) $this->error('请填写评价内容');
            if ($value['images']){
                $arr = explode(',',$value['images']);
                if (count($arr) > 3) $this->error('请上传最多3张评价图片');
            }
            $params[] = [
                'user_id' => $this->auth->id,
                'order_id' => $value['order_id'],
                'goods_id' => $value['goods_id'],
                'comment' => $value['comment'],
                'images' => $value['images'],
                'score' => $value['score'],
            ];
            $orderids[] = $value['order_id'];
李忠强 authored
846 847
        }
李忠强 authored
848
        $ordermodel = new \app\api\model\Order();
何书鹏 authored
849
        $ordermodel->whereIn('id',$orderids)->update(['comment_status'=>'20','comment_time'=>time()]);
李忠强 authored
850 851 852
        $commentmodel = new GoodsComment();
        $commentmodel->isUpdate(false)->saveAll($params);
        $this->success('评价成功');
李忠强 authored
853 854
    }
李忠强 authored
855 856 857 858 859 860 861 862 863 864 865 866 867 868 869 870 871 872 873 874

    /**
     * @ApiTitle    (删除订单)
     * @ApiMethod   (POST)
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     * @ApiParams   (name="order_id", type="integer", required=true, description="订单ID")
     * @ApiReturn   ({
    'code':'1',
    'msg':'SUCCESS'
    })
     */
    public function delOrder()
    {
        $order_id = $this->request->post('order_id');
        if (!is_numeric($order_id)) $this->error('order_id参数不合法');
        $ordermodel = new \app\api\model\Order();
        $ordermodel->where('id',$order_id)->isUpdate()->save(['status'=>'hidden']);
        $this->success('SUCCESS');
    }
何书鹏 authored
875 876 877 878 879 880 881 882 883 884 885 886 887
    /**
     * @ApiTitle    (订单数量)
     * @ApiMethod   (GET)
     * @ApiHeaders (name=token, type=string, required=true, description="请求的Token")
     * @ApiReturn({
        "code": 1,
        "msg": "订单数量",
        "time": "1609138878",
        "data": {
            "nopay": 2, //待支付(数量)
            "nosend": 3, //待发货(数量)
            "noget": 0, //待收货(数量)
            "nocomment": 0, //待评价(数量)
何书鹏 authored
888
            "coupon": 0, //待使用优惠券(数量)
何书鹏 authored
889 890 891 892 893 894 895 896 897 898 899 900 901 902 903 904 905 906 907 908 909 910 911 912 913 914 915 916 917
        }
    })
     */
    public function statusNum () {
        $model = new \app\api\model\Order();
        $nopay = $model->where([
                'status' => 'normal',
                'user_id' => $this->auth->id,
                'pay_status' => '10',
            ])->count();
        $nosend = $model->where([
            'status' => 'normal',
            'user_id' => $this->auth->id,
            'pay_status' => '20',
            'freight_status' => '10',
        ])->count();
        $noget = $model->where([
            'status' => 'normal',
            'user_id' => $this->auth->id,
            'pay_status' => '20',
            'freight_status' => '20',
            'receipt_status' => '10',
        ])->count();
        $nocomment = $model->where([
            'status' => 'normal',
            'user_id' => $this->auth->id,
            'pay_status' => '20',
            'freight_status' => '20',
            'receipt_status' => '20',
何书鹏 authored
918
            'comment_status' => '10'
何书鹏 authored
919
        ])->count();
何书鹏 authored
920 921 922 923 924
        $coupon = UserCoupon::where([
            'user_id' => $this->auth->id,
            'status' => '0'
        ])->count();
        $this->success('订单数量', compact('nopay','nosend','noget','nocomment','coupon'));
何书鹏 authored
925
    }
李忠强 authored
926
}