PHP currentRound Examples

Example #1

File: teamRanking.php Project: audric-perrin/siteParisFoot

function getRankingL1($type)
{
    $roundLimit = 0;
    if ($type == 'realTime') {
        $roundLimit = currentRound();
    } else {
        if ($type == 'delayed') {
            $roundLimit = currentRound() - 1;
        }
    }
    $rankingL1 = array();
    $currentSaison = currentSaison();
    $result = runQuery('
      SELECT * FROM result WHERE scoreDomicile >= 0 && round <= ' . $roundLimit . ' && saison = "' . $currentSaison . '"
    ');
    foreach ($result as $row) {
        $round = intval($row['round']);
        $teamDomicile = $row['teamDomicile'];
        $teamExterieur = $row['teamExterieur'];
        $scoreDomicile = intval($row['scoreDomicile']);
        $scoreExterieur = intval($row['scoreExterieur']);
        if (!isset($rankingL1[$teamDomicile])) {
            $rankingL1[$teamDomicile] = ['name' => $row['teamDomicile'], 'round' => 0, 'win' => 0, 'equality' => 0, 'loose' => 0, 'bp' => 0, 'bc' => 0, 'difference' => 0, 'points' => 0];
        }
        if (!isset($rankingL1[$teamExterieur])) {
            $rankingL1[$teamExterieur] = ['name' => $row['teamExterieur'], 'round' => 0, 'win' => 0, 'equality' => 0, 'loose' => 0, 'bp' => 0, 'bc' => 0, 'difference' => 0, 'points' => 0];
        }
        $rankingL1[$teamDomicile]['round']++;
        $rankingL1[$teamExterieur]['round']++;
        if ($scoreDomicile > $scoreExterieur) {
            $rankingL1[$teamDomicile]['win']++;
            $rankingL1[$teamDomicile]['points'] = $rankingL1[$teamDomicile]['points'] + 3;
            $rankingL1[$teamExterieur]['loose']++;
        } else {
            if ($scoreDomicile < $scoreExterieur) {
                $rankingL1[$teamExterieur]['win']++;
                $rankingL1[$teamExterieur]['points'] = $rankingL1[$teamExterieur]['points'] + 3;
                $rankingL1[$teamDomicile]['loose']++;
            } else {
                $rankingL1[$teamDomicile]['equality']++;
                $rankingL1[$teamDomicile]['points']++;
                $rankingL1[$teamExterieur]['equality']++;
                $rankingL1[$teamExterieur]['points']++;
            }
        }
        $rankingL1[$teamDomicile]['bp'] = $rankingL1[$teamDomicile]['bp'] + $scoreDomicile;
        $rankingL1[$teamDomicile]['bc'] = $rankingL1[$teamDomicile]['bc'] + $scoreExterieur;
        $rankingL1[$teamExterieur]['bp'] = $rankingL1[$teamExterieur]['bp'] + $scoreExterieur;
        $rankingL1[$teamExterieur]['bc'] = $rankingL1[$teamExterieur]['bc'] + $scoreDomicile;
    }
    $ranking = array();
    foreach ($rankingL1 as $team => $row) {
        $rankingL1[$team]['difference'] = $row['bp'] - $row['bc'];
        $ranking[] = $rankingL1[$team];
    }
    usort($ranking, 'compareTeam');
    $index = 0;
    foreach ($ranking as $index => $row) {
        $ranking[$index]['rank'] = $index + 1;
    }
    return $rankingL1 = array('rankingL1' => $ranking);
}

Example #2

File: listSaison.php Project: audric-perrin/siteParisFoot

<?php

require_once '../api/requireConnected.php';
header('Content-Type: application/json');
require_once '../php/sql.php';
require_once '../api/lag.php';
require_once '../lib/general.php';
$currentMonth = currentMonth();
$currentRound = currentRound();
//Selection des classements par saison
$saison = array();
$result = runQuery('SELECT DISTINCT saison FROM result');
foreach ($result as $row) {
    $saison[] = array('label' => 'Saison ' . $row['saison'], 'value' => $row['saison']);
}
echo json_encode(array('saison' => $saison));