From 0481353111afb43a2322e18530dde26f1d841ead Mon Sep 17 00:00:00 2001 From: yanghb <yanghb> Date: 星期五, 21 四月 2023 11:15:34 +0800 Subject: [PATCH] 代码调整 --- ManagementTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/system/service/impl/UserCouponRecordServiceImpl.java | 44 ++++++++++++++++---------------------------- 1 files changed, 16 insertions(+), 28 deletions(-) diff --git a/ManagementTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/system/service/impl/UserCouponRecordServiceImpl.java b/ManagementTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/system/service/impl/UserCouponRecordServiceImpl.java index 015d771..8dd09b3 100644 --- a/ManagementTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/system/service/impl/UserCouponRecordServiceImpl.java +++ b/ManagementTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/system/service/impl/UserCouponRecordServiceImpl.java @@ -8,7 +8,7 @@ import com.stylefeng.guns.modular.system.service.IUserCouponRecordService; import com.baomidou.mybatisplus.service.impl.ServiceImpl; import org.apache.poi.hssf.usermodel.*; -//import org.apache.poi.ss.usermodel.CellType; +import org.apache.poi.ss.usermodel.CellType; import org.apache.poi.ss.usermodel.HorizontalAlignment; import org.apache.poi.ss.util.CellRangeAddress; import org.springframework.beans.factory.annotation.Autowired; @@ -41,22 +41,10 @@ public List<Map<String, Object>> getList(Page<Map<String, Object>> page, String beginTime, String endTime, String userName, String userPhone, Integer couponActivityId, Integer activityType,Integer state) { return this.baseMapper.getList(page,beginTime,endTime,userName,userPhone,couponActivityId,activityType,state); } - - @Override - public List<Map<String, Object>> getListt(String beginTime, String endTime, String userName, String userPhone, Integer couponActivityId, Integer activityType,Integer state) { - return this.baseMapper.getListt(beginTime,endTime,userName,userPhone,couponActivityId,activityType,state); - } - @Override public List<Map<String, Object>> getRedList(Page<Map<String, Object>> page, String beginTime, String endTime, String userName, String userPhone, Integer couponActivityId,Integer state) { return this.baseMapper.getRedList(page,beginTime,endTime,userName,userPhone,couponActivityId,state); } - - @Override - public List<Map<String, Object>> getRedListt(String beginTime, String endTime, String userName, String userPhone, Integer couponActivityId,Integer state) { - return this.baseMapper.getRedListt(beginTime,endTime,userName,userPhone,couponActivityId,state); - } - @Override public Map<String, Object> getCouponStatic(String beginTime, String endTime, Integer activityId, Integer activityType) { return this.baseMapper.getCouponStatic(beginTime,endTime,activityId,activityType); @@ -192,12 +180,12 @@ HSSFRow hssfRow = hssfSheet.createRow(i);//设置第一行数据(标题) HSSFCellStyle style = hssfWorkbook.createCellStyle(); HSSFFont font = hssfWorkbook.createFont(); -// font.setBold(true); + font.setBold(true); style.setFont(font); -// style.setAlignment(HorizontalAlignment.CENTER); + style.setAlignment(HorizontalAlignment.CENTER); for (int l = 0; l < lists.get(i).size(); l++) { HSSFCell hssfCell = hssfRow.createCell(l); -// hssfCell.setCellType(CellType.STRING);//设置表格类型 + hssfCell.setCellType(CellType.STRING);//设置表格类型 hssfCell.setCellValue(lists.get(i).get(l)); hssfCell.setCellStyle(style); if(l > 0) { @@ -232,7 +220,7 @@ data = lists1.get(i).get(l); for (int j = 0; j < data.size(); j++) { HSSFCell hssfCell = row.createCell(j); -// hssfCell.setCellType(CellType.STRING);//设置表格类型 + hssfCell.setCellType(CellType.STRING);//设置表格类型 hssfCell.setCellValue(data.get(j)); } } @@ -324,12 +312,12 @@ HSSFRow hssfRow = hssfSheet.createRow(i);//设置第一行数据(标题) HSSFCellStyle style = hssfWorkbook.createCellStyle(); HSSFFont font = hssfWorkbook.createFont(); -// font.setBold(true); + font.setBold(true); style.setFont(font); -// style.setAlignment(HorizontalAlignment.CENTER); + style.setAlignment(HorizontalAlignment.CENTER); for (int l = 0; l < lists.get(i).size(); l++) { HSSFCell hssfCell = hssfRow.createCell(l); -// hssfCell.setCellType(CellType.STRING);//设置表格类型 + hssfCell.setCellType(CellType.STRING);//设置表格类型 hssfCell.setCellValue(lists.get(i).get(l)); hssfCell.setCellStyle(style); if(l > 0) { @@ -352,7 +340,7 @@ data = lists1.get(i).get(l); for (int j = 0; j < data.size(); j++) { HSSFCell hssfCell = row.createCell(j); -// hssfCell.setCellType(CellType.STRING);//设置表格类型 + hssfCell.setCellType(CellType.STRING);//设置表格类型 hssfCell.setCellValue(data.get(j)); } } @@ -397,9 +385,9 @@ list.add("通用券领取总数"); list.add("通用券使用总数"); list.add("通用券使用总金额"); - list.add("快车券领取总数"); - list.add("快车券使用总数"); - list.add("快车券使用总金额"); + list.add("专车券领取总数"); + list.add("专车券使用总数"); + list.add("专车券使用总金额"); list.add("出租车券领取总数"); list.add("出租车券使用总数"); list.add("出租车券使用总金额"); @@ -440,12 +428,12 @@ HSSFRow hssfRow = hssfSheet.createRow(i);//设置第一行数据(标题) HSSFCellStyle style = hssfWorkbook.createCellStyle(); HSSFFont font = hssfWorkbook.createFont(); -// font.setBold(true); + font.setBold(true); style.setFont(font); -// style.setAlignment(HorizontalAlignment.CENTER); + style.setAlignment(HorizontalAlignment.CENTER); for (int l = 0; l < lists.get(i).size(); l++) { HSSFCell hssfCell = hssfRow.createCell(l); -// hssfCell.setCellType(CellType.STRING);//设置表格类型 + hssfCell.setCellType(CellType.STRING);//设置表格类型 hssfCell.setCellValue(lists.get(i).get(l)); hssfCell.setCellStyle(style); if(l > 0) { @@ -469,7 +457,7 @@ data = lists1.get(i).get(l); for (int j = 0; j < data.size(); j++) { HSSFCell hssfCell = row.createCell(j); -// hssfCell.setCellType(CellType.STRING);//设置表格类型 + hssfCell.setCellType(CellType.STRING);//设置表格类型 hssfCell.setCellValue(data.get(j)); } } -- Gitblit v1.7.1