From 93c5fd918d5584f4dea767fcc20b832467c4b4f1 Mon Sep 17 00:00:00 2001
From: rk <94314517@qq.com>
Date: 星期四, 20 十一月 2025 18:02:10 +0800
Subject: [PATCH] 钥匙柜大屏

---
 server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/JkSketchServiceImpl.java |  236 ++++++++++++++++++++++++++++++++++++++--------------------
 1 files changed, 154 insertions(+), 82 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 cbcb8bd..cf239d5 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
@@ -129,8 +129,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,12 +255,12 @@
     @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);
             BigDecimal cLongitude =new BigDecimal(0);
-
             String location = systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.COMPANY_LOCATION).getCode();
             try {
                 String[] ss = location.split(",");
@@ -269,49 +268,86 @@
                 cLatitude =  new BigDecimal(ss[1]);
             }catch (Exception e){
             }
-            int index =0;
-            for(JkCustomer c : customerList){
-                try {
-                    log.info("浜ら�氳鍒�========"+c.getName()+"==========="+index++);
-                    dealDistancePerCustomer(c,url,date,cLatitude,cLongitude,customerList);
-                }catch (Exception e){
-
-                }
+            int circle = customerList.size()/100;//
+            if(customerList.size()%100>0){
+                circle +=1;
             }
 
+            boolean[] results = new boolean[circle] ;
+            for (int i = 0; i < circle; i++) {
+                final  int start =i*100;
+                final int end = (i+1)*100 > customerList.size()? customerList.size(): (i+1)*100;
+                results[i] =false;
+                BigDecimal finalCLatitude = cLatitude;
+                BigDecimal finalCLongitude = cLongitude;
+                log.error("浜ら�氳鍒�====绾跨▼circle锛�"+i+"====start:"+start+"===========end:"+end);
+                int finalI = i;
+                Thread t1=new Thread(() -> {
+                    try {
+                        int index =0;
+                        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,allList);
+                            }catch (Exception e){
+
+                            }
+                        }
+                    }catch (Exception e){
+                    }finally {
+                        results[finalI] =true;
+                        boolean isDone = false;
+                        for(boolean t : results){
+                            isDone = isDone&&t;
+                        }
+                        if(isDone){
+                            cate.setStatus(Constants.ZERO);
+                            categoryMapper.updateById(cate);//鏇存柊浠诲姟鎵ц鐘舵��
+                        }
+                    }
+
+                });
+                t1.start();
+            }
         }catch (Exception e){
             e.printStackTrace();
         }finally {
-            cate.setStatus(Constants.ZERO);
-            categoryMapper.updateById(cate);//鏇存柊浠诲姟鎵ц鐘舵��
+
         }
     }
 
-    private void dealDistancePerCustomer(JkCustomer c, String url, Date date, BigDecimal cLatitude, BigDecimal cLongitude, List<JkCustomer> customerList) {
+    private void dealDistancePerCustomer(JkCustomer c, String url, Date date, BigDecimal cLatitude, BigDecimal cLongitude, List<JkCustomer> customerList) throws InterruptedException {
         List<JkCustomer> updateCustomerList = new ArrayList<>();
         List<JkCustomerNavigation> navigationList = new ArrayList<>();
         List<DistanceMapParam> tmpList = new ArrayList<>();
         List<DistanceMapParam> distanceMapParamList  = getListFromJsonStr(c.getDistance());
-        boolean isNew = false;
+        boolean isNew = false,hasError =false;
         JkCustomer u =new JkCustomer();
         DistanceMapParam t0 = new DistanceMapParam();
         t0.setId(-2);//琛ㄧず杩斿洖鍥尯
         t0.setDistance(Constants.formatLongNum(c.getStartDistance()) );
         if(Constants.formatLongNum(c.getStartDistance()) <= 0){
-            //鍥尯鍓嶅線璇ュ鎴风殑璺濈锛屽鏋滀箣鍓嶆湭鑾峰彇杩�
+            //鍥尯鍓嶅線璇ュ鎴风殑璺濈锛屽鏋滀箣鍓嶆湭鑾峰彇
             isNew = true;
             JkCustomer start = new JkCustomer();
             start.setId(-1);
             start.setLongitude(cLongitude);
             start.setLatitude(cLatitude);
             DistanceCustomerModel dm = DistanceCalculator.calculateDistanceGaode(url,start,c);
-            c.setStartDistance(dm.getDistance() );
-            t0.setDistance(dm.getDistance());
-            u.setStartDistance(dm.getDistance());
-            if(dm.getLocations().size()>0){
-                //濡傛灉鏈夎矾寰勪俊鎭�
-                u.setStartSteps(dm.getPolyline());
+            if(dm.getCode() == 1){
+                //瑙勫垝澶辫触
+                log.error("==============瀹㈡埛浜ら�氳鍒掓垚鍔熻捣鐐�:"+c.getName());
+                c.setStartDistance(dm.getDistance() );
+                t0.setDistance(dm.getDistance());
+                u.setStartDistance(dm.getDistance());
+                if(dm.getLocations().size()>0){
+                    //濡傛灉鏈夎矾寰勪俊鎭�
+                    u.setStartSteps(dm.getPolyline());
+                }
+            }else{
+                hasError=true;
             }
+
         }
         tmpList.add(t0);
         for(JkCustomer cm : customerList){
@@ -319,7 +355,7 @@
             DistanceMapParam t = new DistanceMapParam();
             t.setId(cm.getId());
             DistanceMapParam param = getParamByCustomerIds( cm.getId(),distanceMapParamList);
-            if(param!=null){//濡傛灉涔嬪墠宸茬粡鑾峰彇杩�
+            if(param!=null && param.getDistance()!=0){//濡傛灉涔嬪墠宸茬粡鑾峰彇杩�
                 t = param;
             }else{
                 JkCustomerNavigation navigation = new JkCustomerNavigation();
@@ -338,10 +374,15 @@
                 }else{
                     DistanceCustomerModel dm = DistanceCalculator.calculateDistanceGaode(url,c,cm);
                     t.setDistance(dm.getDistance() );
-                    if(dm.getLocations().size()>0){
-                        //濡傛灉鏈夎矾寰勪俊鎭�
-                        navigation.setSteps(dm.getPolyline());
+                    if(dm.getCode() == 1){
+                        if(dm.getLocations().size()>0){
+                            //濡傛灉鏈夎矾寰勪俊鎭�
+                            navigation.setSteps(dm.getPolyline());
+                        }
+                    }else{
+                        hasError=true;
                     }
+
                 }
                 navigation.setIdIndex(c.getId()+"-"+cm.getId());
                 navigation.setDistance(t.getDistance());
@@ -359,19 +400,25 @@
             start.setId(-1);
             start.setLongitude(cLongitude);
             start.setLatitude(cLatitude);
-
             DistanceCustomerModel dm = DistanceCalculator.calculateDistanceGaode(url,c,start);
-            c.setEndDistance(dm.getDistance() );
-            tt.setDistance(dm.getDistance());
-            u.setEndDistance(dm.getDistance());
-            if(dm.getLocations().size()>0){
-                //濡傛灉鏈夎矾寰勪俊鎭�
-                u.setEndSteps(dm.getPolyline());
+            if(dm.getCode()== 1){
+                //瑙勫垝澶辫触
+                log.error("==============瀹㈡埛浜ら�氳鍒掓垚鍔�2:"+c.getName());
+                c.setEndDistance(dm.getDistance() );
+                tt.setDistance(dm.getDistance());
+                u.setEndDistance(dm.getDistance());
+                if(dm.getLocations().size()>0){
+                    //濡傛灉鏈夎矾寰勪俊鎭�
+                    u.setEndSteps(dm.getPolyline());
+                }
+            }else{
+                hasError=true;
             }
+
         }
         tmpList.add(tt);
         if(isNew){//
-            u.setDistanceStatus(Constants.ONE);
+            u.setDistanceStatus(hasError?Constants.ZERO:Constants.ONE);//鎵�鏈夐兘鎴愬姛鎵嶆爣娉ㄥ凡瑙勫垝
             u.setId(c.getId());
             u.setDistance(JSONObject.toJSONString(tmpList));
             updateCustomerList.add(u);
@@ -382,8 +429,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);//鎻掑叆鏈�鏂版暟鎹�
         }
     }
@@ -431,8 +480,8 @@
                 .eq(JkCustomer::getIsdeleted,Constants.ZERO)
                 .eq(JkLine::getCategoryId,model.getCategoryId() );
         List<JkCustomer> customerList = jkCustomerMapper.selectJoinList(JkCustomer.class,queryWrapper1);
-        List<JkCustomer> needList =checkNeedDistanceDo(customerList);
-        if(needList == null || needList.size() == 0){
+         List<JkCustomer> needList =checkNeedDistanceDo(customerList);
+        if(Constants.equalsInteger(model.getForceUpdate(),0)&& (needList == null || needList.size() == 0)){
             throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"璇ヤ富绾夸笅鏃犻渶瑕佽繘琛岃窛绂昏绠楃殑瀹㈡埛淇℃伅锛�");
         }
         String errorMsg ="";
@@ -447,6 +496,7 @@
         c.setStatus(Constants.TWO);
         categoryMapper.updateById(c);//鏇存柊浠诲姟鎵ц鐘舵��
         c.setCustomerList(customerList);
+        c.setNeedList(Constants.equalsInteger(model.getForceUpdate(),0)?needList:customerList);
         return  c;
     }
 
@@ -463,6 +513,7 @@
             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[][] distanceMatrix1 = new long[customerList.size()+1][customerList.size()+1];
             distanceMatrix1[0][0] = 0;
@@ -488,9 +539,10 @@
             }
             for (int i = 0; i < lineList.size(); i++) {
                 vehicleCapacities1[i] = lineList.get(i).getMaxOrder();//姣忚締杞︾殑鏈�澶ц鍗曢噺闄愬埗
+                vehicleMaxNodes[i] =lineList.get(i).getMaxCustomer();//鏈�澶у鎴锋暟
             }
             //鏋勯�犱紭鍖栨暟鎹ā鍨�
-            dataModel.initDataInfo(vehicleNumber1,demands1,vehicleCapacities1,distanceMatrix1);
+            dataModel.initDataInfo(vehicleNumber1,demands1,vehicleCapacities1,distanceMatrix1,vehicleMaxNodes);
             TspSolver.startSearch(dataModel);
             dealSearchSolution(model,dataModel);
         }catch (Exception e){
@@ -553,6 +605,7 @@
                 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[][] distanceMatrix1 = new long[customerListParam.size()+1][customerListParam.size()+1];
                 distanceMatrix1[0][0] = 0;
@@ -567,7 +620,7 @@
                     }
                 }
                 //鏋勯�犱紭鍖栨暟鎹ā鍨�
-                dataModel.initDataInfo(vehicleNumber1,demands1,vehicleCapacities1,distanceMatrix1);
+                dataModel.initDataInfo(vehicleNumber1,demands1,vehicleCapacities1,distanceMatrix1,vehicleMaxNodes);
                 TspSolver.startSearch(dataModel);
                 if(dataModel.getSolutions()==null || dataModel.getSolutions().size()==0){
                     throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"绾胯矾銆�"+line.getLineName()+"銆戣皟鏁村け璐� 锛屾湭鑾峰緱鏈�浼樹氦閫氳鍒掓柟妗堬紒");
@@ -651,6 +704,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());
@@ -659,18 +721,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);
+                 DistanceMapParam param = getParamByCustomerIds( cm.getCustomerId(),distanceMapParamList);
                 if(param!=null){//濡傛灉涔嬪墠宸茬粡鑾峰彇杩�
                     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);
             }
@@ -679,7 +744,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);
@@ -729,7 +795,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)){
@@ -741,7 +807,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){
@@ -873,11 +939,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+"銆戝畾浣嶄俊鎭笉瀹屾暣锛屼笉婊¤冻浼樺寲鏉′欢锛�");
@@ -975,7 +1041,7 @@
             queryWrapper.eq(JkSketch::getSortnum, pageWrap.getModel().getSortnum());
         }
         if (pageWrap.getModel().getDateInfo() != null) {
-            queryWrapper.eq(JkSketch::getDateInfo,  pageWrap.getModel().getDateInfo());
+            queryWrapper.like(JkSketch::getDateInfo,  DateUtil.dateToString(pageWrap.getModel().getDateInfo(),"yyyy-MM-dd"));
         }
         if (pageWrap.getModel().getJobId() != null) {
             queryWrapper.eq(JkSketch::getJobId, pageWrap.getModel().getJobId());
@@ -1322,6 +1388,7 @@
                 .leftJoin(JkLine.class,JkLine::getId,JkSketchLine::getLineId)
                 .leftJoin(Category.class,Category::getId,JkLine::getCategoryId )
                 .leftJoin(Cars.class,Cars::getId,JkLine::getCarId)
+                .eq(JkSketch::getIsdeleted,Constants.ZERO)
                 .and(StringUtils.isNotBlank(telecomLineInfoDTO.getSearchInfo()),i->i.like(Cars::getCode,telecomLineInfoDTO.getSearchInfo()).or().like(JkLine::getName,telecomLineInfoDTO.getSearchInfo()))
                 .like(StringUtils.isNotBlank(telecomLineInfoDTO.getDateInfo()),JkSketch::getDateInfo, telecomLineInfoDTO.getDateInfo())
                 .eq(Objects.nonNull(telecomLineInfoDTO.getCategoryId()),JkLine::getCategoryId, telecomLineInfoDTO.getCategoryId())
@@ -1367,9 +1434,10 @@
         telecomLineCountVO.setCustomerNum(Constants.ZERO);
         MPJLambdaWrapper<JkSketch> sketchMPJLambdaWrapper = new MPJLambdaWrapper<JkSketch>().selectAll(JkSketch.class )
                 .selectAs(Category::getName,JkSketch::getCategoryName)
-                .select(" ifnull((select count(1) from jk_sketch_customer jc where jc.ISDELETED= 0 and  jc.SKETCH_ID = t.id),0)" ,JkSketch::getCustomerNum)
+                .select(" ifnull((select count(1) from jk_sketch_customer jc where jc.ISDELETED = 0 and  jc.SKETCH_ID = t.id),0)" ,JkSketch::getCustomerNum)
                 .select(" ifnull((select count(1) from jk_sketch_line jc where   jc.TYPE = 0  and  jc.SKETCH_ID = t.id),0)" ,JkSketch::getBeforeLineNum)
                 .leftJoin(Category.class,Category::getId,JkSketch::getCategoryId )
+                .eq(JkSketch::getIsdeleted,Constants.ZERO)
                 .like(JkSketch::getDateInfo, telecomLineInfoDTO.getDateInfo());
         List<JkSketch> sketchList = jkSketchMapper.selectJoinList(JkSketch.class,sketchMPJLambdaWrapper);
         if(CollectionUtils.isEmpty(sketchList)){
@@ -1396,27 +1464,24 @@
             TelecomCategoryDataVO telecomCategoryDataVO = new TelecomCategoryDataVO();
             telecomCategoryDataVO.setId(jkSketch.getCategoryId());
             telecomCategoryDataVO.setName(jkSketch.getCategoryName());
-            telecomCategoryDataVO.setCustomerNum(jkSketch.getCustomerNum());
+            telecomCategoryDataVO.setCustomerNum(Constants.ZERO);
             List<JkSketchLine> childLineList = jkSketchLineList.stream().filter(i->Constants.equalsInteger(i.getSketchId(),jkSketch.getId())).collect(Collectors.toList());
             //浼樺寲鍓嶆暟鎹�
-            List<JkSketchLine> beforeList = childLineList.stream()
+            List<JkSketchLine> beforeList = jkSketchLineList.stream()
                     .filter(i->Constants.equalsInteger(i.getType(),Constants.ZERO)).collect(Collectors.toList());
             //浼樺寲鍚庢暟鎹�
             List<JkSketchLine> afterList = childLineList.stream()
-                    .filter(i->Constants.equalsInteger(i.getType(),Constants.ONE)&&Constants.equalsInteger(i.getIsdeleted(),Constants.ZERO)).collect(Collectors.toList());
+                    .filter(i->Constants.equalsInteger(i.getType(),Constants.ONE)
+                            && Constants.equalsInteger(i.getIsdeleted(),Constants.ZERO)).collect(Collectors.toList());
 
             lineNum = lineNum + (Constants.equalsInteger(jkSketch.getOptStatus(),Constants.ZERO)?beforeList.size():afterList.size());
             List<TelecomLineDataVO> telecomLineDataVOList = new ArrayList<>();
             for (JkSketchLine sketchLine: Constants.equalsInteger(jkSketch.getOptStatus(),Constants.ZERO)?beforeList:afterList) {
-//                JkSketchLine finalSketchLine = sketchLine;
-//                List<JkSketchLine> afterSelectList = afterList.stream().filter(i->Constants.equalsInteger(i.getLineId(), finalSketchLine.getLineId())).collect(Collectors.toList());
-//                if(afterSelectList.size()>Constants.ZERO){
-//                    sketchLine = afterSelectList.get(Constants.ZERO);
-//                }
                 TelecomLineDataVO telecomLineDataVO = new TelecomLineDataVO();
                 telecomLineDataVO.setId(sketchLine.getId());
                 telecomLineDataVO.setName(sketchLine.getLineName());
                 telecomLineDataVOList.add(telecomLineDataVO);
+                telecomCategoryDataVO.setCustomerNum(telecomCategoryDataVO.getCustomerNum() +  sketchLine.getMaxCustomer());
                 telecomLineCountVO.setCustomerNum(
                         telecomLineCountVO.getCustomerNum() + sketchLine.getMaxCustomer()
                 );
@@ -1439,6 +1504,7 @@
         MPJLambdaWrapper<JkSketch> sketchMPJLambdaWrapper = new MPJLambdaWrapper<JkSketch>().selectAll(JkSketch.class )
                 .selectAs(Category::getName,JkSketch::getCategoryName)
                 .leftJoin(Category.class,Category::getId,JkSketch::getCategoryId )
+                .eq(JkSketch::getIsdeleted,Constants.ZERO)
                 .like(JkSketch::getDateInfo, telecomLineInfoDTO.getDateInfo());
         List<JkSketch> sketchList = jkSketchMapper.selectJoinList(JkSketch.class,sketchMPJLambdaWrapper);
         if(CollectionUtils.isEmpty(sketchList)){
@@ -1456,31 +1522,37 @@
         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())&&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())&&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();
+                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());
 
-                Long distanceAfter = 0L;
-                for (JkSketchLine jkSketchLine:afterList) {
+                    Long distanceAfter = 0L;
+                    for (JkSketchLine jkSketchLine:afterList) {
                         distanceAfter = distanceAfter + jkSketchLine.getDistance();
-                }
-                telecomCategoryDataVO.setDistanceAfter(distanceAfter);
+                    }
+                    telecomCategoryDataVO.setDistanceAfter(distanceAfter);
 
+                }
+                telecomCategoryDataVOList.add(telecomCategoryDataVO);
             }
-            telecomCategoryDataVOList.add(telecomCategoryDataVO);
         }
         return telecomCategoryDataVOList;
     }

--
Gitblit v1.9.3