Constraints On Dates (feature)

From UG

Revision as of 23:40, 12 January 2010 (edit) Alex (Talk | contribs) (→Chronological Order) ← Older edit		Current revision as of 20:15, 23 November 2011 (edit) (undo) Denise (Talk | contribs) (→Requirements)
(23 intermediate revisions not shown)
Line 1:		Line 1:
-	[[Category:Ops]]	+	[[Category:Ops Common]]
Line 11:		Line 11:
	== Requirements ==		== Requirements ==
-	All detailed requirements have been translated into specifications - see below.	+	Original detailed requirements have been translated into specifications - see below [[##Technical_Specification]].
-	== Technical Specification ==	+	Updated detailed requirements which was released to production on 17-Mar-2011, were translated here: [[2413_rfsa]] and [[2413_rfd]]
-	=== Summary ===	+
-	List of constraints on dates:	+	'''These constraints were added to Actual Dates ONLY and were never applicable for Estimated Dates.  Therefore this separate article was created: [[Constraints_on_Estimated_Dates]]'''
-	* [[#Functionality: Order Constraint Based On Chronological Order]]	+	== Technical Specification ==
-	* [[#Functionality: Required Pre-condition Constraint]]	+
-	* [[#Functionality: Actual Date Can Not Be A Future Date Constraint]]	+
		+	=== Summary ===
-	=== User Interface ===	+	Type constraints on dates:
-	There is no UI here except some pop-up messages.	+	*  [[#Chronological Constraint]]
		+	*  [[#Non Empty Prerequisite Constraint]]
		+	*  [[#Contents Constraint]]
		+	*  [[#Actual Date Can Not Be A Future Date Constraint]]
-	=== Functionality: Generic functionality ===	+	=== Chronological Constraint ===
-	==== Point in Time When Data is Tested against Constraints ====	+	All dates can be listed in a chronological order. Given date on the list can be equal or be a later date chronologically than any previous date on the list:
-	Ideally this should happen real-time any time date is entered. But because of a glitch in a framework (or lack of our knowledge of workaround) we can only test it "on Save".	+	cc1 <= cc2 <= ...
-	=== Functionality: Order Constraint Based On Chronological Order ===	+	If order is incorrect then system must present pop-up:
-		+
-		+
-	"On save" check the following order. See [[#Chronological Order]].	+
-		+
-	no1 <= no2 <= no3 <= ...	+
-		+
-	If order is incorrect the show pop-up:	+
	''In CT#XXX, date <date name> can not be <earlier/later> than date <date name>" [OK].''		''In CT#XXX, date <date name> can not be <earlier/later> than date <date name>" [OK].''
-	==== Chronological Order ====	+	See per MOT lists below.
-	'''AIR:'''	+	====  Chronological Constraint: AIR CT ====
	<pre>		<pre>
		+	[cc1] [I] [----------------] (Act) Created on Date
		+	[cc2] [I] [----------------] (Act) Notification Date
		+	[cc3] [I] [----------------] (Act) Authorized on Date
-	[----] [----] [no1] [I] [----------------] (      Act) Created on Date	+	[cc4] [I] [COLLECTION EVENT] (Est / Act) Pick-up date
-	[----] [----] [no2] [I] [----------------] (      Act) Notification Date	+	[cc5] [M] [DEPARTURE EVENT ] (Est / Act) Airport of Departure Date
-	[----] [----] [no3] [I] [----------------] (      Act) Authorized on	+	[cc6] [M] [ARRIVAL EVENT  ] (Est / Act) Airport of Discharge Date
-		+	[cc7] [I] [DELIVERY EVENT  ] (Est / Act) Delivery Date
-	[----] [----] [no4] [I] [COLLECTION EVENT] (Est / Act) Pick-up date	+
-		+
-	[----] [----] [no4] [I] [                ] (Est / Act) Pick-up date	+
-		+
-	[Mne1] [----] [no5] [M] [DEPARTURE EVENT ] (Est / Act) Airport of Departure	+
-		+
-	[----] [----] [no6] [M] [----------------] (Est / Act) Trans-shipment Airport	+
-		+
-	[Mne1] [----] [no7] [M] [ARRIVAL EVENT  ] (Est / Act) Airport of Discharge	+
-		+
-	[----] [----] [no8] [I] [----------------] (      Act) Customs Status Date	+
-	[----] [----] [no9] [I] [----------------] (      Act) FDA Status Date	+
-		+
-	[----] [----] [no10][I] [DELIVERY EVENT  ] (Est / Act) Delivery Date	+
-		+
	</pre>		</pre>
-	'''FCL:'''	+	==== Chronological Constraint: AIR Master ====
	<pre>		<pre>
-		+	[cc1] [M] [DEPARTURE EVENT ] (Act) Airport of Departure Date
-	[no1] [I] [----------------] (      Act) Created on Date	+	[cc2] [M] [ARRIVAL EVENT  ] (Act) Airport of Discharge Date
-	[no2] [I] [----------------] (      Act) Notification Date	+
-	[no3] [I] [----------------] (      Act) Authorized on	+
-		+
-	[no4] [I] [COLLECTION EVENT] (Est / Act) Pick-up date, Container 1	+
-	[no4] [I] [COLLECTION EVENT] (Est / Act) Pick-up date, Container 2 (FCL only)	+
-	...	+
-	[no4] [I] [COLLECTION EVENT] (Est / Act) Pick-up date, Container N (FCL only)	+
-		+
-	[no5] [I] [DEPARTURE EVENT ] (Est / Act) Origin Terminal	+
-	[no6] [M] [--------------- ] (Est / Act) Port Of Loading	+
-	[no7] [M] [----------------] (Est / Act) Port Of Trans-shipment	+
-	[no8] [M] [----------------] (Est / Act) Port Of Discharge	+
-	[no9] [I] [ARRIVAL EVENT  ] (Est / Act) Destination Terminal	+
-		+
-	[---] [I] [----------------] (      Act) Customs Status Date	+
-	[---] [I] [----------------] (      Act) FDA Status Date	+
-		+
-	[no10] [I] [DELIVERY EVENT  ] (Est / Act) Delivery Date, Container 1	+
-	[no10] [I] [DELIVERY EVENT  ] (Est / Act) Delivery Date, Container 2 (FCL only)	+
-	...	+
-	[no10] [I] [DELIVERY EVENT  ] (Est / Act) Delivery Date, Container N (FCL only)	+
-		+
	</pre>		</pre>
-	'''LCL:'''	+	==== Chronological Constraint: OCEAN CT ====
	<pre>		<pre>
-	[no1] [I] [----------------] (      Act) Created on Date	+	[cc1] [I] [----------------] (      Act) Created on Date
-	[no2] [I] [----------------] (      Act) Notification Date	+	[cc2] [I] [----------------] (      Act) Notification Date
-	[no3] [I] [----------------] (      Act) Authorized on	+	[cc3] [I] [----------------] (      Act) Authorized on
-	[no4] [I] [COLLECTION EVENT] (Est / Act) Pick-up date	+	[cc4] [I] [COLLECTION EVENT] (Est / Act) Pick-up date (for FCL, see Note)
-	[no5] [I] [DEPARTURE EVENT ] (Est / Act) Origin Terminal	+	[cc5] [I] [DEPARTURE EVENT ] (Est / Act) Origin Terminal
-	[no6] [M] [--------------- ] (Est / Act) Port Of Loading	+	[cc6] [M] [--------------- ] (Est / Act) Port Of Loading
-	[no7] [M] [----------------] (Est / Act) Port Of Trans-shipment	+	[cc7] [M] [----------------] (Est / Act) Port Of Discharge
-	[no8] [M] [----------------] (Est / Act) Port Of Discharge	+	[cc8] [I] [ARRIVAL EVENT  ] (Est / Act) Destination Terminal
-	[no9] [I] [ARRIVAL EVENT  ] (Est / Act) Destination Terminal	+
-	[---] [I] [----------------] (      Act) Customs Status Date	+	[cc9] [I] [DELIVERY EVENT  ] (Est / Act) Delivery Date (for FCL, see Note)
-	[---] [I] [----------------] (      Act) FDA Status Date	+
-		+
-	[no10] [I] [DELIVERY EVENT  ] (Est / Act) Delivery Date	+
	</pre>		</pre>
-	'''TRUCK-AIR:'''
-	<pre>	+	==== Chronological Constraint: OCEAN Master ====
-		+
-	[no1] [I] [----------------] (      Act) Created on Date	+
-	[no2] [I] [----------------] (      Act) Notification Date	+
-	[no3] [I] [----------------] (      Act) Authorized on	+
-		+
-	[no4] [I] [COLLECTION EVENT?] (Est / Act) Pick-up date	+
-		+
-	[no5][I] [DELIVERY EVENT?  ] (Est / Act) Delivery Date	+
-		+
-	</pre>	+
-		+
-	'''TRUCK-DOM:'''	+
	<pre>		<pre>
-		+	[cc1] [I] [DEPARTURE EVENT ] (Est / Act) Origin Terminal
-	[no1] [I] [----------------] (     Act) Created on Date	+	[cc2] [M] [--------------- ] (Est / Act) Port Of Loading
-	[no2] [I] [----------------] (     Act) Notification Date	+	[cc3] [M] [----------------] (Est / Act) Port Of Discharge
-	[no3] [I] [----------------] (      Act) Authorized on	+	[cc4] [I] [ARRIVAL EVENT   ] (Est / Act) Destination Terminal
-		+
-	[no4] [I] [COLLECTION EVENT?] (Est / Act) Pick-up date	+
-		+
-	[no5][I] [DELIVERY EVENT?  ] (Est / Act) Delivery Date	+
-		+
	</pre>		</pre>
		+	TBD: what to do with container dates for Master???
-	'''TRUCK-OCN:'''	+	==== Chronological Constraint: TRUCK-OCEAN, TRUCK-DOM, TRUCK-AIR CT ====
	<pre>		<pre>
-	[no1] [I] [----------------] (      Act) Created on Date	+	[cc1] [I] [----------------] (      Act) Created on Date
-	[no2] [I] [----------------] (      Act) Notification Date	+	[cc2] [I] [----------------] (      Act) Notification Date
-	[no3] [I] [----------------] (      Act) Authorized on	+	[cc3] [I] [----------------] (      Act) Authorized on
-		+
-	[no4] [I] [COLLECTION EVENT] (Est / Act) Pick-up date, Container 1	+
-	[no4] [I] [COLLECTION EVENT] (Est / Act) Pick-up date, Container 2 (FCL only)	+
-	...	+
-	[no4] [I] [COLLECTION EVENT] (Est / Act) Pick-up date, Container N (FCL only)	+
-	[no5] [I] [DELIVERY EVENT  ] (Est / Act) Delivery Date, Container 1	+	[cc4] [I] [COLLECTION/DEPARTURE EVENT](Est / Act) Pick-up date (for FCL, see Note)
-	[no5] [I] [DELIVERY EVENT ] (Est / Act) Delivery Date, Container 2 (FCL only)	+	[cc5] [I] [ARRIVAL/DELIVERY EVENT   ](Est / Act) Delivery Date (for FCL, see Note)
-	...	+
-	[no5] [I] [DELIVERY EVENT ] (Est / Act) Delivery Date, Container N (FCL only)	+
	</pre>		</pre>
-	=== Functionality: Required Pre-condition Constraint ===	+	==== Chronological Constraint: TRUCK MASTER ====
-	The following validation must be implemented "on Save":	+	TRUCK MASTER has no dates.
-	==== LCL / FCL ====	+	==== Note About FCL ====
		+	In case of FCL there are multiple Pick-up and Delivery Dates (per container). No order between them is enforced.
-	a) Issue error pop-up if “actual departure date” (Origin Terminal) is entered but there is no  “container number”	+	=== Non Empty Prerequisite Constraint ===
-	(not even one container exists).	+
-	b) Issue error pop-up if “actual arrival date” (Destination Terminal) is entered but there is no “actual departure date” (Origin Terminal).	+	There is a natural sequence of pre-requisites (defined per MOT). Field later in the sequence can not be defined until all earlier fields are defined.
-	c) Issue error pop-up if “delivery date” is entered (FCL:on ANY container) but there is no “actual arrival date” (Destination Terminal) set.	+	field 1 --> field 2 --> ...
-	d) Issue error pop-up if “delivery date” is entered (FCL:on ANY container) but there is at least one line in commodity table unassigned.	+	In case of error system must present pop-up:
-	==== AIR ====	+	''In CT#XXX, field <field name> must be set before field <field name> is set" [OK].''
-	a) Issue error pop-up if “actual departure date” (Airport of Departure) is entered but there is no “Master Air Waybill #”.	+	See per MOT definitions below.
-	b) Issue error pop-up if “actual arrival date” (Airport of Destination) is entered but there is no “actual departure date” (Airport of Departure)
-	c) Issue error pop-up if “delivery date” is entered but there is no “actual arrival date” (Airport of Destination) set.	+	==== Non Empty Prerequisite Constraint: AIR CT ====
-	d) Issue error pop-up if “delivery date” is entered (FCL:on ANY container) but there is at least one line in commodity table unassigned.	+	<pre>
-		+	[field 1] [M] [----------------] Master Airway Bill #
-	==== TRUCK-AIR ====	+	[field 2] [M] [DEPARTURE EVENT ] (Act) Airport of Departure Date
		+	[field 3] [M] [ARRIVAL EVENT  ] (Act) Airport of Discharge Date
		+	[field 4] [I] [DELIVERY EVENT  ] (Act) Delivery Date
-	TBD!!!	+	</pre>
-	==== TRUCK-OCEAN ====	+	==== Non Empty Prerequisite Constraint: OCEAN CT ====
-	TBD!!!	+	<pre>
		+	[field 1] [----------------] At least one container#
		+	[field 2] [I] [DEPARTURE EVENT ] (Est / Act) Origin Terminal
		+	[field 3] [I] [ARRIVAL EVENT  ] (Est / Act) Destination Terminal
		+	[field 4] [I] [DELIVERY EVENT  ] (Est / Act) Delivery Date (FCL: on any container)
		+	</pre>
-	==== TRUCK-DOM ====	+	=== Contents Constraint ===
-	TBD!!!	+	==== Contents Constraint: OCEAN CT and TRUCK OCEAN CT====
-	==== Examples of wording for Error Messages ====	+	All contents must be assigned to containers before "(Act) Delivery Date" is set
-	Ocean:	+	If it is not true then system must present pop-up:
-	“A container number must be entered before the actual departure date can be confirmed”	+	''All contents must be assigned to containers before "(Act) Delivery Date" is set [OK]. ''
-	“The actual departure date must be confirmed before the actual arrival date can be confirmed”	+	===  Actual Date Can Not Be A Future Date Constraint ===
-	“The actual arrival date must be confirmed before the actual delivery date can be confirmed”	+	If user is trying to set any actual dates (see below) to the future date system must issue pop up:
-	Air:	+	''Error while saving: <name of the date> can not be in the future [OK].''
-		+
-	“A MAWB number must be entered before the actual departure date can be confirmed”	+
-		+
-	“The actual departure date must be confirmed before the actual arrival date can be confirmed”	+
-		+
-	“The actual arrival date must be confirmed before the actual delivery date can be confirmed”	+
-		+
-	=== Functionality: Actual Date Can Not Be A Future Date Constraint ===	+
-		+
-	If user is trying to set any actual dates (see below) to the future date system must issue pop up: "Error while saving: <name of the date> can not be in the future [OK]".	+
	===== List of actual dates in the system =====		===== List of actual dates in the system =====
Line 310:		Line 238:
	In this case system must verify all related records and display error that spells out WHAT dates on WHAT records are breaking WHAT constraint.		In this case system must verify all related records and display error that spells out WHAT dates on WHAT records are breaking WHAT constraint.
		+
		+	=== User Interface ===
		+
		+	There is no UI here except some pop-up messages.
		+
		+	=== Point in Time When Data is Tested against Constraints ===
		+
		+	Ideally this should happen real-time any time date is entered. But because of a glitch in a framework (or lack of our knowledge of workaround) we can only test it "on Save".
		+
	=== Figures ===		=== Figures ===
Line 328:		Line 265:
	Good idea? How hard?		Good idea? How hard?
-	3) Functionality: Required Pre-condition Constraint	+	3) Non Empty Prerequisite Constraint:
	Should we add to d) condition "or commodity table is empty"		Should we add to d) condition "or commodity table is empty"
Line 346:		Line 283:
	--[[User:Alex|Alex]] 20:01, 12 January 2010 (UTC)		--[[User:Alex|Alex]] 20:01, 12 January 2010 (UTC)
-	=== 0001324: (Constraints On Dates) Display error that spells out WHAT dates on WHAT records are breaking WHAT constrain ===	+	=== Display error that spells out WHAT dates on WHAT records are breaking WHAT constrain ===
		+
		+	* http://mantis.jaguarfreight.com/mantis/view.php?id=1324
		+
	--[[User:Alex|Alex]] 20:01, 12 January 2010 (UTC)		--[[User:Alex|Alex]] 20:01, 12 January 2010 (UTC)
		+
		+	=== Implement major re-design of this component  ===
		+
		+	* http://mantis.jaguarfreight.com/mantis/view.php?id=1673
		+
		+	--[[User:Alex|Alex]] 18:54, 13 January 2010 (UTC)
	== Known Non Critical Bugs ==		== Known Non Critical Bugs ==

---

Current revision as of 20:15, 23 November 2011

Contents 1 Parent Mantis 2 Business Need 3 Requirements 4 Technical Specification 4.1 Summary 4.2 Chronological Constraint 4.2.1 Chronological Constraint: AIR CT 4.2.2 Chronological Constraint: AIR Master 4.2.3 Chronological Constraint: OCEAN CT 4.2.4 Chronological Constraint: OCEAN Master 4.2.5 Chronological Constraint: TRUCK-OCEAN, TRUCK-DOM, TRUCK-AIR CT 4.2.6 Chronological Constraint: TRUCK MASTER 4.2.7 Note About FCL 4.3 Non Empty Prerequisite Constraint 4.3.1 Non Empty Prerequisite Constraint: AIR CT 4.3.2 Non Empty Prerequisite Constraint: OCEAN CT 4.4 Contents Constraint 4.4.1 Contents Constraint: OCEAN CT and TRUCK OCEAN CT 4.5 Actual Date Can Not Be A Future Date Constraint 4.5.1 List of actual dates in the system 4.6 Special case: CTs under Groups and Masters 4.7 User Interface 4.8 Point in Time When Data is Tested against Constraints 4.9 Figures 4.9.1 Figure: XXX 5 RFC 6 History 6.1 Old spec archived 6.2 Spec created 6.3 Display error that spells out WHAT dates on WHAT records are breaking WHAT constrain 6.4 Implement major re-design of this component 7 Known Non Critical Bugs 8 DB

[edit] Parent Mantis

1670

[edit] Business Need

We have a number of constraints / validation rules that we need to enforce for dates.

[edit] Requirements

Original detailed requirements have been translated into specifications - see below ##Technical_Specification.

Updated detailed requirements which was released to production on 17-Mar-2011, were translated here: 2413_rfsa and 2413_rfd

These constraints were added to Actual Dates ONLY and were never applicable for Estimated Dates. Therefore this separate article was created: Constraints_on_Estimated_Dates

[edit] Technical Specification

[edit] Summary

Type constraints on dates:

• #Chronological Constraint
• #Non Empty Prerequisite Constraint
• #Contents Constraint
• #Actual Date Can Not Be A Future Date Constraint

[edit] Chronological Constraint

All dates can be listed in a chronological order. Given date on the list can be equal or be a later date chronologically than any previous date on the list:

cc1 <= cc2 <= ...

If order is incorrect then system must present pop-up:

In CT#XXX, date <date name> can not be <earlier/later> than date <date name>" [OK].

See per MOT lists below.

[edit] Chronological Constraint: AIR CT

 [cc1] [I] [----------------] (Act) Created on Date
 [cc2] [I] [----------------] (Act) Notification Date
 [cc3] [I] [----------------] (Act) Authorized on Date

 [cc4] [I] [COLLECTION EVENT] (Est / Act) Pick-up date 
 [cc5] [M] [DEPARTURE EVENT ] (Est / Act) Airport of Departure Date
 [cc6] [M] [ARRIVAL EVENT   ] (Est / Act) Airport of Discharge Date
 [cc7] [I] [DELIVERY EVENT  ] (Est / Act) Delivery Date 

[edit] Chronological Constraint: AIR Master

[cc1] [M] [DEPARTURE EVENT ] (Act) Airport of Departure Date
[cc2] [M] [ARRIVAL EVENT   ] (Act) Airport of Discharge Date

[edit] Chronological Constraint: OCEAN CT

[cc1] [I] [----------------] (      Act) Created on Date
[cc2] [I] [----------------] (      Act) Notification Date
[cc3] [I] [----------------] (      Act) Authorized on

[cc4] [I] [COLLECTION EVENT] (Est / Act) Pick-up date (for FCL, see Note)

[cc5] [I] [DEPARTURE EVENT ] (Est / Act) Origin Terminal
[cc6] [M] [--------------- ] (Est / Act) Port Of Loading
[cc7] [M] [----------------] (Est / Act) Port Of Discharge
[cc8] [I] [ARRIVAL EVENT   ] (Est / Act) Destination Terminal

[cc9] [I] [DELIVERY EVENT  ] (Est / Act) Delivery Date (for FCL, see Note)

[edit] Chronological Constraint: OCEAN Master

[cc1] [I] [DEPARTURE EVENT ] (Est / Act) Origin Terminal
[cc2] [M] [--------------- ] (Est / Act) Port Of Loading
[cc3] [M] [----------------] (Est / Act) Port Of Discharge
[cc4] [I] [ARRIVAL EVENT   ] (Est / Act) Destination Terminal

TBD: what to do with container dates for Master???

[edit] Chronological Constraint: TRUCK-OCEAN, TRUCK-DOM, TRUCK-AIR CT

[cc1] [I] [----------------] (      Act) Created on Date
[cc2] [I] [----------------] (      Act) Notification Date
[cc3] [I] [----------------] (      Act) Authorized on

[cc4] [I] [COLLECTION/DEPARTURE EVENT](Est / Act) Pick-up date (for FCL, see Note)
[cc5] [I] [ARRIVAL/DELIVERY EVENT    ](Est / Act) Delivery Date (for FCL, see Note)

[edit] Chronological Constraint: TRUCK MASTER

TRUCK MASTER has no dates.

[edit] Note About FCL

In case of FCL there are multiple Pick-up and Delivery Dates (per container). No order between them is enforced.

[edit] Non Empty Prerequisite Constraint

There is a natural sequence of pre-requisites (defined per MOT). Field later in the sequence can not be defined until all earlier fields are defined.

field 1 --> field 2 --> ...

In case of error system must present pop-up:

In CT#XXX, field <field name> must be set before field <field name> is set" [OK].

See per MOT definitions below.

[edit] Non Empty Prerequisite Constraint: AIR CT

[field 1] [M] [----------------] Master Airway Bill #
[field 2] [M] [DEPARTURE EVENT ] (Act) Airport of Departure Date
[field 3] [M] [ARRIVAL EVENT   ] (Act) Airport of Discharge Date
[field 4] [I] [DELIVERY EVENT  ] (Act) Delivery Date 

[edit] Non Empty Prerequisite Constraint: OCEAN CT

[field 1] [----------------] At least one container#
[field 2] [I] [DEPARTURE EVENT ] (Est / Act) Origin Terminal
[field 3] [I] [ARRIVAL EVENT   ] (Est / Act) Destination Terminal
[field 4] [I] [DELIVERY EVENT  ] (Est / Act) Delivery Date (FCL: on any container)

[edit] Contents Constraint

[edit] Contents Constraint: OCEAN CT and TRUCK OCEAN CT

All contents must be assigned to containers before "(Act) Delivery Date" is set

If it is not true then system must present pop-up:

All contents must be assigned to containers before "(Act) Delivery Date" is set [OK].

[edit] Actual Date Can Not Be A Future Date Constraint

If user is trying to set any actual dates (see below) to the future date system must issue pop up:

Error while saving: <name of the date> can not be in the future [OK].

[edit] List of actual dates in the system

UNDEF:

• Gentab.Actual export pickup

Truck-Dom:

• Gentab.Actual export pickup
• Gentab.Actual Delivery

Truck-Air:

• Gentab.Actual export pickup
• Gentab.Actual Delivery

Truck-Ocn:

• Conttab.Containers.ContainerX.Actual collection
• Conttab.Containers.ContainerX.Actual Delivery

AIR:

Gentab:

• Actual export pickup

Exptab:

• Airport of Departure. ATD
• Trans-shipment Airport.ATD
• Airport Of Destination. ATD

ImpTab:

• Actual Delivery Date

LCL:

Gentab:

• Actual export pickup

Exptab:

• Origin Terminal ATD
• Port Of Loading ATD
• Port Of Trans-shipment ATA
• Port Of Discharge ATA
• Destination Terminal ATA

ImpTab:

• Actual Delivery Date

FCL:

Conttab.Containers:

• ContainerX.Actual collection
• ContainerX.Actual Delivery

Exptab:

• Origin Terminal ATD
• Port Of Loading ATD
• Port Of Trans-shipment ATA
• Port Of Discharge ATA
• Destination Terminal ATA

[edit] Special case: CTs under Groups and Masters

In this case change to one date field can be applied to multiple CTs potentially breaking date constraints on multiple records.

In this case system must verify all related records and display error that spells out WHAT dates on WHAT records are breaking WHAT constraint.

[edit] User Interface

There is no UI here except some pop-up messages.

[edit] Point in Time When Data is Tested against Constraints

Ideally this should happen real-time any time date is entered. But because of a glitch in a framework (or lack of our knowledge of workaround) we can only test it "on Save".

[edit] Figures

[edit] Figure: XXX

[edit] RFC

1) Do you clear invalid values after error pop up is generated?

Yes you should clear these values. Now system does not.

Good idea?

2) Idea: have in Admin option to turn any validation.

Option for what records to turn off.

Good idea? How hard?

3) Non Empty Prerequisite Constraint:

Should we add to d) condition "or commodity table is empty"

4) Should we re-design in terms of "CT consistent/ inconsistent state" because for example if user assign all commodities and then set Actual Deliv date BUT later unassign it gives you "strange message":

"Actual Delivery date can not be assigned - all commodity items must be assigned to containers"

It is better to say like this: "Inconsistent State: Actual Delivery date assigned but at least one commodity item is unassigned."

[edit] History

[edit] Old spec archived

It is CT Dates

[edit] Spec created

--Alex 20:01, 12 January 2010 (UTC)

[edit] Display error that spells out WHAT dates on WHAT records are breaking WHAT constrain

• http://mantis.jaguarfreight.com/mantis/view.php?id=1324

--Alex 20:01, 12 January 2010 (UTC)

[edit] Implement major re-design of this component

• http://mantis.jaguarfreight.com/mantis/view.php?id=1673

--Alex 18:54, 13 January 2010 (UTC)

[edit] Known Non Critical Bugs

bug1) error is not specific to what date in what CT there is a problem

bug2) even if problem with ordering of actual dates system complains about "estimated"

[edit] DB