Report95598ServiceImpl.java 4.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126
  1. package com.minpay.common.service.impl;
  2. import com.minpay.common.constant.Constant;
  3. import com.minpay.common.service.IReport95598Service;
  4. import com.minpay.common.service.IReportService;
  5. import com.minpay.common.util.*;
  6. import com.minpay.db.table.mapper.*;
  7. import com.minpay.db.table.model.*;
  8. import com.minpay.db.table.own.mapper.ICommMapper;
  9. import com.minpay.db.table.own.mapper.IReportBatchMapper;
  10. import com.minpay.db.table.own.mapper.IZb95598ReportMapper;
  11. import com.minpay.db.table.own.mapper.ReportServiceMapper;
  12. import com.minpay.reportManage.action.r95598.Util95598zb;
  13. import com.startup.minpay.frame.business.MINHttpServletRequestContext;
  14. import com.startup.minpay.frame.exception.MINBusinessException;
  15. import com.startup.minpay.frame.jdbc.MINRowBounds;
  16. import com.startup.minpay.frame.service.base.IMINDataBaseService;
  17. import com.startup.minpay.frame.service.base.Service;
  18. import com.startup.minpay.frame.target.MINComponent;
  19. import net.sf.json.JSONArray;
  20. import net.sf.json.JSONObject;
  21. import org.apache.commons.fileupload.FileItem;
  22. import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
  23. import java.io.IOException;
  24. import java.lang.reflect.InvocationTargetException;
  25. import java.text.ParseException;
  26. import java.util.*;
  27. @MINComponent
  28. public class Report95598ServiceImpl implements IReport95598Service {
  29. @Override
  30. public Map<String, Object> reportNeedDetail(Map<String, Object> param) throws MINBusinessException {
  31. String range = (String)param.get("range");
  32. String timeRange = (String)param.get("timeRange");
  33. String reportTypeId = (String)param.get("reportTypeId");
  34. MINHttpServletRequestContext request = (MINHttpServletRequestContext)param.get("request");
  35. Map<String, Object> resMap = new HashMap<String, Object>();
  36. if(Constant.REPORT_TYPE_20.equals(reportTypeId)){//95598日报
  37. Map<String,Object> mm = new HashMap<String,Object>();
  38. mm.put("range",range);
  39. mm.put("timeRange",timeRange);
  40. mm.put("reportTypeId",reportTypeId);
  41. Map<String,Object> resList = reportType95598Zb(mm, request);
  42. resMap.put("resList", resList);
  43. }else if(Constant.REPORT_TYPE_21.equals(reportTypeId)){//95598日汇报
  44. Map<String,Object> mm = new HashMap<String,Object>();
  45. mm.put("range",range);
  46. mm.put("timeRange",timeRange);
  47. mm.put("reportTypeId",reportTypeId);
  48. Map<String,Object> resList = reportType95598Zb(mm, request);
  49. resMap.put("resList", resList);
  50. }else if(Constant.REPORT_TYPE_22.equals(reportTypeId)){//95598周报
  51. Map<String,Object> mm = new HashMap<String,Object>();
  52. mm.put("range",range);
  53. mm.put("timeRange",timeRange);
  54. mm.put("reportTypeId",reportTypeId);
  55. Map<String,Object> resList = reportType95598Zb(mm, request);
  56. resMap.put("resList", resList);
  57. }else if(Constant.REPORT_TYPE_23.equals(reportTypeId)){//95598日汇报
  58. Map<String,Object> mm = new HashMap<String,Object>();
  59. mm.put("range",range);
  60. mm.put("timeRange",timeRange);
  61. mm.put("reportTypeId",reportTypeId);
  62. Map<String,Object> resList = reportType95598Zb(mm, request);
  63. resMap.put("resList", resList);
  64. }
  65. return resMap;
  66. }
  67. /**
  68. * 95598周报
  69. * @param mm
  70. * @param request
  71. * @return
  72. */
  73. private Map<String, Object> reportType95598Zb(Map<String, Object> mm, MINHttpServletRequestContext request) throws MINBusinessException {
  74. IMINDataBaseService db = Service.lookup(IMINDataBaseService.class);
  75. String range = StringUtil.ObjectToString(mm.get("range"));
  76. String timeRange = StringUtil.ObjectToString(mm.get("timeRange"));
  77. String start = StringUtil.getStartAndEndDatetime(range,timeRange,"1");
  78. String end = StringUtil.getStartAndEndDatetime(range,timeRange,"2");
  79. mm.put("start",start);
  80. mm.put("end",end);
  81. //单位别名翻译
  82. List<Map<String,String>> unitMapp = db.getMybatisMapper(ICommMapper.class).selectUnitMapps(mm);
  83. mm.put("DICT_GCODE","95598GDLX");
  84. //查询工单业务类型
  85. List<Map<String,String>> gdMapp = db.getMybatisMapper(ICommMapper.class).selectGdType(mm);
  86. //95598业务受理情况
  87. //单位维度数据
  88. List<Map<String,String>> list = db.getMybatisMapper(IZb95598ReportMapper.class).selectBeforeIndex(mm);
  89. //分类明细汇总数据
  90. List<Map<String,String>> list2 = db.getMybatisMapper(IZb95598ReportMapper.class).selectFltjYwsl(mm);
  91. Map<String,String> temp = new HashMap<>();
  92. Map<String,String> temp2 = new HashMap<>();
  93. if(list != null){
  94. for (int i = 0; i < list.size(); i++) {
  95. temp = list.get(i);
  96. Util95598zb.operateData(temp,list2,unitMapp,gdMapp);//按单位统计
  97. }
  98. }
  99. if(list != null){
  100. for (int i = 0; i < list.size(); i++) {
  101. Util95598zb.operateDescData(temp2,list2,unitMapp,gdMapp);//按单位统计
  102. }
  103. }
  104. Map<String,Object> rstMap = new HashMap<>();
  105. rstMap.put("list1",list);
  106. for (int i = 0; i < list.size(); i++) {
  107. System.out.println(list.get(i).toString());
  108. }
  109. return rstMap;
  110. }
  111. @Override
  112. public void init() throws MINBusinessException {
  113. }
  114. }