recordedTable.php

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