Shipment Progress condition

From UG

(Difference between revisions)
Jump to: navigation, search
(→Dept logic)
 
(46 intermediate revisions not shown)
Line 1: Line 1:
-
* Auth logic - this field is mapped to the "19. Authorized on" field n CT2(Internal)-> Gen tab
+
[[Category:Client_Reports]]
-
** If "19.Authorized on" field is not empty, show a solid bar** Collected logic - this field is mapped to the actual picked up date field
+
-
*Collected logic
+
== Intro ==
-
** AIR - this field is mapped to the "General tab, #10"
+
'''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
+
 
-
** FCL - this field is mapped to '''all''' "Actual dates" <span style ="color:#ff0000"> need to ensure the logic with Alex and Simon </span>
+
== Auth logic ==
-
*** If '''all''' actual dates (Exp tab, #11c,#12c, #13c, #14c, and #15c) are not empty, show a solid bar
+
 
-
*** If '''at least 1 actual date''' from (Exp tab, #11c,#12c, #13c, #14c, and #15c) is not empty, show a non-solid bar(shaded bar)
+
* MOT = any
-
* Dept logic
+
** If "GenTab.19.Authorized on" field is not empty, show a solid bar else show empty bar
-
** AIR - this field is mapped to the "Exp tab #11c" or "Origin terminal Actual Date"
+
 
-
*** If "11c Export tab" is not empty, show a solid bar
+
== Collected (Picked) logic ==
-
** LCL - this field is mapped to the "Exp tab #12c" or "Port of load Actual Date"
+
 
-
*** If "12c Export tab" is not empty, show a solid bar
+
* MOT = AIR or LCL or Truck-Air or Truck-Dom or Truck-ocean
-
** FCL - this field is mapped to the "Exp tab #12c" or "Port of load Actual Date"
+
** If "GenTab.10.Actual Export Pickup Date:" is not empty, show a solid bar, else show no bar
-
*** If "12c Export tab" is not empty, show a solid bar
+
 
-
** Trucking Air - this field is mapped to the "Gen tab #10"
+
* MOT = FCL  
-
*** If "Gen #10" is not empty, show a solid bar
+
  IF "ContTab.Actual collection date" is not empty FOR ALL containers
-
** Trucking Ocean
+
  THEN show a solid bar
-
*** If "Y.Actual Delivery" is not empty, show a solid bar
+
ELSE IF "ContTab.Actual collection date" is not empty FOR AT LEAST ONE container
-
* Arr logic
+
  THEN show a shaded(or broken) bar
-
** AIR
+
ELSE show no bar
-
*** If "Exp tab, #14c" is not empty, show a solid bar
+
 
-
** Ocean ?????????
+
* MOT = Truck-Dom or Truck-Air
-
*** If "Exp tab, #15" is not empty, show a solid bar?????
+
 
-
** LCL
+
IF "GenTab.10. Actual Pick-Up Date" is not empty
-
*** If "Exp tabm # 14c" is not empty, show a solid bar
+
  THEN show a solid bar
-
** FCL
+
ELSE show no bar
-
*** If "Exp tabm # 14c" is not empty, show a solid bar
+
 
-
** Trucking Air, Trucking Domestic, Trucking Ocean
+
* MOT = Truck-Ocn
-
*** If "Y.Actual Delivery" is not empty, show a solid bar
+
 
-
* Deliv Logic - this field is mapped to "Act Deliver Date, Import tab" for AIR and Ocean
+
IF "ContTab.Actual collection date" is not empty FOR ALL containers
-
** AIR - If "Act Deliver Date, Import tab" is not empty, show a solid bar
+
  THEN show a solid bar
-
** Ocean, LCL, and FCL - If "Act Deliver Date, Import tab" is not empty, show a solid bar
+
ELSE IF "ContTab.Actual collection date" is not empty FOR AT LEAST ONE container
-
** Trucking Air, Trucking Domestic, and Trucking Ocean
+
  THEN show a shaded(or broken) bar
-
*** Id "Y.Actual Delivery" is not empty, show a solid bar  
+
ELSE show no bar
-
* CC Logic
+
 
-
** AIR and Ocean  
+
== Dept logic ==
-
*** If "Custom status released" and "Custom Status Date" are not empty, show a solid bar
+
 
 +
* 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
Retrieved from "https://wiki.jaguarfreight.com/Shipment_Progress_condition"
Personal tools