| | |
| | | @Autowired |
| | | private CaseInfoService service; |
| | | |
| | | private Map<String,Object> getParameterAll() { |
| | | Map<String, Object> terms = getParameter(); |
| | | // // 来访时间 |
| | | String visitTimeStart = request.getParameter("visitTimeStart"); |
| | | String visitTimeEnd = request.getParameter("visitTimeEnd"); |
| | | if(StringUtils.isNotBlank(visitTimeStart) && StringUtils.isNotBlank(visitTimeEnd)) { |
| | | terms.put("visitTimeStart", visitTimeStart + " 00:00:00"); |
| | | terms.put("visitTimeEnd", visitTimeEnd + " 23:59:59"); |
| | | } |
| | | String createStart = request.getParameter("createStart"); |
| | | String createEnd = request.getParameter("createEnd"); |
| | | if(StringUtils.isNotBlank(createStart) && StringUtils.isNotBlank(createEnd)) { |
| | | terms.put("createStart", createStart+ " 00:00:00"); |
| | | terms.put("createEnd", createEnd+ " 23:59:59"); |
| | | } |
| | | String closeStart = request.getParameter("closeStart"); |
| | | String closeEnd = request.getParameter("closeEnd"); |
| | | if(StringUtils.isNotBlank(closeStart) && StringUtils.isNotBlank(closeEnd)) { |
| | | terms.put("createStart", closeStart+ " 00:00:00"); |
| | | terms.put("createEnd", closeEnd+ " 23:59:59"); |
| | | } |
| | | String fileStart = request.getParameter("fileStart"); |
| | | String fileEnd = request.getParameter("fileEnd"); |
| | | if(StringUtils.isNotBlank(fileStart) && StringUtils.isNotBlank(fileEnd)) { |
| | | terms.put("createStart", fileStart+ " 00:00:00"); |
| | | terms.put("createEnd", fileEnd+ " 23:59:59"); |
| | | } |
| | | return terms; |
| | | } |
| | | |
| | | /** |
| | | * 获取请求URL参数 |
| | | * @return Map<String, Object> |
| | |
| | | @GetMapping("/pageQueryAll") |
| | | public Object pageQueryAll(@RequestParam(value = "page") int page, @RequestParam(value = "size") int size) { |
| | | try { |
| | | Map<String, Object> terms = getParameter(); |
| | | Map<String, Object> terms = getParameterAll(); |
| | | Sort sort = Sort.by(Sort.Direction.DESC, "a.create_time"); |
| | | PageRequest pageRequest = PageRequest.of(page-1, size, sort); |
| | | Page<CasePageDTO> caseInfoPage = service.pageQueryAll(pageRequest, terms); |
| | |
| | | @RequestMapping("/exportQueryAll") |
| | | public void exportQueryAll(HttpServletResponse response) { |
| | | try { |
| | | Map<String, Object> terms = getParameter(); |
| | | Map<String, Object> terms = getParameterAll(); |
| | | Sort sort = Sort.by(Sort.Direction.DESC, "a.create_time"); |
| | | PageRequest pageRequest = PageRequest.of(0, 1000000, sort); |
| | | Page<CasePageDTO> caseInfoPage = service.pageQueryAll(pageRequest, terms); |
| | |
| | | for (CasePageDTO casePageDTO : caseInfoPage.getContent()) { |
| | | CaseInfoWeExcelDTO caseInfoWeExcelDTO = new CaseInfoWeExcelDTO(); |
| | | BeanUtils.copyProperties(casePageDTO,caseInfoWeExcelDTO); |
| | | caseInfoWeExcelDTO.setCloseTime(DateUtils.DateToString(casePageDTO.getCloseTime(), DateUtils.YYYY_MM_DD)); |
| | | if(ObjectUtils.isNotEmpty(casePageDTO.getPlaintiffList())){ |
| | | StringBuffer sb = new StringBuffer(); |
| | | for (CasePersonWeDTO casePersonWeDTO : casePageDTO.getPlaintiffList()) { |
| | |
| | | } |
| | | |
| | | } |
| | | |
| | | /** |
| | | * 综合查询 |
| | | * @url {ctx}/api/web/caseInfo/statistics |
| | | * @return Object |
| | | * @CurrentUser String userId |
| | | */ |
| | | @GetMapping("/statistics") |
| | | public Object statistics() { |
| | | try { |
| | | Map<String, Object> terms = getParameterAll(); |
| | | return ReturnSucUtils.getRepInfo( "处理成功", service.statistics(terms)); |
| | | } catch (Exception e) { |
| | | log.error("Controller接口[CaseInfoWebController.statistics]请求异常:"+e, e); |
| | | return ReturnFailUtils.getRepInfo(); |
| | | } |
| | | } |
| | | } |