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 1,212.00

Excess weight

PHP 206.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 1,212.00

Allowance

200 x 3

PHP 600.00

Grand total

PHP 2,612.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,835-1,841 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 6, 2026 JAYSON PATAGUE
Forward
--
Pangasinan
SISON
Kg11,164.40
Helpers1
260589
Local
PHP 800.00 PHP 1,116.00 PHP 300.00 PHP 2,216.00 --
ArrMar 7, 2026 11:50 AM
DepMar 8, 2026 3:10 AM
Hrs15H20M
DemPHP 0.00
Edit
Jan 30, 2026 JAYSON PATAGUE
Elf
KAS2941
Tarlac
SAN JOSE
Kg4,164.40
Helpers1
260065
Long Distance
PHP 800.00 PHP 800.00 PHP 400.00 PHP 2,000.00 --
ArrJan 30, 2026 10:01 PM
DepJan 31, 2026 10:19 AM
Hrs12H18M
DemPHP 0.00
Edit
Mar 21, 2026 GILBERT LEDESMA
Elf
RMP573
Tarlac
SAN JOSE
Kg8,069.60
Helpers2
261546
Long Distance
PHP 800.00 PHP 1,212.00 PHP 600.00 PHP 2,612.00 --
ArrMar 22, 2026 1:58 AM
DepMar 23, 2026 12:50 AM
Hrs22H52M
DemPHP 0.00
Edit
Mar 22, 2026 GILBERT LEDESMA
Elf
RMP573
Nueva Ecija
CABIAO
Kg355.00
Helpers1
261547
Long Distance
PHP 800.00 PHP 800.00 PHP 400.00 PHP 2,000.00 --
ArrMar 23, 2026 12:23 AM
DepMar 23, 2026 12:54 AM
Hrs31M
DemPHP 0.00
Edit
Mar 22, 2026 GILBERT LEDESMA
Elf
RMP573
Pangasinan
VILLASIS
Kg5,094.00
Helpers2
261565
Local
PHP 600.00 PHP 600.00 PHP 450.00 PHP 1,650.00 --
ArrMar 23, 2026 4:17 AM
DepMar 23, 2026 5:00 AM
Hrs43M
DemPHP 0.00
Edit
Mar 22, 2026 GILBERT LEDESMA
Elf
RMP573
Pangasinan
BAYAMBANG
Kg2,882.60
Helpers2
261606
Local
PHP 600.00 PHP 600.00 PHP 450.00 PHP 1,650.00 --
ArrMar 23, 2026 5:10 PM
DepMar 23, 2026 6:36 PM
Hrs1H26M
DemPHP 0.00
Edit
Mar 23, 2026 GILBERT LEDESMA
Elf
RMP573
Pangasinan
BAYAMBANG
Kg3,826.60
Helpers2
261607
Local
PHP 600.00 PHP 600.00 PHP 450.00 PHP 1,650.00 --
ArrMar 23, 2026 2:40 AM
DepMar 24, 2026 5:12 AM
Hrs26H32M
DemPHP 700.00
Edit