优化代码

1098226878

2021-09-14 0849670f03eaa4b5de71c11558e6baf6ac8d2586

优化代码

 java110-db/src/main/resources/mapper/community/FloorV1ServiceDaoImplMapper.xml

@@ -21,9 +21,11 @@

    <!-- 查询楼栋信息 add by wuxw 2018-07-03 -->
    <select id="getFloorInfo" parameterType="Map" resultType="Map">
        select  t.floor_id,t.floor_id floorId,t.name,t.remark,t.b_id,t.b_id bId,t.community_id,t.community_id communityId,t.user_id,t.user_id userId,t.floor_num,t.floor_num floorNum,t.floor_area,t.floor_area floorArea 
        select  t.floor_id,t.floor_id floorId,t.name floorName,t.remark,t.b_id,t.b_id bId,t.community_id,t.community_id communityId,t.user_id,t.user_id userId,t3.name userName,
        t.floor_num,t.floor_num floorNum,t.floor_area,t.floor_area floorArea
from f_floor t
LEFT JOIN f_floor_attr t2 on t.floor_id = t2.floor_id
        LEFT JOIN u_user t3 on t.user_id = t3.user_id and t3.status_cd = 0
where t2.spec_cd='100201912001' and t2.value='8008' and t.status_cd=0
<if test="floorId !=null and floorId != ''">
   and t.floor_id= #{floorId}
@@ -97,6 +99,7 @@
        select  count(1) count 
from f_floor t
LEFT JOIN f_floor_attr t2 on t.floor_id = t2.floor_id
         LEFT JOIN u_user t3 on t.user_id = t3.user_id and t3.status_cd = 0
where t2.spec_cd='100201912001' and t2.value='8008' and t.status_cd=0
<if test="floorId !=null and floorId != ''">
   and t.floor_id= #{floorId}