In Transit Report ARC
From UG
(Difference between revisions)
(Created page with 'Category:OpsRepsCore') |
(→Tweaks V.1.1 b) |
||
(8 intermediate revisions not shown) | |||
Line 1: | Line 1: | ||
- | [[Category: | + | |
+ | [[Category:Ops Reps Old]] | ||
+ | |||
+ | === Ver 0 === | ||
+ | * http://mantis.jaguarfreight.com/svn/ct2/SS/2009/OpsReps/InTransit/v1/origDef.html [^] | ||
+ | * http://mantis.jaguarfreight.com/svn/ct2/SS/2009/OpsReps/html/CT2specsOpsReps.html [^] | ||
+ | |||
+ | |||
+ | |||
+ | |||
+ | == Ver 1.0 : Dates Conditions == | ||
+ | |||
+ | * These conditions are MOT specific | ||
+ | * Conditions below must be true for CT to be on this report | ||
+ | * They are hard coded | ||
+ | |||
+ | === MOT=Truck === | ||
+ | |||
+ | ((GenTab Estimated Export Pickup Date ''is not empty'' | ||
+ | OR GenTab Actual Export Pickup Date ''is not empty'' | ||
+ | )AND | ||
+ | GenTab Actual Delivery ''is empty'' ) = true | ||
+ | |||
+ | Or to re-phrase: | ||
+ | |||
+ | 2 conditions must be satisfied at the same time: | ||
+ | |||
+ | * cond1) One or more of the dates from the following list are NOT empty: | ||
+ | ** GenTab Estimated Export Pickup Date | ||
+ | ** GenTab Actual Export Pickup Date | ||
+ | |||
+ | * cond2) GenTab Actual Delivery is empty | ||
+ | |||
+ | === MOT = Air === | ||
+ | |||
+ | ((GenTab Estimated Export Pickup Date ''is not empty'' | ||
+ | OR GenTab Actual Export Pickup Date ''is not empty'' | ||
+ | OR ExpTab Arrival Into Warehouse Date ''is not empty'' | ||
+ | OR ExpTab Airport of Departure ETD ''is not empty'' | ||
+ | OR ExpTab Airport of Departure ATD ''is not empty'' | ||
+ | ) AND | ||
+ | ImpTab Actual Delivery ''is empty'' ) = true | ||
+ | |||
+ | === MOT = LCL === | ||
+ | |||
+ | ((GenTab Estimated Export Pickup Date ''is not empty'' | ||
+ | OR GenTab Actual Export Pickup Date ''is not empty'' | ||
+ | OR ExpTab Arrival Into Warehouse Date ''is not empty'' | ||
+ | OR ExpTab Origin Terminal ETD ''is not empty'' | ||
+ | OR ExpTab Origin Terminal ATD ''is not empty'' | ||
+ | OR ExpTab Port Of Loading ETD ''is not empty'' | ||
+ | OR ExpTab Port Of Loading ATD ''is not empty'' | ||
+ | ) AND | ||
+ | ImpTab Actual Delivery ''is empty'' ) = true | ||
+ | |||
+ | === MOT = FCL === | ||
+ | |||
+ | (For every containerX on Container Table: | ||
+ | Estimated collection OR | ||
+ | Actual collection is not empty) | ||
+ | OR ExpTab Origin Terminal ETD ''is not empty'' | ||
+ | OR ExpTab Origin Terminal ATD ''is not empty'' | ||
+ | OR ExpTab Port Of Loading ETD ''is not empty'' | ||
+ | OR ExpTab Port Of Loading ATD ''is not empty'' | ||
+ | AND | ||
+ | For at least one containerX on Container Table: | ||
+ | Actual Delivery is empty | ||
+ | |||
+ | === QA Plan === | ||
+ | *t1 for every MOT above design and run: | ||
+ | ** at least 2 sets of conditions for given CT that should make it APPEAR on report | ||
+ | ** at least 2 sets of conditions for given CT that should make it NOT APPEAR on report | ||
+ | |||
+ | === Tweaks V.1.1.a === | ||
+ | |||
+ | '''Note:''' Feed back added from meeting on Oct1,2009 | ||
+ | |||
+ | tw1) Add output tab for user in order to manage his report result. Heading consists of: | ||
+ | * CT# | ||
+ | * Shipper | ||
+ | * Consignee | ||
+ | * Quantity | ||
+ | * Departure | ||
+ | * Destination | ||
+ | * Departure Date | ||
+ | * Arrival Date | ||
+ | * P.O. | ||
+ | |||
+ | ''No update to TS'' | ||
+ | |||
+ | |||
+ | |||
+ | === Tweaks version 1.1.a === | ||
+ | '''Note:''' [[user:Tira|Tira]] 9:50 28 Oct 2009 | ||
+ | |||
+ | tw1) Add summary shipment record() count on the report to indicate that how many shipments... | ||
+ | |||
+ | tw2) Create a HTML result page before excel report | ||
+ | |||
+ | tw3) Create download to excel button -> generate xls report | ||
+ | |||
+ | ''No update to TS'' | ||
+ | |||
+ | === Tweaks V.1.1 b === | ||
+ | |||
+ | tw1) Update filter names as below | ||
+ | * From Countries -> Origin Countries | ||
+ | * To Countries -> Destination Countries | ||
+ | * From Regions -> Origin Regions | ||
+ | * To Regions -> Destination Regions | ||
+ | * From Airports -> Origin Airports | ||
+ | * To Airports -> Destination Airports | ||
+ | * From Ports/Terminals -> Origin Ports/Terminals | ||
+ | * To Ports/Terminals -> Destination Ports/Terminals | ||
+ | |||
+ | ''No update to TS'' | ||
+ | |||
+ | === Old versions of Column 1 and 2 on spreadsheet === | ||
+ | [[File:In Tansit Spreadsheet.JPG|thumb|600px|Figure 2:In Tansit Spreadsheet.JPG]] |
Current revision as of 15:49, 4 January 2010
Contents |
[edit] Ver 0
- http://mantis.jaguarfreight.com/svn/ct2/SS/2009/OpsReps/InTransit/v1/origDef.html [^]
- http://mantis.jaguarfreight.com/svn/ct2/SS/2009/OpsReps/html/CT2specsOpsReps.html [^]
[edit] Ver 1.0 : Dates Conditions
- These conditions are MOT specific
- Conditions below must be true for CT to be on this report
- They are hard coded
[edit] MOT=Truck
((GenTab Estimated Export Pickup Date is not empty OR GenTab Actual Export Pickup Date is not empty )AND GenTab Actual Delivery is empty ) = true
Or to re-phrase:
2 conditions must be satisfied at the same time:
- cond1) One or more of the dates from the following list are NOT empty:
- GenTab Estimated Export Pickup Date
- GenTab Actual Export Pickup Date
- cond2) GenTab Actual Delivery is empty
[edit] MOT = Air
((GenTab Estimated Export Pickup Date is not empty OR GenTab Actual Export Pickup Date is not empty OR ExpTab Arrival Into Warehouse Date is not empty OR ExpTab Airport of Departure ETD is not empty OR ExpTab Airport of Departure ATD is not empty ) AND ImpTab Actual Delivery is empty ) = true
[edit] MOT = LCL
((GenTab Estimated Export Pickup Date is not empty OR GenTab Actual Export Pickup Date is not empty OR ExpTab Arrival Into Warehouse Date is not empty OR ExpTab Origin Terminal ETD is not empty OR ExpTab Origin Terminal ATD is not empty OR ExpTab Port Of Loading ETD is not empty OR ExpTab Port Of Loading ATD is not empty ) AND ImpTab Actual Delivery is empty ) = true
[edit] MOT = FCL
(For every containerX on Container Table: Estimated collection OR Actual collection is not empty) OR ExpTab Origin Terminal ETD is not empty OR ExpTab Origin Terminal ATD is not empty OR ExpTab Port Of Loading ETD is not empty OR ExpTab Port Of Loading ATD is not empty AND For at least one containerX on Container Table: Actual Delivery is empty
[edit] QA Plan
- t1 for every MOT above design and run:
- at least 2 sets of conditions for given CT that should make it APPEAR on report
- at least 2 sets of conditions for given CT that should make it NOT APPEAR on report
[edit] Tweaks V.1.1.a
Note: Feed back added from meeting on Oct1,2009
tw1) Add output tab for user in order to manage his report result. Heading consists of:
- CT#
- Shipper
- Consignee
- Quantity
- Departure
- Destination
- Departure Date
- Arrival Date
- P.O.
No update to TS
[edit] Tweaks version 1.1.a
Note: Tira 9:50 28 Oct 2009
tw1) Add summary shipment record() count on the report to indicate that how many shipments...
tw2) Create a HTML result page before excel report
tw3) Create download to excel button -> generate xls report
No update to TS
[edit] Tweaks V.1.1 b
tw1) Update filter names as below
- From Countries -> Origin Countries
- To Countries -> Destination Countries
- From Regions -> Origin Regions
- To Regions -> Destination Regions
- From Airports -> Origin Airports
- To Airports -> Destination Airports
- From Ports/Terminals -> Origin Ports/Terminals
- To Ports/Terminals -> Destination Ports/Terminals
No update to TS