Changeset 18720 for trunk

Timestamp:

01/07/17 11:17:59 (8 years ago)

Author:

tbretz

Message:

Order by time instead of ID. This allows an easy implementation of a suspend/resume button just adding it to the end of the schedule.

File:

• trunk/FACT++/www/schedule/load.php (modified) (1 diff)

trunk/FACT++/www/schedule/load.php

@@ -55 +55 @@
 query("SELECT fSourceKEY AS 'key', fSourceName AS 'val' FROM Source WHERE fSourceTypeKEY=1");
 query("SELECT fMeasurementTypeKEY AS 'key', fMeasurementTypeName AS 'val' FROM MeasurementType");
-query("SELECT * FROM Schedule WHERE DATE(ADDTIME(fStart, '-12:00:00')) = '".$_POST['n']."'".$cut."ORDER BY fScheduleID ASC, fMeasurementID ASC");
+query("SELECT * FROM Schedule WHERE DATE(ADDTIME(fStart, '-12:00:00')) = '".$_POST['n']."'".$cut."ORDER BY fStart ASC, fMeasurementID ASC");
 
 //sleep(3);