潘钊 / bsth_control · Files

package com.bsth.service.impl;

import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import com.bsth.common.ResponseCode;
import com.bsth.entity.Line;
import com.bsth.entity.LsSectionRoute;
import com.bsth.entity.LsStationRoute;
import com.bsth.entity.Section;
import com.bsth.entity.SectionRoute;
import com.bsth.entity.SectionRouteCache;
import com.bsth.entity.StationRoute;
import com.bsth.entity.StationRouteCache;
import com.bsth.repository.LineRepository;
import com.bsth.repository.LineVersionsRepository;
import com.bsth.repository.LsSectionRouteRepository;
import com.bsth.repository.LsStationRouteRepository;
import com.bsth.repository.SectionRepository;
import com.bsth.repository.SectionRouteCacheRepository;
import com.bsth.repository.SectionRouteRepository;
import com.bsth.repository.StationRouteCacheRepository;
import com.bsth.repository.StationRouteRepository;
import com.bsth.service.SectionService;
import com.bsth.util.GetUIDAndCode;
import com.bsth.util.TransGPS;
import com.bsth.util.TransGPS.Location;
import com.bsth.util.Geo.GeoUtils;
import com.bsth.util.Geo.Point;

/**
 * 
 * @ClassName: SectionServiceImpl(路段service业务层实现类)
 * 
 * @Extends : BaseService
 * 
 * @Description: TODO(路段service业务层)
 * 
 * @Author bsth@lq
 * 
 * @Date 2016年05月03日 上午9:21:17
 *
 * @Version 公交调度系统BS版 0.1
 * 
 */

@Service
public class SectionServiceImpl extends BaseServiceImpl<Section, Integer> implements SectionService{
	
	@Autowired
	SectionRepository repository;
	
	@Autowired
	LineRepository lineRepository;
	
	@Autowired
	LineVersionsRepository lineVersionsRepository;
	
	@Autowired
	SectionRouteRepository routeRepository;
	
	@Autowired
	LsSectionRouteRepository lsRouteRepository;
	
	@Autowired
	SectionRouteCacheRepository routeCacheRepository;
	
	@Autowired
	StationRouteRepository stationRouteRepository;
	
	@Autowired
	LsStationRouteRepository lsStationRouteRepository;
	
	@Autowired
	StationRouteCacheRepository stationRouteCacheRepository;
	
	/**
	 * @Description :TODO(生成新的线路走向)
	 * 
	 * @param map <sectionId:路段ID； sectionJSON：路段信息>
	 * 
	 * @return Map<String, Object> <SUCCESS ; ERROR>
	 */
	@Override
	@Transactional
	public Map<String, Object> sectionCut(Map<String, Object> map) {
		Map<String, Object> resultMap = new HashMap<String, Object>();
		try {
			// 路段点List
			List<Point> bPointsList = new ArrayList<>();
			// 截取路段点List
//			List<Point> bPointsCutList = new ArrayList<>();
			// 截取后的路段
			List<Map<String, String>> sectionArrayList = new ArrayList<>();
			String bsectionVector = map.get("sectionBsectionVector").equals("") ? "" :map.get("sectionBsectionVector").toString();
			String bsectionVectorCutList = map.get("cutSectionList").equals("") ? "" :map.get("cutSectionList").toString();
			sectionListCut(bPointsList, sectionArrayList, bsectionVector, bsectionVectorCutList);			
			
			// 原坐标类型
			String dbType = map.get("sectiondbType").equals("") ? "" : map.get("sectiondbType").toString();
			// 说明
			String descriptions = map.get("descriptions").equals("") ? "" : map.get("descriptions").toString();
			// 是否撤销
			Integer destroy = map.get("destroy").equals("") ? null : Integer.parseInt(map.get("destroy").toString());
			// 方向
			Integer directions = map.get("sectionrouteDirections").equals("") ? null : Integer.parseInt(map.get("sectionrouteDirections").toString());
			// 线路ID
			Integer sectionRouteLine = map.get("sectionrouteLine").equals("") ? null : Integer.parseInt(map.get("sectionrouteLine").toString());
			// 道路编码
			String roadCoding = map.get("sectionRoadCoding").equals("") ? "" : map.get("sectionRoadCoding").toString();
			// 路段长度
			Double sectionDistance = 0.0;
			// 路段路由Id
//			Integer sectionRouteId = map.get("sectionrouteId").equals("") ? null : Integer.valueOf(map.get("sectionrouteId").toString());
			// 线路编码
			String lineCode =map.get("sectionrouteLineCode").equals("") ? "" : map.get("sectionrouteLineCode").toString();
			// 路段时长
			Double  sectionTime = 0.0;
			// 路段路由
			Integer sectionrouteCode = map.get("sectionrouteCode").equals("") ? null : Integer.valueOf(map.get("sectionrouteCode").toString());
			// 限速
			Double speedLimit = map.get("sectionSpeedLimet").equals("") ? null : Double.valueOf(map.get("sectionSpeedLimet").toString());
			// 版本
			Integer versions = map.get("versions").equals("") ? null : Integer.valueOf(map.get("versions").toString());
			
			Integer createBy = map.get("createBy").equals("") ? null : Integer.valueOf(map.get("createBy").toString());
			String createDate = map.get("createDate").equals("") ? null : map.get("createDate").toString();
			Integer updateBy = map.get("updateBy").equals("") ?null : Integer.valueOf(map.get("updateBy").toString());
			Integer isRoadeSpeed = map.get("isRoadeSpeed").equals("") ? null : Integer.valueOf(map.get("isRoadeSpeed").toString());
			SimpleDateFormat formatter = new SimpleDateFormat ("yyyy-MM-dd HH:mm:ss"); 
			Date date = new Date();
			// 修改日期
			String updateDate = formatter.format(date);
			String crosesRoad="";
			String endNode="";
			String startNode="";
			String middleNode="";
			String sectionType="";
			String csectionVector="";	
			// 撤销原有路段路由
			routeRepository.sectionRouteUpdDestroy(sectionRouteLine,directions);
			// 路段保存
			for (int i = 0; i < sectionArrayList.size(); i++) {
				long sectionMaxId = GetUIDAndCode.getSectionId();
				// 路段编码
				String sectionCode = String.valueOf(sectionMaxId);
				// 路段ID
				int sectionId = (int)sectionMaxId;
				String sectionName = sectionArrayList.get(i).get("sectionName").toString();
				String sectionsBpoints = sectionArrayList.get(i).get("sectionsBpoints").toString();
				String sectionsWJPpoints = sectionArrayList.get(i).get("sectionsWJPpoints").toString();
				// WGS坐标点集合
				String gsectionVector = null;
				if(!sectionsWJPpoints.equals(""))
					gsectionVector = "LINESTRING(" + sectionsWJPpoints +")";
				// 原坐标点集合
				String bsectionVectorS = null;
				if(!sectionsBpoints.equals(""))
					 bsectionVectorS = "LINESTRING(" + sectionsBpoints + ")";				
				repository.systemSave(sectionCode, sectionName, crosesRoad, endNode, startNode, middleNode, gsectionVector, bsectionVectorS, sectionType, csectionVector, roadCoding, sectionDistance, sectionTime, dbType, speedLimit, descriptions, 1, sectionId);
				SectionRoute route = new SectionRoute();
				Line line = lineRepository.findOne(sectionRouteLine);
				Section section = repository.findOne(sectionId);
				route.setSectionrouteCode(sectionrouteCode+i*100);
				route.setLineCode(lineCode);
				route.setSectionCode(sectionCode);
				route.setDirections(directions);
				route.setVersions(versions);
				route.setDestroy(destroy);
				route.setDescriptions(descriptions);
				route.setCreateBy(createBy);
				route.setUpdateBy(updateBy);
				route.setLine(line);
				route.setSection(section);
				route.setIsRoadeSpeed(isRoadeSpeed);
				routeRepository.save(route);
			}
			// 删除缓存路段
			routeCacheRepository.sectionRouteCacheDel(lineCode,directions);
			// 撤销原有站点路由
			stationRouteRepository.stationRouteUpdDestroy(sectionRouteLine,directions);
			// 站点保存
			List<StationRouteCache> stationRouteList = stationRouteCacheRepository.findstationRoute(sectionRouteLine,directions);			
			for(int i=0; i < stationRouteList.size(); i++) {
				StationRouteCache stationRouteCache = stationRouteList.get(i);				
				StationRoute stationRoute = new StationRoute();
				stationRoute.setLine(stationRouteCache.getLine());
				stationRoute.setStation(stationRouteCache.getStation());
				stationRoute.setStationName(stationRouteCache.getStationName());
				stationRoute.setStationRouteCode(stationRouteCache.getStationRouteCode());
				stationRoute.setLineCode(stationRouteCache.getLineCode());
				stationRoute.setStationCode(stationRouteCache.getStationCode());
				stationRoute.setStationMark(stationRouteCache.getStationMark());
				stationRoute.setOutStationNmber(stationRouteCache.getOutStationNmber());
				stationRoute.setDirections(stationRouteCache.getDirections());
				stationRoute.setDistances(stationRouteCache.getDistances());
				stationRoute.setToTime(stationRouteCache.getToTime());
				stationRoute.setFirstTime(stationRouteCache.getFirstTime());
				stationRoute.setEndTime(stationRouteCache.getEndTime());
				stationRoute.setDescriptions(stationRouteCache.getDescriptions());
				stationRoute.setDestroy(stationRouteCache.getDestroy());
				stationRoute.setVersions(versions);
				stationRoute.setCreateBy(stationRouteCache.getCreateBy());
				stationRoute.setCreateDate(stationRouteCache.getCreateDate());
				stationRoute.setUpdateBy(stationRouteCache.getCreateBy());
				stationRoute.setUpdateDate(stationRouteCache.getUpdateDate());
				stationRouteRepository.save(stationRoute);
			}
			// 删除缓存站点
			stationRouteCacheRepository.stationRouteCacheDel(lineCode,directions);
			
			resultMap.put("status", ResponseCode.SUCCESS);			
		} catch (Exception e) {
			resultMap.put("status", ResponseCode.ERROR);
			logger.error("save erro.", e);
		}
		return resultMap;
	}
	
	/**
	 * @Description :TODO(编辑线路走向保存到线路历史表)
	 * 
	 * @param map <sectionId:路段ID； sectionJSON：路段信息>
	 * 
	 * @return Map<String, Object> <SUCCESS ; ERROR>
	 */
	@Override
	@Transactional
	public Map<String, Object> sectionCutSaveLineLS(Map<String, Object> map) {
		Map<String, Object> resultMap = new HashMap<String, Object>();
		try {
			// 路段点List
			List<Point> bPointsList = new ArrayList<>();
			// 截取后的路段
			List<Map<String, String>> sectionArrayList = new ArrayList<>();
			String bsectionVector = map.get("sectionBsectionVector").equals("") ? "" :map.get("sectionBsectionVector").toString();
			String bsectionVectorCutList = map.get("cutSectionList").equals("") ? "" :map.get("cutSectionList").toString();
			sectionListCut(bPointsList, sectionArrayList, bsectionVector, bsectionVectorCutList);			
			
			// 原坐标类型
			String dbType = map.get("sectiondbType").equals("") ? "" : map.get("sectiondbType").toString();
			// 说明
			String descriptions = map.get("descriptions").equals("") ? "" : map.get("descriptions").toString();
			// 是否撤销
			Integer destroy = map.get("destroy").equals("") ? null : Integer.parseInt(map.get("destroy").toString());
			// 方向
			Integer directions = map.get("sectionrouteDirections").equals("") ? null : Integer.parseInt(map.get("sectionrouteDirections").toString());
			// 线路ID
			Integer sectionRouteLine = map.get("sectionrouteLine").equals("") ? null : Integer.parseInt(map.get("sectionrouteLine").toString());
			// 道路编码
			String roadCoding = map.get("sectionRoadCoding").equals("") ? "" : map.get("sectionRoadCoding").toString();
			// 路段长度
			Double sectionDistance = 0.0;
			// 线路编码
			String lineCode =map.get("sectionrouteLineCode").equals("") ? "" : map.get("sectionrouteLineCode").toString();
			// 路段时长
			Double  sectionTime = 0.0;
			// 路段路由
			Integer sectionrouteCode = map.get("sectionrouteCode").equals("") ? null : Integer.valueOf(map.get("sectionrouteCode").toString());
			// 限速
			Double speedLimit = map.get("sectionSpeedLimet").equals("") ? null : Double.valueOf(map.get("sectionSpeedLimet").toString());
			// 版本
			Integer versions = map.get("versions").equals("") ? null : Integer.valueOf(map.get("versions").toString());
			
			Integer createBy = map.get("createBy").equals("") ? null : Integer.valueOf(map.get("createBy").toString());
			Integer updateBy = map.get("updateBy").equals("") ?null : Integer.valueOf(map.get("updateBy").toString());
			Integer isRoadeSpeed = map.get("isRoadeSpeed").equals("") ? null : Integer.valueOf(map.get("isRoadeSpeed").toString());
			String crosesRoad="";
			String endNode="";
			String startNode="";
			String middleNode="";
			String sectionType="";
			String csectionVector="";	
			// 删除原有历史版本路段路由
			lsRouteRepository.batchDelete(sectionRouteLine,directions,versions);
			// 路段保存
			for (int i = 0; i < sectionArrayList.size(); i++) {
				long sectionMaxId = GetUIDAndCode.getSectionId();
				// 路段编码
				String sectionCode = String.valueOf(sectionMaxId);
				// 路段ID
				int sectionId = (int)sectionMaxId;
				String sectionName = sectionArrayList.get(i).get("sectionName").toString();
				String sectionsBpoints = sectionArrayList.get(i).get("sectionsBpoints").toString();
				String sectionsWJPpoints = sectionArrayList.get(i).get("sectionsWJPpoints").toString();
				// WGS坐标点集合
				String gsectionVector = null;
				if(!sectionsWJPpoints.equals(""))
					gsectionVector = "LINESTRING(" + sectionsWJPpoints +")";
				// 原坐标点集合
				String bsectionVectorS = null;
				if(!sectionsBpoints.equals(""))
					bsectionVectorS = "LINESTRING(" + sectionsBpoints + ")";				
				repository.systemSave(sectionCode, sectionName, crosesRoad, endNode, startNode, middleNode, gsectionVector, bsectionVectorS, sectionType, csectionVector, roadCoding, sectionDistance, sectionTime, dbType, speedLimit, descriptions, 1, sectionId);
				LsSectionRoute route = new LsSectionRoute();
				Line line = lineRepository.findOne(sectionRouteLine);
				Section section = repository.findOne(sectionId);
				route.setSectionrouteCode(sectionrouteCode+i*100);
				route.setLineCode(lineCode);
				route.setSectionCode(sectionCode);
				route.setDirections(directions);
				route.setVersions(versions);
				route.setDestroy(destroy);
				route.setDescriptions(descriptions);
				route.setCreateBy(createBy);
				route.setUpdateBy(updateBy);
				route.setLine(line);
				route.setSection(section);
				route.setIsRoadeSpeed(isRoadeSpeed);
				lsRouteRepository.save(route);
			}
			// 删除缓存路段
			routeCacheRepository.sectionRouteCacheDel(lineCode,directions);
			// 删除原有历史表站点路由
			lsStationRouteRepository.batchDelete(sectionRouteLine,directions,versions);
			// 站点保存
			List<StationRouteCache> stationRouteList = stationRouteCacheRepository.findstationRoute(sectionRouteLine,directions);			
			for(int i=0; i < stationRouteList.size(); i++) {
				StationRouteCache stationRouteCache = stationRouteList.get(i);				
				LsStationRoute stationRoute = new LsStationRoute();
				stationRoute.setLine(stationRouteCache.getLine());
				stationRoute.setStation(stationRouteCache.getStation());
				stationRoute.setStationName(stationRouteCache.getStationName());
				stationRoute.setStationRouteCode(stationRouteCache.getStationRouteCode());
				stationRoute.setLineCode(stationRouteCache.getLineCode());
				stationRoute.setStationCode(stationRouteCache.getStationCode());
				stationRoute.setStationMark(stationRouteCache.getStationMark());
				stationRoute.setOutStationNmber(stationRouteCache.getOutStationNmber());
				stationRoute.setDirections(stationRouteCache.getDirections());
				stationRoute.setDistances(stationRouteCache.getDistances());
				stationRoute.setToTime(stationRouteCache.getToTime());
				stationRoute.setFirstTime(stationRouteCache.getFirstTime());
				stationRoute.setEndTime(stationRouteCache.getEndTime());
				stationRoute.setDescriptions(stationRouteCache.getDescriptions());
				stationRoute.setDestroy(stationRouteCache.getDestroy());
				stationRoute.setVersions(versions);
				stationRoute.setCreateBy(stationRouteCache.getCreateBy());
				stationRoute.setCreateDate(stationRouteCache.getCreateDate());
				stationRoute.setUpdateBy(stationRouteCache.getCreateBy());
				stationRoute.setUpdateDate(stationRouteCache.getUpdateDate());
				lsStationRouteRepository.save(stationRoute);
			}
			// 删除缓存站点
			stationRouteCacheRepository.stationRouteCacheDel(lineCode,directions);
			resultMap.put("status", ResponseCode.SUCCESS);			
		} catch (Exception e) {
			resultMap.put("status", ResponseCode.ERROR);
			logger.error("save erro.", e);
		}
		return resultMap;
	}

	private void sectionListCut(List<Point> bPointsList, List<Map<String, String>> sectionArrayList,
			String bsectionVector, String bsectionVectorCutList) {
		if(!bsectionVector.equals("")) {
			// 转换成JSON数组
			JSONArray sectionsArray = JSONArray.parseArray(bsectionVector);
			// 遍历
			for(int s = 0 ;s<sectionsArray.size();s++) {
				String pointsLngStr = sectionsArray.getJSONObject(s).get("lng").toString();
				String pointsLatStr = sectionsArray.getJSONObject(s).get("lat").toString();
				bPointsList.add(new Point(Double.parseDouble(pointsLngStr), Double.parseDouble(pointsLatStr)));
			}
		}
		if(!bsectionVectorCutList.equals("")) {
			// 转换成JSON数组
			JSONArray sectionsArrayList = JSONArray.parseArray(bsectionVectorCutList);
			// 截取路段在总路段中的下表
			int firstTemp = 0;
			int lastTemp = 0;
			// 每个截取的路段去总路段中获取
			for (int i = 0; i < sectionsArrayList.size(); i++) {
				// 切点列表
				JSONObject sectionsArray = sectionsArrayList.getJSONObject(i);
				String sectionName = sectionsArray.get("name").toString();
				JSONArray sectionPoints = sectionsArray.getJSONArray("section");
				// 用两个坐标点去截取总路段
				if (i == 0) {
					for(int s = 0 ;s<sectionPoints.size();s++) {
						String bpointsLngStr = sectionPoints.getJSONObject(s).get("lng").toString();
						String bpointsLatStr = sectionPoints.getJSONObject(s).get("lat").toString();
						Point bPointcut = new Point(Double.parseDouble(bpointsLngStr), Double.parseDouble(bpointsLatStr));
						double distance = 0;
						// 寻找最近点
						for (int index = firstTemp; index < bPointsList.size(); index++) {
							if (index == firstTemp) {
								distance = GeoUtils.getDistance(bPointcut,bPointsList.get(index));
							} else {
								double distanceTemp = GeoUtils.getDistance(bPointcut,bPointsList.get(index));
								if(distance > distanceTemp) {
									distance = distanceTemp;
									lastTemp = index;
								}					
							}
						}	
						if (s == 0) {
							// 第一个点作为路段的起点
							firstTemp = lastTemp;
						}
						// 用切点替换最近点
						if(lastTemp == firstTemp) {
							bPointsList.add(++lastTemp, bPointcut);
						} else {
							bPointsList.set(lastTemp, bPointcut);	
						}						
					}
				} else {
					String bpointsLngStr = sectionPoints.getJSONObject(1).get("lng").toString();
					String bpointsLatStr = sectionPoints.getJSONObject(1).get("lat").toString();
					Point bPointcut = new Point(Double.parseDouble(bpointsLngStr), Double.parseDouble(bpointsLatStr));
					double distance = 0;
					// 寻找最近点
					for (int index = firstTemp; index < bPointsList.size(); index++) {
						if (index == firstTemp) {
							distance = GeoUtils.getDistance(bPointcut,bPointsList.get(index));
						} else {
							double distanceTemp = GeoUtils.getDistance(bPointcut,bPointsList.get(index));
							if(distance > distanceTemp) {
								distance = distanceTemp;
								lastTemp = index;
							}					
						}
					}
					// 用切点替换最近点
					if(lastTemp == firstTemp) {
						bPointsList.add(++lastTemp, bPointcut);
					} else {
						bPointsList.set(lastTemp, bPointcut);	
					}
				}
				// 切路段
				if (sectionName != "" && sectionName != null ) {
					// 原始线状图形坐标集合
					String sectionsBpoints = "";
					// WGS线状图形坐标集合
					String sectionsWJPpoints = "";		
					for (int j = firstTemp; j <= lastTemp; j++) {
						Point point =  bPointsList.get(j);
						String pointsLngStr = String.valueOf(point.getLon());
						String pointsLatStr = String.valueOf(point.getLat());
						/** to WGS坐标 */
						Location resultPoint = FromBDPointToWGSPoint(pointsLngStr,pointsLatStr);
						String WGSLngStr = String.valueOf(resultPoint.getLng());
						String WGSLatStr = String.valueOf(resultPoint.getLat());
						if(j == firstTemp) {
							sectionsBpoints = pointsLngStr + " " + pointsLatStr;
							sectionsWJPpoints = WGSLngStr + " " + WGSLatStr;
						}else {
							sectionsBpoints = sectionsBpoints + "," +  pointsLngStr + " " + pointsLatStr;
							sectionsWJPpoints = sectionsWJPpoints + ","  +   WGSLngStr + " " + WGSLatStr;
						}
					}
					Map<String, String> sectionCutMap = new HashMap<String, String>();
					sectionCutMap.put("sectionName", sectionName);
					sectionCutMap.put("sectionsBpoints", sectionsBpoints);
					sectionCutMap.put("sectionsWJPpoints", sectionsWJPpoints);
					sectionArrayList.add(sectionCutMap);
				}
				// 上一个路段的终点作为下一个路段的起点
				firstTemp = lastTemp;	
			}		
		}
	}
	
	/**
	 * @Description :TODO(编辑线路走向)
	 * 
	 * @param map <sectionId:路段ID； sectionJSON：路段信息>
	 * 
	 * @return Map<String, Object> <SUCCESS ; ERROR>
	 */
	@Override
	public Map<String, Object> sectionUpdate(Map<String, Object> map) {
		Map<String, Object> resultMap = new HashMap<String, Object>();
		try {
			String bsectionVector = map.get("bsectionVector").equals("") ? "" :map.get("bsectionVector").toString();
			// 原始线状图形坐标集合
			String sectionsBpoints = "";
			// WGS线状图形坐标集合
			String sectionsWJPpoints = "";
			if(!bsectionVector.equals("")) {
				// 转换成JSON数组
				JSONArray sectionsArray = JSONArray.parseArray(bsectionVector);
				// 遍历
				for(int s = 0 ;s<sectionsArray.size();s++) {
					String pointsLngStr = sectionsArray.getJSONObject(s).get("lng").toString();
					String pointsLatStr = sectionsArray.getJSONObject(s).get("lat").toString();
					/** to WGS坐标 */
					Location resultPoint = FromBDPointToWGSPoint(pointsLngStr,pointsLatStr);
					String WGSLngStr = String.valueOf(resultPoint.getLng());
					String WGSLatStr = String.valueOf(resultPoint.getLat());
					if(s==0) {
						sectionsBpoints = pointsLngStr + " " + pointsLatStr;
						sectionsWJPpoints = WGSLngStr + " " + WGSLatStr;
					}else {
						sectionsBpoints = sectionsBpoints + "," +  pointsLngStr + " " + pointsLatStr;
						sectionsWJPpoints = sectionsWJPpoints + ","  +   WGSLngStr + " " + WGSLatStr;
					}
				}
			}
			// 原坐标类型
			String dbType = map.get("dbType").equals("") ? "" : map.get("dbType").toString();
			// 说明
			String descriptions = map.get("descriptions").equals("") ? "" : map.get("descriptions").toString();
			// 是否撤销
			Integer destroy = map.get("destroy").equals("") ? null : Integer.parseInt(map.get("destroy").toString());
			// 方向
			Integer directions = map.get("directions").equals("") ? null : Integer.parseInt(map.get("directions").toString());
			// 线路ID
			Integer sectionRouteLine = map.get("sectionRouteLine").equals("") ? null : Integer.parseInt(map.get("sectionRouteLine").toString());
			// 道路编码
			String roadCoding = map.get("roadCoding").equals("") ? "" : map.get("roadCoding").toString();
			// 路段编码
			String sectionCode = map.get("sectionCode").equals("") ? "" : map.get("sectionCode").toString();
			// 路段长度
			Double sectionDistance = map.get("sectionDistance").equals("") ? null : Double.valueOf(map.get("sectionDistance").toString());
			// 路段ID
			Integer sectionId = map.get("sectionId").equals("") ? 0 : Integer.parseInt(map.get("sectionId").toString());
			// 路段名称
			String sectionName = map.get("sectionName").equals("") ? "" : map.get("sectionName").toString();
			// 路段路由Id
			Integer sectionRouteId = map.get("sectionRouteId").equals("") ? null : Integer.valueOf(map.get("sectionRouteId").toString());
			// 线路编码
			String lineCode =map.get("lineCode").equals("") ? "" : map.get("lineCode").toString();
			// 路段时长
			Double  sectionTime = map.get("sectionTime").equals("") ? null : Double.valueOf(map.get("sectionTime").toString());
			// 路段路由
			Integer sectionrouteCode = map.get("sectionrouteCode").equals("") ? null : Integer.valueOf(map.get("sectionrouteCode").toString());
			SectionRoute resultS = routeRepository.findOne(sectionRouteId);
			int old_code = resultS.getSectionrouteCode();
			if(sectionrouteCode!=null) {
				int new_code = sectionrouteCode+100;
				if(new_code==old_code){
					sectionrouteCode = new_code;
				}else {
					sectionrouteCode = new_code-100+1;
				}
			 }else {
				 sectionrouteCode = old_code;
			 }
			// 限速
			Double speedLimit = map.get("speedLimit").equals("") ? null : Double.valueOf(map.get("speedLimit").toString());
			// 版本
			Integer version = map.get("versions").equals("") ? null : Integer.valueOf(map.get("versions").toString());
			// WGS坐标点集合
			String gsectionVector = null;
			if(!sectionsWJPpoints.equals(""))
				gsectionVector = "LINESTRING(" + sectionsWJPpoints +")";
			// 原坐标点集合
			String bsectionVectorS = null;
			if(!sectionsBpoints.equals(""))
				 bsectionVectorS = "LINESTRING(" + sectionsBpoints + ")";
			Integer createBy = map.get("createBy").equals("") ? null : Integer.valueOf(map.get("createBy").toString());
			String createDate = map.get("createDate").equals("") ? null : map.get("createDate").toString();
			Integer updateBy = map.get("updateBy").equals("") ?null : Integer.valueOf(map.get("updateBy").toString());
			Integer isRoadeSpeed = map.get("isRoadeSpeed").equals("") ? null : Integer.valueOf(map.get("isRoadeSpeed").toString());
			SimpleDateFormat formatter = new SimpleDateFormat ("yyyy-MM-dd HH:mm:ss"); 
			Date date = new Date();
			// 修改日期
			String updateDate = formatter.format(date);
			String crosesRoad="";
			String endNode="";
			String startNode="";
			String middleNode="";
			String sectionType="";
			// 更新
			repository.sectionUpdate(sectionId, gsectionVector, bsectionVectorS, sectionCode, sectionName, crosesRoad, endNode, startNode, middleNode, sectionType, roadCoding, sectionDistance, sectionTime, dbType, speedLimit, descriptions, version, createBy, createDate, updateBy, updateDate);
			SectionRoute route = new SectionRoute();
			Line line = lineRepository.findOne(sectionRouteLine);
			Section section = repository.findOne(sectionId);
			route.setId(sectionRouteId);
			route.setSectionrouteCode(sectionrouteCode);
			route.setLineCode(lineCode);
			route.setSectionCode(sectionCode);
			route.setDirections(directions);
			route.setVersions(version);
			route.setDestroy(destroy);
			route.setDescriptions(descriptions);
			route.setCreateBy(createBy);
			route.setUpdateBy(updateBy);
			route.setLine(line);
			route.setSection(section);
			route.setIsRoadeSpeed(isRoadeSpeed);
			routeRepository.save(route);
			resultMap.put("status", ResponseCode.SUCCESS);
		} catch (Exception e) {
			resultMap.put("status", ResponseCode.ERROR);
			logger.error("save erro.", e);
		}
		return resultMap;
	}
	
	/**
	 * @Description :TODO(编辑缓存线路走向)
	 */
	@Override
	public Map<String, Object> sectionCacheUpdate(Map<String, Object> map) {
		Map<String, Object> resultMap = new HashMap<String, Object>();
		try {
			String bsectionVector = map.get("bsectionVector").equals("") ? "" :map.get("bsectionVector").toString();
			// 原始线状图形坐标集合
			String sectionsBpoints = "";
			// WGS线状图形坐标集合
			String sectionsWJPpoints = "";
			if(!bsectionVector.equals("")) {
				// 转换成JSON数组
				JSONArray sectionsArray = JSONArray.parseArray(bsectionVector);
				// 遍历
				for(int s = 0 ;s<sectionsArray.size();s++) {
					String pointsLngStr = sectionsArray.getJSONObject(s).get("lng").toString();
					String pointsLatStr = sectionsArray.getJSONObject(s).get("lat").toString();
					/** to WGS坐标 */
					Location resultPoint = FromBDPointToWGSPoint(pointsLngStr,pointsLatStr);
					String WGSLngStr = String.valueOf(resultPoint.getLng());
					String WGSLatStr = String.valueOf(resultPoint.getLat());
					if(s==0) {
						sectionsBpoints = pointsLngStr + " " + pointsLatStr;
						sectionsWJPpoints = WGSLngStr + " " + WGSLatStr;
					}else {
						sectionsBpoints = sectionsBpoints + "," +  pointsLngStr + " " + pointsLatStr;
						sectionsWJPpoints = sectionsWJPpoints + ","  +   WGSLngStr + " " + WGSLatStr;
					}
				}
			}
			// 原坐标类型
			String dbType = map.get("dbType").equals("") ? "" : map.get("dbType").toString();
			// 说明
			String descriptions = map.get("descriptions").equals("") ? "" : map.get("descriptions").toString();
			// 是否撤销
			Integer destroy = map.get("destroy").equals("") ? null : Integer.parseInt(map.get("destroy").toString());
			// 方向
			Integer directions = map.get("directions").equals("") ? null : Integer.parseInt(map.get("directions").toString());
			// 线路ID
			Integer sectionRouteLine = map.get("sectionRouteLine").equals("") ? null : Integer.parseInt(map.get("sectionRouteLine").toString());
			// 道路编码
			String roadCoding = map.get("roadCoding").equals("") ? "" : map.get("roadCoding").toString();
			// 路段编码
			String sectionCode = map.get("sectionCode").equals("") ? "" : map.get("sectionCode").toString();
			// 路段长度
			Double sectionDistance = map.get("sectionDistance").equals("") ? null : Double.valueOf(map.get("sectionDistance").toString());
			// 路段ID
			Integer sectionId = map.get("sectionId").equals("") ? 0 : Integer.parseInt(map.get("sectionId").toString());
			// 路段名称
			String sectionName = map.get("sectionName").equals("") ? "" : map.get("sectionName").toString();
			// 路段路由Id
			Integer sectionRouteId = map.get("sectionRouteId").equals("") ? null : Integer.valueOf(map.get("sectionRouteId").toString());
			// 线路编码
			String lineCode =map.get("lineCode").equals("") ? "" : map.get("lineCode").toString();
			// 路段时长
			Double  sectionTime = map.get("sectionTime").equals("") ? null : Double.valueOf(map.get("sectionTime").toString());
			// 路段路由
//			Integer sectionrouteCode = map.get("sectionrouteCode").equals("") ? null : Integer.valueOf(map.get("sectionrouteCode").toString());
			Integer sectionrouteCode = 100;
			SectionRouteCache resultS = routeCacheRepository.findOne(sectionRouteId);
			int old_code = resultS.getSectionrouteCode();
			if(sectionrouteCode!=null) {
				int new_code = sectionrouteCode+100;
				if(new_code==old_code){
					sectionrouteCode = new_code;
				}else {
					sectionrouteCode = new_code-100+1;
				}
			 }else {
				 sectionrouteCode = old_code;
			 }
			// 限速
			Double speedLimit = map.get("speedLimit").equals("") ? null : Double.valueOf(map.get("speedLimit").toString());
			// 版本
			Integer version = map.get("versions").equals("") ? null : Integer.valueOf(map.get("versions").toString());
			// WGS坐标点集合
			String gsectionVector = null;
			if(!sectionsWJPpoints.equals(""))
				gsectionVector = "LINESTRING(" + sectionsWJPpoints +")";
			// 原坐标点集合
			String bsectionVectorS = null;
			if(!sectionsBpoints.equals(""))
				 bsectionVectorS = "LINESTRING(" + sectionsBpoints + ")";
			Integer createBy = map.get("createBy").equals("") ? null : Integer.valueOf(map.get("createBy").toString());
			String createDate = map.get("createDate").equals("") ? null : map.get("createDate").toString();
			Integer updateBy = map.get("updateBy").equals("") ?null : Integer.valueOf(map.get("updateBy").toString());
			Integer isRoadeSpeed = map.get("isRoadeSpeed").equals("") ? null : Integer.valueOf(map.get("isRoadeSpeed").toString());
			SimpleDateFormat formatter = new SimpleDateFormat ("yyyy-MM-dd HH:mm:ss"); 
			Date date = new Date();
			// 修改日期
			String updateDate = formatter.format(date);
			String crosesRoad="";
			String endNode="";
			String startNode="";
			String middleNode="";
			String sectionType="";
			// 更新
			repository.sectionUpdate(sectionId, gsectionVector, bsectionVectorS, sectionCode, sectionName, crosesRoad, endNode, startNode, middleNode, sectionType, roadCoding, sectionDistance, sectionTime, dbType, speedLimit, descriptions, version, createBy, createDate, updateBy, updateDate);
			SectionRouteCache route = new SectionRouteCache();
			Line line = lineRepository.findOne(sectionRouteLine);
			Section section = repository.findOne(sectionId);
			route.setId(sectionRouteId);
			route.setSectionrouteCode(sectionrouteCode);
			route.setLineCode(lineCode);
			route.setSectionCode(sectionCode);
			route.setDirections(directions);
			route.setVersions(version);
			route.setDestroy(destroy);
			route.setDescriptions(descriptions);
			route.setCreateBy(createBy);
			route.setUpdateBy(updateBy);
			route.setLine(line);
			route.setSection(section);
			route.setIsRoadeSpeed(isRoadeSpeed);
			routeCacheRepository.save(route);
			resultMap.put("status", ResponseCode.SUCCESS);
		} catch (Exception e) {
			resultMap.put("status", ResponseCode.ERROR);
			logger.error("save erro.", e);
		}
		return resultMap;
	}
	
	/** 百度坐标转WGS坐标 */
	public Location FromBDPointToWGSPoint(String bLonx,String bLatx) {
		
		double lng = Double.parseDouble(bLonx);
		
		double lat = Double.parseDouble(bLatx);
		
		Location bdLoc = TransGPS.LocationMake(lng, lat);
		
		Location location = TransGPS.bd_decrypt(bdLoc);
		
		Location WGSPoint = TransGPS.transformFromGCJToWGS(location);
		
		return WGSPoint;
		
	}
	
	
	/**
	 * 新增路段信息
	 * 
	 * @param map：<bsectionVector：折线百度坐标集合；dbType：圆坐标类型；descriptions：描述与说明；destroy：是否撤销；directions：方向；lineId：线路ID
	 * 
	 * 			   lineCode ：线路编码；roadCoding：道路编码；sectionCode：路段编码；sectionDistance：路段长度；sectionName：路段名称；sectionTime：路段时长；
	 * 			
	 * 			   sectionrouteCode：路段序号；speedLimit：路段限速>
	 * 
	 * @return map<SUCCESS：成功；ERROR：异常>
	 */
	@Override
	@Transactional
	public Map<String, Object> sectionSave(Map<String, Object> map) {
		Map<String, Object> resultMap = new HashMap<String, Object>();
		try {
			// 线路ID.
			Integer lineId = map.get("lineId").equals("") ? null : Integer.valueOf(map.get("lineId").toString());
			// 线路编码.
			String lineCode = map.get("lineCode").equals("") ? "" : map.get("lineCode").toString();
			// 路段名称.
			String sectionName = map.get("sectionName").equals("") ? "" : map.get("sectionName").toString();
			// 路段编码.
			String sectionCode = map.get("sectionCode").equals("") ? "" : map.get("sectionCode").toString();
			// 道路编码.
			String roadCoding = map.get("roadCoding").equals("") ? "" : map.get("roadCoding").toString();
			// 原始坐标类型.
			String dbType = map.get("dbType").equals("") ? "" :map.get("dbType").toString();
			// 路段几何图形坐标.
			String sectionJSON = map.get("bsectionVector").equals("") ? "" : map.get("bsectionVector").toString();
			// 路段序号
			String sectionrouteCode = map.get("sectionrouteCode").equals("") ? "" : map.get("sectionrouteCode").toString();
			// 路段时长.
			Double sectionTime = map.get("sectionTime").equals("") ? 0.0d : Double.valueOf(map.get("sectionTime").toString());
			// 路段距离.
			Double sectionDistance = map.get("sectionDistance").equals("") ? 0.0d : Double.valueOf(map.get("sectionDistance").toString());
			// 路段限速.
			Double speedLimit = map.get("speedLimit").equals("") ? 0.0d : Double.valueOf(map.get("speedLimit").toString());
			// 版本.
			Integer versions = map.get("versions").equals("") ? 1 : Integer.valueOf(map.get("versions").toString());
			// 是否撤销.
			Integer destroy = map.get("destroy").equals("") ? 0 : Integer.valueOf(map.get("destroy").toString());
			// 路段方向.
			Integer directions = map.get("directions").equals("") ? 0 : Integer.valueOf(map.get("directions").toString());
			// 描述与说明.
			String descriptions = map.get("descriptions").equals("")? "" : map.get("descriptions").toString();
			// 原始线状图形坐标集合
			String sectionsBpoints = "";
			// WGS线状图形坐标集合
			String sectionsWJPpoints = "";
			if(!sectionJSON.equals("")) {
				// 转换成JSON数组
				JSONArray sectionsArray = JSONArray.parseArray(sectionJSON);
				// 遍历
				for(int s = 0 ;s<sectionsArray.size();s++) {
					String pointsLngStr = sectionsArray.getJSONObject(s).get("lng").toString();
					String pointsLatStr = sectionsArray.getJSONObject(s).get("lat").toString();
					String WGSLngStr = "";
					String WGSLatStr = "";
					Location resultPoint = FromBDPointToWGSPoint(pointsLngStr,pointsLatStr);
					WGSLngStr = String.valueOf(resultPoint.getLng());
					WGSLatStr = String.valueOf(resultPoint.getLat());			
					if(s==0) {
						sectionsBpoints = pointsLngStr + " " + pointsLatStr;
						sectionsWJPpoints = WGSLngStr + " " + WGSLatStr;
					}else {
						sectionsBpoints = sectionsBpoints + "," +  pointsLngStr + " " + pointsLatStr;
						sectionsWJPpoints = sectionsWJPpoints + ","  +   WGSLngStr + " " + WGSLatStr;
					}
				}
			}
			// WGS坐标点集合
			String gsectionVector = "LINESTRING(" + sectionsWJPpoints +")";
			// 原坐标点集合
			String bsectionVector = "LINESTRING(" + sectionsBpoints + ")";
			String crosesRoad="";
			String endNode ="";
			String startNode="";
			String middleNode="";
			String sectionType="";
			String csectionVector=null;
			Integer id = Integer.valueOf(sectionCode);
			repository.systemSave(sectionCode, sectionName, crosesRoad, endNode, startNode, middleNode, gsectionVector, bsectionVector, sectionType, csectionVector, roadCoding, sectionDistance, sectionTime, dbType, speedLimit, descriptions, versions, id);
			Section section = repository.findOne(id);
			Line line = lineRepository.findOne(lineId);
			// 路段路由
			SectionRoute sectionRoute = new SectionRoute();
			Integer routeCode = null;
			if(!sectionrouteCode.equals("")){
				String sectionrouteCodeArray[] =  sectionrouteCode.split("_");
				routeCode = Integer.valueOf(sectionrouteCodeArray[0])+1;
			}else {
				routeCode = 100;
			}	
			routeRepository.sectionUpdSectionRouteCode(lineId, directions,routeCode);
			sectionRoute.setSectionrouteCode(routeCode);
			sectionRoute.setLineCode(lineCode);
			sectionRoute.setSection(section);
			sectionRoute.setSectionCode(sectionCode);
			sectionRoute.setDirections(directions);
			sectionRoute.setDescriptions(descriptions);
			sectionRoute.setDestroy(destroy);
			sectionRoute.setVersions(versions);
			sectionRoute.setLine(line);
			sectionRoute.setIsRoadeSpeed(0);
			routeRepository.save(sectionRoute);
			resultMap.put("status", ResponseCode.SUCCESS);
		} catch (Exception e) {
			resultMap.put("status", ResponseCode.ERROR);
			logger.error("save erro.", e);
		}
		return resultMap;
	}
}