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 3

PHP 600.00

Grand total

PHP 2,200.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,331-1,337 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
Feb 6, 2026 JOSHUA AQUINO
Elf
ZHR402
Pangasinan
SISON
Kg9,357.30
Helpers2
260127
Local
PHP 600.00 PHP 936.00 PHP 450.00 PHP 1,986.00 Settled
ArrFeb 6, 2026 9:26 PM
DepFeb 6, 2026 11:15 PM
Hrs1H49M
DemPHP 0.00
Edit
Feb 15, 2026 ARTEMIO BIDA
Elf
CBR1845
Pangasinan
ASINGAN
Kg3,815.60
Helpers1
260341
Local
PHP 600.00 PHP 600.00 PHP 300.00 PHP 1,500.00 --
ArrFeb 15, 2026 5:34 PM
DepFeb 16, 2026 6:00 AM
Hrs12H26M
DemPHP 0.00
Edit
Feb 7, 2026 JOSHUA AQUINO
Elf
ZHR402
Pangasinan
MANGALDAN
Kg6,274.20
Helpers2
260160
Local
PHP 600.00 PHP 627.00 PHP 450.00 PHP 1,677.00 Settled
ArrFeb 7, 2026 10:52 PM
DepFeb 8, 2026 5:09 AM
Hrs6H17M
DemPHP 0.00
Edit
Feb 4, 2026 JOSHUA AQUINO
Elf
ZHR402
Tarlac
MONCADA
Kg598.20
Helpers2
260112
Local
PHP 600.00 PHP 600.00 PHP 450.00 PHP 1,650.00 Settled
ArrFeb 4, 2026 11:41 AM
DepFeb 5, 2026 5:45 AM
Hrs18H4M
DemPHP 0.00
Edit
Feb 11, 2026 JOSHUA AQUINO
Elf
ZHR402
Pangasinan
STA MARIA
Kg5,070.80
Helpers2
260230
Local
PHP 600.00 PHP 600.00 PHP 450.00 PHP 1,650.00 Settled
ArrFeb 11, 2026 6:07 PM
DepFeb 12, 2026 3:20 AM
Hrs9H13M
DemPHP 0.00
Edit
Feb 12, 2026 JOSHUA AQUINO
Elf
ZHR402
Pangasinan
SAN FABIAN
Kg2,602.76
Helpers2
260244
Local
PHP 600.00 PHP 600.00 PHP 450.00 PHP 1,650.00 Settled
ArrFeb 12, 2026 3:06 PM
DepFeb 12, 2026 10:26 PM
Hrs7H20M
DemPHP 0.00
Edit
Feb 13, 2026 JOSHUA AQUINO
Elf
ZHR402
Tarlac
SAN JOSE
Kg4,555.70
Helpers2
260283
Long Distance
PHP 800.00 PHP 800.00 PHP 600.00 PHP 2,200.00 Settled
ArrFeb 13, 2026 10:52 PM
DepFeb 14, 2026 3:35 AM
Hrs4H43M
DemPHP 0.00
Edit