| | |
|---|
| | | + "SELECT t.id,t.msg_content,t.photo_pah,t.phone,t.sendto_user_id,t.sendto_user_name,t.status,t.ispublic," |
|---|
| | | + "t.user_id,t.user_account,t.user_name,t.user_phone,t.community_id,t.create_at,t.type, u.phone as userAccount \n" |
|---|
| | | + "FROM \n" + " com_act_message t LEFT JOIN sys_user u ON t.user_id = u.user_id " |
|---|
| | | + " where t.community_id=#{comActMessageVO.communityId}\n" |
|---|
| | | + " where t.community_id = ${comActMessageVO.communityId}\n" |
|---|
| | | + "<if test='comActMessageVO.userAccount != null and comActMessageVO.userAccount.trim() != ""'>" |
|---|
| | | + " and u.phone=#{comActMessageVO.userAccount} \n" + " </if> " |
|---|
| | | + "<if test='comActMessageVO.userName != null and comActMessageVO.userName.trim() != ""'>" |
|---|
