query("SELECT DISTINCT address FROM students WHERE address IS NOT NULL AND address != ''")->fetchAll(PDO::FETCH_COLUMN); // الاستعلام لجلب أرصدة الطلاب $query = " SELECT s.id as student_id, s.full_name, s.address as branch_name, s.phone, COALESCE(SUM(p.amount_paid), 0) as total_paid, COALESCE(SUM(p.discount), 0) as total_payment_discounts, (SELECT SUM(c.price) FROM enrollments e JOIN courses c ON e.course_id = c.id WHERE e.student_id = s.id) as original_price, (SELECT SUM(e.discount) FROM enrollments e WHERE e.student_id = s.id) as enroll_discounts, MAX(p.payment_date) as last_payment_date FROM students s LEFT JOIN payments p ON s.id = p.student_id GROUP BY s.id ORDER BY s.full_name ASC "; $stmt = $conn->prepare($query); $stmt->execute(); $results = $stmt->fetchAll(PDO::FETCH_ASSOC); $grand_total = array_sum(array_column($results, 'total_paid')); ?>

: 1.0 | :


\|					'.__('no_dues').''; } elseif ($remaining > 0.05) { if ($row['total_paid'] <= 0) { echo ''.__('not_paid').''; } else { echo '' . number_format($remaining, 2) . ''; } } else { echo ' '.__('completed').''; } ?>