| | |
| | | |
| | | @Select("<script> " + |
| | | "SELECT * \n" + |
| | | "FROM\n" + |
| | | "com_act_message t where t.community_id=#{comActMessageVO.communityId}\n" + |
| | | "FROM \n" + |
| | | " com_act_message t " + |
| | | " where t.community_id=#{comActMessageVO.communityId}\n" + |
| | | "<if test='comActMessageVO.userAccount != null and comActMessageVO.userAccount.trim() != ""'>" + |
| | | " and t.user_account=#{comActMessageVO.userAccount} \n" + |
| | | " </if> " + |
| | |
| | | "AND t.create_at BETWEEN #{comActMessageVO.publishAtBegin} \n" + |
| | | "AND #{comActMessageVO.publishAtEnd} \n" + |
| | | " </if> " + |
| | | "<if test='comActMessageVO.type != null and comActMessageVO.type !=0'>" + |
| | | " AND t.type=#{comActMessageVO.type} \n" + |
| | | " </if> " + |
| | | " order by create_at desc"+ |
| | | "</script>") |
| | | IPage<PageComActMessageVO> pageMyCommunityMessageApplets(Page page, @Param("comActMessageVO")ComActMessageVO comActMessageVO); |