fix：sql查询时间调整

cjl

2025-01-06 8490eb11583ffdc586436f165860de5cfc39f915

 screen-manage/src/main/java/com/moral/api/service/DeviceService.java

@@ -3,12 +3,8 @@
import java.util.List;
import java.util.Map;

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.moral.api.entity.Device;
import com.baomidou.mybatisplus.extension.service.IService;
import com.moral.api.entity.ManageAccount;
import com.moral.api.entity.Organization;
import com.moral.api.pojo.vo.device.DeviceVO;

/**
 * <p>
@@ -20,11 +16,63 @@
 */
public interface DeviceService extends IService<Device> {

    //设备添加
    void insert(Device device);

    List<ManageAccount> selectAllOperator();
    //删除设备
    void delete(Integer deviceId);

    List<Organization> selectAllOrganization();
    //修改设备
    void update(Device device);

    Page<DeviceVO> selectDevices(Map<String, Object> parameters);
    //所有维护人
    List<Map<String, Object>> selectAllOperators();

    //设备相关字典数据
    List<Map<String, Object>> selectDeviceDictData(String dictType);

    //查询所有组织
    List<Map<String, Object>> selectAllOrganization();

    //查询所有站点
    List<Map<String, Object>> selectAllMonitorPoint();

    //根据组织查询站点
    List<Map<String, Object>> selectMonitorsByOrgId(Integer orgId);

    //根据组织查询设备
    Map<String, Object> selectDevicesByOrgId(Map<String, Object> parameters);

    //根据站点查询设备
    Map<String, Object> selectDevicesByMpId(Map<String, Object> parameters);

    //分页获取所有设备列表
    Map<String, Object> selectDevices(Map<String, Object> parameters);

    //根据设备id查询设备组织，站点，维护人，行业，工艺，设备检测器，采购商等信息
    Map<String, Object> selectDeviceInfoById(Integer deviceId);

    //根据mac获取设备信息
    Map<String, Object> getDeviceByMac(String mac);

    //设备数据校准
    Map<String, Object> adjustDeviceData(Map<String, Object> deviceData,String code);

    //特殊设备数据校准
    Map<String, Object> adjustSpecialDeviceData(Map<String, Object> deviceData);

    //判断并修改设备状态
    void judgeDeviceState(Map<String, Object> data);

    /**
      *@Description: 通过组织id获取站点和设备
      *@Param: [orgId]
      *@return: java.util.List<java.util.Map<java.lang.String,java.lang.Object>> 
      *@Author: lizijie
      *@Date: 2022/1/17 10:30
     **/
    List<Map<String,Object>> selectMonitorPiontAndDeviceByOrgId(int orgId);

    void setRedisDevice();

}