1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / jeffautomobileinc.com / admin /
Filename : add-funding-account.php
back
<?php
session_start();
error_reporting(0);
include('../../config/jaconfig.php');
include('include/checklogin.php');
check_login();
include('include/header.php');
include('include/sidebar.php');
$title = "Add Funding Account";

if (isset($_POST['submit'])) {
    // Capture the form data
    $currency = $_POST['currency'];
    $bank_name = $_POST['bank_name'];
    $account_name = $_POST['account_name'] ?? '';
    $instruction = $_POST['instruction'] ?? '';
    $account_number = $_POST['account_number'];
    $iban = $_POST['iban'] ?? '';
    $swift_code = $_POST['swift_code'] ?? '';
    $description = $_POST['description'];
    $transfer_type = $_POST['transfer_type'];
    $amount = $_POST['amount'];
    $available_time = $_POST['available_time'];
    $status = $_POST['status'];

    // Validation patterns
    $currency_pattern = "/^[A-Z]{3}$/"; // Assuming 3-letter currency codes like USD, EUR, etc.
    $account_number_pattern = "/^[0-9]+$/";

    if (empty($currency)) {
        $msg = "All fields are required";
        $type = "warning";
    } else {
        // Sanitize and prepare data for insertion
        $currency = mysqli_real_escape_string($con, $currency);
        $bank_name = mysqli_real_escape_string($con, $bank_name);
        $account_name = mysqli_real_escape_string($con, $account_name);
        $instruction = mysqli_real_escape_string($con, $instruction);
        $account_number = mysqli_real_escape_string($con, $account_number);
        $swift_code = mysqli_real_escape_string($con, $swift_code);
        $iban = mysqli_real_escape_string($con, $iban);
        $description = mysqli_real_escape_string($con, $description);
        $transfer_type = mysqli_real_escape_string($con, $transfer_type);
        $amount = mysqli_real_escape_string($con, $amount);
        $available_time = mysqli_real_escape_string($con, $available_time);
        $status = mysqli_real_escape_string($con, $status);

        // Insert into funding_details table
        $sql = "INSERT INTO funding_details (currency, bank_name, account_number, description, transfer_type, amount, available_time, status)
                VALUES ('$currency', '$bank_name', '$account_number', '$description', '$transfer_type', '$amount', '$available_time', '$status')";

        if (mysqli_query($con, $sql)) {
            $msg = "Funding account added successfully!";
            $type = "success";
        } else {
            $msg = "Something went wrong, please try again.";
            $type = "warning";
        }
    }
}
?>

<!-- Content wrapper -->
<div class="content-wrapper">
    <!-- Content -->
    <div class="container-xxl flex-grow-1 container-p-y">
        <h4 class="fw-bold py-3 mb-4"><span class="text-muted fw-light">New/</span> Add Funding Account</h4>
        
        <div class="card mb-4">
            <h5 class="card-header">New Funding Account</h5>
            <hr class="my-0" />
            <div class="card-body">
                <?php if (isset($msg)) { ?>
                    <div class="alert alert-<?php echo $type ?>">
                        <h6 class="alert-heading fw-bold mb-1"><?php echo $type ?></h6>
                        <p class="mb-0"><?php echo $msg ?></p>
                    </div>
                <?php } ?>
                <form method="post" action="">
                    <div class="row">
                        <div class="mb-3 col-md-6">
                            <label class="form-label" for="currency">Currency</label>
                            <input type="text" class="form-control" name="currency"  />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label" for="bank_name">Bank Name</label>
                            <input type="text" class="form-control" name="bank_name"  />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label" for="account_name">Account Name *</label>
                            <input type="text" class="form-control" name="account_name" />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label" for="account_name">IBAN *</label>
                            <input type="text" class="form-control" name="iban" />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label" for="account_name">Swift Code/BIC *</label>
                            <input type="text" class="form-control" name="swift_code" />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label" for="account_number">Account Number</label>
                            <input type="text" class="form-control" name="account_number"  />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label" for="description">Description</label>
                            <input type="text" class="form-control" name="description" />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label" for="transfer_type">Transfer Type</label>
                            <input type="text" class="form-control" name="transfer_type"  />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label" for="amount">Amount</label>
                            <input type="number" class="form-control" name="amount"  />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label" for="available_time">Available Time(mins)</label>
                            <input type="text" class="form-control" name="available_time"  placeholder = "25"/>
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label" for="address_name">Instruction *</label>
                            <textarea class="form-control" name="instruction"></textarea>
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label" for="status">Status</label>
                            <select class="form-control" name="status">
                                <option value="1">Active</option>
                                <option value="0">Inactive</option>
                            </select>
                        </div>
                    </div>
                    <div class="mt-2">
                        <button type="submit" class="btn btn-primary me-2" name="submit">Submit</button>
                    </div>
                </form>
            </div>
        </div>
    </div>
</div>
<!-- / Content -->

<?php include('include/footer.php'); ?>