From a97c42ad398252b9b69cabc3494a45a79064eec8 Mon Sep 17 00:00:00 2001
From: jinpengyong <jpy123456>
Date: Thu, 24 Aug 2023 16:26:15 +0800
Subject: [PATCH] chore:测试提交

---
 screen-manage/src/main/java/com/moral/api/service/impl/ManageCoordinateDetailServiceImpl.java |   89 ++++++++++++++++++++---------
 screen-manage/src/main/java/com/moral/api/service/ManageCoordinateService.java                |    2 
 screen-manage/src/main/java/com/moral/api/service/ManageCoordinateDetailService.java          |    1 
 screen-manage/src/main/java/com/moral/api/controller/ManageCoordinateDetailController.java    |   26 +++-----
 screen-api/src/main/java/com/moral/api/service/impl/ExcelServiceImpl.java                     |    8 ++
 screen-manage/src/main/java/com/moral/api/controller/ManageCoordinateController.java          |    5 +
 screen-manage/src/main/java/com/moral/api/service/impl/ManageCoordinateServiceImpl.java       |   17 +++++
 7 files changed, 96 insertions(+), 52 deletions(-)

diff --git a/screen-api/src/main/java/com/moral/api/service/impl/ExcelServiceImpl.java b/screen-api/src/main/java/com/moral/api/service/impl/ExcelServiceImpl.java
index 1eb53a5..6d6bce9 100644
--- a/screen-api/src/main/java/com/moral/api/service/impl/ExcelServiceImpl.java
+++ b/screen-api/src/main/java/com/moral/api/service/impl/ExcelServiceImpl.java
@@ -561,7 +561,13 @@
         for (Map<String, Object> map : list) {
             HistoryDaily historyDaily = new HistoryDaily();
             String time = map.remove("time").toString();
-            Date date = DateUtils.dateStringToDate(time);
+            Date date=null;
+            if (time.length()>20){
+                date = DateUtils.dateStringToDate(time);
+            }else {
+                date = DateUtils.getDate(time, DateUtils.yyyy_MM_dd_HH_mm_ss_EN);
+            }
+
             String mac = map.remove("mac").toString();
             String value = JSONObject.toJSONString(map);
             historyDaily.setMac(mac);
diff --git a/screen-manage/src/main/java/com/moral/api/controller/ManageCoordinateController.java b/screen-manage/src/main/java/com/moral/api/controller/ManageCoordinateController.java
index a343950..8182b65 100644
--- a/screen-manage/src/main/java/com/moral/api/controller/ManageCoordinateController.java
+++ b/screen-manage/src/main/java/com/moral/api/controller/ManageCoordinateController.java
@@ -77,7 +77,10 @@
             return ResultMessage.fail(ResponseCodeEnum.PARAMETERS_IS_MISSING.getCode(),
                     ResponseCodeEnum.PARAMETERS_IS_MISSING.getMsg());
         }
-        manageCoordinateService.deleteCoordinate(id);
+        Integer integer = manageCoordinateService.deleteCoordinate(id);
+        if (integer==1){
+          return  ResultMessage.ok("������������");
+        }
         return ResultMessage.ok();
     }
 
diff --git a/screen-manage/src/main/java/com/moral/api/controller/ManageCoordinateDetailController.java b/screen-manage/src/main/java/com/moral/api/controller/ManageCoordinateDetailController.java
index 4d33cd0..972f489 100644
--- a/screen-manage/src/main/java/com/moral/api/controller/ManageCoordinateDetailController.java
+++ b/screen-manage/src/main/java/com/moral/api/controller/ManageCoordinateDetailController.java
@@ -43,8 +43,11 @@
             return ResultMessage.fail(ResponseCodeEnum.PARAMETERS_IS_MISSING.getCode(), ResponseCodeEnum.PARAMETERS_IS_MISSING.getMsg());
         }
         Integer integer = manageCoordinateDetailService.insertCoordinate(params);
-        if (integer==null){
+        if (integer==1){
             return ResultMessage.ok("������������������");
+        }
+        if (integer==2){
+            return ResultMessage.ok("������������������");
         }
         return ResultMessage.ok();
     }
@@ -64,8 +67,11 @@
         if (!params.containsKey("coordinateId") || !params.containsKey("time1")|| !params.containsKey("time2")) {
             return ResultMessage.fail(ResponseCodeEnum.PARAMETERS_IS_MISSING.getCode(), ResponseCodeEnum.PARAMETERS_IS_MISSING.getMsg());
         }
-
-        return null;
+        Integer integer = manageCoordinateDetailService.batchAll(params);
+        if (integer!=200){
+            return ResultMessage.ok("������������");
+        }
+         return ResultMessage.ok();
     }
 
     /**
@@ -78,20 +84,6 @@
         return null;
     }
 
-
-    /**
-     * ������������������
-     * @param id
-     * @return
-     */
-    @GetMapping("delete")
-    public ResultMessage delete(Integer id){
-        if (id==null){
-            return ResultMessage.fail(ResponseCodeEnum.PARAMETERS_IS_MISSING.getCode(), ResponseCodeEnum.PARAMETERS_IS_MISSING.getMsg());
-        }
-        manageCoordinateDetailService.deleteCoordinate(id);
-        return ResultMessage.ok();
-    }
 
 
     /**
diff --git a/screen-manage/src/main/java/com/moral/api/service/ManageCoordinateDetailService.java b/screen-manage/src/main/java/com/moral/api/service/ManageCoordinateDetailService.java
index 7501c77..a07dcfd 100644
--- a/screen-manage/src/main/java/com/moral/api/service/ManageCoordinateDetailService.java
+++ b/screen-manage/src/main/java/com/moral/api/service/ManageCoordinateDetailService.java
@@ -12,7 +12,6 @@
     Integer insertCoordinate(Map<String,Object> params);
 
 
-    void  deleteCoordinate(Integer id);
 
 
 
diff --git a/screen-manage/src/main/java/com/moral/api/service/ManageCoordinateService.java b/screen-manage/src/main/java/com/moral/api/service/ManageCoordinateService.java
index 7ce8b5f..859817b 100644
--- a/screen-manage/src/main/java/com/moral/api/service/ManageCoordinateService.java
+++ b/screen-manage/src/main/java/com/moral/api/service/ManageCoordinateService.java
@@ -18,7 +18,7 @@
     void updateCoordinate(ManageCoordinate manageCoordinate);
 
 
-    void deleteCoordinate(Integer id);
+    Integer deleteCoordinate(Integer id);
 
 
     List<ManageCoordinate> selectCoordinate();
diff --git a/screen-manage/src/main/java/com/moral/api/service/impl/ManageCoordinateDetailServiceImpl.java b/screen-manage/src/main/java/com/moral/api/service/impl/ManageCoordinateDetailServiceImpl.java
index 121db66..8ce0e1f 100644
--- a/screen-manage/src/main/java/com/moral/api/service/impl/ManageCoordinateDetailServiceImpl.java
+++ b/screen-manage/src/main/java/com/moral/api/service/impl/ManageCoordinateDetailServiceImpl.java
@@ -38,6 +38,7 @@
 import com.moral.api.util.RoadUtils;
 import com.moral.constant.Constants;
 import com.moral.constant.RedisConstants;
+import com.moral.util.DateUtils;
 import com.moral.util.TokenUtils;
 import com.sun.org.apache.regexp.internal.RE;
 
@@ -77,7 +78,8 @@
             ManageCoordinateDetail manageCoordinateDetail = new ManageCoordinateDetail();
             String code = datum.get("code").toString();
             String state = datum.get("state").toString();
-            if (state.equals("1")){
+
+            if (state.equals("2")){
                 String[] rs = code.split("_");
                 manageCoordinateDetail.setCoordinateId(coordinateId);
                 manageCoordinateDetail.setLongitude(Double.parseDouble(rs[0]));
@@ -91,25 +93,19 @@
                 wrapper.eq("latitude",manageCoordinateDetail.getLatitude());
                 Integer integer = manageCoordinateDetailMapper.selectCount(wrapper);
                 if (integer>=1){
-                    return null;
+                    return 1;
                 }
                 manageCoordinateDetailMapper.insert(manageCoordinateDetail);
             }else {
-                manageCoordinateDetailMapper.deleteById(manageCoordinateDetail.getId());
+                Object id1 = datum.get("id");
+                if (ObjectUtils.isEmpty(id1)){
+                    return 2;
+                }
+                manageCoordinateDetailMapper.deleteById(Integer.parseInt(id1.toString()));
 //                    manageCoordinateDetailMapper.delete(wrapper);
-
             }
         }
         return 200;
-    }
-
-    /**
-     * ������������������
-     * @param id
-     */
-    @Override
-    public void deleteCoordinate(Integer id)  {
-        manageCoordinateDetailMapper.deleteById(id);
     }
 
 
@@ -178,8 +174,9 @@
                 String latitude = manageCoordinateDetail.getLatitude().toString();
                 String longitude = manageCoordinateDetail.getLongitude().toString();
                 if (latitude.equals(flyLat) && longitude.equals(flyLon)){
-                    manageCoordinateDetail.setLongitude(Double.parseDouble(flyLon));
-                    manageCoordinateDetail.setLatitude(Double.parseDouble(flyLat));
+                    manageCoordinateDetail.setCode(data);
+                    manageCoordinateDetail.setLongitude(cruiserDTO.getFlyLon());
+                    manageCoordinateDetail.setLatitude(cruiserDTO.getFlyLat());
                     rsList1.add(manageCoordinateDetail);
                     cruiserInfo.remove(i);
                     break;
@@ -205,28 +202,62 @@
         int coordinateId = Integer.parseInt(params.get("coordinateId").toString());
         QueryWrapper<ManageCoordinateDetail> queryWrapper = new QueryWrapper<>();
         queryWrapper.eq("coordinate_id",coordinateId);
+        String time1 = params.remove("time1").toString();
+        String time2 = params.remove("time2").toString();
+        long l = DateUtils.compareDateStr(time1, time2);
+        if (l>0){
+            params.put("time1",time1);
+            params.put("time2",time2);
+        }else {
+            params.put("time1",time2);
+            params.put("time2",time1);
+        }
+        int j =0;
         List<ManageCoordinateDetail> manageCoordinateDetails = manageCoordinateDetailMapper.selectList(queryWrapper);
         List<CruiserDTO> cruiserInfo = historySecondCruiserMapper.getCruiserInfo(params);
-        for (ManageCoordinateDetail manageCoordinateDetail : manageCoordinateDetails) {
-            String latitude = manageCoordinateDetail.getLatitude().toString();
-            String longitude = manageCoordinateDetail.getLongitude().toString();
+        if (ObjectUtils.isEmpty(manageCoordinateDetails)){
             for (CruiserDTO cruiserDTO : cruiserInfo) {
                 Double flyLat = cruiserDTO.getFlyLat();
                 Double flyLon = cruiserDTO.getFlyLon();
-                if (!latitude.equals(flyLat+"") || !longitude.equals(flyLon+"")){
-                    ManageCoordinateDetail rsDTO = new ManageCoordinateDetail();
-                    rsDTO.setLatitude(flyLat);
-                    rsDTO.setLongitude(flyLon);
-                    rsDTO.setState("2");
-                    rsDTO.setCreateTime(new Date());
-                    rsDTO.setUpdateTime(new Date());
-                    rsDTO.setCoordinateId(coordinateId);
-                    int insert = manageCoordinateDetailMapper.insert(rsDTO);
-                    if (insert!=1){
-                        return null;
+                ManageCoordinateDetail rsDTO = new ManageCoordinateDetail();
+                rsDTO.setLatitude(flyLat);
+                rsDTO.setLongitude(flyLon);
+                rsDTO.setState("2");
+                rsDTO.setCreateTime(new Date());
+                rsDTO.setUpdateTime(new Date());
+                rsDTO.setCoordinateId(coordinateId);
+                manageCoordinateDetailMapper.insert(rsDTO);
+                j++;
+                log.info(j+"");
+            }
+        }else {
+            for (int i=cruiserInfo.size()-1;i>0;i--) {
+                CruiserDTO cruiserDTO = cruiserInfo.get(i);
+                Double flyLat = cruiserDTO.getFlyLat();
+                Double flyLon = cruiserDTO.getFlyLon();
+                for (ManageCoordinateDetail manageCoordinateDetail : manageCoordinateDetails) {
+                    String latitude = manageCoordinateDetail.getLatitude().toString();
+                    String longitude = manageCoordinateDetail.getLongitude().toString();
+                    if (latitude.equals(flyLat+"") && longitude.equals(flyLon+"")){
+                        cruiserInfo.remove(i);
+                        break;
                     }
                 }
             }
+            for (CruiserDTO cruiserDTO : cruiserInfo) {
+                Double flyLat = cruiserDTO.getFlyLat();
+                Double flyLon = cruiserDTO.getFlyLon();
+                ManageCoordinateDetail rsDTO = new ManageCoordinateDetail();
+                rsDTO.setLatitude(flyLat);
+                rsDTO.setLongitude(flyLon);
+                rsDTO.setState("2");
+                rsDTO.setCreateTime(new Date());
+                rsDTO.setUpdateTime(new Date());
+                rsDTO.setCoordinateId(coordinateId);
+                manageCoordinateDetailMapper.insert(rsDTO);
+                j++;
+                log.info(j+"");
+            }
         }
         return 200;
     }
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 98c4569..17c4ef3 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
@@ -11,7 +11,10 @@
 import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
 import com.moral.api.entity.ManageCoordinate;
+import com.moral.api.entity.ManageCoordinateDetail;
+import com.moral.api.mapper.ManageCoordinateDetailMapper;
 import com.moral.api.mapper.ManageCoordinateMapper;
+import com.moral.api.service.ManageCoordinateDetailService;
 import com.moral.api.service.ManageCoordinateService;
 
 
@@ -20,6 +23,9 @@
 
     @Autowired
     private ManageCoordinateMapper manageCoordinateMapper;
+
+    @Autowired
+    private ManageCoordinateDetailMapper manageCoordinateDetailMapper;
 
     /**
      * ������������
@@ -62,9 +68,16 @@
      * @param id
      */
     @Override
-    public void deleteCoordinate(Integer id) {
-
+    public Integer deleteCoordinate(Integer id) {
+        QueryWrapper<ManageCoordinateDetail> wrapper = new QueryWrapper<>();
+        wrapper.eq("coordinate_id",id);
+        Integer integer = manageCoordinateDetailMapper.selectCount(wrapper);
+        if (integer>0){
+            return 1;
+        }
         manageCoordinateMapper.deleteById(id);
+        return 200;
+
     }
 
     /**

--
Gitblit v1.8.0