/* * eGov suite of products aim to improve the internal efficiency,transparency, * accountability and the service delivery of the government organizations. * * Copyright (C) <2015> eGovernments Foundation * * The updated version of eGov suite of products as by eGovernments Foundation * is available at http://www.egovernments.org * * This program is free software: you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation, either version 3 of the License, or * any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. * * You should have received a copy of the GNU General Public License * along with this program. If not, see http://www.gnu.org/licenses/ or * http://www.gnu.org/licenses/gpl.html . * * In addition to the terms of the GPL license to be adhered to in using this * program, the following additional terms are to be complied with: * * 1) All versions of this program, verbatim or modified must carry this * Legal Notice. * * 2) Any misrepresentation of the origin of the material is prohibited. It * is required that all modified versions of this material be marked in * reasonable ways as different from the original version. * * 3) This license does not grant any rights to any user of the program * with regards to rights under trademark law for use of the trade names * or trademarks of eGovernments Foundation. * * In case of any queries, you can reach eGovernments Foundation at contact@egovernments.org. */ package org.egov.infra.admin.master.service; import com.vividsolutions.jts.geom.Coordinate; import com.vividsolutions.jts.geom.Geometry; import com.vividsolutions.jts.geom.Point; import org.egov.infra.admin.master.entity.Boundary; import org.egov.infra.admin.master.entity.BoundaryType; import org.egov.infra.admin.master.entity.HierarchyType; import org.egov.infra.admin.master.repository.BoundaryRepository; import org.egov.infra.config.core.ApplicationThreadLocals; import org.egov.infra.exception.ApplicationRuntimeException; import org.egov.infra.utils.StringUtils; import org.geotools.data.DataStore; import org.geotools.data.DataStoreFinder; import org.geotools.feature.FeatureCollection; import org.geotools.geometry.jts.JTSFactoryFinder; import org.opengis.feature.simple.SimpleFeature; import org.opengis.feature.simple.SimpleFeatureType; import org.slf4j.Logger; import org.slf4j.LoggerFactory; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import java.net.URL; import java.util.ArrayList; import java.util.Date; import java.util.HashMap; import java.util.Iterator; import java.util.List; import java.util.Map; import java.util.Optional; import java.util.Set; @Service @Transactional(readOnly = true) public class BoundaryService { private static final Logger LOG = LoggerFactory.getLogger(BoundaryService.class); private final BoundaryRepository boundaryRepository; @Autowired private CrossHierarchyService crossHierarchyService; @Autowired private BoundaryTypeService boundaryTypeService; @Autowired public BoundaryService(final BoundaryRepository boundaryRepository) { this.boundaryRepository = boundaryRepository; } @Transactional public Boundary createBoundary(final Boundary boundary) { boundary.setHistory(false); boundary.setMaterializedPath(getMaterializedPath(null, boundary.getParent())); return boundaryRepository.save(boundary); } @Transactional public void updateBoundary(final Boundary boundary) { boundary.setHistory(false); boundary.setMaterializedPath(getMaterializedPath(boundary, boundary.getParent())); boundaryRepository.save(boundary); } public Boundary getBoundaryById(final Long id) { return boundaryRepository.findOne(id); } public List<Boundary> getAllBoundariesOrderByBoundaryNumAsc(BoundaryType boundaryType) { return boundaryRepository.findByBoundaryTypeOrderByBoundaryNumAsc(boundaryType); } public List<Boundary> getAllBoundariesByBoundaryTypeId(final Long boundaryTypeId) { return boundaryRepository.findBoundariesByBoundaryType(boundaryTypeId); } public List<Boundary> getPageOfBoundaries(final Long boundaryTypeId) { return boundaryRepository.findBoundariesByBoundaryType(boundaryTypeId); } public Boundary getBoundaryByTypeAndNo(final BoundaryType boundaryType, final Long boundaryNum) { return boundaryRepository.findBoundarieByBoundaryTypeAndBoundaryNum(boundaryType, boundaryNum); } public List<Boundary> getParentBoundariesByBoundaryId(final Long boundaryId) { List<Boundary> boundaryList = new ArrayList<>(); final Boundary bndry = getBoundaryById(boundaryId); if (bndry != null) { boundaryList.add(bndry); if (bndry.getParent() != null) boundaryList = getParentBoundariesByBoundaryId(bndry.getParent().getId()); } return boundaryList; } public List<Boundary> getActiveBoundariesByBoundaryTypeId(final Long boundaryTypeId) { return boundaryRepository.findActiveBoundariesByBoundaryTypeId(boundaryTypeId); } public List<Boundary> getTopLevelBoundaryByHierarchyType(final HierarchyType hierarchyType) { return boundaryRepository.findActiveBoundariesByHierarchyTypeAndLevelAndAsOnDate(hierarchyType, 1l, new Date()); } public List<Boundary> getActiveChildBoundariesByBoundaryId(final Long boundaryId) { return boundaryRepository.findActiveChildBoundariesByBoundaryIdAndAsOnDate(boundaryId, new Date()); } public List<Boundary> getChildBoundariesByBoundaryId(final Long boundaryId) { return boundaryRepository.findChildBoundariesByBoundaryIdAndAsOnDate(boundaryId, new Date()); } public Boundary getActiveBoundaryByBndryNumAndTypeAndHierarchyTypeCode(final Long bndryNum, final String boundaryType, final String hierarchyTypeCode) { return boundaryRepository.findActiveBoundaryByBndryNumAndTypeAndHierarchyTypeCodeAndAsOnDate(bndryNum, boundaryType, hierarchyTypeCode, new Date()); } public List<Boundary> getActiveBoundariesByBndryTypeNameAndHierarchyTypeName(final String boundaryTypeName, final String hierarchyTypeName) { return boundaryRepository.findActiveBoundariesByBndryTypeNameAndHierarchyTypeName(boundaryTypeName, hierarchyTypeName); } public List<Boundary> getBoundariesByBndryTypeNameAndHierarchyTypeName(final String boundaryTypeName, final String hierarchyTypeName) { return boundaryRepository.findBoundariesByBndryTypeNameAndHierarchyTypeName(boundaryTypeName, hierarchyTypeName); } public Boundary getBoundaryByBndryTypeNameAndHierarchyTypeName(final String boundaryTypeName, final String hierarchyTypeName) { return boundaryRepository.findBoundaryByBndryTypeNameAndHierarchyTypeName(boundaryTypeName, hierarchyTypeName); } public List<Boundary> getBondariesByNameAndTypeOrderByBoundaryNumAsc(final String boundaryName, final Long boundaryTypeId) { return boundaryRepository.findByNameAndBoundaryTypeOrderByBoundaryNumAsc(boundaryName, boundaryTypeId); } public Boolean validateBoundary(final BoundaryType boundaryType) { return Optional.ofNullable(boundaryRepository.findByBoundaryTypeNameAndHierarchyTypeNameAndLevel( boundaryType.getName(), boundaryType.getHierarchyType().getName(), 1L)).isPresent(); } public List<Boundary> getBondariesByNameAndBndryTypeAndHierarchyType(final String boundaryTypeName, final String hierarchyTypeName, final String name) { return boundaryRepository.findActiveBoundariesByNameAndBndryTypeNameAndHierarchyTypeName(boundaryTypeName, hierarchyTypeName, name); } public List<Map<String, Object>> getBoundaryDataByNameLike(final String name) { final List<Map<String, Object>> list = new ArrayList<>(); crossHierarchyService.getChildBoundaryNameAndBndryTypeAndHierarchyType("Locality", "Location", "Administration", '%' + name + '%').stream().forEach(location -> { final Map<String, Object> res = new HashMap<>(); res.put("id", location.getId()); res.put("name", location.getChild().getName() + " - " + location.getParent().getName()); list.add(res); }); return list; } public List<Boundary> findActiveChildrenWithParent(final Long parentBoundaryId) { return boundaryRepository.findActiveChildrenWithParent(parentBoundaryId); } public List<Boundary> findActiveBoundariesForMpath(final Set<String> mpath) { return boundaryRepository.findActiveBoundariesForMpath(mpath); } public String getMaterializedPath(final Boundary child, final Boundary parent) { String mpath = ""; int childSize = 0; if (null == parent) mpath = String.valueOf(boundaryRepository.findAllParents().size() + 1); else childSize = boundaryRepository.findActiveImmediateChildrenWithOutParent(parent.getId()).size(); if (mpath.isEmpty()) if (null != child) { if (parent != null && !child.getMaterializedPath().equalsIgnoreCase(parent.getMaterializedPath() + "." + childSize)) { childSize += 1; mpath = parent.getMaterializedPath() + "." + childSize; } else mpath = child.getMaterializedPath(); } else if (parent != null) { childSize += 1; mpath = parent.getMaterializedPath() + "." + childSize; } return mpath; } public Long getBoundaryIdFromShapefile(final Double latitude, final Double longitude) { Optional<Boundary> boundary = getBoundary(latitude, longitude); return boundary.isPresent() ? boundary.get().getId() : 0; } public Optional<Boundary> getBoundary(final Double latitude, final Double longitude) { try { if (latitude != null && longitude != null) { final Map<String, URL> map = new HashMap<>(); map.put("url", Thread.currentThread().getContextClassLoader() .getResource("gis/" + ApplicationThreadLocals.getTenantID() + "/wards.shp")); final DataStore dataStore = DataStoreFinder.getDataStore(map); final FeatureCollection<SimpleFeatureType, SimpleFeature> collection = dataStore .getFeatureSource(dataStore.getTypeNames()[0]).getFeatures(); final Iterator<SimpleFeature> iterator = collection.iterator(); final Point point = JTSFactoryFinder.getGeometryFactory(null) .createPoint(new Coordinate(longitude, latitude)); LOG.debug("Fetching boundary data for coordinates lng {}, lat {}", longitude, latitude); try { while (iterator.hasNext()) { final SimpleFeature feature = iterator.next(); final Geometry geom = (Geometry) feature.getDefaultGeometry(); if (geom.contains(point)) { LOG.debug("Found coordinates in shape file"); return getBoundaryByNumberAndType((Long) feature.getAttribute("bndrynum"), (String) feature.getAttribute("bndrytype")); } } } finally { collection.close(iterator); } } return Optional.empty(); } catch (final Exception e) { throw new ApplicationRuntimeException("Error occurred while fetching boundary from GIS data", e); } } public Optional<Boundary> getBoundaryByNumberAndType(Long boundaryNum, String boundaryTypeName) { if (boundaryNum != null && StringUtils.isNotBlank(boundaryTypeName)) { final BoundaryType boundaryType = boundaryTypeService .getBoundaryTypeByNameAndHierarchyTypeName(boundaryTypeName, "ADMINISTRATION"); final Boundary boundary = this.getBoundaryByTypeAndNo(boundaryType, boundaryNum); if (boundary == null) { final BoundaryType cityBoundaryType = boundaryTypeService .getBoundaryTypeByNameAndHierarchyTypeName("City", "ADMINISTRATION"); return Optional.ofNullable(this.getAllBoundariesByBoundaryTypeId(cityBoundaryType.getId()).get(0)); } return Optional.of(boundary); } return Optional.empty(); } }