| | |
| | | "u.user_id,\n" + |
| | | "u.account,\n" + |
| | | "u.`name`,\n" + |
| | | "u.`password`,\n" + |
| | | "u.phone,\n" + |
| | | "e.role_name,\n" + |
| | | "e.role_id ,\n" + |
| | | "u.`status`,\n" + |
| | | "u.create_at,\n" + |
| | | "u.last_login_time \n" + |
| | |
| | | "AND u.community_id = #{administratorsUserVO.communityId} \n" + |
| | | " </if> " + |
| | | "<if test='administratorsUserVO.name != null and administratorsUserVO.name.trim() != ""'>" + |
| | | "AND u.name = #{administratorsUserVO.name} \n" + |
| | | "AND u.name like concat (#{administratorsUserVO.name},'%') \n" + |
| | | " </if> " + |
| | | "<if test='administratorsUserVO.phone != null and administratorsUserVO.phone.trim() != ""'>" + |
| | | "AND u.phone = #{administratorsUserVO.phone}" + |
| | | "AND u.phone like concat(#{administratorsUserVO.phone},'%') " + |
| | | " </if> " + |
| | | "<if test='administratorsUserVO.account != null and administratorsUserVO.account.trim() != ""'>" + |
| | | "AND u.account = #{administratorsUserVO.account}" + |
| | | "AND u.account like concat(#{administratorsUserVO.account},'%') " + |
| | | " </if> " + |
| | | " </where>" + |
| | | "</script>") |