video_front_page()

Complexity

Conditions	17
Paths	3456

Size

Total Lines	109
Code Lines	83

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
function video_front_page() {
    $db = new ParlDB;
    $statuses = array(

The assignment to $statuses is dead and can be removed.

        0 => 'Unstamped',
        4 => 'Timestamped by users',
    );
    $q = $db->query('select video_status&4 as checked,count(*) as c from hansard
    where major=1 and video_status>0 and video_status<8 and video_status!=2 and htype in (12,13) group by video_status&4');
    $totaliser = array(0=>0, 4=>0);
    for ($i=0; $i<$q->rows(); $i++) {
        $status = $q->field($i, 'checked');
        $count = $q->field($i, 'c');
        $totaliser[$status] = $count;
    }
    $percentage = round($totaliser[4] / ($totaliser[0]+$totaliser[4]) * 10000) / 100;
    $out = "$totaliser[4] timestamped out of " . ($totaliser[0] + $totaliser[4]) . " ($percentage%)"
?>

<p style="margin-top:1em"><big>TheyWorkForYou has video of the House of Commons from the BBC, and
the text of Hansard from Parliament. Now we need <strong>your</strong>
help to match up the two.</big></p>

<p>We've written a little Flash app where you can (hopefully) match up the written speech being displayed to
what's playing on the video. We'll then store your results and use them to put the video,
timestamped to the right location, on the relevant page of TheyWorkForYou.</p>

<p>If you're a registered user and logged in,
your timestampings will appear in our chart below &ndash; there may be prizes for best timestampers&hellip; :)
Registration is not needed to timestamp videos, but you can <a href="/user/?pg=join&ret=/video/">register here</a> if you want.</p>

<p id="video_attract"><?php
    if ($totaliser[0]) {
        echo '<a href="next.php?action=random">Give me a random speech that needs timestamping</a>';
    } else {
        echo 'Wow, everything that can currently be timestamped appears to have been, thanks!';
    }
?></p>

<div id="top" style="float: left; width: 45%;">
<?php

    list($out_today, $rank_today) = display_league(20, 'and date(whenstamped)=current_date');
    list($out_week, $rank_week) = display_league(40, 'and date(whenstamped)>current_date-interval 28 day');
    list($out_overall, $rank_overall) = display_league(100);
    $out_overall = '';

    global $THEUSER;

Use of global functionality is not recommended; it makes your code harder to test, and less reusable.

    if ($THEUSER->user_id() && ($rank_today || $rank_week || $rank_overall)) {
        echo '<p align="center"><big>You are ';
        if ($rank_today) echo make_ranking($rank_today), ' today, ';
        if ($rank_week) echo make_ranking($rank_week), ' last 4 weeks, ';
        if ($rank_overall) echo make_ranking($rank_overall), ' overall';
        echo '</big></p>';
    }
    if ($out_today) echo "<h3>Top timestampers (today)</h3> <ol>$out_today</ol>";
    if ($out_week) echo "<h3>Top timestampers (last 4 weeks)</h3> <ol>$out_week</ol>";
    if ($out_overall) echo "<h3>Top timestampers (overall)</h3> <ol>$out_overall</ol>";
    echo '</div>';
?>
<div style="float: right; width: 50%">
<img align="right" width=200 height=100 src="http://chart.apis.google.com/chart?chs=200x100&cht=gom&chd=t:<?=$percentage?>" alt="<?=$percentage?>% of speeches have been timestamped">
<h3>Totaliser</h3>
<ul><?=$out?></ul>

<?php
    $q = $db->query('select video_status&4 as checked,count(*) as c from hansard
    where major=1 and video_status>0 and video_status<8 and video_status!=2 and htype in (12,13)
        and hdate=(select max(hdate) from hansard where major=1)
    group by video_status&4');
    $totaliser = array(0=>0, 4=>0);
    for ($i=0; $i<$q->rows(); $i++) {
        $status = $q->field($i, 'checked');
        $count = $q->field($i, 'c');
        $totaliser[$status] = $count;
    }
    $total_possible = $totaliser[0] + $totaliser[4];
    if ($total_possible == 0) {
        $percentage = 0;
        $out = 'Nothing possible to timestamp on most recent day';
    } else {
        $percentage = round($totaliser[4] / $total_possible * 10000) / 100;
        $out = "$totaliser[4] timestamped out of $total_possible ($percentage%)";
    }

?>
<h3 style="padding-top:0.5em;clear:right">Totaliser for most recent day</h3>
<img align="right" width=200 height=100 src="http://chart.apis.google.com/chart?chs=200x100&cht=gom&chd=t:<?=$percentage?>" alt="<?=$percentage?>% of speeches have been timestamped">
<ul><?=$out?></ul>

<h3 style="clear:both;margin-top:1em">Latest stamped</h3>
<ul>
<?php

    $q = $db->query('select hansard.gid, body, major from video_timestamps, hansard, epobject
    where (user_id != -1 or user_id is null) and video_timestamps.deleted=0
        and video_timestamps.gid = hansard.gid and hansard.subsection_id = epobject.epobject_id
    order by whenstamped desc limit 20');
    for ($i=0; $i<$q->rows(); $i++) {
        $gid = $q->field($i, 'gid');
        $body = $q->field($i, 'body');
        if ($q->field($i, 'major') == 101) {
            $url = '/lords/?gid=';
        } else {
            $url = '/debate/?id=';
        }
        echo '<li><a href="', $url, fix_gid_from_db($gid) . '">' . $body . '</a>';
    }

    echo '</ul></div>';
}