/**
* Show the league ranking as widget.
*
* @param integer $id_league
* @return string
*/
public function widget_ranking_table($id_league)
{
global $wpdb;
$db = new PHPLeague_Database();
// League not found in the database
if ($db->is_league_exists($id_league) === FALSE) {
return;
}
$setting = $db->get_league_settings($id_league);
$nb_teams = (int) $setting->nb_teams;
$favorite = (int) $setting->id_favorite;
$output = '<table id="phpleague"><thead><tr>
<th class="centered">' . __('Pos', 'phpleague') . '</th>
<th>' . __('Team', 'phpleague') . '</th>
<th class="centered">' . __('Pts', 'phpleague') . '</th>
<th class="centered">' . __('P', 'phpleague') . '</th>
<th class="centered">' . __('+/-', 'phpleague') . '</th></tr></thead><tbody>';
$place = 1;
foreach ($db->get_league_table_data('general', $id_league, $nb_teams) as $row) {
if ($place <= $nb_teams) {
if ($favorite == $row->id_team) {
$output .= '<tr class="id-favorite">';
} else {
$output .= '<tr>';
}
$points = (int) $row->points;
$played = (int) $row->played;
$diff = (int) $row->diff;
$output .= '<td class="centered">' . $place . '</td>';
$output .= '<td>' . esc_html($row->club_name) . '</td>';
$output .= '<td class="centered">' . $points . '</td>';
$output .= '<td class="centered">' . $played . '</td>';
$output .= '<td class="centered">' . $diff . '</td></tr>';
$place++;
}
}
$output .= '</tbody></table>';
return $output;
}
