jiaoyi-webman/app/controller/merchant/Order.php

<?php

namespace app\controller\merchant;

use app\extra\basic\Base;
use app\extra\dyLife\data\BaseData;
use app\extra\dyLife\data\OrderData;
use app\extra\tools\LifeWeb;
use app\middleware\AuthMiddleware;
use app\model\saas\SaasOrder;
use app\model\saas\SaasOrderAddress;
use app\model\saas\SaasOrderExpress;
use app\model\saas\SaasOrderItem;
use app\model\saas\SaasOrderVerify;
use app\model\saas\SaasStore;
use app\model\saas\SaasUserOpen;
use app\model\system\SystemImport;
use app\service\saas\GoodsService;
use app\service\saas\OrderService;
use DI\Attribute\Inject;
use LinFly\Annotation\Attributes\Route\Controller;
use LinFly\Annotation\Attributes\Route\GetMapping;
use LinFly\Annotation\Attributes\Route\Middleware;
use LinFly\Annotation\Attributes\Route\PostMapping;
use support\Request;
use support\Response;


#[Controller("/api/merchant/order"),Middleware(AuthMiddleware::class)]
class Order extends Base
{


    #[Inject]
    protected OrderService $service;

    #[Inject]
    protected SaasOrder $model;

    #[Inject]
    protected GoodsService $goodsService;

    #[GetMapping('list')]
    public function getOrderList(Request $request): Response
    {
        try {
            $param = $request->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'])->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 ($request->user['store_id'] <> $order['poi_id'] && $request->user['is_super'] == 0) return errorTrans("empty.data");
            $orderExpress = (new SaasOrderExpress)->where("order_sn",$order['order_sn'])->findOrEmpty();
            if ($orderExpress->isEmpty()) return error("订单尚未发货");
            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 ($order['status'] <> 1) 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",$order["order_sn"])->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"      => $order["order_sn"],
                "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());
        }

    }

}