Welcome to the Airline app - created and maintained by Sascha Wildgrube.
This app was built to help organizing the shipment of medical supplies to the Ukraine during the full-scale invasion that started in February 2022.
It is dedicated to the people of Ukraine, their resistance, their bravery and to everyone who invests their time and resources to help.
Manage pilots, aircraft, aircraft models and airports.
Plan and schedule flights - produce PDF flight sheets for pilots and PPRs for airports.
Manage safety requirements for flights, like IPR and deicing requirements.
Aggregate multilpe flights to a mission - to coordinate connection flights and complex transport operations.
Mission planning is supported by maintaining a list of potential airports and pilots.
Manage freight and passengers.
Connect to the OpenAIP API to get additonal information on airports automatically.
Airline is NOT an officially supported ServiceNow product.
Airline does NOT come with any kind of warranty. If you use it, you own it!
x_snc_devtools.InstallApp("x_snc_airline");Controls if the Airline application is active.
Controls the verbosity of log output produced by the Airline application.
ID: x_snc_airline.OpenAIP_API
The airline admin role grants all access to all areas, including the test suite and application logs.
The airline manager role grants all read and write access to all data and all flight planning and operations activities.
The airline viewer role grants read access to all areas and data.
The table is not derived from any other table.
The table is not derived from any other table.
The table is not derived from any other table.
The table is not derived from any other table.
The table is not derived from any other table.
The table is not derived from any other table.
The table is not derived from any other table.
The table is not derived from any other table.
The table is not derived from any other table.
The table is derived from table User (sys_user).
The table is not derived from any other table.
Sets the state of the flight to "Complete" and prevents further changes except for the post completion notes.
Opens the flightaware page for this aircraft.
Open Google image search page in a new browser tab to show images of the aircraft model.
Display a list of all contact details of everyone involved in the mission.
Display the the list of emails of everyone involved in this mission.
Display a list of email addresses of all identified potential pilots.
Create a new airport schedule
Create a Prior Permission Required message to the airport associated to the flight stop.
Create PPR messages to be sent to all airports associated to the stops of this flight.
Creates PPR messages to be sent to all airports associated to all stops of all flights of this mission.
Saves the current flight stop and opens the form to create another one.
Change the state of a flight to "Scheduled" and verify the choices made during planning.
Displays the operating hours of an airport.
Opens the skyvector page for this airport.
Sets the state of a flight back to "Planning".
Create or update the PDF flight sheet.
Activities to be performed when the application is being baselined.
Creates test data for the Airline app.
Retrieves information about the app's dependencies to other apps and required versions.
Gets a system property of this application.
This script installs Airline.
Sets all system properties to default values.
Sets a system property of this application.
Creates the flight sheet pdf document and attaches it to the flight record.
Produces a log output in the application log using the DevTools Debug function.
Implements the extension point for DevTools.
The function DevToolsGetApplicationStatus is called by the DevTools extension point instance class and returns the application status object with additional status information to be displayed on the "DevTools Application Overview" page.
The DevToolsGetFormatConfig function is called by the DevTools extension point instance class and returns an object with field formatting information.
The function DevToolsGetInstancePipelineName is called by the DevTools extension point instance class and returns the pipeline name of an instance based on the given actual name.
The DevToolsGetLinkDirectory function is called by the DevTools extension point instance class and returns an extended (or modified) link directory object that serves as the basis for the DevTools Link page.
The DevToolsGetParentRecord function is called by the DevTools extension point instance class and returns a parent record for the given record if it can be determined.
The function DevToolsRenderDebugDump is called by the DevTools extension point instance class and returns additional debug information provided by the application.
Returns a GlideRecord object representing the aircraft based on the given Sys ID, or false if the aircraft does not exist.
Returns an object containing coordinates of the airport in longitude and latitude values.
Returns an airport record if the given record can be found, false if not.
Returns a GlideRecord object representing a flight based on the given Sys ID, or false if the flight does not exist.
Renders a passenger's display value.
Returns a GlideRecord object representing the passenger based on the given Sys ID, or false of the passenger does not exist.
Returns a pilot record if the given record can be found, false if not.
Returns true if the application is active, otherwise false.
Produces a log output in the application log.
Produces an error log output in the application log.
Produces a warning log output in the application log.
Retrieves airport information from the OpenAIP API based on a given ICAO code.
Sends a request to the OpenAIP API using the API key configured with the OpenAIP API credential alias.
Searches for airports via the OpenAIP API based on a given search string.
Compatible Versions: 1.102.0
Repository url: https://github.com/saschawildgrube/servicenow-devtools.git
Using numerous script include functions.
Compatible Versions: 1.2.0
Repository url: https://github.com/saschawildgrube/servicenow-geodata.git
Using the Schengen and EU fields on the country table.
Compatible Versions: 1.2.0
Repository url: https://github.com/saschawildgrube/servicenow-parcel.git
Parcels can be loaded and unloaded during flights.
A number of Script Includes are not yet covered in ATF tests.
Copyright 2022-2024 by Sascha Wildgrube
Licensed under the Apache License, Version 2.0 (the "License")
You may not use Airline except in compliance with the License.
You may obtain a copy of the License at: https://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.
First baselined version