Logistic Calculation
Three engineering challenges implemented in PHP 8.3 / Laravel 13: a WhatsApp message parser, a geospatial database design, and a payment term calculator.
WhatsApp Message Parser
Parses raw WhatsApp logistics messages into structured JSON — handling Indonesian dates, multi-destination cargo lines, PO dates, and formatting markers.
Database Design
MySQL/MariaDB schema for finding trucks within a given radius — with a denormalised current-location table, B-tree bounding-box indexing, and a Haversine radius query.
TOP Calculator
Calculates the Term of Payment for transporter invoices — applying individual per-type delay caps and a final 45-day ceiling, with all 8 specified test cases passing.