fix：sql查询时间调整

cjl

2025-01-06 8490eb11583ffdc586436f165860de5cfc39f915

 screen-manage/src/main/java/com/moral/api/controller/VersionController.java

@@ -1,24 +1,24 @@
package com.moral.api.controller;

import com.alibaba.fastjson.JSON;
import com.moral.api.entity.Version;
import com.moral.api.entity.VersionSensorUnit;
import com.moral.api.mapper.VersionMapper;
import com.moral.api.pojo.dto.version.VersionDTO;
import com.moral.api.pojo.dto.version.VersionQueryDTO;
import com.moral.api.pojo.form.version.VersionInsertForm;
import com.moral.api.pojo.form.version.VersionQueryForm;
import com.moral.api.pojo.form.version.VersionUpdateForm;
import com.moral.api.pojo.form.version.*;
import com.moral.api.pojo.vo.Version.VersionQueryVO;
import com.moral.api.pojo.vo.Version.VersionVO;
import com.moral.api.service.VersionService;
import com.moral.constant.ResponseCodeEnum;
import com.moral.constant.ResultMessage;
import com.moral.util.TokenUtils;
import io.swagger.annotations.Api;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import java.util.Arrays;
import java.util.List;
import java.util.*;

/**
 * @ClassName VersionController
@@ -76,4 +76,59 @@

        return new ResultMessage(dto.getCode(), dto.getMsg(), null);
    }

    @PostMapping("delete")
    public ResultMessage delete(@RequestBody VersionDeleteForm form){

        //判断是否缺少参数
        if (!form.valid())
            return ResultMessage.fail(ResponseCodeEnum.PARAMETERS_IS_MISSING.getCode(),
                    ResponseCodeEnum.PARAMETERS_IS_MISSING.getMsg());

        //处理删除业务
        VersionDTO dto = versionService.delete(form);

        return new ResultMessage(dto.getCode(), dto.getMsg(), null);
    }

    @PostMapping("updateSensorUnit")
    public ResultMessage updateSensorUnit(@RequestBody VersionSensorUnitForm form){

        //判断是否缺少参数
        if (!form.valid())
            return ResultMessage.fail(ResponseCodeEnum.PARAMETERS_IS_MISSING.getCode(),
                    ResponseCodeEnum.PARAMETERS_IS_MISSING.getMsg());

        //处理更新业务
        VersionDTO dto = versionService.updateSensorUnits(form);

        return new ResultMessage(dto.getCode(), dto.getMsg(), null);
    }



    @GetMapping("queryById")
    public ResultMessage queryById(VersionQueryByIdForm form){
        //判断是否缺少参数
        if (!form.valid())
            return ResultMessage.fail(ResponseCodeEnum.PARAMETERS_IS_MISSING.getCode(),
                    ResponseCodeEnum.PARAMETERS_IS_MISSING.getMsg());

        VersionQueryDTO dto = versionService.queryVersionById(form);

        VersionQueryVO vo = VersionQueryVO.convert(dto);

        return new ResultMessage(dto.getCode(), dto.getMsg(), vo);
    }

    @GetMapping("queryByOrgId")
    public ResultMessage queryByOrganizationId(Integer organizationId){

        VersionQueryDTO dto = versionService.queryByOrganizationId(organizationId);

        VersionQueryVO vo = VersionQueryVO.convert(dto);

        return new ResultMessage(dto.getCode(), dto.getMsg(), vo);
    }

}