// Define the entry point
$(document).ready(function() {
var min=2010;
var max=2014;
var datos=[];
<?php
$min = 2010;
$max = 2014;
$filas = get_users_have_voted($bd);
foreach ($filas as $user_id) {
$data = "[";
for ($i = $min; $i <= $max; $i++) {
if ($i > $min) {
$data = $data . ",";
}
$data = $data . "[{$i}," . count_wins_by_user($bd, $user_id, $i) . "]";
}
$data = $data . "]";
//echo "datos['$user_id']=$data;\r\n";
?>
datos.push(<?php
echo $data;
?>
);
<?php
}
?>
var chartObj=$.jqplot('chartdiv', datos,
{axesDefaults:{pad:2},
axes:{xaxis:{min:min, max:max,numberTicks:4},yaxis:{min:0, max:20,numberTicks:5}},
seriesDefaults: {
var chartObj=$.jqplot('chartdiv', [<?php
$min = 2010;
$max = 2013;
$filas = get_users_have_voted($bd);
$first = true;
foreach ($filas as $user_id) {
if (!$first) {
echo ",";
}
$first = false;
echo "[";
for ($i = $min; $i < $max; $i++) {
if ($i > $min) {
echo ",";
}
echo "[{$i}," . count_wins_by_user($bd, $user_id, $i) . "]";
}
echo "]";
}
?>
],
{axesDefaults:{pad:2},
axes:{xaxis:{min:min, max:max,numberTicks:4},yaxis:{min:0, max:20,numberTicks:5}},
seriesDefaults: {
pointLabels: { show:true }
}
});
coloreaUsuarios();
registraClicks();
});
function coloreaUsuarios(){
$c = $bd->prepare("SELECT distinct user_id FROM votes WHERE year=" . $year . " ORDER BY user_id");
//$c=$bd->prepare("SELECT distinct userid FROM users");
$c->execute();
while ($f = $c->fetch()) {
$user_id = $f[0];
$user = $facebook->api($user_id);
$username = utf8_decode($user["name"]);
//echo "<td><span class=\"css-vertical-text\">$user</span></td>";
$column_class = "class='no_yo'";
//echo "Usuario actual:$user_id(".$user['id']."), Mi usuario: ".$me['id']."<br>";
if ($user_id == $myId) {
$column_class = "class='yo'";
}
echo "<td {$column_class} style='text-align:center;'>";
//if($user_id=='cris.f.orellana'){
echo "<span style='font-size:17px;margin-bottom:2px;'>" . count_wins_by_user($bd, $user_id, $year) . "</span>";
echo "<br><img src='https://graph.facebook.com/{$user_id}/picture' title='{$username}' alt='{$username}]'>";
//}else{
// echo $user_id;
//}
echo "</td>";
}
echo "</tr>";
$sql = "SELECT id,name,display_function,vote_extractor FROM CATEGORIES_YEAR,CATEGORIES WHERE CATEGORIES_YEAR.category_id=CATEGORIES.id AND CATEGORIES_YEAR.year=" . $year;
$consulta = $bd->prepare($sql);
$consulta->execute();
//$error=$bd->errorInfo();
//echo "Error ".$error[2];
while ($fila = $consulta->fetch()) {
$categoria = utf8_decode($fila[1]);
$funcion = $fila[2];
