//build feed for this specific group
error_log("selecting Group: $select", 0);
$conditions = array('conditions' => array('basename like ? AND playgroup like ?', '%.mp4', $select));
$rquery = array(
'select'=>'recorded.*
, ifnull(
nullif(recorded.originalairdate,0)
, makedate( (select airdate from recordedprogram where recordedprogram.chanid=recorded.chanid and recordedprogram.starttime=recorded.starttime),1 )
) as airdate'
);
$record = Recorded::all( array_merge($rquery, $conditions) );
error_log("COUNT of RECORDED: ".count($record), 0);
$video = VideoMetadata::find_by_sql( $SQL );
error_log("COUNT of VIDEOMETADATA: ".count($video), 0);
$items = array();
$shows = array_values(array_merge($record, $video));
foreach($shows as $item => $show ){
$items[] = new item($show);
}
//usort($items, 'items_title_date_compare');
usort($items, 'items_title_episode_compare');
if(count($items)){
$feed = new feed(
array(
'resultLength'=>new resultLength(array('content'=>count($items)))
, 'endIndex'=>new endIndex(array('content'=>count($items)))
default:
break;
}
if(useUTC())
$intervalQry = "starttime between adddate(utc_timestamp(), interval $interval) and utc_timestamp() ";
else
$intervalQry = "starttime between adddate(now(), interval $interval) and now() ";
$conditions = array('conditions' => array("basename like ? AND $intervalQry", '%.mp4'));
$record = Recorded::all( $conditions );
error_log("COUNT of RECORDED: ".count($record), 0);
$vselect = array('select' => '*, case releasedate when (releasedate is null) then insertdate else releasedate end as starttime');
$conditions = array('conditions' => array("filename like ? AND host > ? HAVING $intervalQry", '%.m%4%', ''));
$video = VideoMetadata::all( array_merge($vselect, $conditions) );
error_log("COUNT of VIDEOMETADATA: ".count($video), 0);
$items = array();
$shows = array_values(array_merge($record, $video));
usort($shows, 'shows_date_compare');
foreach($shows as $item => $show ){
$items[] = new item($show);
}
if(count($items)){
$feed = new feed(
array(
'resultLength'=>new resultLength(array('content'=>count($items)))
, 'endIndex'=>new endIndex(array('content'=>count($items)))
, 'item'=>$items
array(XmlEmitter::ATR.'title'=>'Genre'
, XmlEmitter::ATR.'description'=>'Select a Genre'
, XmlEmitter::ATR.'sd_img'=>"$WebServer/$MythRokuDir/images/bookmark-5.png"
, XmlEmitter::ATR.'hd_img'=>"$WebServer/$MythRokuDir/images/bookmark-5.png"
, 'categoryLeaf'=>array()
)
);
$menu = array();
$results = array();
$rec_cat = Recorded::find_by_sql( "select distinct category from recorded where basename like '%.mp4'" );
foreach ( $rec_cat as $value ) {
$results[] = ucwords(str_replace('-', ' ', $value->category));
}
$vid_genre = VideoMetadata::find_by_sql( "select (case when g.genre is null then 'Default' else g.genre end) as genre from videometadata v left join videometadatagenre a on a.idvideo = v.intid left join videogenre g on g.intid = a.idgenre");
foreach ( $vid_genre as $value ) {
$results[] = ucwords(str_replace('-', ' ', $value->genre));
}
asort($results);
$results = array_unique($results);
foreach ( $results as $value ) {
$parms = array('Genre'=>rawurlencode($value));
$menu[] = new categoryLeaf(
array(XmlEmitter::ATR.'title'=>$value
, XmlEmitter::ATR.'feed'=>"$WebServer/$MythRokuDir/mythtv_genre_xml.php?".http_build_query($parms))
);
}
$genre->categoryLeaf = $menu;