// 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];