1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / nc6d095 / betstrength.com / admin / view /
Filename : volleyball-clubs.php
back
<?php
include('../inc/config.php');
include('../inc/auth.php');

$tinyEditor = "bare";

const TITLE = 'Manage Volleyball Clubs';
const HEADER = 'Volleyball Clubs';
const BREADCRUMB = 'volleyball-clubs';

if(isset($_GET['d'])){
    $d = $_GET['d'];
    if($d == "new-club"){ $crdTitle = "Add New Club"; }
    if($d == "edit-club"){
        if(isset($_GET['id'])){ $id = $_GET['id']; }
        $dbClub = getDBVal('volleyball_clubs',$id);
        $dbStadium = getDBVal('volleyball_clubs',$id,"stadium");
        $dbCountry = getDBVal('volleyball_clubs',$id,"country");
        $crdTitle = "Edit Club (<small>".strtolower($dbClub).")</small>";
    }
}

#logics
#show clubs
if(isset($_GET['c'])){
    if(!$_GET['c'] > 0){
        $emsg = "you must select a country to see the clubs";
    }
    else{
        $country = trim(intval($_GET['c']));
        $co = getDBVal('countries', $country,'continent');
    }
}


#save club
if(isset($_POST['saveClub'])){
    if(isset($country)){
        #data cleaning & scrutinization
        $club = trim(stripslashes(mysqli_real_escape_string($db, $_POST['club'])));
        if(empty($club)){ $errs[] = $clubErr = "required"; }
        if($country < 1){ $errs[] = $countryErr = ""; $emsg = "no country selected"; }
        if(!empty($club)){
            $rowCnt = checkDuplicates('volleyball_clubs', "name='$club' AND country=$country");
            if($rowCnt > 0){
                $errs[] = $clubExistErr = "";
                $emsg = "Club '$club' already exists";
            }
        }
        if(count($errs) == 0){
            $q = dbInsert("volleyball_clubs", ['name' => $club, 'country' => $country, 'dc' => $now]);
            if($q){
                $smsg = "Club '$club' saved successfully";
                $preventResubmission = true;
            }
            else{
               $emsg = "Action not successful. Try again later";
            }
        }
    }
    else{
        $emsg = "No country selected";
    }
}

#update club
if(isset($_POST['updateClub'])){
    $clubName = trim(stripslashes(mysqli_real_escape_string($db, $_POST['clubName'])));
    $clubId = trim(intval($_POST['clubId']));
    if(empty($clubName)){ $errs[] = $clubNameErr = ""; $emsg = "name required"; }
    else{
        $rowCnt = checkDuplicates('volleyball_clubs', "name='$clubName' AND country=$country AND id<>$clubId");
        $rowCnt2 = checkDuplicates('volleyball_clubs', "name='$clubName' AND country=$country AND id=$clubId");
        if($rowCnt > 0){
            $errs[] = $clubExistErr = "";
            $emsg = "Club '$clubName' already exists";
        }
        if($rowCnt2 > 0){
            $errs[] = $clubExistErr = "";
            $emsg = "Modification is required to continue";
        }
    }
    if(count($errs) == 0){
        $dbClubName = getDBVal('volleyball_clubs',$clubId);
        $q = dbUpdate("volleyball_clubs",['name'=>$clubName, 'du'=>$now],"id=".$clubId);
        if($q){
            $smsg = "'$dbClubName' updated to '$clubName' successfully";
            $preventResubmission = true;
        }
        else{
           $emsg = "Action not successful. Try again later";
        }
    }
}

#update club
if(isset($_POST['updateCountry'])){
    $country = trim(intval($_POST['country']));
    if($country == 0){ $errs[] = $countryErr = "required"; }
    else{
        $rowCnt = checkDuplicates('volleyball_clubs', "country=$country AND id=$id");
        if($rowCnt > 0){
            $errs[] = $clubExistErr = "";
            $emsg = "Modification is required to continue";
        }
    }
    if(count($errs) == 0){
        $q = dbUpdate("volleyball_clubs",['country'=>$country, 'du'=>$now],"id=".$id);
        if($q){
            $smsg = "country for '$dbClub' updated successfully";
            $preventResubmission = true;
        }
        else{
           $emsg = "Action not successful. Try again later";
        }
    }
}

#manage club status
if(isset($_GET['d']) && isset($_GET['id'])){
    $d = $_GET['d'];
    $id = $_GET['id'];
    $dbClub = getDBVal('volleyball_clubs',$id);
    if($d == 'actv-club'  && checkInactive('volleyball_clubs',$id) == true){
        $q = changeStatus('volleyball_clubs','active',$id);
        if($q){ $smsg = "club '$dbClub' activated successfully"; }else{ $emsg = "something went wrong."; }
    }
    if($d == 'dactv-club'  && checkActive('volleyball_clubs',$id) == true){
        $q = changeStatus('volleyball_clubs','inactive',$id);
        if($q){ $smsg = "club '$dbClub' deactivated successfully"; }else{ $emsg = "something went wrong."; }
    }
    if($d == 'dlt-club'){
        $dltItem = true;
        $dltmsg = "Are you sure you want to delete the club '$dbClub'";
        $url = $adminRoot."volleyball-clubs";
        if(isset($_POST['doDlt'])){
            $dltItem = false;
            $q = dltRow('volleyball_clubs',$id);
            if($q){ $smsg = "club '$dbClub' deleted successfully"; jsRefresh($adminRoot."volleyball-clubs",2000); }else{ $emsg = "something went wrong."; }
        }
    }
}


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

<body>

    <!--*******************
        Preloader start
    ********************-->
    <?php include("../inc/preloader.php"); ?>
    <!--*******************
        Preloader end
    ********************-->

    <!--**********************************
        Main wrapper start
    ***********************************-->
    <div id="main-wrapper" class="menu-toggle">

        <!--**********************************
            Nav header start
        ***********************************-->
        <?php include("../inc/nav-header.php"); ?>
        <!--**********************************
            Nav header end
        ***********************************-->


        <!--**********************************
            Header start
        ***********************************-->
        <?php include("../inc/header.php"); ?>
        <!--**********************************
            Header end ti-comment-alt
        ***********************************-->

        <!--**********************************
            Sidebar start
        ***********************************-->
        <?php include("../inc/sidebar.php"); ?>
        <!--**********************************
            Sidebar end
        ***********************************-->

        <!--**********************************
            Content body start
        ***********************************-->
        <div class="content-body">
            <div class="container-fluid">
                <?php include("../inc/page-header.php"); ?>

                <div class="row">
                    <div class="col-md-12">
                        <div class="card">
                            <div class="card-body">
                                <a href="<?= $adminRoot ?>volleyball-clubs?d=new-club&sz=min<?= isset($_GET['c']) ? '&c='.$_GET['c'] : '' ?>" class="btn btn-xs btn-outline-primary" title="Add New"><i class="fa fa-plus"></i></a>
                                <div class="d-inline-block ml-3">
                                    <form action="" method="get">
                                        <div class="input-group">
                                            <div class="input-group-prepend">
                                                <span class="input-group-text bg-white-900 text-primary border border-right-0">Continent</span>
                                            </div>
                                            <select class="form-control default-select w-input-300" id="" onChange="getCountry(this.value);">
                                                <option value="" selected>Select</option>
                                                <?php
                                                $q = getRows('continents',"*","status='active'");
                                                while($row = mysqli_fetch_array($q)){
                                                    ?>
                                                    <option <?php if(isset($co) && $co == $row['id']){ echo 'selected'; } ?> value="<?= $row['id'] ?>"><?= $row['name'] ?></option>
                                                <?php }?>
                                            </select>
                                            <div class="input-group-append">
                                                <span class="input-group-text bg-white-900 text-primary border border-right-0">Country</span>
                                            </div>
                                            <select class="form-control w-input-300" id="countryBox2" name="c">
                                                <?php if($country > 0):
                                                    $q = dbSelect("countries","*", "continent=$co", "name");
                                                    while($row = mysqli_fetch_assoc($q)){
                                                        ?>
                                                        <option <?php if($country == $row['id']){ echo 'selected'; } ?> value="<?= $row['id'] ?>"><?= $row['name'] ?></option>
                                                    <?php } endif ?>
                                                <?php if(isset($country)){ echo "<option>".getDBVal('countries',$country)."</option>"; } ?>
                                            </select>
                                            <div class="input-group-append">
                                                <button type="submit" class="btn btn-xs btn-primary mr-3 submitButton">Go</button>
                                            </div>
                                        </div>
                                    </form>
                                </div>
                                <a href="<?= $adminRoot ?>volleyball-clubs<?= isset($_GET['c']) ? '&c='.$_GET['c'] : '' ?>" class="btn btn-xs btn-outline-primary float-right" title="Refresh Page"><i class="fa fa-refresh"></i></a>
                            </div>
                        </div>
                    </div>
                </div>

                <div class="row gy-3">

                    <?php if(isset($_GET['sz'])): ?>
                    <div class="col-md-3">
                        <div class="card">
                            <div class="card-header">
                                <h4 class="card-title d-inline"><?= ($crdTitle != '' ? $crdTitle : 'Add New') ?></h4>
                                <a href="<?= $adminRoot ?>volleyball-clubs<?= isset($_GET['c']) ? '?c='.$_GET['c'] : '' ?>" class="float-right text-danger"><i class="fa fa-times"></i></a>
                            </div>
                            <div class="card-body">
                                <?php if(isset($_GET['d']) && $_GET['d'] == "new-club"): ?>
                                <form action="" method="post" enctype="multipart/form-data">
                                    <div class="form-row" id="new-club">
                                        <div class="form-group col-md-12">
                                            <label>Name</label>
                                            <input type="text" class="form-control" autofocus name="club" value="<?php if(isset($_POST['club'])){ echo $_POST['club']; } ?>">
                                            <?php if(isset($clubErr)): ?><span class="bg-danger text-white px-2 rounded-sm"><?= $clubErr ?></span><?php endif ?>
                                        </div>
                                    </div>
                                    <div class="form-row mt-3">
                                        <div class="col-md-12 text-center">
                                            <button type="submit" name="saveClub" class="btn btn-xs w-100 btn-primary mr-3 submitButton">Add</button>
                                        </div>
                                    </div>
                                </form>
                                <?php endif ?>
                            </div>
                        </div>
                    </div>
                    <?php endif ?>
                    <div class="col-md-<?php if(isset($_GET['sz']) && $_GET['sz'] == "min"){echo 9;}else{echo 12;} ?>">
                        <div class="card">
                            <div class="card-header">
                                <h4 class="card-title">Manage All</h4>
                            </div>
                            <div class="card-body">
                                <table class="table dtTable">
                                    <thead>
                                        <tr>
                                            <th scope="col">S/N</th>
                                            <th scope="col"><i class="bi bi-toggles text-primary"></i></th>
                                            <th scope="col" style="width: 30%;">Name</th>
                                            <th scope="col" style="width: 15%;">Country</th>
                                            <th scope="col">Stats</th>
<!--                                            <th scope="col"><i class="bi bi-calendar2-date text-primary"></i></th>-->
<!--                                            <th scope="col"><i class="bi bi-calendar2-date-fill text-primary"></i></th>-->
                                            <th scope="col"><i class="bi bi-calendar-plus-fill text-primary"></i></th>
                                            <th scope="col"><i class="bi bi-calendar-check-fill text-primary"></i></th>
                                            <th scope="col" class="text-center">Status</th>
                                        </tr>
                                    </thead>
                                    <?php if(isset($country) && $country > 0): ?>
                                    <tbody>
                                    <?php
                                    $no = 1;
                                    $q = dbSelect("volleyball_clubs", "*", "country=$country", "dc DESC");
                                    while($row = mysqli_fetch_array($q)){
                                        $id = $row['id']; $clubName = $row['name'];
                                        $dc = $row['dc']; $du = $row['du']; $status = $row['status'];
                                        $q2 = dbSelect("volleyball_archive", "COUNT(DISTINCT season) AS totalSeasons", "club=$id");
                                        $row2 = mysqli_fetch_assoc($q2);
                                    ?>
                                        <tr>
                                            <th><?= $no++ ?></th>
                                            <td>
                                                <div class="btn-group">
                                                    <div class="dropdown">
                                                        <button type="button" class="btn btn-outline-primary btn-xs" data-toggle="dropdown" title="Add New">
                                                            <i class="fa fa-gears"></i>
                                                        </button>
                                                        <ul class="dropdown-menu">
                                                            <?php if($status == 'active'): ?>
                                                            <li><a class="dropdown-item" href="<?= $adminRoot ?>volleyball-clubs?id=<?= $id ?>&d=dactv-club<?= isset($_GET['c']) ? '&c='.$_GET['c'] : '' ?>">Deactivate</a></li>
                                                            <?php else: ?>
                                                            <li><a class="dropdown-item" href="<?= $adminRoot ?>volleyball-clubs?id=<?= $id ?>&d=actv-club<?= isset($_GET['c']) ? '&c='.$_GET['c'] : '' ?>">Activate</a></li>
                                                            <li><a class="dropdown-item" href="<?= $adminRoot ?>volleyball-clubs?id=<?= $id ?>&d=dlt-club<?= isset($_GET['c']) ? '&c='.$_GET['c'] : '' ?>">Delete</a></li>
                                                            <?php endif ?>
                                                        </ul>
                                                    </div>
                                                </div>
                                            </td>
                                            <td>
                                                <span class="invisible-text d-block"><?= $clubName ?></span>
                                                <form action="" method="post" class="d-inline-block">
                                                    <input type="text" name="clubId" value="<?= $id ?>" hidden="hidden">
                                                    <div class="input-group">
                                                        <input type="text" class="form-control" name="clubName" value="<?php if(isset($_POST['clubName']) && !empty($_POST['clubName']) && $_POST['clubId'] == $id){ echo $_POST['clubName']; }else{ echo $clubName; } ?>">
                                                        <div class="input-group-append">
                                                            <button type="submit" name="updateClub" class="btn btn-xs btn-primary mr-3 submitButton"><i class="bi bi-check2-square"></i></button>
                                                        </div>
                                                    </div>
                                                </form>
                                            </td>
                                            <td><?= getDBVal('countries',$row['country']) ?></td>
                                            <td><?= $row2['totalSeasons'] ?></td>
<!--                                            <td>--><?php //= getArchiveSeason($id,'club','first') ?><!--</td>-->
<!--                                            <td>--><?php //= getArchiveSeason($id,'club', 'last') ?><!--</td>-->
                                            <td><?= getTimeAgo(strtotime($dc)) ?></td>
                                            <td><?php if($du != ""){ echo getTimeAgo(strtotime($du)); } ?></td>
                                            <td class="text-center">
                                                <i class="fa fa-circle text-<?= getStatusColor($status) ?>"></i>
                                            </td>
                                        </tr>
                                        <?php } ?>
                                    </tbody>
                                    <?php else: ?>
                                    <tfoot>
                                    <tr>
                                        <td colspan="8">
                                            <h4>Kindly select a country to continue</h4>
                                        </td>
                                    </tr>
                                    </tfoot>
                                    <?php endif ?>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>

            </div>
        </div>
        <!--**********************************
            Content body end
        ***********************************-->

        <!--**********************************
            Footer start
        ***********************************-->
        <?php include("../inc/footer.php"); ?>
        <!--**********************************
            Footer end
        ***********************************-->


    </div>
    <!--**********************************
        Main wrapper end
    ***********************************-->

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