Mercurial > epgrec.yaz

comparison storeProgram.inc.php @ 125:ef3df87f3c7d

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
mod: ??????????????????
author Sushi-k <epgrec@park.mda.or.jp>
date Wed, 17 Mar 2010 18:12:01 +0900
parents 3bed74eca373
children 9c5e597ef6c6
comparison
equal deleted inserted replaced
124:aa48eb5f1993 125:ef3df87f3c7d
27 } 27 }
28 } 28 }
29 29
30 function storeProgram( $type, $xmlfile ) { 30 function storeProgram( $type, $xmlfile ) {
31 global $BS_CHANNEL_MAP, $GR_CHANNEL_MAP, $CS_CHANNEL_MAP; 31 global $BS_CHANNEL_MAP, $GR_CHANNEL_MAP, $CS_CHANNEL_MAP;
32
32 // チャンネルマップファイルの準備 33 // チャンネルマップファイルの準備
33 $map = array(); 34 $map = array();
34 if( $type == "BS" ) $map = $BS_CHANNEL_MAP; 35 if( $type == "BS" ) $map = $BS_CHANNEL_MAP;
35 else if( $type == "GR") $map = $GR_CHANNEL_MAP; 36 else if( $type == "GR") $map = $GR_CHANNEL_MAP;
36 else if( $type == "CS") $map = $CS_CHANNEL_MAP; 37 else if( $type == "CS") $map = $CS_CHANNEL_MAP;
69 // channel 終了 70 // channel 終了
70 71
71 // programme 取得 72 // programme 取得
72 73
73 foreach( $xml->programme as $program ) { 74 foreach( $xml->programme as $program ) {
75 $channel_rec = null;
76
74 $channel_disc = $program['channel']; 77 $channel_disc = $program['channel'];
75 if( ! array_key_exists( "$channel_disc", $map ) ) continue; 78 if( ! array_key_exists( "$channel_disc", $map ) ) continue;
79 $channel = $map["$channel_disc"];
76 80
77 $channel = $map["$channel_disc"]; 81 try {
82 $channel_rec = new DBRecord(CHANNEL_TBL, "channel_disc", "$channel_disc" );
83 }
84 catch( Exception $e ) {
85 // 無視
86 }
87 if( $channel_rec == null ) continue; // あり得ないことが起きた
88 if( $channel_rec->skip == 1 ) continue; // 受信しないチャンネル
89
78 $starttime = str_replace(" +0900", '', $program['start'] ); 90 $starttime = str_replace(" +0900", '', $program['start'] );
79 $endtime = str_replace( " +0900", '', $program['stop'] ); 91 $endtime = str_replace( " +0900", '', $program['stop'] );
80 $title = $program->title; 92 $title = $program->title;
81 $desc = $program->desc; 93 $desc = $program->desc;
82 $cat_ja = ""; 94 $cat_ja = "";
99 $cat_rec->name_en = $cat_en; 111 $cat_rec->name_en = $cat_en;
100 $cat_rec->category_disc = $category_disc; 112 $cat_rec->category_disc = $category_disc;
101 } 113 }
102 else 114 else
103 $cat_rec = new DBRecord(CATEGORY_TBL, "category_disc" , $category_disc ); 115 $cat_rec = new DBRecord(CATEGORY_TBL, "category_disc" , $category_disc );
104 // 116 //
105 $channel_rec = new DBRecord(CHANNEL_TBL, "channel_disc", $channel_disc );
106 $num = DBRecord::countRecords(PROGRAM_TBL, "WHERE program_disc = '".$program_disc."'" ); 117 $num = DBRecord::countRecords(PROGRAM_TBL, "WHERE program_disc = '".$program_disc."'" );
107 if( $num == 0 ) { 118 if( $num == 0 ) {
108 // 新規番組 119 // 新規番組
109 // 重複チェック 同時間帯にある番組 120 // 重複チェック 同時間帯にある番組
110 $options = "WHERE channel_disc = '".$channel_disc."' ". 121 $options = "WHERE channel_disc = '".$channel_disc."' ".