| | |
|---|
| | | @Override
|
|---|
| | | public List<Map<String, Object>> countAuditTotal(Integer state, Integer type, String years, String startTime,
|
|---|
| | | String endTime) throws Exception{
|
|---|
| | | List<Map<String, Object>> list = extractAuditRecordMapper.countAuditTotal(state, type, years, startTime, endTime);
|
|---|
| | | |
|---|
| | | if (list == null || list.size() == 0) {
|
|---|
| | | return list = new ArrayList<Map<String, Object>>();
|
|---|
| | | } |
|---|
| | | |
|---|
| | | switch (type){
|
|---|
| | | case 1: // 按天处理
|
|---|
| | | return dayFactory(startTime, endTime, list);
|
|---|
| | | case 2: // 按月处理
|
|---|
| | | return monthFactory(list);
|
|---|
| | | case 3: |
|---|
| | | return yearFactory(list);
|
|---|
| | | default: |
|---|
| | | return null;
|
|---|
| | | }
|
|---|
| | | return extractAuditRecordMapper.countAuditTotal(state, type, years, startTime, endTime);
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | |
|---|
| | | |
|---|
| | | @Override
|
|---|
| | | public List<Map<String, Object>> countExtractMoney(Integer state, Integer type, String years, String startTime,
|
|---|
| | | public List<Map<String, Object>> countExtractApplyMoney(Integer state, Integer type, String years, String startTime,
|
|---|
| | | String endTime) throws Exception{
|
|---|
| | | List<Map<String, Object>> list = extractAuditRecordMapper.countExtractMoney(state, type, years, startTime, endTime);
|
|---|
| | | |
|---|
| | | if (list == null || list.size() == 0) {
|
|---|
| | | return list = new ArrayList<Map<String, Object>>();
|
|---|
| | | } |
|---|
| | | |
|---|
| | | switch (type){
|
|---|
| | | case 1: // 按天处理
|
|---|
| | | return dayFactory(startTime, endTime, list);
|
|---|
| | | case 2: // 按月处理
|
|---|
| | | return monthFactory(list);
|
|---|
| | | case 3: |
|---|
| | | return yearFactory(list);
|
|---|
| | | default: |
|---|
| | | return null;
|
|---|
| | | }
|
|---|
| | | return extractAuditRecordMapper.countExtractMoney(state, type, years, startTime, endTime);
|
|---|
| | | }
|
|---|
| | | |
|---|
| | |
|
|---|
| | | @Override
|
|---|
| | | public List<Map<String, Object>> countExtractApplyNumber(Integer state, Integer type, String years, String startTime,
|
|---|
| | | String endTime) throws Exception{
|
|---|
| | | List<Map<String, Object>> list = extractAuditRecordMapper.countExtractApplyNumber(state, type, years, startTime, endTime);
|
|---|
| | | |
|---|
| | | if (list == null || list.size() == 0) {
|
|---|
| | | return list = new ArrayList<Map<String, Object>>();
|
|---|
| | | } |
|---|
| | | |
|---|
| | | switch (type){
|
|---|
| | | case 1: // 按天处理
|
|---|
| | | return dayFactory(startTime, endTime, list);
|
|---|
| | | case 2: // 按月处理
|
|---|
| | | return monthFactory(list);
|
|---|
| | | case 3: |
|---|
| | | return yearFactory(list);
|
|---|
| | | default: |
|---|
| | | return null;
|
|---|
| | | }
|
|---|
| | | return extractAuditRecordMapper.countExtractApplyNumber(state, type, years, startTime, endTime);
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | |
|
|---|
| | | |
|---|
| | | public List<Map<String, Object>> dayFactory(String startTime, String endTime, List<Map<String, Object>> list) throws Exception {
|
|---|
| | |
|
|---|
| | | List<Map<String, Object>> listObject = new ArrayList<Map<String, Object>>();
|
|---|
| | |
|
|---|
| | | if (startTime.equals(endTime)) {
|
|---|
| | |
|
|---|
| | | Map<String, Object> map = list.get(0);
|
|---|
| | | Object total = map.get("total");
|
|---|
| | | if (total == null) {
|
|---|
| | | map.put("total", 0);
|
|---|
| | | }
|
|---|
| | | listObject.add(map);
|
|---|
| | | return listObject;
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | String plusDay = "";
|
|---|
| | | for (int i = 0; i < 1000; i++) {
|
|---|
| | | if (i == 0) {
|
|---|
| | | plusDay = startTime;
|
|---|
| | | } else {
|
|---|
| | | plusDay = DateUtil.plusDay(i, startTime);
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | Map<String, Object> mapObject = new HashMap<String, Object>();
|
|---|
| | | Object total = null;
|
|---|
| | |
|
|---|
| | | for (int j = 0; j < list.size(); j++) {
|
|---|
| | | Map<String, Object> map = list.get(j);
|
|---|
| | | Object createDate = map.get("showDate");
|
|---|
| | | String month = createDate.toString();
|
|---|
| | | if (plusDay.equalsIgnoreCase(month)) {
|
|---|
| | | total = map.get("total");
|
|---|
| | | break;
|
|---|
| | | }
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | if (total == null) {
|
|---|
| | | total = 0;
|
|---|
| | | }
|
|---|
| | | mapObject.put("total", total);
|
|---|
| | |
|
|---|
| | | SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
|
|---|
| | | SimpleDateFormat sdf2 = new SimpleDateFormat("yyyy/MM/dd");
|
|---|
| | | Date parseDate = sdf.parse(plusDay.toString());
|
|---|
| | |
|
|---|
| | | mapObject.put("showDate", sdf2.format(parseDate));
|
|---|
| | |
|
|---|
| | | listObject.add(mapObject);
|
|---|
| | |
|
|---|
| | | if (plusDay.equals(endTime)) {
|
|---|
| | | break; // 时间结束
|
|---|
| | | }
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | return listObject;
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | public List<Map<String, Object>> monthFactory(List<Map<String, Object>> list) {
|
|---|
| | |
|
|---|
| | | List<Map<String, Object>> listObject = new ArrayList<Map<String, Object>>();
|
|---|
| | | // 12 个月处理
|
|---|
| | | for (int i = 1; i <= 12; i++) {
|
|---|
| | | Map<String, Object> mapObject = new HashMap<String, Object>();
|
|---|
| | | Object total = null;
|
|---|
| | |
|
|---|
| | | for (int j = 0; j < list.size(); j++) {
|
|---|
| | | Map<String, Object> map = list.get(j);
|
|---|
| | | Object createDate = map.get("showDate");
|
|---|
| | | String month = createDate.toString();
|
|---|
| | | if ((i + "").equalsIgnoreCase(month) || i == Integer.parseInt(month)) {
|
|---|
| | | total = map.get("total");
|
|---|
| | | break;
|
|---|
| | | }
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | if (total == null) {
|
|---|
| | | total = 0;
|
|---|
| | | }
|
|---|
| | | mapObject.put("total", total);
|
|---|
| | |
|
|---|
| | | mapObject.put("showDate", i + "月");
|
|---|
| | |
|
|---|
| | | listObject.add(mapObject);
|
|---|
| | | }
|
|---|
| | | return listObject;
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | public List<Map<String, Object>> yearFactory(List<Map<String, Object>> list) {
|
|---|
| | |
|
|---|
| | | List<Map<String, Object>> listObject = new ArrayList<Map<String, Object>>();
|
|---|
| | |
|
|---|
| | | for (int i = 0; i < list.size(); i++) {
|
|---|
| | | Map<String, Object> map = list.get(i);
|
|---|
| | | Object total = map.get("total");
|
|---|
| | |
|
|---|
| | | if (total == null) {
|
|---|
| | | total = 0;
|
|---|
| | | }
|
|---|
| | | map.put("total", total);
|
|---|
| | |
|
|---|
| | | listObject.add(map);
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | return listObject;
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | }
|
|---|
