Shipment Progress condition
From UG
(Difference between revisions)
(→Dept logic) |
|||
(46 intermediate revisions not shown) | |||
Line 1: | Line 1: | ||
- | + | [[Category:Client_Reports]] | |
- | + | ||
- | + | == Intro == | |
- | ** | + | '''new''' Read [[Shipment Milestones and Phases]] to get some background info. --[[User:Alex|Alex]] 19:46, 9 August 2009 (UTC) |
- | *** If "10.Actual Export Pickup Date:" is not empty, show a solid bar | + | |
- | * | + | == Auth logic == |
- | + | ||
- | + | * MOT = any | |
- | + | ** If "GenTab.19.Authorized on" field is not empty, show a solid bar else show empty bar | |
- | * | + | |
- | + | == Collected (Picked) logic == | |
- | * | + | |
- | + | * MOT = AIR or LCL or Truck-Air or Truck-Dom or Truck-ocean | |
- | + | ** If "GenTab.10.Actual Export Pickup Date:" is not empty, show a solid bar, else show no bar | |
- | + | ||
- | + | * MOT = FCL | |
- | + | IF "ContTab.Actual collection date" is not empty FOR ALL containers | |
- | * | + | THEN show a solid bar |
- | + | ELSE IF "ContTab.Actual collection date" is not empty FOR AT LEAST ONE container | |
- | + | THEN show a shaded(or broken) bar | |
- | * | + | ELSE show no bar |
- | + | ||
- | ** | + | * MOT = Truck-Dom or Truck-Air |
- | ** | + | |
- | ** | + | IF "GenTab.10. Actual Pick-Up Date" is not empty |
- | + | THEN show a solid bar | |
- | * | + | ELSE show no bar |
- | + | ||
- | * | + | * MOT = Truck-Ocn |
- | + | ||
- | * Deliv Logic | + | IF "ContTab.Actual collection date" is not empty FOR ALL containers |
- | ** | + | THEN show a solid bar |
- | * | + | ELSE IF "ContTab.Actual collection date" is not empty FOR AT LEAST ONE container |
- | + | THEN show a shaded(or broken) bar | |
- | * | + | ELSE show no bar |
- | * | + | |
- | ** AIR | + | == Dept logic == |
- | + | ||
+ | * MOT = AIR | ||
+ | ** If "ExpTab.11c ATD - Actual Time of Dept:" is not empty, show a solid bar, else no bar | ||
+ | |||
+ | * MOT = LCL or FCL | ||
+ | ** If "ExpTab.12c. ATD" not empty show a solid bar; ELSE show no bar | ||
+ | |||
+ | |||
+ | * MOT = Truck-Dom or Truck-Air | ||
+ | same as in Collected (Picked) logic | ||
+ | |||
+ | * MOT = Truck-Ocn | ||
+ | same as in Collected (Picked) logic | ||
+ | |||
+ | * All MOT: | ||
+ | :* IF "Dept" bar exists but conditions for "Collected" is not satisfied THEN show bar before that anyway so that bar is not broken | ||
+ | :*This could happen when non jaguar company collects shipment. in this case jag opers do not enter Coll date | ||
+ | |||
+ | == Arr logic == | ||
+ | |||
+ | * AIR | ||
+ | ** If "ExpTab.14c. ATA - Actual Time of Arrival:" is not empty, show a solid bar; else no bar | ||
+ | |||
+ | * MOT = LCL or FCL | ||
+ | IF "ExpTab.14c. ATA:" is not empty | ||
+ | THEN show a solid bar | ||
+ | ELSE no bar | ||
+ | |||
+ | * MOT = Trucking Air or Trucking Domestic | ||
+ | |||
+ | If "Y.Actual Delivery" is not empty | ||
+ | THEN show a solid bar | ||
+ | ELSE no bar | ||
+ | |||
+ | * MOT = Truck-ocean | ||
+ | same logic as for Deliv Logic for MOT = FCL | ||
+ | |||
+ | == Deliv Logic == | ||
+ | |||
+ | * AIR | ||
+ | ** If "ImpTab.Act Deliver Date" is not empty, show a solid bar; else no bar | ||
+ | |||
+ | * MOT = LCL | ||
+ | |||
+ | IF "ImpTab.11. Actual Delivery Date" not empty | ||
+ | THEN show solid bar | ||
+ | ELSE show no bar | ||
+ | |||
+ | * MOT = FCL | ||
+ | |||
+ | IF "ContTab.Actual Delivery date" is not empty FOR ALL containers | ||
+ | THEN show a solid bar | ||
+ | ELSE IF "ContTab.Actual Delivery date" is not empty FOR AT LEAST ONE container | ||
+ | THEN show a shaded(or broken) bar | ||
+ | ELSE show no bar | ||
+ | |||
+ | |||
+ | * MOT = Trucking Air or Trucking Domestic | ||
+ | |||
+ | same logic as for Arrived Logic for MOT = Trucking Air or Trucking Domestic | ||
+ | |||
+ | * MOT = Truck-ocean | ||
+ | same logic as for Deliv Logic for MOT = FCL | ||
+ | |||
+ | == CC Logic == | ||
+ | |||
+ | * MOT = AIR or Ocean FCL or LCL | ||
+ | IF "ImpTab.Custom status" == (Custom Status) AND "ImpTab.Custom Status Date" are both not empty | ||
+ | THEN show a filled circle color by status; else no color (blank circle) | ||
+ | |||
+ | * MOT = Truck modes | ||
+ | always show always unchecked | ||
+ | |||
+ | * CC status | ||
+ | ONLY green color has checked mark symbol | ||
+ | |||
+ | |||
+ | == History == | ||
+ | === m1342 === | ||
+ | * Make an empty bar for the status of progressing bar that is empty and occurred before the other bars(partial/solid bar) | ||
+ | * See [[#Auth logic ]] | ||
+ | * Spec is updated: Y | ||
+ | * see attached image on Mantis [http://mantis.jaguarfreight.com/mantis/view.php?id=1342 1342] |
Current revision as of 21:15, 7 June 2010
Contents |
[edit] Intro
new Read Shipment Milestones and Phases to get some background info. --Alex 19:46, 9 August 2009 (UTC)
[edit] Auth logic
- MOT = any
- If "GenTab.19.Authorized on" field is not empty, show a solid bar else show empty bar
[edit] Collected (Picked) logic
- MOT = AIR or LCL or Truck-Air or Truck-Dom or Truck-ocean
- If "GenTab.10.Actual Export Pickup Date:" is not empty, show a solid bar, else show no bar
- MOT = FCL
IF "ContTab.Actual collection date" is not empty FOR ALL containers THEN show a solid bar ELSE IF "ContTab.Actual collection date" is not empty FOR AT LEAST ONE container THEN show a shaded(or broken) bar ELSE show no bar
- MOT = Truck-Dom or Truck-Air
IF "GenTab.10. Actual Pick-Up Date" is not empty THEN show a solid bar ELSE show no bar
- MOT = Truck-Ocn
IF "ContTab.Actual collection date" is not empty FOR ALL containers THEN show a solid bar ELSE IF "ContTab.Actual collection date" is not empty FOR AT LEAST ONE container THEN show a shaded(or broken) bar ELSE show no bar
[edit] Dept logic
- MOT = AIR
- If "ExpTab.11c ATD - Actual Time of Dept:" is not empty, show a solid bar, else no bar
- MOT = LCL or FCL
- If "ExpTab.12c. ATD" not empty show a solid bar; ELSE show no bar
- MOT = Truck-Dom or Truck-Air
same as in Collected (Picked) logic
- MOT = Truck-Ocn
same as in Collected (Picked) logic
- All MOT:
- IF "Dept" bar exists but conditions for "Collected" is not satisfied THEN show bar before that anyway so that bar is not broken
- This could happen when non jaguar company collects shipment. in this case jag opers do not enter Coll date
[edit] Arr logic
- AIR
- If "ExpTab.14c. ATA - Actual Time of Arrival:" is not empty, show a solid bar; else no bar
- MOT = LCL or FCL
IF "ExpTab.14c. ATA:" is not empty THEN show a solid bar ELSE no bar
- MOT = Trucking Air or Trucking Domestic
If "Y.Actual Delivery" is not empty THEN show a solid bar ELSE no bar
- MOT = Truck-ocean
same logic as for Deliv Logic for MOT = FCL
[edit] Deliv Logic
- AIR
- If "ImpTab.Act Deliver Date" is not empty, show a solid bar; else no bar
- MOT = LCL
IF "ImpTab.11. Actual Delivery Date" not empty THEN show solid bar ELSE show no bar
- MOT = FCL
IF "ContTab.Actual Delivery date" is not empty FOR ALL containers THEN show a solid bar ELSE IF "ContTab.Actual Delivery date" is not empty FOR AT LEAST ONE container THEN show a shaded(or broken) bar ELSE show no bar
- MOT = Trucking Air or Trucking Domestic
same logic as for Arrived Logic for MOT = Trucking Air or Trucking Domestic
- MOT = Truck-ocean
same logic as for Deliv Logic for MOT = FCL
[edit] CC Logic
- MOT = AIR or Ocean FCL or LCL
IF "ImpTab.Custom status" == (Custom Status) AND "ImpTab.Custom Status Date" are both not empty THEN show a filled circle color by status; else no color (blank circle)
- MOT = Truck modes
always show always unchecked
- CC status
ONLY green color has checked mark symbol
[edit] History
[edit] m1342
- Make an empty bar for the status of progressing bar that is empty and occurred before the other bars(partial/solid bar)
- See #Auth logic
- Spec is updated: Y
- see attached image on Mantis 1342