diff Keyword.class.php @ 106:57676bb30f64

add: 時間帯で絞り込みを追加

--- a/Keyword.class.php	Wed Mar 03 00:02:15 2010 +0900
+++ b/Keyword.class.php	Mon Mar 08 18:07:19 2010 +0900
@@ -47,6 +47,10 @@
 			$options .= " AND WEEKDAY(starttime) = '".$this->weekofday."'";
 		}
 		
+		if( $this->prgtime != 24 ) {
+			$options .= " AND time(starttime) BETWEEN cast('".sprintf( "%02d:00:00", $this->prgtime)."' as time) AND cast('".sprintf("%02d:59:59", $this->prgtime)."' as time)";
+		}
+		
 		$options .= " ORDER BY starttime ASC";
 		
 		$recs = array();
@@ -56,7 +60,6 @@
 		catch( Exception $e ) {
 			throw $e;
 		}
-		
 		return $recs;
 	}