1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / nc6d095 / www / admin / view /
Filename : loyalty-activities.php
back
<?php
global $now, $db;
include('../inc/config.php');
include('../inc/auth.php');

const TITLE = 'Manage Activities';
const HEADER = 'Activities';
const BREADCRUMB = 'activities';

if(isset($_GET['d'])){
    $d = $_GET['d'];
    if($d == "new-activity"){ $crdTitle = "Add New Activity"; }
    if($d == "edit-activity"){
        if(isset($_GET['id'])){ $id = $_GET['id']; }
        $dbActivity = getDBVal('social_posts',$id,"title");
        $dbPostImg = getDBVal('social_posts',$id,"coverImg");
        $dbFBL = getDBVal('social_posts',$id,"fbL");
        $dbFBS = getDBVal('social_posts',$id,"fbS");
        $dbFBC = getDBVal('social_posts',$id,"fbC");
        $dbIGL = getDBVal('social_posts',$id,"igL");
        $dbIGS = getDBVal('social_posts',$id,"igS");
        $dbIGC = getDBVal('social_posts',$id,"igC");
        $dbTKL = getDBVal('social_posts',$id,"tkL");
        $dbTKS = getDBVal('social_posts',$id,"tkS");
        $dbTKC = getDBVal('social_posts',$id,"tkC");
        $dbYTL = getDBVal('social_posts',$id,"ytL");
        $dbYTS = getDBVal('social_posts',$id,"ytS");
        $dbYTC = getDBVal('social_posts',$id,"ytC");
        $dbTWL = getDBVal('social_posts',$id,"twL");
        $dbTWR = getDBVal('social_posts',$id,"twR");
        $dbTWC = getDBVal('social_posts',$id,"twC");
        $dbLKL = getDBVal('social_posts',$id,"lkL");
        $dbLKR = getDBVal('social_posts',$id,"lkR");
        $dbLKC = getDBVal('social_posts',$id,"lkC");
        $dbWAS = getDBVal('social_posts',$id,"waS");
        $crdTitle = "Edit Activity (<small>".strtolower($dbActivity).")</small>";
    }
}

#logics
#save activity
if(isset($_POST['saveActivity'])){
    $uploadPath = "../uploads/images/loyalty-posts/";
    #data cleaning & scrutinization
    $postTitle = trim(stripslashes(mysqli_real_escape_string($db, $_POST['postTitle'])));
    $coverImg = $_FILES['coverImg']['name'];
    #facebook
    if(isset($_POST['fbLike'])){ $fbLike = 1; }else{ $fbLike = 0; }
    if(isset($_POST['fbShare'])){ $fbShare = 1; }else{ $fbShare = 0; }
    if(isset($_POST['fbComment'])){ $fbComment = 1; }else{ $fbComment = 0; }
    #twitter
    if(isset($_POST['twLike'])){ $twLike = 1; }else{ $twLike = 0; }
    if(isset($_POST['twRetweet'])){ $twRetweet = 1; }else{ $twRetweet = 0; }
    if(isset($_POST['twComment'])){ $twComment = 1; }else{ $twComment = 0; }
    #linkedin
    if(isset($_POST['lkLike'])){ $lkLike = 1; }else{ $lkLike = 0; }
    if(isset($_POST['lkRepost'])){ $lkRepost = 1; }else{ $lkRepost = 0; }
    if(isset($_POST['lkComment'])){ $lkComment = 1; }else{ $lkComment = 0; }
    #instagram
    if(isset($_POST['igLike'])){ $igLike = 1; }else{ $igLike = 0; }
    if(isset($_POST['igShare'])){ $igShare = 1; }else{ $igShare = 0; }
    if(isset($_POST['igComment'])){ $igComment = 1; }else{ $igComment = 0; }
    #tiktok
    if(isset($_POST['tkLike'])){ $tkLike = 1; }else{ $tkLike = 0; }
    if(isset($_POST['tkShare'])){ $tkShare = 1; }else{ $tkShare = 0; }
    if(isset($_POST['tkComment'])){ $tkComment = 1; }else{ $tkComment = 0; }
    #youtube
    if(isset($_POST['ytLike'])){ $ytLike = 1; }else{ $ytLike = 0; }
    if(isset($_POST['ytShare'])){ $ytShare = 1; }else{ $ytShare = 0; }
    if(isset($_POST['ytComment'])){ $ytComment = 1; }else{ $ytComment = 0; }
    #whatsapp
    if(isset($_POST['waShare'])){ $waShare = 1; }else{ $waShare = 0; }
    #data validation
    if(empty($coverImg)){ $errs[] = $coverImgErr = "cover image expected"; }
    else{
        $ext = strtolower(pathinfo($_FILES['coverImg']['name'], PATHINFO_EXTENSION));
        $allowedExts = ['jpg','png','jpeg'];
        if(!in_array($ext,$allowedExts)){
            $errs[] = $coverImgErr = "Invalid file format encountered. Only jpg/png/jpeg allowed";
        }
    }
    if(empty($postTitle)){ $errs[] = $postTitleErr = "please enter a value"; }
    else{
        $rowCnt = checkDuplicates('social_posts', "title='$postTitle'");
        if($rowCnt > 0){
            $errs[] = $activityExistErr = "";
            $emsg = "Activity '$postTitle' already exists";
        }
    }

    #execute when errors have been solved
    if(count($errs) == 0){
        $newTitle = md5($postTitle).".".$ext;
        $jpgImg = md5($postTitle).".jpg";
        $pngImg = md5($postTitle).".png";
        $jpegImg = md5($postTitle).".jpeg";
        $q = dbInsert("social_posts", ['title' => $postTitle, 'coverImg' => $newTitle, 'fbL'=>$fbLike, 'fbS'=>$fbShare, 'fbC'=>$fbComment, 'igL'=>$igLike, 'igS'=>$igShare, 'igC'=>$igComment, 'tkL'=>$tkLike, 'tkS'=>$tkShare, 'tkC'=>$tkComment, 'ytL'=>$ytLike, 'ytS'=>$ytShare, 'ytC'=>$ytComment, 'twL'=>$twLike, 'twR'=>$twRetweet, 'twC'=>$twComment, 'lkL'=>$lkLike, 'lkR'=>$lkRepost, 'lkC'=>$lkComment, 'waS'=>$waShare, 'dc' => $now]);
        if($q){
            if(file_exists($uploadPath.$pngImg)) unlink($uploadPath.$pngImg);
            if(file_exists($uploadPath.$jpgImg)) unlink($uploadPath.$jpgImg);
            if(file_exists($uploadPath.$jpegImg)) unlink($uploadPath.$jpegImg);
            $absolutePath = $uploadPath.$newTitle;
            // Compress Image
            compressImage($_FILES['coverImg']['tmp_name'],$absolutePath,50);
            $smsg = "Activity '$postTitle' added successfully";
            $preventResubmission = true;
        }
        else{
           $emsg = "Action not successful. Try again later";
        }
    }
}

#update activity
if(isset($_POST['updateActivities'])){
    #data cleaning & scrutinization
    #facebook
    if(isset($_POST['fbLike'])){ $fbLike = 1; }else{ $fbLike = 0; }
    if(isset($_POST['fbShare'])){ $fbShare = 1; }else{ $fbShare = 0; }
    if(isset($_POST['fbComment'])){ $fbComment = 1; }else{ $fbComment = 0; }
    #twitter
    if(isset($_POST['twLike'])){ $twLike = 1; }else{ $twLike = 0; }
    if(isset($_POST['twRetweet'])){ $twRetweet = 1; }else{ $twRetweet = 0; }
    if(isset($_POST['twComment'])){ $twComment = 1; }else{ $twComment = 0; }
    #linkedin
    if(isset($_POST['lkLike'])){ $lkLike = 1; }else{ $lkLike = 0; }
    if(isset($_POST['lkRepost'])){ $lkRepost = 1; }else{ $lkRepost = 0; }
    if(isset($_POST['lkComment'])){ $lkComment = 1; }else{ $lkComment = 0; }
    #instagram
    if(isset($_POST['igLike'])){ $igLike = 1; }else{ $igLike = 0; }
    if(isset($_POST['igShare'])){ $igShare = 1; }else{ $igShare = 0; }
    if(isset($_POST['igComment'])){ $igComment = 1; }else{ $igComment = 0; }
    #tiktok
    if(isset($_POST['tkLike'])){ $tkLike = 1; }else{ $tkLike = 0; }
    if(isset($_POST['tkShare'])){ $tkShare = 1; }else{ $tkShare = 0; }
    if(isset($_POST['tkComment'])){ $tkComment = 1; }else{ $tkComment = 0; }
    #youtube
    if(isset($_POST['ytLike'])){ $ytLike = 1; }else{ $ytLike = 0; }
    if(isset($_POST['ytShare'])){ $ytShare = 1; }else{ $ytShare = 0; }
    if(isset($_POST['ytComment'])){ $ytComment = 1; }else{ $ytComment = 0; }
    #whatsapp
    if(isset($_POST['waShare'])){ $waShare = 1; }else{ $waShare = 0; }

    #execute when errors have been solved
    if(count($errs) == 0){
        $q = dbUpdate("social_posts", ['fbL'=>$fbLike, 'fbS'=>$fbShare, 'fbC'=>$fbComment, 'igL'=>$igLike, 'igS'=>$igShare, 'igC'=>$igComment, 'tkL'=>$tkLike, 'tkS'=>$tkShare, 'tkC'=>$tkComment, 'ytL'=>$ytLike, 'ytS'=>$ytShare, 'ytC'=>$ytComment, 'twL'=>$twLike, 'twR'=>$twRetweet, 'twC'=>$twComment, 'lkL'=>$lkLike, 'lkR'=>$lkRepost, 'lkC'=>$lkComment, 'waS'=>$waShare, 'du' => $now], "id=$id");
        if($q){
            $smsg = "Activity '$dbActivity' updated successfully";
            jsRefresh($adminRoot."loyalty-activities?id=$id&sz=min&d=edit-activity",2000);
        }
        else{
           $emsg = "Action not successful. Try again later";
        }
    }
}

#update post
if(isset($_POST['updateTitle'])){
    #data cleaning & scrutinization
    $postTitle = trim(stripslashes(mysqli_real_escape_string($db, $_POST['postTitle'])));
    #data validation
    if(empty($postTitle)){ $errs[] = $postTitleErr = "please enter a value"; }
    #prpost duplicates
    if(!empty($postTitle)){
        $rowCnt = checkDuplicates('social_posts', "title='$postTitle' AND id<>$id");
        $rowCnt2 = checkDuplicates('social_posts', "title='$postTitle' AND id=$id");
        if($rowCnt > 0){ $errs[] = $postExistErr = ""; $emsg = "Activity '$postTitle' already exists"; }
        if($rowCnt2 > 0){ $errs[] = $postExistErr = ""; $emsg = "Modification is required to continue"; }
    }
    #execute when errors have been solved
    if(count($errs) == 0){
        if($dbPostImg == 'default.png'){
            $q = dbUpdate("social_posts",['title'=>$postTitle, 'du'=>$now],"id=".$id);
        }else{
            $ext = explode(".",$dbPostImg);
            $ext = end($ext);
            $newTitle = md5(makeSlug($postTitle)).".".$ext;
            $uploadPath = "../uploads/images/loyalty-posts/";
            rename($uploadPath.$dbPostImg,$uploadPath.$newTitle);
            $q = dbUpdate("social_posts",['title'=>$postTitle, 'coverImg'=>$newTitle, 'du'=>$now],"id=".$id);
        }
        if($q){
            $smsg = "'$dbActivity' updated to '$postTitle' successfully"; $preventResubmission = true;
            jsRefresh($adminRoot."loyalty-activities?id=$id&sz=min&d=edit-activity",2000);
        }
        else{
            $emsg = "Action not successful. Try again later";
        }
    }
}


//change cover image
if(isset($_POST['changeCover'])){
    $uploadPath = "../uploads/images/loyalty-posts/";
    $coverImage = $_FILES['coverImage']['name'];
    //get the extension of the uploaded image
    $ext = strtolower(pathinfo($_FILES['coverImage']['name'], PATHINFO_EXTENSION));
    $allowedExts = ['jpg','png','jpeg'];
    if(!in_array($ext,$allowedExts)){
        $errs[] = $coverImgErr = "Invalid file format encountered. Only jpg/png/jpeg allowed";
    }
    if(count($errs) == 0){
        $newTitle = md5($dbActivity).".".$ext;
        $jpgImg = md5($dbActivity).".jpg";
        $jpegImg = md5($dbActivity).".jpeg";
        $pngImg = md5($dbActivity).".png";
        $q = dbUpdate("social_posts",['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);
            if(file_exists($uploadPath.$jpegImg)) unlink($uploadPath.$jpegImg);
            $absolutePath = $uploadPath.$newTitle;
            // Compress Image
            compressImage($_FILES['coverImage']['tmp_name'],$absolutePath,50);
            $smsg = "cover for post '$dbActivity' has been updated successfully";
            jsRefresh($adminRoot."loyalty-activities?id=$id&sz=min&d=edit-activity",2000);
        }
        else{
            $emsg = "Something went wrong. Please try again later";
        }
    }
}

#manage activity status
if(isset($_GET['d']) && isset($_GET['id'])){
    $d = $_GET['d'];
    $id = $_GET['id'];
    $dbActivity = getDBVal('social_posts',$id,"title");
    if($d == 'publish-activity' && checkPending('social_posts', $id)){
        $q = changeStatus('social_posts','published',$id);
        if($q){ $smsg = "activity '$dbActivity' published successfully"; }else{ $emsg = "something went wrong."; }
    }
    if($d == 'hide-activity' && checkPublished('social_posts',$id) == true){
        $q = changeStatus('social_posts','pending',$id);
        if($q){ $smsg = "activity '$dbActivity' unpublished successfully"; }else{ $emsg = "something went wrong."; }
    }
    if($d == 'dlt-activity'){
        $dltItem = true;
        $dltmsg = "Are you sure you want to delete the activity '$dbActivity'";
        $url = $adminRoot."loyalty-activities";
        if(isset($_POST['doDlt'])){
            $dltItem = false;
            $q = dltRow('social_posts',$id);
            if($q){ $smsg = "activity '$dbActivity' deleted successfully"; jsRefresh($adminRoot."loyalty-activities",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">
                                <a href="<?= $adminRoot ?>loyalty-activities?d=new-activity&sz=min" class="btn btn-xs btn-outline-primary" title="Add New"><i class="fa fa-plus"></i></a>
                                <a href="<?= $adminRoot ?>loyalty-activities" 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">
                    <?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 ?>activities" 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-activity"): ?>
                                <form action="" method="post" enctype="multipart/form-data">
                                    <div class="form-row" id="new-activity">
                                        <div class="form-group col-md-12">
                                            <label>Activity</label>
                                            <input type="text" class="form-control" name="postTitle" value="<?php if(isset($_POST['postTitle'])){ echo $_POST['postTitle']; } ?>">
                                            <?php if(isset($postTitleErr)): ?><span class="bg-danger text-white px-2 rounded"><?= $postTitleErr ?></span><?php endif ?>
                                        </div>
                                        <div class="col-md-12">
                                            <label for="input-file-now">Cover Image <small class="text-info">(jpg/png format expected)</small> *</label>
                                            <div class="input-group">
                                                <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="coverImg" onChange="displayImage(this)">
                                                    <label class="custom-file-label">Choose file</label>
                                                </div>
                                            </div>
                                            <?php if(isset($coverImgErr)): ?><span class="bg-danger text-white px-2 rounded"><?= $coverImgErr ?></span><?php endif ?>
                                        </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/loyalty-posts/default.png" class="imageThumb rounded-lg">
                                            </div>
                                        </div>
                                        <div class="col-md-12 mt-3">
                                            <div class="card">
                                                <div class="social-graph-wrapper widget-facebook">
                                                    <span class="s-icon"><i class="fa fa-facebook"></i></span>
                                                </div>
                                                <div class="row">
                                                    <div class="col-4 border-right">
                                                        <div class="pt-3 pb-3 pl-0 pr-0 text-center">
                                                            <div class="custom-control custom-checkbox mb-3 check-lg">
                                                                <input type="checkbox" class="custom-control-input" id="fbLike" name="fbLike" <?= isset($_POST['fbLike']) ? "checked" : '' ?>>
                                                                <label class="custom-control-label" for="fbLike"></label>
                                                            </div>
                                                            <p class="m-0">Like</p>
                                                        </div>
                                                    </div>
                                                    <div class="col-4 border-right">
                                                        <div class="pt-3 pb-3 pl-0 pr-0 text-center">
                                                            <div class="custom-control custom-checkbox mb-3 check-lg">
                                                                <input type="checkbox" class="custom-control-input" id="fbShare" name="fbShare" <?= isset($_POST['fbShare']) ? "checked" : '' ?>>
                                                                <label class="custom-control-label" for="fbShare"></label>
                                                            </div>
                                                            <p class="m-0">Share</p>
                                                        </div>
                                                    </div>
                                                    <div class="col-4">
                                                        <div class="pt-3 pb-3 pl-0 pr-0 text-center">
                                                            <div class="custom-control custom-checkbox mb-3 check-lg">
                                                                <input type="checkbox" class="custom-control-input" id="fbComment" name="fbComment" <?= isset($_POST['fbComment']) ? "checked" : '' ?>>
                                                                <label class="custom-control-label" for="fbComment"></label>
                                                            </div>
                                                            <p class="m-0">Comment</p>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                        <div class="col-md-12 mt-3">
                                            <div class="card">
                                                <div class="social-graph-wrapper widget-twitter">
                                                    <span class="s-icon"><i class="fa fa-twitter"></i></span>
                                                </div>
                                                <div class="row">
                                                    <div class="col-4 border-right">
                                                        <div class="pt-3 pb-3 pl-0 pr-0 text-center">
                                                            <div class="custom-control custom-checkbox mb-3 check-lg">
                                                                <input type="checkbox" class="custom-control-input" id="twLike" name="twLike" <?= isset($_POST['twLike']) ? "checked" : '' ?>>
                                                                <label class="custom-control-label" for="twLike"></label>
                                                            </div>
                                                            <p class="m-0">Like</p>
                                                        </div>
                                                    </div>
                                                    <div class="col-4 border-right">
                                                        <div class="pt-3 pb-3 pl-0 pr-0 text-center">
                                                            <div class="custom-control custom-checkbox mb-3 check-lg">
                                                                <input type="checkbox" class="custom-control-input" id="twRetweet" name="twRetweet" <?= isset($_POST['twRetweet']) ? "checked" : '' ?>>
                                                                <label class="custom-control-label" for="twRetweet"></label>
                                                            </div>
                                                            <p class="m-0">Retweet</p>
                                                        </div>
                                                    </div>
                                                    <div class="col-4">
                                                        <div class="pt-3 pb-3 pl-0 pr-0 text-center">
                                                            <div class="custom-control custom-checkbox mb-3 check-lg">
                                                                <input type="checkbox" class="custom-control-input" id="twComment" name="twComment" <?= isset($_POST['twComment']) ? "checked" : '' ?>>
                                                                <label class="custom-control-label" for="twComment"></label>
                                                            </div>
                                                            <p class="m-0">Comment</p>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                        <div class="col-md-12 mt-3">
                                            <div class="card">
                                                <div class="social-graph-wrapper widget-linkedin">
                                                    <span class="s-icon"><i class="fa fa-linkedin"></i></span>
                                                </div>
                                                <div class="row">
                                                    <div class="col-4 border-right">
                                                        <div class="pt-3 pb-3 pl-0 pr-0 text-center">
                                                            <div class="custom-control custom-checkbox mb-3 check-lg">
                                                                <input type="checkbox" class="custom-control-input" id="lkLike" name="lkLike" <?= isset($_POST['lkLike']) ? "checked" : '' ?>>
                                                                <label class="custom-control-label" for="lkLike"></label>
                                                            </div>
                                                            <p class="m-0">Like</p>
                                                        </div>
                                                    </div>
                                                    <div class="col-4 border-right">
                                                        <div class="pt-3 pb-3 pl-0 pr-0 text-center">
                                                            <div class="custom-control custom-checkbox mb-3 check-lg">
                                                                <input type="checkbox" class="custom-control-input" id="lkRepost" name="lkRepost" <?= isset($_POST['lkRepost']) ? "checked" : '' ?>>
                                                                <label class="custom-control-label" for="lkRepost"></label>
                                                            </div>
                                                            <p class="m-0">Repost</p>
                                                        </div>
                                                    </div>
                                                    <div class="col-4">
                                                        <div class="pt-3 pb-3 pl-0 pr-0 text-center">
                                                            <div class="custom-control custom-checkbox mb-3 check-lg">
                                                                <input type="checkbox" class="custom-control-input" id="lkComment" name="lkComment" <?= isset($_POST['lkComment']) ? "checked" : '' ?>>
                                                                <label class="custom-control-label" for="lkComment"></label>
                                                            </div>
                                                            <p class="m-0">Comment</p>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                        <div class="col-md-12 mt-3">
                                            <div class="card">
                                                <div class="social-graph-wrapper bg-pink">
                                                    <span class="s-icon"><i class="fa fa-instagram"></i></span>
                                                </div>
                                                <div class="row">
                                                    <div class="col-4 border-right">
                                                        <div class="pt-3 pb-3 pl-0 pr-0 text-center">
                                                            <div class="custom-control custom-checkbox mb-3 check-lg">
                                                                <input type="checkbox" class="custom-control-input" id="igLike" name="igLike" <?= isset($_POST['igLike']) ? "checked" : '' ?>>
                                                                <label class="custom-control-label" for="igLike"></label>
                                                            </div>
                                                            <p class="m-0">Like</p>
                                                        </div>
                                                    </div>
                                                    <div class="col-4 border-right">
                                                        <div class="pt-3 pb-3 pl-0 pr-0 text-center">
                                                            <div class="custom-control custom-checkbox mb-3 check-lg">
                                                                <input type="checkbox" class="custom-control-input" id="igShare" name="igShare" <?= isset($_POST['igShare']) ? "checked" : '' ?>>
                                                                <label class="custom-control-label" for="igShare"></label>
                                                            </div>
                                                            <p class="m-0">Share</p>
                                                        </div>
                                                    </div>
                                                    <div class="col-4">
                                                        <div class="pt-3 pb-3 pl-0 pr-0 text-center">
                                                            <div class="custom-control custom-checkbox mb-3 check-lg">
                                                                <input type="checkbox" class="custom-control-input" id="igComment" name="igComment" <?= isset($_POST['igComment']) ? "checked" : '' ?>>
                                                                <label class="custom-control-label" for="igComment"></label>
                                                            </div>
                                                            <p class="m-0">Comment</p>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                        <div class="col-md-12 mt-3">
                                            <div class="card">
                                                <div class="social-graph-wrapper bg-dark">
                                                    <span class="s-icon"><i class="bi bi-tiktok"></i></span>
                                                </div>
                                                <div class="row">
                                                    <div class="col-4 border-right">
                                                        <div class="pt-3 pb-3 pl-0 pr-0 text-center">
                                                            <div class="custom-control custom-checkbox mb-3 check-lg">
                                                                <input type="checkbox" class="custom-control-input" id="tkLike" name="tkLike" <?= isset($_POST['tkLike']) ? "checked" : '' ?>>
                                                                <label class="custom-control-label" for="tkLike"></label>
                                                            </div>
                                                            <p class="m-0">Like</p>
                                                        </div>
                                                    </div>
                                                    <div class="col-4 border-right">
                                                        <div class="pt-3 pb-3 pl-0 pr-0 text-center">
                                                            <div class="custom-control custom-checkbox mb-3 check-lg">
                                                                <input type="checkbox" class="custom-control-input" id="tkShare" name="tkShare" <?= isset($_POST['tkShare']) ? "checked" : '' ?>>
                                                                <label class="custom-control-label" for="tkShare"></label>
                                                            </div>
                                                            <p class="m-0">Share</p>
                                                        </div>
                                                    </div>
                                                    <div class="col-4">
                                                        <div class="pt-3 pb-3 pl-0 pr-0 text-center">
                                                            <div class="custom-control custom-checkbox mb-3 check-lg">
                                                                <input type="checkbox" class="custom-control-input" id="tkComment" name="tkComment" <?= isset($_POST['tkComment']) ? "checked" : '' ?>>
                                                                <label class="custom-control-label" for="tkComment"></label>
                                                            </div>
                                                            <p class="m-0">Comment</p>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                        <div class="col-md-12 mt-3">
                                            <div class="card">
                                                <div class="social-graph-wrapper bg-red">
                                                    <span class="s-icon"><i class="fa fa-youtube"></i></span>
                                                </div>
                                                <div class="row">
                                                    <div class="col-4 border-right">
                                                        <div class="pt-3 pb-3 pl-0 pr-0 text-center">
                                                            <div class="custom-control custom-checkbox mb-3 check-lg">
                                                                <input type="checkbox" class="custom-control-input" id="ytLike" name="ytLike" <?= isset($_POST['ytLike']) ? "checked" : '' ?>>
                                                                <label class="custom-control-label" for="ytLike"></label>
                                                            </div>
                                                            <p class="m-0">Like</p>
                                                        </div>
                                                    </div>
                                                    <div class="col-4 border-right">
                                                        <div class="pt-3 pb-3 pl-0 pr-0 text-center">
                                                            <div class="custom-control custom-checkbox mb-3 check-lg">
                                                                <input type="checkbox" class="custom-control-input" id="ytShare" name="ytShare" <?= isset($_POST['ytShare']) ? "checked" : '' ?>>
                                                                <label class="custom-control-label" for="ytShare"></label>
                                                            </div>
                                                            <p class="m-0">Share</p>
                                                        </div>
                                                    </div>
                                                    <div class="col-4">
                                                        <div class="pt-3 pb-3 pl-0 pr-0 text-center">
                                                            <div class="custom-control custom-checkbox mb-3 check-lg">
                                                                <input type="checkbox" class="custom-control-input" id="ytComment" name="ytComment" <?= isset($_POST['ytComment']) ? "checked" : '' ?>>
                                                                <label class="custom-control-label" for="ytComment"></label>
                                                            </div>
                                                            <p class="m-0">Comment</p>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                        <div class="col-md-12 mt-3">
                                            <div class="card">
                                                <div class="social-graph-wrapper bg-green">
                                                    <span class="s-icon"><i class="fa fa-whatsapp"></i></span>
                                                </div>
                                                <div class="row">
                                                    <div class="col-12">
                                                        <div class="pt-3 pb-3 pl-0 pr-0 text-center">
                                                            <div class="custom-control custom-checkbox mb-3 check-lg">
                                                                <input type="checkbox" class="custom-control-input" id="waShare" name="waShare" <?= isset($_POST['waShare']) ? "checked" : '' ?>>
                                                                <label class="custom-control-label" for="waShare"></label>
                                                            </div>
                                                            <p class="m-0">Share</p>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="form-row mt-3">
                                        <div class="col-md-12 text-center">
                                            <button type="submit" name="saveActivity" class="btn btn-xs btn-primary mr-3">Add Activity</button>
                                        </div>
                                    </div>
                                </form>
                                <?php endif ?>

                                <?php if(isset($_GET['d']) && $_GET['d'] == "edit-activity"): ?>
                                <form action="" method="post">
                                    <div class="form-row">
                                        <div class="form-group col-md-12">
                                            <label for="">Title</label>
                                            <input type="text" class="form-control" name="postTitle" value="<?php if(isset($_POST['postTitle'])){ echo $_POST['postTitle']; }else{ echo $dbActivity; } ?>">
                                            <?php if(isset($postTitleErr)): ?><span class="bg-danger text-white px-2 rounded"><?= $postTitleErr ?></span><?php endif ?>
                                        </div>
                                    </div>
                                    <div class="form-row">
                                        <div class="col-md-12">
                                            <button type="submit" name="updateTitle" class="btn btn-xs btn-primary mr-3">Update Title</button>
                                        </div>
                                    </div>
                                </form>
                                <form action="" method="post" class="mt-3 pt-3 border-top" enctype="multipart/form-data">
                                    <div class="form-row">
                                        <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/loyalty-posts/<?= $dbPostImg; ?>" class="imageThumb2 rounded-lg">
                                            </div>
                                        </div>
                                    </div>
                                    <div class="form-row mt-3">
                                        <div class="col-md-12">
                                            <button type="submit" name="changeCover" class="btn btn-xs btn-primary mr-3">Update Cover Image</button>
                                        </div>
                                    </div>
                                </form>
                                <form action="" method="post" class="mt-3 pt-3 border-top">
                                    <div class="form-row">
                                        <div class="col-md-12 mt-3">
                                            <div class="card">
                                                <div class="social-graph-wrapper widget-facebook">
                                                    <span class="s-icon"><i class="fa fa-facebook"></i></span>
                                                </div>
                                                <div class="row">
                                                    <div class="col-4 border-right">
                                                        <div class="pt-3 pb-3 pl-0 pr-0 text-center">
                                                            <div class="custom-control custom-checkbox mb-3 check-lg">
                                                                <input type="checkbox" class="custom-control-input" id="fbLike" name="fbLike" <?= isset($_POST['fbLike']) || $dbFBL == 1 ? "checked" : '' ?>>
                                                                <label class="custom-control-label" for="fbLike"></label>
                                                            </div>
                                                            <p class="m-0">Like</p>
                                                        </div>
                                                    </div>
                                                    <div class="col-4 border-right">
                                                        <div class="pt-3 pb-3 pl-0 pr-0 text-center">
                                                            <div class="custom-control custom-checkbox mb-3 check-lg">
                                                                <input type="checkbox" class="custom-control-input" id="fbShare" name="fbShare" <?= isset($_POST['fbShare']) || $dbFBS == 1 ? "checked" : '' ?>>
                                                                <label class="custom-control-label" for="fbShare"></label>
                                                            </div>
                                                            <p class="m-0">Share</p>
                                                        </div>
                                                    </div>
                                                    <div class="col-4">
                                                        <div class="pt-3 pb-3 pl-0 pr-0 text-center">
                                                            <div class="custom-control custom-checkbox mb-3 check-lg">
                                                                <input type="checkbox" class="custom-control-input" id="fbComment" name="fbComment" <?= isset($_POST['fbComment']) || $dbFBC == 1 ? "checked" : '' ?>>
                                                                <label class="custom-control-label" for="fbComment"></label>
                                                            </div>
                                                            <p class="m-0">Comment</p>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                        <div class="col-md-12 mt-3">
                                            <div class="card">
                                                <div class="social-graph-wrapper widget-twitter">
                                                    <span class="s-icon"><i class="fa fa-twitter"></i></span>
                                                </div>
                                                <div class="row">
                                                    <div class="col-4 border-right">
                                                        <div class="pt-3 pb-3 pl-0 pr-0 text-center">
                                                            <div class="custom-control custom-checkbox mb-3 check-lg">
                                                                <input type="checkbox" class="custom-control-input" id="twLike" name="twLike" <?= isset($_POST['twLike']) || $dbTWL == 1 ? "checked" : '' ?>>
                                                                <label class="custom-control-label" for="twLike"></label>
                                                            </div>
                                                            <p class="m-0">Like</p>
                                                        </div>
                                                    </div>
                                                    <div class="col-4 border-right">
                                                        <div class="pt-3 pb-3 pl-0 pr-0 text-center">
                                                            <div class="custom-control custom-checkbox mb-3 check-lg">
                                                                <input type="checkbox" class="custom-control-input" id="twRetweet" name="twRetweet" <?= isset($_POST['twRetweet']) || $dbTWR == 1 ? "checked" : '' ?>>
                                                                <label class="custom-control-label" for="twRetweet"></label>
                                                            </div>
                                                            <p class="m-0">Retweet</p>
                                                        </div>
                                                    </div>
                                                    <div class="col-4">
                                                        <div class="pt-3 pb-3 pl-0 pr-0 text-center">
                                                            <div class="custom-control custom-checkbox mb-3 check-lg">
                                                                <input type="checkbox" class="custom-control-input" id="twComment" name="twComment" <?= isset($_POST['twComment']) || $dbTWC == 1 ? "checked" : '' ?>>
                                                                <label class="custom-control-label" for="twComment"></label>
                                                            </div>
                                                            <p class="m-0">Comment</p>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                        <div class="col-md-12 mt-3">
                                            <div class="card">
                                                <div class="social-graph-wrapper widget-linkedin">
                                                    <span class="s-icon"><i class="fa fa-linkedin"></i></span>
                                                </div>
                                                <div class="row">
                                                    <div class="col-4 border-right">
                                                        <div class="pt-3 pb-3 pl-0 pr-0 text-center">
                                                            <div class="custom-control custom-checkbox mb-3 check-lg">
                                                                <input type="checkbox" class="custom-control-input" id="lkLike" name="lkLike" <?= isset($_POST['lkLike']) || $dbLKL == 1 ? "checked" : '' ?>>
                                                                <label class="custom-control-label" for="lkLike"></label>
                                                            </div>
                                                            <p class="m-0">Like</p>
                                                        </div>
                                                    </div>
                                                    <div class="col-4 border-right">
                                                        <div class="pt-3 pb-3 pl-0 pr-0 text-center">
                                                            <div class="custom-control custom-checkbox mb-3 check-lg">
                                                                <input type="checkbox" class="custom-control-input" id="lkRepost" name="lkRepost" <?= isset($_POST['lkRepost']) || $dbLKR == 1 ? "checked" : '' ?>>
                                                                <label class="custom-control-label" for="lkRepost"></label>
                                                            </div>
                                                            <p class="m-0">Repost</p>
                                                        </div>
                                                    </div>
                                                    <div class="col-4">
                                                        <div class="pt-3 pb-3 pl-0 pr-0 text-center">
                                                            <div class="custom-control custom-checkbox mb-3 check-lg">
                                                                <input type="checkbox" class="custom-control-input" id="lkComment" name="lkComment" <?= isset($_POST['lkComment']) || $dbLKC == 1 ? "checked" : '' ?>>
                                                                <label class="custom-control-label" for="lkComment"></label>
                                                            </div>
                                                            <p class="m-0">Comment</p>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                        <div class="col-md-12 mt-3">
                                            <div class="card">
                                                <div class="social-graph-wrapper bg-pink">
                                                    <span class="s-icon"><i class="fa fa-instagram"></i></span>
                                                </div>
                                                <div class="row">
                                                    <div class="col-4 border-right">
                                                        <div class="pt-3 pb-3 pl-0 pr-0 text-center">
                                                            <div class="custom-control custom-checkbox mb-3 check-lg">
                                                                <input type="checkbox" class="custom-control-input" id="igLike" name="igLike" <?= isset($_POST['igLike']) || $dbIGL == 1 ? "checked" : '' ?>>
                                                                <label class="custom-control-label" for="igLike"></label>
                                                            </div>
                                                            <p class="m-0">Like</p>
                                                        </div>
                                                    </div>
                                                    <div class="col-4 border-right">
                                                        <div class="pt-3 pb-3 pl-0 pr-0 text-center">
                                                            <div class="custom-control custom-checkbox mb-3 check-lg">
                                                                <input type="checkbox" class="custom-control-input" id="igShare" name="igShare" <?= isset($_POST['igShare']) || $dbIGS == 1 ? "checked" : '' ?>>
                                                                <label class="custom-control-label" for="igShare"></label>
                                                            </div>
                                                            <p class="m-0">Share</p>
                                                        </div>
                                                    </div>
                                                    <div class="col-4">
                                                        <div class="pt-3 pb-3 pl-0 pr-0 text-center">
                                                            <div class="custom-control custom-checkbox mb-3 check-lg">
                                                                <input type="checkbox" class="custom-control-input" id="igComment" name="igComment" <?= isset($_POST['igComment']) || $dbIGC == 1 ? "checked" : '' ?>>
                                                                <label class="custom-control-label" for="igComment"></label>
                                                            </div>
                                                            <p class="m-0">Comment</p>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                        <div class="col-md-12 mt-3">
                                            <div class="card">
                                                <div class="social-graph-wrapper bg-dark">
                                                    <span class="s-icon"><i class="bi bi-tiktok"></i></span>
                                                </div>
                                                <div class="row">
                                                    <div class="col-4 border-right">
                                                        <div class="pt-3 pb-3 pl-0 pr-0 text-center">
                                                            <div class="custom-control custom-checkbox mb-3 check-lg">
                                                                <input type="checkbox" class="custom-control-input" id="tkLike" name="tkLike" <?= isset($_POST['tkLike']) || $dbTKL == 1 ? "checked" : '' ?>>
                                                                <label class="custom-control-label" for="tkLike"></label>
                                                            </div>
                                                            <p class="m-0">Like</p>
                                                        </div>
                                                    </div>
                                                    <div class="col-4 border-right">
                                                        <div class="pt-3 pb-3 pl-0 pr-0 text-center">
                                                            <div class="custom-control custom-checkbox mb-3 check-lg">
                                                                <input type="checkbox" class="custom-control-input" id="tkShare" name="tkShare" <?= isset($_POST['tkShare']) || $dbTKS == 1 ? "checked" : '' ?>>
                                                                <label class="custom-control-label" for="tkShare"></label>
                                                            </div>
                                                            <p class="m-0">Share</p>
                                                        </div>
                                                    </div>
                                                    <div class="col-4">
                                                        <div class="pt-3 pb-3 pl-0 pr-0 text-center">
                                                            <div class="custom-control custom-checkbox mb-3 check-lg">
                                                                <input type="checkbox" class="custom-control-input" id="tkComment" name="tkComment" <?= isset($_POST['tkComment']) || $dbTKC == 1 ? "checked" : '' ?>>
                                                                <label class="custom-control-label" for="tkComment"></label>
                                                            </div>
                                                            <p class="m-0">Comment</p>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                        <div class="col-md-12 mt-3">
                                            <div class="card">
                                                <div class="social-graph-wrapper bg-red">
                                                    <span class="s-icon"><i class="fa fa-youtube"></i></span>
                                                </div>
                                                <div class="row">
                                                    <div class="col-4 border-right">
                                                        <div class="pt-3 pb-3 pl-0 pr-0 text-center">
                                                            <div class="custom-control custom-checkbox mb-3 check-lg">
                                                                <input type="checkbox" class="custom-control-input" id="ytLike" name="ytLike" <?= isset($_POST['ytLike']) || $dbYTL == 1 ? "checked" : '' ?>>
                                                                <label class="custom-control-label" for="ytLike"></label>
                                                            </div>
                                                            <p class="m-0">Like</p>
                                                        </div>
                                                    </div>
                                                    <div class="col-4 border-right">
                                                        <div class="pt-3 pb-3 pl-0 pr-0 text-center">
                                                            <div class="custom-control custom-checkbox mb-3 check-lg">
                                                                <input type="checkbox" class="custom-control-input" id="ytShare" name="ytShare" <?= isset($_POST['ytShare']) || $dbYTS == 1 ? "checked" : '' ?>>
                                                                <label class="custom-control-label" for="ytShare"></label>
                                                            </div>
                                                            <p class="m-0">Share</p>
                                                        </div>
                                                    </div>
                                                    <div class="col-4">
                                                        <div class="pt-3 pb-3 pl-0 pr-0 text-center">
                                                            <div class="custom-control custom-checkbox mb-3 check-lg">
                                                                <input type="checkbox" class="custom-control-input" id="ytComment" name="ytComment" <?= isset($_POST['ytComment']) || $dbYTC == 1 ? "checked" : '' ?>>
                                                                <label class="custom-control-label" for="ytComment"></label>
                                                            </div>
                                                            <p class="m-0">Comment</p>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                        <div class="col-md-12 mt-3">
                                            <div class="card">
                                                <div class="social-graph-wrapper bg-green">
                                                    <span class="s-icon"><i class="fa fa-whatsapp"></i></span>
                                                </div>
                                                <div class="row">
                                                    <div class="col-12">
                                                        <div class="pt-3 pb-3 pl-0 pr-0 text-center">
                                                            <div class="custom-control custom-checkbox mb-3 check-lg">
                                                                <input type="checkbox" class="custom-control-input" id="waShare" name="waShare" <?= isset($_POST['waShare']) || $dbWAS == 1 ? "checked" : '' ?>>
                                                                <label class="custom-control-label" for="waShare"></label>
                                                            </div>
                                                            <p class="m-0">Share</p>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="form-row">
                                        <div class="col-md-12">
                                            <button type="submit" name="updateActivities" class="btn btn-xs btn-primary mr-3">Update Activities</button>
                                        </div>
                                    </div>
                                </form>
                                <?php endif ?>
                            </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">Cover</th>
                                            <th scope="col">Activities</th>
                                            <th scope="col">Responses</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('social_posts',"*",null,"dc DESC");
                                    while($row = mysqli_fetch_array($q)){
                                        $activityNo = 0;
                                        $id = $row['id']; $postTitle = $row['title'];
                                        $dc = $row['dc']; $du = $row['du']; $status = $row['status'];
                                        if($row['fbL'] == 1){ $activityNo += 1; }
                                        if($row['fbS'] == 1){ $activityNo += 1; }
                                        if($row['fbC'] == 1){ $activityNo += 1; }
                                        if($row['igL'] == 1){ $activityNo += 1; }
                                        if($row['igS'] == 1){ $activityNo += 1; }
                                        if($row['igC'] == 1){ $activityNo += 1; }
                                        if($row['tkL'] == 1){ $activityNo += 1; }
                                        if($row['tkS'] == 1){ $activityNo += 1; }
                                        if($row['tkC'] == 1){ $activityNo += 1; }
                                        if($row['ytL'] == 1){ $activityNo += 1; }
                                        if($row['ytS'] == 1){ $activityNo += 1; }
                                        if($row['ytC'] == 1){ $activityNo += 1; }
                                        if($row['twL'] == 1){ $activityNo += 1; }
                                        if($row['twR'] == 1){ $activityNo += 1; }
                                        if($row['twC'] == 1){ $activityNo += 1; }
                                        if($row['lkL'] == 1){ $activityNo += 1; }
                                        if($row['lkR'] == 1){ $activityNo += 1; }
                                        if($row['lkC'] == 1){ $activityNo += 1; }
                                        if($row['waS'] == 1){ $activityNo += 1; }
                                        $started = cntRows("social_post_responses","post=$id AND status='pending'");
                                        $submitted = cntRows("social_post_responses","post=$id AND status='submitted'");
                                        $settled = cntRows("social_post_responses","post=$id AND status='settled'");
                                    ?>
                                        <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($submitted > 0): ?>
                                                            <li><a class="dropdown-item" href="<?= $adminRoot ?>loyalty-responses?post=<?= $id ?>">View Response(s)</a></li>
                                                            <?php endif ?>
                                                            <?php if(strtolower($status) == 'published'): ?>
                                                            <li><a class="dropdown-item" href="<?= $adminRoot ?>loyalty-activities?id=<?= $id ?>&sz=min&d=edit-activity">Edit</a></li>
                                                            <li><a class="dropdown-item" href="<?= $adminRoot ?>loyalty-activities?id=<?= $id ?>&d=hide-activity">Mark Pending</a></li>
                                                            <li><a class="dropdown-item" href="<?= $adminRoot ?>loyalty-activities?id=<?= $id ?>&d=completed">Mark Completed</a></li>
                                                            <?php else: ?>
                                                            <li><a class="dropdown-item" href="<?= $adminRoot ?>loyalty-activities?id=<?= $id ?>&d=publish-activity">Publish</a></li>
                                                            <li><a class="dropdown-item" href="<?= $adminRoot ?>loyalty-activities?id=<?= $id ?>&d=dlt-activity">Delete</a></li>
                                                            <?php endif ?>
                                                        </ul>
                                                    </div>
                                                </div>
                                            </td>
                                            <td><?= $postTitle ?></td>
                                            <td><img src="<?= $uploadsRoot; ?>images/loyalty-posts/<?= $row['coverImg']; ?>" class="rounded-lg" height="50"></td>
                                            <td><?= $activityNo ?></td>
                                            <td>
                                                <p>
                                                    <strong>Started:</strong> <?= $started ?><br>
                                                    <strong>Submitted:</strong> <?= $submitted ?><br>
                                                    <strong>Settled:</strong> <?= $settled ?>
                                                </p>
                                            </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"); ?>