Where Is Report

From UG

Contents 1 Info 2 BR: Business Requirements 3 SD: Systems Design 4 Tweaks (v1.1) 4.1 Note About Containers 4.2 Note about Archived CTs 5 Dev 6 History 6.1 m2045 6.1.1 BA 6.1.2 SA 6.2 m1875 6.2.1 BA 6.2.2 SA 6.3 m2068 6.3.1 BA

Info

1587

BR: Business Requirements

• Need to add text box for Steamship Lines Booking #
• For Container #, need option to search the last digit by typing * instead of typing any number between 0-9

SD: Systems Design

ss1 results in HTML

• see http://mantis.jaguarfreight.com/svn/ct2/SS/reports/where_is/v2/HTML_format_example.html

ss2 results in spreadsheet:

• see http://mantis.jaguarfreight.com/svn/ct2/SS/reports/where_is/v2/spreadsheet_format_example.html

NOTE: There is a similar report for Client App, see here: Client Where Is

Tweaks (v1.1)

tw1) HTML paging

tw2) Master Airway Bills and container# fields, when user enters number in, it should be tab over automatically for each box. For example, 111-1111-1111 user must be able to enter 11 digits without jump it to each box manually. There are 3 boxes with 3 digits, 4 digits, and 4 digits with automatically tab over when user are typing.

• --Alex 17:06, 31 July 2009 (UTC) new: see Master Airway Bill field

tw3) Logic for the Master Airway right now is not correct.

• If Master Airway Bills field is not empty, show records that are filtered by AIR only. The records for different MOT must not be showing in this case.
• If Container #s: field is not empty, show records that are filtered by Ocean only. The records for different MOT must not be showing in this case.

tw4) Logic for Container #s: and Master Airway Bills, it must be allowed user to choose one at the time. One field must be read only (grey out) when the other field is active.

tw5) When user does not set any filter(s) and click "Generate results", it does not search anything and it must also notify user somehow as 2 options below:

• show an error message somewhere.
• or "Generate result" button must be in a non-active mode or a grey out button.

tw6) On the result page, Deliv Date and Comment columns should be merged and should not be showing both at the same time. See options below:

• grey out one column when the other one is active.
  • If Deliv Date column is showed, Comment column must be greyed out or n/a.
  • If Comment column is showed, Deliv Date column must be greyed out or n/a.

• OR merge both columns to one column
  • show an active column only. For example, when Deliv Date field is active, there is no Comment column or vise versa.

Note: tw1-tw6 -- Tira 05:20 PM 27 July 2009 (UTC)

tw7) --Alex 18:41, 31 July 2009 (UTC) need Jag logo on xls version of report (top right)

tw8) --Alex 18:41, 31 July 2009 (UTC) CBM - need 2 decimals not 3

tw9) Must have logic to control all the dates (high priority) For example:

• Departure Date field logic : from date MUST not be after to date. (chronologically) -- Tira 4:09 PM 4 Aug 2009 (UTC)
• Arrival Date field logic : from date MUST not be after to date. -- --Tira 11:20 PM 4 Aug 2009 (UTC)

Note: tw10) --Tira 2:35 PM 6 Sep 2009 (UTC)

tw10) Where Is Report, Need to have a binoculars in front of the detail record that is searched for.

For Example,

Cybertrax> Where Is> set filter(s)> Generate result.

User can set any filters; In this case I set filter for SKU contain 1111, then click generate result. Then lists of CT# result is generated. Then I want to see CT# 33 detail, I clicks CT# 33 link. Then I view CT#33, I am supposed to see a binocular in front of P.O 123 (because this P.O contains SKU 1111)

Note: tw11)and tw12) --Tira 5:30 PM 2 Oct 2009 (UTC)

tw11) Add a column for binocular(s) itself/themselves in front of P.O column

tw12) Change the binocular color to Orange to be more outstanding (please ask Slava to design it)

Note About Containers

• see Containers_and_Contents_Component#FCL_.2F_LCL_vs_Ocean-Truck

Note about Archived CTs

They are not included into this Report

Dev

Old specs: http://mantis.jaguarfreight.com/svn/ct2/SS/reports/where_is/v2/

History

m2045

2045

BA

• Need to add text box for the Steamship Lines Booking # which is found on the export tab under field # 6
• current revision

SA

• Add a filter: Steamship Lines Booking #

Steamship Lines Booking #

• Label: Steamship Lines Booking # contains:
• Widget: textbox , can be multiple selected
• Location: After Master Airway Bills:
• This field can be found on the ocean > export tab under field # 6

NOTE: this field is applied to Ocean shipments ONLY

m1875

1875

BA

• We need the option to search the last digit of the container # by typing * instead of typing any number between 0-9
  • See Example on how to search by using * symbol

• See Results from the search by using the * symbol

SA

• Add logic for * symbol in order to search the all digit from 0-9 possibilities
• current revision

m2068

2068

BA

• Need the where is report search feature to ignore upper/lower case letters