bug修改

张天森

2022-09-27 0a3c08a23b6ba4fcea2a6fbd30bb05d3dfd36a6d

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActMessageDAO.java

@@ -30,8 +30,9 @@
    List<ComActMessageBackVO> selectMsgBackList(@Param("id") Long id);

    @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})))"
        + " ((sendto_user_id in (select id from com_pb_member_role t1 where t1.phone=#{comActMessageVO.phone}) AND type = 2) "
        + " or (sendto_user_id in (select id from com_pb_service_team t2 where t2.phone=#{comActMessageVO.phone}) AND type = 1) "
        + " or (sendto_user_id in (select id from com_act_dpc t3 where t3.phone=#{comActMessageVO.phone}) AND type = 3)) "
        + "<if test='comActMessageVO.status != null'>" + " and status=#{comActMessageVO.status} \n" + " </if> "
        + " order by create_at desc" + "</script>")
    IPage<PageComActMessageVO> pageSendMeMessageApplets(Page page,