package com.skua.modules.inspection.mapper;


import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.skua.modules.inspection.vo.InspectionPointVO;
import org.apache.ibatis.annotations.Param;
import com.skua.modules.inspection.entity.InspectionPoint;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;

/**
 * 巡检点
 */
public interface InspectionPointMapper extends BaseMapper<InspectionPoint> {

    @Select("select *,(select count(*) from inspection_point_fill_group ipfg where ipfg.inspection_point_id = ip.id) fill_group_count from inspection_point ip ${ew.customSqlSegment}")
    IPage<InspectionPointVO> getPage(Page<InspectionPointVO> page, @Param(Constants.WRAPPER) QueryWrapper<InspectionPointVO> queryWrapper);
}