| | |
| | | String name = dataReportingMapper.getUserNameById(map1.get("userId")); |
| | | registrantCountDto.setName2(name); |
| | | } |
| | | ; |
| | | String department = dataReportingMapper.getUserDepartmentById(map1.get("userId")); |
| | | registrantCountDto.setDepartment(department); |
| | | map.put("body", dataReportingMapper.selectRegistrantCountDtoPageList(page, QueryWrappers.queryWrappers(registrantCountDto), registrantCountDto.getStartTime(), registrantCountDto.getEndTime())); |
| | |
| | | .eq(DataReporting::getName, dataReporting.getName()) |
| | | .eq(DataReporting::getAccountConsumption, dataReporting.getAccountConsumption()) |
| | | .eq(DataReporting::getShowNum, dataReporting.getShowNum()) |
| | | .eq(DataReporting::getClick, dataReporting.getClick())); |
| | | .eq(DataReporting::getClick, dataReporting.getClick()) |
| | | .last("limit 1")); |
| | | if (BeanUtil.isNotEmpty(dataReporting1)) { |
| | | dataReporting.setId(dataReporting1.getId()); |
| | | dataReportingMapper.updateById(dataReporting); |
| | |
| | | |
| | | @Override |
| | | public String downFansSubmitFile(IPage<FansSubmit> page, FansSubmit fansSubmit) { |
| | | fansSubmit.setCreateTime(fansSubmit.getCreateTime().plusDays(1)); |
| | | Map<String, Object> map = fansSubmitService.selectFansSubmitList(page, fansSubmit); |
| | | String time = LocalDateTime.now().format(DateTimeFormatter.ofPattern("yyyy_MM_dd_HH_mm_ss")); |
| | | String name = "粉丝上报" + time + ".csv"; |
| | |
| | | CsvWriter writer = CsvUtil.getWriter(path, CharsetUtil.CHARSET_GBK); |
| | | writer.write(new String[]{"导出时间:" + time}); |
| | | writer.write(new String[]{}); |
| | | writer.write(new String[]{"时间范围:" + fansSubmit.getCreateTime().format(DateTimeFormatter.ofPattern("yyyyMMdd"))}); |
| | | writer.write(new String[]{"时间范围:" + fansSubmit.getCreateTime().minusDays(1).format(DateTimeFormatter.ofPattern("yyyyMMdd"))}); |
| | | writer.write(new String[]{}); |
| | | writer.write(new String[]{}); |
| | | List<Map<String, String>> head = JSON.parseObject(JSON.toJSONString(map.get("head")), List.class); |
| | |
| | | |
| | | @Override |
| | | public String downFinanceSubmitFile(IPage<FinanceSubmit> page, FinanceSubmit financeSubmit) { |
| | | financeSubmit.setCreateTime(financeSubmit.getCreateTime().plusDays(1)); |
| | | Map<String, Object> map = financeSubmitService.selectFinanceSubmitList(page, financeSubmit); |
| | | String time = LocalDateTime.now().format(DateTimeFormatter.ofPattern("yyyy_MM_dd_HH_mm_ss")); |
| | | String time = LocalDateTime.now().minusDays(1).format(DateTimeFormatter.ofPattern("yyyy_MM_dd_HH_mm_ss")); |
| | | String name = "财务上报" + time + ".csv"; |
| | | String path = outPath + name; |
| | | CsvWriter writer = CsvUtil.getWriter(path, CharsetUtil.CHARSET_GBK); |
| | | writer.write(new String[]{"导出时间:" + time}); |
| | | writer.write(new String[]{}); |
| | | writer.write(new String[]{"时间范围:" + financeSubmit.getCreateTime().format(DateTimeFormatter.ofPattern("yyyyMMdd"))}); |
| | | writer.write(new String[]{"时间范围:" + financeSubmit.getCreateTime().minusDays(1).format(DateTimeFormatter.ofPattern("yyyyMMdd"))}); |
| | | writer.write(new String[]{}); |
| | | writer.write(new String[]{}); |
| | | List<Map<String, String>> head = JSON.parseObject(JSON.toJSONString(map.get("head")), List.class); |