xiaoyong931011
2023-05-06 076f5a4f0a7c5a4d3a6d3a1a61ff96a0091e3320
src/main/java/cc/mrbird/febs/mall/controller/AdminMallOrderController.java
@@ -14,6 +14,7 @@
import cc.mrbird.febs.mall.entity.*;
import cc.mrbird.febs.mall.mapper.MallExpressInfoMapper;
import cc.mrbird.febs.mall.mapper.MallMemberMapper;
import cc.mrbird.febs.mall.mapper.MallOrderInfoMapper;
import cc.mrbird.febs.mall.mapper.MallOrderRefundOperationMapper;
import cc.mrbird.febs.mall.service.IAdminMallGoodsService;
import cc.mrbird.febs.mall.service.IAdminMallOrderService;
@@ -52,6 +53,7 @@
    private final IAdminMallOrderService adminMallOrderService;
    private final MallExpressInfoMapper mallExpressInfoMapper;
    private final MallMemberMapper mallMemberMapper;
    private final MallOrderInfoMapper mallOrderInfoMapper;
    /**
     * 订单列表
@@ -340,6 +342,68 @@
        return null;
    }
    @GetMapping("exportOrderListAll")
    @ControllerEndpoint(operation = "订单列表", exceptionMessage = "导出失败")
    public FebsResponse exportOrderListAll(MallOrderInfo mallOrderInfo, HttpServletResponse response) throws IOException {
        List<ExcelSheetPO> res = new ArrayList<>();
        ExcelSheetPO orderSheet = new ExcelSheetPO();
        String title = "订单列表";
        orderSheet.setSheetName(title);
        orderSheet.setTitle(title);
        String[] header = {"订单编号", "登录账户", "购买人", "手机号码", "订单金额", "状态"};
        orderSheet.setHeaders(header);
        QueryRequest request = new QueryRequest();
        request.setPageNum(1);
        request.setPageSize(9999);
        List<MallOrderInfo> dataList = mallOrderInfoMapper.selectList(null);
        List<List<Object>> list = new ArrayList<>();
        if (dataList.size() > 0) {
            for (MallOrderInfo item : dataList) {
                List<Object> temp = new ArrayList<>();
                temp.add(item.getOrderNo());
                temp.add(mallMemberMapper.selectById(item.getMemberId()).getAccountLogin());
                temp.add(mallMemberMapper.selectById(item.getMemberId()).getName());
                temp.add(mallMemberMapper.selectById(item.getMemberId()).getPhone());
                temp.add(item.getAmount());
                switch (item.getStatus()) {
                    case 1:
                        temp.add("待支付");
                        break;
                    case 2:
                        temp.add("待发货");
                        break;
                    case 3:
                        temp.add("待收货");
                        break;
                    case 4:
                        temp.add("已完成");
                        break;
                    case 5:
                        temp.add("退款中");
                        break;
                    case 6:
                        temp.add("已退款");
                        break;
                    case 7:
                        temp.add("已取消");
                        break;
                    default:
                }
                list.add(temp);
            }
        }
        orderSheet.setDataList(list);
        res.add(orderSheet);
        response = ResponseHeadUtil.setExcelHead(response);
        response.setHeader("Content-Disposition",
                "attachment;filename=" + URLEncoder.encode(title + DateUtil.format(new Date(), "yyyyMMDDHHmmss") + ".xlsx".trim(), "UTF-8"));
        OutputStream os = response.getOutputStream();
        ExcelUtil.createWorkbookAtOutStream(ExcelVersion.V2007, res, os, true);
        return null;
    }
    @PostMapping(value = "/importDeliver")
    @ControllerEndpoint(operation = "导入发货", exceptionMessage = "导入失败")
    public FebsResponse importDeliver(@RequestBody MultipartFile file) throws IOException {