1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / nc6d095 / heroreads.com / dashboard / view /
Filename : countries.php
back
<?php
include "../inc/config.php";
include "../inc/auths/admin.php";
$pageUrl = $adminRoot."countries";
$addLinks = [
    "Country"=>"$pageUrl?min&new-country",
];
include "../inc/logics/countries.php";

const TITLE = "Manage Countries";
const HEADER = "Manage Countries";
const BREADCRUMB = "countries";

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


      <!--////////////////// PreLoader Start//////////////////////-->
      <?php include "../inc/preloader.php"; ?>
      <!--////////////////// /.PreLoader END//////////////////////-->


    <div class="d-flex flex-column flex-root">
      <!--Page-->
      <div class="page d-flex flex-row flex-column-fluid">


        <!--///////////Page sidebar begin///////////////-->
        <?php include "../inc/aside.php"; ?>
        <!--///////////Page Sidebar End///////////////-->




        <!--///////////Page content wrapper///////////////-->
        <main class="page-content d-flex flex-column flex-row-fluid">

          <!--//page-header//-->
          <?php include "../inc/header.php"; ?>
          <!--Main Header End-->

            <!--//Page Header//-->
            <?php include "../inc/page-header.php"; ?>
            <!--//Page Header End//-->

            <!--//Page content//-->
            <div class="content d-flex flex-column-fluid">
                <div class="container-fluid px-0">
                    <div class="pt-3 px-3 px-lg-6 overflow-hidden">
                        <div class="row gy-3">
                            <?php if(isset($_GET['min'])): ?>
                                <div class="col-md-4">
                                    <div class="card overflow-hidden h-100">
                                        <div class="card-header d-flex align-items-center">
                                            <h5 class="mb-0"><?= $cardTitle ?></h5>
                                            <!--dropdown-->
                                            <div class="flex-shrink-0 ms-auto">
                                                <div class="btn-group btn-group-sm">
                                                    <a href="<?= $pageUrl ?>" data-tippy-content="Close" data-tippy-placement="top"><i class="bi bi-x-square-fill text-primary"></i></a>
                                                </div>
                                            </div>
                                        </div>
                                        <div class="card-body">
                                            <?php if(isset($_GET['new-country'])): ?>
                                                <form class="row g-3" action="" method="post">
                                                    <div class="col-12">
                                                        <div class="form-floating">
                                                            <input type="text" class="form-control" id="country" name="country" placeholder="" value="<?= $_POST['country'] ?? '' ?>">
                                                            <label for="country">Name <small class="text-info">e.g Nigeria etc.</small></label>
                                                        </div>
                                                        <span class="text-danger"><?= $countryErr ?? '' ?></span>
                                                    </div>
                                                    <div class="col-12">
                                                        <div class="form-floating">
                                                            <input type="text" class="form-control" id="capital" name="capital" placeholder="" value="<?= $_POST['capital'] ?? '' ?>">
                                                            <label for="capital">Capital</label>
                                                        </div>
                                                        <span class="text-danger"><?= $capitalErr ?? '' ?></span>
                                                    </div>
                                                    <div class="col-12">
                                                        <div class="form-floating">
                                                            <select class="form-control form-control-lg" name="continent" data-choices='{"searchEnabled":true, "itemSelectText":"type above to filter"}'>
                                                                <option value="">select continent</option>
                                                                <?php
                                                                $q = dbSelect('continents', "*", "status='active'");
                                                                while($row = mysqli_fetch_assoc($q)){
                                                                    ?>
                                                                    <option <?php if(isset($_POST['continent']) && $_POST['continent'] == $row['id']){ echo 'selected'; } ?> value="<?= $row['id'] ?>"><?= $row['name'] ?></option>
                                                                <?php } ?>
                                                            </select>
                                                        </div>
                                                        <span class="text-danger"><?= $continentErr ?? '' ?></span>
                                                    </div>
                                                    <div class="col-12">
                                                        <button type="submit" name="addCountry" class="btn btn-primary growBtn">Add</button>
                                                        <button type="reset" class="btn btn-secondary">Cancel</button>
                                                    </div>
                                                </form>
                                            <?php endif ?>
                                            <?php if(isset($_GET['edit-country'])): ?>
                                                <form class="row g-3" action="" method="post">
                                                    <h6 class="text-primary-alt mb-0 col-12">Update Country Name</h6>
                                                    <div class="col-12">
                                                        <div class="form-floating">
                                                            <input type="text" class="form-control" id="country" name="country" placeholder="" value="<?= $_POST['country'] ?? $dbCountry ?>">
                                                            <label for="country">Name</label>
                                                        </div>
                                                        <span class="text-danger"><?= $countryErr ?? '' ?></span>
                                                    </div>
                                                    <div class="col-12">
                                                        <button type="submit" name="updateCountry" class="btn btn-primary growBtn">Update</button>
                                                    </div>
                                                </form>
                                                <form class="row g-3 mt-4 pt-4 border-top" action="" method="post">
                                                    <h6 class="text-primary-alt mb-0 col-12">Update Capital</h6>
                                                    <div class="col-12">
                                                        <div class="form-floating">
                                                            <input type="text" class="form-control" id="capital" name="capital" placeholder="" value="<?= $_POST['capital'] ?? $dbCapital ?>">
                                                            <label for="capital">Capital</label>
                                                        </div>
                                                        <span class="text-danger"><?= $capitalErr ?? '' ?></span>
                                                    </div>
                                                    <div class="col-12">
                                                        <button type="submit" name="updateCapital" class="btn btn-primary growBtn">Update</button>
                                                    </div>
                                                </form>
                                                <form class="row g-3 mt-4 pt-4 border-top" action="" method="post">
                                                    <h6 class="text-primary-alt mb-0 col-12">Update Continent</h6>
                                                    <div class="col-12">
                                                        <div class="form-floating">
                                                            <select class="form-control form-control-lg" name="continent" data-choices='{"searchEnabled":true, "itemSelectText":"type above to filter"}'>
                                                                <option value="">select continent</option>
                                                                <?php
                                                                $q = dbSelect('continents', "*", "status='active'");
                                                                while($row = mysqli_fetch_assoc($q)){
                                                                    ?>
                                                                    <option <?php if((isset($_POST['continent']) && $_POST['continent'] == $row['id']) || $dbContinent == $row['id']){ echo 'selected'; } ?> value="<?= $row['id'] ?>"><?= $row['name'] ?></option>
                                                                <?php } ?>
                                                            </select>
                                                        </div>
                                                        <span class="text-danger"><?= $continentErr ?? '' ?></span>
                                                    </div>
                                                    <div class="col-12">
                                                        <button type="submit" name="updateContinent" class="btn btn-primary growBtn">Update</button>
                                                    </div>
                                                </form>
                                            <?php endif ?>
                                        </div>
                                    </div>
                                </div>
                            <?php endif ?>

                            <div class="col-md-<?= isset($_GET['min']) ? 8 : 12 ?>">
                                <div class="card overflow-hidden h-100">
                                    <div class="card-header d-flex align-items-center">
                                        <h5 class="mb-0">Manage</h5>
                                        <!--dropdown-->
                                        <div class="flex-shrink-0 ms-auto">
                                            <div class="btn-group btn-group-sm">
                                                <?php if(isset($_GET['min'])): ?>
                                                    <a href="<?= $pageUrl ?>" class="btn btn-outline-secondary btn-sm" data-tippy-content="Maximize" data-tippy-placement="top"><i class="bi bi-window-fullscreen"></i></a>
                                                <?php else: ?>
                                                    <a href="<?= $pageUrl ?>?min" class="btn btn-outline-secondary btn-sm" data-tippy-content="Minimize" data-tippy-placement="top"><i class="bi bi-window-dash"></i></a>
                                                <?php endif ?>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="card-body">
                                        <div class="table-responsive">
                                            <table class="table dtTable mt-0 table-hover table-card table-nowrap">
                                                <thead class="text-uppercase small text-body-secondary">
                                                <tr>
                                                    <th style="width: 5%;"><i class="bi bi-list-ol text-primary" data-tippy-content="S/N" data-tippy-placement="top"></i></th>
                                                    <th><i class="bi bi-toggles text-primary" data-tippy-content="Actions" data-tippy-placement="top"></i></th>
                                                    <th>Country</th>
                                                    <th>Continent</th>
                                                    <th><i class="bi bi-calendar3 text-primary" data-tippy-content="Dates" data-tippy-placement="top"></i></th>
                                                    <th><i class="bi bi-circle-fill text-primary" data-tippy-content="Status" data-tippy-placement="top"></i></th>
                                                </tr>
                                                </thead>
                                                <tbody>
                                                <?php
                                                $no = 1;
                                                $q = dbSelect('countries',"*");
                                                while($row = mysqli_fetch_assoc($q)){
                                                    ?>
                                                    <tr>
                                                        <td><?= $no++ ?></td>
                                                        <td>
                                                            <div class="dropdown me-2">
                                                                <a class="d-flex align-items-center justify-content-center size-30 rounded-circle btn btn-primary p-0" href="#" role="button" data-bs-toggle="dropdown" aria-expanded="false" data-tippy-content="Actions" data-tippy-placement="left">
                                                                    <span class="material-symbols-rounded align-middle">more_horiz</span>
                                                                </a>
                                                                <div class="dropdown-menu dropdown-menu-end mt-1">
                                                                    <?php if(strtolower($row['status']) == 'active'): ?>
                                                                        <a class="dropdown-item" href="<?= $pageUrl ?>?edit-country&min&id=<?= $row['id'] ?>">Edit</a>
                                                                        <a class="dropdown-item manage-item" data-name="<?= $row['name'] ?>" data-table="countries" data-url="ajax-manage?action=deactivate" data-action="deactivate" data-id="<?= $row['id'] ?>">Deactivate</a>
                                                                    <?php else: ?>
                                                                        <a class="dropdown-item manage-item" data-name="<?= $row['name'] ?>" data-table="countries" data-url="ajax-manage?action=activate" data-action="activate" data-id="<?= $row['id'] ?>">Activate</a>
                                                                        <a class="dropdown-item manage-item" data-name="<?= $row['name'] ?>" data-table="countries" data-url="ajax-manage?action=delete" data-action="delete" data-id="<?= $row['id'] ?>">Delete</a>
                                                                    <?php endif ?>
                                                                </div>
                                                            </div>
                                                        </td>
                                                        <td>
                                                            <p class="mb-0"><strong class="text-primary">country:</strong> <?= $row['name'] ?></p>
                                                            <p class="mb-0"><strong class="text-primary">capital:</strong> <?= $row['capital'] ?></p>
                                                        </td>
                                                        <td><?= getDBVal('continents',$row['continent']) ?></td>
                                                        <td>
                                                            <p class="mb-0"><strong><i class="bi bi-calendar2 text-success"></i></strong> <?= getTimeAgo(strtotime($row['dc'])) ?></p>
                                                            <?php if($row['du'] != ""): ?>
                                                                <p class="mb-0"><strong><i class="bi bi-calendar2 text-info"></i></strong> <?= getTimeAgo(strtotime($row['du'])) ?></p>
                                                            <?php endif ?>
                                                        </td>
                                                        <td><i class="bi bi-circle-fill text-<?= formatStatus($row['status']) ?>" data-tippy-content="<?= ucfirst($row['status']) ?>" data-tippy-placement="left"></i></td>
                                                    </tr>
                                                <?php } ?>
                                                </tbody>
                                            </table>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            <!--//Page content End//-->

           <!--//Page-footer//-->
           <?php include "../inc/footer.php"; ?>
            <!--/.Page Footer End-->

        </main>
        <!--///////////Page content wrapper End///////////////-->
      </div>
    </div>


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