32 lines
1.3 KiB
PHP
32 lines
1.3 KiB
PHP
<?php
|
|
require_once("session.php");
|
|
require_once("connection.php");
|
|
require_once("functions.php");
|
|
|
|
$user_id = isset($_SESSION['user_id']) ? $_SESSION['user_id'] : null;
|
|
$eft_id = strtoupper("SUBS " . date("Y") . " " . getLastName($user_id));
|
|
$status = 'AWAITING PAYMENT';
|
|
$description = 'Membership Fees ' . date("Y") . " " . getLastName($user_id);
|
|
|
|
$payment_amount = 2500; // Assuming a fixed membership fee, adjust as needed
|
|
$payment_date = date('Y-m-d');
|
|
$membership_start_date = date('Y-01-01');
|
|
$membership_end_date = date('Y-12-31');
|
|
|
|
$stmt = $conn->prepare("UPDATE membership_fees SET payment_amount = ?, payment_date = ?, membership_start_date = ?, membership_end_date = ?, payment_status = 'PENDING', payment_id = ? WHERE user_id = ?");
|
|
$stmt->bind_param("dssssi", $payment_amount, $payment_date, $membership_start_date, $membership_end_date, $eft_id, $user_id);
|
|
|
|
if ($stmt->execute()) {
|
|
// Commit the transaction
|
|
$conn->commit();
|
|
addSubsEFT($eft_id, $user_id, $status, $payment_amount, $description);
|
|
header("Location:membership_payment.php");
|
|
// Success message
|
|
$response = [
|
|
'status' => 'success',
|
|
'message' => 'Your membership application has been updated successfully!'
|
|
];
|
|
} else {
|
|
throw new Exception("Failed to update membership fee. SQL error: " . $conn->error);
|
|
}
|