1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / nc6d095 / promote.agumarket.com / view /
Filename : checkout.php
back
<?php
include("../admin/inc/config.php");
include("../inc/auth.php");
$pgURL = $mainRoot.'checkout';

if(isset($_POST['checkout']) || (isset($_SESSION['checkout']) && count($_SESSION['checkout']) > 0)){
    $promptMsg = "You are about to checkout your promotion list. Are you sure?";
    if(!isset($_SESSION['checkout'])) {
        $seller = $_POST['seller'];
        $grandTotal = $_POST['grandTotal'];
        $_SESSION['checkout'] = [];
        $_SESSION['checkout']['seller'] = $seller;
        $_SESSION['checkout']['grandTotal'] = $grandTotal;
    }
    else{
        $seller = $_SESSION['checkout']['seller'];
        $grandTotal = $_SESSION['checkout']['grandTotal'];
    }
    $prompt = true;
    if(isset($_POST['doAction'])) {
        $prompt = false;
        if($moneyBalance >= $grandTotal) {
            $promotionList = [];
            $q = dbSelect('cart',"*","seller=$seller");
            while($cartRow = mysqli_fetch_assoc($q)) {
                $rowList = [];
                $product = $cartRow['product'];
                $duration = $cartRow['duration'];
                $rowList['product'] = $product;
                $rowList['duration'] = $duration;
                $promotionList[] = $rowList;
            }
            $listDetails = json_encode($promotionList);
            $newMoney = floatval($moneyBalance - $grandTotal);
            if(dbInsert('promotions',['seller'=>$seller,'details'=>$listDetails, 'dc'=>$now]) == 'success'){
            if(dbInsert('transactions',['seller'=>$seller,'amount'=>$grandTotal,'direction'=>'out','details'=>'promotion','dc'=>$now]) == 'success') {
                if (dbDelete('cart', null, "seller=$seller") == 'success') {
                    if ($q = dbUpdate("seller_wallets", ['balance' => $newMoney, 'du' => $now], "seller=" . $sellerId) == 'success') {
                        $smsg = "your promotion request has been submitted successfully";
                        unset($_SESSION['checkout']);
                        jsRefresh($mainRoot . 'promote', 3000);
                    }
                }
            }
            }
            else{
                $emsg = "something went wrong";
            }
        } else {
            $change = number_format($grandTotal - $moneyBalance,2);
            $emsg = "insufficient balance in your wallet. You need extra $change to compete the process";
        }
    }
}

const TITLE = "Promotion Checkout";
const HEADER = "Promotion Checkout";
const BREADCRUMB = "checkout";
$pgView = true;

include("../inc/head.php");
?>
<div class="content-wrapper">
    <?php include("../inc/header.php"); ?>
    <!-- /header -->

    <?php include("../inc/page-header.php"); ?>
    <!-- /page-header -->
    <section class="wrapper bg-light">
        <div class="container py-7 py-md-9">
            <div class="row">
        <div class="col-md-12">
            <?php include "../inc/alerts.php"; ?>
            <p class="text-info">Kindly review the list below and hit the checkout button when you're ready to submit the list<br>
            <strong>NB:</strong> Each product will be promoted across our <strong>Social Media Platforms</strong>, they will also be featured on the <strong>Website</strong> for the number of weeks you specified below</p>
            <div class="table-responsive mt-5 pt-5 border-top">
                <table class="table table-striped table-borderless">
                    <thead>
                    <tr>
                        <th>Product</th>
                        <th>Duration</th>
                        <th>Promotion Price</th>
                    </tr>
                    </thead>
                    <tbody>
                    <?php
                    $grandTotal = floatval(0);
                    $cartItems = false;
                    $q = dbSelect("cart","*","seller=$sellerId");
                    if(mysqli_num_rows($q) > 0){ $cartItems = true;
                        while($cartRow = mysqli_fetch_assoc($q)){
                            $cartId = $cartRow['id'];
                            $pName = getDBVal2("products",$cartRow['product']);
                            $unitPrice = getDBVal2("products",$cartRow['product'],"unit_price");
                            $promoteCost = floatval(getPercentageValue(3,$unitPrice,2) * $cartRow['duration']);
                            $grandTotal += $promoteCost;
                            ?>
                            <tr>
                                <td>
                                    <?php if(isset($_GET['eitem']) && $_GET['eitem'] == $cartRow['id']): ?>
                                        <select class="form-select w-75" id="product" name="product">
                                            <option value="">--select--</option>
                                            <?php
                                            $q2 = dbSelect2('products',"*");
                                            while($row = mysqli_fetch_array($q2)){
                                                if(cntRows("cart","product","seller=$sellerId AND id<>$cartId AND product=".$row['id']) > 0){
                                                    continue;
                                                }
                                                ?>
                                                <option <?php if($cartRow['product'] == $row['id']){ echo 'selected'; } ?> value="<?= $row['id'] ?>"><?= $row['name']." (".$row['current_stock'].")" ?></option>
                                            <?php } ?>
                                        </select>
                                        <?php if(isset($product2Error)): ?><span class="d-inline-block bg-danger text-white px-2 rounded mt-1"><?= $product2Error ?></span><?php endif ?>
                                    <?php else: ?>
                                        <?= $pName ?>
                                    <?php endif ?>
                                </td>
                                <td><?= $cartRow['duration'] ?></td>
                                <td><?= "₦".number_format($promoteCost,2) ?></td>
                            </tr>
                        <?php } ?>
                        <tr>
                            <td colspan="2" class="text-primary">
                                <strong>List Total</strong>
                            </td>
                            <td class="text-primary">
                                <strong><?= "₦".number_format($grandTotal,2) ?></strong>
                            </td>
                        </tr>
                        <tr>
                            <td colspan="2" class="text-danger">
                                <strong>Tax</strong>
                            </td>
                            <td class="text-danger">
                                <strong>0%</strong>
                            </td>
                        </tr>
                        <tr>
                            <td colspan="2" class="text-success">
                                <strong>Grand Total</strong>
                            </td>
                            <td class="text-success">
                                <strong><?= "₦".number_format($grandTotal,2) ?></strong>
                            </td>
                        </tr>
                    <?php } ?>
                    </tbody>
                </table>
                <?php if($cartItems): ?>
                    <div class="mt-3">
                        <form action="" method="post">
                            <input type="number" hidden="hidden" name="seller" value="<?= $sellerId ?>">
                            <input type="number" hidden="hidden" name="grandTotal" value="<?= $grandTotal ?>">
                            <?php if($moneyBalance >= $grandTotal): ?><button type="submit" name="checkout" class="btn btn-success me-1 mb-1">Checkout</button><?php endif ?>
                            <a href="<?= $mainRoot ?>promote" class="btn btn-success me-1 mb-1">Go Back</a>
                        </form>
                    </div>
                <?php else: ?>
                    <div class="mt-3">
                        <a href="<?= $mainRoot ?>promote" class="btn btn-success me-1 mb-1">Go Back</a>
                    </div>
                <?php endif ?>
            </div>
        </div>
    </div>
        </div>
    </section>
</div>
<?php include("../inc/footer.php"); ?>

<?php include("../inc/foot.php"); ?>