1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / nc6d095 / sports.nisan.space / view /
Filename : country-leagues.php
back
<?php
include("../admin/inc/config.php");
include("../inc/auth.php");

$hd = $ac = $hcl = $acl = 0; $clubData = $lgAPIs = [];
$index = $recordCnt = 0;

if(isset($_POST['loadLeagues'])){
    $cId = trim(intval($_POST['country']));
    $cName = getDBVal('countries',$cId);

    $q = dbSelect('leagues',"apiID","country=$cId","level");
    while($row = mysqli_fetch_assoc($q)){
        $apiID = json_decode($row['apiID'],true);
        $lgAPIs[] = $apiID;
    }
}


define("TITLE", "$cName Leagues | Explore League Stats: Your Search Results");
define("HEADER", "$cName Leagues");
const OVERVIEW = "";
const BREADCRUMB = "league-stats";
$pgView = 'league-stats';


include("../inc/head.php");
?>

<body>
    <div class="content-wrapper">
        <?php include("../inc/header.php"); ?>
        <!-- /header -->

        <?php include("../inc/page-header.php"); ?>
        <!-- /page-header -->

        <section class="wrapper bg-light">
            <div class="container-fluid py-10 py-md-12">
                <div class="row gy-3">
                    <div class="col-lg-12">
                        <div class="row gy-3">
                            <form action="<?= $mainRoot ?>leagues" method="post">
                                <div class="card">
                                    <div class="card-body">
                                        <h5 class="card-title">Country Filter</h5>
                                        <div class="row g-3">
                                            <div class="col-md-4">
                                                <div class="form-floating">
                                                    <select class="form-select select-adv" id="country" name="country">
                                                        <option value="">--select--</option>
                                                        <?php
                                                        $q = dbSelect("countries", "*", null, "name");
                                                        while($row = mysqli_fetch_assoc($q)){
                                                            ?>
                                                            <option <?php if($cId > 0 && $cId == $row['id']){ echo 'selected'; }  ?> value="<?= $row['id'] ?>"><?= $row['name'] ?></option>
                                                        <?php } ?>
                                                    </select>
                                                    <label for="country" class="form-label">Country</label>
                                                </div>
                                            </div>
                                            <div class="col-md-3">
                                                <button type="submit" class="btn btn-outline-primary btn-icon btn-icon-start w-100 text-uppercase fs-20 searchBtn" name="loadLeagues"><i class="uil uil-chart-growth-alt"></i>Show Stats</button>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </form>
                            <div class="card shadow border-0 col-md-12">
                                <div class="card-body overflow-x-auto">
                                    <div class="row g-3">
                                        <?php if(isset($lgAPIs) && count($lgAPIs) > 0): ?>
                                            <div class="col-md-12">
                                                <div class="row gy-5">
                                                    <div class="col-md-6">
                                                        <div class="card">
                                                            <div class="card-body">
                                                                <h5 class="card-title">Home Team</h5>
                                                                <div class="form-floating">
                                                                    <select class="form-select select-adv" id="homeClub" name="homeClub" onChange="getHArchive(this.value);">
                                                                        <?php
                                                                            $q = dbSelect("clubs","*", "country=$cId");
                                                                            while($row = mysqli_fetch_assoc($q)){
                                                                                ?>
                                                                                <option <?php if($hcl == $row['id']){ echo 'selected'; } ?> value="<?= $row['id'] ?>"><?= $row['name'] ?></option>
                                                                            <?php } ?>
                                                                    </select>
                                                                    <label for="homeClub" class="form-label">Club</label>
                                                                </div>
                                                                <div class="table-responsive">
                                                                    <table class="table table-striped">
                                                                        <tbody id="homeClubBox"></tbody>
                                                                    </table>
                                                                </div>
                                                            </div>
                                                        </div>
                                                    </div>
                                                    <div class="col-md-6">
                                                        <div class="card">
                                                            <div class="card-body">
                                                                <h5 class="card-title">Away Team</h5>
                                                                <div class="form-floating">
                                                                    <select class="form-select select-adv" id="awayClub" name="awayClub" onChange="getAArchive(this.value);">
                                                                        <?php
                                                                            $q = dbSelect("clubs","*", "country=$cId");
                                                                            while($row = mysqli_fetch_assoc($q)){
                                                                                ?>
                                                                                <option <?php if($hcl == $row['id']){ echo 'selected'; } ?> value="<?= $row['id'] ?>"><?= $row['name'] ?></option>
                                                                            <?php } ?>
                                                                    </select>
                                                                    <label for="awayClub" class="form-label">Club</label>
                                                                </div>
                                                                <div class="table-responsive">
                                                                    <table class="table table-striped">
                                                                        <tbody id="awayClubBox"></tbody>
                                                                    </table>
                                                                </div>
                                                            </div>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                            <div class="col-md-12">
                                                <div class="accordion accordion-wrapper" id="leagueStanding">
                                                    <?php
                                                        foreach($lgAPIs as $api):
                                                            foreach($api as $apiID):
                                                                include "../inc/api/football-standings.php";
                                                                $leagueData = $data['response'][0];
                                                        ?>
                                                        <div class="card accordion-item icon">
                                                            <div class="card-header" id="lsHeading<?= $apiID ?>">
                                                                <button class="collapsed" data-bs-toggle="collapse" data-bs-target="#lsStandingTeams<?= $apiID ?>" aria-expanded="false" aria-controls="lsStandingTeams<?= $apiID ?>"><span><img src="<?= $leagueData['league']['logo'] ?>" alt="" width="20"></span><?= $leagueData['league']['name'] ?></button>
                                                            </div>
                                                            <!--/.card-header -->
                                                            <div id="lsStandingTeams<?= $apiID ?>" class="accordion-collapse collapse" aria-labelledby="lsHeading<?= $apiID ?>" data-bs-parent="#leagueStanding">
                                                                <div class="card-body">
                                                                    <div class="table-responsive">
                                                                        <table class="table">
                                                                            <thead>
                                                                            <tr>
                                                                                <th>P</th>
                                                                                <th>Team</th>
                                                                                <th>Form</th>
                                                                                <th class="bg-primary text-white">S</th>
                                                                                <th>M</th>
                                                                                <th>W</th>
                                                                                <th>X</th>
                                                                                <th>L</th>
                                                                                <th>GD</th>
                                                                                <th>PTS</th>
                                                                                <th class="bg-primary text-white">HS</th>
                                                                                <th class="bg-soft-green">HM</th>
                                                                                <th class="bg-soft-green">HW</th>
                                                                                <th class="bg-soft-green">HX</th>
                                                                                <th class="bg-soft-green">HL</th>
                                                                                <th class="bg-soft-green">HGD</th>
                                                                                <th class="bg-soft-green">PTS</th>
                                                                                <th class="bg-primary text-white">AS</th>
                                                                                <th class="bg-soft-red">AM</th>
                                                                                <th class="bg-soft-red">AW</th>
                                                                                <th class="bg-soft-red">AX</th>
                                                                                <th class="bg-soft-red">AL</th>
                                                                                <th class="bg-soft-red">AGD</th>
                                                                                <th class="bg-soft-red">PTS</th>
                                                                            </tr>
                                                                            </thead>
                                                                            <tbody>
                                                                            <?php foreach($leagueData['league']['standings'][0] as $lData):
                                                                                $tm = $lData['all']['played']; $tw = $lData['all']['win']; $td = $lData['all']['draw']; $tl = $lData['all']['lose']; $tGf = $lData['all']['goals']['for']; $tGa = $lData['all']['goals']['against'];
                                                                                $hTm = $lData['home']['played']; $hTw = $lData['home']['win']; $hTd = $lData['home']['draw']; $hTl = $lData['home']['lose']; $hGf = $lData['home']['goals']['for']; $hGa = $lData['home']['goals']['against'];
                                                                                $aTm = $lData['away']['played']; $aTw = $lData['away']['win']; $aTd = $lData['away']['draw']; $aTl = $lData['away']['lose']; $aGf = $lData['away']['goals']['for']; $aGa = $lData['away']['goals']['against'];
                                                                                $maxP = $tm * 3;
                                                                                $maxHP = $hTm * 3;
                                                                                $maxAP = $aTm * 3;
                                                                                $hGd = $hGf - $hGa;
                                                                                $aGd = $aGf - $aGa;
                                                                                $tGd = $tGf - $tGa;
                                                                                $hWc = percentageVal($hTw, $hTm);
                                                                                $aWc = percentageVal($aTw, $aTm);
                                                                                $tWc = percentageVal($tw, $tm);
                                                                                $hXc = percentageVal($hTw + $hTd, $hTm);
                                                                                $aXc = percentageVal($aTw + $aTd, $aTm);
                                                                                $tXc = percentageVal($tw + $td, $tm);
                                                                                $hLc = percentageVal($hTl, $hTm);
                                                                                $aLc = percentageVal($aTl, $aTm);
                                                                                $tLc = percentageVal($tl, $tm);
                                                                                $hP = ($hTw * 3) + $hTd;
                                                                                $aP = ($aTw * 3) + $aTd;
                                                                                $tP = ($tw * 3) + $td;
                                                                                ?>
                                                                                <tr>
                                                                                    <td class="fw-bolder"><?= $lData['rank'] ?></td>
                                                                                    <td class="fw-bolder"><?= $lData['team']['name'] ?></td>
                                                                                    <td>
                                                                                        <?php
                                                                                        foreach(array_reverse(str_split($lData['form'])) as $formInfo){
                                                                                            if($formInfo == "W"){
                                                                                                echo "<strong class='text-green mx-1'>".$formInfo."</strong>";
                                                                                            }
                                                                                            elseif($formInfo == "D"){
                                                                                                echo "<strong class='text-ash mx-1'>".$formInfo."</strong>";
                                                                                            }
                                                                                            elseif($formInfo == "L"){
                                                                                                echo "<strong class='text-red mx-1'>".$formInfo."</strong>";
                                                                                            }
                                                                                        }
                                                                                        ?>
                                                                                    </td>
                                                                                    <td class="bg-primary text-white fw-bolder"><?= getPercentage($tP, $maxP) ?></td>
                                                                                    <td class="fw-bolder"><?= $tm ?></td>
                                                                                    <td class="text-green fw-bolder"><?= $tWc."%" ?></td>
                                                                                    <td class="text-ash fw-bolder"><?= $tXc."%" ?></td>
                                                                                    <td class="text-red fw-bolder"><?= $tLc."%" ?></td>
                                                                                    <td class="text-<?= ($tGd > 0) ? "green" : "red" ?> fw-bolder"><?= $tGd ?></td>
                                                                                    <td class="fw-bolder text-grape"><?= $tP ?></td>
                                                                                    <td class="bg-primary text-white fw-bolder"><?= getPercentage($hP, $maxHP) ?></td>
                                                                                    <td class="bg-soft-green fw-bolder"><?= $hTm ?></td>
                                                                                    <td class="bg-soft-green text-green fw-bolder"><?= $hWc."%" ?></td>
                                                                                    <td class="bg-soft-green text-ash fw-bolder"><?= $hXc."%" ?></td>
                                                                                    <td class="bg-soft-green text-red fw-bolder"><?= $hLc."%" ?></td>
                                                                                    <td class="bg-soft-green text-<?= ($hGd > 0) ? "green" : "red" ?> fw-bolder"><?= $hGd ?></td>
                                                                                    <td class="bg-soft-green fw-bolder text-grape"><?= $hP ?></td>
                                                                                    <td class="bg-primary text-white fw-bolder"><?= getPercentage($aP, $maxAP) ?></td>
                                                                                    <td class="bg-soft-red fw-bolder"><?= $aTm ?></td>
                                                                                    <td class="bg-soft-red text-green fw-bolder"><?= $aWc."%" ?></td>
                                                                                    <td class="bg-soft-red text-ash fw-bolder"><?= $aXc."%" ?></td>
                                                                                    <td class="bg-soft-red text-red fw-bolder"><?= $aLc."%" ?></td>
                                                                                    <td class="bg-soft-red text-<?= ($aGd > 0) ? "green" : "red" ?> fw-bolder"><?= $aGd ?></td>
                                                                                    <td class="bg-soft-red fw-bolder text-grape"><?= $aP ?></td>
                                                                                </tr>
                                                                            <?php endforeach ?>
                                                                            </tbody>
                                                                        </table>
                                                                    </div>
                                                                </div>
                                                                <!--/.card-body -->
                                                            </div>
                                                            <!--/.accordion-collapse -->
                                                        </div>
                                                        <!--/.accordion-item -->
                                                    <?php endforeach; endforeach; endif ?>
                                                </div>
                                                <!--/.accordion -->
                                            </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            <!-- /.container -->
        </section>
        <!-- /section -->


        <?php include("../inc/footer.php"); ?>

        <?php  include("../inc/foot.php"); ?>