Pricing Time Slots¶
Pricing time slots define when different price tiers apply. The system maps each day-of-week and time combination to a pricing period, which is then used to look up rental fees.
Pricing Periods (Arazasi idosav)¶
Navigate: Klub konfiguracio → Arazasi idosav — /Club/RentPricingPeriod
| Column | Description |
|---|---|
| Name | Display name |
| Text_Code | Internal identifier |
Demo Data¶
| ID | Name |
|---|---|
| 1 | Anytime |
| 2 | Low |
| 3 | High |
Pricing Period Intervals (Arazasi idosav szakasz)¶
Navigate: Klub konfiguracio → Arazasi idosav szakasz — /Club/RentPricingPeriodInterval
| Column | Description |
|---|---|
| RentPricingPeriod_ID | FK to RentPricingPeriod |
| DayOfWeek_Code | Day of week identifier |
| BeginningTime | Start time of the interval |
| EndTime | End time of the interval |
A unique constraint exists on (RentPricingPeriod_ID, DayOfWeek_Code, BeginningTime).
Demo intervals
19 intervals map specific day + time combinations to the Low or High pricing periods.
How Price Lookup Works¶
- The system takes the reservation's day of week and start time.
- It searches
RentPricingPeriodIntervalfor a matching row. - The matched
RentPricingPeriod_IDis used to look up the fee in theSportsFieldRenttable.
Reservation (Wed 18:00) → Interval match → "High" period → SportsFieldRent lookup → 6,000 Ft
Catch-all periods
Periods without any interval entries (like Anytime) serve as default fallbacks. If no interval matches a given day + time, the system uses the catch-all period for pricing.