Index: /trunk/doc/CHANGES.txt =================================================================== --- /trunk/doc/CHANGES.txt (リビジョン 37) +++ /trunk/doc/CHANGES.txt (リビジョン 38) @@ -1,3 +1,8 @@ foltia 更新履歴 http://www.dcc-jpl.com/soft/foltia/ +07.1.14 +reserveepg.php: +graytable.css: +viewepg.php: +　EPG番組表をジャンルごとにカラー塗り分け 07.1.8 Index: /trunk/install/perl/xmltv2foltia.pl =================================================================== --- /trunk/install/perl/xmltv2foltia.pl (リビジョン 27) +++ /trunk/install/perl/xmltv2foltia.pl (リビジョン 38) @@ -150,4 +150,35 @@ chomp(); $item{category} = &removetag($_); + + if ($item{category} =~ /情報/){ + $item{category} = "information"; + }elsif ($item{category} =~ /趣味・実用/){ + $item{category} = "hobby"; + }elsif ($item{category} =~ /教育/){ + $item{category} = "education"; + }elsif ($item{category} =~ /音楽/){ + $item{category} = "music"; + }elsif ($item{category} =~ /演劇/){ + $item{category} = "stage"; + }elsif ($item{category} =~ /映画/){ + $item{category} = "cinema"; + }elsif ($item{category} =~ /バラエティ/){ + $item{category} = "variety"; + }elsif ($item{category} =~ /ニュース・報道/){ + $item{category} = "news"; + }elsif ($item{category} =~ /ドラマ/){ + $item{category} = "drama"; + }elsif ($item{category} =~ /ドキュメンタリー・教養/){ + $item{category} = "documentary"; + }elsif ($item{category} =~ /スポーツ/){ + $item{category} = "sports"; + }elsif ($item{category} =~ /キッズ/){ + $item{category} = "kids"; + }elsif ($item{category} =~ /アニメ・特撮/){ + $item{category} = "anime"; + }elsif ($item{category} =~ /その他/){ + $item{category} = "etc"; + } + #print Dumper($_) ; #print "$result \n"; Index: /trunk/install/php/viewepg.php =================================================================== --- /trunk/install/php/viewepg.php (リビジョン 36) +++ /trunk/install/php/viewepg.php (リビジョン 38) @@ -173,5 +173,5 @@ $epgend = calcendtime($start , (8*60)); $query = " -SELECT startdatetime , enddatetime , lengthmin , epgtitle , epgdesc , epgcategory ,ontvchannel ,epgid +SELECT startdatetime , enddatetime , lengthmin , epgtitle , epgdesc , epgcategory ,ontvchannel ,epgid , epgcategory FROM foltia_epg WHERE foltia_epg.ontvchannel = '$stationname' AND @@ -184,5 +184,5 @@ if ($maxrowsstation == 0) { //print("番組データがありません
"); - $item[0]["$stationname"] = "番組データがありません"; + $item[0]["$stationname"] = ">番組データがありません"; }else{ @@ -199,4 +199,5 @@ $height = htmlspecialchars($stationrowdata[2]) * 3; $epgid = htmlspecialchars($stationrowdata[7]); +$epgcategory = htmlspecialchars($stationrowdata[8]); if (isset($timetablehash["$stationrowdata[0]"])){ @@ -205,5 +206,10 @@ $number = 0; } -$item["$number"]["$stationname"] = "$printstarttime $title $desc"; +if ($epgcategory == ""){ +$item["$number"]["$stationname"] = ">$printstarttime $title $desc"; +}else{ +$item["$number"]["$stationname"] = " id=\"$epgcategory\">$printstarttime $title $desc"; +}//if + }//for }//if @@ -221,12 +227,12 @@ $item[$i][$stationname] = ""; }else{ - $item[$i][$stationname] = "". $item[$i][$stationname] . ""; + $item[$i][$stationname] = ""; $rowspan--; } //ROWSPAN if ($rowspan === 1 ){ - $item[$dataplace][$stationname] = "". $item[$dataplace][$stationname] . ""; + $item[$dataplace][$stationname] = ""; }else{ - $item[$dataplace][$stationname] = "". $item[$dataplace][$stationname] . ""; + $item[$dataplace][$stationname] = ""; } @@ -238,7 +244,7 @@ $rowspan = $i - $dataplace; if ($rowspan === 1 ){ - $item[$dataplace][$stationname] = "". $item[$dataplace][$stationname] . ""; + $item[$dataplace][$stationname] = ""; }else{ - $item[$dataplace][$stationname] = "". $item[$dataplace][$stationname] . ""; + $item[$dataplace][$stationname] = ""; } $dataplace = $i; @@ -268,4 +274,25 @@ ?> +
+凡例 + + + + + + + + + + + + + + + + + + +
情報アニメ・特撮ニュース・報道ドラマバラエティドキュメンタリー・教養教育音楽映画趣味・実用キッズスポーツその他演劇
Index: /trunk/install/php/reserveepg.php =================================================================== --- /trunk/install/php/reserveepg.php (リビジョン 1) +++ /trunk/install/php/reserveepg.php (リビジョン 38) @@ -81,6 +81,36 @@ $progdesc = htmlspecialchars($rowdata[6]); $progdesc = z2h($progdesc); -$progcat = htmlspecialchars($rowdata[7]); -$progcat = z2h($progcat); +$progcat = htmlspecialchars(z2h($rowdata[7])); + +if ($progcat == "information"){ +$progcat = '情報'; +}elseif ($progcat == "anime"){ +$progcat = 'アニメ・特撮'; +}elseif ($progcat == "news"){ +$progcat = 'ニュース・報道'; +}elseif ($progcat == "drama"){ +$progcat = 'ドラマ'; +}elseif ($progcat == "variety"){ +$progcat = 'バラエティ'; +}elseif ($progcat == "documentary"){ +$progcat = 'ドキュメンタリー・教養'; +}elseif ($progcat == "education"){ +$progcat = '教育'; +}elseif ($progcat == "music"){ +$progcat = '音楽'; +}elseif ($progcat == "cinema"){ +$progcat = '映画'; +}elseif ($progcat == "hobby"){ +$progcat = '趣味・実用'; +}elseif ($progcat == "kids"){ +$progcat = 'キッズ'; +}elseif ($progcat == "sports"){ +$progcat = 'スポーツ'; +}elseif ($progcat == "etc"){ +$progcat = 'その他'; +}elseif ($progcat == "stage"){ +$progcat = '演劇'; +} + $epgid = $epgid ; $stationid = htmlspecialchars($rowdata[10]); Index: /trunk/install/php/graytable.css =================================================================== --- /trunk/install/php/graytable.css (リビジョン 36) +++ /trunk/install/php/graytable.css (リビジョン 38) @@ -1,3 +1,2 @@ - body * {margin:0px;padding:0px;border:0px;} @@ -25,7 +24,7 @@ background-color: #CCC; } -th + th, td + td { border-left: 1px solid #AAA; } -td { border-top: 1px solid #AAA; vertical-align: top; } -th, td { padding: 3px;} +th + th, td + td { border-right: 1px solid #AAA; } +td { vertical-align: top; } +th, td { border-right: 1px solid #AAA;border-bottom: 1px solid #AAA; padding: 3px;} tr.reserved{background-color: #FFDDDD;} tr.reservedtitle{background-color: #DDDDFF;} @@ -57,2 +56,26 @@ ul {list-style-type:none;} li {width:90px;background:#ffa;padding:2px;border:1px solid white;line-height:1.1em;} + +td#anime {background:#FFC0CB;} /* アニメ・特撮 */ +td#kids {background:#FFFFDC;} /* キッズ */ +td#sports {background:#D7D7FF;} /* スポーツ */ +td#etc {background:#F3F3F3;} /* その他 */ +td#news {background:#E3C0FF;} /* ニュース・報道 */ +td#cinema {background:#FAA5FF;} /* 映画 */ +td#education{background-color:#C9C9C9;} /* 教育 */ +td#documentary{background-color:#E8FFE8;} /* ドキュメンタリー・教養 */ +td#music{background-color: #A4FFF5;} /* 音楽 */ +td#variety{background-color: #E0F0CA;} /* バラエティ */ +td#hobby{background-color: #FDF7BB;} /* 趣味・実用 */ +td#information {background:#B6FFFA;} /* 情報 */ +td#stage{background-color: #FFC0E3;} /* 演劇 */ +td#drama {background:#FFD0FF;} /* ドラマ */ + +#information:hover, #hobby:hover, #education:hover, #music:hover, #stage:hover, #cinema:hover, #variety:hover, #news:hover, #drama:hover, #documentary:hover, #sports:hover, #kids:hover, #anime:hover, #etc:hover + { + background-color: #FFFA4D; + padding-right: 1px; padding-bottom:1px; + border-right: 3px solid #aaa; border-bottom: 3px solid #666; } + + +