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); }