Campaign Offers¶
Navigate to Ajánlatok via /Club/CampaignOffer.
Overview¶
Campaign offers allow clubs to define special pricing for specific time slots, sports fields, and customer segments. When multiple offers match a reservation, the one with the highest Priority value wins.
Data Model¶
The CampaignOffer table stores all offer definitions:
| Column | Type | Description |
|---|---|---|
| Season_ID | FK | Season the offer belongs to |
| SportsFieldType_ID | FK | Required — the field type targeted |
| SportsField_ID | FK (nullable) | Optionally narrow to a specific field |
| UserType_ID | FK (nullable) | Optionally target a user type |
| User_ID | FK (nullable) | Optionally target an individual user |
| Date | date | Specific date for the offer |
| DayOfWeek_Code | char (nullable) | Recurring day-based offers |
| BeginningTime | time | Slot start |
| EndTime | time | Slot end |
| Priority | int | Higher value overrides lower |
| RentalFee | decimal | Special price |
| Notes | nvarchar | Internal notes |
| BgColor / FgColor | varchar | Calendar highlight colors |
| IsPublic | bit | Visible to customers |
| IsActive | bit | Whether the offer is in effect |
Targeting Rules¶
Campaign offers use a layered targeting model:
- SportsFieldType (Pályatípus) — required for every offer.
- SportsField (Pálya) — optionally narrow to one specific field.
- UserType (Felhasználó típus) — optionally restrict to a customer segment.
- User (Felhasználó) — optionally restrict to a single customer.
- DayOfWeek_Code (Hét napja) — for recurring weekly offers.
Priority resolution
When multiple campaign offers match the same time slot, the offer with the highest Priority integer wins. Design your offers so that more specific targeting carries a higher priority.
Calendar Display¶
Offers appear on the booking calendar with custom colors:
- BgColor — background highlight (default:
#2ee4d9) - FgColor — text color (default:
#ffffff)
These defaults are configured via the CampaignBackgroundColor and CampaignForegroundColor system parameters.
Visibility Flags¶
| Flag | Effect |
|---|---|
| IsPublic (Publikus) | When enabled, the offer is visible to customers on their booking calendar. |
| IsActive (Aktív) | When disabled, the offer is ignored during price calculation regardless of other settings. |
Related Stored Procedure¶
GetCampaignOffers— retrieves matching offers for the booking engine.
Demo environment
The demo site has 1 campaign offer configured for reference.