| | |
| | | " ) t " + |
| | | " LEFT JOIN com_elders_auth ea ON t.id = ea.id " + |
| | | " LEFT JOIN sys_user u ON ea.SUMIT_USER_ID = u.user_id\n" + |
| | | " LEFT JOIN com_act ac ON u.community_id = ac.community_id\n" + |
| | | " <where> " + |
| | | |
| | | "<if test='pageEldersAuthDTO.communityId != null'>" + |
| | | " AND ac.community_id = #{pageEldersAuthDTO.communityId} " + |
| | | " </if> " + |
| | | |
| | | "<if test='pageEldersAuthDTO.sumitUserId != null'>" + |
| | | " AND ea.SUMIT_USER_ID = #{pageEldersAuthDTO.sumitUserId} " + |
| | | " </if> " + |
| | |
| | | " LEFT JOIN com_act ac ON u.community_id = ac.community_id\n" + |
| | | " <where> " + |
| | | |
| | | "<if test='pageEldersAuthDTO.communityId != null'>" + |
| | | " AND ac.community_id = #{pageEldersAuthDTO.communityId} " + |
| | | " </if> " + |
| | | |
| | | "<if test='pageEldersAuthDTO.ids != null and pageEldersAuthDTO.ids.length>0 '>" + |
| | | " AND ea.id in " + |
| | | "<foreach collection='pageEldersAuthDTO.ids' item='id' index='index' open='(' close=')' separator=',' >\n" + |