Exemplo n.º 1
0
 @SuppressWarnings("unchecked")
 @Override
 public List<GeoObject> listByLayerIdWithTags(Long layerId) {
   List<GeoObject> objs =
       (List<GeoObject>)
           getCurrentSession()
               .createQuery(
                   ("Select o from GeoLayer l inner join l.geoObjects o left join fetch o.geoObjectProperties p left join fetch o.createdBy cb left join fetch o.changedBy chb where l.id = :layerId"))
               .setLong("layerId", layerId)
               .list();
   if (objs.size() == 0) return objs;
   List<GeoObjectTag> tags =
       getCurrentSession()
           .createQuery(
               "SELECT t from GeoObjectTag t join t.geoObject o join o.geoLayers l where l.id = :layerId")
           .setLong("layerId", layerId)
           .list();
   for (GeoObject obj : objs) {
     HashSet<GeoObjectTag> fetchedTags = new HashSet<GeoObjectTag>();
     for (GeoObjectTag tag : tags) {
       if (tag.getGeoObject().getId() == obj.getId()) {
         fetchedTags.add(tag);
       }
     }
     obj.setTags(fetchedTags);
   }
   return objs;
 }
Exemplo n.º 2
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();
   }
 }
Exemplo n.º 3
0
  @SuppressWarnings("unchecked")
  @Override
  public List<GeoObject> listByLayerIdFromRevision(Long layerId, Long revId) {
    List<GeoObject> objs =
        (List<GeoObject>)
            getCurrentSession()
                .createSQLQuery(getResourceSQL("GeoObjectDao.listByLayerIdFromRevision"))
                .addEntity(GeoObject.class)
                .setLong("layerId", layerId)
                .setLong("revId", revId)
                .list();
    if (objs.size() == 0) return objs;

    List<GeoObjectTag> tags =
        getCurrentSession()
            .createQuery("from GeoObjectTag t where t.geoObject in :objs")
            .setParameterList("objs", objs)
            .list();
    for (GeoObject obj : objs) {
      HashSet<GeoObjectTag> fetchedTags = new HashSet<GeoObjectTag>();
      for (GeoObjectTag tag : tags) {
        if (tag.getGeoObject().getId() == obj.getId()) {
          fetchedTags.add(tag);
        }
      }
      obj.setTags(fetchedTags);
    }
    return objs;

    /*
    for(GeoObject obj : objs){
    	 List<GeoObjectTag> tags = getCurrentSession().createQuery("from GeoObjectTag t where t.geoObject = :obj").setEntity("obj", obj).list();
    	 obj.setTags(new HashSet<GeoObjectTag>(tags));
    }
    return objs;
    */
  }