<?php
/*
 Anime recording system foltia
 http://www.dcc-jpl.com/soft/foltia/

reserveepgcomp.php

目的
EPG番組の予約登録をします。

引数
stationid:録画局ID
subtitle:番組名
startdatetime:録画開始時刻 (ex.200510070145)
enddatetime:録画終了時刻 (ex.200510070215)
lengthmin:録画時間(単位:分)

 DCC-JPL Japan/foltia project

*/
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html lang="ja">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=EUC-JP">
<meta http-equiv="Content-Style-Type" content="text/css">
<link rel="stylesheet" type="text/css" href="graytable.css"> 
<body BGCOLOR="#ffffff" TEXT="#494949" LINK="#0047ff" VLINK="#000000" ALINK="#c6edff" >

<?php 
  include("./foltialib.php");

	printhtmlpageheader();
?>
  <p align="left"><font color="#494949" size="6">番組予約</font></p>
  <hr size="4">
<?php

$stationid = getnumform(stationid);
$subtitle = getform(subtitle);
$startdatetime = getnumform(startdatetime);
$enddatetime = getnumform(enddatetime);
$lengthmin = getnumform(lengthmin);

		if ($stationid == "" || $startdatetime < 0 ||  $enddatetime < 0 || $lengthmin < 0) {
		print "	<title>foltia:EPG予約:Error</title></head>\n";
		die_exit("登録番組がありません<BR>");
		}
print "	<title>foltia:EPG予約:完了</title>
</head>\n";
$con = m_connect();
$now = date("YmdHi");   
// - DB登録作業

//時刻検査
if (($startdatetime > $now ) && ($enddatetime > $now ) && ($enddatetime  > $startdatetime ) ){

//min pidを探す
$query = "SELECT min(pid) FROM  foltia_subtitle ";
	$rs = m_query($con, $query, "DBクエリに失敗しました");
	$maxrows = pg_num_rows($rs);
	if ($maxrows == 0){
	$insertpid = -1 ;
	}else{
	$rowdata = pg_fetch_row($rs, 0);
	$insertpid = $rowdata[0];
	$insertpid-- ;
	}
// next 話数を探す
$query = "SELECT max(countno) FROM  foltia_subtitle WHERE tid = 0";
	$rs = m_query($con, $query, "DBクエリに失敗しました");
	$maxrows = pg_num_rows($rs);
	if ($maxrows == 0){
	$nextcno = 1 ;
	}else{
	$rowdata = pg_fetch_row($rs, 0);
	$nextcno = $rowdata[0];
	$nextcno++ ;
	}

//INSERT
if ($demomode){
}else{

$query = "
insert into foltia_subtitle  
values ( '$insertpid','0','$stationid',
	'$nextcno','$subtitle','$startdatetime','$enddatetime','0' ,'$lengthmin')";

	$rs = m_query($con, $query, "DBクエリに失敗しました");

//addatq.pl
//キュー入れプログラムをキック
//引数　TID チャンネルID
//echo("$toolpath/perl/addatq.pl $tid $station");

	$oserr = system("$toolpath/perl/addatq.pl 0 0");

}//end if demomode

print "下記予約を完了いたしました。<br>";

}else{
print "時刻が不正なために予約できませんでした。 <br>";

}

?>


<?php
print "<table width=\"100%\" border=\"0\">
    <tr><td>放送開始</td><td>$startdatetime</td></tr>
    <tr><td>放送終了</td><td>$enddatetime</td></tr>
    <tr><td>局コード</td><td>$stationid</td></tr>
    <tr><td>尺(分)</td><td>$lengthmin</td></tr>
    <tr><td>番組名</td><td>$subtitle</td></tr>
	
</tbody>
</table>";

?>
</body>
</html>
