|
1
|
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 $order = "";
|
|
|
7 $search = "";
|
|
|
8 $category_id = 0;
|
|
|
9 $station = 0;
|
|
|
10
|
|
|
11 #$options = "WHERE complete='1'";
|
|
|
12 $options = "WHERE starttime < '". date("Y-m-d H:i:s")."'"; // ながら再生は無理っぽい？
|
|
|
13
|
|
|
14 if(isset( $_POST['do_search'] )) {
|
|
|
15 if( isset($_POST['search'])){
|
|
|
16 if( $_POST['search'] != "" ) {
|
|
|
17 $search = $_POST['search'];
|
|
|
18 $options .= " AND CONCAT(title,description) like '%".mysql_real_escape_string($_POST['search'])."%'";
|
|
|
19 }
|
|
|
20 }
|
|
|
21 if( isset($_POST['category_id'])) {
|
|
|
22 if( $_POST['category_id'] != 0 ) {
|
|
|
23 $category_id = $_POST['category_id'];
|
|
|
24 $options .= " AND category_id = '".$_POST['category_id']."'";
|
|
|
25 }
|
|
|
26 }
|
|
|
27 if( isset($_POST['station'])) {
|
|
|
28 if( $_POST['station'] != 0 ) {
|
|
|
29 $station = $_POST['station'];
|
|
|
30 $options .= " AND channel_id = '".$_POST['station']."'";
|
|
|
31 }
|
|
|
32 }
|
|
|
33 }
|
|
|
34
|
|
|
35
|
|
|
36 $options .= " ORDER BY starttime DESC";
|
|
|
37
|
|
|
38 try{
|
|
|
39 $rvs = DBRecord::createRecords(TBL_PREFIX.RESERVE_TBL, $options );
|
|
|
40 $records = array();
|
|
|
41 foreach( $rvs as $r ) {
|
|
|
42 $cat = new DBRecord(TBL_PREFIX.CATEGORY_TBL, "id", $r->category_id );
|
|
|
43 $ch = new DBRecord(TBL_PREFIX.CHANNEL_TBL, "id", $r->channel_id );
|
|
|
44 $arr = array();
|
|
|
45 $arr['id'] = $r->id;
|
|
|
46 $arr['station_name'] = $ch->name;
|
|
|
47 $arr['starttime'] = $r->starttime;
|
|
|
48 $arr['endtime'] = $r->endtime;
|
|
|
49 $arr['title'] = "<a href=\"".INSTALL_URL."/viewer.php?reserve_id=".$r->id."\">".htmlspecialchars($r->title,ENT_QUOTES)."</a>";
|
|
|
50 $arr['description'] = "<a href=\"".INSTALL_URL."/viewer.php?reserve_id=".$r->id."\">".htmlspecialchars($r->description,ENT_QUOTES)."</a>";
|
|
|
51 $arr['thumb'] = "<a href=\"".INSTALL_URL."/viewer.php?reserve_id=".$r->id."\"><img src=\"".INSTALL_URL.THUMBS."/".$r->path.".jpg\" /></a>";
|
|
|
52 $arr['cat'] = $cat->name_en;
|
|
|
53 $arr['mode'] = $RECORD_MODE[$r->mode]['name'];
|
|
|
54
|
|
|
55 array_push( $records, $arr );
|
|
|
56 }
|
|
|
57
|
|
|
58 $crecs = DBRecord::createRecords(TBL_PREFIX.CATEGORY_TBL );
|
|
|
59 $cats = array();
|
|
|
60 $cats[0]['id'] = 0;
|
|
|
61 $cats[0]['name'] = "すべて";
|
|
|
62 $cats[0]['selected'] = $category_id == 0 ? "selected" : "";
|
|
|
63 foreach( $crecs as $c ) {
|
|
|
64 $arr = array();
|
|
|
65 $arr['id'] = $c->id;
|
|
|
66 $arr['name'] = $c->name_jp;
|
|
|
67 $arr['selected'] = $c->id == $category_id ? "selected" : "";
|
|
|
68 array_push( $cats, $arr );
|
|
|
69 }
|
|
|
70
|
|
|
71 $crecs = DBRecord::createRecords(TBL_PREFIX.CHANNEL_TBL );
|
|
|
72 $stations = array();
|
|
|
73 $stations[0]['id'] = 0;
|
|
|
74 $stations[0]['name'] = "すべて";
|
|
|
75 $stations[0]['selected'] = (! $station) ? "selected" : "";
|
|
|
76 foreach( $crecs as $c ) {
|
|
|
77 $arr = array();
|
|
|
78 $arr['id'] = $c->id;
|
|
|
79 $arr['name'] = $c->name;
|
|
|
80 $arr['selected'] = $station == $c->id ? "selected" : "";
|
|
|
81 array_push( $stations, $arr );
|
|
|
82 }
|
|
|
83
|
|
|
84
|
|
|
85 $smarty = new Smarty();
|
|
|
86 $smarty->assign("sitetitle","録画済一覧");
|
|
|
87 $smarty->assign( "records", $records );
|
|
|
88 $smarty->assign( "search", $search );
|
|
|
89 $smarty->assign( "stations", $stations );
|
|
|
90 $smarty->assign( "cats", $cats );
|
|
|
91 $smarty->assign( "use_thumbs", USE_THUMBS );
|
|
|
92
|
|
|
93 $smarty->display("recordedTable.html");
|
|
|
94
|
|
|
95
|
|
|
96 }
|
|
|
97 catch( exception $e ) {
|
|
|
98 exit( $e->getMessage() );
|
|
|
99 }
|
|
|
100 ?>
|
