| | |
| | | " com_act_message t LEFT JOIN sys_user u ON t.user_id = u.user_id " + |
| | | " where t.community_id=#{comActMessageVO.communityId}\n" + |
| | | "<if test='comActMessageVO.userAccount != null and comActMessageVO.userAccount.trim() != ""'>" + |
| | | " and t.user_account=#{comActMessageVO.userAccount} \n" + |
| | | " and u.phone=#{comActMessageVO.userAccount} \n" + |
| | | " </if> " + |
| | | "<if test='comActMessageVO.userName != null and comActMessageVO.userName.trim() != ""'>" + |
| | | " and t.user_name=#{comActMessageVO.userName} \n" + |