1#@!#!123s

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

const TITLE = 'Manage Delivery Modes';
const HEADER = 'Delivery Modes';
const BREADCRUMB = 'delivery-mode';

if(isset($_GET['d'])){
    $d = $_GET['d'];
    if($d == "new-mode"){ $crdTitle = "Add New Delivery Mode"; }
    if($d == "edit-mode"){
        if(isset($_GET['id'])){ $id = $_GET['id']; }
        $dbDeliveryMode = getDBVal('delivery_prefs',$id);
        $dbMoneyPercent = getDBVal('delivery_prefs',$id,'moneyPercentage');
        $dbPointPercent = getDBVal('delivery_prefs',$id,'pointPercentage');
        $crdTitle = "Edit Delivery Mode (<small>".strtolower($dbDeliveryMode).")</small>";
    }
}

#logics
#save mode
if(isset($_POST['saveDeliveryMode'])){
    #data cleaning & scrutinization
    $modeName = trim(stripslashes(mysqli_real_escape_string($db, $_POST['modeName'])));
    $moneyPercent = trim(intval($_POST['moneyPercent']));
    $pointPercent = trim(intval($_POST['pointPercent']));
    #data validation
    if(empty($modeName)){
        $errs[] = $modeNameErr = "please enter a value";
    }
    if($moneyPercent < 1){
        $errs[] = $moneyPercentErr = "please enter a value";
    }
    if($pointPercent < 1){
        $errs[] = $pointPercentErr = "please enter a value";
    }
    #prevent duplicates
    if(!empty($modeName)){
        $rowCnt = checkDuplicates('delivery_prefs', "name='$modeName'");
        if($rowCnt > 0){
            $errs[] = $modeExistErr = "";
            $emsg = "Delivery Mode '$modeName' already exists";
        }
    }
    #execute when errors have been solved
    if(count($errs) == 0){
        $q = dbInsert("delivery_prefs", ['name' => $modeName, 'moneyPercentage'=>$moneyPercent, 'pointPercentage'=>$pointPercent, 'dc' => $now]);
        if($q){
            $smsg = "Delivery Mode '$modeName' saved successfully";
            $preventResubmission = true;
        }
        else{
           $emsg = "Action not successful. Try again later";
        }
    }
}

#update mode
if(isset($_POST['updateDeliveryMode'])){
    #data cleaning & scrutinization
    $modeName = trim(stripslashes(mysqli_real_escape_string($db, $_POST['modeName'])));
    #data validation
    if(empty($modeName)){
        $errs[] = $modeNameErr = "please enter a value";
    }
    #prevent duplicates
    if(!empty($modeName)){
        $rowCnt = checkDuplicates('delivery_prefs', "name='$modeName' AND id<>$id");
        $rowCnt2 = checkDuplicates('delivery_prefs', "name='$modeName' AND id=$id");
        if($rowCnt > 0){
            $errs[] = $modeExistErr = "";
            $emsg = "Delivery Mode '$modeName' already exists";
        }
        if($rowCnt2 > 0){
            $errs[] = $modeExistErr = "";
            $emsg = "Modification is required to continue";
        }
    }
    #execute when errors have been solved
    if(count($errs) == 0){
        $q = dbUpdate("delivery_prefs",['name'=>$modeName, 'du'=>$now],"id=".$id);
        if($q){
            $smsg = "'$dbDeliveryMode' updated to '$modeName' successfully";
            $preventResubmission = true;
        }
        else{
           $emsg = "Action not successful. Try again later";
        }
    }
}

#update money percentage
if(isset($_POST['updateMoney'])){
    #data cleaning & scrutinization
    $moneyPercent = trim(intval($_POST['moneyPercent']));
    #data validation
    if($moneyPercent < 1 || $moneyPercent == $dbMoneyPercent){
        $errs[] = $moneyPercentErr = "please modify the value";
    }
    #execute when errors have been solved
    if(count($errs) == 0){
        $q = dbUpdate("delivery_prefs",['moneyPercentage'=>$moneyPercent, 'du'=>$now],"id=".$id);
        if($q){
            $smsg = "delivery method '$dbDeliveryMode' updated successfully";
            $preventResubmission = true;
        }
        else{
            $emsg = "Action not successful. Try again later";
        }
    }
}

#update money percentage
if(isset($_POST['updatePoint'])){
    #data cleaning & scrutinization
    $pointPercent = trim(intval($_POST['pointPercent']));
    #data validation
    if($pointPercent < 1 || $pointPercent == $dbPointPercent){
        $errs[] = $pointPercentErr = "please modify the value";
    }
    #execute when errors have been solved
    if(count($errs) == 0){
        $q = dbUpdate("delivery_prefs",['pointPercentage'=>$pointPercent, 'du'=>$now],"id=".$id);
        if($q){
            $smsg = "delivery method '$dbDeliveryMode' updated successfully";
            $preventResubmission = true;
        }
        else{
            $emsg = "Action not successful. Try again later";
        }
    }
}

#manage mode status
if(isset($_GET['d']) && isset($_GET['id'])){
    $d = $_GET['d'];
    $id = $_GET['id'];
    $dbDeliveryMode = getDBVal('delivery_prefs',$id);
    if($d == 'actv-mode' && checkInactive('delivery_prefs', $id)){
        $q = changeStatus('delivery_prefs','active',$id);
        if($q){ $smsg = "mode '$dbDeliveryMode' activated successfully"; }else{ $emsg = "something went wrong."; }
    }
    if($d == 'dactv-mode' && checkActive('delivery_prefs', $id)){
        $q = changeStatus('delivery_prefs','inactive',$id);
        if($q){ $smsg = "mode '$dbDeliveryMode' deactivated successfully"; }else{ $emsg = "something went wrong."; }
    }
    if($d == 'dlt-mode'){
        $dltItem = true;
        $dltmsg = "Are you sure you want to delete the mode '$dbDeliveryMode'";
        $url = $adminRoot."delivery-mode";
        if(isset($_POST['doDlt'])){
            $dltItem = false;
            $q = dltRow('delivery_prefs',$id);
            if($q){ $smsg = "mode '$dbDeliveryMode' deleted successfully"; jsRefresh($adminRoot."delivery-mode",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">
                                        <a href="<?= $adminRoot ?>delivery-mode?d=new-mode&sz=min" class="btn btn-xs btn-outline-primary"><i class="fa fa-plus"></i></a>

                                    <a href="<?= $adminRoot ?>delivery-mode" 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 ?>delivery-mode" 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-mode"): ?>
                                    <form action="" method="post" enctype="multipart/form-data">
                                        <div class="form-row" id="new-mode">
                                            <div class="form-group col-md-12">
                                                <label>Delivery Mode</label>
                                                <input type="text" class="form-control" name="modeName" value="<?php if(isset($_POST['modeName'])){ echo $_POST['modeName']; } ?>">
                                                <?php if(isset($modeNameErr)): ?><span class="bg-danger text-white px-2 rounded"><?= $modeNameErr ?></span><?php endif ?>
                                            </div>
                                            <div class="form-group col-md-6">
                                                <label>Money %</label>
                                                <input type="text" class="form-control num-only" name="moneyPercent" value="<?php if(isset($_POST['moneyPercent'])){ echo $_POST['moneyPercent']; } ?>">
                                                <?php if(isset($moneyPercentErr)): ?><span class="bg-danger text-white px-2 rounded"><?= $moneyPercentErr ?></span><?php endif ?>
                                            </div>
                                            <div class="form-group col-md-6">
                                                <label>Point %</label>
                                                <input type="text" class="form-control num-only" name="pointPercent" value="<?php if(isset($_POST['pointPercent'])){ echo $_POST['pointPercent']; } ?>">
                                                <?php if(isset($pointPercentErr)): ?><span class="bg-danger text-white px-2 rounded"><?= $pointPercentErr ?></span><?php endif ?>
                                            </div>
                                        </div>
                                        <div class="form-row mt-3">
                                        <div class="col-md-12 text-center">
                                            <button type="submit" name="saveDeliveryMode" class="btn btn-xs btn-primary mr-3">Add</button>

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

                                    <?php if(isset($_GET['d']) && $_GET['d'] == "edit-mode"): ?>
                                    <form action="" method="post">
                                        <div class="form-row">
                                            <div class="form-group col-md-12">
                                                <label>Mode</label>
                                                <div class="input-group">
                                                    <div class="input-group-prepend">
                                                        <span class="input-group-text">₦</span>
                                                    </div>
                                                    <input type="text" class="form-control" name="modeName" value="<?php if(isset($_POST['modeName'])){ echo $_POST['modeName']; }else{ echo $dbDeliveryMode; } ?>">
                                                    <div class="input-group-append">
                                                        <button type="submit" name="updateDeliveryMode" class="btn btn-primary mr-3">Update</button>
                                                    </div>
                                                </div>
                                                <?php if(isset($modeNameErr)): ?><span class="bg-danger text-white px-2 rounded"><?= $modeNameErr ?></span><?php endif ?>
                                            </div>
                                        </div>
                                    </form>
                                    <form action="" method="post" class="mt-3">
                                        <div class="form-row">
                                            <div class="form-group col-md-12">
                                                <label>Money %</label>
                                                <div class="input-group">
                                                    <input type="text" class="form-control" name="moneyPercent" value="<?php if(isset($_POST['moneyPercent'])){ echo $_POST['moneyPercent']; }else{ echo $dbMoneyPercent; } ?>">
                                                    <div class="input-group-append">
                                                        <span class="input-group-text">%</span>
                                                    </div>
                                                    <div class="input-group-append">
                                                        <button type="submit" name="updateMoney" class="btn btn-primary mr-3">Update</button>
                                                    </div>
                                                </div>
                                                <?php if(isset($moneyPercentErr)): ?><span class="bg-danger text-white px-2 rounded"><?= $moneyPercentErr ?></span><?php endif ?>
                                            </div>
                                        </div>
                                    </form>
                                    <form action="" method="post" class="mt-3">
                                        <div class="form-row">
                                            <div class="form-group col-md-12">
                                                <label>Point %</label>
                                                <div class="input-group">
                                                    <input type="text" class="form-control" name="pointPercent" value="<?php if(isset($_POST['pointPercent'])){ echo $_POST['pointPercent']; }else{ echo $dbPointPercent; } ?>">
                                                    <div class="input-group-append">
                                                        <span class="input-group-text">%</span>
                                                    </div>
                                                    <div class="input-group-append">
                                                        <button type="submit" name="updatePoint" class="btn btn-primary mr-3">Update</button>
                                                    </div>
                                                </div>
                                                <?php if(isset($pointPercentErr)): ?><span class="bg-danger text-white px-2 rounded"><?= $pointPercentErr ?></span><?php endif ?>
                                            </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">Name</th>
                                            <th scope="col">Point - Money (%)</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('delivery_prefs',"*");
                                    while($row = mysqli_fetch_array($q)){
                                        $id = $row['id']; $modeName = $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 ?>delivery-mode?id=<?= $id ?>&sz=min&d=edit-mode">Edit</a></li>
                                                            <li><a class="dropdown-item" href="<?= $adminRoot ?>delivery-mode?id=<?= $id ?>&d=dactv-mode">Deactivate</a></li>
                                                            <?php else: ?>
                                                            <li><a class="dropdown-item" href="<?= $adminRoot ?>delivery-mode?id=<?= $id ?>&d=actv-mode">Activate</a></li>
                                                            <li><a class="dropdown-item" href="<?= $adminRoot ?>delivery-mode?id=<?= $id ?>&d=dlt-mode">Delete</a></li>
                                                            <?php endif ?>
                                                        </ul>
                                                    </div>
                                                </div>
                                            </td>
                                            <td><?= $modeName ?></td>
                                            <td><?= $row['pointPercentage']." - ".$row['moneyPercentage'] ?></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"); ?>