🎓 Training Management Dashboard
| Station | Type of Training | Planned Date | Actual Date | Trained By | Duration | Description | Status | Last Update | Action |
|---|---|---|---|---|---|---|---|---|---|
📊 Database Editor
🎫 Events & Planner Dashboard
| Key | Event Title ↕ | Status ↕ | Progress ↕ | Created ↕ | Last Update ↕ | Due Date ↕ | Labels | Assignees | Actions |
|---|
📊 Flight Analytics & Pivot Table
Pivot Configuration
Filters
📊 Pivot Matrix Result
📈 Analytics Chart Viz
⚙️ System Admin Panel
Add / Edit Airline
Defined Airlines
Havalimanı Veritabanı Alan Özelleştirme
Aşağıdaki listeden AirportDB'de hangi alanların görüntüleneceğini/düzenleneceğini belirleyebilir ve bu alanların etiketlerini (başlıklarını) değiştirebilirsiniz.
Not: IATA Kodu, Şehir ve Ülke gibi temel parametreler global düzeydedir ve gizlenemez.
Group Custom Styles
Configured Group Styles
Add Template Task
Checklist Template Items
⚙️ Airline SMTP Configuration & Email Notifications
Configure airline-isolated outgoing mail servers and automated email alerts for Planner & Trainings.
A notification email will be sent automatically to users who have an email address specified in User Management:
📜 Sent Email Logs
Audit trail of automated notifications and EasyMail dispatches sent via Airline SMTP.
➕ Havalimanı Ekle (Manuel & Akıllı Arama)
Havalimanının 3 haneli IATA kodunu yazıp **"Sorgula"** butonuna basarak koordinat, şehir, ülke ve ICAO kodunun internetten otomatik getirilmesini sağlayabilirsiniz.
✈️ Import Flight Routes (FROMTO.csv)
Upload the route schedule in CSV format (separated by semicolon).
Required Columns: Station, DEST, 2026, 2027.
This operation will recreate the route arcs on the map and automatically recalculate the total flight volumes for all airports in the main database.
📅 Import Detailed Flight Plan (flights.csv)
Upload the flight-by-flight plan in CSV format (separated by semicolon).
Required Columns: ORIG, DEST, FLT_DATE, AC_SEAT_TOTAL, TTL_PAX.
This operation will import detailed flight logs and automatically recalculate route summaries, first flight dates, and log new airports.
📥 Import Airport Database (CSV)
Upload your stations database in CSV format (separated by semicolon). Missing columns will be automatically created in the database and dynamic fields configurations.
Required Columns: Airport (represents the IATA code).
📥 Import Handling Contacts (CSV)
Upload your handling contacts directory in CSV format (separated by semicolon). This will overwrite existing contacts for this airline.
Expected Columns: Station;Department_or_Title;SECTION;MNGRORDEP;Person_in_Charge;Email_Address;Show_on_EFB;SITATEX;Office_Phone;Mobile_Phone
🏨 Untracked Flight Plan Airports
These IATA codes exist in the flight plan (`flights.csv`) but are missing from the main database (`airports` table). You can add them with one click.
🏢 Manage Departments / Groups
Sistemdeki kullanıcı departman gruplarını buradan ekleyebilir veya silebilirsiniz.
Active Groups
🔑 Sütun Yetkileri:
Seçilen grubun sadece işaretli sütunları düzenlemesine izin verilir. İşaretlenmeyen sütunlar kilitli kalacaktır.
⚙️ System Configuration
Sistem genelindeki güvenlik, veri kısıtlamaları ve başlangıç parametrelerini buradan yönetebilirsiniz.
📋 System Event Logs (Notlar)
| Timestamp | Station | User | Log Message | Action |
|---|
📡 Live ADSB Position Logs (Son 24 Saat)
| Logged At | Tescil (Reg) | Uçuş No | Status | Orig | Dest | Lat | Lng | İrtifa (ft) | Hız (kt) | Yön (°) |
|---|
✈️ Flights Master API Viewer
Add / Edit Event Status
Active Event Statuses (Max 8)
| Display Order | Status Name | Color Badge | Actions |
|---|
📁 Project Pools & Access Management
Manage project pools, key prefixes, and user access permissions here.
| ID | Airline | Key Prefix | Project Name | Description | Allowed Users | Actions |
|---|