Tiny File Manager

Back Back Up Advanced Editor

<?php
include('includes/config.php');

if (!isset($_SESSION['user_id'])) {
    header("Location: index.php");
    exit();
}

$response = array('success' => false, 'message' => '');

$membershipTypesQuery = "SELECT id, type, amount FROM membership_types";
$membershipTypesResult = $conn->query($membershipTypesQuery);

if (isset($_GET['id'])) {
    $memberId = $_GET['id'];

$fetchMemberQuery = "SELECT * FROM members WHERE id = $memberId";
    $fetchMemberResult = $conn->query($fetchMemberQuery);

if ($fetchMemberResult->num_rows > 0) {
        $memberDetails = $fetchMemberResult->fetch_assoc();
    } else {
        header("Location: members_list.php");
        exit();
    }
}

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $membershipTypeId = $_POST['membershipType'];
    $renewDuration = $_POST['extend'];

$expiryDate = date('Y-m-d', strtotime("+$renewDuration months"));

$updateMemberQuery = "UPDATE members SET membership_type = $membershipTypeId, expiry_date = '$expiryDate' WHERE id = $memberId";
    $updateMemberResult = $conn->query($updateMemberQuery);

$totalAmount = $_POST['totalAmount'];
    $renewDate = date('Y-m-d');
    $insertRenewQuery = "INSERT INTO renew (member_id, total_amount, renew_date) VALUES ($memberId, $totalAmount, '$renewDate')";
    $insertRenewResult = $conn->query($insertRenewQuery);

if ($updateMemberResult && $insertRenewResult) {
        $response['success'] = true;
        $response['message'] = 'Membership renewed successfully.';
    } else {
        $response['message'] = 'Error updating membership or renewing: ' . $conn->error;
    }
}
?>

<?php include('includes/header.php');?>

<?php include('includes/sidebar.php'); ?>

<div class="content-wrapper">
        <?php include('includes/pagetitle.php'); ?>

<section class="content">
            <div class="container-fluid">
                
                <div class="row">
                    
                    <div class="col-md-12">

<?php if ($response['success']): ?>
                            <div class="alert alert-success alert-dismissible">
                                <button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
                                <h5><i class="icon fas fa-check"></i> Success</h5>
                                <?php echo $response['message']; ?>
                            </div>
                        <?php elseif (!empty($response['message'])): ?>
                            <div class="alert alert-danger alert-dismissible">
                                <button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
                                <h5><i class="icon fas fa-ban"></i> Error</h5>
                                <?php echo $response['message']; ?>
                            </div>
                        <?php endif; ?>

<div class="card card-primary">
                            <div class="card-header">
                                <h3 class="card-title"><i class="fas fa-keyboard"></i> Renew Membership Form</h3>
                            </div>
                            
                            
                            
                            <form method="post" action="">
                            <input type="hidden" name="member_id" value="<?php echo $id; ?>">
                                <div class="card-body">
                                    <div class="row">
                                    <div class="col-sm-6">
                                    <label for="fullname">Full Name</label>
                                    <input type="text" class="form-control" id="fullname" name="fullname"
                                        placeholder="Enter full name" required value="<?php echo $memberDetails['fullname']; ?>" disabled>
                                </div>
                                        <div class="col-sm-6">
                                            <label for="dob">Membership Number</label>
                                            <input type="text" class="form-control" id="mm" name="mm" value="<?php echo $memberDetails['membership_number']; ?>" disabled>
                                        </div>
                                        
                                    </div>

<div class="row mt-3">
                                    <div class="col-sm-6">
                                    <label for="membershipType">Membership Type</label>
                                    <select class="form-control" id="membershipType" name="membershipType" required>
                                        <?php
                                        if ($membershipTypesResult) {
                                            while ($row = $membershipTypesResult->fetch_assoc()) {
                                                echo "<option value='{$row['id']}'>{$row['type']} - {$row['amount']}</option>";
                                            }
                                        } else {
                                            echo "Error: " . $conn->error;
                                        }
                                        ?>
                                    </select>
                                </div>
                                        <div class="col-sm-6">
                                        <label for="extendate">Renew Upto</label>
                                            <select class="form-control" id="extend" name="extend" required>
                                                <option value="1">One Month</option>
                                                <option value="3">Three Months</option>
                                                <option value="6">Six Months</option>
                                                <option value="12">One Year</option>
                                            </select>
                                        </div>
                                       
                                    </div>

<div class="row mt-3">
                                    <div class="col-sm-6">
                                        <label for="totalAmount">Total Amount</label>
                                        <div class="input-group">
                                            <div class="input-group-prepend">
                                                <span class="input-group-text" id="currencySymbol"><?php echo getCurrencySymbol(); ?></span>
                                            </div>
                                            <input type="text" class="form-control" id="totalAmount" name="totalAmount" placeholder="Total Amount" readonly>
                                        </div>
                                    </div>
                                </div>

<?php
                                function getCurrencySymbol()
                                {
                                    global $conn;

$currencyQuery = "SELECT currency FROM settings";
                                    $currencyResult = $conn->query($currencyQuery);

if ($currencyResult->num_rows > 0) {
                                        $currencyRow = $currencyResult->fetch_assoc();
                                        return $currencyRow['currency'];
                                    } else {
                                        return '$';
                                    }
                                }
                                ?>
                                </div>

<div class="card-footer">
                                    <button type="submit" class="btn btn-primary">Submit</button>
                                </div>
                            </form>
                        </div>

</div>

</div>

</div>
        </section>
        
    </div>

<aside class="control-sidebar control-sidebar-dark">
        
    </aside>

<footer class="main-footer">
        <strong> &copy; <?php echo date('Y');?> codeastro.com</a> -</strong>
        All rights reserved.
        <div class="float-right d-none d-sm-inline-block">
        <b>Developed By</b> <a href="https://codeastro.com/">CodeAstro</a>
        </div>
    </footer>
</div>

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

var renewDuration = parseFloat($('#extend').val());

var totalAmount = membershipTypeAmount * renewDuration;

$('#totalAmount').val(totalAmount.toFixed(2));
        }

$('#membershipType, #extend').change(updateTotalAmount);

updateTotalAmount();
    });
</script>

</body>
</html>