Changeset 142 for trunk

Timestamp:

06/16/05 14:12:15 (18 years ago)

Author:

bastiaans

Message:

web/addons/toga/libtoga.php:

• Fixed typo

web/addons/toga/search.php:

• Timebased searching works now

Location:

trunk/web/addons/toga

Files:

• libtoga.php (modified) (1 diff)
• search.php (modified) (2 diffs)

trunk/web/addons/toga/libtoga.php

@@ -120 +120 @@
                         if( $start_from_time )
                                 $query_args[] = "job_start_timestamp >= $start_from_time";
-                        if( $start_end_time )
+                        if( $start_to_time )
                                 $query_args[] = "job_start_timestamp <= $start_to_time";
                         if( $end_from_time )

trunk/web/addons/toga/search.php

@@ -102 +102 @@
 function makeDate( $time ) {
         return strftime( "%a %d %b %Y %H:%M:%S", $time );
+}
+
+function datetimeToEpoch( $datetime ) {
+
+        $datetime_fields = explode( ' ', $datetime );
+
+        $date = $datetime_fields[0];
+        $time = $datetime_fields[1];
+
+        $date_fields = explode( '-', $date );
+
+        $days = $date_fields[0];
+        $months = $date_fields[1];
+        $years = $date_fields[2];
+
+        $time_fields = explode( ':', $time );
+        reset( $time_fields );
+
+        print_r( $time_fields );
+
+        $hours = $time_fields[0];
+        $minutes = $time_fields[1];
+        $seconds = $time_fields[2];
+
+        $timestamp = mktime( $hours, $minutes, $seconds, $months, $days, $years );
+
+        return $timestamp;
 }
 
@@ -150 +177 @@
                 $tpl->newBlock( "search_results" );
                 $tdb = new TarchDbase();
+                if( $start_from_time ) $start_from_time = datetimeToEpoch( $start_from_time );
+                if( $start_to_time ) $start_to_time = datetimeToEpoch( $start_to_time );
+                if( $end_from_time ) $end_from_time = datetimeToEpoch( $end_from_time );
+                if( $end_to_time ) $end_to_time = datetimeToEpoch( $end_to_time );
                 $search_ids = $tdb->searchDbase( $id, $queue, $user, $name, $start_from_time, $start_to_time, $end_from_time, $end_to_time );