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 852.00

Excess weight

PHP 26.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 852.00

Allowance

200 x 2

PHP 400.00

Grand total

PHP 2,052.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,877-1,883 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 7, 2026 CRISANTO JAVONILLO
Forward
CBP1838
Pangasinan
SISON
Kg11,857.60
Helpers3
260154
Local
PHP 800.00 PHP 1,186.00 PHP 600.00 PHP 2,586.00 Settled
ArrFeb 7, 2026 6:53 PM
DepFeb 7, 2026 11:54 PM
Hrs5H1M
DemPHP 0.00
Edit
Feb 10, 2026 CRISANTO JAVONILLO
Elf
ZBP211
Pangasinan
MANGALDAN
Kg1,780.44
Helpers2
260205
Local
PHP 600.00 PHP 600.00 PHP 450.00 PHP 1,650.00 Settled
ArrFeb 10, 2026 8:38 PM
DepFeb 11, 2026 7:48 AM
Hrs11H10M
DemPHP 0.00
Edit
Feb 11, 2026 CRISANTO JAVONILLO
Elf
ZBP211
La Union
SUDIPEN
Kg3,126.10
Helpers2
260239
Long Distance
PHP 950.00 PHP 800.00 PHP 600.00 PHP 2,350.00 Settled
ArrFeb 11, 2026 12:44 AM
DepFeb 12, 2026 7:43 AM
Hrs30H59M
DemPHP 700.00
Edit
Jan 30, 2026 DAN PACLE
Elf
XTN453
Tarlac
SAN JOSE
Kg6,267.60
Helpers1
260071
Long Distance
PHP 800.00 PHP 852.00 PHP 400.00 PHP 2,052.00 Settled
ArrJan 30, 2026 10:09 PM
DepJan 31, 2026 3:03 PM
Hrs16H54M
DemPHP 0.00
Edit
Jan 29, 2026 DAN PACLE
Single Tire
XTN453
Tarlac
SAN JOSE
Kg1,318.80
Helpers1
260045
Long Distance
PHP 800.00 PHP 800.00 PHP 400.00 PHP 2,000.00 Settled
ArrJan 29, 2026 5:33 PM
DepJan 30, 2026 7:44 AM
Hrs14H11M
DemPHP 0.00
Edit
Jan 28, 2026 DAN PACLE
Elf
XTN453
Pangasinan
SISON
Kg7,495.00
Helpers1
260039
Local
PHP 600.00 PHP 750.00 PHP 300.00 PHP 1,650.00 Settled
ArrJan 28, 2026 4:30 PM
DepJan 29, 2026 7:20 AM
Hrs14H50M
DemPHP 0.00
Edit
Jan 15, 2026 DAN PACLE
Single Tire
XTN453
Pangasinan
SISON
Kg4,436.00
Helpers1
260002
Local
PHP 600.00 PHP 600.00 PHP 300.00 PHP 1,500.00 Settled
ArrJan 15, 2026 8:00 PM
DepJan 16, 2026 9:30 AM
Hrs13H30M
DemPHP 0.00
Edit