Mercurial > dive4elements > river
view flys-backend/src/main/java/de/intevation/flys/model/BedHeightSingle.java @ 4198:1cdbd8a0c994
Added two new tables ClickableQDTable and ClickableWTable and made Ws and Qs clickable in historical discharge calculation.
The new tables define listener interfaces (clicked lower or upper icon) to listen to user clicks.
In addition to this, there is an enum ClickMode with NONE, SINGLE and RANGE options, which allows to
specifiy, which icons are displayed in the tables. NONE means no icon for user clicks, SINGLE has 1
icon, RANGE 2 icons for lower and upper.
author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
---|---|
date | Mon, 22 Oct 2012 13:31:25 +0200 |
parents | 5d8db3349b77 |
children |
line wrap: on
line source
package de.intevation.flys.model; import java.io.Serializable; import java.util.ArrayList; import java.util.List; import javax.persistence.Entity; import javax.persistence.Id; import javax.persistence.Table; import javax.persistence.GeneratedValue; import javax.persistence.Column; import javax.persistence.SequenceGenerator; import javax.persistence.GenerationType; import javax.persistence.JoinColumn; import javax.persistence.OneToOne; import javax.persistence.OneToMany; import org.hibernate.Session; import org.hibernate.Query; import de.intevation.flys.backend.SessionHolder; @Entity @Table(name = "bed_height_single") public class BedHeightSingle implements Serializable { private Integer id; private Integer year; private Integer soundingWidth; private String evaluationBy; private String description; private River river; private BedHeightType type; private LocationSystem locationSystem; private ElevationModel curElevationModel; private ElevationModel oldElevationModel; private Range range; private List<BedHeightSingleValue> values; public BedHeightSingle() { } public BedHeightSingle( River river, Integer year, Integer soundingWidth, BedHeightType type, LocationSystem locationSystem, ElevationModel curElevationModel, Range range ) { this( river, year, soundingWidth, type, locationSystem, curElevationModel, null, range, null, null); } public BedHeightSingle( River river, Integer year, Integer soundingWidth, BedHeightType type, LocationSystem locationSystem, ElevationModel curElevationModel, ElevationModel oldElevationModel, Range range, String evaluationBy, String description ) { this.river = river; this.year = year; this.soundingWidth = soundingWidth; this.type = type; this.locationSystem = locationSystem; this.curElevationModel = curElevationModel; this.oldElevationModel = oldElevationModel; this.range = range; this.evaluationBy = evaluationBy; this.description = description; } @Id @SequenceGenerator( name = "SEQUENCE_BED_HEIGHT_SINGLE_ID_SEQ", sequenceName = "BED_HEIGHT_SINGLE_ID_SEQ", allocationSize = 1) @GeneratedValue( strategy = GenerationType.SEQUENCE, generator = "SEQUENCE_BED_HEIGHT_SINGLE_ID_SEQ") @Column(name = "id") public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } @OneToOne @JoinColumn(name = "river_id" ) public River getRiver() { return river; } public void setRiver(River river) { this.river = river; } @Column(name = "year") public Integer getYear() { return year; } public void setYear(Integer year) { this.year = year; } @Column(name = "sounding_width") public Integer getSoundingWidth() { return soundingWidth; } public void setSoundingWidth(Integer soundingWidth) { this.soundingWidth = soundingWidth; } @OneToOne @JoinColumn(name = "type_id") public BedHeightType getType() { return type; } public void setType(BedHeightType type) { this.type = type; } @OneToOne @JoinColumn(name = "location_system_id") public LocationSystem getLocationSystem() { return locationSystem; } public void setLocationSystem(LocationSystem locationSystem) { this.locationSystem = locationSystem; } @OneToOne @JoinColumn(name = "cur_elevation_model_id") public ElevationModel getCurElevationModel() { return curElevationModel; } public void setCurElevationModel(ElevationModel curElevationModel) { this.curElevationModel = curElevationModel; } @OneToOne @JoinColumn(name = "old_elevation_model_id") public ElevationModel getOldElevationModel() { return oldElevationModel; } public void setOldElevationModel(ElevationModel oldElevationModel) { this.oldElevationModel = oldElevationModel; } @OneToOne @JoinColumn(name = "range_id") public Range getRange() { return range; } public void setRange(Range range) { this.range = range; } @Column(name = "evaluation_by") public String getEvaluationBy() { return evaluationBy; } public void setEvaluationBy(String evaluationBy) { this.evaluationBy = evaluationBy; } @Column(name = "description") public String getDescription() { return description; } public void setDescription(String description) { this.description = description; } @OneToMany @JoinColumn(name = "bed_height_single_id") public List<BedHeightSingleValue> getValues() { return values; } public void setValues(List<BedHeightSingleValue> values) { this.values = values; } public static List<BedHeightSingle> getBedHeightSingles( River river, double kmLo, double kmHi ) { Session session = SessionHolder.HOLDER.get(); Query query = session.createQuery( "from BedHeightSingle where river=:river"); query.setParameter("river", river); // TODO Do km range filtering in SQL statement List<BedHeightSingle> singles = query.list(); List<BedHeightSingle> good = new ArrayList<BedHeightSingle>(); for (BedHeightSingle s: singles) { for (BedHeightSingleValue value: s.getValues()) { double station = value.getStation().doubleValue(); if (station >= kmLo && station <= kmHi) { good.add(s); break; } } } return good; } public static BedHeightSingle getBedHeightSingleById(int id) { Session session = SessionHolder.HOLDER.get(); Query query = session.createQuery( "from BedHeightSingle where id=:id"); query.setParameter("id", id); List<BedHeightSingle> singles = query.list(); return singles != null ? singles.get(0) : null; } } // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :