Mercurial > bmsapp / changeset

--- a/src/CalibrateiSpindel.cpp	Sat Oct 14 18:50:47 2023 +0200
+++ b/src/CalibrateiSpindel.cpp	Sun Oct 15 13:30:24 2023 +0200
@@ -21,6 +21,19 @@
 #include "polyfit.h"
 #include "MainWindow.h"
 
+/*
+ * The following MySQL query produces a table with historic real results:
+ *
+ * SELECT pr.code,
+ *        pr.og,
+ *        (SELECT angle FROM log_ispindel WHERE code=pr.code ORDER BY datetime LIMIT 1) as og_angle,
+ *        pr.fg,
+ *        (SELECT angle FROM log_ispindel WHERE code=pr.code ORDER BY datetime DESC LIMIT 1) as fg_angle
+ *   FROM products AS pr
+ *   WHERE pr.stage=11 AND pr.log_ispindel=1
+ *   ORDER BY pr.fg DESC
+ * ;
+ */
 
 
 CalibrateiSpindel::CalibrateiSpindel(int id, QWidget *parent) : QDialog(parent), ui(new Ui::CalibrateiSpindel)