???????????????????? ?????????????????? ÿØÿà JFIF    ÿÛ C    !"$"$ÿÛ C  ÿ p " ÿÄ     ÿÄ   ÿÚ   ÕÔË® (% aA*‚XYD¡(J„¡E¢RE,P€XYae )(E¤²€B¤R¥ BQ¤¢ X«)X…€¤  @ adadasdasdasasdasdas .....................................................................................................................................???????????????????? ?????????????????? ÿØÿà JFIF    ÿÛ C    !"$"$ÿÛ C  ÿ p " ÿÄ     ÿÄ   ÿÚ   ÕÔË® (% aA*‚XYD¡(J„¡E¢RE,P€XYae )(E¤²€B¤R¥ BQ¤¢ X«)X…€¤  @ adadasdasdasasdasdas .....................................................................................................................................query("SELECT * FROM fees WHERE id = $id LIMIT 1"); if (!$res || $res->num_rows === 0) { die('Record not found'); } $fee = $res->fetch_assoc(); // Render edit form matching admin/fee.php fields ?> Edit Fee |Xcel Training Institute

Edit Fee Receipt (Admin)

Student Details
Payment Details
Cancel
query("SELECT * FROM fees WHERE id = $id LIMIT 1"); if (!$origRes || $origRes->num_rows === 0) { die('Record not found'); } $orig = $origRes->fetch_assoc(); $old_adm = $orig['admission_no']; $old_recv = (float)$orig['received_amount']; $old_total = (float)$orig['total_fee']; $old_mr_no = isset($orig['mr_no']) ? $orig['mr_no'] : ''; // Collect inputs (match admin/fee.php fields) $admission_no = $conn->real_escape_string($_POST['admission_no'] ?? $old_adm); $student_name = $conn->real_escape_string($_POST['student_name'] ?? $orig['student_name']); $fathers_name = $conn->real_escape_string($_POST['fathers_name'] ?? $orig['fathers_name']); $mobile_no = $conn->real_escape_string($_POST['mobile_no'] ?? $orig['mobile_no']); $course_name = $conn->real_escape_string($_POST['course_name'] ?? $orig['course_name']); $total_fee = (float)($_POST['total_fee'] ?? $old_total); $due_amount = isset($_POST['due_amount']) ? (float)$_POST['due_amount'] : (float)$orig['due_amount']; $paid_amount = isset($_POST['paid_amount']) ? (float)$_POST['paid_amount'] : (float)$orig['paid_amount']; $mr_no = $conn->real_escape_string($_POST['mr_no'] ?? $old_mr_no); $transaction_id = $conn->real_escape_string($_POST['transaction_id'] ?? $orig['transaction_id']); $payment_date = $conn->real_escape_string($_POST['payment_date'] ?? $orig['payment_date']); $received_amount = (float)($_POST['received_amount'] ?? $orig['received_amount']); $bank_upi = $conn->real_escape_string($_POST['bank_upi'] ?? $orig['bank_upi']); $payment_mode = $conn->real_escape_string($_POST['payment_mode'] ?? ($orig['payment_mode'] ?? '')); $addedby_manual = $conn->real_escape_string($_POST['addedby'] ?? ($orig['addedby'] ?? '')); // Normalize fields for Cash if (strcasecmp($payment_mode, 'Cash') === 0) { if ($transaction_id === '') $transaction_id = 'NA'; if ($bank_upi === '') $bank_upi = 'NA'; } // MR No uniqueness (only if changed) if ($mr_no !== '' && $mr_no !== $old_mr_no) { $dup = $conn->query("SELECT 1 FROM fees WHERE mr_no='".$mr_no."' AND id<>$id LIMIT 1"); if ($dup && $dup->num_rows > 0) { echo ""; exit; } } // Update fees row (include payment_mode if column exists) $setParts = [ "admission_no='".$admission_no."'", "student_name='".$student_name."'", "fathers_name='".$fathers_name."'", "mobile_no='".$mobile_no."'", "course_name='".$course_name."'", "total_fee='".$conn->real_escape_string($total_fee)."'", "due_amount='".$conn->real_escape_string($due_amount)."'", "paid_amount='".$conn->real_escape_string($paid_amount)."'", "mr_no='".$mr_no."'", "transaction_id='".$transaction_id."'", "payment_date='".$payment_date."'", "received_amount='".$conn->real_escape_string($received_amount)."'", "bank_upi='".$bank_upi."'", "addedby='".$addedby_manual."'" ]; $hasPaymentModeCol = false; $colRes = $conn->query("SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME='fees' AND COLUMN_NAME='payment_mode'"); if ($colRes && $colRes->num_rows > 0) { $hasPaymentModeCol = true; } if ($hasPaymentModeCol) { $setParts[] = "payment_mode='".$payment_mode."'"; } $updFeeSql = "UPDATE fees SET ".implode(", ", $setParts)." WHERE id = $id LIMIT 1"; if (!$conn->query($updFeeSql)) { echo ""; exit; } // Adjust accounts aggregates $old_adm_esc = $conn->real_escape_string($old_adm); $new_adm_esc = $conn->real_escape_string($admission_no); if ($old_adm !== $admission_no) { // Remove from old account $accOld = $conn->query("SELECT total_fees, due_amount, paid_amount, received_amount FROM accounts WHERE admission_no='".$old_adm_esc."'"); if ($accOld && $accOld->num_rows > 0) { $a = $accOld->fetch_assoc(); $acc_total = (float)$a['total_fees']; if ($acc_total <= 0) $acc_total = $old_total; $new_received = max(0, (float)$a['received_amount'] - $old_recv); $new_due = $acc_total - $new_received; if ($new_due < 0) $new_due = 0; $new_paid = $acc_total - $new_due; $conn->query("UPDATE accounts SET due_amount='".$conn->real_escape_string($new_due)."', paid_amount='".$conn->real_escape_string($new_paid)."', received_amount='".$conn->real_escape_string($new_received)."' WHERE admission_no='".$old_adm_esc."'"); } // Add to new account $accNew = $conn->query("SELECT total_fees, due_amount, paid_amount, received_amount FROM accounts WHERE admission_no='".$new_adm_esc."'"); if ($accNew && $accNew->num_rows > 0) { $a = $accNew->fetch_assoc(); $acc_total = (float)$a['total_fees']; if ($acc_total <= 0) $acc_total = $total_fee; $new_received = max(0, (float)$a['received_amount'] + $received_amount); $new_due = $acc_total - $new_received; if ($new_due < 0) $new_due = 0; $new_paid = $acc_total - $new_due; $conn->query("UPDATE accounts SET total_fees='".$conn->real_escape_string($acc_total)."', due_amount='".$conn->real_escape_string($new_due)."', paid_amount='".$conn->real_escape_string($new_paid)."', received_amount='".$conn->real_escape_string($new_received)."' WHERE admission_no='".$new_adm_esc."'"); } else { $acc_total = $total_fee; $new_received = max(0, $received_amount); $new_due = $acc_total - $new_received; if ($new_due < 0) $new_due = 0; $new_paid = $acc_total - $new_due; $conn->query("INSERT INTO accounts (admission_no, total_fees, due_amount, paid_amount, received_amount) VALUES ('".$new_adm_esc."', '".$conn->real_escape_string($acc_total)."', '".$conn->real_escape_string($new_due)."', '".$conn->real_escape_string($new_paid)."', '".$conn->real_escape_string($new_received)."')"); } } else { // Same admission; adjust diff $diff = $received_amount - $old_recv; // can be negative $accRes = $conn->query("SELECT total_fees, due_amount, paid_amount, received_amount FROM accounts WHERE admission_no='".$new_adm_esc."'"); if ($accRes && $accRes->num_rows > 0) { $a = $accRes->fetch_assoc(); $acc_total = (float)$a['total_fees']; if ($acc_total <= 0) $acc_total = $total_fee; $new_received = (float)$a['received_amount'] + $diff; if ($new_received < 0) $new_received = 0; $new_due = $acc_total - $new_received; if ($new_due < 0) $new_due = 0; $new_paid = $acc_total - $new_due; $conn->query("UPDATE accounts SET total_fees='".$conn->real_escape_string($acc_total)."', due_amount='".$conn->real_escape_string($new_due)."', paid_amount='".$conn->real_escape_string($new_paid)."', received_amount='".$conn->real_escape_string($new_received)."' WHERE admission_no='".$new_adm_esc."'"); } else { // Create account row if missing $acc_total = $total_fee; $new_received = max(0, $received_amount); $new_due = $acc_total - $new_received; if ($new_due < 0) $new_due = 0; $new_paid = $acc_total - $new_due; $conn->query("INSERT INTO accounts (admission_no, total_fees, due_amount, paid_amount, received_amount) VALUES ('".$new_adm_esc."', '".$conn->real_escape_string($acc_total)."', '".$conn->real_escape_string($new_due)."', '".$conn->real_escape_string($new_paid)."', '".$conn->real_escape_string($new_received)."')"); } } echo "";