| | |
|---|
| | | 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, |
|---|
