1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / nc6d095 / nisan.space / church / admin / view /
Filename : states.php
back
<?php
include '../inc/config.php';
include '../inc/auth/admin.php';

$pageURL = $adminURL."states";

include '../inc/logics/states.php';



const TITLE = "States";
const HEADER = "States";
const LINK = "states";



?>
<?php include '../inc/head.php'; ?>

<!-- ======= Header ======= -->
<?php include '../inc/header.php'; ?>
<!-- End Header -->

<!-- ======= Sidebar ======= -->
<?php include '../inc/sidebar.php'; ?>
<!-- End Sidebar-->

<main id="main" class="main">


    <?php include '../inc/breadcrumb.php'; ?>
    <!-- End Page Title -->
    <div class="card shadow border-0 rounded-3">
        <div class="card-header mb-3">
            <div class="btn-group btn-group-sm">
                <a href="<?= $adminURL ?>states?new-state&min" class="btn btn-outline-dark"><i class="bi bi-plus"></i></a>
                <a href="<?= $adminURL ?>states?truncate" class="btn btn-outline-warning"><i class="bi bi-trash3"></i></a>
            </div>
            <div class="btn-group btn-group-sm float-end">
                <?php if(isset($_GET['edit'])): ?>
                <div class="dropdown">
                    <button class="btn btn-outline-dark btn-sm dropdown-toggle" type="button" id="btnList" data-bs-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
                        <i class="bi bi-list-ol"></i>
                    </button>
                    <div class="dropdown-menu dropdown-menu-right" aria-labelledby="btnList">
                        <?php
                                $q = dbSelect('states', "*", "id<>$id", "name");
                                while($row = mysqli_fetch_assoc($q)){
                                ?>
                        <a href="<?= $adminURL ?>states?id=<?= $row['id'] ?>&edit&min" class="dropdown-item"><?= $row['name'] ?></a>
                        <?php } ?>
                    </div>
                </div>
                <?php endif ?>
                <a href="<?= $adminURL ?>states" class="btn btn-outline-primary"><i class="bi bi-arrow-clockwise"></i></a>
            </div>
        </div>
        <div class="card-body">
            <div class="row g-3">
                <?php if(isset($_GET['min'])): ?>
                <div class="col-md-4">
                    <?php if(isset($_GET['new-state'])): ?>
                    <div class="card shadow border-0">
                        <div class="card-header bg-primary mb-3">
                            <h4 class="card-title mb-0 text-white py-0">Add New
                                <a href="<?= $adminURL ?>states" class="float-end text-danger"><i class="bi bi-x"></i></a>
                            </h4>
                        </div>
                        <div class="card-body">
                            <form action="" method="post">
                                <div class="form-group mb-4">
                                    <label for="">State</label>
                                    <input type="text" name="state" class="form-control" value="<?= isset($_POST['state']) ? $_POST['state'] : '' ?>">
                                    <?php if(isset($stateErr)): ?><span class="text-danger"><?= $stateErr ?></span><?php endif ?>
                                </div>
                                <div class="form-group mb-4">
                                    <label for="">Capital</label>
                                    <input type="text" name="capital" class="form-control" value="<?= isset($_POST['capital']) ? $_POST['capital'] : '' ?>">
                                    <?php if(isset($capitalErr)): ?><span class="text-danger"><?= $capitalErr ?></span><?php endif ?>
                                </div>
                                <div class="">
                                    <button type="submit" class="btn btn-success" name="addState">Save</button>
                                </div>
                            </form>
                        </div>
                    </div>
                    <?php endif ?>
                    <?php if(isset($_GET['edit'])): ?>
                    <div class="card shadow border-0">
                        <div class="card-header bg-primary mb-3">
                            <h4 class="card-title mb-0 text-white py-0">Edit State <span class="badge bg-white text-black-50"><?= $stateName ?></span>
                                <a href="<?= $adminURL ?>states" class="float-end text-danger"><i class="bi bi-x"></i></a>
                            </h4>
                        </div>
                        <div class="card-body">
                            <form action="" method="post">
                                <div class="form-group mb-4">
                                    <label for="">State</label>
                                    <input type="text" name="state" class="form-control" value="<?= isset($_POST['state']) ? $_POST['state'] : $stateName ?>">
                                    <?php if(isset($stateErr)): ?><span class="text-danger"><?= $stateErr ?></span><?php endif ?>
                                </div>
                                <div class="">
                                    <button type="submit" class="btn btn-primary" name="updateState">Update</button>
                                </div>
                            </form>
                            <form action="" method="post" class="mt-3 pt-3 border-top">
                                <div class="form-group mb-4">
                                    <label for="">Capital</label>
                                    <input type="text" name="capital" class="form-control" value="<?= isset($_POST['capital']) ? $_POST['capital'] : $dbCapital ?>">
                                    <?php if(isset($capitalErr)): ?><span class="text-danger"><?= $capitalErr ?></span><?php endif ?>
                                </div>
                                <div class="">
                                    <button type="submit" class="btn btn-primary" name="updateCapital">Update</button>
                                </div>
                            </form>
                        </div>
                    </div>
                    <?php endif ?>
                </div>
                <?php endif ?>
                <div class="col-md-<?= isset($_GET['min']) ? 8 : 12 ?>">
                    <div class="card shadow border-0">
                        <div class="card-header bg-primary mb-3">
                            <h4 class="card-title mb-0 text-white py-0">Manage All
                                <?php if(isset($_GET['min'])): ?>
                                <a href="<?= $adminURL ?>states" class="float-end text-white"><i class="bi bi-fullscreen"></i></a>
                                <?php else: ?>
                                <a href="<?= $adminURL ?>states?min" class="float-end text-white"><i class="bi bi-fullscreen-exit"></i></a>
                                <?php endif ?>
                            </h4>
                        </div>
                        <div class="card-body">
                            <table class="table datatable table-stripped table-hover">
                                <caption>States</caption>
                                <thead>
                                    <tr>
                                        <th><i class="bi bi-list-ol"></i></th>
                                        <th><i class="bi bi-toggle-on"></i></th>
                                        <th>State</th>
                                        <th>Capital</th>
                                        <th><i class="bi bi-calendar-plus"></i></th>
                                        <th><i class="bi bi-calendar-check"></i></th>
                                        <th class="text-center"><i class="bi bi-circle-fill"></i></th>
                                    </tr>
                                </thead>
                                <tbody>
                                    <?php
                                        $no = 1;
                                        $q = dbSelect("states", "*");
                                        while($row = mysqli_fetch_assoc($q)){
                                            $du = $row['du'];
                                            $status = strtolower($row['status']);
                                        ?>
                                    <tr>
                                        <td><?= $no++ ?></td>
                                        <td>
                                            <div class="dropdown">
                                                <button class="btn btn-outline-dark btn-sm dropdown-toggle" type="button" id="actnBtn" data-bs-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
                                                    <i class="mdi mdi-settings-box"></i>
                                                </button>
                                                <div class="dropdown-menu dropdown-menu-right" aria-labelledby="actnBtn">
                                                    <?php if($status == 'active'): ?>
                                                    <a class="dropdown-item" href="<?= $adminURL ?>states?id=<?= $row['id'] ?>&edit&min"><i class="bi bi-pencil-fill me-1 text-black"></i>Edit</a>
                                                    <a class="dropdown-item" href="<?= $adminURL ?>states?id=<?= $row['id'] ?>&deactivate"><i class="bi bi-x-circle me-1 text-black"></i>Deactivate</a>
                                                    <a class="dropdown-item" href="<?= $adminURL ?>states?id=<?= $row['id'] ?>&trash"><i class="bi bi-trash me-1 text-black"></i>Trash</a>
                                                    <?php elseif($status == 'trashed'): ?>
                                                    <a class="dropdown-item" href="<?= $adminURL ?>states?id=<?= $row['id'] ?>&restore"><i class="bi bi-recycle me-1 text-black"></i>Restore</a>
                                                    <a class="dropdown-item" href="<?= $adminURL ?>states?id=<?= $row['id'] ?>&delete"><i class="bi bi-trash me-1 text-black"></i>Delete</a>
                                                    <?php else: ?>
                                                    <a class="dropdown-item" href="<?= $adminURL ?>states?id=<?= $row['id'] ?>&activate"><i class="bi bi-check me-1 text-black"></i>Activate</a>
                                                    <?php endif ?>
                                                </div>
                                            </div>
                                        </td>
                                        <td><?= $row['name'] ?></td>
                                        <td><?= $row['capital'] ?></td>
                                        <td><?= getTimeAgo(strtotime($row['dc'])) ?></td>
                                        <td><?= empty($du) ? '' : getTimeAgo(strtotime($du)) ?></td>
                                        <td class="text-center"><i class="bi bi-circle-fill text-<?= formatStatus($row['status']) ?>"></i></td>
                                    </tr>
                                    <?php } ?>
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

</main><!-- End #main -->

<!-- ======= Footer ======= -->
<?php include '../inc/footer.php'; ?>
<?php include '../inc/foot.php'; ?>
<!-- End Footer -->