PHP Channel::getChannelList方法代码示例

/**
 * Prints a <select> of the available channels
/**/
function channel_select($params = '', $selected = '', $id = 00)
{
    $channels = Channel::getChannelList();
    echo "\n<select name=\"chan_{$id}\" {$params}>";
    foreach ($channels as $chanid) {
        $channel =& Channel::find($chanid);
        // Not visible?
        if (empty($channel->visible) || $channel->chanid == 91010) {
            continue;
        }
        // Print the option
        echo '
                <option value="', $channel->chanid, '"', ' title="', html_entities($channel->name), '"';
        // Selected?
        if ($channel->chanid == $selected || $channel->chanid == $_GET['chanid']) {
            echo ' SELECTED';
        }
        // Print the rest of the content
        echo '>';
        if ($_SESSION["prefer_channum"]) {
            echo $channel->channum . '&nbsp;&nbsp;(' . html_entities($channel->callsign) . ')';
        } else {
            echo html_entities($channel->callsign) . '&nbsp;&nbsp;(' . $channel->channum . ')';
        }
        echo '</option>';
    }
    echo '</select>';
}

/**
 * prints a <select> of the available channels
/**/
function channel_select($chanid)
{
    $Channel_list = Channel::getChannelList();
    echo '<select name="channel"><option value=""';
    if (empty($chanid)) {
        echo ' SELECTED';
    }
    echo '>(' . t('Any Channel') . ')</option>';
    foreach ($Channel_list as $chanid) {
        $channel =& Channel::find($chanid);
        // Print the option
        echo '<option value="', $channel->chanid, '"', ' title="', html_entities($channel->name), '"';
        // Selected?
        if ($channel->chanid == $chanid) {
            echo ' SELECTED';
        }
        // Print the rest of the content
        echo '>';
        if ($_SESSION["prefer_channum"]) {
            echo $channel->channum . '&nbsp;&nbsp;(' . html_entities($channel->callsign) . ')';
        } else {
            echo html_entities($channel->callsign) . '&nbsp;&nbsp;(' . $channel->channum . ')';
        }
        echo '</option>';
    }
    echo '</select>';
}

<table id="title_choices" class="commandbox commands" border="0" cellspacing="0" cellpadding="4">
<tr>


    <td class="x-recordings"><?php 
echo t('Channels');
?>
:</td>
    <td><select name="chanid" onchange="$('change_title').submit()">
        <option id="All recordings" value=""><?php 
echo t('All channels');
?>
</option>
<?php 
$selChan = null;
$channels = Channel::getChannelList();
foreach ($channels as $chanid) {
    $channel =& Channel::find($chanid);
    // Not visible?
    if (empty($channel->visible)) {
        continue;
    }
    // Print the option
    echo '<option value="', $channel->chanid, '"', ' title="', html_entities($channel->name), '"';
    // Selected?
    if ($channel->chanid == $selected || $channel->chanid == $_GET['chanid']) {
        echo ' SELECTED';
        $selChan = $channel;
    }
    // Print the rest of the content
    echo '>';

/**
 * loads all program data for the specified time range.
 * Set $single_program to true if you only want information about programs that
 * start exactly at $start_time (used by program_detail.php)
/**/
function &load_all_program_data($start_time, $end_time, $chanid = false, $single_program = false, $extra_query = '', $distinctTitle = false)
{
    global $db;
    // Don't allow negative timestamps; it confuses MySQL
    if ($start_time < 0) {
        $start_time = 0;
    }
    if ($end_time < 0) {
        $end_time = 0;
    }
    // Make a local hash of channel chanid's with references to the actual
    // channel data (Channels are not indexed by anything in particular, so
    // that the user can sort by chanid or channum).
    $channel_hash = array();
    // An array (that later gets converted to a string) containing the id's of channels we want to load
    if ($chanid) {
        $these_channels[] = $chanid;
    } else {
        $these_channels = Channel::getChannelList();
    }
    // convert $these_channels into a string so it'll go straight into the query
    if (!count($these_channels)) {
        trigger_error("load_all_program_data() attempted with out any channels", FATAL);
    }
    $these_channels = implode(',', $these_channels);
    // Build the sql query, and execute it
    $query = 'SELECT program.*,
                         UNIX_TIMESTAMP(program.starttime) AS starttime_unix,
                         UNIX_TIMESTAMP(program.endtime) AS endtime_unix,
                         IFNULL(programrating.system, "") AS rater,
                         IFNULL(programrating.rating, "") AS rating,
                         channel.callsign,
                         channel.channum
                  FROM program USE INDEX (id_start_end)
                       LEFT JOIN programrating USING (chanid, starttime)
                       LEFT JOIN channel ON program.chanid = channel.chanid
                       LEFT JOIN credits ON (program.chanid = credits.chanid AND program.starttime = credits.starttime)
                       LEFT JOIN people ON (credits.person = people.person)
                 WHERE';
    // Only loading a single channel worth of information
    if ($chanid > 0) {
        $query .= ' program.chanid=' . $db->escape($chanid);
    } else {
        $query .= ' program.chanid IN (' . $these_channels . ')';
    }
    // Requested start time is the same as the end time - don't bother with fancy calculations
    if ($start_time == $end_time) {
        $query .= ' AND program.starttime = FROM_UNIXTIME(' . $db->escape($start_time) . ')';
    } else {
        $query .= ' AND (program.endtime > FROM_UNIXTIME(' . $db->escape($start_time) . ')' . ' AND program.starttime < FROM_UNIXTIME(' . $db->escape($end_time) . ')' . ' AND program.starttime != program.endtime)';
    }
    // The extra query, if there is one
    if ($extra_query) {
        $query .= ' AND ' . $extra_query;
    }
    // Group and sort
    if (!$distinctTitle) {
        $query .= "\nGROUP BY channel.callsign, program.chanid, program.starttime";
    } else {
        $query .= "\nGROUP BY program.title";
    }
    $query .= " ORDER BY program.starttime";
    // Limit
    if ($single_program) {
        $query .= "\n LIMIT 1";
    }
    // Query
    $sh = $db->query($query);
    // No results
    if ($sh->num_rows() < 1) {
        $sh->finish();
        return array();
    }
    // Build two separate queries for optimized selecting of recstatus
    $sh2 = $db->prepare('SELECT recstatus
                               FROM oldrecorded
                              WHERE recstatus IN (-3, 11)
                                    AND programid = ?
                                    AND seriesid  = ?
                                    AND future = 0
                             LIMIT 1');
    $sh3 = $db->prepare('SELECT recstatus
                               FROM oldrecorded
                              WHERE recstatus IN (-3, 11)
                                    AND title       = ?
                                    AND subtitle    = ?
                                    AND description = ?
                                    AND future = 0 
                             LIMIT 1');
    // Load in all of the programs (if any?)
    $these_programs = array();
    $scheduledRecordings = Schedule::findScheduled();
    while ($data = $sh->fetch_assoc()) {
        if (!$data['chanid']) {
            continue;
//.........这里部分代码省略.........