From c1805d7cd4227345f496989b349b602a3665ef7a Mon Sep 17 00:00:00 2001 From: CeDo <cedoogle@gmail.com> Date: 星期五, 07 五月 2021 14:29:42 +0800 Subject: [PATCH] bugfixed --- springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActMessageDAO.java | 10 +++++++++- 1 files changed, 9 insertions(+), 1 deletions(-) diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActMessageDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActMessageDAO.java index 18d0e81..40683b9 100644 --- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActMessageDAO.java +++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActMessageDAO.java @@ -29,7 +29,15 @@ @Select("select * from com_act_message_back where msg_id=#{id} order by create_at desc") List<ComActMessageBackVO> selectMsgBackList(@Param("id")Long id); - @Select("select * from com_act_message where (sendto_user_id in (select id from com_pb_member_role t1 where t1.phone=#{comActMessageVO.phone})) or (sendto_user_id in (select id from com_pb_service_team t2 where t2.phone=#{comActMessageVO.phone})) order by create_at desc") + @Select("<script>" + + "select * from com_act_message " + + " where (sendto_user_id in (select id from com_pb_member_role t1 where t1.phone=#{comActMessageVO.phone})) " + + " or (sendto_user_id in (select id from com_pb_service_team t2 where t2.phone=#{comActMessageVO.phone}))" + + "<if test='comActMessageVO.status != null'>" + + " and status=#{comActMessageVO.status} \n" + + " </if> " + + " order by create_at desc"+ + "</script>") IPage<PageComActMessageVO> pageSendMeMessageApplets(Page page, @Param("comActMessageVO")ComActMessageVO comActMessageVO); @Select("select * from com_act_message where user_id=#{comActMessageVO.userId} order by create_at desc") -- Gitblit v1.7.1