Task #17696
openTask #18862: Sprint Planning for 06/10/2025 - 17/10/2025
FFS_Air_Flight
100%
Description
What is a Flight?
A commercial flight is a flight operated by an airline or aviation company (GSA) for the purpose of transporting cargo.
Reason for creation of a Flight in Provisional state?
In many cases, the Freight Forwarder knows a minimum of information prior to the shipment. The minimum information are: (a) Airline code (b) Port of origin (c) Port of Destination (d) Expected date and time of arrival. Hence, the Freight Forwarder should be able to create the flight with the minimum data. The other fields (as explained in point (b) should become Mandatory when switching from 'Provisional' to 'Final'
Pre-requisite:
- Manage 'Airline Module' should already be present (Ticket number: #229 )
Contents of a 'Flight Schedule' Screen:
-
Display list of Schedule Flights. Columns displayed are:
Airline Code ICAO Code Flight Number Port of Origin Port of Destination Expected Arrival Date / Time (Destination) Actual Arrival Date/Time ATP Number Report Number State Mode of Shipment MK MAU 045 DXB - Dubai International Airport MRU - SSR International Airport 12/02/2025 17:00 12/02/2025 17:15 ATP25212261 000362 Provisional / Final Import / Export -
Display 'ADD FLIGHT' :
(a). When clicking on "ADD FLIGHT" button, A new pop-up 'Add Flight' screen is displayed.
(b) Fields to be displayed in "Add Flight" screen:
-
Airline code (Dropdown from 'Manage Airlines' - Active Airline only) [MANDATORY]
-
Flight number [OPTIONAL WHEN STATE IS PARTIAL ELSE IT IS MANDATORY]
-
ATP number [OPTIONAL WHEN STATE IS PARTIAL ELSE IT IS MANDATORY]
-
State - User to select either 'Provisional' or 'Final'.
-
Checkbox Indicating 'Valid' or not.
-
Port of Origin [MANDATORY]
-
Port of Destination [MANDATORY]
-
Expected Date/Time of Arrival. [MANDATORY]
-
Actual Date/Time of Arrival. [OPTIONAL]
-
Report Number [OPTIONAL]
-
Mode of Shipment - User to Select 'Import' or 'Export'.
-
User should be able to 'ADD/UPDATE'
-
User should be able to search flight by
(i) Flight Code
(ii) Flight Number
(iii) Date Range - Arrival
(iv) State
-
Activity log - All changes made pertaining to a Flight should be logged automatically for traceability purposes.
-
A Flight should be unique per day. For e.g. we cannot have two Import Flight MK150 for the same day.
-
Option to upload 'NOA' received from the Airline.
-
A checkbox indicating 'NOA' has been received from the Airline for those who receives the message electronically.
Special conditions:
(a) A Flight cannot be deleted in case (i) a shipment cost (ii) File reference is associated to it.
(b) Option to Mark the Flight as 'Skipped'.
(c) Option to clone the Flight [But shall be Modifiable]
GitLab Sync Log
[{"id": "27780", "author": "Al-Shad Isaac", "hours": 2.0, "created": "2025-08-06T06:05:20.925Z", "log_date": "2025-08-06", "comment": "Imported from GitLab by @Al-Shad Isaac on 2025-08-06T06:05:20.925Z: 2h-(2.0)h spend at: 2025-08-06", "status": "active", "deleted_by": "", "redmine_entry_id": 10063}, {"id": "29977", "author": "Gilles Mahomudally", "hours": 8.0, "created": "2025-08-29T07:46:07.860Z", "log_date": "2025-08-28", "comment": "Imported from GitLab by @Gilles Mahomudally on 2025-08-29T07:46:07.860Z: 1d-(8.0)h spend at: 2025-08-28", "status": "active", "deleted_by": "", "redmine_entry_id": 10232}, {"id": "28632", "author": "Waliyuddin Delba", "hours": 6.0, "created": "2025-08-22T12:00:27.240Z", "log_date": "2025-08-21", "comment": "Imported from GitLab by @Waliyuddin Delba on 2025-08-22T12:00:27.240Z: 6h-(6.0)h spend at: 2025-08-21", "status": "active", "deleted_by": "", "redmine_entry_id": 10233}, {"id": "28590", "author": "Waliyuddin Delba", "hours": 6.0, "created": "2025-08-21T12:01:49.538Z", "log_date": "2025-08-20", "comment": "Imported from GitLab by @Waliyuddin Delba on 2025-08-21T12:01:49.538Z: 6h-(6.0)h spend at: 2025-08-20", "status": "active", "deleted_by": "", "redmine_entry_id": 10234}, {"id": "30182", "author": "Waliyuddin Delba", "hours": 6.0, "created": "2025-09-04T11:54:56.619Z", "log_date": "2025-09-01", "comment": "Imported from GitLab by @Waliyuddin Delba on 2025-09-04T11:54:56.619Z: 6h-(6.0)h spend at: 2025-09-01", "status": "active", "deleted_by": "", "redmine_entry_id": 10278}, {"id": "30181", "author": "Waliyuddin Delba", "hours": 5.5, "created": "2025-09-04T11:53:21.544Z", "log_date": "2025-09-02", "comment": "Imported from GitLab by @Waliyuddin Delba on 2025-09-04T11:53:21.544Z: 5h 30m-(5.5)h spend at: 2025-09-02", "status": "active", "deleted_by": "", "redmine_entry_id": 10279}, {"id": "30180", "author": "Waliyuddin Delba", "hours": 6.0, "created": "2025-09-04T11:50:25.563Z", "log_date": "2025-09-03", "comment": "Imported from GitLab by @Waliyuddin Delba on 2025-09-04T11:50:25.563Z: 6h-(6.0)h spend at: 2025-09-03", "status": "active", "deleted_by": "", "redmine_entry_id": 10280}, {"id": "30356", "author": "Waliyuddin Delba", "hours": 6.0, "created": "2025-09-10T12:00:19.046Z", "log_date": "2025-09-09", "comment": "Imported from GitLab by @Waliyuddin Delba on 2025-09-10T12:00:19.046Z: 6h-(6.0)h spend at: 2025-09-09", "status": "active", "deleted_by": "", "redmine_entry_id": 10312}, {"id": "30392", "author": "Gilles Mahomudally", "hours": 6.0, "created": "2025-09-11T09:32:10.626Z", "log_date": "2025-09-10", "comment": "Imported from GitLab by @Gilles Mahomudally on 2025-09-11T09:32:10.626Z: 6h-(6.0)h spend at: 2025-09-10", "status": "active", "deleted_by": "", "redmine_entry_id": 10322}, {"id": "30391", "author": "Gilles Mahomudally", "hours": 4.0, "created": "2025-09-11T09:32:02.448Z", "log_date": "2025-09-07", "comment": "Imported from GitLab by @Gilles Mahomudally on 2025-09-11T09:32:02.448Z: 4h-(4.0)h spend at: 2025-09-07", "status": "active", "deleted_by": "", "redmine_entry_id": 10323}, {"id": "30389", "author": "Gilles Mahomudally", "hours": 8.0, "created": "2025-09-11T09:31:35.770Z", "log_date": "2025-09-09", "comment": "Imported from GitLab by @Gilles Mahomudally on 2025-09-11T09:31:35.770Z: 1d-(8.0)h spend at: 2025-09-09", "status": "active", "deleted_by": "", "redmine_entry_id": 10324}, {"id": "30388", "author": "Gilles Mahomudally", "hours": 8.0, "created": "2025-09-11T09:31:27.035Z", "log_date": "2025-09-08", "comment": "Imported from GitLab by @Gilles Mahomudally on 2025-09-11T09:31:27.035Z: 1d-(8.0)h spend at: 2025-09-08", "status": "active", "deleted_by": "", "redmine_entry_id": 10325}, {"id": "30387", "author": "Gilles Mahomudally", "hours": 8.0, "created": "2025-09-11T09:31:16.520Z", "log_date": "2025-09-07", "comment": "Imported from GitLab by @Gilles Mahomudally on 2025-09-11T09:31:16.520Z: 1d-(8.0)h spend at: 2025-09-07", "status": "deleted", "deleted_by": "30390", "redmine_entry_id": 10326}, {"id": "30989", "author": "Waliyuddin Delba", "hours": 4.0, "created": "2025-09-26T05:23:44.506Z", "log_date": "2025-09-23", "comment": "Imported from GitLab by @Waliyuddin Delba on 2025-09-26T05:23:44.506Z: 4h-(4.0)h spend at: 2025-09-23", "status": "active", "deleted_by": "", "redmine_entry_id": 10426}, {"id": "30985", "author": "Waliyuddin Delba", "hours": 5.0, "created": "2025-09-26T05:22:39.139Z", "log_date": "2025-09-21", "comment": "Imported from GitLab by @Waliyuddin Delba on 2025-09-26T05:22:39.139Z: 5h-(5.0)h spend at: 2025-09-21", "status": "active", "deleted_by": "", "redmine_entry_id": 10427}, {"id": "30983", "author": "Waliyuddin Delba", "hours": 6.0, "created": "2025-09-26T05:20:44.055Z", "log_date": "2025-09-11", "comment": "Imported from GitLab by @Waliyuddin Delba on 2025-09-26T05:20:44.055Z: 6h-(6.0)h spend at: 2025-09-11", "status": "active", "deleted_by": "", "redmine_entry_id": 10428}, {"id": "31336", "author": "Al-Shad Isaac", "hours": 0.5, "created": "2025-10-03T06:46:23.928Z", "log_date": "2025-10-03", "comment": "Imported from GitLab by @Al-Shad Isaac on 2025-10-03T06:46:23.928Z: 30m-(0.5)h spend at: 2025-10-03", "status": "active", "deleted_by": "", "redmine_entry_id": 10581}, {"id": "31404", "author": "Waliyuddin Delba", "hours": 4.0, "created": "2025-10-06T05:51:57.984Z", "log_date": "2025-10-02", "comment": "Imported from GitLab by @Waliyuddin Delba on 2025-10-06T05:51:57.984Z: 4h-(4.0)h spend at: 2025-10-02", "status": "active", "deleted_by": "", "redmine_entry_id": 10595}, {"id": "31480", "author": "Waliyuddin Delba", "hours": 1.0, "created": "2025-10-06T06:46:52.733Z", "log_date": "2025-10-01", "comment": "Imported from GitLab by @Waliyuddin Delba on 2025-10-06T06:46:52.733Z: 1h-(1.0)h spend at: 2025-10-01", "status": "active", "deleted_by": "", "redmine_entry_id": 10615}, {"id": "31474", "author": "Waliyuddin Delba", "hours": 6.0, "created": "2025-10-06T06:44:13.602Z", "log_date": "2025-09-30", "comment": "Imported from GitLab by @Waliyuddin Delba on 2025-10-06T06:44:13.602Z: 6h-(6.0)h spend at: 2025-09-30", "status": "active", "deleted_by": "", "redmine_entry_id": 10616}, {"id": "31467", "author": "Waliyuddin Delba", "hours": 4.0, "created": "2025-10-06T06:42:08.067Z", "log_date": "2025-10-02", "comment": "Imported from GitLab by @Waliyuddin Delba on 2025-10-06T06:42:08.067Z: 4h-(4.0)h spend at: 2025-10-02", "status": "active", "deleted_by": "", "redmine_entry_id": 10617}, {"id": "31461", "author": "Waliyuddin Delba", "hours": 5.0, "created": "2025-10-06T06:38:09.449Z", "log_date": "2025-10-01", "comment": "Imported from GitLab by @Waliyuddin Delba on 2025-10-06T06:38:09.449Z: 5h-(5.0)h spend at: 2025-10-01", "status": "active", "deleted_by": "", "redmine_entry_id": 10618}, {"id": "31454", "author": "Waliyuddin Delba", "hours": 3.0, "created": "2025-10-06T06:36:52.861Z", "log_date": "2025-10-02", "comment": "Imported from GitLab by @Waliyuddin Delba on 2025-10-06T06:36:52.861Z: 3h-(3.0)h spend at: 2025-10-02", "status": "deleted", "deleted_by": "31462", "redmine_entry_id": 10619}, {"id": "31647", "author": "Waliyuddin Delba", "hours": 8.0, "created": "2025-10-08T05:41:37.101Z", "log_date": "2025-10-06", "comment": "Imported from GitLab by @Waliyuddin Delba on 2025-10-08T05:41:37.101Z: 1d-(8.0)h spend at: 2025-10-06", "status": "active", "deleted_by": "", "redmine_entry_id": 10672}, {"id": "31645", "author": "Waliyuddin Delba", "hours": 8.0, "created": "2025-10-08T05:38:21.768Z", "log_date": "2025-10-05", "comment": "Imported from GitLab by @Waliyuddin Delba on 2025-10-08T05:38:21.768Z: 1d-(8.0)h spend at: 2025-10-05", "status": "active", "deleted_by": "", "redmine_entry_id": 10673}, {"id": "31874", "author": "Waliyuddin Delba", "hours": 2.0, "created": "2025-10-13T09:32:51.120Z", "log_date": "2025-10-08", "comment": "Imported from GitLab by @Waliyuddin Delba on 2025-10-13T09:32:51.120Z: 2h-(2.0)h spend at: 2025-10-08", "status": "active", "deleted_by": "", "redmine_entry_id": 10731}, {"id": "31873", "author": "Waliyuddin Delba", "hours": 7.0, "created": "2025-10-13T09:32:37.955Z", "log_date": "2025-10-09", "comment": "Imported from GitLab by @Waliyuddin Delba on 2025-10-13T09:32:37.955Z: 7h-(7.0)h spend at: 2025-10-09", "status": "active", "deleted_by": "", "redmine_entry_id": 10732}, {"id": "31872", "author": "Waliyuddin Delba", "hours": 6.0, "created": "2025-10-13T09:31:11.980Z", "log_date": "2025-10-08", "comment": "Imported from GitLab by @Waliyuddin Delba on 2025-10-13T09:31:11.980Z: 6h-(6.0)h spend at: 2025-10-08", "status": "active", "deleted_by": "", "redmine_entry_id": 10733}, {"id": "31871", "author": "Waliyuddin Delba", "hours": 1.0, "created": "2025-10-13T09:30:24.144Z", "log_date": "2025-10-07", "comment": "Imported from GitLab by @Waliyuddin Delba on 2025-10-13T09:30:24.144Z: 1h-(1.0)h spend at: 2025-10-07", "status": "active", "deleted_by": "", "redmine_entry_id": 10734}, {"id": "31870", "author": "Waliyuddin Delba", "hours": 5.0, "created": "2025-10-13T09:29:49.204Z", "log_date": "2025-10-07", "comment": "Imported from GitLab by @Waliyuddin Delba on 2025-10-13T09:29:49.204Z: 5h-(5.0)h spend at: 2025-10-07", "status": "active", "deleted_by": "", "redmine_entry_id": 10735}, {"id": "31963", "author": "Waliyuddin Delba", "hours": 3.33, "created": "2025-10-14T09:14:29.794Z", "log_date": "2025-10-12", "comment": "Imported from GitLab by @Waliyuddin Delba on 2025-10-14T09:14:29.794Z: 3h 20m-(3.33)h spend at: 2025-10-12", "status": "active", "deleted_by": "", "redmine_entry_id": 10777}, {"id": "31962", "author": "Waliyuddin Delba", "hours": 3.0, "created": "2025-10-14T09:13:45.107Z", "log_date": "2025-10-12", "comment": "Imported from GitLab by @Waliyuddin Delba on 2025-10-14T09:13:45.107Z: 3h-(3.0)h spend at: 2025-10-12", "status": "active", "deleted_by": "", "redmine_entry_id": 10778}, {"id": "32061", "author": "Waliyuddin Delba", "hours": 1.0, "created": "2025-10-16T05:29:15.825Z", "log_date": "2025-10-14", "comment": "Imported from GitLab by @Waliyuddin Delba on 2025-10-16T05:29:15.825Z: 1h-(1.0)h spend at: 2025-10-14", "status": "active", "deleted_by": "", "redmine_entry_id": 10818}, {"id": "32465", "author": "Al-Shad Isaac", "hours": 0.5, "created": "2025-10-22T12:01:37.216Z", "log_date": "2025-10-22", "comment": "Imported from GitLab by @Al-Shad Isaac on 2025-10-22T12:01:37.216Z: 30m-(0.5)h spend at: 2025-10-22", "status": "active", "deleted_by": "", "redmine_entry_id": 10945}, {"id": "32486", "author": "Waliyuddin Delba", "hours": 3.0, "created": "2025-10-23T05:35:21.418Z", "log_date": "2025-10-21", "comment": "Imported from GitLab by @Waliyuddin Delba on 2025-10-23T05:35:21.418Z: 3h-(3.0)h spend at: 2025-10-21", "status": "active", "deleted_by": "", "redmine_entry_id": 10952}, {"id": "32546", "author": "Waliyuddin Delba", "hours": 1.5, "created": "2025-10-23T11:46:38.948Z", "log_date": "2025-10-22", "comment": "Imported from GitLab by @Waliyuddin Delba on 2025-10-23T11:46:38.948Z: 1h 30m-(1.5)h spend at: 2025-10-22", "status": "active", "deleted_by": "", "redmine_entry_id": 10968}]