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