Ejemplo n.º 1
0
 @Override
 @CacheEvict(value = "objectPermanent", allEntries = true)
 public void cloneObjectListToLayer(
     List<Long> objIdList, Long targetLayerId, GeoUser currentGeoUser) {
   List<GeoObject> originalObjects = listByIds(objIdList);
   for (GeoObject orig : originalObjects) {
     GeoObject obj = orig.clone();
     obj.setId(null);
     HashSet<GeoObjectTag> objectTags = new HashSet<GeoObjectTag>();
     for (GeoObjectTag prop : orig.getTags()) {
       GeoObjectTag tag = new GeoObjectTag();
       tag.setKey(prop.getKey());
       tag.setValue(prop.getValue());
       tag.setGeoObject(obj);
       objectTags.add(tag);
     }
     obj.setTags(objectTags);
     obj.setCreatedBy(currentGeoUser);
     obj.setCreated(Calendar.getInstance().getTime());
     getCurrentSession()
         .createSQLQuery(
             "INSERT INTO geo_layer_to_object (layer_id, object_id) VALUES(:lId, :oId)")
         .setLong("oId", add(obj).getId())
         .setLong("lId", targetLayerId)
         .executeUpdate();
   }
 }
Ejemplo n.º 2
0
 @SuppressWarnings("unchecked")
 @Override
 public List<GeoObject> listByIdsNotManaged(List<Long> objIdList) {
   String sql = getResourceSQL("GeoObjectDao.listByIdsNotManaged");
   List<Object[]> rows =
       getCurrentSession()
           .createSQLQuery(sql.toString())
           .addScalar("id", StandardBasicTypes.LONG)
           .addScalar("name", StandardBasicTypes.STRING)
           .addScalar("created_by", StandardBasicTypes.LONG)
           .addScalar("changed_by", StandardBasicTypes.LONG)
           .addScalar("created", StandardBasicTypes.DATE)
           .addScalar("changed", StandardBasicTypes.DATE)
           .addScalar("fias_code", StandardBasicTypes.STRING)
           .addScalar("the_geom", GeometryUserType.TYPE)
           .addScalar("version", StandardBasicTypes.INTEGER)
           .setParameterList("ids", objIdList)
           .list();
   if (rows != null && rows.size() > 0) {
     GeoObject[] objects = new GeoObject[rows.size()];
     for (int j = 0; j < rows.size(); j++) {
       GeoObject obj = new GeoObject();
       Object[] row = rows.get(j);
       obj.setId((Long) row[0]);
       obj.setVersion((Integer) row[8]);
       Geometry geom = (Geometry) row[7];
       obj.setTheGeom(geom);
       obj.setName((String) row[1]);
       obj.setChanged((Date) row[5]);
       obj.setCreated((Date) row[4]);
       obj.setFiasCode((String) row[6]);
       objects[j] = obj;
     }
     return Arrays.asList(objects);
   }
   return new ArrayList<GeoObject>();
 }