Shipment Progress condition

From UG

Revision as of 19:36, 30 October 2009

Intro

new Read Shipment Milestones and Phases to get some background info. --Alex 19:46, 9 August 2009 (UTC)

Auth logic

• MOT = any
  • If "GenTab.19.Authorized on" field is not empty, show a solid bar else show no 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

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

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

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

Tweaks V.1.1.a

tw1) make an empty bar for the status of progressing bar that is empty and occurred before the other bars(partial/solid bar)

ver 1.2

IF departed bar exists but conditions for collected conditions are not satisfied THEN anyway show bar for "departed" so that bar is not broken

This could happen when non jaguar company collects shipment