CeDo
2021-05-07 35ff14bdb249a37e9a49db294e59b63ae9ef6c7e
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActMessageDAO.java
@@ -31,8 +31,9 @@
   
   @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}))" +
         " 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> " +