From 73c73c150d4b418849f779bf7a296713d8ff7cc1 Mon Sep 17 00:00:00 2001 From: yuxc <653031404@qq.com> Date: 星期四, 14 十二月 2023 18:22:27 +0800 Subject: [PATCH] 1、数据统计接口查询数据为空则每月返回为零。 --- Source/UBCS/ubcs-service/ubcs-code/src/main/java/com/vci/ubcs/code/service/impl/MdmEngineServiceImpl.java | 8 ++++---- Source/UBCS/ubcs-service/ubcs-system/src/main/java/com/vci/ubcs/system/service/impl/StatisticConfigServiceImpl.java | 1 + 2 files changed, 5 insertions(+), 4 deletions(-) diff --git a/Source/UBCS/ubcs-service/ubcs-code/src/main/java/com/vci/ubcs/code/service/impl/MdmEngineServiceImpl.java b/Source/UBCS/ubcs-service/ubcs-code/src/main/java/com/vci/ubcs/code/service/impl/MdmEngineServiceImpl.java index d744a7a..8faa36a 100644 --- a/Source/UBCS/ubcs-service/ubcs-code/src/main/java/com/vci/ubcs/code/service/impl/MdmEngineServiceImpl.java +++ b/Source/UBCS/ubcs-service/ubcs-code/src/main/java/com/vci/ubcs/code/service/impl/MdmEngineServiceImpl.java @@ -1168,10 +1168,7 @@ "order by to_char(CREATETIME, 'mm')"; //鏌ヨ鍑洪渶瑕佸鐞嗙殑鏁版嵁 List<Map> maps = commonsMapper.selectBySql(sql); - if(maps.size() == 0){ - throw new ServiceException("浼犲叆绫诲瀷["+ datum.getName() + ":" + - datum.getId() +"]鏈煡鍒扮浉鍏崇粺璁℃暟鎹紝璇风‘璁�!!!!"); - } + //褰撳勾姣忔湀鏈堜唤涔嬪墠涔嬪拰 List<Integer> monthCount = new ArrayList<>(12); //褰撳勾姣忔湀鐨勬湀浠芥暟鎹� @@ -1179,6 +1176,9 @@ //鑾峰彇褰撳墠鏈堢殑鏁板瓧 Calendar instance = Calendar.getInstance(); int nowmonth = instance.get(Calendar.MONTH) + 1; + if(maps.size() == 0){ + nowmonth = 0; + } //浠�1鍒�12鏈堣繘琛屽鐞� for (Integer i = 1; i <= 12; i++) { //褰撳墠鏈堝悗鎵�鏈夋暟鎹缃负0 diff --git a/Source/UBCS/ubcs-service/ubcs-system/src/main/java/com/vci/ubcs/system/service/impl/StatisticConfigServiceImpl.java b/Source/UBCS/ubcs-service/ubcs-system/src/main/java/com/vci/ubcs/system/service/impl/StatisticConfigServiceImpl.java index 1168900..0c5c98c 100644 --- a/Source/UBCS/ubcs-service/ubcs-system/src/main/java/com/vci/ubcs/system/service/impl/StatisticConfigServiceImpl.java +++ b/Source/UBCS/ubcs-service/ubcs-system/src/main/java/com/vci/ubcs/system/service/impl/StatisticConfigServiceImpl.java @@ -96,6 +96,7 @@ public R getBtmAndChartIds() { QueryWrapper<StatisticConfig> wrapper = new QueryWrapper<>(); wrapper.eq("user_id", AuthUtil.getUser().getUserId()); + wrapper.isNotNull("chart_ids"); List<StatisticConfig> list = this.list(wrapper); Map<String, String> collect = list.stream().collect(Collectors.toMap(StatisticConfig::getBtmname, StatisticConfig::getChartIds)); return R.data(collect); -- Gitblit v1.9.3