From 0dded054a1744e032c30bc5b10fda1f2c94a4099 Mon Sep 17 00:00:00 2001 From: KKSU <15274802129@163.com> Date: Wed, 21 Feb 2024 15:20:48 +0800 Subject: [PATCH] 抽奖 --- src/main/java/cc/mrbird/febs/mall/controller/AdminMallOrderController.java | 77 ++++++++++++++++++++++++++++++++++++++ 1 files changed, 77 insertions(+), 0 deletions(-) diff --git a/src/main/java/cc/mrbird/febs/mall/controller/AdminMallOrderController.java b/src/main/java/cc/mrbird/febs/mall/controller/AdminMallOrderController.java index ba47f51..0c2f0c7 100644 --- a/src/main/java/cc/mrbird/febs/mall/controller/AdminMallOrderController.java +++ b/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,20 @@ private final IAdminMallOrderService adminMallOrderService; private final MallExpressInfoMapper mallExpressInfoMapper; private final MallMemberMapper mallMemberMapper; + private final MallOrderInfoMapper mallOrderInfoMapper; + + + /** + * 订单列表 + * + * @param request + * @return + */ + @GetMapping("chouJiangList") + public FebsResponse chouJiangList(ChoujiangInfoDto choujiangInfoDto, QueryRequest request) { + Map<String, Object> data = getDataTable(adminMallOrderService.getChouJiangListInPage(choujiangInfoDto, request)); + return new FebsResponse().success().data(data); + } /** * 订单列表 @@ -340,6 +355,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 { -- Gitblit v1.9.1