all(); $param['poi_id'] = $request->user['store_id']; $productType = $this->goodsService->productType(); $data = $this->service->setModel()->getList($param,['product' => function($query) use($productType){ $query->field("product_id,product_name,product_type,is_new,price,line_price")->append(['types'])->withAttr(['types' => function($query,$resp) use($productType){ $productTypeArr = []; foreach ($productType as $val) { $productTypeArr[$val['key']] = $val['name']; } return $productTypeArr[$resp['product_type']]??''; }]); },'user' => function($query){ $query->field("openid,nickname,avatar"); },"star" => function($query){ $query->field("uid,nick_name,avatar_url,unique_id"); }],true,['end_time','refund_num'],["end_time" => function ($resp,$next) { return timeDiff(strtotime("+30 minutes",strtotime($next['create_at'])),time()); },'refund_num' => function($resp,$next){ if ($next['status'] == 6) { return (new SaasOrderItem)->where(['order_sn' => $next['order_sn'],'status' => 2])->count()??0; } return 0; }]); return successTrans("success.data",pageFormat($data),200); } catch (\Throwable $throwable) { return error($throwable->getMessage()); } } #[GetMapping('detail')] public function getOrderDetail(Request $request): Response { try { $param = $this->_valid([ "order.require" => trans("empty.require"), ],$request->method()); if (!is_array($param)) return error($param); $order = $this->model->where("out_order_no",$param['order'])->with(['product','poi','user','address' => function($query){ $query->with(['goods']); },'express','refund'])->findOrEmpty(); if ($order->isEmpty()) return errorTrans("empty.data"); if ($order['poi_id'] <> $request->user['store_id'] && $request->user['is_super'] == 0) return errorTrans("empty.data"); $order['end_time'] = timeDiff(strtotime("+30 minutes",strtotime($order['create_at'])),time()); return successTrans("success.data",$order->toArray()); } catch (\Throwable $throwable) { return error($throwable->getMessage()); } } #[PostMapping('save')] public function setOrderData(Request $request): Response { try { $param = $this->_valid([ "order.require" => trans("empty.require"), "field.require" => trans("empty.require"), "val.require" => trans("empty.require"), ],$request->method()); if (!is_array($param)) return error($param); $order = $this->model->where("out_order_no",$param['order'])->with(['product','poi','user','address'])->findOrEmpty(); if ($order->isEmpty()) return errorTrans("empty.data"); if ($order['poi_id'] <> $request->user['store_id'] && $request->user['is_super'] == 0) return errorTrans("empty.data"); $update = []; if ($param['field'] == 'status' && $param['val'] == 1) { $update['express_status'] = 0; (new SaasOrderAddress)->where(["openid" => $order['openid'],'order_sn' => $order['out_order_no']])->delete(); } if ($param['field'] == 'is_error' && $param['val'] == 1) { $update['express_status'] = 0; $update['error_at'] = getDateFull(); } $update[$param['field']] = $param['val']; $state = $order->save($update); if (!$state) return errorTrans("error.data"); return successTrans("success.data"); } catch (\Throwable $throwable) { return error($throwable->getMessage()); } } /** * 小程序手动核销 * @param Request $request * @return Response */ #[PostMapping('doneMini')] public function doneOrderMini(Request $request): Response { try { $param = $this->_valid([ "order.require" => trans("empty.require") ],$request->method()); if (!is_array($param)) return error($param); $order = $this->model->where("out_order_no",$param['order'])->with(['product','poi','user'])->findOrEmpty(); if ($order->isEmpty()) return errorTrans("empty.data"); if ($order['status'] <> 7) return error("该订单状态不支持核销"); if ($order['is_done'] <> 1) return error("该订单状态不支持核销"); if ($request->user['store_id'] <> $order['poi_id'] && $request->user['is_super'] == 0) return errorTrans("empty.data"); $orderExpress = (new SaasOrderExpress)->where("order_sn",$order['out_order_no'])->findOrEmpty(); if ($orderExpress->isEmpty()) return error("订单尚未发货"); if (!empty($order['error_at'])) { if (strtotime("+24 hour",strtotime($order['error_at'])) < time()) return error("新订单需24小时后方可核销"); } [$state,$expressData] = (new LifeWeb)->getExpressData($orderExpress['express_sn'],$orderExpress['mobile']); if (!$state) return error("查询物流失败,请联系管理员"); if (!in_array($expressData['logisticsStatusDesc'],['派件中',"已签收","已代收"])) return error("当前物流状态不允许核销"); $startTime = $order['poi']['order_start']??'09:00'; $endTime = $order['poi']['order_end']??'22:30'; $startTimeStamp = strtotime(date("Y-m-d {$startTime}:00")); $endTimeStamp = strtotime(date("Y-m-d {$endTime}:00")); if (time() > $startTimeStamp && time() < $endTimeStamp) { $data = (new OrderData)->config([ "appid" => sConf("wechat.mini_appid"), "secret" => sConf("wechat.mini_secret") ])->token()->verifyOrder($order->toArray()); if (empty($data['verify_results'])) return error($data['description']); // 核销失败 $order->status = 2; $order->express_status = 3; $order->done_at = getDateFull(); $order->save(); (new SaasOrderItem)->where(['order_sn'=>$order['order_sn'],'status'=>1])->update(['status'=>3]); (new SaasOrderVerify)->insertGetId([ "poi_id" => $order['poi_id'], "order_sn" => $order['order_sn'], "money" => $order['price'], "certificate_id" => $data['verify_results'][0]['certificate_id']??'0', "verify_id" => $data['verify_results'][0]['verify_id']??'0', ]); return success("核销成功"); } else { return error("当前时间段不支持核销"); } } catch (\Throwable $throwable) { return error($throwable->getMessage()); } } /** * 手动核销 - 废弃 * @param Request $request * @return Response */ #[PostMapping('done')] public function doneOrder(Request $request): Response { try { $param = $this->_valid([ "id.require" => trans("empty.require") ],$request->method()); if (!is_array($param)) return error($param); $order = $this->model->where("order_sn",$param['id'])->with(['product','poi','user'])->findOrEmpty(); if ($order->isEmpty()) return errorTrans("empty.data"); if ($order['poi_id'] <> $request->user['store_id']) return errorTrans("empty.data"); if ($order['status'] <> 1) return error("该订单状态不支持核销"); $store = (new SaasStore)->where("poi_id",$request->user['store_id'])->findOrEmpty(); if ($store->isEmpty()) return errorTrans("error.data"); // 获取到订单encrypted_code $orderCode = (new OrderData)->config([ "appid" => sConf("wechat.appid"), "secret" => sConf("wechat.secret"), "account" => sConf("wechat.shop_id"), ])->token()->getCertificate($order['order_sn'],$store['store_id']); if (empty($orderCode['certificates'])) return error("获取订单数据失败"); if (!isset($orderCode['certificates'][0]['encrypted_code'])) return error("获取订单数据失败"); if ($orderCode['certificates'][0]['status'] <> 1) return error("该订单状态不支持核销"); // 核销订单 $orderDone = (new OrderData)->config([ "appid" => sConf("wechat.appid"), "secret" => sConf("wechat.secret"), "account" => sConf("wechat.shop_id"), ])->token()->verifyCertificate([ "account_id" => $store['store_id'], "pay_sn" => $order['pay_sn'], "encrypted_code" => $orderCode['certificates'][0]['encrypted_code'], "order_id" => $order['order_sn'], "poi_id" => $order['poi_id'] ]); if (empty($orderDone['verify_results'])) return error("核销失败"); if (!isset($orderDone['verify_results'][0]['verify_id'])) return error("核销失败"); if (!isset($orderDone['verify_results'][0]['certificate_id'])) return error("核销失败"); $order->status = 2; $order->verify_id = $orderDone['verify_results'][0]['verify_id']; $order->certificate_id = $orderDone['verify_results'][0]['certificate_id']; $order->done_at = getDateFull(); $state = $order->save(); if (!$state) return error("核销失败"); return success("核销成功"); } catch (\Throwable $throwable) { return error($throwable->getMessage()); } } /** * 三级城市信息 * @param Request $request * @return Response */ #[GetMapping("city")] public function getCityJson(Request $request): Response { try { $data = json_decode(file_get_contents(base_path()."/city.json"),true); return successTrans("success.data",$data); } catch (\Throwable $throwable) { return error($throwable->getMessage()); } } #[PostMapping('address/edit')] public function editOrderAddress(Request $request): Response { try { $param = $this->_valid([ "nickname.require" => trans("empty.require"), "mobile.require" => trans("empty.require"), "mobile.mobile" => trans("error.mobile"), "city.require" => trans("empty.require"), "address.require" => trans("empty.require"), "goods.require" => trans("empty.require"), "cityLabel.default" => "", "id.require" => trans("empty.require"), ],$request->method()); if (!is_array($param)) return error($param); $address = (new SaasOrderAddress)->where("id",$param["id"])->findOrEmpty(); if ($address->isEmpty()) return error("数据不存在"); if (!empty($param['cityLabel'])) { $param['city_text'] = implode("",$param['cityLabel']); } $goodsJson = json_decode($param['goods'],true); $param['goods'] = $goodsJson[0]['id']; $param['city_code'] = empty($param['city'])?[]:json_encode($param['city']); $state = $address->setAutoData($param); if (!$state) return errorTrans("error.data"); return successTrans("success.data"); } catch (\Throwable $throwable) { return error($throwable->getMessage()); } } #[GetMapping('address/detail')] public function getOrderAddress(Request $request): Response { try { $param = $this->_valid([ "order.require" => trans("empty.require") ],$request->method()); if (!is_array($param)) return error($param); $detail = (new SaasOrderAddress)->where("order_sn",$param['order'])->with(['goods','orders' => function($query){ $query->field("out_order_no,life_goods_id"); }])->findOrEmpty(); if ($detail->isEmpty()) return error("该订单尚未预约"); return successTrans("success.data",$detail->toArray()); } catch (\Throwable $throwable) { return error($throwable->getMessage()); } } #[PostMapping('address')] public function setOrderAddress(Request $request): Response { try { $param = $this->_valid([ "nickname.require" => trans("empty.require"), "mobile.require" => trans("empty.require"), "mobile.mobile" => trans("error.mobile"), "city.require" => trans("empty.require"), "address.require" => trans("empty.require"), "cityLabel.require" => trans("empty.require"), "order.require" => trans("empty.require"), "goods.require" => trans("empty.require"), ],$request->method()); if (!is_array($param)) return error($param); $order = (new SaasOrder)->where("out_order_no",$param["order"])->with(['poi'])->findOrEmpty(); if ($order->isEmpty()) return error("关联订单错误"); if ($order['status'] <> 1) return error("关联订单错误"); $address = (new SaasOrderAddress)->where(['openid' => $order['openid'],'order_sn' => $param['order']])->findOrEmpty(); if (!$address->isEmpty()) return error("请勿重复提交"); $param['city_text'] = empty($param['cityLabel'])?'':implode("",$param['cityLabel']); $goodsJson = json_decode($param['goods'],true); $param['goods'] = $goodsJson[0]['id']; $address->insertGetId([ "openid" => $order['openid'], "order_sn" => $param['order'], "city_code" => empty($param['city'])?[]:json_encode($param['city']), "city_text" => $param['city_text'], "mobile" => $param['mobile'], "address" => $param['address'], "nickname" => $param['nickname'], "goods" => $param['goods'], ]); $order->status = 7; $order->express_status = 1; $state = $order->save(); if (!$state) return errorTrans("error.data"); return successTrans("success.data"); } catch (\Throwable $throwable) { return error($throwable->getMessage()); } } #[PostMapping("refund")] public function setOrderRefund(Request $request): Response { try { $param = $this->_valid([ "order.require" => trans("empty.require"), ],$request->method()); if (!is_array($param)) return error($param); $order = (new SaasOrder)->where("out_order_no",$param["order"])->with(['poi'])->findOrEmpty(); if ($order->isEmpty()) return error("关联订单错误"); if (!in_array($order['status'],[1,6,7,8])) return error("关联订单错误"); if (empty($order['item_order_id'])) return error("订单数据不完整"); $data = (new OrderData)->config([ "appid" => sConf("wechat.mini_appid"), "secret" => sConf("wechat.mini_secret"), ])->token()->refundOrderOp($order->toArray()); echo getDateFull()."==={$order["order_sn"]}===手动发起退款\n"; print_r($data); if (empty($data['refund_id'])) return error("发起退款失败,请联系管理员"); $order->status = 3; $order->refund_at = getDateFull(); $state = $order->save(); if (!$state) return errorTrans("error.data"); return successTrans("success.data"); } catch (\Throwable $throwable) { return error($throwable->getMessage()); } } #[PostMapping("black")] public function setOrderBlack(Request $request): Response { try { $param = $this->_valid([ "order.require" => trans("empty.require"), ],$request->method()); if (!is_array($param)) return error($param); $order = (new SaasOrder)->where("out_order_no",$param["order"])->with(['user'])->findOrEmpty(); if ($order->isEmpty()) return error("关联订单错误"); if ($order['user']['is_black'] == 1) return error("该用户已在黑名单,无需重复操作"); $state = (new SaasUserOpen)->where("openid",$order['openid'])->save(['is_black' => 1,'poi_id' => $order['poi_id']]); if (!$state) return errorTrans("error.data"); return successTrans("success.data"); } catch (\Throwable $throwable) { return error($throwable->getMessage()); } } #[PostMapping("express")] public function setExpressData(Request $request): Response { try { $param = $this->_valid([ "order.require" => trans("empty.require"), "express_sn.require" => trans("empty.require"), "express_name.require" => trans("empty.require"), ],$request->method()); if (!is_array($param)) return error($param); $order = $this->model->where("out_order_no",$param["order"])->findOrEmpty(); if ($order->isEmpty()) return error("关联订单错误"); $express = (new SaasOrderExpress)->where("order_sn",$param["order"])->findOrEmpty(); if (!$express->isEmpty()) return error("该订单已完成发货,请勿重复操作"); $usedOrder = (new SaasOrderExpress)->where('express_sn', $param['express_sn']) ->where('order_sn', '<>', $order["order_sn"]) // 排除自己 ->where('status', 0) // 只查未发货的 ->findOrEmpty(); if (!$usedOrder->isEmpty() && $usedOrder['openid'] != $order['openid']) { return error("该单号已被其他用户使用"); } $state = $express->setAutoData([ "openid" => $order["openid"], "order_sn" => $param["order"], "express_sn" => $param["express_sn"], "express_name" => $param["express_name"], "mobile" => $param["mobile"]??$order['mobile'], ]); if (!$state) return errorTrans("error.data"); $order->status = 7; $order->express_status = 2; $order->save(); return successTrans("success.data"); } catch (\Throwable $throwable) { return error($throwable->getMessage()); } } /** * 核销前退款取消 * @param Request $request * @return Response */ #[PostMapping("audit/cancel")] public function auditOrderCancel(Request $request): Response { try { $param = $this->_valid([ "order.require" => trans("empty.require"), ],$request->method()); if (!is_array($param)) return error($param); $order = $this->model->where("out_order_no",$param["order"])->findOrEmpty(); if ($order->isEmpty()) return error("关联订单错误"); if ($order['status'] == 8) { $order->status = 7; } else { $order->status = 2; } $state = $order->save(); if (!$state) return errorTrans("error.data"); return successTrans("success.data"); } catch (\Throwable $throwable) { return error($throwable->getMessage()); } } /** * 核销后退款申请审核 * @param Request $request * @return Response */ #[PostMapping("audit")] public function auditRefund(Request $request): Response { try { $param = $this->_valid([ "order.require" => trans("empty.require"), "status.require" => trans("empty.require"), "sign.default" => "", "reason.default" => "" ],$request->method()); if (!is_array($param)) return error($param); if ($param['status'] == 1 && empty($param['sign'])) return error("请上传打款凭证"); if ($param['status'] == 2 && empty($param['reason'])) return error("请输入拒绝原因"); $refund = (new SaasOrderRefund)->where("order_sn",$param["order"])->findOrEmpty(); if ($refund->isEmpty()) return error("退款申请不存在"); $refund->status = $param['status']; $refund->last_at = getDateFull(); if ($param['status'] == 1) { $refund->sign = $param['sign']; $this->model->where("out_order_no",$param["order"])->save(['status' => 3]); } else { $refund->reason = $param['reason']; $this->model->where("out_order_no",$param["order"])->save(['is_error' => 1,'status' => 2]); } $state = $refund->save(); if (!$state) return errorTrans("error.data"); return successTrans("success.data"); } catch (\Throwable $throwable) { return error($throwable->getMessage()); } } }