审查视图

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 52

    /**
     * @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已完成
            "total_sum": 0, 商品总数量
何书鹏 authored
53 54
            "goods": [{
                "goods_id": 1, 商品ID
李忠强 authored
55 56 57 58 59
                "goods_name": "asdasd", 商品名
                "goods_attr": "1", 规格名
                "total_num": 0, 数量
                "total_price": "0.00", 价格
                "image_text": "" 图片
何书鹏 authored
60
                "stock_num": 68, 商品总库存
何书鹏 authored
61
            }],
李忠强 authored
62 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
            "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
91
                    'fa_litestore_order.pay_status' => '20',
李忠强 authored
92 93 94 95 96 97 98
                    'fa_litestore_order.freight_status' => '10',
                ];
                break;
            case 4:
                $where = [
                    'fa_litestore_order.status' => 'normal',
                    'fa_litestore_order.user_id' => $this->auth->id,
何书鹏 authored
99 100
                    'fa_litestore_order.pay_status' => '20',
                    'fa_litestore_order.freight_status' => '20',
李忠强 authored
101 102 103 104 105 106 107
                    'fa_litestore_order.receipt_status' => '10',
                ];
                break;
            default :
                $where = [
                    'fa_litestore_order.status' => 'normal',
                    'fa_litestore_order.user_id' => $this->auth->id,
何书鹏 authored
108 109
                    'fa_litestore_order.pay_status' => '20',
                    'fa_litestore_order.freight_status' => '20',
李忠强 authored
110
                    'fa_litestore_order.receipt_status' => '20',
何书鹏 authored
111
                    'fa_litestore_order.comment_status' => '10',
李忠强 authored
112 113 114 115 116 117 118 119 120 121 122 123 124 125
                ];
                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
126 127 128
                    // 总库存
                    $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
129 130 131 132 133 134 135 136 137 138 139 140 141
                }
                $item['total_sum'] = $sum;
                $item->visible([
                    'goods','total_sum','order_no','id','pay_price',
                    'discount_price','pay_status','order_status','receipt_status',
                    'freight_status'
                ]);
            });
        $this->success('订单列表',$list);
    }

    /**
     * @ApiTitle    (下单页面)
142
     * @ApiSummary ([{id:113 goods_id:22 goods_sku_id:106 number:2} {id:114 goods_id:23 goods_sku_id:66 number:2}])
李忠强 authored
143 144 145
     * @ApiMethod   (POST)
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     * @ApiParams   (name="data_json", type="string", required=true, description="下单的商品json数据")
146
     * @ApiParams   (name="id", type="integer", required=false, description="购物车或我常买id 此值不传 json数组注释用")
李忠强 authored
147 148 149 150 151 152 153 154 155
     * @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": [
            {
156
            "id": 113, 购物车或我常买id
李忠强 authored
157 158 159 160 161 162 163 164 165 166
            "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": "", 图片
            },
            {
167
            "id": 114,
李忠强 authored
168 169 170 171 172 173 174 175 176 177 178 179 180 181 182
            "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
183
        $json = $this->request->param('data_json');
李忠强 authored
184
        if (!$json) $this->error('data_json参数不能为空');
李忠强 authored
185
        $json = str_replace('&quot;','"',$json);
李忠强 authored
186 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
//        $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
216 217 218
            if(!empty($value['id'])){
                $goods['id'] = $value['id'];
            }
李忠强 authored
219 220 221
            $goods_array[] = $goods;
            $sum_price = bcadd($sum_price,bcmul($sku['goods_price'],$value['number'],2),2);
        }
李忠强 authored
222 223 224 225 226 227 228 229 230 231
        $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
232
            $express_price = $this->distancePrice($lat1,$lng1,$lat2,$lng2,$sum_price);
李忠强 authored
233 234 235 236 237
            if ($express_price === false)  $express_price = 0;
        }else{
            $address = [];
        }
        $sum_price += $express_price;
李忠强 authored
238
        $this->success('下单页详情',['list'=>$goods_array,'price'=>$sum_price,'order_price'=>$sum_price-$express_price,'express_price'=>$express_price,'address'=>$address]);
李忠强 authored
239 240 241
    }

    /**
李忠强 authored
242 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
     * @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
283
            ->where('id',$order_id)
李忠强 authored
284 285 286 287 288 289 290
            ->find();
        $user = \app\api\model\User::get($order['user_id']);
        $user->visible(['nickname']);
        $this->success('下单页详情',['detail'=>$order,'user'=>$user]);
    }

    /**
李忠强 authored
291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310
     * @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('规格已失效,请重新选择');
311 312
        $cart_number = \app\api\model\Cart::where('sku_id',$sku_id)->sum('number');
        if ($sku['stock_num'] < $number+$cart_number) $this->error('已超出最大库存');
李忠强 authored
313 314 315 316
        $this->success('SUCCESS');
    }

    /**
李忠强 authored
317 318 319 320
     * @ApiTitle    (计算运费)
     * @ApiMethod   (POST)
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     * @ApiParams   (name="address_id", type="integer", required=true, description="地址id")
何书鹏 authored
321
     * @ApiParams   (name="goods_total_price", type="string", required=true, description="商品总价")
李忠强 authored
322 323
     * @ApiReturn   ({
    'code':'1',
李忠强 authored
324
    'msg':'计算运费'
李忠强 authored
325
    'data':
何书鹏 authored
326 327
        "price": "37574.00", 总价
        "delivery_threshold": "20.00", 起送价
李忠强 authored
328 329 330 331 332
    })
     */
    public function freightCalculation()
    {
        $address_id = $this->request->post('address_id');
何书鹏 authored
333
        $goods_total_price = $this->request->post('goods_total_price');
李忠强 authored
334
        if (!$address_id) $this->error('请选择地址');
何书鹏 authored
335
        if (!$goods_total_price) $this->error('请计算商品总价');
李忠强 authored
336 337 338 339 340 341 342 343
        $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
344
        $sum_price = $this->distancePrice($lat1,$lng1,$lat2,$lng2,$goods_total_price);
李忠强 authored
345
        if ($sum_price === false) $this->error('地址超出配送距离');
何书鹏 authored
346 347 348 349 350
        $delivery_threshold = Db::name('litestore_rider_rule')->value('delivery_threshold');
        $this->success('计算运费',[
            'price' => $sum_price,
            'delivery_threshold' => $delivery_threshold
        ]);
李忠强 authored
351 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
    }

    /**
     * @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
379 380 381
        $model = new UserCoupon();

        // 更新已过期状态
何书鹏 authored
382
        $model->where('status','0')->where('user_id',$this->auth->id)->where('endtime','<',time())->update(['status'=>'2']);
何书鹏 authored
383
李忠强 authored
384 385
        $price = $this->request->post('price');
        if (!is_numeric($price)) $this->error('订单价格不合法');
何书鹏 authored
386
李忠强 authored
387 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
        $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
415 416 417
        $json = $this->request->param('data_json');
        $coupon_id = $this->request->param('coupon_id');
        $address_id = $this->request->param('address_id');
李忠强 authored
418 419 420 421 422 423 424 425 426 427 428 429
        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
430
                ->where('status','0')
李忠强 authored
431 432 433
                ->find();
            if (!$coupon) $this->error('优惠券不存在');
        }
李忠强 authored
434
        $json = str_replace('&quot;','"',$json);
李忠强 authored
435 436 437 438 439 440
        $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
441
        $cartmodel = new \app\api\model\Cart();
李忠强 authored
442 443 444 445 446 447 448 449 450 451 452 453 454
        $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
455
            if ($sku['stock_num'] < $value['number']) $this->error('库存不足');
李忠强 authored
456 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
            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
492
        $distance_price = $this->distancePrice($lat1,$lng1,$lat2,$lng2,$sum_price);
李忠强 authored
493 494
        if ($distance_price === false) $this->error('地址超出配送距离');
何书鹏 authored
495
        if ($coupon !== [] && $coupon['full_price'] > $sum_price) $this->error('优惠券不可使用');
李忠强 authored
496
何书鹏 authored
497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513
        // 给骑手佣金
        $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
514 515 516 517 518 519 520 521 522 523 524 525 526 527 528
        // 订单地址
        $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
529
李忠强 authored
530 531 532 533 534
        // 订单信息
        $order = [
            'order_no' => $order_no,
            'total_price' => $sum_price,  // 订单总价
            'discount_price' => $couponprice,  // 优惠价格
535
            'pay_price' => bcsub($sum_price,$couponprice,2),  // 支付总价
李忠强 authored
536
            'express_price' => $distance_price,  // 骑手费用
537
            'user_id' => $user_id,
何书鹏 authored
538 539
            'user_coupon_id' => $coupon_id > 0 ? $coupon_id : 0,
            'rider_price' => $rider_price
李忠强 authored
540 541 542 543 544 545 546 547
        ];

        // 添加订单
        try {
            Db::startTrans();
            $ordermodel->save($order);
            foreach ($goods_array as $key => &$value){
                $value['order_id'] = $ordermodel->id;
李忠强 authored
548 549 550 551
                // 减少库存
                if ($value['deduct_stock_type'] == 10){
                    $skumodel->where('goods_spec_id',$value['goods_spec_id'])->setDec('stock_num',$value['total_num']);
                }
李忠强 authored
552 553 554 555
            }
            $ordergoodsmodel->saveAll($goods_array);
            $order_address['order_id'] = $ordermodel->id;
            $orderaddressmodel->save($order_address);
李忠强 authored
556 557 558 559 560 561 562 563 564 565 566
            // 删除购物车
            $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();
567 568
            // 如果使用了优惠券,就把优惠券状态变为已使用
            UserCoupon::where('id',$coupon_id)->update(['status'=>'1']);
569
            // 待支付自动关闭
何书鹏 authored
570
            $close_minue = 2;
571
            \think\Queue::later(($close_minue * 60), '\app\api\job\OrderAutoOper@autoClose', ['order_id' => $ordermodel->id], 'temporaryfood');
李忠强 authored
572 573 574 575 576 577 578 579 580 581 582 583 584 585
            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
586
     * @ApiParams   (name="openid", type="string", required=false, description="代付人openid")
李忠强 authored
587 588 589 590 591 592 593 594
     * @ApiReturn   ({
    'code':'1',
    'msg':'返回成功'
    })
     */
    public function pay()
    {
        $order_id = $this->request->post('id');
何书鹏 authored
595
        $openid = $this->request->post('openid');
何书鹏 authored
596
        empty($order_id) && $this->error('缺少必需参数');
李忠强 authored
597 598 599 600

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

    /**
     * @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
643 644 645 646 647 648 649 650 651 652
        $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
653
        $order->order_status = '30'; //订单状态变为已完成
何书鹏 authored
654 655 656 657 658 659
        $order->save();
        // 修改配送单信息
        $rider_order->status = '2'; //已送达
        $rider_order->sendtime = time(); //送达时间
        $rider_order->save();
        // 发放订单运费
何书鹏 authored
660
        \app\common\model\User::money($order->rider_price,$order->rider_user_id,'订单运费');
何书鹏 authored
661
李忠强 authored
662 663 664 665 666 667 668 669 670 671 672 673 674 675 676 677 678 679 680 681
        $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
682
        $model->where('id',$order_id)->update(['remind_status'=>'20']);
李忠强 authored
683 684 685 686 687 688 689 690 691 692 693 694 695 696 697 698 699 700 701
        $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
702
        $order = $model->where('id',$order_id)->find();
703 704
        empty($order) && $this->error('订单不存在');
何书鹏 authored
705
        $res = self::cancelOrderAction($order);
706 707 708 709 710 711 712 713 714
        $res['code'] == 0 && $this->error($res['msg']);

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

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

        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
732
            }
733 734 735 736 737

            // 已支付就退款
            if($order['pay_status'] == '20'){
                $config = Service::getConfig('wechat');
                $config['app_id'] = $config['miniapp_id'];
何书鹏 authored
738
                $config['notify_url'] = request()->domain().'api/notify/refund/type/wechat';
739 740 741 742
                $config['return_url'] = '';
                $wechat = Pay::wechat($config);
                $refund_no = 'LQ-'.time().mt_rand(10000,99999);
                $param = [
李忠强 authored
743 744
//            'total_fee' => $order['pay_price'],
//            'refund_fee' => $order['pay_price'],
745 746 747 748 749 750 751 752 753 754 755 756 757 758 759 760 761 762 763 764 765 766 767 768 769
                    '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();
770
            return ['code' => 0,'msg' => $e->getMessage()];
何书鹏 authored
771
        }
772
        return ['code' => 1,'msg' => '取消成功'];
李忠强 authored
773 774 775
    }

    /**
李忠强 authored
776
     * @ApiTitle    (评价订单详情页)
李忠强 authored
777 778 779 780 781
     * @ApiMethod   (POST)
     * @ApiParams   (name="id", type="integer", required=true, description="订单ID")
     * @ApiReturn   ({
    'code':'1',
    'msg':'返回成功'
李忠强 authored
782 783 784 785 786 787
    'data':
        order_id:订单id
        goods_name:商品名称
        goods_id:商品id
        goods_attr:规格描述
        image_text:商品图片
李忠强 authored
788 789
    })
     */
李忠强 authored
790
    public function commentOrderDetail()
李忠强 authored
791 792 793
    {
        $order_id = $this->request->post('id');
        if (!is_numeric($order_id)) $this->error('订单id参数不合法');
李忠强 authored
794 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

        $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
824
        $data = json_decode(htmlspecialchars_decode($data),true);
李忠强 authored
825 826 827 828 829 830 831 832 833 834 835 836 837 838 839 840 841 842 843 844
        $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
845 846
        }
李忠强 authored
847
        $ordermodel = new \app\api\model\Order();
何书鹏 authored
848
        $ordermodel->whereIn('id',$orderids)->update(['comment_status'=>'20','comment_time'=>time()]);
李忠强 authored
849 850 851
        $commentmodel = new GoodsComment();
        $commentmodel->isUpdate(false)->saveAll($params);
        $this->success('评价成功');
李忠强 authored
852 853
    }
李忠强 authored
854 855 856 857 858 859 860 861 862 863 864 865 866 867 868 869 870 871 872 873

    /**
     * @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
874 875 876 877 878 879 880 881 882 883 884 885 886
    /**
     * @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
887
            "coupon": 0, //待使用优惠券(数量)
何书鹏 authored
888 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 918
        }
    })
     */
    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',
            'order_status' => '10'
        ])->count();
何书鹏 authored
919 920 921 922 923
        $coupon = UserCoupon::where([
            'user_id' => $this->auth->id,
            'status' => '0'
        ])->count();
        $this->success('订单数量', compact('nopay','nosend','noget','nocomment','coupon'));
何书鹏 authored
924
    }
李忠强 authored
925
}