TableMapper
@Mapper
public interface TableMapper extends BaseMapperX<TProjectDO> {
IPage<QueryResp> selectNotProjectPage(IPage<QueryResp> page, @Param(Constants.WRAPPER) QueryWrapper<QueryResp> wrapper);
}
TableMapper.xml
select p.a,
p.b,
p.c,
p.d,
p.e,
p.f,
p.g,
rec.h,
pd.id as project_distribution_id,
pd.j,
rec.k,
rec.l
from t_p p
inner join t_pd pd on p.id = pd.t_p_id
inner join t_rec rec on pd.id = rec.t_pd_id
${ew.customSqlSegment}
QueryResp
@Schema(title = "存量项目分配-未分配-响应")
@Data
public class QueryResp {
private String id;
}
Service
@Override
public IPage<QueryResp> listNot(QueryReq req) {
IPage<QueryResp> pages = new Page<>(req.getPageNo(), req.getPageSize());
QueryWrapper<QueryResp> queryWrapper = new QueryWrapper<>();
queryWrapper.eq("p.deleted", 0);
queryWrapper.eq("pd.deleted", 0);
queryWrapper.eq("rec.deleted", 0);
IPage<QueryResp> pageList = tProjectMapper.selectNotProjectPage(pages, queryWrapper);
return pageList;
}