Shipment Progress condition

From UG

Revision as of 20:43, 29 July 2009 (edit) Alex (Talk | contribs) (→Dept logic) ← Older edit		Current revision as of 21:15, 7 June 2010 (edit) (undo) Montira (Talk | contribs) (→Dept logic)
(34 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)
		+
	== Auth logic ==		== Auth logic ==
	* MOT = any		* MOT = any
-	** If "GenTab.19.Authorized on" field is not empty, show a solid bar else show no bar	+	** If "GenTab.19.Authorized on" field is not empty, show a solid bar else show empty bar
	== Collected (Picked) logic ==		== Collected (Picked) logic ==
Line 10:		Line 15:
	* MOT = FCL		* 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		IF "ContTab.Actual collection date" is not empty FOR ALL containers
	THEN show a solid bar		THEN show a solid bar
Line 25:		Line 44:
-	** Trucking Air - this field is mapped to the "Gen tab #10"	+	* MOT = Truck-Dom or Truck-Air
-	*** If "Gen #10" is not empty, show a solid bar	+	same as in Collected (Picked) logic
-	** Trucking Ocean	+
-	*** If "Y.Actual Delivery" is not empty, show a solid bar	+	* 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 ==		== Arr logic ==
Line 40:		Line 64:
	ELSE no bar		ELSE no bar
		+	* MOT = Trucking Air or Trucking Domestic
-	** Trucking Air, Trucking Domestic, Trucking Ocean	+	If "Y.Actual Delivery" is not empty
-	*** If "Y.Actual Delivery" is not empty, show a solid bar	+	THEN show a solid bar
		+	ELSE no bar
-	== Deliv Logic ==	+	* MOT = Truck-ocean
		+	same logic as for Deliv Logic for MOT = FCL
-	- this field is mapped to "Act Deliver Date, Import tab" for AIR and Ocean	+	== Deliv Logic ==
	* AIR		* AIR
Line 66:		Line 93:
		+	* MOT = Trucking Air or Trucking Domestic
		+	same logic as for Arrived Logic for MOT = Trucking Air or Trucking Domestic
-	** Trucking Air, Trucking Domestic, and Trucking Ocean	+	* MOT = Truck-ocean
-	*** Id "Y.Actual Delivery" is not empty, show a solid bar	+	same logic as for Deliv Logic for MOT = FCL
	== CC Logic ==		== CC Logic ==
	* MOT = AIR or Ocean FCL or LCL		* MOT = AIR or Ocean FCL or LCL
-	** If "ImpTab.Custom status" == released AND "ImpTab.Custom Status Date" are not empty, then show a solid bar; else no bar	+	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		* 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 1 Intro 2 Auth logic 3 Collected (Picked) logic 4 Dept logic 5 Arr logic 6 Deliv Logic 7 CC Logic 8 History 8.1 m1342

[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