Ops Etc

From UG

(Difference between revisions)
Jump to: navigation, search
(Delivery Comment Check Box)
(Solution)
 
(50 intermediate revisions not shown)
Line 1: Line 1:
-
[[Category:Ops]]
+
[[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 ====
-
[setADDforAIR] "Enter Delivery Comment" checkbox field and logic
+
-
 
+
-
  1.
+
-
 
+
-
      added June 2, 2009
+
-
  2.
+
-
 
+
-
      add label "Enter Delivery Comment" + check box; default=unchecked
+
-
  3.
+
-
 
+
-
      add above “DeliveryComment”
+
-
  4.
+
-
 
+
-
      If unchecked then hide “DeliveryComment” label + textbox
+
-
  5.
+
-
 
+
-
      On change from uncheck TO check:
+
-
 
+
-
          o
+
-
 
+
-
            show “DeliveryComment” label + textbox
+
-
          o
+
-
 
+
-
            copy ExpTab.14c.ATA (Airport Of Destination) value into ImpTab.ActualDeliveryDate
+
-
 
+
-
  6.
+
-
 
+
-
      On change from check TO uncheck:
+
-
 
+
-
          o
+
-
 
+
-
            hide “DeliveryComment” label + textbox
+
-
          o
+
-
 
+
-
            clear ImpTab.ActualDeliveryDate
+
-
          o
+
-
            clear “DeliveryComment” textbox // added june 12
 
 +
* 1.      add label "Enter Delivery Comment" + check box; default=unchecked
 +
* 2.      add above “DeliveryComment”
 +
* 3.      If unchecked then hide “DeliveryComment” label + textbox
-
[setADDforLCL*] "Enter Delivery Comment" checkbox field and logic (for MOT = LCL*)
+
==== Air ====
-
  7.
 
-
      added June 2, 2009
+
* On change from uncheck TO check:
-
  8.
+
** show “DeliveryComment” label + textbox
 +
** copy ExpTab.14c.Airport Of Destination.ATA(rrival) value into ImpTab.ActualDeliveryDate
-
      add label "Enter Delivery Comment" + check box; default=unchecked
+
* On change from check TO uncheck:
-
  9.
+
** hide “DeliveryComment” label + textbox
 +
** clear ImpTab.ActualDeliveryDate
 +
** clear “DeliveryComment” textbox
-
      add above “DeliveryComment”
+
==== LCL ====
-
  10.
+
-
      If unchecked then hide “DeliveryComment” label + textbox
+
* On change from uncheck TO check:
-
  11.
+
** show “DeliveryComment” label + textbox
 +
** copy ExpTab.15c.Destination Terminal.ATA value into ImpTab.ActualDeliveryDate
-
      On change from uncheck TO check:
+
* On change from check TO uncheck:
 +
** hide “DeliveryComment” label + textbox
 +
** clear ImpTab.ActualDeliveryDate
 +
** clear “DeliveryComment” textbox
-
          o
+
==== FCL ====
-
            show “DeliveryComment” label + textbox
+
* On change from uncheck TO check:
-
          o
+
** show “DeliveryComment” label + textbox
 +
** copy ExpTab.15c.Destination Terminal.ATA value into ComTable.ContainerTable.ActualDeliveryDateDATEBOX (for EVERY container)
-
            copy ExpTab.15c.ATA value into ImpTab.ActualDeliveryDate
+
* On change from check TO uncheck:
 +
** hide “DeliveryComment” label + textbox
 +
** clear ComTable.ContainerTable.ActualDeliveryDateDATEBOX (for EVERY container)
 +
** clear “DeliveryComment” textbox // added june 12
-
  12.
+
==== Delivery Comment Check Box Rel 1.1 ====
-
      On change from check TO uncheck:
+
* 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
-
          o
+
http://mantis.jaguarfreight.com/mantis/view.php?id=1326
-
            hide “DeliveryComment” label + textbox
+
==== Delivery Comment Check Box Rel 1.2 Prevent copying nothing into Actual Delivery Date ====
-
          o
+
-
            clear ImpTab.ActualDeliveryDate
+
* 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 "
-
          o
+
* 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
-
            clear “DeliveryComment” textbox // added june 12
+
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
-
[setADDforFCL*] "Enter Delivery Comment" checkbox field and logic (for MOT = FCL*)
+
==== Delivery Comment Check Box RFC ====
-
  13.
+
*1 // For AIR, OCN.  
-
      added June 2, 2009
+
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.
-
  14.
+
 +
*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.
-
      add label "Enter Delivery Comment" + check box; default=unchecked
+
Possible solutions: a) Block users from clearing "ImpTab.Actual Delivery Date" if "Delivery Comment" is set; b) see #4 below
-
  15.
+
-
      add above “DeliveryComment” (!bug: Delivery Date Type and DeliveryComment are missing now for FCL!)
+
*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?
-
  16.
+
-
      If unchecked then hide “DeliveryComment” label + textbox
+
*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):
-
  17.
+
** 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)
-
      On change from uncheck TO check:
+
One question with this simplified design is: somebody must still set Actual Deliv Dates for CT to switch on "Archived state" at some point
-
          o
+
== SOW 1 ==
-
            show “DeliveryComment” label + textbox
+
'''Mantis:''' [http://ct.jaguarfreight.com/mantis/view.php?id=2842 2842]: (CT2 Misc) CT2 Date/Time Zones issues
-
          o
+
-
            copy ExpTab.15c.ATA value into ComTable.ContainerTable.ActualDeliveryDateDATEBOX (for EVERY container)
+
=== Core requirements ===
-
  18.
+
* 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.
-
      On change from check TO uncheck:
+
=== Glossary ===
-
          o
+
* '''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.
-
            hide “DeliveryComment” label + textbox
+
=== Solution ===
-
          o
+
-
            clear ComTable.ContainerTable.ActualDeliveryDateDATEBOX (for EVERY container)
+
* '''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.
-
          o
+
* '''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''.
-
            clear “DeliveryComment” textbox // added june 12
+
NOTE: would be good to select (or define) and use an ONE standard appearance of Time Zone stamp for all places in CT2.
-
== QA Plan ==
+
== SOW 2 ==
-
=== Air ===
+
TBD
-
* create Air CT
+
-
* save, verify that CT is listed under Live in List CTs
+
-
* set ExpTab.14c.ATA (Airport Of Destination) value
+
-
* check Enter Delivery Comment. Observe that system:
+
-
** fills Actual Delivery Date with ExpTab.14c.ATA (Airport Of Destination) value
+
-
** makes Delivery Comment visible
+
-
* save, verify that CT is listed under Delivered in List CTs
+

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 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

Personal tools