From f95e2a385d4cbd07501b512079d7da6aae253a41 Mon Sep 17 00:00:00 2001 From: xuefei <564615061@qq.com> Date: 星期日, 13 十二月 2020 10:01:13 +0800 Subject: [PATCH] 服务机构页面 --- platform-modules/platform-zhyl/src/main/java/cn/cetc54/platform/zhyl/entity/vo/FwjgCount.java | 4 platform-modules/platform-zhyl/src/main/java/cn/cetc54/platform/zhyl/mapper/SubsidyPersonStaticsMapper.java | 2 platform-modules/platform-zhyl/src/main/java/cn/cetc54/platform/zhyl/api/SubsidyAPIController.java | 40 +++ platform-modules/platform-zhyl/src/main/java/cn/cetc54/platform/zhyl/api/FwjgController.java | 36 ++- api.md | 433 ++++++++++++++++++++++++++++++++++++++++++- platform-modules/platform-zhyl/src/main/java/cn/cetc54/platform/zhyl/api/FwdxController.java | 34 +++ 6 files changed, 522 insertions(+), 27 deletions(-) diff --git a/api.md b/api.md index ff2523e..5406aff 100644 --- a/api.md +++ b/api.md @@ -726,9 +726,9 @@ } } ``` -<h4 id='5.3'>5.3鏍规嵁鍖哄煙id鍜岃鍗曢噺鏌ヨ鏈嶅姟鏈烘瀯鎺掑悕鎯呭喌</h4> +<h4 id='5.3'>5.3 鏈嶅姟鏈烘瀯璁㈠崟閲�</h4> ###### 鎺ュ彛鍔熻兘 -> 鏍规嵁鍖哄煙id鍜岃鍗曢噺鏌ヨ鏈嶅姟鏈烘瀯鎺掑悕鎯呭喌 +> 鏈嶅姟鏈烘瀯璁㈠崟閲� ###### URL > /api/fwjg/getFwjgOrderByOrderNumber @@ -747,15 +747,150 @@ ###### 杩斿洖瀛楁 |杩斿洖瀛楁|瀛楁绫诲瀷|璇存槑 | |:----- |:------|:----------------------------- | -| records | list | 鏈嶅姟鏈烘瀯list | +| name | String | 鏈嶅姟鏈烘瀯鍚嶇О | +| orderNumber | int | 璁㈠崟閲� | ###### 鎺ュ彛绀轰緥 ``` java - - +{ + "success": true, + "message": "success", + "code": 200, + "timestamp": 1607822690539, + "result": [ + { + "id": "13", + "createBy": null, + "createTime": null, + "updateBy": null, + "updateTime": null, + "delFlag": 0, + "areaId": null, + "orgFwId": null, + "pid": "1", + "name": "搴峰鎸夋懇", + "orderNumber": 0 + }, + { + "id": "21", + "createBy": null, + "createTime": null, + "updateBy": null, + "updateTime": null, + "delFlag": 0, + "areaId": null, + "orgFwId": null, + "pid": "2", + "name": "涓汉鍗敓鏈嶅姟", + "orderNumber": 0 + }, + { + "id": "22", + "createBy": null, + "createTime": null, + "updateBy": null, + "updateTime": null, + "delFlag": 0, + "areaId": null, + "orgFwId": null, + "pid": "2", + "name": "鍠樻伅鏈嶅姟", + "orderNumber": 0 + }, + { + "id": "23", + "createBy": null, + "createTime": null, + "updateBy": null, + "updateTime": null, + "delFlag": 0, + "areaId": null, + "orgFwId": null, + "pid": "2", + "name": "闄瘖鏈嶅姟", + "orderNumber": 0 + }, + { + "id": "24", + "createBy": null, + "createTime": null, + "updateBy": null, + "updateTime": null, + "delFlag": 0, + "areaId": null, + "orgFwId": null, + "pid": "2", + "name": "鍗忓姪绉讳綅", + "orderNumber": 0 + }, + { + "id": "31", + "createBy": null, + "createTime": null, + "updateBy": null, + "updateTime": null, + "delFlag": 0, + "areaId": null, + "orgFwId": null, + "pid": "3", + "name": "灏忔椂宸�", + "orderNumber": 0 + }, + { + "id": "32", + "createBy": null, + "createTime": null, + "updateBy": null, + "updateTime": null, + "delFlag": 0, + "areaId": null, + "orgFwId": null, + "pid": "3", + "name": "鏃ュ父淇濇磥", + "orderNumber": 0 + }, + { + "id": "33", + "createBy": null, + "createTime": null, + "updateBy": null, + "updateTime": null, + "delFlag": 0, + "areaId": null, + "orgFwId": null, + "pid": "3", + "name": "琛f湇鎷嗘礂缂濊ˉ", + "orderNumber": 0 + }, + { + "id": "41", + "createBy": null, + "createTime": null, + "updateBy": null, + "updateTime": null, + "delFlag": 0, + "areaId": null, + "orgFwId": null, + "pid": "4", + "name": "鍏虫��鏈嶅姟", + "orderNumber": 0 + }, + { + "id": "42", + "createBy": null, + "createTime": null, + "updateBy": null, + "updateTime": null, + "delFlag": 0, + "areaId": null, + "orgFwId": null, + "pid": "4", + "name": "鐢熸椿闄即", + "orderNumber": 0 + } ``` -<h4 id='5.4'>5.4鏍规嵁鍖哄煙id鍜岃鍗曢噺鏌ヨ鏈嶅姟鏈烘瀯鎺掑悕鎯呭喌</h4> +<h4 id='5.4'>5.4 鏈嶅姟棰嗗煙璁㈠崟閲�</h4> ###### 鎺ュ彛鍔熻兘 -> 鏍规嵁鍖哄煙id鍜岃鍗曢噺鏌ヨ瀹為檯鏈嶅姟鎺掑悕鎯呭喌 +> 鏈嶅姟棰嗗煙璁㈠崟閲� ###### URL > /api/fwjg/getFuwuDetailsOrderByOrderNumber @@ -774,10 +909,148 @@ ###### 杩斿洖瀛楁 |杩斿洖瀛楁|瀛楁绫诲瀷|璇存槑 | |:----- |:------|:----------------------------- | -| records | list | 鏈嶅姟璇︽儏list | +| name | String | 鏈嶅姟棰嗗煙鍚嶇О | +| orderNumber | int | 璁㈠崟閲� | ###### 鎺ュ彛绀轰緥 ``` java - +{ + "success": true, + "message": "success", + "code": 200, + "timestamp": 1607823539804, + "result": [ + { + "id": "13", + "createBy": null, + "createTime": null, + "updateBy": null, + "updateTime": null, + "delFlag": 0, + "areaId": null, + "orgFwId": null, + "pid": "1", + "name": "搴峰鎸夋懇", + "orderNumber": 0 + }, + { + "id": "21", + "createBy": null, + "createTime": null, + "updateBy": null, + "updateTime": null, + "delFlag": 0, + "areaId": null, + "orgFwId": null, + "pid": "2", + "name": "涓汉鍗敓鏈嶅姟", + "orderNumber": 0 + }, + { + "id": "22", + "createBy": null, + "createTime": null, + "updateBy": null, + "updateTime": null, + "delFlag": 0, + "areaId": null, + "orgFwId": null, + "pid": "2", + "name": "鍠樻伅鏈嶅姟", + "orderNumber": 0 + }, + { + "id": "23", + "createBy": null, + "createTime": null, + "updateBy": null, + "updateTime": null, + "delFlag": 0, + "areaId": null, + "orgFwId": null, + "pid": "2", + "name": "闄瘖鏈嶅姟", + "orderNumber": 0 + }, + { + "id": "24", + "createBy": null, + "createTime": null, + "updateBy": null, + "updateTime": null, + "delFlag": 0, + "areaId": null, + "orgFwId": null, + "pid": "2", + "name": "鍗忓姪绉讳綅", + "orderNumber": 0 + }, + { + "id": "31", + "createBy": null, + "createTime": null, + "updateBy": null, + "updateTime": null, + "delFlag": 0, + "areaId": null, + "orgFwId": null, + "pid": "3", + "name": "灏忔椂宸�", + "orderNumber": 0 + }, + { + "id": "32", + "createBy": null, + "createTime": null, + "updateBy": null, + "updateTime": null, + "delFlag": 0, + "areaId": null, + "orgFwId": null, + "pid": "3", + "name": "鏃ュ父淇濇磥", + "orderNumber": 0 + }, + { + "id": "33", + "createBy": null, + "createTime": null, + "updateBy": null, + "updateTime": null, + "delFlag": 0, + "areaId": null, + "orgFwId": null, + "pid": "3", + "name": "琛f湇鎷嗘礂缂濊ˉ", + "orderNumber": 0 + }, + { + "id": "41", + "createBy": null, + "createTime": null, + "updateBy": null, + "updateTime": null, + "delFlag": 0, + "areaId": null, + "orgFwId": null, + "pid": "4", + "name": "鍏虫��鏈嶅姟", + "orderNumber": 0 + }, + { + "id": "42", + "createBy": null, + "createTime": null, + "updateBy": null, + "updateTime": null, + "delFlag": 0, + "areaId": null, + "orgFwId": null, + "pid": "4", + "name": "鐢熸椿闄即", + "orderNumber": 0 + } + ] +} ``` <h4 id='5.5'>5.5鎵ц涓鍗�</h4> ###### 鎺ュ彛鍔熻兘 @@ -804,4 +1077,144 @@ | orderByExecuteList | list | 鎵ц涓鍗曡鎯� | ###### 鎺ュ彛绀轰緥 ``` java - +{ + "success": true, + "message": "success", + "code": 200, + "timestamp": 1607824114880, + "result": { + "orderByExecuteList": [ + { + "order": { + "id": "fds3", + "createBy": null, + "createTime": "2020-12-12 21:00:00", + "updateBy": null, + "updateTime": null, + "delFlag": 0, + "areaId": "1", + "detailId": "11", + "detail": "鎸囧璇勪及", + "duixiangId": "1", + "personId": "1", + "state": 0 + }, + "fuwuPerson": { + "id": "1", + "createBy": null, + "createTime": "2020-12-11 14:17:55", + "updateBy": null, + "updateTime": null, + "delFlag": 0, + "areaId": "1", + "name": "寮犱笁", + "age": null, + "sex": null, + "sfzhm": null, + "orgFwId": "1" + }, + "fuwuDetails": { + "id": "11", + "createBy": null, + "createTime": null, + "updateBy": null, + "updateTime": null, + "delFlag": 0, + "areaId": null, + "orgFwId": null, + "pid": "1", + "name": "鎸囧璇勪及", + "orderNumber": null + } + }, + { + "order": { + "id": "1", + "createBy": null, + "createTime": "2020-12-17 17:27:37", + "updateBy": null, + "updateTime": null, + "delFlag": 0, + "areaId": "1", + "detailId": "11", + "detail": "鎸囧璇勪及", + "duixiangId": "1", + "personId": "1", + "state": 0 + }, + "fuwuPerson": { + "id": "1", + "createBy": null, + "createTime": "2020-12-11 14:17:55", + "updateBy": null, + "updateTime": null, + "delFlag": 0, + "areaId": "1", + "name": "寮犱笁", + "age": null, + "sex": null, + "sfzhm": null, + "orgFwId": "1" + }, + "fuwuDetails": { + "id": "11", + "createBy": null, + "createTime": null, + "updateBy": null, + "updateTime": null, + "delFlag": 0, + "areaId": null, + "orgFwId": null, + "pid": "1", + "name": "鎸囧璇勪及", + "orderNumber": null + } + }, + { + "order": { + "id": "2", + "createBy": null, + "createTime": "2020-12-24 17:27:41", + "updateBy": null, + "updateTime": null, + "delFlag": 0, + "areaId": "1", + "detailId": "12", + "detail": "鍔熻兘璁粌", + "duixiangId": "1", + "personId": "1", + "state": 1 + }, + "fuwuPerson": { + "id": "1", + "createBy": null, + "createTime": "2020-12-11 14:17:55", + "updateBy": null, + "updateTime": null, + "delFlag": 0, + "areaId": "1", + "name": "寮犱笁", + "age": null, + "sex": null, + "sfzhm": null, + "orgFwId": "1" + }, + "fuwuDetails": { + "id": "12", + "createBy": null, + "createTime": null, + "updateBy": null, + "updateTime": null, + "delFlag": 0, + "areaId": null, + "orgFwId": null, + "pid": "1", + "name": "鍔熻兘璁粌", + "orderNumber": null + } + } + ], + "count": 3 + } +} +銆併�併�� diff --git a/platform-modules/platform-zhyl/src/main/java/cn/cetc54/platform/zhyl/api/FwdxController.java b/platform-modules/platform-zhyl/src/main/java/cn/cetc54/platform/zhyl/api/FwdxController.java index 55d86a2..cf2a359 100644 --- a/platform-modules/platform-zhyl/src/main/java/cn/cetc54/platform/zhyl/api/FwdxController.java +++ b/platform-modules/platform-zhyl/src/main/java/cn/cetc54/platform/zhyl/api/FwdxController.java @@ -9,6 +9,7 @@ import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; +import lombok.Data; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.transaction.annotation.Transactional; @@ -17,8 +18,10 @@ import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; +import java.util.ArrayList; import java.util.Date; import java.util.List; +import java.util.Map; /** * @author xfei @@ -69,8 +72,35 @@ if (StrUtil.isEmpty(areaId)){ return ResultUtil.error("缂哄皯鍙傛暟"); } - List result = iSubsidyPersonStaticsService.getMonthAddOut(areaId,type); - return ResultUtil.data(result); + List<Map<String,Object>> result = iSubsidyPersonStaticsService.getMonthAddOut(areaId,type); + StatisVO vo = new StatisVO(); + result.forEach(e->{ + String month = (String) e.get("month"); + int mAdd = Integer.parseInt(String.valueOf(e.get("mAdd"))); + int mOut = Integer.parseInt(String.valueOf(e.get("mOut"))); + int checkNum = Integer.parseInt(String.valueOf(e.get("checkNum"))); + int totalNum = Integer.parseInt(String.valueOf(e.get("totalNum"))); + vo.month.add(0,month.split("-")[1]); + vo.mAdd.add(0,mAdd); + vo.mOut.add(0,mOut); + vo.checkNum.add(0,checkNum); + vo.totalNum.add(0,totalNum); + }); + return ResultUtil.data(vo); + + } + @Data + class StatisVO{ + //鏈堜唤 + List month = new ArrayList(); + //鏈堟柊澧� + List mAdd = new ArrayList(); + //鏈堥��鍑� + List mOut = new ArrayList(); + //鏈堝鏍告暟 + List checkNum = new ArrayList(); + //鏈堝鏍告暟 + List totalNum = new ArrayList(); } diff --git a/platform-modules/platform-zhyl/src/main/java/cn/cetc54/platform/zhyl/api/FwjgController.java b/platform-modules/platform-zhyl/src/main/java/cn/cetc54/platform/zhyl/api/FwjgController.java index efd88cb..d495f21 100644 --- a/platform-modules/platform-zhyl/src/main/java/cn/cetc54/platform/zhyl/api/FwjgController.java +++ b/platform-modules/platform-zhyl/src/main/java/cn/cetc54/platform/zhyl/api/FwjgController.java @@ -9,6 +9,7 @@ import cn.cetc54.platform.zhyl.entity.vo.FwnlAndOrderCount; import cn.cetc54.platform.zhyl.entity.vo.OrderByExecute; import cn.cetc54.platform.zhyl.service.*; +import cn.hutool.core.util.StrUtil; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; import io.swagger.annotations.Api; @@ -31,8 +32,6 @@ @Transactional @CrossOrigin("*") public class FwjgController { - @Autowired - private IAreaService iAreaService; @Autowired private IOrgFuwuService iOrgFuwuService; @Autowired @@ -73,6 +72,7 @@ QueryWrapper<FuwuDetails> wrapper = new QueryWrapper<>(); wrapper.isNull("pid"); List<FuwuDetails> list = iFuwuDetailsService.list(wrapper); + List<FwnlAndOrderCount> fwnlAndOrderCountList=new ArrayList<>(); for (FuwuDetails fuwuDetails : list) { QueryWrapper<FuwuDetails> wrapper1 = new QueryWrapper<>(); @@ -80,7 +80,9 @@ List<FuwuDetails> list1 = iFuwuDetailsService.list(wrapper1); for (FuwuDetails details : list1) { QueryWrapper<Order> wrapper2 = new QueryWrapper<>(); - wrapper2.eq("area_id",areaId); + if (StrUtil.isNotBlank(areaId)){ + wrapper2.eq("area_id",areaId); + } wrapper2.eq("detail_id",details.getId()); int count = iOrderService.count(wrapper2); details.setOrderNumber(count); @@ -128,28 +130,42 @@ @RequestMapping(value = "/getFuwuDetailsOrderByOrderNumber", method = RequestMethod.GET) @ApiOperation(value = "鏍规嵁鍖哄煙id鍜岃鍗曢噺鏌ヨ瀹為檯鏈嶅姟鎺掑悕鎯呭喌") public Result<Object> getFuwuDetailsOrderByOrderNumber(String areaId){ + if (StrUtil.isNotBlank(areaId)&&areaId.equals("0")){ + //濡傛灉鏄叏甯� areaId璁剧疆鏈┖ + areaId = null; + } QueryWrapper<FuwuDetails> wrapper = new QueryWrapper<>(); wrapper.isNotNull("pid"); wrapper.eq("del_flag",0); List<FuwuDetails> list = iFuwuDetailsService.list(wrapper); for (FuwuDetails fuwuDetails : list) { QueryWrapper<Order> wrapper3 = new QueryWrapper<>(); - wrapper3.eq("area_id",areaId); + if (StrUtil.isNotBlank(areaId)){ + wrapper3.eq("area_id",areaId); + } wrapper3.eq("detail_id",fuwuDetails.getId()); int count = iOrderService.count(wrapper3); fuwuDetails.setOrderNumber(count); } List<FuwuDetails> collectList = list.stream().sorted(Comparator.comparing(FuwuDetails::getOrderNumber)).collect(Collectors.toList()); - return new ResultUtil<Object>().setData(collectList.subList(0,10)); + List<FuwuDetails> resList = collectList.size()>10?collectList.subList(0,10):collectList; + return ResultUtil.data(resList); } @RequestMapping(value = "/getOrder", method = RequestMethod.GET) @ApiOperation(value = "鎵ц涓鍗�") public Result<Object> getOrder(String areaId){ + if (StrUtil.isNotBlank(areaId)&&areaId.equals("0")){ + //濡傛灉鏄叏甯� areaId璁剧疆鏈┖ + areaId = null; + } QueryWrapper<Order> wrapper = new QueryWrapper<>(); - wrapper.eq("area_id",areaId); - wrapper.eq("state",0); - wrapper.orderByAsc("creat_time"); + if (StrUtil.isNotBlank(areaId)){ + wrapper.eq("area_id",areaId); + } + +// wrapper.eq("state",0); + wrapper.orderByAsc("create_time"); List<Order> list = iOrderService.list(wrapper); int count = iOrderService.count(wrapper); List<OrderByExecute> orderByExecuteList=new ArrayList<>(); @@ -167,8 +183,4 @@ map.put("orderByExecuteList",orderByExecuteList); return new ResultUtil<Object>().setData(map); } - - - - } diff --git a/platform-modules/platform-zhyl/src/main/java/cn/cetc54/platform/zhyl/api/SubsidyAPIController.java b/platform-modules/platform-zhyl/src/main/java/cn/cetc54/platform/zhyl/api/SubsidyAPIController.java index 66699d5..914a739 100644 --- a/platform-modules/platform-zhyl/src/main/java/cn/cetc54/platform/zhyl/api/SubsidyAPIController.java +++ b/platform-modules/platform-zhyl/src/main/java/cn/cetc54/platform/zhyl/api/SubsidyAPIController.java @@ -5,6 +5,7 @@ import cn.cetc54.platform.zhyl.service.ISubsidyLogService; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; +import lombok.Data; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.CrossOrigin; @@ -12,7 +13,9 @@ import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; +import java.util.ArrayList; import java.util.HashMap; +import java.util.List; import java.util.Map; /** @@ -43,10 +46,43 @@ @ApiOperation(value = "骞村害鏈堝害缁熻鏁版嵁") public Result getStatistics(String areaId,Integer type){ Map<String,Object> resMap = new HashMap<>(); - resMap.put("monthStatistics",iSubsidyLogService.getMonthTotal(areaId,type)); - resMap.put("yearStatistics",iSubsidyLogService.getYearTotal(areaId,type)); + List<Map<String,Object>> monthList = iSubsidyLogService.getMonthTotal(areaId,type); + List<Map<String,Object>> yearList = iSubsidyLogService.getYearTotal(areaId,type); + + List<String> month = new ArrayList<>(); + List<Double> mSum = new ArrayList<>(); + monthList.forEach(e->{ + String d = (String) e.get("time"); + double s = (double) e.get("sum"); + month.add(0,d.split("-")[1]); + mSum.add(0,s); + }); + StatisticsVo mS = new StatisticsVo(); + mS.setTime(month); + mS.setSum(mSum); + + List<String> year = new ArrayList<>(); + List<Double> ySum = new ArrayList<>(); + yearList.forEach(e->{ + String d = (String) e.get("time"); + double s = (double) e.get("sum"); + year.add(0,d); + ySum.add(0,s); + }); + StatisticsVo yS = new StatisticsVo(); + yS.setTime(year); + yS.setSum(ySum); + + + resMap.put("monthStatistics",mS); + resMap.put("yearStatistics",yS); return ResultUtil.data(resMap); } + @Data + class StatisticsVo{ + Object time; + Object sum; + } } diff --git a/platform-modules/platform-zhyl/src/main/java/cn/cetc54/platform/zhyl/entity/vo/FwjgCount.java b/platform-modules/platform-zhyl/src/main/java/cn/cetc54/platform/zhyl/entity/vo/FwjgCount.java index bec9d4a..7a01df4 100644 --- a/platform-modules/platform-zhyl/src/main/java/cn/cetc54/platform/zhyl/entity/vo/FwjgCount.java +++ b/platform-modules/platform-zhyl/src/main/java/cn/cetc54/platform/zhyl/entity/vo/FwjgCount.java @@ -4,8 +4,12 @@ @Data public class FwjgCount { + //鏈嶅姟鏈烘瀯鎬绘暟 private Integer fwjgCount; + //鏈嶅姟浜哄憳鎬绘暟 private Integer fwPersonCount; + //璁㈠崟鎬绘暟 private Integer orderCount; + //璁㈠崟鐩戞帶鐜� private String orderWatch; } diff --git a/platform-modules/platform-zhyl/src/main/java/cn/cetc54/platform/zhyl/mapper/SubsidyPersonStaticsMapper.java b/platform-modules/platform-zhyl/src/main/java/cn/cetc54/platform/zhyl/mapper/SubsidyPersonStaticsMapper.java index 6de56e5..7df4b46 100644 --- a/platform-modules/platform-zhyl/src/main/java/cn/cetc54/platform/zhyl/mapper/SubsidyPersonStaticsMapper.java +++ b/platform-modules/platform-zhyl/src/main/java/cn/cetc54/platform/zhyl/mapper/SubsidyPersonStaticsMapper.java @@ -19,7 +19,7 @@ * @return */ @Select("<script>" + - "select month,SUM(month_add) as mAdd,SUM(month_out) as mOut,SUM(check_num) as checkNum,SUM(total_num) as totalName " + + "select month,SUM(month_add) as mAdd,SUM(month_out) as mOut,SUM(check_num) as checkNum,SUM(total_num) as totalNum " + "FROM t_yl_subsidy_person_statics " + " <where> " + "area_id = #{areaId} " + -- Gitblit v1.9.1