Filters below apply to Dashboard + Registry + Drivers + White Product. Use OPEN REGISTRY to jump straight to the full table.
Total Trips
Total Revenue
Total Net Income (P&L)
Total Qty Moved
Revenue = Qty × H-Rate | Fuel = Fuel Qty × Pump Price | Total Exp = Fuel + T.Allow + Repairs | Net = Revenue - Total Exp
This table is live. Search, filter, sort, discharge, edit, delete all work. Registry Loaded: 0 trips | Last updated:
| Date ↕ | Truck ↕ | Driver ↕ | Product | Source | Destination | Qty | H-Rate | Revenue | Fuel Qty | Pump | Fuel Amt | T.Allow | Repairs | Total Exp | Net | Status | Actions |
|---|
No trips found.
| Driver | Truck | Phone | Trips | Revenue | Expenses | P&L | Avg/Trip | Action |
|---|
Loading Date → Offloading Date | Duration = Offloading - Loading | Consumed = Loaded - Offloaded | Allowance Collected
| Loading | Offloading | Duration | Driver | Truck | Product | Loaded | Offloaded | Consumed | Allowance | Revenue | Net P&L | Status |
|---|
Qty Sold = Final Meter - Initial Meter | Amount = Qty × Unit Price
| Truck | Outlet | Initial | Final | Qty Sold | Price | Amount |
|---|
| Metric | Excel Formula | JS / SQL | Rule |
|---|---|---|---|
| Revenue | =G*H | qty * hRate | Qty Lifted × H-Rate |
| Fuel Amount | =J*K | fuelQty * pumpPrice | Fuel Qty × Pump Price |
| Total Expenses | =N+M+L | fuelAmt + allow + repairs | Sum of costs |
| Net Income / P&L | =I-O | revenue - totalExp | Profit if >0 |
| Trips | =IF(I>0,1) | revenue>0?1:0 | Count if revenue exists |
| White Duration | =Off - Load | (offDate - loadDate)/86400000 | Days |
| White Consumed | =Loaded - Offloaded | loaded - offloaded | Fuel/Spillage |
| Peddler Qty | =Final - Initial | final - initial | Meter diff |
vehicles(id UUID PK, plate_number UNIQUE, vehicle_type, capacity, status) drivers(id UUID PK, full_name, license_number UNIQUE, phone_number, base_salary, assigned_vehicle_id FK) trips(id UUID PK, vehicle_id FK, driver_id FK, product_type, operation_mode, loading_depot, destination, dispatch_timestamp, discharge_timestamp, loading_qty, discharge_qty, shortage_qty GENERATED (discharge-loading), freight_rate, gross_freight GENERATED (loading*rate), trip_status) peddler_sales(id UUID PK, trip_id FK, customer_outlet, initial_meter, final_meter, quantity_sold GENERATED (final-initial), unit_price, total_amount GENERATED) trip_settlements(id UUID PK, trip_id UNIQUE FK, base_allowance, fuel_cost, union_fees, shortage_deduction, net_payout GENERATED (allowance-deduction)) -- NEW v1.1: driver_profiles(full_name, truck_number UNIQUE, phone_number UNIQUE) -- NEW v1.1: white_product_trips(loading_date, offloading_date, duration_days GENERATED, liters_loaded, liters_offloaded, liters_consumed GENERATED, allowance_collected) -- INDEXES: idx_trips_driver, idx_trips_date, idx_trips_product