Ejemplo n.º 1
0
function creerTournoi($nbPairByGroup, $idTournament, $pluie, $dbh)
{
    // var_dump($nbPairByGroup);
    // var_dump($idTournament);
    // var_dump($pluie);
    // echo "-----------------players    ";
    $players = getSoloPlayers($idTournament, $dbh);
    // print_r(count($players));
    // echo "-----------------pairs    ";
    $pairs = makingPair($players);
    // print_r(count($pairs));
    // echo "-----------------insert    ";
    insertPairs(transformPairsToDb($pairs, $idTournament, $dbh), $dbh);
    // echo "-----------------cours :    ";
    $cours = getAllCourts($idTournament, $pluie, $dbh);
    // print_r(count($cours));
    // echo "-----------------pairs :    ";
    $pairs = getPairs($idTournament, $dbh);
    // print_r(count($pairs));
    // echo "-----------------groups :    ";
    $nbGroup = 0;
    //n-1
    $group = [];
    while (!empty($pairs)) {
        // echo "[GROUP START NUM=".$nbGroup."]";
        // echo "pairs = ".count($pairs);
        $group[$nbGroup]['pairs'] = getXPairByRank($pairs, array_shift($pairs), $nbPairByGroup);
        $group[$nbGroup]['leader'] = getLeaderOfGroup($group[$nbGroup]['pairs']);
        // echo "COUNT___________".count($group[$nbGroup]['pairs'])."__________COUNT";
        // var_dump($group[$nbGroup]['pairs']);
        //var_dump($group[$nbGroup]['leader']);
        // echo "pairs = ".count($pairs);
        $key = array_search($group[$nbGroup]['pairs'][1], $pairs);
        unset($pairs[$key]);
        /*foreach ($group[$nbGroup]['pairs'] as $p) {
            $key = array_search($p, $pairs);
            unset($pairs[$key]);
          }*/
        // echo "pairs = ".count($pairs);
        // echo "[GROUP END NUM = ".$nbGroup."]";
        $nbGroup++;
    }
    // var_dump(count($group));
    // die('GROUPS');
    // echo "-----------------groups and cours :    ";
    set_time_limit(0);
    foreach ($group as $k => $g) {
        $courtTmp = getNearCours($cours, $g['pairs'], $dbh);
        $key = array_search($courtTmp, $cours);
        unset($cours[$key]);
        $group[$k]['court_fk'] = $courtTmp;
        $groupTmp = ['court_fk' => $courtTmp['idcourts'], 'tournament_fk' => $idTournament];
        if (!is_null($g['leader'])) {
            $groupTmp['leader'] = $g['leader'];
        }
        $idGroup = insertGroup($groupTmp, $dbh);
        $group[$k]['group_id'] = $idGroup;
        foreach ($g['pairs'] as $kPair => $valuePair) {
            addGroupFkPair($valuePair['idpairs'], $idGroup, $dbh);
            $group[$k]['pairs'][$kPair]['joueur1'] = getPlayerById($valuePair['user_j1_fk'], $dbh);
            $group[$k]['pairs'][$kPair]['joueur2'] = getPlayerById($valuePair['user_j2_fk'], $dbh);
        }
    }
    return $group;
}
Ejemplo n.º 2
0
            <h2>Частота выпадения одиночных чисел</h2>
            <?php 
foreach (getHighest(count($data), $data) as $num => $counts) {
    ?>
                <span>Число <strong><?php 
    echo $num;
    ?>
</strong> выпадало <i><?php 
    echo $counts;
    ?>
</i> раз</span><br>
            <?php 
}
?>
            <h2>Частота выпадения пар чисел</h2>
            <?php 
foreach (getPairs(count($data), $data) as $num => $counts) {
    ?>
                <span>Пара <strong><?php 
    echo $num;
    ?>
</strong> выпадало <i><?php 
    echo $counts;
    ?>
</i> раз</span><br>
            <?php 
}
?>
        </div>
    </body>
</html>
Ejemplo n.º 3
0
        $sql = getFrequencyInSystem($_GET["startDate"], $_GET["endDate"], $_GET["numberType"], $_GET["systemNumber"]);
        break;
    case "jackpotPerYear":
        $sql = getJackpotPerYear();
        break;
    case "mostCommonNumbers":
        $sql = getMostCommonNumbers($_GET["numRows"]);
        break;
    case "threeRuns":
        $sql = getThreeRuns($_GET["numRows"]);
        break;
    case "fourRuns":
        $sql = getFourRuns();
        break;
    case "pairs":
        $sql = getPairs($_GET["numRows"]);
        break;
    case "triplets":
        $sql = getTriplets($_GET["numRows"]);
        break;
    case "percentEvenOdd":
        $sql = getpercentEvenOdd();
        break;
    case "allEvenOrOdd":
        $sql = getAllEvenOrOdd();
        break;
    case "getTotalTuples":
        $sql = getTotalTuples();
        break;
}
//Run statement