--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/artifacts/src/main/java/org/dive4elements/river/artifacts/sinfo/flowdepth/FlowDepthCalculation.java	Thu Jan 18 18:34:41 2018 +0100
@@ -0,0 +1,152 @@
+/* Copyright (C) 2017 by Bundesanstalt für Gewässerkunde
+ * Software engineering by 
+ *  Björnsen Beratende Ingenieure GmbH 
+ *  Dr. Schumacher Ingenieurbüro für Wasser und Umwelt
+ *
+ * This file is Free Software under the GNU AGPL (>=v3)
+ * and comes with ABSOLUTELY NO WARRANTY! Check out the
+ * documentation coming with Dive4Elements River for details.
+ */
+package org.dive4elements.river.artifacts.sinfo.flowdepth;
+
+import java.util.Collection;
+import java.util.List;
+
+import org.dive4elements.artifacts.CallContext;
+import org.dive4elements.river.artifacts.BedHeightsArtifact;
+import org.dive4elements.river.artifacts.model.Calculation;
+import org.dive4elements.river.artifacts.model.CalculationResult;
+import org.dive4elements.river.artifacts.model.LocationProvider;
+import org.dive4elements.river.artifacts.model.WKms;
+import org.dive4elements.river.artifacts.resources.Resources;
+import org.dive4elements.river.artifacts.sinfo.SINFOArtifact;
+import org.dive4elements.river.artifacts.sinfo.flowdepth.FlowDepthAccess.DifferencesPair;
+import org.dive4elements.river.artifacts.states.WDifferencesState;
+import org.dive4elements.river.model.BedHeight;
+import org.dive4elements.river.model.Gauge;
+import org.dive4elements.river.model.River;
+import org.dive4elements.river.utils.GaugeIndex;
+import org.dive4elements.river.utils.RiverUtils;
+
+class FlowDepthCalculation {
+
+    private static final String CSV_NOT_IN_GAUGE_RANGE = "export.waterlevel.csv.not.in.gauge.range";
+
+	private CallContext context;
+
+	public FlowDepthCalculation( final CallContext context ) {
+		this.context = context;
+	}
+	
+    public CalculationResult calculate(final SINFOArtifact sinfo) {
+    	
+    	/* access input data */
+    	final FlowDepthAccess access = new FlowDepthAccess(sinfo);
+    	final River river = access.getRiver();
+    	
+    	final Collection<DifferencesPair> diffPairs = access.getDifferencePairs();
+    	
+		final double from = access.getFrom();
+		final double to = access.getTo();
+
+    	final boolean useTkh = access.isUseTransportBodies();
+
+    	/* calculate results for each diff pair */
+    	final Calculation problems = new Calculation();
+
+    	final List<Gauge> gauges = river.determineGauges(from, to);
+    	final GaugeIndex gaugeIndex = new GaugeIndex(gauges);
+
+    	final FlowDepthCalculationResults results = new FlowDepthCalculationResults(river, from, to, useTkh);
+
+    	for (final DifferencesPair diffPair : diffPairs) {
+    		final FlowDepthCalculationResult result = calculateResult( river, from, to, diffPair, problems, gaugeIndex );
+    		if( result != null )
+    			results.addResult(result);
+		}
+    	
+		return new CalculationResult(results,problems);
+    }
+
+	private FlowDepthCalculationResult calculateResult(final River river, final double from, final double to, final DifferencesPair diffPair, final Calculation problems, final GaugeIndex gaugeIndex) {
+
+		/* access real input data from database */
+    	final String soundingId = diffPair.getSoundingId();
+    	final String wstId = diffPair.getWstId();
+
+    	final BedHeight bedHeight = loadBedHeight( soundingId, from, to );
+		final WKms wstKms = new WDifferencesState().getWKms(wstId, context, from, to);
+		if( bedHeight == null || wstKms == null )
+			return null;
+
+    	final FlowDepthCalculationResult resultData = new FlowDepthCalculationResult(wstKms.getName(), bedHeight.getDescription());
+
+        final String notinrange = Resources.getMsg(context.getMeta(), CSV_NOT_IN_GAUGE_RANGE, CSV_NOT_IN_GAUGE_RANGE);
+
+    	// TODO: unklarheiten
+    	// 'idealerweise alle 100m' was heisst das? kann doch nur durch datenverfügbarkeit bestimmt werden
+    	// wie mit unterschiedlichen Ranges umgehen? Schnitt bilden? Fehlermeldung? ...?
+    	// wie interpolieren? wst interpolieren? peilung interpolieren?
+
+		// FIXME: für die Berechnung der TKH sind weitere 'in FLYS vorliegende' Daten notwendig.
+		// aktuell unklar ob das durch andere Barten berechnete Werte oder Basisdaten sind
+		// TODO: check Vergleiche BArt 'Transportkörperhöhen'
+        
+    	// TODO: Berechnung der Transportkörperhöhen
+    	// - woher kommen die zusätzlichen eingangsdaten? sind das fixe daten pro gewässer? --> falls ja, warum nicht einmal berechnen und in db ablegen?
+
+    	final String bedHeightLabel = bedHeight.getDescription();
+    	final String wstLabel = wstKms.getName();
+
+		for (int i = 0; i < wstKms.size(); i++) {
+
+			final double km = wstKms.getKm(i);
+    		final double wst = wstKms.getW(i);
+    		// FIXME: interpolate from bedheights?
+    		final double meanBedHeight = 79.32;
+
+    		final double flowDepth = wst - meanBedHeight;
+    		
+    		final double tkh = 0;
+    		final double flowDepthTkh = flowDepth - tkh;
+    		
+    		// FIXME: discharge not available for all wst? or any?
+    		final double discharge = 0.0;
+
+    		// REMARK: access the location once only during calculation 
+    		final String location = LocationProvider.getLocation(river.getName(), km);
+    		
+    		// REMARK: access the gauge once only during calculation 
+    		final Gauge gauge = gaugeIndex.findGauge(km);
+    		final String gaugeLabel = gauge == null ? notinrange : gauge.getName();
+    		
+			resultData.addRow( km, flowDepth, flowDepthTkh, tkh, wst, discharge, wstLabel, gaugeLabel, meanBedHeight, bedHeightLabel, location );
+		}
+		
+		return resultData;
+	}
+
+	private BedHeight loadBedHeight(final String soundingId, final double from, final double to) {
+		
+		// FIXME: absolutely unbelievable....
+		// The way how bed-heights (and other data too) is accessed is different for nearly ever calculation-type throughout flys.
+		// The knowledge on how to parse the datacage-ids is spread thorugh the complete code-base...
+
+		// We use here the way on how bed-heights are accessed by the BedDifferenceAccess/BedDifferenceCalculation, but this is plain random
+	    final String[] parts = soundingId.split(";");
+
+	    final BedHeightsArtifact artifact = (BedHeightsArtifact) RiverUtils.getArtifact(parts[0], context);
+
+	    final Integer bedheightId = artifact.getDataAsInteger("height_id");
+	    // FIXME: this only works with type 'single'; unclear on how to distinguish from epoch data (or whatever the other type means)
+	    // Luckily, the requirement is to only access 'single' data here.
+	    // final String bedheightType = artifact.getDataAsString("type");
+	    
+	    // FIXME: BedDifferences uses this, but we also need the metadata of the BedHeight
+	    // FIXME: second absolutely awful thing: BedHeight is a hibernate binding class, accessing the database via hibernate stuff
+	    // BedHeightFactory uses its own (direct) way of accessing the data, with its own implemented data classes.
+	    //return BedHeightFactory.getHeight(bedheightType, bedheightId, from, to);
+	     
+	    return BedHeight.getBedHeightById(bedheightId);
+	}
+}
\ No newline at end of file