Viewing File: /home/rareljzw/public_html/admin/fundings.php

<?php




$pageName  = "Credit/Debit Users";
include("./layout/header.php");


if(isset($_POST['credit'])){
    $username = $_POST['username'];
    $amount = $_POST['amount'];
    $createdAt = $_POST['createdAt'];

    

    $sql = "SELECT * FROM users WHERE username =:username";
    $checkUser = $conn->prepare($sql);
    $checkUser->execute([
       'username'=>$username
    ]);
    $result = $checkUser->fetch(PDO::FETCH_ASSOC);

    $available_balance = $amount + $result['balance'];

    $sql = "UPDATE users SET balance=:available_balance WHERE username=:username";
    $addUp = $conn->prepare($sql);
    $addUp->execute([
       'available_balance'=>$available_balance,
        'username'=>$username
    ]);


    if(true) {
            $refrence_id = uniqid();
            $wallet_status = 1;
            $trans_type = "Funding";
            $deposited = "INSERT INTO wallet (amount,username,trans_type,refrence_id,wallet_status,createdAt)VALUES(:amount,:username,:trans_type,:refrence_id,:wallet_status,:createdAt)";
            $stmt = $conn->prepare($deposited);

            $stmt->execute([
                'amount' => $amount,
                'username' => $username,
                'trans_type' => $trans_type,
                'refrence_id' => $refrence_id,
               'wallet_status'=> $wallet_status,
               'createdAt' => $createdAt

            ]);

       
       
       
                $APP_NAME = WEB_TITLE;
                $APP_URL = WEB_URL;
                $user_email = $result['acct_email'];
                $username = $result['username'];
        
        
                $message = $sendMail->WalletCredit($username,$APP_NAME, $APP_URL);
        
                // User Email
                $subject = "Wallet Credit";
                $email_message->send_mail($user_email, $message, $subject);

        if (true) {
            toast_alert('success', 'Account Fund Successfully', 'Approved');
        } else {
            toast_alert('error', 'Sorry Something Went Wrong');
        }
    }
}
else if(isset($_POST['debit'])){
       $username = $_POST['username'];
    $amount = $_POST['amount'];
    $createdAt = $_POST['createdAt'];

    

    $sql = "SELECT * FROM users WHERE username =:username";
    $checkUser = $conn->prepare($sql);
    $checkUser->execute([
       'username'=>$username
    ]);
    $result = $checkUser->fetch(PDO::FETCH_ASSOC);
    
    
    if($amount > $result['balance']){
        toast_alert('error','Insufficient Balance');
    }else {




        $available_balance = ($result['balance'] - $amount);


    $sql = "UPDATE users SET balance=:available_balance WHERE username=:username";
    $addUp = $conn->prepare($sql);
    $addUp->execute([
       'available_balance'=>$available_balance,
        'username'=>$username
    ]);


    if(true) {
            $refrence_id = uniqid();
            $wallet_status = 1;
            $trans_type = "Withdrawal";
            $deposited = "INSERT INTO wallet (amount,username,trans_type,refrence_id,wallet_status,createdAt)VALUES(:amount,:username,:trans_type,:refrence_id,:wallet_status,:createdAt)";
            $stmt = $conn->prepare($deposited);

            $stmt->execute([
                'amount' => $amount,
                'username' => $username,
                'trans_type' => $trans_type,
                'refrence_id' => $refrence_id,
               'wallet_status'=> $wallet_status,
               'createdAt' => $createdAt

            ]);

            $APP_NAME = WEB_TITLE;
            $APP_URL = WEB_URL;
            $user_email = $result['acct_email'];
            $username = $result['username'];
    
    
            $message = $sendMail->WalletDebited($username,$APP_NAME, $APP_URL);
    
            // User Email
            $subject = "Wallet Debit";
            $email_message->send_mail($user_email, $message, $subject);

        if (true) {
            toast_alert('success', 'Account Debited Successfully', 'Approved');
        } else {
            toast_alert('error', 'Sorry Something Went Wrong');
        }
        
    }
    }

}
 

?>

<!-- Content Wrapper. Contains page content -->
<div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
        <h1>
            Credit/Debit User
        </h1>
        <ol class="breadcrumb">
            <li><a href="./dashboard"><i class="fa fa-dashboard"></i> Dashboard</a></li>
        </ol>
    </section>



    <!-- Main content -->
    <section class="content">

        <!-- SELECT2 EXAMPLE -->
        <div class="box box-default">
            <div class="box-header with-border">
                <div class="box-tools pull-right">
                    <button type="button" class="btn btn-box-tool" data-widget="collapse"><i
                            class="fa fa-minus"></i></button>
                    <button type="button" class="btn btn-box-tool" data-widget="remove"><i
                            class="fa fa-remove"></i></button>
                </div>
            </div>
            <!-- /.box-header -->
            <div class="box-body">
            <form method="POST">

                <div class="row">
                    
                    <div class="col-md-6">
                        <div class="form-group">
                            <label>Select user</label>
                            <select name="username" class="form-control select2" style="width: 100%;" required>
                                <option selected="selected">Select User</option>

                                <?php
                                                    $sql="select * from users order by username ASC";
                                                    $stmt = $conn->prepare($sql);
                                                    $stmt->execute();

                                                    while($row = $stmt->fetch(PDO::FETCH_ASSOC)){
                                                        $fullName = $row['username'];

                                                    ?>
                                <option value="<?=$row['username']?>"><?= ucwords($fullName)?></option>
                                <?php
                                                    }
                                                    ?>
                            </select>
                        </div>
                        <!-- /.form-group -->
                        

                        <div class="form-group">
                            <label>Date</label>
                            <input type="date" class="form-control" name="createdAt" required>
                        </div>
                        <!-- /.form-group -->
                    </div>
                    <!-- /.col -->
                    <div class="col-md-6">
                        <div class="form-group">
                            <label>Amount</label>
                            <input type="number" step="any" class="form-control" name="amount" placeholder="0.00001" required>
                        </div>

                        

                        <!--<div class="form-group">-->
                        <!--    <label>Time</label>-->
                        <!--    <input type="timestamp" class="form-control" placeholder="2022-11-06 16:38:50" name="time_created" required>-->
                        <!--</div>-->

                    </div>
                    
                    <!-- /.col -->
                </div>
               
                <!-- /.row -->
            </div>
            <!-- /.box-body -->
            <div class="box-footer">
                <button type="submit" name="credit" class="btn btn-primary">Credit</button>

                <button type="submit" name="debit" class="btn btn-danger">Debit</button>
            </div>
        </div>
        <!-- /.box -->

        </form>


    </section>
    <!-- /.content -->
</div>
<!-- /.content-wrapper -->



<?php
include("./layout/footer.php");

?>