package org.jeecg.modules.iot.mapper;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import io.lettuce.core.dynamic.annotation.Param;
import org.apache.ibatis.annotations.Select;
import org.jeecg.modules.iot.entity.EmptyParameter;

import java.util.Date;
import java.util.List;

/**
 * @Description: 虚设备参数
 * @Author: cuikaidong
 * @Date: 2025-1-7
 * @Version: V1.0
 */
public interface EmptyParameterMapper extends BaseMapper<EmptyParameter> {

    List<EmptyParameter> findEmptyParameterList(@Param("list") List<String> list);

    /**
     *   根据时间，终端查询
     */
    @Select("SELECT p.*,e.eqpt_code FROM iot_empty_parameter p LEFT JOIN iot_equipment e ON e.id = p.equipment_id WHERE p.create_time > #{deployDate} AND e.server_id = #{serverId};")
//    @Select("SELECT p.*,e.eqpt_code FROM `iot_empty_parameter` p LEFT JOIN iot_equipment e ON e.id = p.equipment_id WHERE p.create_time > #{deployDate} AND e.server_id = #{serverId};")
    public List<EmptyParameter> findEmptyParameterListByTime(Date deployDate, String serverId);
}