Skip to content
Alzubair Alojali
WhatsApp
ALL WORK · 03
Freight platform

The Ocean Line

Client
Zain Libya
Status
Delivered
Platform
Web
Stack
PHP (PHPRunner)MySQLMulti-currency invoicing

Screens are faithful reconstructions of an archived system, rebuilt from its real database schema.

Active shipments, containers in transit, invoices outstanding, balance due
Active shipments, containers in transit, invoices outstanding, balance due
The brief

Track sea and air shipments, invoice, and see the full financial picture, all in one freight platform.

Freight forwarding runs on paperwork: bookings, bills of lading, container manifests, invoices in several currencies, and keeping one financial picture across all of it is the hard part.

A shipment, end to end

Shanghai to Tripoli on one screen: bill of lading, consignee, containers and the live tracking stage, sea or air.

A shipment from Shanghai to Tripoli: B/L, consignee, containers, live tracking stage
A shipment from Shanghai to Tripoli: B/L, consignee, containers, live tracking stage

The booking book, structured

Routes, commodities, sea/air mode, hazardous-cargo flags and SOC/CMA container ownership. The paperwork becomes a data model.

The booking book: routes, commodities, sea/air, hazardous flags
The booking book: routes, commodities, sea/air, hazardous flags

Invoices that keep score

Multi-currency invoices with paid, partial and overdue states. Every payment reconciles into a running balance due.

Invoices with paid / partial / overdue status
Invoices with paid / partial / overdue status

One financial picture

Revenue, outstanding by client, the sea-vs-air split and top routes. The whole book of business in one view.

Revenue, outstanding by client, sea vs air split, top routes
Revenue, outstanding by client, sea vs air split, top routes
The hard part

Modelling real freight-forwarding operations: bookings, B/Ls, containers, consignees, agents and providers, with multi-currency invoicing and partial payments tracked to a running balance due.

PHP (PHPRunner)MySQLMulti-currency invoicing
Outcome

Sea and air shipments tracked end to end.

Outcome

Invoices and partial payments reconciled to a running balance.

Outcome

One system, one financial picture.

Status

Delivered

Have something like this in mind?

Usually replies within a day.
NEXT PROJECT · TriBudget · 08/15

A budgeting app built around three buckets: what you spend, what you invest, and what you owe, so every dinar has a job.

READ THE CASE STUDY