query("INSERT INTO fee_discounts (student_id, discount_type, discount_amount, discount_reason, approved_by, valid_from, valid_till, remarks, status) VALUES ('$student_id', '$discount_type', '$discount_amount', '$discount_reason', '$approved_by', '$valid_from', '$valid_till', '$remarks', '$status')"); echo ''; exit(); } // Edit Discount if(isset($_POST['action']) && $_POST['action'] == 'edit_discount') { $id = mysqli_real_escape_string($con, $_POST['id']); $discount_type = mysqli_real_escape_string($con, $_POST['discount_type']); $discount_amount = mysqli_real_escape_string($con, $_POST['discount_amount']); $discount_reason = mysqli_real_escape_string($con, $_POST['discount_reason']); $approved_by = mysqli_real_escape_string($con, $_POST['approved_by']); $valid_from = mysqli_real_escape_string($con, $_POST['valid_from']); $valid_till = mysqli_real_escape_string($con, $_POST['valid_till']); $remarks = mysqli_real_escape_string($con, $_POST['remarks']); $status = mysqli_real_escape_string($con, $_POST['status']); $con->query("UPDATE fee_discounts SET discount_type='$discount_type', discount_amount='$discount_amount', discount_reason='$discount_reason', approved_by='$approved_by', valid_from='$valid_from', valid_till='$valid_till', remarks='$remarks', status='$status' WHERE id='$id'"); echo ''; exit(); } // Delete Discount if(isset($_GET['action']) && $_GET['action'] == 'delete') { $id = mysqli_real_escape_string($con, $_GET['id']); $con->query("DELETE FROM fee_discounts WHERE id='$id'"); echo ''; exit(); } // Fetch discounts $discounts = $con->query("SELECT fd.*, s.name, s.enrollment_no, s.father, s.mobile, c.course_name, ce.institute_name FROM fee_discounts fd LEFT JOIN students s ON fd.student_id = s.id LEFT JOIN courses c ON s.course_id = c.id LEFT JOIN centers ce ON s.center_id = ce.id ORDER BY fd.id DESC"); // Fetch students for dropdown $students = $con->query("SELECT s.*, c.course_name FROM students s LEFT JOIN courses c ON s.course_id = c.id WHERE s.status = 1 ORDER BY s.name ASC"); // Summary $summary = $con->query("SELECT COUNT(*) as total_discounts, SUM(discount_amount) as total_amount, COUNT(DISTINCT student_id) as total_students, SUM(CASE WHEN discount_type='Percentage' THEN 1 ELSE 0 END) as percentage_discounts, SUM(CASE WHEN discount_type='Fixed' THEN 1 ELSE 0 END) as fixed_discounts, SUM(CASE WHEN status=1 THEN 1 ELSE 0 END) as active_discounts FROM fee_discounts")->fetch_assoc(); ?>
Total Discounts
₹
Total Amount
Students
Active
Percentage
Fixed Amount

Fee Discounts / Concessions

num_rows > 0): ?> fetch_assoc()): $expired = (!empty($d['valid_till']) && strtotime($d['valid_till']) < time()); $status_label = $d['status'] ? ($expired ? 'Expired' : 'Active') : 'Inactive'; $status_class = $d['status'] ? ($expired ? 'badge-expired' : 'badge-active') : 'badge-inactive'; ?>
#ID Student Name Enroll. No. Course Center Type Amount Reason Valid Till Status Actions
#
No discounts found