TP 2 : TRAVEL TICKET IMPORT APP
1) TP Front-end
Implement the following app with it’s full navigation schema
4589521039
Amount XAF 270500
1
X
(3) Import Batch
Use native OS File Explorer to select ONE FOLDER
where all files will be imported
Open Cancel
2
Search …
# Travel Amount
DAN / STEPHENS JR MR XAF 42,520.00
ACC TML ACC -13 Days
057 9485632158 | 17 Oct 2022 Pending
ASMI / SOPHIA MRS XAF 250,500.00
LOS ABJ LOS +15 Days
459 9485632159 | 15 Nov 2022 Flown
X CHILUBA / FREDERICK MR XAF 89,900.00
NSI CDG BRU Today
082 9485632160 | 01 Nov 2022 Boarding
OLIVER / SWART MR XAF 150,560.00
DLA BJL DKR +6 Days
708 9485632161 | 06 Nov 2022 Flown
LERUO / MOLOTLEGI MR XAF 75,800.00
OUA ABJ COO -2 Days
906 9485632162 | 28 Oct 2022 Pending
(4) List
3
2) Parse an AIR file to extract the following information
# Name Value for this AIR
1 Issuing Date 17 Oct 2022
2 Itinerary ACC TML TML ACC
3 Currency GHS
Amount 100
4 Passenger Name TETTEH YEBOAH/GLADYS
5 Airline 394
Ticket Number 6716835023
4
3) Implement a Postgres DATABASE to host the TRAVEL
TICKET
# Name Type
1 Issuing Date Date
2 Itinerary String
3 Currency String
Amount Decimal
4 Passenger Name String
5 Airline String
Ticket Number String
4) Implement NEW ITEM from the designed UI
(1) New Item
Display TRAVEL TICKET form
Implement type validation on each field
All fields are required beforer SAVE is performed
UNICITY should be on TICKET NUMBER (Combination of AIRLINE CODE + NUMBER)
SAVE will add the item to the DATABASE
5) Implement IMPORT SINGLE from the designed UI
(2) Import
Single
Open the File Explorer
Select a file (AIR file)
Click on OPEN to import
Store the item (Travel Ticket) in the database
Send a confirmation message (Success or Error)
6) Implement IMPORT BATCH from the designed UI
(3) Import Batch
Open the File Explorer
Select a folder (containing one or several AIR files)
5
Click on OPEN to import
Store the items (Travel Ticket) in the database
Send a confirmation message (Success or Error)
7) Implement LIST DISPLAY from the designed UI
(4) List
Load TRAVEL TICKETS from the DATABASE as per required mapping
Implement the EDIT function
Implement the DELETE function
Implement the search feature to search LIKE occurrences on each field
PLACE HOLDER SPECIFICATIONS
# Travel Amount
PASSENGER NAME CURRENCY <Amount>
ITINERARY <Issuing Date - Today> Days
Airlinne Number | Issuing Date Pending : If Date is MORE THAN Today
Flown: If Date is LESS THAN Today
Boarding: If Date IS Today
Background for selected item