From 8490eb11583ffdc586436f165860de5cfc39f915 Mon Sep 17 00:00:00 2001
From: cjl <909710561@qq.com>
Date: Mon, 06 Jan 2025 09:18:29 +0800
Subject: [PATCH] fix：sql查询时间调整
---
screen-manage/src/main/java/com/moral/api/service/impl/ManageCoordinateServiceImpl.java | 38 ++++++++++++++++++++++++++++++++++++--
1 files changed, 36 insertions(+), 2 deletions(-)
diff --git a/screen-manage/src/main/java/com/moral/api/service/impl/ManageCoordinateServiceImpl.java b/screen-manage/src/main/java/com/moral/api/service/impl/ManageCoordinateServiceImpl.java
index 7139fb6..7baa71b 100644
--- a/screen-manage/src/main/java/com/moral/api/service/impl/ManageCoordinateServiceImpl.java
+++ b/screen-manage/src/main/java/com/moral/api/service/impl/ManageCoordinateServiceImpl.java
@@ -1,13 +1,18 @@
package com.moral.api.service.impl;
+import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.util.ObjectUtils;
import java.util.Date;
+import java.util.HashMap;
import java.util.List;
import java.util.Map;
+import com.alibaba.fastjson.JSON;
+import com.alibaba.fastjson.JSONArray;
+import com.alibaba.fastjson.JSONObject;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
@@ -18,6 +23,7 @@
import com.moral.api.mapper.ManageCoordinateDetailMapper;
import com.moral.api.mapper.ManageCoordinateMapper;
import com.moral.api.mapper.SpecialDeviceMapper;
+import com.moral.api.pojo.form.coordinate.CoordinateCode;
import com.moral.api.service.DeviceService;
import com.moral.api.service.ManageCoordinateDetailService;
import com.moral.api.service.ManageCoordinateService;
@@ -65,11 +71,17 @@
/**
* ������������
- * @param manageCoordinate
+ * @param coordinateCode
*/
@Override
- public void updateCoordinate(ManageCoordinate manageCoordinate) {
+ public void updateCoordinate(CoordinateCode coordinateCode) {
+ ManageCoordinate manageCoordinate = new ManageCoordinate();
+ BeanUtils.copyProperties(coordinateCode,manageCoordinate);
manageCoordinate.setUpdateTime(new Date());
+ List<HashMap<String, Object>> value = coordinateCode.getValue();
+ String s = JSON.toJSONString(value);
+ manageCoordinate.setValue(s);
+ manageCoordinate.setBdValue(JSON.toJSONString(coordinateCode.getBdValue()));
manageCoordinateMapper.updateById(manageCoordinate);
}
@@ -107,6 +119,28 @@
queryWrapper.eq("is_del",0);
queryWrapper.orderByDesc("coordinate_id");
List<ManageCoordinate> manageCoordinates = manageCoordinateMapper.selectList(queryWrapper);
+ manageCoordinates.forEach(it->{
+ String value = it.getValue();
+ String bdValue = it.getBdValue();
+ if (!ObjectUtils.isEmpty(value) && !ObjectUtils.isEmpty(bdValue)){
+// List<HashMap<String, Object>> hashMaps = (List<HashMap<String, Object>>)JSON.parseObject(value,List.class);
+ List<HashMap<String, Object>> parse = (List<HashMap<String, Object>>) JSONArray.parse(value);
+ it.setValues(parse);
+ it.setBdValues((List<HashMap<String, Object>>) JSONArray.parse(bdValue));
+ }
+ });
return manageCoordinates;
}
+
+ /**
+ * ������id������������������
+ *
+ * @param id
+ * @return
+ */
+ @Override
+ public ManageCoordinate query(Integer id) {
+ ManageCoordinate manageCoordinate = manageCoordinateMapper.selectById(id);
+ return manageCoordinate;
+ }
}
--
Gitblit v1.8.0