public function index()
{
Model::load('admincp/dashboard');
$post = countStats();
// $headData=array('title'=>'Dashboard - '.ADMINCP_TITLE);
System::setTitle('Dashboard - ' . ADMINCP_TITLE);
View::make('admincp/head');
self::makeContents('dashboard', $post);
View::make('admincp/footer');
}
/**
* Shows a list of all the deputies, sorted by the percentage of presence
* in votes.
*/
function showSenatePresencePercentage($sortby, $order)
{
global $cid;
if ($sortby != 'percent' && $sortby != 'seconds' && $sortby != 'idparty' && $sortby != 'name') {
$sortby = 'percent';
}
if ($order != 'desc' && $order != 'asc') {
$order = 'asc';
if ($sortby == 'percent') {
$order = 'desc';
}
if ($sortby == 'name') {
$order = 'asc';
}
}
if ($sortby == 'idparty') {
$sortby .= ' ' . $order . ', percent';
}
$sql = "SELECT sen.id, sen.name, sen.name_diacritics, sen.idm, " . "sen.timein, sen.timeout, sen.motif, sen.idperson, " . "votes.possible, votes.percent, " . "belong.idparty, " . "cand.url as dep_url, " . "colleges.url as col_url, " . "res.winner, res.difference, res.reason, " . "agg.total, agg.college " . "FROM senat_2004_senators AS sen " . "LEFT JOIN senat_2004_votes_agg AS votes " . "ON votes.idperson = sen.idperson " . "LEFT JOIN senat_2004_belong_agg AS belong " . "ON belong.idperson = sen.idperson " . "LEFT JOIN alegeri_2008_candidates AS cand " . "ON cand.idperson = sen.idperson " . "LEFT JOIN alegeri_2008_colleges as colleges " . "ON cand.college_id = colleges.id " . "LEFT JOIN results_2008_candidates AS res on cand.name = res.nume " . "LEFT JOIN results_2008_agg AS agg ON res.college = agg.college " . "WHERE timeout = 0 " . "ORDER BY {$sortby} {$order}";
$sdep = mysql_query($sql);
$numVotes = getSenatorsNumberOfVotes();
$count = 1;
$stats = initStatsObject();
$norder = $order == 'asc' ? 'desc' : 'asc';
?>
<table class=bigtable width=900>
<tr class=header><td></td><td>
<a href=?cid=<?php
echo $cid;
?>
&sort=name&order=<?php
echo $norder;
?>
>Senator</a></td>
<td>
<a href=?cid=<?php
echo $cid;
?>
&sort=percent&order=<?php
echo $norder;
?>
>Procent de voturi<br>la care a fost prezent</a>
<br>începând cu Sep 2007</td>
<td>
<a href=?cid=<?php
echo $cid;
?>
&sort=idparty&order=<?php
echo $norder;
?>
>Partid</a></td>
<td>Reales</td></tr>
<?php
while ($rdep = mysql_fetch_array($sdep)) {
echo "<tr>";
echo "<td align=right>" . $count++ . ".</td>";
echo "<td> " . "<a href=\"?cid=9&id=" . $rdep['idperson'] . "\">" . $rdep['name_diacritics'] . "</a>";
// ----------------- now print the times in office, if need be
// ------------------ vote percentages
$timein = $rdep['timein'] / 1000;
$timeout = $rdep['timeout'] / 1000;
echo "<br><span class=\"small gray\">";
// 1076994000 = 17 dec 2004
if ($timein != 1076994000 || $timeout != 0) {
echo date("M Y", $timein) . " - " . ($timeout == 0 ? 'prezent' : date("M Y", $timeout));
echo $rdep['motif'] != "" ? "(" . $rdep['motif'] . ")" : "";
}
echo getEuroParliamentString($rdep['id'], 1);
echo "</span></td>";
$sum = $rdep['possible'] * $rdep['percent'];
$candidateVotes = $rdep['possible'];
$percent = $rdep['percent'];
$class = "blacktext";
if ($percent < 0.5) {
$class = "red";
}
if ($percent < 0.3) {
$class = "brightred";
}
echo "<td><span class={$class}>" . floor(10000 * $percent) / 100 . " %</span>";
if ($candidateVotes != $numVotes) {
echo "<br><span class=\"small gray\"> din " . $candidateVotes . " voturi</span>";
if ($awayVotes != 0) {
echo "<br>Pentru {$awayVotes} a fost europarlamentar";
}
echo "</td>";
}
echo "<td>";
$parties = getPartiesForSenator($rdep['id']);
echo getPartyName($parties[0]['name']);
if (sizeof($parties) > 1) {
echo '<br><span class="gray small">';
for ($i = 1; $i < sizeof($parties); $i++) {
echo "<b>" . getPartyName($parties[$i]['name']) . "</b> până în " . date("M Y", $parties[$i]['t'] / 1000);
if ($i != sizeof($parties) - 1) {
echo "<br>";
}
}
echo '</span>';
}
echo "</td>";
echo "<td>" . getReElectedString($rdep) . "</td>";
echo "</tr>";
$stats = countStats($stats, $rdep, $percent);
}
echo "</table>";
printStats($stats);
}
