1#@!#!123s

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

define('TITLE','Manage Careers');
define('HEADER','Careers');
define('BREADCRUMB','careers');

$tinyEditor = "full";

if(isset($_GET['d'])){
    $d = $_GET['d'];
    if(isset($_GET['id'])) {
        $id = $_GET['id'];
        $dbCareer = getDBVal('careers', $id, 'name');
        $dbOverview = getDBVal('careers', $id, 'overview');
        $dbAppMode = getDBVal('careers', $id, 'appMode');
        $dbQualifications = getDBVal('careers', $id, 'qualifications');
        $dbResponsibilities = getDBVal('careers', $id, 'responsibilities');
        $dbState = getDBVal('careers', $id, 'location');
        $dbCareerImg = getDBVal('careers', $id, 'coverImg');
    }
    if($d == "new-career"){ $crdTitle = "Add New Career"; }
    if($d == "edit-title" || $d == "edit-info" || $d == "edit-state"){
        $crdTitle = "Edit Career (<small>".strtolower($dbCareer).")</small>";
    }
    if($d == "add-image"){
        $crdTitle = "Add Image (<small>".strtolower($dbCareer).")</small>";
    }
    if($d == "change-cover"){
        $crdTitle = "Change Cover Image (<small>".strtolower($dbCareer).")</small>";
    }
}

#logics
#save career
if(isset($_POST['saveCareer'])){
    #data cleaning & scrutinization
    $careerTitle = trim(mysqli_real_escape_string($db, $_POST['careerTitle']));
    $overview = trim(mysqli_real_escape_string($db, $_POST['overview']));
    $qualifications = trim(mysqli_real_escape_string($db, $_POST['qualifications']));
    $appMode = trim(mysqli_real_escape_string($db, $_POST['appMode']));
    $responsibilities = trim(mysqli_real_escape_string($db, $_POST['responsibilities']));
    $location = trim(intval($_POST['location']));

    #data validation
    if(empty($careerTitle)){ $errs[] = $careerTitleErr = "please enter a value"; }
    if(empty($overview)){ $errs[] = $overviewErr = "please enter a value"; }
    if(empty($appMode)){ $errs[] = $appModeErr = "please enter a value"; }
    if(empty($qualifications)){ $errs[] = $qualificationsErr = "please enter a value"; }
    if(empty($responsibilities)){ $errs[] = $responsibilitiesErr = "please enter a value"; }
    if($location == 0){ $errs[] = $locationErr = "please select a value"; }

    #prcareer duplicates
    if(!empty($careerTitle)){
        $rowCnt = checkDuplicates('careers', "name='$careerTitle'");
        if($rowCnt > 0){
            $errs[] = $careerExistErr = "";
            $emsg = "Career '$careerTitle' already exists";
        }
    }

    #execute when errors have been solved
    if(count($errs) == 0){
        $q = dbInsert("careers", ['name'=>$careerTitle, 'location'=>$location, 'overview'=>$overview, 'appMode'=>$appMode, 'qualifications'=>$qualifications, 'responsibilities'=>$responsibilities, 'dc'=>$now]);
        if($q){
            $smsg = "Career '$careerTitle' saved successfully";
            $preventResubmission = true;
        }
        else{
           $emsg = "Action not successful. Try again later";
        }
    }
}

#update career
if(isset($_POST['updateCareerTitle'])){
    #data cleaning & scrutinization
    $careerTitle = trim(stripslashes(mysqli_real_escape_string($db, $_POST['careerTitle'])));
    #data validation
    if(empty($careerTitle)){ $errs[] = $careerTitleErr = "please enter a value"; }
    #prcareer duplicates
    if(!empty($careerTitle)){
        $rowCnt = checkDuplicates('careers', "name='$careerTitle' AND id<>$id");
        $rowCnt2 = checkDuplicates('careers', "name='$careerTitle' AND id=$id");
        if($rowCnt > 0){ $errs[] = $careerExistErr = ""; $emsg = "Career '$careerTitle' already exists"; }
        if($rowCnt2 > 0){ $errs[] = $careerExistErr = ""; $emsg = "Modification is required to continue"; }
    }
    #execute when errors have been solved
    if(count($errs) == 0){
        if($dbCareerImg == 'default.png'){
            $q = dbUpdate("careers",['name'=>$careerTitle, 'du'=>$now],"id=".$id);
        }else{
            $ext = explode(".",$dbCareerImg);
            $ext = end($ext);
            $newTitle = strtolower(md5(makeSlug($careerTitle)).".".$ext); $uploadPath = "../uploads/images/careers/";
            rename($uploadPath.$dbCareerImg,$uploadPath.$newTitle);
            $q = dbUpdate("careers",['name'=>$careerTitle, 'coverImg'=>$newTitle, 'du'=>$now],"id=".$id);
        }
        if($q){
            $smsg = "'$dbCareer' updated to '$careerTitle' successfully"; $preventResubmission = true;
        }
        else{
           $emsg = "Action not successful. Try again later";
        }
    }
}

#update career category
if(isset($_POST['updateLocation'])){
    #data cleaning & scrutinization
    $state = trim(intval($_POST['state']));
    #data validation
    if($state == 0){ $errs[] = $stateErr = "please select a value"; }
    #prcareer duplicates
    else{
        $rowCnt = checkDuplicates('careers', "location=$state AND id=$id");
        if($rowCnt > 0){ $errs[] = $careerExistErr = ""; $emsg = "Modification is required to continue"; }
    }
    #execute when errors have been solved
    if(count($errs) == 0){
            $q = dbUpdate("careers",['location'=>$state, 'du'=>$now],"id=".$id);
        if($q){
            $smsg = "career '$dbCareer' location updated successfully"; $preventResubmission = true;
        }
        else{
           $emsg = "Action not successful. Try again later";
        }
    }
}

#update career info
if(isset($_POST['updateInfo'])){
    #data cleaning & scrutinization
    $overview = trim(mysqli_real_escape_string($db, $_POST['overview']));
    $qualifications = trim(mysqli_real_escape_string($db, $_POST['qualifications']));
    $appMode = trim(mysqli_real_escape_string($db, $_POST['appMode']));
    $responsibilities = trim(mysqli_real_escape_string($db, $_POST['responsibilities']));
    #data validation
    if(empty($overview)){ $errs[] = $overviewErr = "please enter a value"; }
    if(empty($appMode)){ $errs[] = $appModeErr = "please enter a value"; }
    if(empty($qualifications)){ $errs[] = $qualificationsErr = "please enter a value"; }
    if(empty($responsibilities)){ $errs[] = $responsibilitiesErr = "please enter a value"; }
    #prcareer duplicates
    if(!empty($overview) || !empty($qualifications) || !empty($appMode) || !empty($responsibilities)){
        $rowCnt = checkDuplicates('careers', "overview='$overview' AND id=$id");
        $rowCnt2 = checkDuplicates('careers', "appMode='$appMode' AND id=$id");
        $rowCnt3 = checkDuplicates('careers', "qualifications='$qualifications' AND id=$id");
        $rowCnt4 = checkDuplicates('careers', "responsibilities='$responsibilities' AND id=$id");
        if($rowCnt > 0 && $rowCnt2 > 0 && $rowCnt3 > 0 && $rowCnt4 > 0){ $errs[] = $careerExistErr = ""; $emsg = "Modification of at least one of the info is required to continue"; }
    }
    #execute when errors have been solved
    if(count($errs) == 0){
            $q = dbUpdate("careers",['overview'=>$overview, 'appMode'=>$appMode, 'qualifications'=>$qualifications, 'responsibilities'=>$responsibilities, 'du'=>$now],"id=".$id);
        if($q){
            $smsg = "info for career '$dbCareer' updated successfully"; $preventResubmission = true;
        }
        else{
           $emsg = "Action not successful. Try again later";
        }
    }
}

//change cover image
if(isset($_POST['changeCover'])){
    $uploadPath = "../uploads/images/careers/";
    $coverImage = $_FILES['coverImage']['name'];
    //get the extension of the uploaded image
    $ext = explode(".",$coverImage);
    $ext = end($ext);
    #data validation
    $allowedExts = ['jpg','JPG','png','PNG'];
    if(!in_array($ext,$allowedExts)){
        $errs[] = $coverImageErr = "Invalid file format encountered. Only jpg/png allowed";
    }
    if(count($errs) == 0){
        $newTitle = strtolower(md5(makeSlug($dbCareer)).".".$ext);
        $jpgImg = strtolower(makeSlug($dbCareer)).".jpg";
        $pngImg = strtolower(makeSlug($dbCareer)).".png";
        $q = dbUpdate("careers",['coverImg'=>$newTitle, 'du'=>$now],"id=".$id);
        if($q){
            //moving the uploaded photo into appropriate folder
            //check existing file
            if(file_exists($uploadPath.$pngImg)) unlink($uploadPath.$pngImg);
            if(file_exists($uploadPath.$jpgImg)) unlink($uploadPath.$jpgImg);
            $absolutePath = $uploadPath.$newTitle;
            // Compress Image
            compressImage($_FILES['coverImage']['tmp_name'],$absolutePath,50);
            $smsg = "cover for career '$dbCareer' has been updated successfully";
            $preventResubmission = true;
        }
        else{
            $emsg = "Something went wrong. Please try again later";
        }
    }
}

#manage career status
if(isset($_GET['d']) && isset($_GET['id'])){
    $d = $_GET['d'];
    $id = $_GET['id'];
    $dbCareer = getDBVal('careers',$id,'name');
    if($d == 'actv-career'  && checkInactive('careers', $id)){
        $q = changeStatus('careers','active',$id);
        if($q){ $smsg = "career '$dbCareer' activated successfully"; }else{ $emsg = "something went wrong."; }
    }
    if($d == 'dactv-career'  && checkActive('careers', $id)){
        $q = changeStatus('careers','inactive',$id);
        if($q){ $smsg = "career '$dbCareer' deactivated successfully"; }else{ $emsg = "something went wrong."; }
    }
    if($d == 'dlt-career'){
        $dltItem = true;
        $dltmsg = "Are you sure you want to delete the career '$dbCareer'. Please note that all image files associated with it will also be deleted";
        $url = $adminRoot."careers";
        if(isset($_POST['doDlt'])){
            $dltItem = false;
            $uploadPath = "../uploads/images/careers/";
            $q = dbSelect('career_images', "*","career=$id");
            if(mysqli_num_rows($q) > 0){
                while($row = mysqli_fetch_array($q)){
                    $image = $row['image'];
                    dltRow('career_images',$row['id']);
                    if(file_exists($uploadPath.$image)){ unlink($uploadPath.$image); }
                }
            }
            $q2 = dltRow('careers',$id);
            if($q2){ $smsg = "career '$dbCareer' deleted successfully"; jsRefresh($adminRoot."careers",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">

        <!--**********************************
            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">
                                <div class="button-dropdown">
                                    <div class="btn-group" title="Add New">
                                        <button type="button" class="btn btn-xs btn-outline-primary"><i class="fa fa-plus-square fa-2x"></i></button>
                                        <button type="button" class="btn btn-xs btn-primary dropdown-toggle dropdown-toggle-split" data-toggle="dropdown" aria-expanded="false">
                                        </button>
                                        <div class="dropdown-menu" x-placement="bottom-start" style="position: absolute; will-change: transform; top: 0px; left: 0px; transform: translate3d(79px, 42px, 0px);">
                                            <a class="dropdown-item" href="<?= $adminRoot ?>careers?d=new-career&sz=min">Career</a>
                                        </div>
                                    </div>

                                    <a href="<?= $adminRoot ?>careers" class="btn btn-xs btn-outline-primary float-right" title="Refresh Page"><i class="fa fa-refresh"></i></a>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

                <div class="row">
                    <?php if(isset($_GET['sz'])): ?>
                    <div class="col-md-4">
                        <div class="card">
                            <div class="card-header">
                                <h4 class="card-title d-inline"><?= ($crdTitle != '' ? $crdTitle : 'Add New') ?></h4>
                                <a href="<?= $adminRoot ?>careers" class="float-right text-danger"><i class="fa fa-times"></i></a>
                            </div>
                            <div class="card-body">
                                <form action="" method="post" enctype="multipart/form-data">

                                    <?php if(isset($_GET['d']) && $_GET['d'] == "new-career"): ?>
                                    <div class="form-row" id="new-career">
                                        <div class="form-group col-md-12">
                                            <label>Title</label>
                                            <input type="text" class="form-control" name="careerTitle" placeholder="" value="<?php if(isset($_POST['careerTitle'])){ echo $_POST['careerTitle']; } ?>">
                                            <?php if(isset($careerTitleErr)): ?><span class="bg-danger text-white px-2 rounded"><?= $careerTitleErr ?></span><?php endif ?>
                                        </div>
                                        <div class="form-group col-md-12">
                                            <label>Location</label>
                                            <select class="form-control default-select" id="" name="location">
                                                <option value="" selected>Select State</option>
                                                <?php
                                                $q = getRows('states',"*","status='Active' OR status='active'");
                                                while($row = mysqli_fetch_array($q)){
                                                ?>
                                                <option <?php if((isset($_POST['location']) && $_POST['location'] == $row['id'])){ echo 'selected'; } ?> value="<?= $row['id'] ?>"><?= $row['name'] ?></option>
                                                <?php }?>
                                            </select>
                                            <?php if(isset($locationErr)): ?><span class="bg-danger text-white px-2 rounded"><?= $locationErr ?></span><?php endif ?>
                                        </div>
                                        <div class="form-group col-md-12">
                                            <label>Overview</label>
                                            <textarea name="overview" id="" rows="10" class="form-control tinyeditor" placeholder=""><?php if(isset($_POST['overview'])){ echo $_POST['overview']; } ?></textarea>
                                            <?php if(isset($overviewErr)): ?><span class="bg-danger text-white px-2 rounded"><?= $overviewErr ?></span><?php endif ?>
                                        </div>
                                        <div class="form-group col-md-12">
                                            <label>Application Mode</label>
                                            <textarea name="appMode" id="" rows="10" class="form-control tinyeditor" placeholder=""><?php if(isset($_POST['appMode'])){ echo $_POST['appMode']; } ?></textarea>
                                            <?php if(isset($appModeErr)): ?><span class="bg-danger text-white px-2 rounded"><?= $appModeErr ?></span><?php endif ?>
                                        </div>
                                        <div class="form-group col-md-12">
                                            <label>Qualifications</label>
                                            <textarea name="qualifications" id="" rows="10" class="form-control tinyeditor" placeholder=""><?php if(isset($_POST['qualifications'])){ echo $_POST['qualifications']; } ?></textarea>
                                            <?php if(isset($qualificationsErr)): ?><span class="bg-danger text-white px-2 rounded"><?= $qualificationsErr ?></span><?php endif ?>
                                        </div>
                                        <div class="form-group col-md-12">
                                            <label>Responsibilities</label>
                                            <textarea name="responsibilities" id="" rows="10" class="form-control tinyeditor" placeholder=""><?php if(isset($_POST['responsibilities'])){ echo $_POST['responsibilities']; } ?></textarea>
                                            <?php if(isset($responsibilitiesErr)): ?><span class="bg-danger text-white px-2 rounded"><?= $responsibilitiesErr ?></span><?php endif ?>
                                        </div>
                                    </div>
                                    <div class="form-row mt-3">
                                        <div class="col-md-12 text-center">
                                            <button type="submit" name="saveCareer" class="btn btn-xs btn-primary mr-3">Add</button>

                                        </div>
                                    </div>
                                    <?php endif ?>

                                    <?php if(isset($_GET['d']) && $_GET['d'] == "edit-title"): ?>
                                    <div class="form-row" id="edit-title">
                                        <div class="form-group col-md-12">
                                            <label>Title</label>
                                            <input type="text" class="form-control" name="careerTitle" placeholder="Career Title" value="<?php if(isset($_POST['careerTitle'])){ echo $_POST['careerTitle']; }else{ echo $dbCareer; } ?>">
                                            <?php if(isset($careerTitleErr)): ?><span class="bg-danger text-white px-2 rounded"><?= $careerTitleErr ?></span><?php endif ?>
                                        </div>
                                    </div>
                                    <div class="form-row mt-3">
                                        <div class="col-md-12 text-center">
                                            <button type="submit" name="updateCareerTitle" class="btn btn-xs btn-primary mr-3">Update</button>

                                        </div>
                                    </div>
                                    <?php endif ?>

                                    <?php if(isset($_GET['d']) && $_GET['d'] == "edit-state"): ?>
                                    <div class="form-row" id="edit-cat">
                                        <div class="form-group col-md-12">
                                            <label>State</label>
                                            <select class="form-control default-select" id="" name="state">
                                                <option value="" selected>Select State</option>
                                                <?php
                                                $q = getRows('states',"*");
                                                while($row = mysqli_fetch_array($q)){
                                                ?>
                                                <option <?php if((isset($_POST['state']) && $_POST['state'] == $row['id']) || $dbState == $row['id']){ echo 'selected'; } ?> value="<?= $row['id'] ?>"><?= $row['name'] ?></option>
                                                <?php }?>
                                            </select>
                                            <?php if(isset($stateErr)): ?><span class="bg-danger text-white px-2 rounded"><?= $stateErr ?></span><?php endif ?>
                                        </div>
                                    </div>
                                    <div class="form-row mt-3">
                                        <div class="col-md-12 text-center">
                                            <button type="submit" name="updateLocation" class="btn btn-xs btn-primary mr-3">Update</button>

                                        </div>
                                    </div>
                                    <?php endif ?>

                                    <?php if(isset($_GET['d']) && $_GET['d'] == "edit-info"): ?>
                                    <div class="form-row" id="edit-description">
                                        <div class="form-group col-md-12">
                                            <label>Overview</label>
                                            <textarea name="overview" id="" rows="10" class="form-control tinyeditor" placeholder=""><?php if(isset($_POST['overview'])){ echo $_POST['overview']; }else{ echo $dbOverview; } ?></textarea>
                                            <?php if(isset($overviewErr)): ?><span class="bg-danger text-white px-2 rounded"><?= $overviewErr ?></span><?php endif ?>
                                        </div>
                                        <div class="form-group col-md-12">
                                            <label>Application Mode</label>
                                            <textarea name="appMode" id="" rows="10" class="form-control tinyeditor" placeholder=""><?php if(isset($_POST['appMode'])){ echo $_POST['appMode']; }else{ echo $dbAppMode; } ?></textarea>
                                            <?php if(isset($appModeErr)): ?><span class="bg-danger text-white px-2 rounded"><?= $appModeErr ?></span><?php endif ?>
                                        </div>
                                        <div class="form-group col-md-12">
                                            <label>Qualifications</label>
                                            <textarea name="qualifications" id="" rows="10" class="form-control tinyeditor" placeholder=""><?php if(isset($_POST['qualifications'])){ echo $_POST['qualifications']; }else{ echo $dbQualifications; } ?></textarea>
                                            <?php if(isset($qualificationsErr)): ?><span class="bg-danger text-white px-2 rounded"><?= $qualificationsErr ?></span><?php endif ?>
                                        </div>
                                        <div class="form-group col-md-12">
                                            <label>Responsibilities</label>
                                            <textarea name="responsibilities" id="" rows="10" class="form-control tinyeditor" placeholder=""><?php if(isset($_POST['responsibilities'])){ echo $_POST['responsibilities']; }else{ echo $dbResponsibilities; } ?></textarea>
                                            <?php if(isset($responsibilitiesErr)): ?><span class="bg-danger text-white px-2 rounded"><?= $responsibilitiesErr ?></span><?php endif ?>
                                        </div>
                                    </div>
                                    <div class="form-row mt-3">
                                        <div class="col-md-12 text-center">
                                            <button type="submit" name="updateInfo" class="btn btn-xs btn-primary mr-3">Update</button>

                                        </div>
                                    </div>
                                    <?php endif ?>

                                    <?php if(isset($_GET['d']) && $_GET['d'] == "change-cover"): ?>
                                    <div class="form-row" id="edit-lga">
                                        <div class="col-md-12">
                                            <label for="input-file-now">Image <small class="text-info">(jpg/png format expected)</small> *</label>
                                            <div class="input-group mb-3">
                                                <div class="input-group-prepend">
                                                    <span class="input-group-text">Upload</span>
                                                </div>
                                                <div class="custom-file">
                                                    <input type="file" class="custom-file-input" name="coverImage" onChange="displayImage2(this)">
                                                    <label class="custom-file-label">Choose file</label>
                                                </div>
                                            </div>
                                            <span class="text-danger"><?php if(isset($coverImageErr)){ echo $coverImageErr; } ?></span>
                                        </div>

                                        <div class="col-md-12">
                                            <label class="box-title">Current Image </label>
                                            <div class="rounded-lg border-0 img-box img-box-normal">
                                                <img src="<?= $uploadsRoot; ?>images/careers/<?= $dbCareerImg; ?>" class="imageThumb2 rounded-lg">
                                            </div>
                                        </div>
                                    </div>
                                    <div class="form-row mt-3">
                                        <div class="col-md-12 text-center">
                                            <button type="submit" name="changeCover" class="btn btn-xs btn-primary mr-3">Update</button>

                                        </div>
                                    </div>
                                    <?php endif ?>
                                </form>
                            </div>
                        </div>
                    </div>
                    <?php endif ?>
                    <div class="col-md-<?php if(isset($_GET['sz']) && $_GET['sz'] == "min"){echo 8;}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">Title</th>
                                            <th scope="col">Location</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 = mysqli_query($db, "SELECT * FROM careers");
                                    while($row = mysqli_fetch_array($q)){
                                        $id = $row['id']; $name = $row['name'];
                                        $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' || $status == 'Active'): ?>
                                                            <li><a class="dropdown-item" href="<?= $adminRoot ?>careers?id=<?= $id ?>&sz=min&d=edit-title">Edit Title</a></li>
                                                            <li><a class="dropdown-item" href="<?= $adminRoot ?>careers?id=<?= $id ?>&sz=min&d=edit-state">Edit State</a></li>
                                                            <li><a class="dropdown-item" href="<?= $adminRoot ?>careers?id=<?= $id ?>&sz=min&d=edit-info">Edit Info</a></li>
                                                            <li><a class="dropdown-item" href="<?= $adminRoot ?>careers?id=<?= $id ?>&sz=min&d=change-cover">Change Cover</a></li>
                                                            <li><a class="dropdown-item" href="<?= $adminRoot ?>careers?id=<?= $id ?>&d=dactv-career">Deactivate</a></li>
                                                            <?php else: ?>
                                                            <li><a class="dropdown-item" href="<?= $adminRoot ?>careers?id=<?= $id ?>&d=actv-career">Activate</a></li>
                                                            <li><a class="dropdown-item" href="<?= $adminRoot ?>careers?id=<?= $id ?>&d=dlt-career">Delete</a></li>
                                                            <?php endif ?>
                                                        </ul>
                                                    </div>
                                                </div>
                                            </td>
                                            <td><?= $name ?></td>
                                            <td><?= getDBVal('states',$row['location']) ?></td>
                                            <td><img src="<?= $uploadsRoot; ?>images/careers/<?= $row['coverImg']; ?>" class="rounded-lg" height="50"></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>
                                </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"); ?>