Client Main Report

From UG

(Difference between revisions)

Revision as of 20:48, 13 May 2010

Dev

Business Requirements

Client Main Report is reusing the code from Internal App Main Report. There are some similarities and differences in term of list of filters, output and design.

It allows client to create a report for his/her company's shipments. This applies client's visibility's rules.

Specs

See Main report specs from Internal App > Main Report at Main Wizard Report
There are 4 different categories for filters:
- General Filters
- Transportation Filters
- Date Filters
- Output
Some filters require Client visibility rule
There is Reset Form button; It allows user to clear all the filters to the fresh beginning stage
There is Generate Result button; system will generate result after user clicks this button
Label of filters' names can be different from Internal Main Report
Each filter has "clr" button in order to clear info for a specific filter
See #Figure 1. Main report

General Filters

All the same as Main report (Internal App) but these filters drop down list MUST be Client specific: Auto populated; it should show only the specific list for client:
- Client Company
- Shipper
- Consignee
- Origin Country
- Destination Country
- Shipping Terms
- Pickup Locations
- Delivery Locations
The rest of filters are not required Client specific: Auto populated
List of filters that are not required, compare to Main Wizard Report on Internal App
- Export Ref # contains:
- Import Ref # contains:
- Jaguar 3rd Ref # contains:
- Remove Cargo Locations
Transport Mode filters in General filters Tab has a logic connecting to Transportation Filters.
- IF client selects ANY OCEAN for transport mode, Transportation Filters tab will provide ONLY lists of ocean filters as below:
  - Container#s
  - Shipping Line
  - Origin Port/Terminal
  - Destination Port/Terminal
  - Vessel Name Contains
- IF client select AIR for transport mode, Transportation Filters tab will provide ONLY lists of air filters as below:
  - Airlines
  - Origin Airport
  - Destination Airport

Transportation Filters

Transportation Filters
- AIR filters will ONLY show when client clicks AIR for Transport Mode in General filter tab
  - These filters drop down list MUST be Client specific: Auto populated; it should show only the specific list for client:
    - Airlines
    - Origin Airport
    - Destination Airport
- OCEAN filters will ONLY show when client clicks ANY OCEAN for Transport Mode in General filter tab
  - These filters drop down list MUST be Client specific: Auto populated; it should show only the specific list for client:
    - Container#s
    - Shipping Line
    - Origin Port/Terminal
    - Destination Port/Terminal
    - Vessel Name Contains
- TRUCK There is no any filters on Transportation filters
See #Figure 2. Transportation Filters for the case of no transport mode is selected or Truck mode(s) is selected from general filters
List of filters that are not required, compare to Main Wizard Report on Internal App
- - Pickup Truckers
  - Delivery Truckers
  - Co-Loader Ocean
  - Co-Loader Air

Date Filters

Order of Filters from the top to the bottom"
- Estimated Pickup Date:
- Actual Pickup Date:
- Estimated Departure Date:
- Actual Departure Date:
- Estimated Arrival Date:
- Actual Arrival Date:
- Estimated Delivery Date:
- Actual Delivery Date:
Date Logics:
- "Delivery Date" cannot be before "Arrival Date", "Departure Date", and "Pickup Date"
- "Arrival Date" cannot be before "Departure Date", and "Pickup Date"
- "Departure Date" cannot be before "Pickup Date"
Must have "clear" button for every date field .
See #Figure 3. Date Filters

Output

Output consists of a long list of headings
Output list is multi-selected
Default: selected output list should be listed on the right box and the rest should be in output dropdown list
User is able to manage the order of the output heading list by moving up and down
User is able to add/remove the output heading list by moving it to the left or right
Label output heading as listed below
- Field // Apply to Mode // Default on the right box
- CT# // All modes // Yes
- Shipper // All modes // Yes
- Consignee // All modes // Yes
- Transport Mode // All modes // Yes
- Departure // All modes // Yes
- Destination // All modes // Yes
- Actual Departure Date // All modes // Yes
  - Mapping: ExpTab 12c
- Actual Arrival Date // All modes // Yes
  - Mapping: ExpTab 14c
- Actual Delivery Date // All modes // Yes
- Commodity Item PO# // All modes // No
- Commodity Item SKU# // All modes // No
- Commodity Item Description // All modes // No
- Commodity Item Quantity // All modes // No
- Commodity Item Total Pallets // All modes // No
- Commodity Item Total Loose Packages // All modes // No
- Commodity Item Gross Weight // All modes // No
- Chargeable Weight // All modes // No
- Departure Region // All modes // No
- Destination Region // All modes // No
- Notification Date // All modes // No
- Authorization Date // All modes // No
- Estimated Departure Date // All modes // No
  - Mapping: ExpTab 12b
- Estimated Arrival Date // All modes // No
  - Mapping: ExpTab 14b
- Estimated Delivery Date // All modes // No
  - Mapping: ContTab for FCL shipment
- Estimated Collection Date // All modes // No
  - Mapping: ContTab for FCL shipment
- Actual Collection Date // All modes // No
  - Mapping: ContTab for FCL shipment
- Vessel name // OCEAN // No
- Flight Number // AIR // No
- HAWB# // AIR // No
- Container Description // OCEAN // No
- Shipping Line // OCEAN // No
- Airline // AIR // No

More information from fields above:

Air

ETS :ExpTab 11b. Airport of Departure:
ATS :ExpTab 11c. ATD - Actual Time of Dept:
ETA :ExpTab 14b. ETA - Est Time of Arrival:
ATA :ExpTab 14c. ATA - Actual Time of Arrival:
Estimate Collection Date: GenTab 9. Estimated Export Pick-Up Date:
Actual Collection Date: GenTab 10. Actual Export Pick-Up Date:
Requested Delivery Date: ImpTab b.Estimated Delivery Date:
Actual Delivery Date: ImpTab b.Actual Delivery Date:

Ocean

ETS :ExpTab 12b. ETD:
ATS :ExpTab 12c. ATD:
ETA :ExpTab 14b. ETA:
ATA :ExpTab 14c. ATA:
Estimate Collection Date: ContTab for FCL shipment, GenTab 9. Estimated Export Pick-Up Date: for LCL
Actual Collection Date: ContTab for FCL shipment, GenTab 10. Actual Export Pick-Up Date: for LCL
Requested Delivery Date: ContTab for FCL shipment, ImpTab 10. Estimated Delivery Date: for LCL
Actual Delivery Date: ContTab for FCL shipment, ImpTab 11. Actual Delivery Date: for LCL

Truck

ETS :GenTab 9. Estimated Export Pick-Up Date:
ATS :GenTab 10. Actual Export Pick-Up Date:
ETA :GenTab x. Estimated Delivery:
ATA :GenTab y. Actual Delivery:
Estimate Collection Date: GenTab 9. Estimated Export Pick-Up Date:
Actual Collection Date: GenTab 10. Actual Export Pick-Up Date:
Requested Delivery Date: GenTab x. Estimated Delivery:
Actual Delivery Date: GenTab y. Actual Delivery:

Report output

Show record() count on the report to indicate that how many shipments per mode

Use cases

QA

Figures

Figure 1. Main report

Figure 2. Transportation Filters

Figure 3. Date Filters

Tweaks

tw1) remove Go back button from the where Is top bar. -- Tira 11:20 AM 28 July 2009 (UTC)

Note: Feedback from Simon on Oct2, 2009 -- Tira 9:10 AM 3 Oct 2009 (UTC)

tw2) Main Report: Default selected output list in the combo box as list below:

Shipper
Consignee
Mode
Departure
Destination
~~Chargeable Weight~~ --> Remove from default output back to the list -- Tira 11:45 AM 16 Jan 2010
Actual Departure Date
Actual Arrival Date
Actual Delivery Date

The rest of the list should be in default dropdown

tw3) Main Report: Update label names:

from "Departure Estimated Date" to "Estimated Departure Date"
from "Departure Actual Date" to "Actual Departure Date"
from "Arrival Estimated Date" to "Estimated Arrival Date"
from "Arrival Actual Date" to "Actual Arrival Date"

tw4) Main and In-transit Report: Show/hide Client Companies list filter. When there is only client company in the filter, this filter section should be invisible. If there is more than one client companies, this filter becomes visible.

Tweaks version 1.1.a

Note: tweaks below applies to both Main and In-transit report Tira 9:50 28 Oct 2009

tw1) Add summary shipment record() count on the report to indicate that how many shipments...

tw2) Create a HTML result page before excel report

tw3) Create download to excel button -> generate xls report

Tweak version 1.1.b

tw1) Main Report - List of Transport Mode (filter) MUST include "UNDEFINED" as well in order to see Undefined shipments -- Tira 11:00 AM Feb 2, 2010

RFC

rfc1) Simon would like to have dynamic filters for Client App by setting filters in Admin Mode for Non-jaguar Users -- Tira 12:33PM 19 Aug 2009 (UTC)

@@ Line 92: / Line 92: @@
 === Output ===
-* Logic for these lists. When client selects "Transport Mode" from General tab to AIR or Ocean, lists of AIR or Ocean hide/show to apply with particular Mode in output dropdown list.
+* Output consists of a long list of headings
-* These header lists should be in output dropdown
+* Output list is multi-selected
-** '''Field // Mode'''
+* Default: selected output list should be listed on the right box and the rest should be in output dropdown list
-** CT# // ALL
+* User is able to manage the order of the output heading list by moving up and down
-** Shipper // ALL
+* User is able to add/remove the output heading list by moving it to the left or right
-** Consignee // ALL
+* Label output heading as listed below
-** Mode // ALL
+** '''Field // Apply to Mode // Default on the right box
-** PO# // ALL
+** CT# // All modes // Yes
-** Item# // ALL
+** Shipper // All modes // Yes
-** Origin Port // ALL
+** Consignee // All modes // Yes
-** Destination Port // ALL
+** Transport Mode // All modes // Yes
-** Origin Region // ALL
+** Departure // All modes // Yes
-** Destination Region // ALL
+** Destination // All modes // Yes
-** Notification Date // ALL
+** Actual Departure Date // All modes // Yes
-** Authorization Date // ALL
+*** Mapping: ExpTab 12c
-** ETS // ALL (this is mapped to field ExpTab 12b)
+** Actual Arrival Date // All modes // Yes
-** ATS	// ALL (this is mapped to field ExpTab 12c)
+*** Mapping: ExpTab 14c
-** ETA	// ALL (this is mapped to field ExpTab 14b)
+** Actual Delivery Date // All modes // Yes
-** ATA	// ALL (this is mapped to field ExpTab 14c)
+***
-** Estimated Collection Date // ALL (this is mapped to a field in ContTab for FCL shipment)
+** Commodity Item PO# // All modes // No
-** Actual Collection Date // ALL (this is mapped to a field in ContTab for FCL shipment)
+** Commodity Item SKU# // All modes // No
-** Requested Delivery Date // ALL (this is mapped to a field in ContTab for FCL shipment)
+** Commodity Item Description // All modes // No
-** Actual Delivery Date // ALL (this is mapped to a field in ContTab for FCL shipment)
+** Commodity Item Quantity // All modes // No
-** Total Pallets // ALL
+** Commodity Item Total Pallets // All modes // No
-** Total Loose Packages // ALL
+** Commodity Item Total Loose Packages // All modes // No
-** Total Weight // ALL
+** Commodity Item Gross Weight // All modes // No
-** Total Chargeable Weight // ALL
+** Chargeable Weight // All modes // No
-** Description // ALL
+** Departure Region // All modes // No
-** Vessel name //OCEAN
+** Destination Region // All modes // No
-** Flight Number // AIR
+** Notification Date // All modes // No
-** HAWB# // AIR
+** Authorization Date // All modes // No
-** Container# (s) // OCEAN
+** Estimated Departure Date // All modes // No
-** Airline // AIR
+*** Mapping: ExpTab 12b
-** Shipping Line // OCEAN
+** Estimated Arrival Date // All modes // No
+*** Mapping: ExpTab 14b
+** Estimated Delivery Date // All modes // No
+*** Mapping: ContTab for FCL shipment
+** Estimated Collection Date // All modes // No
+*** Mapping: ContTab for FCL shipment
+** Actual Collection Date // All modes // No
+*** Mapping: ContTab for FCL shipment
+** Vessel name // OCEAN // No
+** Flight Number // AIR // No
+** HAWB# // AIR // No
+** Container Description // OCEAN // No
+** Shipping Line // OCEAN // No
+** Airline // AIR // No
 More information from fields above:
@@ Line 162: / Line 175: @@
   Requested Delivery Date: GenTab x. Estimated Delivery:
   Actual Delivery Date: GenTab y. Actual Delivery:
+== Report output ==
+* Show record() count on the report to indicate that how many shipments per mode
 ==  Use cases ==