prepare($query);
$stmt->execute();
$expenses = $stmt->fetchAll(PDO::FETCH_ASSOC);
$grand_total = array_sum(array_column($expenses, 'amount'));
// جلب أنواع المصروفات للقائمة المنسدلة
$types_stmt = $conn->query("SELECT DISTINCT expense_type FROM expenses WHERE expense_type IS NOT NULL");
$all_types = $types_stmt->fetchAll(PDO::FETCH_COLUMN);
?>
