java/zhihuishenqu.git

			@@ -644,7 +644,7 @@

			List<String> getPopulationListCardNo(@Param("streetId") Long streetId);

			Integer getPopulationAge(@Param("streetId") Long streetId);
			Integer getPopulationAge(@Param("streetId") Long streetId, @Param("age") Integer age);

			List<EventPopulationStreetVO> getComprehensiveStreetList();
			}

			@@ -7768,7 +7768,8 @@
			populationSpecial.setOtherTotal(populationSpecial.getZjTotal() + populationSpecial.getSfTotal()
			+ populationSpecial.getXsTotal() + populationSpecial.getXjTotal()
			+ populationSpecial.getJzTotal() + populationSpecial.getXdTotal());
			populationSpecial.setLnTotal(comMngPopulationDAO.getPopulationAge(streetId));
			populationSpecial.setLnTotal(comMngPopulationDAO.getPopulationAge(streetId,60));
			populationSpecial.setGlTotal(comMngPopulationDAO.getPopulationAge(streetId,80));
			statisticsVo.setSpecialStatisticsVo(populationSpecial);
			}
			return R.ok(statisticsVo);

			@@ -877,19 +877,6 @@
			) as dbTotal ,
			(
			SELECT
			count( cmpct2.id )
			FROM
			com_mng_population_community_tags AS cmpct2
			LEFT JOIN com_act AS ca2 ON ca2.community_id = cmpct2.community_id
			LEFT JOIN com_street AS cs2 ON cs2.street_id = ca2.street_id
			WHERE
			cmpct2.label LIKE '%高龄老人%' and ca2.area_code = '510423' and ca2.is_screen_statistics = 1
			<if test="streetId != null and streetId != 0">
			and cs2.street_id = #{streetId}
			</if>
			) as glTotal ,
			(
			SELECT
			count( cmpct3.id )
			FROM
			com_mng_population_community_tags AS cmpct3
			@@ -1063,7 +1050,7 @@
			and cs.street_id = #{streetId}
			</if>
			</where>
			having age >= 60
			having age >= #{age}
			) as ageDual
			</select>

	springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngPopulationDAO.java	2 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComMngPopulationServiceImpl.java	3 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComMngPopulationDOMapper.xml	15 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史