package org.jeecg.modules.mdc.mapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import org.apache.ibatis.annotations.Param;
|
import org.jeecg.modules.mdc.entity.MdcEquipment;
|
import org.jeecg.modules.mdc.entity.MdcEquipmentMonitor;
|
import org.jeecg.modules.mdc.vo.MdcEquipmentDepVo;
|
import org.jeecg.modules.mdc.vo.MdcEquipmentProVo;
|
|
import java.util.List;
|
|
/**
|
* @Description: 设备表
|
* @Author: liuS
|
* @Date: 2023-03-22
|
* @Version: V1.0
|
*/
|
public interface MdcEquipmentMapper extends BaseMapper<MdcEquipment> {
|
|
/**
|
* 根据设备Ids,查询设备所属部门名称信息
|
*/
|
List<MdcEquipmentDepVo> getDepNamesByEquipmentIds(@Param("equipmentIds") List<String> equipmentIds);
|
|
/**
|
* 根据设备Ids,查询设备所属产线名称信息
|
*/
|
List<MdcEquipmentProVo> getProNamesByEquipmentIds(@Param("equipmentIds") List<String> equipmentIds);
|
|
/**
|
* 根据部门id查询设备列表
|
*/
|
IPage<MdcEquipment> pageListByDepId(Page<MdcEquipment> page, @Param("departId") String departId, @Param("equipmentId") String equipmentId);
|
|
/**
|
* 根据产线id查询设备列表
|
*/
|
IPage<MdcEquipment> pageListByProId(Page<MdcEquipment> page, @Param("productionId") String productionId, @Param("equipmentId") String equipmentId);
|
|
/**
|
* 根据部门id查询设备
|
*/
|
List<MdcEquipment> queryByDepartId(@Param("departId") String departId);
|
|
/**
|
* 根据产线id查询设备
|
*/
|
List<MdcEquipment> queryByProductionId(@Param("productionId") String productionId);
|
|
/**
|
* 查找设备监控信息
|
*/
|
List<MdcEquipmentMonitor> checkStatusFromEquipmentIds(@Param("equipmentIds") List<String> equipmentIds);
|
|
/**
|
* 根据产线id查询设备id集合
|
*/
|
List<String> queryIdsByProductions(@Param("allProductionIds") List<String> allProductionIds);
|
|
/**
|
* 根据部门id查询设备id集合
|
*/
|
List<String> queryIdsByDeparts(@Param("allDepartIds") List<String> allDepartIds);
|
}
|
