springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/service/impl/NeedProblemInventoryServiceImpl.java
@@ -66,18 +66,15 @@ public int addData(NeedProblemInventoryDTO item) { item.setStatus("1"); int num=baseMapper.addData(item); //1问题清单 2需求清单 if(num>0) { List<String> openIdList=baseMapper.getOpenIdList(item.getCommunityId()); if(openIdList==null || openIdList.size()<=0) { return num; } if(item.getKind().equals("1")) { WxXCXTempSend util = new WxXCXTempSend(); @@ -105,7 +102,6 @@ } } } return num; } springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/resources/mapper/NewStriveForMapper.xml
@@ -72,7 +72,7 @@ LEFT JOIN sys_user as su on su.user_id=cpm.user_id LEFT JOIN com_act as ca on ca.community_id = cpm.community_id LEFT JOIN com_act_integral_user as caiu on cpm.user_id=caiu.user_id and cpm.community_id=caiu.community_id WHERE cpm.check_unit_id=(SELECT check_unit_id FROM com_pb_member WHERE user_id=#{userId}) WHERE cpm.check_unit_id=(SELECT check_unit_id FROM com_pb_member WHERE user_id=#{userId} limit 1) GROUP BY cpm.user_id order by amount desc,user_id desc) as tab ,(SELECT @row_number:=0) AS t