1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / nc6d095 / www / member / view /
Filename : wallet.php
back
<?php
global $email, $memberRoot, $userId;
include('../../admin/inc/config.php');
include('../inc/auth.php');

const TITLE = 'Manage My Wallet';
const HEADER = 'My Wallet';
const BREADCRUMB = 'wallet';

$okMsgs = [];$showFAlert = $showHPAlert = false;

if(isset($_POST['fundWallet'])){
    $amount = trim(intval($_POST['amount']));
    if(empty($amount)) { $errs[] = $amountErr = "you must enter an amount"; }

    if(count($errs) == 0){
        $preventResubmission = true;
        $showFAlert = true;
        #payment gateway begins
        //Initiate Paystack
        $url = "https://api.paystack.co/transaction/initialize";
        //Gather the body params
        $transaction_data =[
            "email" => $email,
            "amount" => $amount * 100,
            "callback_url" => $memberRoot."confirm-payment",
            "metadata" => [
                "custom_fields" =>[
                    [
                        "display_name" => "Amount Paid",
                        "variable_name" => "owo",
                        "value" => $amount
                    ]
                ]
            ]
        ];
        //Generate a URL-encoded string
        $encode_transaction_data = http_build_query($transaction_data);
        //Open connect to cURL
        $ch = curl_init();
        //Turn off Mandatory SSL checking
        curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
        //Set the url
        curl_setopt($ch, CURLOPT_URL, $url);
        //Enable data to be sent in POST arrays
        curl_setopt($ch, CURLOPT_POST, true);
        //Collect the posted data from above
        curl_setopt($ch, CURLOPT_POSTFIELDS, $encode_transaction_data);
        //Set the headers from the endpoint
        curl_setopt($ch, CURLOPT_HTTPHEADER, array(
            "Authorization: Bearer sk_test_029a93f23051dd3421802032529905545ba71194",
            "cache-Control: no-cache"
        ));
        //Make curl return the data instead of echoing it
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
        //Execute cURL
        $result = curl_exec($ch);
        //Check for errors
        $errors = curl_error($ch);
        if($errors){
            $emsg = "Curl returned some errors: " . $errors;
        }
        // var_dump($result);
        $transaction = json_decode($result);
        //Automatically redirect customers to the payment page
        #header("Location: " . $transaction->data->authorization_url);
        jsRefresh($transaction->data->authorization_url,10000);
    }

}


if(isset($_POST['purchaseHP'])){
    $hpAmount = trim(floatval($_POST['hpAmount']));
    if(empty($hpAmount)) { $errs[] = $hpAmountErr = "you must enter an amount"; }
    else {
        $reqAmount = floatval(HP_CONV_COST * $hpAmount);
        if($reqAmount <= $moneyBalance) {
            $newBalance = floatval($moneyBalance) - $reqAmount;
            $newPointBalance = floatval($pointBalance) + $hpAmount;
            $q = dbUpdate('members',['moneyBalance'=>$newBalance, 'pointBalance'=>$newPointBalance, 'du'=>$now], "id=".$userId);
            $q2 = dbInsert("member_wallet_transactions", ['member'=>$userId, 'amount'=>$reqAmount, 'details'=>'points conversion', 'direction'=>'out', 'dc'=>$now]);
            $q3 = dbInsert("member_point_transactions", ['member'=>$userId, 'amount'=>$hpAmount, 'details'=>'HP purchase', 'direction'=>'in', 'dc'=>$now]);
            if($q && $q2 && $q3) {
                $reqAmountFormatted = "₦" . number_format($reqAmount, 2);
                $smsg = "Conversion was successful. $reqAmountFormatted has been deducted from your wallet to fund the conversion";
                jsRefresh($memberRoot."wallet",2000);
            }
        }else{
            $overflow = floatval($reqAmount) - floatval($moneyBalance);
            $overflowFormatted = "₦".number_format($overflow,2);
            $errs[] = $hpAmountErr = "insuficient wallet funds";
            $emsg = "You'll need additional $overflowFormatted to complete the purchase. Kindly fund your wallet or adjust the HP you are trying to purchase";
        }
    }
}
include("../../admin/inc/head.php");
?>

<body>

    <!--*******************
        Preloader start
    ********************-->
    <?php include("../../admin/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-4">
                        <form action="" method="post" enctype="multipart/form-data">
                            <div class="row">
                                <div class="col-md-12 mb-3">
                                    <div class="card">
                                        <div class="card-header">
                                            <h4 class="card-title d-inline">Fund Wallet</h4>
                                            <span class="float-right"><strong>Balance:</strong> ₦<?= number_format($moneyBalance,2) ?></span>
                                        </div>
                                        <div class="card-body">
                                            <?php if($showFAlert): ?>
                                                <div class="alert alert-info alert-dismissible alert-alt fade show">
                                                    <strong><i class="bi bi-exclamation-circle"></i></strong> Page about to reload, you can cancel by clicking the cancel button within 10 seconds <a href="<?= $memberRoot ?>wallet" class="btn btn-rounded btn-xs btn-secondary">Cancel</a>
                                                </div>
                                            <?php endif ?>
                                            <div id="">
                                                <div class="form-row">
                                                    <div class="form-group col-md-12">
                                                        <label>Amount</label>
                                                        <div class="input-group">
                                                            <div class="input-group-prepend">
                                                                <span class="input-group-text">₦</span>
                                                            </div>
                                                            <input type="number" class="form-control" name="amount" value="<?php if(isset($_POST['amount'])){ echo $_POST['amount']; } ?>">
                                                            <div class="input-group-append">
                                                                <span class="input-group-text">.00</span>
                                                                <button type="submit" name="fundWallet" class="btn btn-primary mr-3 submitButton">Fund</button>
                                                            </div>
                                                        </div>
                                                        <?php if(isset($amountErr)): ?><span class="bg-danger text-white px-2 rounded"><?= $amountErr ?></span><?php endif ?>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                                <div class="col-md-12 mb-3">
                                    <div class="card">
                                        <div class="card-header">
                                            <h4 class="card-title d-inline">Purchase HP</h4>
                                            <span class="float-right"><strong>₦<?= number_format(1000) ?> <i class="bi bi-arrow-left-right mx-2 text-primary font-weight-bold"></i></strong> <strong>15HP</strong></span>
                                        </div>
                                        <div class="card-body">
                                            <?php if($showHPAlert): ?>
                                                <div class="alert alert-info alert-dismissible alert-alt fade show">
                                                    <strong><i class="bi bi-exclamation-circle"></i></strong> Page about to reload, you can cancel by clicking the cancel button within 10 seconds <a href="<?= $memberRoot ?>wallet" class="btn btn-rounded btn-xs btn-secondary">Cancel</a>
                                                </div>
                                            <?php endif ?>
                                            <div id="">
                                                <div class="form-row">
                                                    <div class="form-group col-md-12">
                                                        <label>Amount <small class="text-info">Your wallet balance can get you up to <?= number_format(getPointValue($moneyBalance),2) ?>HP</small></label>
                                                        <div class="input-group">
                                                            <input type="number" class="form-control" name="hpAmount" value="<?php if(isset($_POST['hpAmount'])){ echo $_POST['hpAmount']; } ?>">
                                                            <div class="input-group-append">
                                                                <span class="input-group-text">HP</span>
                                                                <button type="submit" name="purchaseHP" class="btn btn-primary mr-3 submitButton align-items-center">Purchase</button>
                                                            </div>
                                                        </div>
                                                        <?php if(isset($hpAmountErr)): ?><span class="bg-danger text-white px-2 rounded"><?= $hpAmountErr ?></span><?php endif ?>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </form>
                    </div>
                    <div class="col-md-8">
                        <div class="row gy-3">
                            <div class="col-md-12">
                                <div class="card">
                                    <div class="card-header">
                                        <h4 class="card-title">Wallet Transaction History</h4>
                                    </div>
                                    <div class="card-body tbl-card">
                                        <table class="table dtTable fancy-scb">
                                            <thead>
                                            <tr>
                                                <th scope="col">S/N</th>
                                                <th scope="col">Amount</th>
                                                <th scope="col">Details</th>
                                                <th scope="col" class="text-center">Direction</th>
                                                <th scope="col">Date Logged</th>
                                            </tr>
                                            </thead>
                                            <tbody>
                                            <?php
                                            $no = 1;
                                            $q = dbSelect('member_wallet_transactions',"*", "member='$userId'","dc DESC");
                                            while($row = mysqli_fetch_array($q)){
                                                $direction = $row['direction'];
                                                ?>
                                                <tr class="">
                                                    <th><?= $no++ ?></th>
                                                    <td><?= "₦".number_format($row['amount'],2) ?></td>
                                                    <td><?= ucfirst($row['details']) ?></td>
                                                    <td class="text-center"><i class="text-primary bi bi-box-arrow-<?= $direction == 'in' ? "in-right" : "right" ?> fa-2x"></i></td>
                                                    <td><?= formatDate($row['dc']) ?></td>
                                                </tr>
                                            <?php } ?>
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>
                            <div class="col-md-12">
                                <div class="card">
                                    <div class="card-header">
                                        <h4 class="card-title">HP Transaction History</h4>
                                    </div>
                                    <div class="card-body tbl-card">
                                        <table class="table dtTable fancy-scb">
                                            <thead>
                                            <tr>
                                                <th scope="col">S/N</th>
                                                <th scope="col">Amount</th>
                                                <th scope="col">Details</th>
                                                <th scope="col" class="text-center">Direction</th>
                                                <th scope="col">Date Logged</th>
                                            </tr>
                                            </thead>
                                            <tbody>
                                            <?php
                                            $no = 1;
                                            $q = dbSelect('member_point_transactions',"*", "member='$userId'","dc DESC");
                                            while($row = mysqli_fetch_array($q)){
                                                $direction = $row['direction'];
                                                ?>
                                                <tr class="">
                                                    <th><?= $no++ ?></th>
                                                    <td><?= number_format($row['amount'],2)."HP" ?></td>
                                                    <td><?= ucfirst($row['details']) ?></td>
                                                    <td class="text-center"><i class="text-primary bi bi-box-arrow-<?= $direction == 'in' ? "in-right" : "right" ?> fa-2x"></i></td>
                                                    <td><?= formatDate($row['dc']) ?></td>
                                                </tr>
                                            <?php } ?>
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>
                        </div>


                    </div>
                </div>
            </div>
        </div>
        <!--**********************************
            Content body end
        ***********************************-->

        <!--**********************************
            Footer start
        ***********************************-->
        <?php include("../../admin/inc/footer.php"); ?>
        <!--**********************************
            Footer end
        ***********************************-->


    </div>
    <!--**********************************
        Main wrapper end
    ***********************************-->

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