Task #18863
closedTask #19240: Sprint Planning for 06/01/2026 - 16/01/2026
Report - Pending House Delivery Order
Description
Mr. Yoni Soleil, from EDL has requested the following report after our meeting on 01 October 2025.
Report listing all pending House Delivery Orders (HDOs) to quickly identify shipments where no Manual DO or CCS transmission has been done and take corrective action.
Acceptance Criteria¶
- The report must display:
- File Reference
- HBL Number
- MBL Number
- Consignee
- DO Type (Temporary / Manual DO / CCS Transmission)
- Status (Approved/Not Approved)
- Transmission Status (Not Sent / Success / Failed)
- DO Created Date
- Pending logic
- Pending – RED: A Temporary DO exists AND (no Manual DO OR no CCS Transmission).
- Pending – ORANGE: No DO at all (no Temporary, no Manual, no Transmission).
- Exclude from report: A Manual DO exists OR a CCS Transmission (Success) exists.
- The report should allow filtering by:
- Date range (ETA or DO created date)
- File Reference (contains)
- Customer (contains)
- HBL Number (contains)
- MBL Number (contains)
-
KPI tiles: add small KPIs above the table:
- “Pending (RED) count”, “No DO (ORANGE) count”
- Report must be exportable to Excel.
GitLab Sync Log
[{"id": "36630", "author": "Waliyuddin Delba", "hours": 2.0, "created": "2026-01-08T11:54:12.242Z", "log_date": "2026-01-07", "comment": "Imported from GitLab by @Waliyuddin Delba on 2026-01-08T11:54:12.242Z: 2h-(2.0)h spend at: 2026-01-07", "status": "active", "deleted_by": "", "redmine_entry_id": 11912}, {"id": "37140", "author": "Waliyuddin Delba", "hours": 6.0, "created": "2026-01-16T11:33:58.342Z", "log_date": "2026-01-15", "comment": "Imported from GitLab by @Waliyuddin Delba on 2026-01-16T11:33:58.342Z: 6h-(6.0)h spend at: 2026-01-15", "status": "active", "deleted_by": "", "redmine_entry_id": 11981}, {"id": "37341", "author": "Waliyuddin Delba", "hours": 5.0, "created": "2026-01-19T10:49:11.216Z", "log_date": "2026-01-18", "comment": "Imported from GitLab by @Waliyuddin Delba on 2026-01-19T10:49:11.216Z: 5h-(5.0)h spend at: 2026-01-18", "status": "active", "deleted_by": "", "redmine_entry_id": 11992}, {"id": "42397", "author": "Ra-ees Peeroo", "hours": 6.0, "created": "2026-04-17T10:20:51.733Z", "log_date": "2026-04-15", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2026-04-17T10:20:51.733Z: 6h-(6.0)h spend at: 2026-04-15", "status": "active", "deleted_by": "", "redmine_entry_id": 13136}, {"id": "42388", "author": "Ra-ees Peeroo", "hours": 6.0, "created": "2026-04-17T10:18:05.666Z", "log_date": "2026-04-17", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2026-04-17T10:18:05.666Z: 6h-(6.0)h spend at: 2026-04-17", "status": "deleted", "deleted_by": "42395", "redmine_entry_id": 13137}, {"id": "42535", "author": "Ra-ees Peeroo", "hours": 3.0, "created": "2026-04-21T05:34:30.645Z", "log_date": "2026-04-16", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2026-04-21T05:34:30.645Z: 3h-(3.0)h spend at: 2026-04-16", "status": "active", "deleted_by": "", "redmine_entry_id": 13170}, {"id": "42895", "author": "Ra-ees Peeroo", "hours": 7.0, "created": "2026-04-23T07:18:51.959Z", "log_date": "2026-04-19", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2026-04-23T07:18:51.959Z: 7h-(7.0)h spend at: 2026-04-19", "status": "active", "deleted_by": "", "redmine_entry_id": 13281}, {"id": "43165", "author": "Ra-ees Peeroo", "hours": 1.0, "created": "2026-04-27T09:34:46.374Z", "log_date": "2026-04-20", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2026-04-27T09:34:46.374Z: 1h-(1.0)h spend at: 2026-04-20", "status": "active", "deleted_by": "", "redmine_entry_id": 13341}]