prepare("
SELECT payments.*, students.full_name
FROM payments
JOIN students ON payments.student_id = students.id
WHERE payment_date BETWEEN ? AND ?
ORDER BY payment_date DESC
");
$stmtPayments->execute([$start_date, $end_date]);
$payments = $stmtPayments->fetchAll();
// جلب المصروفات ضمن النطاق الزمني مع شرط البحث في نوع المصروف أو الوصف إذا تم الإدخال
if ($expense_search !== '') {
$searchTerm = "%$expense_search%";
$stmtExpenses = $conn->prepare("SELECT * FROM expenses WHERE expense_date BETWEEN ? AND ? AND (expense_type LIKE ? OR description LIKE ?) ORDER BY expense_date DESC");
$stmtExpenses->execute([$start_date, $end_date, $searchTerm, $searchTerm]);
} else {
$stmtExpenses = $conn->prepare("SELECT * FROM expenses WHERE expense_date BETWEEN ? AND ? ORDER BY expense_date DESC");
$stmtExpenses->execute([$start_date, $end_date]);
}
$expenses = $stmtExpenses->fetchAll();
// حساب المجموعات
$totalPayments = 0;
foreach ($payments as $payment) {
$totalPayments += $payment['amount_paid'];
}
$totalExpenses = 0;
foreach ($expenses as $expense) {
$totalExpenses += $expense['amount'];
}
$netBalance = $totalPayments - $totalExpenses;
?>