package org.jeecg.modules.mdc.mapper;
|
|
import com.baomidou.mybatisplus.annotation.InterceptorIgnore;
|
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.apache.ibatis.annotations.Select;
|
import org.jeecg.modules.mdc.dto.MdcEquDepDto;
|
import org.jeecg.modules.mdc.dto.MdcEquProDto;
|
import org.jeecg.modules.mdc.dto.MdcEquipmentDto;
|
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 org.jeecg.modules.mdc.vo.MdcEquipmentVo;
|
import org.jeecg.modules.mdc.vo.WorkshopEquipmentVo;
|
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* @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);
|
|
/**
|
* 根据设备编号查询设备信息和部门信息
|
*
|
* @param equipmentIdList
|
* @return
|
*/
|
List<MdcEquDepDto> findEquDepList(@Param("equipmentIdList") List<String> equipmentIdList);
|
|
/**
|
* 根据设备编号查询设备信息和产线信息
|
*
|
* @param equipmentIdList
|
* @return
|
*/
|
List<MdcEquProDto> findEquProList(@Param("equipmentIdList") List<String> equipmentIdList);
|
|
/**
|
* 根据大屏车间id查询设备列表
|
*/
|
IPage<MdcEquipment> getEquipmentByWorkshopId(Page<MdcEquipment> page, @Param("workshopEquipmentVo") WorkshopEquipmentVo workshopEquipmentVo);
|
|
/**
|
* 分页列表
|
*/
|
IPage<MdcEquipment> pageList(Page<MdcEquipment> page, @Param("mdcEquipment") MdcEquipmentVo mdcEquipment);
|
|
@InterceptorIgnore(tenantLine = "1")
|
@Select("select TOP 1 CollectTime ${columns} from [${tableName}] order by CollectTime desc")
|
Map<String, Object> getWorkLineLast(Map<String, Object> param);
|
|
/**
|
* 导出list
|
* @param mdcEquipment
|
* @return
|
*/
|
List<MdcEquipment> exportXlsList(@Param("mdcEquipment") MdcEquipmentVo mdcEquipment);
|
|
/**
|
* 查询单表数据
|
* @param tableName
|
* @return
|
*/
|
@InterceptorIgnore(tenantLine = "1")
|
MdcEquipmentDto findWorkLineLast(@Param("tableName") String tableName);
|
|
}
|
