package org.jeecg.modules.eam.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.jeecg.modules.eam.entity.DailyInspectionStandardDetail;
import org.jeecg.modules.eam.model.InspectionCycleVo;

import java.util.List;
import java.util.Map;

/**
 * @Description: mom_eam_daily_inspection_standard_detail
 * @Author: jeecg-boot
 * @Date:   2023-03-10
 * @Version: V1.0
 */
public interface DailyInspectionStandardDetailMapper extends BaseMapper<DailyInspectionStandardDetail> {

    List<Map<String, Object>> getInspectionStandardDetailList(@Param("inspectionStandardId")String inspectionStandardId);

    IPage<Map<String, Object>> getInspectionStandardDetailById(IPage<Map> pageData, @Param("params") Map<String,Object> params);

//    @Select("select t1.id as value,concat(t1.code, '/', t1.cycle,t1.cycle_unit) as text,concat(t1.code, '/', t1.cycle,t1.cycle_unit) as title from mom_eam_inspection_cycle t1 left join mom_sys_data_version t2 on t1.id = t2.business_id where t1.del_flag = '0' and t2.version_status = '2'")
    @Select("select t1.id as value,concat(t1.code, '/', t1.name) as text,concat(t1.code, '/', t1.name) as title from mom_eam_inspection_cycle t1 where t1.del_flag = '0' and version_status = '2'")
    List<InspectionCycleVo> getInspectionCycle();
}