comparison Keyword.class.php @ 106:57676bb30f64

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

95:d9b9d1d903a1

		
		if( $this->weekofday != 7 ) {
			$options .= " AND WEEKDAY(starttime) = '".$this->weekofday."'";
		}
		
		$options .= " ORDER BY starttime ASC";
		
		$recs = array();
		try {
			$recs = DBRecord::createRecords( PROGRAM_TBL, $options );
		}
		catch( Exception $e ) {
			throw $e;
		}
		
		return $recs;
	}
	
	
	public function reservation() {

106:57676bb30f64

		
		if( $this->weekofday != 7 ) {
			$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();
		try {
			$recs = DBRecord::createRecords( PROGRAM_TBL, $options );
		}
		catch( Exception $e ) {
			throw $e;
		}
		return $recs;
	}
	
	
	public function reservation() {