# HG changeset patch
# User Sascha L. Teichmann <sascha.teichmann@intevation.de>
# Date 1556629907 -7200
# Node ID 7b4092b6b51aed33e439acb96720b46ace757d57
# Parent  f34277674926f517bf6330f492b15a14ffbebe8d
Fairway availability depth: Fixed SQL statement.

diff -r f34277674926 -r 7b4092b6b51a pkg/controllers/bottlenecks.go
--- a/pkg/controllers/bottlenecks.go	Tue Apr 30 13:32:52 2019 +0200
+++ b/pkg/controllers/bottlenecks.go	Tue Apr 30 15:11:47 2019 +0200
@@ -84,7 +84,6 @@
 `
 	selectGaugeLDCSQL = `
 SELECT
-  grwl.depth_reference,
   grwl.value
 FROM waterway.gauges_reference_water_levels grwl JOIN
      waterway.bottlenecks bns
@@ -691,7 +690,7 @@
 		}
 		f := pfrom
 		pfrom = pfrom.AddDate(0, 1, 0)
-		label := fmt.Sprint("%02d-%d", f.Month(), f.Year())
+		label := fmt.Sprintf("%02d-%d", f.Month(), f.Year())
 		return f, f.AddDate(0, 1, 0).Add(-time.Nanosecond), label
 	}
 }
@@ -704,7 +703,7 @@
 		}
 		f := pfrom
 		pfrom = pfrom.AddDate(0, 3, 0)
-		label := fmt.Sprint("Q%d-%d", int(f.Month())/4+1, f.Year())
+		label := fmt.Sprintf("Q%d-%d", int(f.Month())/4+1, f.Year())
 		return f, f.AddDate(0, 3, 0).Add(-time.Nanosecond), label
 	}
 }
@@ -717,7 +716,7 @@
 		}
 		f := pfrom
 		pfrom = pfrom.AddDate(1, 0, 0)
-		label := fmt.Sprint("%d", f.Year())
+		label := fmt.Sprintf("%d", f.Year())
 		return f, f.AddDate(1, 0, 0).Add(-time.Nanosecond), label
 	}
 }