Project

General

Profile

Actions

Task #17557

open

Task #18451: Ocean Sprint Planning for 16/06/2025 - 30/06/2025

Report - Job File Weight/Volume by Origin Report

Added by Redmine Admin 7 months ago. Updated 39 minutes ago.

Status:
QA
Priority:
High
Assignee:
-
Start date:
03/17/2025
Due date:
06/27/2025 (about 6 months late)
% Done:

100%

Estimated time:
24:00 h
Spent time:
GitLab ID:
2216
GitLab Milestone:
GitLab Ticket Number:
369
GitLab Time Logged:
115200
Lock Timeline Date:
No
gitlab project trace:
Ocean Sprint Planning for 16/06/2025 - 30/06/2025

Description

Acceptance Criteria:

  1. Report Header:
    • Company Name, Logo, Address, Contact Info, VAT Registration Number
    • Report Title: "Job File Weight/Volume by Origin Report"
    • Reporting Period (clearly stated From - To dates)
  2. Report Structure and Fields
    • The system should generate a structured report displaying shipment weight/volume by origin for a selected period.
    • The report should include the following details and other fields as listed in the sample report.
      • Year
      • Origin (Port of Loading)
      • Total Shipment Weight (Tons)
      • Total Shipment Volume (CBM)
      • Monthly Breakdown (January - December)
      • Annual Total
    • The system should allow sorting by year and origin.
  3. Filtering and Selection Criteria
    • The system should allow users to filter data by:
      • Date Range (From Date - To Date)
      • Origin (Port of Loading)
      • Shipment Type (LCL, FCL)
      • Company / Business Unit
      • Freight Terms (Prepaid, Collect)
    • Users should have an option to filter by year or monthly breakdown.
  4. Export and Reporting Format
    • The system should allow exporting the report in:
      • PDF Format
      • Excel Format
    • Users should be able to schedule automatic report generation and email notifications (e.g., monthly, quarterly, yearly).
  5. Data Visualization
    • Can also provide an interactive dashboard view with (if possible):
      • Bar charts and trend graphs comparing shipment weight/volume by origin.
      • Drill-down capability to view individual shipment details by month or specific origin.
  6. User Access & Permissions
    • Only authorised users (e.g., Operations Managers, Freight Forwarders, and Logistics Analysts) should have access to generate and view the report.

image.png{width="609" height="860"}


GitLab Sync Log

[{"id": "24705", "author": "Gilles Mahomudally", "hours": 2.0, "created": "2025-06-10T10:48:05.944Z", "log_date": "2025-06-09", "comment": "Imported from GitLab by @Gilles Mahomudally on 2025-06-10T10:48:05.944Z: 2h-(2.0)h spend at: 2025-06-09", "status": "active", "deleted_by": "", "redmine_entry_id": 9564}, {"id": "24744", "author": "Gilles Mahomudally", "hours": 6.0, "created": "2025-06-11T11:11:26.853Z", "log_date": "2025-06-10", "comment": "Imported from GitLab by @Gilles Mahomudally on 2025-06-11T11:11:26.853Z: 6h-(6.0)h spend at: 2025-06-10", "status": "active", "deleted_by": "", "redmine_entry_id": 9571}, {"id": "24869", "author": "Gilles Mahomudally", "hours": 8.0, "created": "2025-06-13T05:31:52.760Z", "log_date": "2025-06-12", "comment": "Imported from GitLab by @Gilles Mahomudally on 2025-06-13T05:31:52.760Z: 1d-(8.0)h spend at: 2025-06-12", "status": "active", "deleted_by": "", "redmine_entry_id": 9618}, {"id": "24868", "author": "Gilles Mahomudally", "hours": 8.0, "created": "2025-06-13T05:31:41.225Z", "log_date": "2025-06-11", "comment": "Imported from GitLab by @Gilles Mahomudally on 2025-06-13T05:31:41.225Z: 1d-(8.0)h spend at: 2025-06-11", "status": "active", "deleted_by": "", "redmine_entry_id": 9619}, {"id": "25116", "author": "Gilles Mahomudally", "hours": 8.0, "created": "2025-06-16T11:50:28.954Z", "log_date": "2025-06-15", "comment": "Imported from GitLab by @Gilles Mahomudally on 2025-06-16T11:50:28.954Z: 1d-(8.0)h spend at: 2025-06-15", "status": "active", "deleted_by": "", "redmine_entry_id": 9652}]

Actions #1

Updated by Redmine Admin 7 months ago

  • GitLab Sync Log updated (diff)
Actions #2

Updated by Redmine Admin 6 months ago

  • Parent task changed from #16323 to #18123
  • gitlab project trace changed from Ocean Sprint Planning for 19/05/2025 - 30/05/2025 to Ocean Sprint Planning for 04/06/2025 - 13/06/2025
Actions #3

Updated by Redmine Admin 6 months ago

  • Due date changed from 05/30/2025 to 06/13/2025
Actions #4

Updated by Redmine Admin 6 months ago

  • % Done changed from 0 to 8
  • GitLab Time Logged changed from 0 to 7200
Actions #5

Updated by Redmine Admin 6 months ago

  • GitLab Sync Log updated (diff)
Actions #6

Updated by Redmine Admin 6 months ago

  • % Done changed from 8 to 33
  • GitLab Time Logged changed from 7200 to 28800
Actions #7

Updated by Redmine Admin 6 months ago

  • GitLab Sync Log updated (diff)
Actions #8

Updated by Redmine Admin 6 months ago

  • % Done changed from 33 to 100
  • GitLab Time Logged changed from 28800 to 86400
Actions #9

Updated by Redmine Admin 6 months ago

  • GitLab Sync Log updated (diff)
Actions #10

Updated by Redmine Admin 6 months ago

  • Parent task changed from #18123 to #18351
  • gitlab project trace changed from Ocean Sprint Planning for 04/06/2025 - 13/06/2025 to Ocean Sprint Planning for 16/06/2025 - 27/06/2025
Actions #11

Updated by Redmine Admin 6 months ago

  • Due date changed from 06/13/2025 to 06/27/2025
  • GitLab Time Logged changed from 86400 to 115200
Actions #12

Updated by Redmine Admin 6 months ago

  • GitLab Sync Log updated (diff)
Actions #13

Updated by Redmine Admin 6 months ago

  • Status changed from New to QA
Actions #14

Updated by Redmine Admin 5 months ago

  • Parent task changed from #18351 to #18451
  • gitlab project trace changed from Ocean Sprint Planning for 16/06/2025 - 27/06/2025 to Ocean Sprint Planning for 16/06/2025 - 30/06/2025
Actions #15

Updated by Redmine Admin 5 months ago

  • Status changed from QA to New
Actions #16

Updated by Redmine Admin 3 months ago

  • Status changed from New to QA
Actions

Also available in: Atom PDF