package com.panzhihua.service_community.dao;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.panzhihua.common.model.dtos.neighbor.DetailNeighborCommentReplyByAdminDTO;
|
import com.panzhihua.common.model.vos.neighbor.ComActNeighborCommentReplyByAdminVO;
|
import com.panzhihua.service_community.model.dos.ComActNeighborCircleCommentReplyDO;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Select;
|
|
/**
|
* @auther lyq
|
* @create 2021-04-28 09:21:45
|
* @describe 邻里圈评论回复表mapper类
|
*/
|
@Mapper
|
public interface ComActNeighborCircleCommentReplyDAO extends BaseMapper<ComActNeighborCircleCommentReplyDO> {
|
|
@Select("<script> " +
|
"select cr.*,u.name as userName from com_act_neighbor_circle_comment_reply cr left join sys_user u on cr.user_id=u.user_id " +
|
"<where>"+
|
"<if test='dto.id != null and pageActWorkGuideDTO.dto!= 0l'>" +
|
"comment_id = #{dto.id}"+
|
" </if> " +
|
"</where>"+
|
" ORDER BY create_at"+
|
"</script>")
|
Page<ComActNeighborCommentReplyByAdminVO> selectListByComment(Page<ComActNeighborCircleCommentReplyDO> page, DetailNeighborCommentReplyByAdminDTO dto);
|
|
}
|
