1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / nc6d095 / cbtcnow.com / admin / view /
Filename : subscribers.php
back
<?php
include('../inc/config.php');
include('../inc/auth.php');
const TITLE = 'Manage Subscribers';
const HEADER = 'Subscribers';
const BREADCRUMB = 'subscribers';

#manage subscriber status
if(isset($_GET['d']) && isset($_GET['id'])){
    $d = $_GET['d'];
    $id = $_GET['id'];
    $dbUsername = getDBVal('subscribers','username',$id);
    if($d == 'actv-subscriber'  && checkInactive('subscribers', $id)){
        $q = changeStatus('subscribers','active',$id);
        if($q){ $smsg = "subscriber '$dbUsername' activated successfully"; }else{ $emsg = "something went wrong."; }
    }
    if($d == 'dactv-subscriber'  && checkActive('subscribers', $id)){
        $q = changeStatus('subscribers','inactive',$id);
        if($q){ $smsg = "subscriber '$dbUsername' deactivated successfully"; }else{ $emsg = "something went wrong."; }
    }
    if($d == 'dlt-subscriber'){
        $dltItem = true;
        $dltmsg = "Are you sure you want to delete the subscriber '$dbUsername'";
        $url = $adminRoot."subscribers";
        if(isset($_POST['doDlt'])){
            $dltItem = false;
            $q = dltRow('subscribers',$id);
            if($q){ $smsg = "subscriber '$dbUsername' deleted successfully"; pageReload(2000,$adminRoot."subscribers"); }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">

    <!--**********************************
        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-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">Name</th>
                                    <th scope="col">Contact</th>
                                    <th scope="col">Image</th>
                                    <th scope="col">Created</th>
                                    <th scope="col">Updated</th>
                                    <th scope="col" class="text-center">Status</th>
                                </tr>
                                </thead>
                                <tbody>
                                <?php
                                $no = 1;
                                $q = dbSelect('subscribers',"*",null,"dc DESC", 100);
                                while($row = mysqli_fetch_array($q)){
                                    $id = $row['id'];
                                    $dc = $row['dc']; $du = $row['du']; $status = $row['status'];
                                    ?>
                                    <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 ?>sub-profile/<?= $id ?>/overview">Profile</a></li>
                                                            <li><a class="dropdown-item" href="<?= $adminRoot ?>subscribers?id=<?= $id ?>&d=dactv-subscriber">Deactivate</a></li>
                                                        <?php else: ?>
                                                            <li><a class="dropdown-item" href="<?= $adminRoot ?>subscribers?id=<?= $id ?>&d=actv-subscriber">Activate</a></li>
                                                            <li><a class="dropdown-item" href="<?= $adminRoot ?>subscribers?id=<?= $id ?>&d=dlt-subscriber">Delete</a></li>
                                                        <?php endif ?>
                                                    </ul>
                                                </div>
                                            </div>
                                        </td>
                                        <td><?= $row['fName']." ".$row['lName'] ?></td>
                                        <td>
                                            <p class="mb-0"><i class="uil uil-at mr-2 text-primary"></i><?= $row['email'] ?></p>
                                            <p class="mb-0"><i class="uil uil-phone-alt mr-2 text-primary"></i><?= $row['phone'] ?></p>
                                        </td>
                                        <td>
                                            <img src="<?= $uploadsRoot; ?>images/members/profile/<?= $row['image']; ?>" class="rounded-circle" width="60">
                                        </td>
                                        <td><?= getTimeAgo(strtotime($row['dc'])) ?></td>
                                        <td><?php if($du != ""){ echo getTimeAgo(strtotime($row['du'])); } ?></td>
                                        <td class="text-center">
                                            <i class="fa fa-circle text-<?= getStatusColor($status) ?>"></i>
                                        </td>
                                    </tr>
                                <?php } ?>
                                </tbody>
                            </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"); ?>