Shared operations ledger

Trip Ticket Dashboard

Centralized trip encoding, payroll calculation, and export for a shared MySQL-backed register.

Operations tools

Export follows the current filters and sort order for the trip register.

Trip form

Update record

Move from trip reference to route, pay, and timing in one clean flow.

Editing

Identity

Ticket and trip reference

Start with the short trip reference, the assigned truck, and the trip type.

Assignment

Truck, driver, and destination

Choose the truck and crew first, then complete the route and load details.

Pay details

Driver and helper computation

Driver pay can auto-fill from the route. Helper base is only needed for long-distance trips.

Long distance helper

PHP 800.00

Excess weight

PHP 0.00

Excess weight follows the stored truck threshold formula.

Timing

Harvest and demurrage clock

Harvest date stays separate. Arrival and departure drive total hours and demurrage.

Live totals

Review before saving

Driver

PHP 800.00

Helper

PHP 800.00

Allowance

200 x 2

PHP 400.00

Grand total

PHP 2,000.00

Cancel

Driver salary

PHP 1,370,700.00

Total driver payout for the current filtered register.

Helper salary

PHP 1,498,202.04

Total helper payout for the current filtered register.

Total allowance

PHP 845,600.00

Combined allowance for the current search and filters.

Grand total

PHP 3,714,502.04

Allowance and salary totals combined for the current view.

Trip register

Encoded trips

1,895 results 7 rows per page Sort: Created date ยท DESC

Showing 1,849-1,855 of 1,895 results.

Date of Harvest Driver's Name Truck / Plate # Province / Municipality Kilos / Helpers Trip Ticket / Trip Driver Salary Helper Salary Allowance Total Amount Status Arrival / Departure / Total Hours / Demurrage Actions
Mar 29, 2026 GILBERT LEDESMA
Elf
--
Nueva Ecija
NATIVIDAD
Kg6,647.69
Helpers1
261870
Long Distance
PHP 800.00 PHP 928.00 PHP 400.00 PHP 2,128.00 --
ArrMar 30, 2026 2:59 AM
DepMar 30, 2026 4:02 AM
Hrs1H3M
DemPHP 0.00
Edit
Jan 21, 2026 GILBERT LEDESMA
Elf
--
Tarlac
SAN JOSE
Kg5,662.00
Helpers1
260008
Long Distance
PHP 800.00 PHP 800.00 PHP 400.00 PHP 2,000.00 --
ArrJan 21, 2026 11:00 PM
DepJan 22, 2026 11:00 AM
Hrs12H
DemPHP 0.00
Edit
Jan 23, 2026 GILBERT LEDESMA
Elf
--
Tarlac
SAN JOSE
Kg6,612.60
Helpers1
260019
Long Distance
PHP 800.00 PHP 922.00 PHP 400.00 PHP 2,122.00 --
ArrJan 23, 2026 2:00 AM
DepJan 24, 2026 7:40 AM
Hrs29H40M
DemPHP 500.00
Edit
Jan 29, 2026 GILBERT LEDESMA
Elf
--
Tarlac
SAN JOSE
Kg0.00
Helpers2
260056
Long Distance
PHP 800.00 PHP 800.00 PHP 600.00 PHP 2,200.00 --
ArrJan 30, 2026 12:33 AM
DepJan 30, 2026 9:33 AM
Hrs9H
DemPHP 0.00
Edit
-- GILBERT LEDESMA
Elf
--
Pangasinan
MANGALDAN
Kg4,587.80
Helpers1
NO TICKET
Local
PHP 600.00 PHP 600.00 PHP 300.00 PHP 1,500.00 --
Arr--
Dep--
Hrs--
Dem--
Edit
Feb 6, 2026 GILBERT LEDESMA
Elf
--
Tarlac
SAN JOSE
Kg6,444.20
Helpers2
260140
Long Distance
PHP 800.00 PHP 888.00 PHP 600.00 PHP 2,288.00 --
ArrFeb 6, 2026 8:09 PM
DepFeb 8, 2026 8:12 AM
Hrs36H3M
DemPHP 700.00
Edit
Feb 9, 2026 GILBERT LEDESMA
Elf
--
Pangasinan
BALUNGAO
Kg6,203.00
Helpers1
260167
Local
PHP 600.00 PHP 620.00 PHP 300.00 PHP 1,520.00 --
ArrFeb 9, 2026 8:44 PM
DepFeb 9, 2026 10:56 PM
Hrs2H12M
DemPHP 0.00
Edit