Task Details

Task Details :-

Nigel,

for every order that is uploaded... we need to keep record of the histoy of what will happen to this order.... we call this order tracking.

This will be a new table you will create called "Order_Tracking", currently it will have these column:

Order ID - this is primary key from orders

DateTime - need to keep track when the order was updated

Status - this will the update of the order depending on different cases we will do later..
The first case we know already... which is "Order has been uploaded" - so you can ADD this as a new entry into the Order_Tracking when user confirm "upload data"

the second case we know alerady... which is "AWB Bills created" - so you can add this when user clicks created AWB and the pdf is downloaded successfully.

So this will be a table with multiple rows for each order... each time something new is updated for teh order.

the table screenshot shows what it will look like.

We will show the tracking for the orders later on anotehr task.

Task Current Status :-

Task Complete