jczz_manager.git

			@@ -107,7 +107,7 @@
			bus.`name` AS policeName,
			bu.phone AS policePhone,
			jda.address_name,
			bd.dept_name
			jpag.pcs_name deptName
			from jczz_place jp
			left join blade_user bu on bu.id = jp.principal_user_id and bu.is_deleted = 0
			left join jczz_place_ext jpe on jpe.place_id=jp.id and jpe.is_deleted = 0
			@@ -115,7 +115,7 @@
			left join blade_region br on br.code = jg.community_code
			LEFT JOIN jczz_community jc on jc.`code`=jg.community_code
			LEFT JOIN blade_user bus on bus.id = jc.res_police_user_id
			LEFT JOIN blade_dept bd on bd.id = bus.dept_id
			LEFT JOIN jczz_police_affairs_grid jpag on jpag.community_code= jg.community_code
			LEFT JOIN jczz_doorplate_address jda on jda.address_code=jp.house_code
			left join (
			select a.* from jczz_place_poi_label a inner join

			@@ -165,7 +165,7 @@
			jtpr.signature_path,
			jtpr.create_user,
			jtpr.image_urls,
			bd.dept_name,
			jpag.pcs_name deptName,
			jp.id jpid,
			jp.place_name,
			jp.location,
			@@ -186,8 +186,8 @@
			LEFT JOIN blade_region br ON br.`code` = jg.community_code
			LEFT JOIN jczz_place_ext jpe ON jpe.place_id = jp.id
			LEFT JOIN blade_user bu ON bu.id = jtpr.create_user
			LEFT JOIN blade_dept bd ON bu.dept_id = bd.id
			LEFT JOIN jczz_doorplate_address jda on jda.address_code=jtpr.house_code
			LEFT JOIN jczz_police_affairs_grid jpag on jpag.community_code= jg.community_code
			<where>
			<if test="taskPalce.id != null ">and id = #{taskPalce.id}</if>
			<if test="taskPalce.placeCheckId != null ">and place_check_id = #{taskPalce.placeCheckId}</if>

	src/main/java/org/springblade/modules/place/mapper/PlaceMapper.xml	4 ●●●●● patch \| view \| raw \| blame \| history
	src/main/java/org/springblade/modules/taskPlaceRectification/mapper/TaskPlaceRectificationMapper.xml	4 ●●●●● patch \| view \| raw \| blame \| history