comparison reservationTable.php @ 1:f5a9f0eb4858

deleted: LICENSE.ja
author Sushi-k <epgrec@park.mda.or.jp>
date Wed, 08 Jul 2009 11:44:50 +0900
parents
children 8965ef108821
comparison
equal deleted inserted replaced
0:96312e6ab8d4 1:f5a9f0eb4858
1 <?php
2 include_once('config.php');
3 include_once( INSTALL_PATH . '/DBRecord.class.php' );
4 include_once( INSTALL_PATH . '/Smarty/Smarty.class.php' );
5
6 try{
7 $rvs = DBRecord::createRecords(TBL_PREFIX.RESERVE_TBL, "WHERE complete='0' ORDER BY starttime ASC" );
8
9 $reservations = array();
10 foreach( $rvs as $r ) {
11 $cat = new DBRecord(TBL_PREFIX.CATEGORY_TBL, "id", $r->category_id );
12 $arr = array();
13 $arr['id'] = $r->id;
14 $arr['type'] = $r->type;
15 $arr['channel'] = $r->channel;
16 $arr['starttime'] = $r->starttime;
17 $arr['endtime'] = $r->endtime;
18 $arr['mode'] = $RECORD_MODE[$r->mode]['name'];
19 $arr['title'] = $r->title;
20 $arr['description'] = $r->description;
21 $arr['cat'] = $cat->name_en;
22 $arr['autorec'] = $r->autorec;
23
24 array_push( $reservations, $arr );
25 }
26
27 $smarty = new Smarty();
28 $smarty->assign("sitetitle","録画予約一覧");
29 $smarty->assign( "reservations", $reservations );
30 $smarty->display("reservationTable.html");
31 }
32 catch( exception $e ) {
33 exit( $e->getMessage() );
34 }
35 ?>