| | |
| | | |
| | | @GetMapping("resultWord") |
| | | public void adresultWordd(HttpServletResponse response,String time,String endTime) { |
| | | // for(int i = 495;i<1095;i++){ |
| | | List<SysTest> listAll = sysTestService.listAll(time,endTime,null); |
| | | String ks = "2023-08-06"; |
| | | for(int i =1;i<2;i++){ |
| | | Date ksDate = DateUtils.convertDate(ks); |
| | | List<SysTest> listAll = sysTestService.listAll(ks,null,null); |
| | | if(CollectionUtils.isEmpty(listAll)){ |
| | | return; |
| | | } |
| | | /* Date endTime =listAll.get(0).getTime(); |
| | | String endTimeStr = DateUtils.dateToDateString(endTime,DateUtils.yyyyMMdd_EN); |
| | | String endTimeStr = DateUtils.dateToDateString(ksDate,DateUtils.yyyyMMdd_EN); |
| | | String fileName = "空气质量日报.docx"; |
| | | Map<String,Object> map = resultMap(listAll); |
| | | downloadWord(fileName, map, response,"空气质量日报"+endTimeStr+".docx");*/ |
| | | // time = DateUtils.dateToDateString(DateUtils.addDays(endTime,1),DateUtils.yyyy_MM_dd_EN); |
| | | // } |
| | | downloadWord(fileName, map, response,"空气质量日报"+endTimeStr+".docx"); |
| | | ks = DateUtils.dateToDateString(DateUtils.addDays(ksDate,1),DateUtils.yyyy_MM_dd_EN); |
| | | } |
| | | } |
| | | |
| | | |
| | | @GetMapping("excelM") |
| | | public void excelM(HttpServletResponse response,String time,String endTime) { |
| | |
| | | |
| | | @GetMapping("resultWordWeek") |
| | | public void resultWordWeek(HttpServletResponse response) { |
| | | String ks = "2020-06-22"; |
| | | String ks = "2023-06-19"; |
| | | Date ksDate = DateUtils.convertDate(ks); |
| | | for(int i = 0;i<157;i++){ |
| | | int num = 157; |
| | | for(int i = 0;i<8;i++){ |
| | | Date jsDate = DateUtils.addDays(ksDate,6); |
| | | String time = DateUtils.dateToDateString(ksDate,DateUtils.yyyy_MM_dd_EN); |
| | | String endTime = DateUtils.dateToDateString(jsDate,DateUtils.yyyy_MM_dd_EN); |
| | |
| | | String fileName = "空气质量周报.docx"; |
| | | String time1 = DateUtils.dateToDateString(ksDate,"yyyy.MM.dd"); |
| | | String endTime1= DateUtils.dateToDateString(jsDate,"yyyy.MM.dd"); |
| | | Map<String,Object> map = resultWeekMap(listAll,i+1,time1+"-"+endTime1); |
| | | Map<String,Object> map = resultWeekMap(listAll,num,time1+"-"+endTime1); |
| | | downloadWord(fileName, map, response,"空气质量周报"+time+".docx"); |
| | | ksDate = DateUtils.addDays(ksDate,7); |
| | | num++; |
| | | } |
| | | } |
| | | |
| | | @GetMapping("resultWordMonth") |
| | | public void resultWordMonth(HttpServletResponse response) { |
| | | |
| | | String ks = "2020-06-01"; |
| | | String ks = "2023-07-01"; |
| | | Date ksDate = DateUtils.convertDate(ks); |
| | | for(int i = 0;i<37;i++){ |
| | | for(int i = 0;i<1;i++){ |
| | | Date jsDate = DateUtils.getLastDayOfCurrMonth(ksDate);; |
| | | String time = DateUtils.dateToDateString(ksDate,DateUtils.yyyy_MM_dd_EN); |
| | | String endTime = DateUtils.dateToDateString(jsDate,DateUtils.yyyy_MM_dd_EN); |
| | |
| | | String path = getPath(fileName);//我这放 resources包下 |
| | | try { |
| | | //获取模板文档 |
| | | OutputStream out = new FileOutputStream("E:\\home\\mon\\" + newFileName); |
| | | OutputStream out = new FileOutputStream("E:\\home\\week1\\" + newFileName); |
| | | File rootFile = new File(ResourceUtils.getURL("classpath:").getPath()); |
| | | File file= new File(rootFile, path); |
| | | XWPFDocument word = WordExportUtil.exportWord07(file.getPath(), params); |
| | |
| | | resultMap.put(name+"TV", StringUtils.isNotEmpty(s.getVoc())?s.getVoc():"--"); |
| | | resultMap.put(name+"S", StringUtils.isNotEmpty(s.getSu())?s.getSu():"--"); |
| | | } |
| | | // String bodyName = stringButterStrWeek(listAll); |
| | | HashMap<String, Integer> datas = new HashMap<>(3); |
| | | String bodyName = stringButterStrWeek(listAll); |
| | | /* HashMap<String, Integer> datas = new HashMap<>(3); |
| | | datas.put("一号",10); |
| | | datas.put("二号",20); |
| | | datas.put("三号",40); |
| | | ImageEntity imageEntity = pieChart("测试",datas, 500, 300); |
| | | resultMap.put("主要内容",imageEntity); |
| | | ImageEntity imageEntity = pieChart("测试",datas, 500, 300);*/ |
| | | resultMap.put("主要内容",bodyName); |
| | | return resultMap; |
| | | } |
| | | private Map<String,Object> resultWeekMap(List<SysTest> listAll,String weekTime,List<SysTest> listDay,int days){ |
| | |
| | | } |
| | | |
| | | public static void main(String[] args) { |
| | | String ks = "2020-06-01"; |
| | | /*String ks = "2020-06-01"; |
| | | Date ksDate = DateUtils.convertDate(ks); |
| | | for(int i = 0;i<37;i++){ |
| | | Date jsDate = DateUtils.getLastDayOfCurrMonth(ksDate); |
| | | System.out.println("开始:"+DateUtils.dateToDateString(ksDate,DateUtils.yyyy_MM_dd_EN)); |
| | | System.out.println("结束:"+DateUtils.dateToDateString(jsDate,DateUtils.yyyy_MM_dd_EN)); |
| | | ksDate = DateUtils.addMonths(ksDate,1); |
| | | } |
| | | }*/ |
| | | |
| | | String ks = "2023-06-22"; |
| | | for(int i =1;i<46;i++){ |
| | | Date ksDate = DateUtils.convertDate(ks); |
| | | System.out.println("开始:"+DateUtils.dateToDateString(ksDate,DateUtils.yyyy_MM_dd_EN)); |
| | | |
| | | ks = DateUtils.dateToDateString(DateUtils.addDays(ksDate,1),DateUtils.yyyy_MM_dd_EN); |
| | | System.out.println("结束:"+ks); |
| | | } |
| | | |
| | | /*String ks = "2020-06-22"; |
| | | Date ksDate = DateUtils.convertDate(ks); |