From 6500da411f234b8ad0ee493909d515bf9eeecdd5 Mon Sep 17 00:00:00 2001
From: doum <doum>
Date: 星期四, 16 十月 2025 19:28:27 +0800
Subject: [PATCH] 最新版本541200007

---
 server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/JkSketchCustomerServiceImpl.java |  103 +++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 103 insertions(+), 0 deletions(-)

diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/JkSketchCustomerServiceImpl.java b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/JkSketchCustomerServiceImpl.java
index 467a4b4..338bd2e 100644
--- a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/JkSketchCustomerServiceImpl.java
+++ b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/JkSketchCustomerServiceImpl.java
@@ -1,6 +1,9 @@
 package com.doumee.service.business.impl;
 
+import com.alibaba.fastjson.JSONObject;
+import com.doumee.biz.system.SystemDictDataBiz;
 import com.doumee.core.utils.Constants;
+import com.doumee.dao.business.JkCustomerNavigationMapper;
 import com.doumee.dao.business.model.*;
 import com.doumee.service.business.third.model.PageData;
 import com.doumee.service.business.third.model.PageWrap;
@@ -17,7 +20,9 @@
 import org.springframework.stereotype.Service;
 import org.springframework.util.CollectionUtils;
 
+import java.math.BigDecimal;
 import java.math.RoundingMode;
+import java.util.ArrayList;
 import java.util.List;
 
 /**
@@ -29,7 +34,11 @@
 public class JkSketchCustomerServiceImpl implements JkSketchCustomerService {
 
     @Autowired
+    private SystemDictDataBiz systemDictDataBiz;
+    @Autowired
     private JkSketchCustomerMapper jkSketchCustomerMapper;
+    @Autowired
+    private JkCustomerNavigationMapper jkCustomerNavigationMapper;
 
     @Override
     public Integer create(JkSketchCustomer jkSketchCustomer) {
@@ -82,6 +91,100 @@
         return jkSketchCustomerMapper.selectOne(wrapper);
     }
 
+    /**
+     * 鏌ヨ鍏ㄩ儴浜ら�氳鍒掕矾绾�
+     * @param jkSketchCustomer
+     * @return
+     */
+    @Override
+    public List<JkCustomerNavigation>  allMapList(JkSketchCustomer jkSketchCustomer) {
+        List<JkCustomerNavigation> list = new ArrayList<>();
+        MPJLambdaWrapper<JkSketchCustomer> queryWrapper = new MPJLambdaWrapper<>();
+        jkSketchCustomer.setIsdeleted(Constants.ZERO);
+        queryWrapper.selectAll(JkSketchCustomer.class )
+                .selectAs(JkCustomer::getName,JkSketchCustomer::getName)
+                .selectAs(JkCustomer::getCode,JkSketchCustomer::getCode)
+                .selectAs(JkCustomer::getStartDistance,JkSketchCustomer::getStartDistance)
+                .selectAs(JkCustomer::getEndDistance,JkSketchCustomer::getEndDistance)
+                .selectAs(JkCustomer::getLatitude,JkSketchCustomer::getLatitude)
+                .selectAs(JkCustomer::getLongitude,JkSketchCustomer::getLongitude)
+                .selectAs(JkCustomer::getStartSteps,JkSketchCustomer::getStartSteps)
+                .selectAs(JkCustomer::getEndSteps,JkSketchCustomer::getEndSteps)
+                .selectAs(JkCustomer::getLocation,JkSketchCustomer::getLocation)
+                .leftJoin(JkCustomer.class,JkCustomer::getId,JkSketchCustomer::getCustomerId ) ;
+        queryWrapper.eq( JkSketchCustomer::getSketchLineId,jkSketchCustomer.getSketchLineId())
+                    .eq( JkSketchCustomer::getIsdeleted,Constants.ZERO);
+
+        BigDecimal cLatitude =new BigDecimal(0);
+        BigDecimal cLongitude =new BigDecimal(0);
+
+        String comLocation = systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.COMPANY_LOCATION).getCode();
+        try {
+            String[] ss = comLocation.split(",");
+            cLongitude = new BigDecimal(ss[0]);
+            cLatitude =  new BigDecimal(ss[1]);
+        }catch (Exception e){
+        }
+        List<JkSketchCustomer> allList =  jkSketchCustomerMapper.selectJoinList(JkSketchCustomer.class,queryWrapper);
+        if(allList !=null && allList.size()>0){
+            JkCustomerNavigation startmodel = new JkCustomerNavigation();
+            startmodel.setStartId(-1);
+            startmodel.setName("鍥尯");
+            startmodel.setStartLatitude(cLatitude);
+            startmodel.setStartLogitude(cLongitude);
+            startmodel.setEndLatitude(allList.get(0).getLatitude());
+            startmodel.setEndLogitude(allList.get(0).getLongitude());
+            startmodel.setDistance(allList.get(0).getStartDistance());
+            startmodel.setSteps(allList.get(0).getStartSteps());
+            if(StringUtils.isBlank(startmodel.getSteps())){
+                startmodel.setSteps(comLocation +";"+allList.get(0).getLongitude()+","+allList.get(0).getLatitude());
+            }
+            list.add(startmodel);
+
+            for (int i = 0; i < allList.size(); i++) {
+                if(allList.size() == i+1){
+                    JkCustomerNavigation endmodel = new JkCustomerNavigation();
+                    endmodel.setStartId(-1);
+                    endmodel.setLocation(allList.get(i).getLocation());
+                    endmodel.setName(allList.get(i).getName());
+                    endmodel.setSteps(allList.get(i).getEndSteps());
+                    endmodel.setStartLatitude(allList.get(i).getLatitude());
+                    endmodel.setStartLogitude(allList.get(i).getLongitude());
+                    endmodel.setDistance(allList.get(0).getEndDistance());
+                    endmodel.setEndLatitude(cLatitude);
+                    endmodel.setEndLogitude(cLongitude);
+                    if(StringUtils.isBlank(startmodel.getSteps())){
+                        startmodel.setSteps(allList.get(i).getLongitude()+","+allList.get(i).getLatitude()+";"+comLocation);
+                    }
+                    list.add(endmodel);
+                    break;
+                }
+                JkSketchCustomer start = allList.get(i);
+                JkSketchCustomer end = allList.get(i+1);
+                JkCustomerNavigation tt = jkCustomerNavigationMapper.selectOne(new QueryWrapper<JkCustomerNavigation>().lambda()
+                        .eq(JkCustomerNavigation::getIsdeleted,Constants.ZERO)
+                        .eq(JkCustomerNavigation::getIdIndex, allList.get(i).getCustomerId()+"-"+ allList.get(i+1).getCustomerId())
+                        .orderByDesc(JkCustomerNavigation::getId)
+                        .last("limit 1")
+                );
+                if(tt==null){
+                    //鍙湁璧锋鐐�
+                    tt = new JkCustomerNavigation();
+                    tt.setStartLatitude(start.getLatitude());
+                    tt.setStartLogitude(start.getLongitude());
+                    tt.setEndLatitude(end.getLatitude());
+                    tt.setEndLogitude(end.getLongitude());
+                }
+                tt.setLocation(allList.get(i).getLocation());
+                tt.setName(allList.get(i).getName());
+                if(StringUtils.isBlank(tt.getSteps())){
+                    tt.setSteps(start.getLongitude()+","+end.getLatitude()+";"+end.getLongitude()+","+end.getLatitude());
+                }
+                list.add(tt);
+            }
+        }
+        return list;
+    }
     @Override
     public List<JkSketchCustomer> findList(JkSketchCustomer jkSketchCustomer) {
         MPJLambdaWrapper<JkSketchCustomer> queryWrapper = new MPJLambdaWrapper<>();

--
Gitblit v1.9.3