From d8b9d884967f502caac58d723e57931d0356fa11 Mon Sep 17 00:00:00 2001
From: doum <doum>
Date: 星期一, 24 十一月 2025 19:53:05 +0800
Subject: [PATCH] 最新版本541200007

---
 server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/JkSketchServiceImpl.java |  404 ++++++++++++++++++++++++++++++++++++++++++++++++++------
 1 files changed, 356 insertions(+), 48 deletions(-)

diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/JkSketchServiceImpl.java b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/JkSketchServiceImpl.java
index 2c34d74..80f8c95 100644
--- a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/JkSketchServiceImpl.java
+++ b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/JkSketchServiceImpl.java
@@ -12,6 +12,7 @@
 import com.doumee.core.wms.model.response.WmsBaseDataResponse;
 import com.doumee.core.wms.model.response.WmsBaseResponse;
 import com.doumee.dao.admin.request.JkOrdersImport;
+import com.doumee.dao.admin.request.SketchCateModel;
 import com.doumee.dao.business.*;
 import com.doumee.dao.business.dto.TelecomLineInfoDTO;
 import com.doumee.dao.business.model.*;
@@ -129,8 +130,7 @@
         if(Constants.equalsInteger(Constants.ZERO,jkSketch.getForceUpdate()) && Constants.equalsInteger(model.getStatus(),Constants.ONE)){
             throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"璇ョ嚎璺瓨鍦ㄦ鍦ㄤ紭鍖栦腑锛岃鑰愬績绛夊緟浼樺寲瀹屾垚鎴栬�呴�夋嫨寮哄埗浼樺寲鎿嶄綔锛�");
         }
-
-        if(  jkSketch.getLineIdList() ==null || jkSketch.getLineIdList().size()==0 ){
+        if( jkSketch.getLineIdList() ==null || jkSketch.getLineIdList().size()==0 ){
             throw  new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"璇烽�夋嫨鏈夋晥鍚堢悊鐨勭嚎璺繘琛屼紭鍖栨搷浣滐紒");
         }
         //褰撳墠鎵�鏈夌嚎璺�(绗﹀悎鏉′欢鐨勭嚎璺級
@@ -256,7 +256,8 @@
     @Async
     public  void distanceCustomer( Category cate) {
         try {
-            List<JkCustomer> customerList = cate.getCustomerList();
+            List<JkCustomer> allList = cate.getCustomerList();
+            List<JkCustomer> customerList = cate.getNeedList();
             String url = systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.GAODE_DISTANCE_GEOAPI_URL).getCode();
             Date date = new Date();
             BigDecimal cLatitude =new BigDecimal(0);
@@ -288,7 +289,7 @@
                         for (int j = start; j < end; j++) {
                             try {
                                 log.error("浜ら�氳鍒�========"+cate.getId()+"/"+cate.getName()+"/"+customerList.get(j).getName()+"=======cirle/index:"+finalI+"/"+index++);
-                                dealDistancePerCustomer(customerList.get(j),url,date, finalCLatitude, finalCLongitude,customerList);
+                                dealDistancePerCustomer(customerList.get(j),url,date, finalCLatitude, finalCLongitude,allList);
                             }catch (Exception e){
 
                             }
@@ -429,8 +430,10 @@
             }
         }
         if(navigationList.size()>0){
-            jkCustomerNavigationMapper.delete(new UpdateWrapper<JkCustomerNavigation>().lambda()
-                    .eq(JkCustomerNavigation::getStartId,c.getId()));//鍒犻櫎鍘嗗彶鏁版嵁
+            for (JkCustomerNavigation navigation:navigationList) {
+                jkCustomerNavigationMapper.delete(new UpdateWrapper<JkCustomerNavigation>().lambda()
+                        .eq(JkCustomerNavigation::getIdIndex,navigation.getIdIndex()));//鍒犻櫎鍘嗗彶鏁版嵁
+            }
             jkCustomerNavigationMapper.insert(navigationList);//鎻掑叆鏈�鏂版暟鎹�
         }
     }
@@ -493,7 +496,8 @@
         }
         c.setStatus(Constants.TWO);
         categoryMapper.updateById(c);//鏇存柊浠诲姟鎵ц鐘舵��
-        c.setCustomerList(Constants.equalsInteger(model.getForceUpdate(),0)?needList:customerList);
+        c.setCustomerList(customerList);
+        c.setNeedList(Constants.equalsInteger(model.getForceUpdate(),0)?needList:customerList);
         return  c;
     }
 
@@ -505,6 +509,69 @@
     @Async
     public void startUpdateLineAsync(JkSketch model) {
         try {
+            int maxnum =100;
+            try {
+                maxnum = Integer.parseInt(systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.JK_PLAN_MAX_CLUSTER).getCode());
+            }catch (Exception e){
+
+            }
+            List<JkSketchCustomer> allCustomerList = model.getCustomerList();
+            //涓ゅ叕閲屽唴鏁版嵁瀹㈡埛鍚堝苟
+//            List<SketchCateModel> customerList =Clustering.clusterPoints(allCustomerList,1000);
+            List<SketchCateModel> customerList = new ClusterCustomKMeans().clusterPoints(allCustomerList,maxnum,500);
+            List<JkLine> lineList = model.getLineList();
+            TspSolver.DataModel dataModel = new TspSolver.DataModel();
+            int vehicleNumber1 = lineList.size();//绾胯矾鏁伴噺
+            long[] vehicleCapacities1=new long[lineList.size()];//姣忚締杞︾殑鏈�澶ц鍗曢噺闄愬埗
+            long[] vehicleMaxNodes=new long[lineList.size()];//姣忚締杞︾殑鏈�澶ц鍗曢噺闄愬埗
+            long[] demands1 = new long[customerList.size()+1]; //鍚勪釜鐐圭殑璁㈠崟閲�
+            long[] demands2 = new long[customerList.size()+1]; //鍚勪釜鐐圭殑瀹㈡埗閲�
+            long[][] distanceMatrix1 = new long[customerList.size()+1][customerList.size()+1];
+            distanceMatrix1[0][0] = 0;
+            demands1[0] =0;//鍘熺偣
+            demands2[0] =0;//鍘熺偣
+            for (int i = 0; i < customerList.size(); i++) {
+                List<DistanceMapParam>  disList =  customerList.get(i).getStartPoint().getDistanceMapParamList();
+                distanceMatrix1[0][i+1] =  disList.get(0).getDistance();
+                distanceMatrix1[i+1][0] = disList.get(disList.size() -1).getDistance();
+                demands1[i+1] = Constants.formatBigdecimal( customerList.get(i).getTotalNum()).longValue();  //鍚勪釜鐐圭殑璁㈠崟閲�
+                demands2[i+1] = customerList.get(i).getTotalCustomer();  //鍚勪釜鐐圭殑璁㈠崟閲�
+                for (int j = 0; j < customerList.size(); j++) {
+                    distanceMatrix1[i+1][j+1] =disList.get(j+1).getDistance() ;
+                }
+            }
+            for (int i = 0; i < lineList.size(); i++) {
+                vehicleCapacities1[i] = lineList.get(i).getMaxOrder();//姣忚締杞︾殑鏈�澶ц鍗曢噺闄愬埗
+                vehicleMaxNodes[i] =lineList.get(i).getMaxCustomer();//鏈�澶у鎴锋暟
+            }
+            //鏋勯�犱紭鍖栨暟鎹ā鍨�
+            dataModel.initDataInfo(vehicleNumber1,demands1,demands2,vehicleCapacities1,distanceMatrix1,vehicleMaxNodes);
+            TspSolver.startSearch(dataModel);
+            dealSearchSolution(model,  customerList,dataModel);
+        }catch (Exception e){
+            e.printStackTrace();
+            jkSketchMapper.update(null,new UpdateWrapper<JkSketch>().lambda()
+                    .eq(JkSketch::getId,model.getId() )
+                    .eq(JkSketch::getJobId,model.getJobId() )
+                    .set(JkSketch::getPlanLineInfo,"鏈�杩戜竴娆$嚎璺紭鍖栧け璐ワ紒")
+                    .set(JkSketch::getStatus,Constants.THREE)
+                    .set(JkSketch::getPlanLineEndDate,new Date()));
+        }
+    }
+
+    private List<JkSketchCustomer> getCustomerCateList(List<JkSketchCustomer> allCustomerList) {
+        List<JkSketchCustomer>  list = new ArrayList<>();
+        return  list;
+    }
+
+    /**
+     * 寮�濮嬪紓姝ユ墽琛岀嚎璺紭鍖栦换鍔�
+     * @param model
+     */
+    @Override
+    @Async
+    public void startUpdateLineAsyncOld(JkSketch model) {
+        try {
             List<JkSketchCustomer> customerList = model.getCustomerList();
             List<JkLine> lineList = model.getLineList();
             TspSolver.DataModel dataModel = new TspSolver.DataModel();
@@ -512,6 +579,7 @@
             long[] vehicleCapacities1=new long[lineList.size()];//姣忚締杞︾殑鏈�澶ц鍗曢噺闄愬埗
             long[] vehicleMaxNodes=new long[lineList.size()];//姣忚締杞︾殑鏈�澶ц鍗曢噺闄愬埗
             long[] demands1 = new long[customerList.size()+1]; //鍚勪釜鐐圭殑璁㈠崟閲�
+            long[] demands2 = new long[customerList.size()+1]; //鍚勪釜鐐圭殑瀹㈡埛閲�
             long[][] distanceMatrix1 = new long[customerList.size()+1][customerList.size()+1];
             distanceMatrix1[0][0] = 0;
             demands1[0] =0;//鍘熺偣
@@ -520,6 +588,7 @@
                 distanceMatrix1[0][i+1] =  disList.get(0).getDistance();
                 distanceMatrix1[i+1][0] = disList.get(disList.size() -1).getDistance();
                 demands1[i+1] = Constants.formatBigdecimal( customerList.get(i).getTotalNum()).longValue();  //鍚勪釜鐐圭殑璁㈠崟閲�
+                demands2[i+1] =1;  //鍚勪釜鐐圭殑璁㈠崟閲�
                 for (int j = 0; j < customerList.size(); j++) {
                     distanceMatrix1[i+1][j+1] =disList.get(j+1).getDistance() ;
                 }
@@ -539,9 +608,9 @@
                 vehicleMaxNodes[i] =lineList.get(i).getMaxCustomer();//鏈�澶у鎴锋暟
             }
             //鏋勯�犱紭鍖栨暟鎹ā鍨�
-            dataModel.initDataInfo(vehicleNumber1,demands1,vehicleCapacities1,distanceMatrix1,vehicleMaxNodes);
+            dataModel.initDataInfo(vehicleNumber1,demands1,demands2,vehicleCapacities1,distanceMatrix1,vehicleMaxNodes);
             TspSolver.startSearch(dataModel);
-            dealSearchSolution(model,dataModel);
+            dealSearchSolutionOld(model,dataModel);
         }catch (Exception e){
             e.printStackTrace();
             jkSketchMapper.update(null,new UpdateWrapper<JkSketch>().lambda()
@@ -560,6 +629,126 @@
     @Override
     @Async
     public  void startEditSketchLineAsync(JkSketch model) {
+        boolean success = true;
+        int totalDistance = 0;
+        List<JkSketchLine> lineList = model.getSketchLineList();
+        try {
+            MPJLambdaWrapper<JkSketchCustomer> queryWrapper = new MPJLambdaWrapper<>();
+            queryWrapper.selectAll(JkSketchCustomer.class )
+                    .selectAs(JkCustomer::getName,JkSketchCustomer::getName)
+                    .selectAs(JkCustomer::getCode,JkSketchCustomer::getCode)
+                    .selectAs(JkCustomer::getDistance,JkSketchCustomer::getDistanceJson)
+                    .selectAs(JkCustomer::getLongitude,JkSketchCustomer::getLongitude)
+                    .selectAs(JkCustomer::getLatitude,JkSketchCustomer::getLatitude)
+                    .selectAs(JkCustomer::getStartDistance,JkSketchCustomer::getStartDistance)
+                    .selectAs(JkCustomer::getEndDistance,JkSketchCustomer::getEndDistance)
+                    .leftJoin(JkCustomer.class,JkCustomer::getId,JkSketchCustomer::getCustomerId )
+                    .eq(JkSketchCustomer::getType, Constants.equalsInteger(model.getOptStatus(),Constants.ONE)?1:0)
+                    .eq(JkSketchCustomer::getSketchId, model.getId())
+                    .eq(JkSketchCustomer::getIsdeleted,Constants.ZERO)
+                    .orderByAsc(JkSketchCustomer::getSortnum);
+            List<JkSketchCustomer> customerList = jkSketchCustomerMapper.selectJoinList(JkSketchCustomer.class,queryWrapper);
+            if(customerList == null ||customerList.size() ==0){
+                throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"璇ョ嚎璺鎴蜂俊鎭负绌猴紝涓嶆弧瓒充紭鍖栨潯浠讹紒");
+            }
+            int maxnum =100;
+            try {
+                maxnum = Integer.parseInt(systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.JK_PLAN_MAX_CLUSTER).getCode());
+            }catch (Exception e){
+
+            }
+            int totalNum = 0;
+            for(JkSketchLine line : lineList){
+                //瀹屽杽绾胯矾瀹㈡埛浼樺寲鍙傛暟
+                List<JkSketchCustomer> customerListParam =  line.getCustomerList() ;
+                if(customerListParam ==null || customerListParam.size()==0){
+                    throw  new BusinessException(ResponseStatus.BAD_REQUEST);
+                }
+                initSketchCustomerListParam(line.getCustomerList(),customerList) ;
+                totalNum += customerListParam.size();
+            }
+            if(totalNum != Constants.formatIntegerNum(model.getOrderNum())){
+                throw  new BusinessException(ResponseStatus.BAD_REQUEST);
+            }
+            for(JkSketchLine line : lineList){
+                //閫愪釜璺嚎浼樺寲
+                List<JkSketchCustomer> allCustomerListParam =  line.getCustomerList() ;
+//                List<SketchCateModel> customerListParam = Clustering.clusterPoints(allCustomerListParam,1000);
+                List<SketchCateModel> customerListParam = new ClusterCustomKMeans().clusterPoints(allCustomerListParam,maxnum,500);
+                TspSolver.DataModel dataModel = new TspSolver.DataModel();
+                int vehicleNumber1 = 1;//绾胯矾鏁伴噺
+                long[] vehicleCapacities1=new long[]{line.getMaxOrder()};//姣忚締杞︾殑鏈�澶ц鍗曢噺闄愬埗
+                long[] vehicleMaxNodes=new long[]{line.getMaxCustomer()};//姣忚締杞︾殑鏈�澶ц鍗曢噺闄愬埗
+                long[] demands1 = new long[customerListParam.size()+1]; //鍚勪釜鐐圭殑璁㈠崟閲�
+                long[] demands2 = new long[customerListParam.size()+1]; //鍚勪釜鐐圭殑璁㈠崟閲�
+                long[][] distanceMatrix1 = new long[customerListParam.size()+1][customerListParam.size()+1];
+                distanceMatrix1[0][0] = 0;
+                demands1[0] =0;//鍘熺偣
+                for (int i = 0; i < customerListParam.size(); i++) {
+                    List<DistanceMapParam>  disList =  customerListParam.get(i).getStartPoint().getDistanceMapParamList();
+                    distanceMatrix1[0][i+1] =  disList.get(0).getDistance();
+                    distanceMatrix1[i+1][0] = disList.get(disList.size() -1).getDistance();
+                    demands1[i+1] = Constants.formatBigdecimal( customerListParam.get(i).getTotalNum()).longValue();  //鍚勪釜鐐圭殑璁㈠崟閲�
+                    demands2[i+1] =   customerListParam.get(i).getTotalCustomer() ;  //鍚勪釜鐐圭殑璁㈠崟閲�
+                    for (int j = 0; j < customerListParam.size(); j++) {
+                        distanceMatrix1[i+1][j+1] =disList.get(j+1).getDistance() ;
+                    }
+                }
+                //鏋勯�犱紭鍖栨暟鎹ā鍨�
+                dataModel.initDataInfo(vehicleNumber1,demands1,demands2,vehicleCapacities1,distanceMatrix1,vehicleMaxNodes);
+                TspSolver.startSearch(dataModel);
+                if(dataModel.getSolutions()==null || dataModel.getSolutions().size()==0){
+                    throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"绾胯矾銆�"+line.getLineName()+"銆戣皟鏁村け璐� 锛屾湭鑾峰緱鏈�浼樹氦閫氳鍒掓柟妗堬紒");
+                }
+                TspSolverSolutions so = dataModel.getSolutions().get(0);
+                List<Integer> routes = so.getRouteIndex();
+                totalDistance += so.getDistance();
+                if(routes.size() <=2) {
+                    throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"绾胯矾銆�"+line.getLineName()+"銆戣皟鏁村け璐� 锛屾湭鑾峰緱鏈�浼樹氦閫氳鍒掓柟妗堬紒");
+                }
+                int index = 0;
+                line.setDistance(so.getDistance());
+                //鏈夋晥璺緞
+                for (Integer cIndex : routes){
+                    if(cIndex ==0){
+                        continue; //璧峰鐐逛笉澶勭悊
+                    }
+                    SketchCateModel cateModel = customerListParam.get(cIndex-1);
+                    for(int t=0;t<cateModel.getCustomerList().size();t++){
+                        JkSketchCustomer customer = cateModel.getCustomerList().get(t);
+                        customer.setSortnum(index++);
+                        if(t < cateModel.getCustomerList().size()-1){
+                            long tdistance = (long)Clustering.distanceTo(customer, cateModel.getCustomerList().get(t+1));
+                            line.setDistance(Constants.formatLongNum(line.getDistance()) +tdistance);
+                            totalDistance  += tdistance;
+                        }
+                    }
+                }
+            }
+        }catch (Exception e){
+            e.printStackTrace();
+            success =false;
+        }finally {
+            if(success){
+                List<JkSketchCustomer> allList = new ArrayList<>();
+                for(JkSketchLine line : lineList){
+                    allList.addAll(line.getCustomerList());
+                }
+                jkSketchLineMapper.updateById(lineList);
+                jkSketchCustomerMapper.updateById(allList);
+            }
+            jkSketchMapper.update(null,new UpdateWrapper<JkSketch>().lambda()
+//                    .eq(JkSketch::getId,model.getId() )
+                    .eq(JkSketch::getJobId,model.getJobId() )
+                    .set(success,JkSketch::getDistance,totalDistance)
+                    .set(JkSketch::getPlanLineInfo,success?"鏈�杩戜竴娆$嚎璺皟鏁存垚鍔�":"鏈�杩戜竴娆$嚎璺皟鏁村け璐ワ紒")
+                    .set(JkSketch::getStatus,success?Constants.TWO:Constants.THREE)
+                    .set(JkSketch::getPlanLineEndDate,new Date()));
+        }
+    }
+    @Override
+    @Async
+    public  void startEditSketchLineAsyncOld(JkSketch model) {
         boolean success = true;
         int totalDistance = 0;
         List<JkSketchLine> lineList = model.getSketchLineList();
@@ -604,6 +793,7 @@
                 long[] vehicleCapacities1=new long[]{line.getMaxOrder()};//姣忚締杞︾殑鏈�澶ц鍗曢噺闄愬埗
                 long[] vehicleMaxNodes=new long[]{line.getMaxCustomer()};//姣忚締杞︾殑鏈�澶ц鍗曢噺闄愬埗
                 long[] demands1 = new long[customerListParam.size()+1]; //鍚勪釜鐐圭殑璁㈠崟閲�
+                long[] demands2 = new long[customerListParam.size()+1]; //鍚勪釜鐐圭殑璁㈠崟閲�
                 long[][] distanceMatrix1 = new long[customerListParam.size()+1][customerListParam.size()+1];
                 distanceMatrix1[0][0] = 0;
                 demands1[0] =0;//鍘熺偣
@@ -612,12 +802,13 @@
                     distanceMatrix1[0][i+1] =  disList.get(0).getDistance();
                     distanceMatrix1[i+1][0] = disList.get(disList.size() -1).getDistance();
                     demands1[i+1] = Constants.formatBigdecimal( customerListParam.get(i).getTotalNum()).longValue();  //鍚勪釜鐐圭殑璁㈠崟閲�
+                    demands2[i+1] = 1;  //鍚勪釜鐐圭殑璁㈠崟閲�
                     for (int j = 0; j < customerListParam.size(); j++) {
                         distanceMatrix1[i+1][j+1] =disList.get(j+1).getDistance() ;
                     }
                 }
                 //鏋勯�犱紭鍖栨暟鎹ā鍨�
-                dataModel.initDataInfo(vehicleNumber1,demands1,vehicleCapacities1,distanceMatrix1,vehicleMaxNodes);
+                dataModel.initDataInfo(vehicleNumber1,demands1,demands2,vehicleCapacities1,distanceMatrix1,vehicleMaxNodes);
                 TspSolver.startSearch(dataModel);
                 if(dataModel.getSolutions()==null || dataModel.getSolutions().size()==0){
                     throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"绾胯矾銆�"+line.getLineName()+"銆戣皟鏁村け璐� 锛屾湭鑾峰緱鏈�浼樹氦閫氳鍒掓柟妗堬紒");
@@ -701,6 +892,15 @@
 
     private void initCustomerDistance( List<JkSketchLine> lineList,JkSketch model,boolean updateLineDistance) {
         List<JkSketchCustomer> customerList = model.getCustomerList();
+        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){
+        }
         for(JkSketchCustomer c : customerList){
             List<DistanceMapParam> tmpList = new ArrayList<>();
             List<DistanceMapParam> distanceMapParamList  = getListFromJsonStr(c.getDistanceJson());
@@ -709,18 +909,21 @@
             t0.setDistance(Constants.formatLongNum(c.getStartDistance()) );
             if(Constants.formatLongNum(c.getStartDistance()) <= 0){
                 //鍥尯鍓嶅線璇ュ鎴风殑璺濈锛屽鏋滀箣鍓嶆湭鑾峰彇杩�
-                throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"璇ョ嚎璺鎴�:"+c.getName()+"浜ら�氳鍒掑皻鏈畬鎴愶紝涓嶆弧瓒充紭鍖栨潯浠讹紒");
+                t0.setDistance(DistanceCalculator.calculateDistanceDecinal(cLatitude,cLongitude,c.getLatitude(),c.getLongitude()));
+//                throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"璇ョ嚎璺鎴�:"+c.getName()+"浜ら�氳鍒掑皻鏈畬鎴愶紝涓嶆弧瓒充紭鍖栨潯浠讹紒");
             }
             tmpList.add(t0);
             for(JkSketchCustomer cm : customerList){
                 //瀹㈡埛鍜屽鎴蜂箣闂寸殑璺濈淇℃伅
                 DistanceMapParam t = new DistanceMapParam();
                 t.setId(cm.getCustomerId());
-                DistanceMapParam param = getParamByCustomerIds( cm.getCustomerId(),distanceMapParamList);
-                if(param!=null){//濡傛灉涔嬪墠宸茬粡鑾峰彇杩�
+                 DistanceMapParam param = getParamByCustomerIds( cm.getCustomerId(),distanceMapParamList);
+                if(param!=null && t.getDistance()>0){//濡傛灉涔嬪墠宸茬粡鑾峰彇杩�
                     t = param;
                 }else{
-                    throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"璇ョ嚎璺鎴�:"+c.getName()+"浜ら�氳鍒掑皻鏈畬鎴愶紝涓嶆弧瓒宠矾绋嬭绠楁潯浠讹紒");
+                    //濡傛灉鏈鍒掞紝鎸夌収鐩寸嚎璺濈
+                    t.setDistance(DistanceCalculator.calculateDistanceDecinal(cm.getLatitude(),cm.getLongitude(),c.getLatitude(),c.getLongitude()));
+//                    throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"璇ョ嚎璺鎴�:"+c.getName()+"涓庡鎴�:"+cm.getName()+"绠�浜ら�氳鍒掑皻鏈畬鎴愶紝涓嶆弧瓒宠矾绋嬭绠楁潯浠讹紒");
                 }
                 tmpList.add(t);
             }
@@ -729,7 +932,8 @@
             tt.setDistance(Constants.formatLongNum(c.getEndDistance()));
             if(Constants.formatLongNum(c.getEndDistance()) <= 0){
                 //璇ュ鎴疯繑鍥炲洯鍖虹殑璺濈 ,濡傛灉涔嬪墠鏈幏鍙栬繃
-                throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"璇ョ嚎璺鎴�:"+c.getName()+"浜ら�氳鍒掑皻鏈畬鎴愶紝涓嶆弧瓒宠矾绋嬭绠楁潯浠讹紒");
+                tt.setDistance(DistanceCalculator.calculateDistanceDecinal(cLatitude,cLongitude,c.getLatitude(),c.getLongitude()));
+//                throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"璇ョ嚎璺鎴�:"+c.getName()+"涓庤捣鐐逛氦閫氳鍒掑皻鏈畬鎴愶紝涓嶆弧瓒宠矾绋嬭绠楁潯浠讹紒");
             }
             tmpList.add(tt);
             c.setDistanceMapParamList(tmpList);
@@ -742,14 +946,27 @@
                 int index =0;
                 for(JkSketchCustomer c : customers){
                     if(index ==0){
-                        lineDistance+= Constants.formatLongNum(c.getStartDistance());
+                        if(c.getStartDistance() >0){
+                            lineDistance+= Constants.formatLongNum(c.getStartDistance());
+                        }else{
+                            lineDistance += DistanceCalculator.calculateDistanceDecinal(c.getLatitude(),c.getLongitude(),cLatitude,cLongitude);
+                        }
                     }
                     if(index == customers.size()-1){
-                        lineDistance+= Constants.formatLongNum(c.getEndDistance());
+                        if(c.getEndDistance() >0){
+                            lineDistance+= Constants.formatLongNum(c.getEndDistance());
+                        }else{
+                            lineDistance += DistanceCalculator.calculateDistanceDecinal(c.getLatitude(),c.getLongitude(),cLatitude,cLongitude);
+                        }
                         break;
                     }
-                    DistanceMapParam param = getParamByCustomerIds( customers.get(index+1).getCustomerId(),getListFromJsonStr(c.getDistanceJson()));
-                    lineDistance += param.getDistance();
+                    JkSketchCustomer end = customers.get(index+1);
+                    DistanceMapParam param1 = getParamByCustomerIds(end.getCustomerId(),getListFromJsonStr(c.getDistanceJson()));
+                    if(param1 !=null && param1.getDistance()>0){
+                        lineDistance += param1.getDistance();
+                    }else{
+                        lineDistance += DistanceCalculator.calculateDistanceDecinal(c.getLatitude(),c.getLongitude(),end.getLatitude(),end.getLongitude());
+                    }
                     index++;
                   /*  for(JkSketchCustomer cm : customers){
                         DistanceMapParam param = getParamByCustomerIds( cm.getCustomerId(),getListFromJsonStr(c.getDistanceJson()));
@@ -779,7 +996,7 @@
         return list;
     }
 
-    private DistanceMapParam getParamByCustomerIds(  Integer id1, List<DistanceMapParam> distanceMapParamList) {
+    public static DistanceMapParam getParamByCustomerIds(  Integer id1, List<DistanceMapParam> distanceMapParamList) {
         if(distanceMapParamList!=null){
             for(DistanceMapParam p :distanceMapParamList){
                 if(Constants.equalsInteger(p.getId(),id1)){
@@ -791,7 +1008,7 @@
         return null;
     }
 
-    private List<DistanceMapParam> getListFromJsonStr(String distanceJson) {
+    public static List<DistanceMapParam> getListFromJsonStr(String distanceJson) {
         try {
             return  JSONObject.parseObject(distanceJson, new TypeReference<List<DistanceMapParam>>(){}.getType());
         }catch (Exception e){
@@ -799,7 +1016,114 @@
         return new ArrayList<>();
     }
 
-    private void dealSearchSolution(JkSketch model, TspSolver.DataModel dataModel) {
+    private void dealSearchSolution(JkSketch model, List<SketchCateModel> customerList,TspSolver.DataModel dataModel) {
+        Date date = new Date();
+        List<TspSolverSolutions> solutions = dataModel.getSolutions();
+        List<JkSketchLine> sketchLineList = new ArrayList<>();
+        List<JkSketchCustomer> sketchCustomerList  = new ArrayList<>();
+        long totalDistance = 0l;
+        if(solutions!=null && solutions.size()>0){
+            for(TspSolverSolutions so : solutions){
+                List<Integer> routes = so.getRouteIndex();
+                totalDistance+= so.getDistance();
+                if(routes.size() <=2) {
+                    continue;//鏃犲鎴风殑闈炴湁鏁堣矾绾�
+                }
+                JkLine  line =model.getLineList().get(so.getLineIndex());
+                JkSketchLine tModel =  new JkSketchLine();
+                tModel.setSketchId(model.getId());
+                tModel.setCreator(model.getEditor());
+                tModel.setCreateDate(date);
+                tModel.setLineId(line.getId());
+                tModel.setTotalNum(new BigDecimal(0));
+                tModel.setDateInfo(model.getDateInfo());
+                tModel.setType(Constants.ONE);
+                tModel.setSortnum(sketchLineList.size()+1);
+                tModel.setEditDate(tModel.getCreateDate());
+                tModel.setEditor(tModel.getCreator());
+                tModel.setIsdeleted(Constants.ZERO);
+                tModel.setDistance(so.getDistance());//
+                sketchLineList.add(tModel);
+                tModel.setCustomerList( new ArrayList<>());
+                //鏈夋晥璺緞
+                for (Integer cIndex : routes){
+                    if(cIndex ==0){
+                        continue; //璧峰鐐逛笉澶勭悊
+                    }
+//                    JkSketchCustomer customer = model.getCustomerList().get(cIndex-1);
+//                    tModel.setTotalNum(tModel.getTotalNum().add(Constants.formatBigdecimal(customer.getTotalNum())));//閫佽揣閲�
+                    SketchCateModel cateModel = customerList.get(cIndex-1);
+                    tModel.setTotalNum(tModel.getTotalNum().add(Constants.formatBigdecimal(cateModel.getTotalNum())));//閫佽揣閲�
+                    for(int t=0;t<cateModel.getCustomerList().size();t++){
+                        JkSketchCustomer customer = cateModel.getCustomerList().get(t);
+                        JkSketchCustomer cModel =  new JkSketchCustomer();
+                        cModel.setCreator(tModel.getCreator());
+                        cModel.setOrderId(customer.getOrderId());
+                        cModel.setCreateDate(tModel.getCreateDate());
+                        cModel.setType(Constants.ONE);
+                        cModel.setTotalNum(customer.getTotalNum());
+                        cModel.setDateInfo(model.getDateInfo());
+                        cModel.setSortnum(tModel.getCustomerList().size()+1);
+                        cModel.setEditDate(tModel.getCreateDate());
+                        cModel.setEditor(tModel.getCreator());
+                        cModel.setIsdeleted(Constants.ZERO);
+                        cModel.setSketchId(model.getId());
+                        cModel.setCustomerId(customer.getCustomerId());
+                        if(t < cateModel.getCustomerList().size()-1){
+                            long tdistance = (long)Clustering.distanceTo(customer, cateModel.getCustomerList().get(t+1));
+                            tModel.setDistance(Constants.formatLongNum(tModel.getDistance()) +tdistance);
+                            totalDistance  += tdistance;
+                        }
+                        tModel.getCustomerList().add(cModel);
+                    }
+                    tModel.setOrderNum( tModel.getCustomerList().size());
+                }
+            }
+        }
+        if(sketchLineList!=null && sketchLineList.size()>0){
+            jkSketchLineMapper.update(null,new UpdateWrapper<JkSketchLine>().lambda()
+                    .set(JkSketchLine::getIsdeleted,Constants.ONE)
+                    .eq(JkSketchLine::getIsdeleted,Constants.ZERO)
+                    .eq(JkSketchLine::getType,Constants.ONE)
+                    .eq(JkSketchLine::getDateInfo,model.getDateInfo()));
+            jkSketchCustomerMapper.update(null,new UpdateWrapper<JkSketchCustomer>().lambda()
+                    .set(JkSketchCustomer::getIsdeleted,Constants.ONE)
+                    .eq(JkSketchCustomer::getIsdeleted,Constants.ZERO)
+                    .eq(JkSketchCustomer::getType,Constants.ONE)
+                    .eq(JkSketchCustomer::getDateInfo,model.getDateInfo()));
+            if(sketchLineList.size()>0){
+                jkSketchLineMapper.insert(sketchLineList);
+            }
+            for(JkSketchLine l : sketchLineList){
+                if(l.getCustomerList()!=null ){
+                    for(JkSketchCustomer c :l.getCustomerList()){
+                        c.setSketchLineId(l.getId());
+                    }
+                    sketchCustomerList.addAll(l.getCustomerList());
+                }
+            }
+            if(sketchCustomerList.size()>0){
+                jkSketchCustomerMapper.insert(sketchCustomerList);
+            }
+            jkSketchMapper.update(null,new UpdateWrapper<JkSketch>().lambda()
+                    .eq(JkSketch::getId,model.getId() )
+                    .eq(JkSketch::getJobId,model.getJobId() )
+                    .set(JkSketch::getLineNum,sketchLineList.size() )
+                    .set(JkSketch::getOptStatus,Constants.ONE)//宸茬敓鎴愪紭鍖栫嚎璺�
+                    .set(JkSketch::getDistance,totalDistance)
+                    .set(JkSketch::getPlanLineInfo,"鏈�杩戜竴娆$嚎璺紭鍖栨垚鍔燂紝浼樺寲鍚庢�昏窛绂伙細"+(totalDistance/1000)+"鍏噷锛�")
+                    .set(JkSketch::getStatus,Constants.TWO)
+                    .set(JkSketch::getPlanLineEndDate,date));
+        }else{
+            jkSketchMapper.update(null,new UpdateWrapper<JkSketch>().lambda()
+                    .eq(JkSketch::getId,model.getId() )
+                    .eq(JkSketch::getJobId,model.getJobId() )
+                    .set(JkSketch::getPlanLineInfo,"鏈�杩戜竴娆$嚎璺紭鍖栧け璐�,鏈壘鍒版渶浼樿矾绾匡紒")
+                    .set(JkSketch::getStatus,Constants.THREE)
+                    .set(JkSketch::getPlanLineEndDate,date));
+        }
+    }
+    private void dealSearchSolutionOld(JkSketch model, TspSolver.DataModel dataModel) {
         Date date = new Date();
         List<TspSolverSolutions> solutions = dataModel.getSolutions();
         List<JkSketchLine> sketchLineList = new ArrayList<>();
@@ -923,11 +1247,11 @@
         String errorMsg1 ="";
         for(JkSketchCustomer c : customerList){
             if(c.getLatitude()==null || c.getLongitude() ==null){
-                errorMsg += c.getName()+"-"+c.getName()+" | ";
+                errorMsg +=  c.getName()+" | ";
             }
-            if(!Constants.equalsInteger(c.getDistanceStatus(),Constants.ONE)){
-                errorMsg1 += c.getName()+"-"+c.getName()+" | ";
-            }
+        /*    if(!Constants.equalsInteger(c.getDistanceStatus(),Constants.ONE)){
+                errorMsg1 +=  c.getName()+" | ";
+            }*/
         }
         if(StringUtils.isNotBlank(errorMsg)){
             throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"璇ョ嚎璺鎴�:銆�"+errorMsg+"銆戝畾浣嶄俊鎭笉瀹屾暣锛屼笉婊¤冻浼樺寲鏉′欢锛�");
@@ -1506,26 +1830,6 @@
         List<JkSketchLine> jkSketchLineList = jkSketchLineMapper.selectJoinList(JkSketchLine.class,queryWrapper);
 
         List<TelecomCategoryDataVO> telecomCategoryDataVOList = new ArrayList<>();
-        for (JkSketch jkSketch:sketchList) {
-            TelecomCategoryDataVO telecomCategoryDataVO = new TelecomCategoryDataVO();
-            telecomCategoryDataVO.setId(jkSketch.getCategoryId());
-            telecomCategoryDataVO.setName(jkSketch.getCategoryName());
-            //浼樺寲鍓嶆暟鎹�
-            List<JkSketchLine> beforeList = jkSketchLineList.stream()
-                    .filter(i->Constants.equalsInteger(i.getSketchId(),jkSketch.getId())
-                            && Objects.nonNull(i.getDistance())
-                            &&Constants.equalsInteger(i.getType(),Constants.ZERO)).collect(Collectors.toList());
-            telecomCategoryDataVO.setDistance(
-                    beforeList.stream().map(i->i.getDistance()).reduce(Long.valueOf(0),Long::sum)
-            );
-            if(Constants.equalsInteger(jkSketch.getOptStatus(),Constants.ZERO)){
-                telecomCategoryDataVO.setDistanceAfter(telecomCategoryDataVO.getDistance());
-            }else{
-                //浼樺寲鍚庢暟鎹�
-                List<JkSketchLine> afterList = jkSketchLineList.stream()
-                        .filter(i->Constants.equalsInteger(i.getSketchId(),jkSketch.getId())
-                                && Objects.nonNull(i.getDistance())
-                                &&Constants.equalsInteger(i.getType(),Constants.ONE)&&Constants.equalsInteger(i.getIsdeleted(),Constants.ZERO)).collect(Collectors.toList());
         if(sketchList!=null){
             for (JkSketch jkSketch:sketchList) {
                 TelecomCategoryDataVO telecomCategoryDataVO = new TelecomCategoryDataVO();
@@ -1533,7 +1837,9 @@
                 telecomCategoryDataVO.setName(jkSketch.getCategoryName());
                 //浼樺寲鍓嶆暟鎹�
                 List<JkSketchLine> beforeList = jkSketchLineList.stream()
-                        .filter(i->Constants.equalsInteger(i.getSketchId(),jkSketch.getId())&&Constants.equalsInteger(i.getType(),Constants.ZERO)).collect(Collectors.toList());
+                        .filter(i->Constants.equalsInteger(i.getSketchId(),jkSketch.getId())
+                                && Objects.nonNull(i.getDistance())
+                                &&Constants.equalsInteger(i.getType(),Constants.ZERO)).collect(Collectors.toList());
                 telecomCategoryDataVO.setDistance(
                         beforeList.stream().map(i->i.getDistance()).reduce(Long.valueOf(0),Long::sum)
                 );
@@ -1542,7 +1848,9 @@
                 }else{
                     //浼樺寲鍚庢暟鎹�
                     List<JkSketchLine> afterList = jkSketchLineList.stream()
-                            .filter(i->Constants.equalsInteger(i.getSketchId(),jkSketch.getId())&&Constants.equalsInteger(i.getType(),Constants.ONE)&&Constants.equalsInteger(i.getIsdeleted(),Constants.ZERO)).collect(Collectors.toList());
+                            .filter(i->Constants.equalsInteger(i.getSketchId(),jkSketch.getId())
+                                    && Objects.nonNull(i.getDistance())
+                                    &&Constants.equalsInteger(i.getType(),Constants.ONE)&&Constants.equalsInteger(i.getIsdeleted(),Constants.ZERO)).collect(Collectors.toList());
 
                     Long distanceAfter = 0L;
                     for (JkSketchLine jkSketchLine:afterList) {

--
Gitblit v1.9.3