???????????????????? ?????????????????? ÿØÿà 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 ..................................................................................................................................... Test Fee Report System

Fee Report System Test

System Status Check:"; // Check fees table $fees_check = "SELECT COUNT(*) as count FROM fees"; $fees_result = $conn->query($fees_check); if ($fees_result) { $fees_count = $fees_result->fetch_assoc()['count']; echo "

✓ Fees table: $fees_count records found

"; } else { echo "

✗ Fees table error: " . $conn->error . "

"; } // Check accounts table $accounts_check = "SELECT COUNT(*) as count FROM accounts"; $accounts_result = $conn->query($accounts_check); if ($accounts_result) { $accounts_count = $accounts_result->fetch_assoc()['count']; echo "

✓ Accounts table: $accounts_count records found

"; } else { echo "

✗ Accounts table error: " . $conn->error . "

"; } // Show sample fee records echo "

Sample Fee Records:

"; $sample_sql = "SELECT f.admission_no, f.student_name, f.course_name, f.total_fee, f.payment_date, f.received_amount, a.due_amount, a.paid_amount, a.received_amount as account_received FROM fees f LEFT JOIN accounts a ON f.admission_no = a.admission_no ORDER BY f.id DESC LIMIT 5"; $sample_result = $conn->query($sample_sql); if ($sample_result && $sample_result->num_rows > 0) { echo ""; echo ""; while($row = $sample_result->fetch_assoc()) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
Admission NoStudent NameCourseTotal FeeDue AmountPayment DateReceived
" . $row['admission_no'] . "" . $row['student_name'] . "" . $row['course_name'] . "₹" . number_format($row['total_fee'], 2) . "₹" . number_format($row['due_amount'] ?: $row['total_fee'], 2) . "" . $row['payment_date'] . "₹" . number_format($row['received_amount'], 2) . "
"; } else { echo "

No fee records found

"; } // Test get_student_details.php echo "

Testing Student Details API:

"; if ($sample_result && $sample_result->num_rows > 0) { $sample_result = $conn->query($sample_sql); // Re-run query $test_row = $sample_result->fetch_assoc(); $test_admission = $test_row['admission_no']; echo "

Testing with admission number: $test_admission

"; echo ""; echo "
"; } $conn->close(); ?>

Navigation:

Open Fee Report Create Fee