| | |
| | | @Select("select type,name,phone,image_url from sys_user where user_id=#{userId}") |
| | | LoginUserInfoVO selectUserByUserId(Long userId); |
| | | |
| | | @Select("select user_id from sys_user where user_id=#{name} limit 1") |
| | | @Select("select user_id from sys_user where name like concat('%',#{name},'%') limit 1") |
| | | Long selectUserIdByName(String name); |
| | | |
| | | @Select("<script> " + |
| | |
| | | "AND d.status in (1,3) \n" + |
| | | " </if> " + |
| | | "<if test='pageComOpsHouseDTO.houseCommunityName != null and pageComOpsHouseDTO.houseCommunityName.trim() != ""'>" + |
| | | " and d.`house_community_name` LIKE concat( #{pageComOpsHouseDTO.houseCommunityName}, '%' ) \n" + |
| | | " and (" + |
| | | " d.`house_community_name` LIKE concat( '%', #{pageComOpsHouseDTO.houseCommunityName}, '%' ) " + |
| | | " or d.title like concat( '%', #{pageComOpsHouseDTO.houseCommunityName}, '%' ) " + |
| | | " ) \n" + |
| | | " </if> " + |
| | | "<if test='pageComOpsHouseDTO.mobile != null and pageComOpsHouseDTO.mobile.trim() != ""'>" + |
| | | " and d.`mobile` LIKE concat( #{pageComOpsHouseDTO.mobile}, '%' ) \n" + |