Changeset 152 for trunk/web/addons/toga/libtoga.php

Timestamp:

06/21/05 15:01:45 (19 years ago)

Author:

bastiaans

Message:

toga/libtoga.php:

• Only search jobs in 'F' state

toga/search.php:

• Fixed form validation

web/addons/toga/graph.php:

• Added x-grid determination for labels and such along x-axis

File:

• trunk/web/addons/toga/libtoga.php (modified) (2 diffs)

trunk/web/addons/toga/libtoga.php

@@ -108 +108 @@
 
                 if( $id ) 
-                        $query = "SELECT job_id FROM jobs WHERE job_id = '$id'";
+                        $query = "SELECT job_id FROM jobs WHERE job_id = '$id' AND job_status = 'F'";
                 else {
                         $query_args = array();
@@ -127 +127 @@
                                 $query_args[] = "job_stop_timestamp <= $end_to_time";
 
-                        $query = "SELECT job_id FROM jobs WHERE ";
+                        $query = "SELECT job_id FROM jobs WHERE job_status = 'F' AND ";
                         $extra_query_args = '';