Ops Etc
From UG
(Replaced content with 'Category:Ops == Delivery Comment Check Box == * mantis: 984: [Ops.Common.EnterDeliveryCommentCheckBox] === Air ===') |
(→Solution) |
||
(49 intermediate revisions not shown) | |||
Line 1: | Line 1: | ||
- | [[Category: | + | [[Category:OpsMisc]] |
- | == Delivery Comment Check Box == | + | == SOW 0 == |
+ | === Delivery Comment Check Box === | ||
+ | see [[#SOW 0 ]] | ||
+ | |||
+ | === Delivery Comment Check Box Rel 1.0 === | ||
* mantis: 984: [Ops.Common.EnterDeliveryCommentCheckBox] | * mantis: 984: [Ops.Common.EnterDeliveryCommentCheckBox] | ||
- | === Air === | + | ==== General ==== |
+ | |||
+ | |||
+ | * 1. add label "Enter Delivery Comment" + check box; default=unchecked | ||
+ | * 2. add above “DeliveryComment” | ||
+ | * 3. If unchecked then hide “DeliveryComment” label + textbox | ||
+ | |||
+ | ==== Air ==== | ||
+ | |||
+ | |||
+ | * On change from uncheck TO check: | ||
+ | ** show “DeliveryComment” label + textbox | ||
+ | ** copy ExpTab.14c.Airport Of Destination.ATA(rrival) value into ImpTab.ActualDeliveryDate | ||
+ | |||
+ | * On change from check TO uncheck: | ||
+ | ** hide “DeliveryComment” label + textbox | ||
+ | ** clear ImpTab.ActualDeliveryDate | ||
+ | ** clear “DeliveryComment” textbox | ||
+ | |||
+ | ==== LCL ==== | ||
+ | |||
+ | * On change from uncheck TO check: | ||
+ | ** show “DeliveryComment” label + textbox | ||
+ | ** copy ExpTab.15c.Destination Terminal.ATA value into ImpTab.ActualDeliveryDate | ||
+ | |||
+ | * On change from check TO uncheck: | ||
+ | ** hide “DeliveryComment” label + textbox | ||
+ | ** clear ImpTab.ActualDeliveryDate | ||
+ | ** clear “DeliveryComment” textbox | ||
+ | |||
+ | ==== FCL ==== | ||
+ | |||
+ | * On change from uncheck TO check: | ||
+ | ** show “DeliveryComment” label + textbox | ||
+ | ** copy ExpTab.15c.Destination Terminal.ATA value into ComTable.ContainerTable.ActualDeliveryDateDATEBOX (for EVERY container) | ||
+ | |||
+ | * On change from check TO uncheck: | ||
+ | ** hide “DeliveryComment” label + textbox | ||
+ | ** clear ComTable.ContainerTable.ActualDeliveryDateDATEBOX (for EVERY container) | ||
+ | ** clear “DeliveryComment” textbox // added june 12 | ||
+ | |||
+ | ==== Delivery Comment Check Box Rel 1.1 ==== | ||
+ | |||
+ | * FCL logic update: apply logic not for '''EVERY container''' but for ''' EVERY container with Cont. assigned?=true''' | ||
+ | * note: "Cont. assigned?" is a column in CT.ContainersTable | ||
+ | |||
+ | http://mantis.jaguarfreight.com/mantis/view.php?id=1326 | ||
+ | |||
+ | ==== Delivery Comment Check Box Rel 1.2 Prevent copying nothing into Actual Delivery Date ==== | ||
+ | |||
+ | * On change from unchecked TO checked first: | ||
+ | ** see if "actual Arrival date" is not empty. If empty then do not allow to enter Delivery comment/copy dates. Give error pop-up: "Can not add delivery comment - actual arrival date is empty" | ||
+ | ** see if "Actual Delivery Date" is not empty. If not empty then give Warning: "Actual Delivery Date is not empty. Are you sure you want to copy Arrival Date into Delivery Date? Y/N " | ||
+ | |||
+ | * see specific what arrival dates to use (depending on MOT) here http://mantis.jaguarfreight.com/wiki/Ops_Misc#Delivery_Comment_Check_Box_Rel_1.0 | ||
+ | |||
+ | see http://mantis.jaguarfreight.com/mantis/view.php?id=1409 | ||
+ | |||
+ | ==== Delivery Comment Check Box Rel 1.3 Two more validation rules ==== | ||
+ | * Block users from clearing "ImpTab.Actual Delivery Date" if "Delivery Comment checkbox" is checked | ||
+ | * Block users from saving CT if "Delivery Comment textbox" is empty AND "Delivery Comment checkbox" is checked | ||
+ | |||
+ | ==== Delivery Comment Check Box RFC ==== | ||
+ | |||
+ | *1 // For AIR, OCN. | ||
+ | |||
+ | ImpTab. Delivery Comment logic must be updated to block users from saving Delivery comment if Delivered date remains empty at the moment of Save. Reason: it creates inconsistent state - CT will be on Live CT with delivery comment set. (This happens when arrival dates are empty and systems "copy nothing" to deliv date - see http://mantis.jaguarfreight.com/wiki/Ops_Misc#Delivery_Comment_Check_Box_Rel_1.2 above. | ||
+ | |||
+ | *2 // It is possible to clear "ImpTab.Actual Delivery Date" with "c" now. At the same time "Delivery Comment" will remain set. CT would be on Live Tab. | ||
+ | |||
+ | Possible solutions: a) Block users from clearing "ImpTab.Actual Delivery Date" if "Delivery Comment" is set; b) see #4 below | ||
+ | |||
+ | *3 // It is possible now to set "Enter Delivery Comment" checkbox and Save. At the same time "Delivery Comment" would be empty. Is this confusing? | ||
+ | |||
+ | *4 // As we can see delivery comment logic design is complex with a lot of possible cases and sub cases. Maybe we need to take radical approach and simplify "Delivery Comment" logic all together (for example have it as in CT1 without any dates propagation, check box states, etc.) Dates could be set by operator. In CT1 there are only two cases (as far as I understand): | ||
+ | ** IF Deliv Comment Textbox is not empty THEN ignore Actual Deliv Dates values and moved CT to "Delivered State" | ||
+ | ** ELSE IF Deliv Comment Textbox is empty THEN "Delivered/Live State" will be defined by Actual Deliv Date(s) | ||
+ | |||
+ | One question with this simplified design is: somebody must still set Actual Deliv Dates for CT to switch on "Archived state" at some point | ||
+ | |||
+ | == SOW 1 == | ||
+ | |||
+ | '''Mantis:''' [http://ct.jaguarfreight.com/mantis/view.php?id=2842 2842]: (CT2 Misc) CT2 Date/Time Zones issues | ||
+ | |||
+ | === Core requirements === | ||
+ | |||
+ | * Add to CT2 ability to ''differentiate'' time zones for the various Jaguar offices (HK, NY, London & Paris) based on user log-in and ''display'' time stamps accordingly. | ||
+ | |||
+ | === Glossary === | ||
+ | |||
+ | * '''Time Zone''' - is a region on Earth that has a uniform standard time for legal, commercial, and social purposes[http://en.wikipedia.org/wiki/Time_zone].<br>Standard time zones could be defined by geometrically subdividing the Earth's spheroid into 24 lunes. | ||
+ | * '''UTC''' (Coordinated Universal Time) is the primary time standard by which the world regulates clocks and time.<br>UTC is commonly referred to as '''GMT''' (Greenwich Mean Time) and this is what we use in CT2. | ||
+ | * '''DST''' (Daylight Saving Time, ''also summer time in several countries)'' - is a way of making better use of the daylight by setting the clocks forward '''one hour''' during the long days of summer, and back again in the fall. | ||
+ | |||
+ | === Solution === | ||
+ | |||
+ | * '''Admin part''' | ||
+ | System should provide an ability to select which time to display: | ||
+ | :* JFS server time: EST Time Zone (GMT - 5 hours)''. | ||
+ | :* Office local time: | ||
+ | ::* NEW YORK. | ||
+ | :::* Time Zone offset: GMT - 5 hours. | ||
+ | :::* Time Zone abbreviation: EST (Eastern Standard Time). | ||
+ | :::* DST: is used. | ||
+ | ::::* When DST become active then clocks are turned to UTC - 4h. Time Zone is EDT (Eastern Daylight Time). | ||
+ | ::::* ''2012: Daylight Saving Time started on Sunday, March 11 and ends on Sunday, November 4''. | ||
+ | ::* LONDON. | ||
+ | :::* Time Zone offset: GMT + 0 hours. | ||
+ | :::* Time Zone abbreviation: GMT (Greenwich Mean Time). | ||
+ | :::* DST is used: | ||
+ | ::::* When DST become active then clocks are turned to UTC + 1h. Time Zone is BST (British Summer Time). | ||
+ | ::::* ''2012: Daylight Saving Time starts on Sunday, March 25 and ends on Sunday, October 28''. | ||
+ | ::* PARIS, BRUSSELS: GMT + 1 hour. | ||
+ | :::* Time Zone offset: GMT + 1 hours. | ||
+ | :::* Time Zone abbreviation: CET (Central European Time). | ||
+ | :::* DST is used: | ||
+ | ::::* When DST become active then clocks are turned to UTC + 2h. Time Zone is CEST (Central European Summer Time). | ||
+ | ::::* ''2012: Daylight Saving Time starts on Sunday, March 25 and ends on Sunday, October 28''. | ||
+ | ::* HONG KONG. | ||
+ | :::* Time Zone offset: GMT + 8 hours | ||
+ | :::* Time Zone abbreviation: HKT (Hong Kong Time). | ||
+ | :::* DST: is not used. | ||
+ | |||
+ | * '''Time Zone stamp (working examples)''' | ||
+ | :* Application (Internal and Client). | ||
+ | ::* Right top corner of screen: ''Friday, 16 March 2012, CET''. | ||
+ | ::* Shipment editor: ''09:27 EDT Mar-16-2012'' (i.e. CommTab of CT). | ||
+ | ::* Exchange Rates History: ''05-Jan-2012 05:45 AM''. | ||
+ | ::* Purchase Invoice Date: datebox with timestamp ''11:46 AM''. | ||
+ | :* Reports. | ||
+ | ::* Saved/Scheduled Reports. "Date, Time Modified" column: ''12-Mar-2012 12:04 PM''. | ||
+ | ::* Header of downloaded spreadsheets: ''16-March-2012 09:17 AM EDT''. | ||
+ | ::* Upon using dateboxes as report filters we should take into account time difference between local office time zone and JFS server time zone. | ||
+ | :* System Log. | ||
+ | ::* Time column: ''Mar-16-2012 00:00''. | ||
+ | |||
+ | NOTE: would be good to select (or define) and use an ONE standard appearance of Time Zone stamp for all places in CT2. | ||
+ | |||
+ | == SOW 2 == | ||
+ | TBD |
Current revision as of 14:16, 16 March 2012
Contents |
[edit] SOW 0
[edit] Delivery Comment Check Box
see #SOW 0
[edit] Delivery Comment Check Box Rel 1.0
- mantis: 984: [Ops.Common.EnterDeliveryCommentCheckBox]
[edit] General
- 1. add label "Enter Delivery Comment" + check box; default=unchecked
- 2. add above “DeliveryComment”
- 3. If unchecked then hide “DeliveryComment” label + textbox
[edit] Air
- On change from uncheck TO check:
- show “DeliveryComment” label + textbox
- copy ExpTab.14c.Airport Of Destination.ATA(rrival) value into ImpTab.ActualDeliveryDate
- On change from check TO uncheck:
- hide “DeliveryComment” label + textbox
- clear ImpTab.ActualDeliveryDate
- clear “DeliveryComment” textbox
[edit] LCL
- On change from uncheck TO check:
- show “DeliveryComment” label + textbox
- copy ExpTab.15c.Destination Terminal.ATA value into ImpTab.ActualDeliveryDate
- On change from check TO uncheck:
- hide “DeliveryComment” label + textbox
- clear ImpTab.ActualDeliveryDate
- clear “DeliveryComment” textbox
[edit] FCL
- On change from uncheck TO check:
- show “DeliveryComment” label + textbox
- copy ExpTab.15c.Destination Terminal.ATA value into ComTable.ContainerTable.ActualDeliveryDateDATEBOX (for EVERY container)
- On change from check TO uncheck:
- hide “DeliveryComment” label + textbox
- clear ComTable.ContainerTable.ActualDeliveryDateDATEBOX (for EVERY container)
- clear “DeliveryComment” textbox // added june 12
[edit] Delivery Comment Check Box Rel 1.1
- FCL logic update: apply logic not for EVERY container but for EVERY container with Cont. assigned?=true
- note: "Cont. assigned?" is a column in CT.ContainersTable
http://mantis.jaguarfreight.com/mantis/view.php?id=1326
[edit] Delivery Comment Check Box Rel 1.2 Prevent copying nothing into Actual Delivery Date
- On change from unchecked TO checked first:
- see if "actual Arrival date" is not empty. If empty then do not allow to enter Delivery comment/copy dates. Give error pop-up: "Can not add delivery comment - actual arrival date is empty"
- see if "Actual Delivery Date" is not empty. If not empty then give Warning: "Actual Delivery Date is not empty. Are you sure you want to copy Arrival Date into Delivery Date? Y/N "
- see specific what arrival dates to use (depending on MOT) here http://mantis.jaguarfreight.com/wiki/Ops_Misc#Delivery_Comment_Check_Box_Rel_1.0
see http://mantis.jaguarfreight.com/mantis/view.php?id=1409
[edit] Delivery Comment Check Box Rel 1.3 Two more validation rules
- Block users from clearing "ImpTab.Actual Delivery Date" if "Delivery Comment checkbox" is checked
- Block users from saving CT if "Delivery Comment textbox" is empty AND "Delivery Comment checkbox" is checked
[edit] Delivery Comment Check Box RFC
- 1 // For AIR, OCN.
ImpTab. Delivery Comment logic must be updated to block users from saving Delivery comment if Delivered date remains empty at the moment of Save. Reason: it creates inconsistent state - CT will be on Live CT with delivery comment set. (This happens when arrival dates are empty and systems "copy nothing" to deliv date - see http://mantis.jaguarfreight.com/wiki/Ops_Misc#Delivery_Comment_Check_Box_Rel_1.2 above.
- 2 // It is possible to clear "ImpTab.Actual Delivery Date" with "c" now. At the same time "Delivery Comment" will remain set. CT would be on Live Tab.
Possible solutions: a) Block users from clearing "ImpTab.Actual Delivery Date" if "Delivery Comment" is set; b) see #4 below
- 3 // It is possible now to set "Enter Delivery Comment" checkbox and Save. At the same time "Delivery Comment" would be empty. Is this confusing?
- 4 // As we can see delivery comment logic design is complex with a lot of possible cases and sub cases. Maybe we need to take radical approach and simplify "Delivery Comment" logic all together (for example have it as in CT1 without any dates propagation, check box states, etc.) Dates could be set by operator. In CT1 there are only two cases (as far as I understand):
- IF Deliv Comment Textbox is not empty THEN ignore Actual Deliv Dates values and moved CT to "Delivered State"
- ELSE IF Deliv Comment Textbox is empty THEN "Delivered/Live State" will be defined by Actual Deliv Date(s)
One question with this simplified design is: somebody must still set Actual Deliv Dates for CT to switch on "Archived state" at some point
[edit] SOW 1
Mantis: 2842: (CT2 Misc) CT2 Date/Time Zones issues
[edit] Core requirements
- Add to CT2 ability to differentiate time zones for the various Jaguar offices (HK, NY, London & Paris) based on user log-in and display time stamps accordingly.
[edit] Glossary
- Time Zone - is a region on Earth that has a uniform standard time for legal, commercial, and social purposes[1].
Standard time zones could be defined by geometrically subdividing the Earth's spheroid into 24 lunes. - UTC (Coordinated Universal Time) is the primary time standard by which the world regulates clocks and time.
UTC is commonly referred to as GMT (Greenwich Mean Time) and this is what we use in CT2. - DST (Daylight Saving Time, also summer time in several countries) - is a way of making better use of the daylight by setting the clocks forward one hour during the long days of summer, and back again in the fall.
[edit] Solution
- Admin part
System should provide an ability to select which time to display:
- JFS server time: EST Time Zone (GMT - 5 hours).
- Office local time:
- NEW YORK.
- Time Zone offset: GMT - 5 hours.
- Time Zone abbreviation: EST (Eastern Standard Time).
- DST: is used.
- When DST become active then clocks are turned to UTC - 4h. Time Zone is EDT (Eastern Daylight Time).
- 2012: Daylight Saving Time started on Sunday, March 11 and ends on Sunday, November 4.
- LONDON.
- Time Zone offset: GMT + 0 hours.
- Time Zone abbreviation: GMT (Greenwich Mean Time).
- DST is used:
- When DST become active then clocks are turned to UTC + 1h. Time Zone is BST (British Summer Time).
- 2012: Daylight Saving Time starts on Sunday, March 25 and ends on Sunday, October 28.
- PARIS, BRUSSELS: GMT + 1 hour.
- Time Zone offset: GMT + 1 hours.
- Time Zone abbreviation: CET (Central European Time).
- DST is used:
- When DST become active then clocks are turned to UTC + 2h. Time Zone is CEST (Central European Summer Time).
- 2012: Daylight Saving Time starts on Sunday, March 25 and ends on Sunday, October 28.
- HONG KONG.
- Time Zone offset: GMT + 8 hours
- Time Zone abbreviation: HKT (Hong Kong Time).
- DST: is not used.
- Time Zone stamp (working examples)
- Application (Internal and Client).
- Right top corner of screen: Friday, 16 March 2012, CET.
- Shipment editor: 09:27 EDT Mar-16-2012 (i.e. CommTab of CT).
- Exchange Rates History: 05-Jan-2012 05:45 AM.
- Purchase Invoice Date: datebox with timestamp 11:46 AM.
- Reports.
- Saved/Scheduled Reports. "Date, Time Modified" column: 12-Mar-2012 12:04 PM.
- Header of downloaded spreadsheets: 16-March-2012 09:17 AM EDT.
- Upon using dateboxes as report filters we should take into account time difference between local office time zone and JFS server time zone.
- System Log.
- Time column: Mar-16-2012 00:00.
NOTE: would be good to select (or define) and use an ONE standard appearance of Time Zone stamp for all places in CT2.
[edit] SOW 2
TBD