package org.jeecg.modules.spare.mapper;
|
|
import java.util.List;
|
import java.util.Map;
|
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
import org.jeecg.modules.eam.model.InspectionCycleVo;
|
import org.jeecg.modules.spare.entity.SparePart;
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import org.jeecg.modules.spare.vo.AuxiliaryUnitVo;
|
|
/**
|
* @Description: mom_eam_spare_part
|
* @Author: jeecg-boot
|
* @Date: 2023-06-20
|
* @Version: V1.0
|
*/
|
public interface SparePartMapper extends BaseMapper<SparePart> {
|
|
/**
|
* 通过设备备件获取适配的设备
|
* qsw 2023-6-21
|
*/
|
IPage<Map<String, Object>> getSpareContactEquipmentList(IPage<Map> pageData, @Param("params") Map<String,Object> params);
|
|
|
/**
|
*根据主单位获取辅单位
|
*/
|
@Select("select t2.id as value,t2.name as text,t2.name as title from mom_base_unit_conversion t1 inner join mom_base_unit t2 on t1.target_unit_id = t2.id where t1.del_flag = '0' and t2.del_flag = '0' and t1.unit_id = #{mainUnitId}")
|
List<AuxiliaryUnitVo> getAuxiliaryUnits(@Param("mainUnitId")String mainUnitId);
|
|
/**
|
*根据主单位、辅单位获取 唯一换算比例
|
*/
|
@Select("select conversion_ratio as conversionRatio from mom_base_unit_conversion where unit_id = #{mainUnitId} and target_unit_id = #{auxiliaryUnitId} and del_flag = '0'")
|
List<String> getConversionRatio(@Param("mainUnitId")String mainUnitId,@Param("auxiliaryUnitId")String auxiliaryUnitId);
|
}
|
