comparison programTable.php @ 106:57676bb30f64

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

95:d9b9d1d903a1

					array( "name" => "���", "id" => 5, "selected" => "" ),
					array( "name" => "���", "id" => 6, "selected" => "" ),
					array( "name" => "������", "id" => 7, "selected" => "" ),
);

$autorec_modes = $RECORD_MODE;
$autorec_modes[(int)($settings->autorec_mode)]['selected'] = "selected";

$weekofday = 7;
$search = "";
$use_regexp = 0;
$type = "*";
$category_id = 0;
$station = 0;

// mysql_real_escape_string�������������･膓������������鏆�荀����������
$dbh = @mysql_connect($settings->db_host, $settings->db_user, $settings->db_pass );

	// ��������＜�若�帥��������

		$weekofday = $_POST['weekofday'];
		if( $weekofday != 7 ) {
			$options .= " AND WEEKDAY(starttime) = '".$weekofday."'";
		}
	}
}
$options .= " ORDER BY starttime ASC LIMIT 300";
$do_keyword = 0;
if( ($search != "") || ($type != "*") || ($category_id != 0) || ($station != 0) )
	$do_keyword = 1;
	
try{
	
	$precs = DBRecord::createRecords(PROGRAM_TBL, $options );
	
	$programs = array();
	foreach( $precs as $p ) {
		$ch  = new DBRecord(CHANNEL_TBL, "id", $p->channel_id );

		$arr['selected'] = $station == $c->id ? "selected" : "";
		if( $station == $c->id ) $k_station_name = $c->name;
		array_push( $stations, $arr );
	}
	$weekofdays["$weekofday"]["selected"] = "selected" ;

	$smarty = new Smarty();
	$smarty->assign("sitetitle","���腟�罎�膣�");
	$smarty->assign("do_keyword", $do_keyword );
	$smarty->assign( "programs", $programs );

	$smarty->assign( "weekofday", $weekofday );
	$smarty->assign( "k_weekofday", $weekofdays["$weekofday"]["name"] );
	$smarty->assign( "weekofday", $weekofday );
	$smarty->assign( "weekofdays", $weekofdays );
	$smarty->assign( "autorec_modes", $autorec_modes );
	$smarty->display("programTable.html");
}
catch( exception $e ) {
	exit( $e->getMessage() );
}

106:57676bb30f64

					array( "name" => "���", "id" => 5, "selected" => "" ),
					array( "name" => "���", "id" => 6, "selected" => "" ),
					array( "name" => "������", "id" => 7, "selected" => "" ),
);


$autorec_modes = $RECORD_MODE;
$autorec_modes[(int)($settings->autorec_mode)]['selected'] = "selected";

$weekofday = 7;
$search = "";
$use_regexp = 0;
$type = "*";
$category_id = 0;
$station = 0;
$prgtime = 24;


// mysql_real_escape_string�������������･膓������������鏆�荀����������
$dbh = @mysql_connect($settings->db_host, $settings->db_user, $settings->db_pass );

	// ��������＜�若�帥��������

		$weekofday = $_POST['weekofday'];
		if( $weekofday != 7 ) {
			$options .= " AND WEEKDAY(starttime) = '".$weekofday."'";
		}
	}
	if( isset($_POST['prgtime']) ) {
		$prgtime = (int)($_POST['prgtime']);
		if( $prgtime != 24 ) {
			$options .= " AND time(starttime) BETWEEN cast('".sprintf( "%02d:00:00", $prgtime)."' as time) AND cast('".sprintf("%02d:59:59", $prgtime)."' as time)";
		}
	}
}
$options .= " ORDER BY starttime ASC LIMIT 300";


$do_keyword = 0;
if( ($search != "") || ($type != "*") || ($category_id != 0) || ($station != 0) )
	$do_keyword = 1;
	
try{
	$precs = DBRecord::createRecords(PROGRAM_TBL, $options );
	
	$programs = array();
	foreach( $precs as $p ) {
		$ch  = new DBRecord(CHANNEL_TBL, "id", $p->channel_id );

		$arr['selected'] = $station == $c->id ? "selected" : "";
		if( $station == $c->id ) $k_station_name = $c->name;
		array_push( $stations, $arr );
	}
	$weekofdays["$weekofday"]["selected"] = "selected" ;
	
	// ������絽�
	$prgtimes = array();
	for( $i=0; $i < 25; $i++ ) {
		array_push( $prgtimes, 
			array(  "name" => ( $i == 24  ? "������" : sprintf("%0d���鐔�",$i) ),
					"value" => $i,
					"selected" =>  ( $i == $prgtime ? "selected" : "" ) )
		);
	}



	$smarty = new Smarty();
	$smarty->assign("sitetitle","���腟�罎�膣�");
	$smarty->assign("do_keyword", $do_keyword );
	$smarty->assign( "programs", $programs );

	$smarty->assign( "weekofday", $weekofday );
	$smarty->assign( "k_weekofday", $weekofdays["$weekofday"]["name"] );
	$smarty->assign( "weekofday", $weekofday );
	$smarty->assign( "weekofdays", $weekofdays );
	$smarty->assign( "autorec_modes", $autorec_modes );
	$smarty->assign( "prgtimes", $prgtimes );
	$smarty->assign( "prgtime", $prgtime );
	$smarty->display("programTable.html");
}
catch( exception $e ) {
	exit( $e->getMessage() );
}