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);
|
}
|
