Changelog

• Enabled v5 Sandbox for VAs to experiment without affecting their VAs. Sandbox details are provided in our Discord.

Orwell:

• Added Route Import functionality.

• Reworked ID and Delete checks for importers.

• Enabled Airport, Fleet, and Aircraft importers for Sandbox VA.

• Enabled Claims, Events, and some VDS actions for Sandbox VA.

Backend:

• Added an option to unban IPs while keeping the account ban intact.

Orwell:

• Fixed and disabled Airport Import.

• Fixed Container Export.

• Added Container Import.

• Added Load Factor Import.

• Added Hub Import.

• Added Scenery Import.

• Added Stand Import.

• Added Stand Group Import.

• Added and disabled Aircraft Import.

• Added and disabled Fleet Import.

• Small update to Hangar - vAMSYS Sync. v5 will now push Hangar enable/disable settings and rank updates after changes.

• Disabled Hangar settings in vAMSYS v3.

• Successfully migrated our servers and the entire vAMSYS ecosystem to new servers, setting us up for future development and growth.

Phoenix

• Fixed rendering issues for some HTML elements on Custom Pages.

Orwell

• Added an Activity Whitelist table under Pilots.

• Added an Initial Activity table under Pilots.

• Added an Ongoing Activity table under Pilots.

• Introduced various Exporters: Fleet, Aircraft, Airport, Hub, Scenery, Stand, Stand Group, and Route.

• Added Export/Import settings for staff.

Backend

• Added a job to check routes and start/terminate them on schedule.

• Added a job to periodically delete old exports.

Routes, Bookings, and PIREPs have been disconnected from v3. v5 Beta is no longer aware of them, meaning that adding routes and making bookings will not affect v3.

Migration Preparation

• Event creation/editing has been disabled.

• Submitting claims has been disabled.

• Fleet creation has been disabled in VDS.

• Removed the unused VDS Statistics job.

VDS

• Refactored Route Creation/Editing forms.

• Route Type selectors now adjust available fields based on the type selected.

• Removed the Status column from Routes.

• Added functionality for VFR type routes to bypass route validation.

• Fixed ETE calculation when not entered.

• Routing can now be null, eliminating 'MANUAL ROUTE PLANNING REQUIRED' messages.

Phoenix

• Jumpseat route types now include jumpseat options.

• Implemented compatibility fixes for Repositioning and Training route types.

• Added native support for routes to the same airport.

• Implemented 'Online Network Remarks' to be sent to VATSIM and IVAO.

• Removed prefile options for bookings not dispatched via SB.

• Fixed SB Dispatch for Repositioning and Training flights.

• In the View Booking page, 'Company' route is no longer shown if empty.

• Added import functionality for Flight Level, Cost Index, and Estimated Time parameters from SB Dispatch.

Orwell

• Added point, hour, and review options for Repositioning, Training, and Charter flights in Settings -> Airline -> PIREPs.

• Added an Online Network Remarks setting in Settings -> Airline -> Bookings.

Phoenix:

• Corrected a typo in the Book Flight filters related to tags.

• Added the ability to hide the tags filter in Book Flight based on VDS settings.

• Added the ability to hide the tags filter in Destinations based on VDS settings.

VDS:

• Added fields for Arrival and Departure Times in route editing.

• Implemented cross-interaction between Arrival, Departure, and ETE times.

• Made the Arrival/Departure Time and Tag boxes visible based on VDS settings.

• Added a Route Type selector.

Orwell:

• Added an option to whitelist pilots from activity requirements.

• Added an option in VDS settings to disable Departure/Arrival Times.

• Added an option in VDS settings to disable Route Tags.

Backend:

• Implemented logic for processing pilot invites.

• Added logic to send Registration Rejected emails.

• Added logic to send Registration Received emails.

• Split various nightly jobs into independent jobs for greater redundancy if one VA's jobs fail.

• Refactored the process for removing frozen pilots/users.

• Updated initial activity logic and added email notifications.

• Updated ongoing activity logic, including a permanent removal flag and email notifications.

• Added an option for Team vAMSYS to change the VA owner.

• Added options for Team vAMSYS to manage VA staff entries and settings.

• Added options for Team vAMSYS to manage VA callsign parameters.

Phoenix:

• Event registrations now correctly refresh after registering/removing registration for event

Orwell:

• Badge count and Award Badge options correctly update after new badge is created/edited.

• Added Pilots -> Invite functionality replicating the options we have in v3.

Orwell:

• Reformatted text and layout on the Billing page.

• Added a list of recipients and a button to manually award badges on the Badges page.

• Added an action to award badges in the Pilot Table.

Backend:

• Updated the Aeolus Users table to display staff and owner counts.

Orwell:

• Added Jumpseat-related settings in Settings -> Airline -> Booking.

• Added a width setting for components in Settings -> Design -> Phoenix Dashboard.

• Included a number of items selector (1 to 8) for Booking and PIREP Box in Settings -> Design -> Phoenix Dashboard.

• Added an option in Settings -> Airline -> Pilot Activity to make pilot removals for inactivity permanent or non-permanent.

• Added 'Can Manage All Routes' permission in Settings -> Staff.

Phoenix:

• Implemented jumpseat-related options in Flight Centre -> Book Flight.

• Implemented jumpseat-related options in Flight Centre -> Destination Map.

• Improved map bounds fitting when only one aircraft is online in Flight Centre -> Live Flights / Dashboard.

• Enhanced custom layouts in Dashboard by allowing further splitting, refactoring CSS, and normalizing gaps.

• Refactored the Pilot Settings Action in Dashboard.

VDS:

• Fixed the map display for stands in Airport Management -> Stands.

• Fixed editing of stand groups in Airport Management -> Stands.

Backend:

• Added logic to remove expired VA Trials.

• Changed the process for restoring a Trial VA.

• Enabled the option for Team vAMSYS to delete Trial VAs.

• Added mailable notifications when a VA on trial is deleted.

• Refactored internal rank transfers into a queued job with statistics recalculation.

Backend:

• Fixed route statistics on the View Booking page.

• Removed all references to Pusher temporarily until reinstated.

• Updated booking cancellation logic: Bookings will be cancelled if not departed within 60 minutes of the booked departure time when dispatching or 12 hours after the last position report if the booking does not result in PIREP. These checks run every ten minutes and every 2 hours respectively.

• Added Airport Observer to take appropriate actions (deleting routes, moving pilots, etc.) when an airport is deleted.

• Improved logic for handling the deletion of a Stand Group.

• Refactored Ban/Unban logic and moved it to a job.

• Completed VDS Parameter observer to handle deleting parameters.

• Deleting a pilot now removes their future event registrations and active sessions.

• Defined actions to take when a user account is deleted.

Phoenix:

• Dashboard now includes the stand number in the Booking box if booked.

• Reworked the table and filters for NOTAMs.

• Added a checker for unread must-read NOTAMs. Users with unread NOTAMs are redirected to the NOTAMs page.

• Added tag functionality to the Book Flight section.

• Estimated departure time in Book Flight now uses a preparation time scorer. If absent, a default of 35 minutes is used.

• Dispatches in Book Flight now store departure time as date-time, enabling future features.

• Fixed an issue in View Booking when viewing non-container routes.

Orwell:

• Activated the View PIREP button in Livery Review's dropdown actions.

• Fixed display issues in PIREP Review when VA counts taxi time in flight length.

• Added an option in Billing for VAs on trial to terminate the trial and delete their VA.

VDS:

• Added tag functionality to Route Management.

• Added a filter in Airport Management to list previously deleted airports, with an option to restore them.

• Added sortable columns to Name, ICAO, IATA, Country, Category, and Base in Airport Management. The default sort is by airport, and sort preferences are stored in the session.

Phoenix

• Slightly refactored the look of the View Booking page.

• Added confirmation modals for cancelling bookings.

Aeolus

• Fixed sidebar styling for the Users menu when the sidebar is collapsed.

• Fixed the Capitalize Name action.

• Enhanced the Airlines table with new filters.

• Added edit, delete, and restore actions to the Airlines table.

• Completely rebuilt the Airline View page.

• Added a global data jobs overview.

• Added a global pilot list.

Other Bugs and Changes

• Restored missing VDS/Orwell shortcut buttons.

• Added a mandatory 'Reason' field for the "Send for Name Review" action in Orwell.

Select Page

• Fixed columns breaking mid-VA when the user is a pilot in an uneven number of VAs.

• Enforced a 9/2 aspect ratio on logos.

Phoenix

• Disabled re-dispatch. For several reasons, the preferred way to 'edit' the booking is to rebook. A Cancel and Rebook button has been added.

• Slightly refactored the View Booking page, pending a re-style.

• In Dispatch, allowed sorting of the booking flight list by flight number instead of callsign.

• Added a link to VDS from the dispatch page for staff with permission.

• Leaderboards now link to the Pilot profile.

Bugs

• Select Page: The buttons now function correctly again.

**Phoenix - Finalized Dispatch:**

• Implemented Load Factors for passengers, passenger luggage, cargo, and cargo volume.

• Added container selection and container amount selection features.

• Enhanced validation and redirects during dispatching.

• Fixed issues with SimBrief dispatch using containers and luggage.

• Resolved issues with redispatching when swapping routes between airports.

• Improved page load times for the View Booking page, with more optimizations planned.

• Corrected the calculation of passengers with hold luggage.

**Other Changes and Improvements:**

• Users who have not verified their emails are deleted after 7 days.

• Fixed the VA sync job to prevent failures when a deleted VA is restored.

• Resolved issues with VAs being undeleted in Hangar if they were restored in vAMSYS.

• Added a sortable Download Count column in the Staff Panel -> Files.

• Removed the Dashboard from the Staff Panel; the default page is now /files.

• Introduced a Downloads page in the Staff Panel to list all downloads, with the ability to mark items as 'ignored'.

• Renamed the Downloads section to Files in the Pilot Panel.

• Added a Packs section in the Pilot Panel, allowing users to download packs.

• Added partial download functionality in Pilot Panel -> Packs.

• Enhanced the Files repeater in Pilot Panel -> Packs with buttons to individually download, view, or hide files.

• Introduced a new table in Pilot Panel -> Your Downloads, allowing users to remove their download records.

**VDS:**

• In Airport Management -> Airports, finalized the assignment of Containers and Load Factors in both edit and create modals.

• In Route Management -> Routes, finalized the assignment of Containers and Load Factors across all edit forms.

**Orwell:**

• Added some charts to the Orwell Dashboard as a test. The plan is to eventually move these charts to a dedicated statistics page.

**VDS:**

• In Aircraft Management -> Fleets, changed the Create/Edit modals to use tabs instead of collapsible sections.

• In Aircraft Management -> Fleets, ensured that at least one Allowed Parameter must be selected when creating or editing a fleet.

• In Aircraft Management -> Fleets, added a 'type' selector for Pax/Cargo operations.

• Introduced container units in Aircraft Management -> Fleets and Aircraft, improving the lookup to the parent Fleet when overriding.

• In Load Management -> Containers, added a listing table with options to create, edit, and remove containers. A new feature compared to v3 is incompatible containers, i.e., containers that cannot be loaded together.

• In Airport Management -> Airports, updated the Create/Edit Modals to the now standard tabbed layout.

• Improved the creation modal in Airport Management -> Airports to enable all options previously hidden unless edited after creation, including taxi time overrides and airport managers.

• Added a Container management tab in Airport Management -> Airports.

**Phoenix:**

• Changed dashboard component spacing from 1 to 0.5 rem.

• Updated the dashboard pilot statistics component to align the 'Statistics:' text and make the selection box consistent with other boxes.

• Added a new 'slim' pilot statistics component, displaying only 3 blocks in one row instead of 6 blocks in two rows.

• Enabled Load Factors (Passenger and Cargo) set in VDS to determine pax/freight load in booking dispatch.

**Orwell:**

• Changed dashboard component spacing from 1 to 0.5 rem.

• Normalized the dashboard statistics component to look similar to the one in Phoenix.

• Added options to the Dashboard New Registrations Table to auto-capitalize names and report names to Team vAMSYS.

**VDS:**

• Updated the Airport Overview table to use live data instead of pre-cached data.

• Changed table column links to redirect to the new routes table.

• Added required filters to the routes table.

• Adjusted the paginator on the routes table.

• Limited Bulk Full Edit functionality in the routes table to 20 records.

• Introduced Load Management -> Load Factors, the first step in setting up custom Load Factors (LFs) for Pax/Cargo operations.

**Other Changes and Additions:**

• Added three additional indexes to the database.

• Fixed an issue that was breaking URLs on Chromium browsers (Orwell Dashboard Infobox).

• Resolved Aeolus errors that were preventing access to the dashboard and edit pages.

**VDS:**

• Introduced a new Routes Table.

• Implemented Quick Edit action for single routes.

• Implemented Copy & Edit action for single routes.

• Implemented End Today action for single routes.

• Implemented Remove End Date action for single routes.

• Implemented Delete action for single routes.

• Implemented End Today bulk action.

• Implemented Remove End Date bulk action.

• Implemented Bulk Delete action.

• Implemented Bulk Edit action.

• Implemented Bulk Full Edit action, along with the related page and logic.

**Other Changes and Additions:**

• Tweaked database indexes for improved performance.

**Optimization Work:**

A lot of optimization work was done today to clear the backlog and improve the speed of v5:

• Second round of database optimizations.

• Removed 1.3 million jumpseat PIREP records, as v5 no longer logs them.

• Removed 200 million Position Reports from flights that did not result in a PIREP.

• Added a nightly prune job to remove Position Reports to prevent buildup.

• Major refactor of used traits, including deduplication of database queries.

• Moved some session handling tasks to asynchronous jobs.

• Query optimizations in Phoenix Dashboard.

• Query optimizations in Phoenix -> Events.

• Query optimizations in Phoenix -> Documents -> Scorer.

• Query optimizations in Phoenix -> Resources -> Airports.

**VDS:**

• Added a list of users with VDS access to the Dashboard.