View source for EST 355181 Artex Scan Out of Depot Report

{{Template:Estimate
|Supimix_Client_Code=PART
|Supimix_Project_Code=DEV
|Supimix_Site_Code=PART-KOO
|Supimix_Client_Reference=T20181029.0016
|Supimix_Number=355181
|The_version_of_the_document=0.1
|Your_Name=A N Walker
|Supimix_PO_Reference=&nbsp;
|Supimix_Priority=3
|Date_(DD/MM/YY)=15/01/2019
|Clients_Customer=Artex
|System_Version_being_changed=Latest (4.X)
|Client_Request=From Ken Hayes, Monday, 14 January, 2019 3:35 PM:

Artex have asked for a "scanned out of depot report" which will enable them to monitor their Fork Lift drivers performance.

I have reviewed data on the portal and have identified the following fields which should be usable in the report:

*    User: FLT driver
*    Vehicle: FLT truck
*    Start date
*    Arrive date
*    End date
*    Start time 
*    Arrive time
*    End time
*    Container (pallet) quantity
|OBS_Solution=A new report will be added to the ''Reports'' menu item in the ''CALIDUS'' ePOD Admin application, selectable from the drop-down list of reports, labelled as "Loading/Unloading Items Report".

When the user selects this report, the following criteria will be prompted for:
* Date Range, which will default yesterday's date for both Date From and Date To.
* Loading or Unloading selection, defaulting to "Loading". This will also allow the user to select Unloading jobs.

[[File:EST_355181_Params1.PNG|border]]

When the user clicks the '''Create Excel Spreadsheet''' button, the screen will retrieve the data and build a spreadsheet for the user.

Based on analysis the data that the Artex customer is currently generating (for example load "010801L"), the report will select all complete jobs for the user's current site, the type selected (loading or unloading), that '''ended''' within the date range selected (inclusive), the load on which they were received, and a count of all containers (items) successfully confirmed. The data will be summed per:
*    Site
*    User
*    Vehicle
*    Start date
*    Start time 
*    Arrive date
*    Arrive time
*    End date
*    End time

The browser will offer to save the report generated. Note that this is dependent on the user's browser settings.

The report will be named "Loading Unloading Items Report_YYYYMMDD_HHMMSSNN.xls", where:
* YYYYMMDD is the date the user ran the report. 
* HHMMSSNN is the time the user ran the report.

The report will show:
* The selection criteria.
* The results.

The Selection criteria will show:
* Date From
* Date To
* Type

The report will consist of the following columns:
* User - the name of the user that processed the load.
* Vehicle - the vehicle registration assigned to the load.
* Start Date - the actual date when the tasks started.
* Arrive Date - the actual time when the tasks started.
* End Date - the actual date when the tasks ended.
* Start Time - the actual time when the tasks ended.
* Arrive Time - the actual date when the tasks arrived.
* End Time - the actual time when the tasks arrived.
* Item Quantity - a sum of all the confirmed loaded or unloaded items (containers)

[[File:EST_355181_Report.PNG|border|600px]]
|Requirements_Days=0
|Estimation_Days=0.25
|Functional_Specification_Days=0.25
|Technical_Specification_Days=0
|Development_Days=1.75
|Testing_and_Release_Days=0.25
|Implementation_Days=0.25
|Project_Management_Days=0.25
|Year=2019
|Free_Of_Charge=N
|DiscountPerc=0
|ExpiryDays=30
}}