Reports & Statistics¶
Navigate to Riportok — an expandable menu with 4 sub-views for statistical analysis and salary calculations.
Report Views¶
1. Trainer Salaries (Edzői fizetések)¶
Route: /Club/Report/TrainerSalaries
Calculates trainer compensation based on TrainerPayGradeFee multiplied by attendance records. Use this to generate payroll data for trainers based on the sessions they actually conducted.
Calculation basis
Salary = TrainerPayGradeFee (per-session rate by pay grade) x attendance count (verified check-ins for sessions led by the trainer).
2. Weekly Booking Statistics (Heti foglaltsági statisztika)¶
Route: /Club/Report/WeeklyBookingStatistics
Weekly booking utilization across sports fields, showing occupancy rates by day of week.
Uses the WeeklyBookingStatistics table-valued database function.
3. Hourly Booking Statistics (Órás foglaltsági statisztika)¶
Route: /Club/Report/HourlyBookingStatistics
Hourly booking patterns showing peak and off-peak usage across time slots.
Uses the HourlyBookingStatistics table-valued database function.
4. Customer Activity (Ügyfél aktivitás)¶
Route: /Club/Report/CustomerActivity
Customer-level booking and payment activity, useful for identifying active members, churning customers, and VIP candidates.
Database Functions¶
Both booking statistics reports rely on dedicated table-valued functions that return pre-aggregated data:
| Function | Created | Returns |
|---|---|---|
WeeklyBookingStatistics |
2020-07-07 | Aggregated booking data by week and field |
HourlyBookingStatistics |
2020-09-10 | Aggregated booking data by hour and field |
The GetTimeRanges function supports both reports by providing configurable time range boundaries for the aggregation.
Access Control¶
All report views are restricted to Club manager (Klubvezető) only.