| | |
| | | void updatePublic(@Param("ispublic") Integer ispublic,@Param("id") Long id); |
| | | |
| | | @Select("<script> " + |
| | | "SELECT * \n" + |
| | | "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 " + |
| | | " 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" + |