InspectionPlanPointMapper.java
1021 字节
package com.skua.modules.inspection.mapper;
import java.util.List;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.skua.modules.inspection.entity.InspectionPoint;
import com.skua.modules.inspection.vo.InspectionPlanPointVO;
import org.apache.ibatis.annotations.Param;
import com.skua.modules.inspection.entity.InspectionPlanPoint;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;
/**
* 巡检计划
*/
public interface InspectionPlanPointMapper extends BaseMapper<InspectionPlanPoint> {
@Select({"select ipa.id,ia.id inspection_point_id,point_name,point_desc from inspection_plan_point ipa right join inspection_point ia on ipa.inspection_point_id = ia.id and inspection_plan_id=#{planId} ${ew.customSqlSegment}"})
List<InspectionPlanPointVO> getInspectionPoint(@Param(Constants.WRAPPER) QueryWrapper<InspectionPoint> queryWrapper, @Param("planId") String planId);
}