Merge branch 'mdc_hyjs_master'

zhangherong

2025-06-25 23855599412c4d61b38d78f0f3abd3430a48b5b1

 lxzn-module-mdc-common/src/main/java/org/jeecg/modules/mdc/mapper/MdcEquipmentMapper.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,147 @@
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.MdcEquipmentDetailedDto;
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);

    /**
     * æ ¹æ®äº§çº¿id、type、已分配权限数据 æŸ¥è¯¢è®¾å¤‡
     */
    List<MdcEquipment> queryByProductionIdAndType(@Param("productionId") String productionId, @Param("deviceIds") List<String> deviceIds);

    /**
     * æ ¹æ®éƒ¨é—¨ids、已分配权限数据 æŸ¥è¯¢è®¾å¤‡
     */
    List<MdcEquipment> queryByDepartIdsAndType(@Param("productionIds") List<String> productionIds, @Param("deviceIds") List<String> deviceIds);

    /**
     * æŸ¥æ‰¾è®¾å¤‡ç›‘控信息
     */
    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);

    /**
     * æ ¹æ®id获取设备信息
     * @param id
     * @return
     */
    MdcEquipmentDetailedDto findById(@Param("id") String id);

    List<MdcEquipment> findByProductionIds(@Param("mdcProductionIds") List<String> mdcProductionIds);

    List<MdcEquipment> findByProIdsAndTeamCode(@Param("mdcProductionIds") List<String> mdcProductionIds, @Param("teamCodeList") List<String> teamCodeList);

    List<MdcEquipment> findByProIdsAndType(@Param("mdcProductionIds") List<String> mdcProductionIds, @Param("typeList") List<String> typeList);

    List<String> getEquIdsByProIds(@Param("proIds") List<String> proIds);

    List<MdcEquipment> getEquipmentList(@Param("allProductionIds") List<String> allProductionIds);
}