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/controller/general/UserCouponRecordController.java | 104 ---------------------------------------------------- 1 files changed, 0 insertions(+), 104 deletions(-) diff --git a/ManagementTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/system/controller/general/UserCouponRecordController.java b/ManagementTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/system/controller/general/UserCouponRecordController.java index c913c98..f1087c3 100644 --- a/ManagementTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/system/controller/general/UserCouponRecordController.java +++ b/ManagementTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/system/controller/general/UserCouponRecordController.java @@ -4,10 +4,7 @@ import com.stylefeng.guns.core.base.controller.BaseController; import com.stylefeng.guns.core.common.constant.factory.PageFactory; import com.stylefeng.guns.core.shiro.ShiroKit; -import com.stylefeng.guns.core.util.ExcelUtil; import com.stylefeng.guns.core.util.SinataUtil; -import com.stylefeng.guns.core.util.ToolUtil; -import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.ResponseBody; @@ -19,12 +16,6 @@ import com.stylefeng.guns.modular.system.model.UserCouponRecord; import com.stylefeng.guns.modular.system.service.IUserCouponRecordService; -import javax.servlet.http.HttpServletResponse; -import java.io.OutputStream; -import java.text.DateFormat; -import java.text.SimpleDateFormat; -import java.util.Date; -import java.util.List; import java.util.Map; /** @@ -126,100 +117,5 @@ @ResponseBody public Object detail(@PathVariable("userCouponRecordId") Integer userCouponRecordId) { return userCouponRecordService.selectById(userCouponRecordId); - } - - - /** - * 导出 - */ - @RequestMapping(value = "/exportRecord") - @ResponseBody - public Object exportRecord(HttpServletResponse response,@RequestParam String createTime,@RequestParam String userName,@RequestParam String userPhone, - @RequestParam Integer couponActivityId,@RequestParam Integer activityType,@RequestParam Integer state) { - try { - - String beginTime = null; - String endTime = null; - if (SinataUtil.isNotEmpty(createTime)){ - String[] timeArray = createTime.split(" - "); - beginTime = timeArray[0]; - endTime = timeArray[1]; - } - - Date date = new Date(); - DateFormat format = new SimpleDateFormat("yyyyMMdd"); - String time = format.format(date); - String fileName = "活动奖励领取记录"+time+".xls"; - String[] title = new String[] {"领取时间","领取人","领取人电话","领取金额","到期时间","领取类型","状态","使用时间"}; - List<Map<String,Object>> mapList = userCouponRecordService.getListt(beginTime,endTime,userName,userPhone,couponActivityId,activityType,state); - - String[][] values = new String[mapList.size()][]; - for (int i = 0; i < mapList.size(); i++) { - Map<String,Object> d=mapList.get(i); - values[i] = new String[title.length]; - values[i][0]=d.get("insertTime").toString(); - values[i][1]=d.get("nickName").toString(); - if (ToolUtil.isNotEmpty(d.get("phone"))){ - values[i][2]=d.get("phone").toString(); - }else { - values[i][2]=""; - } - - values[i][3]=d.get("money").toString(); - values[i][4]=d.get("expirationTime").toString(); - String couponUseType = d.get("couponUseType").toString(); - switch (couponUseType) { - case "0": - values[i][5] = "通用券"; - break; - case "1": - values[i][5] = "快车券"; - break; - case "2": - values[i][5] = "出租券"; - break; - case "3": - values[i][5] = "跨城出行券"; - break; - default: - values[i][5] = ""; - break; - } - - String stateStr =d.get("state").toString(); - switch (stateStr) { - case "0": - values[i][6] = "未使用"; - break; - case "1": - values[i][6] = "已使用"; - break; - case "2": - values[i][6] = "已过期"; - break; - default: - values[i][6] = ""; - break; - } - - if (ToolUtil.isNotEmpty(d.get("useTime"))){ - values[i][7]=d.get("useTime").toString(); - }else { - values[i][7]=""; - } - } - String fileNameTitle="活动奖励领取记录"; - HSSFWorkbook wb = ExcelUtil.getHSSFWorkbook(fileNameTitle+time, title, values, null); - ExcelUtil.setResponseHeader(response, fileName); - OutputStream os = response.getOutputStream(); - wb.write(os); - os.flush(); - os.close(); - - } catch (Exception e) { - e.printStackTrace(); - /*return ApiUtil.putFailObj("导出失败");*/ - } - return SUCCESS_TIP; } } -- Gitblit v1.7.1