src/main/java/org/springblade/modules/doorplateAddress/mapper/DoorplateAddressMapper.xml
@@ -307,7 +307,7 @@ jp.id as cid,jp.*,jp.create_time as pcreateTime, bu.real_name as createUserName FROM jczz_doorplate_address jda left join jczz_place jp on locate(jda.address_code,jp.house_code>0 and jp.is_deleted = 0 left join jczz_place jp on locate(jda.address_code,jp.house_code)>0 and jp.is_deleted = 0 left join blade_user bu on bu.id = jp.create_user and bu.is_deleted = 0 WHERE 1=1 <if test="vo.stdId != null and vo.stdId != ''"> src/main/java/org/springblade/modules/place/mapper/PlaceExtMapper.xml
@@ -68,7 +68,7 @@ FROM jczz_place_ext jpe LEFT JOIN jczz_place jp ON jp.id = jpe.place_id and jp.is_deleted = 0 LEFT JOIN jczz_doorplate_address jda ON locate(jda.address_code,jp.house_code>0 LEFT JOIN jczz_doorplate_address jda ON locate(jda.address_code,jp.house_code)>0 <where> <if test="confirmFlag != null"> and jpe.confirm_flag = #{confirmFlag} src/main/java/org/springblade/modules/task/mapper/TaskMapper.xml
@@ -47,7 +47,7 @@ FROM jczz_task jt LEFT JOIN jczz_doorplate_address jda ON jda.address_code = jt.house_code LEFT JOIN jczz_place jp ON locate(jt.house_code,jp.house_code>0 and jp.is_deleted = 0 LEFT JOIN jczz_place jp ON locate(jt.house_code,jp.house_code)>0 and jp.is_deleted = 0 LEFT JOIN blade_user bu on bu.id = jt.create_user and bu.is_deleted = 0 LEFT JOIN jczz_grid_range jgr on jgr.house_code= jt.house_code LEFT JOIN jczz_grid jg on jg.id = jgr.grid_id and jg.is_deleted = 0 @@ -261,7 +261,7 @@ FROM jczz_task jt LEFT JOIN jczz_doorplate_address jda ON jda.address_code = jt.house_code LEFT JOIN jczz_place jp ON locate(jt.house_code,jp.house_code>0 and jp.is_deleted = 0 LEFT JOIN jczz_place jp ON locate(jt.house_code,jp.house_code)>0 and jp.is_deleted = 0 LEFT JOIN blade_user bu on bu.id = jt.create_user and bu.is_deleted = 0 LEFT JOIN jczz_grid_range jgr on jgr.house_code= jt.house_code LEFT JOIN jczz_grid jg on jg.id = jgr.grid_id and jg.is_deleted = 0
