| | |
| | | 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; |
| | |
| | | private final IAdminMallOrderService adminMallOrderService; |
| | | private final MallExpressInfoMapper mallExpressInfoMapper; |
| | | private final MallMemberMapper mallMemberMapper; |
| | | private final MallOrderInfoMapper mallOrderInfoMapper; |
| | | |
| | | /** |
| | | * 订单列表 |
| | |
| | | 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 { |