Queries & History¶
Navigate to Lekérdezések — an expandable menu with 9 sub-views for historical data and reporting queries.
Admin Query Views¶
1. Purchase History (Vásárlás történet)¶
Route: /Club/Query/PurchaseHistory
Payment transaction history with date filtering, customer search, and payment method breakdown.
2. Credit History (Kredit történet)¶
Route: /Club/Query/CreditHistory
CreditTransaction records showing all credit movements — purchases, usage, expirations, and refunds.
3. Credit Modifications (Kredit módosítások)¶
Route: /Club/Query/CreditModifications
Manual credit adjustments made by administrators, separate from automated transaction flows.
4. Training Credit History (Tanfolyam kredit történet)¶
Route: /Club/Query/TrainingCreditHistory
TrainingPackageTransaction records for course-specific credit balances and usage.
5. Training Package Subscriptions (Tanfolyam jelentkezések)¶
Route: /Club/Query/TrainingPackageSubscriptions
Course enrollment records showing who signed up for which training packages.
6. Attendance History (Jelenlét történet)¶
Route: /Club/Query/AttendanceHistory
AttendanceHistory records tracking customer check-ins at the facility.
7. Resource Usage (Erőforrás kihasználtság)¶
Route: /Club/Query/ResourceUsage
Resource utilization metrics across sports fields and time periods.
8. Contact Lists (Kontakt listák)¶
Route: /Club/Query/ContactLists
Customer contact data export for marketing and communication purposes.
9. Email Notifications (Email értesítések)¶
Route: /Club/Query/EmailNotification
Email delivery log showing sent notifications, their recipients, and delivery status.
Common Features¶
All query views share these capabilities
- DataTables with server-side pagination
- Search across all visible columns
- Column filtering for targeted queries
- Excel export for offline analysis
Customer Query Views¶
Customers have access to a subset of query pages under their own portal:
| View | Route |
|---|---|
| Credit History (Kredit történet) | /Customer/Query/CreditHistory |
| Training Credit History (Tanfolyam kredit történet) | /Customer/Query/TrainingCreditHistory |
| Purchase History (Vásárlás történet) | /Customer/Query/PurchaseHistory |
| Pending Payments (Függő fizetések) | /Customer/Query/PendingPayment |
| Training Summary (Tanfolyam összesítő) | /Customer/Query/TrainingSummary |
Access Control¶
Admin query views are available to Receptionist (Recepciós) and Club manager (Klubvezető) user types.