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 386-392 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
Jan 27, 2026 CRISANTO TENEZA
Elf
KAS2941
Pangasinan
LAOAC
Kg3,399.56
Helpers1
260030
Local
PHP 600.00 PHP 600.00 PHP 300.00 PHP 1,500.00 --
ArrJan 27, 2026 10:45 PM
DepJan 28, 2026 11:10 AM
Hrs12H25M
DemPHP 0.00
Edit
Apr 1, 2026 GILBERT LEDESMA
Elf
CBR1843
Tarlac
MONCADA
Kg2,179.00
Helpers1
262109
Local
PHP 600.00 PHP 600.00 PHP 300.00 PHP 1,500.00 --
ArrApr 2, 2026 11:20 AM
DepApr 2, 2026 11:25 PM
Hrs12H5M
DemPHP 0.00
Edit
Apr 10, 2026 JOBERT ALVAREZ
Elf
JBH7649
Pangasinan
BAUTISTA
Kg6,004.00
Helpers2
261281
Local
PHP 600.00 PHP 600.00 PHP 450.00 PHP 1,650.00 --
ArrApr 12, 2026 11:40 PM
DepApr 14, 2026 6:32 PM
Hrs42H52M
DemPHP 700.00
Edit
Apr 8, 2026 JOBERT ALVAREZ
Elf
JBH7649
Pangasinan
BAUTISTA
Kg5,504.20
Helpers3
002184
Local
PHP 600.00 PHP 600.00 PHP 600.00 PHP 1,800.00 --
ArrApr 10, 2026 9:25 PM
DepApr 12, 2026 4:15 PM
Hrs42H50M
DemPHP 900.00
Edit
Apr 5, 2026 JOBERT ALVAREZ
Elf
JBH7649
Pangasinan
SAN JACINTO
Kg7,385.40
Helpers2
262428
Local
PHP 600.00 PHP 739.00 PHP 450.00 PHP 1,789.00 --
ArrApr 7, 2026 5:43 PM
DepApr 9, 2026 1:20 AM
Hrs31H37M
DemPHP 700.00
Edit
Mar 31, 2026 GILBERT LEDESMA
Elf
RMP573
Nueva Ecija
JAEN
Kg3,956.40
Helpers1
262057
Long Distance
PHP 800.00 PHP 800.00 PHP 400.00 PHP 2,000.00 --
ArrApr 1, 2026 6:00 PM
DepApr 1, 2026 7:29 PM
Hrs1H29M
DemPHP 0.00
Edit
Apr 5, 2026 JOBERT ALVAREZ
Forward
JBH7649
Pangasinan
BAUTISTA
Kg9,608.40
Helpers2
262312
Local
PHP 800.00 PHP 961.00 PHP 450.00 PHP 2,211.00 --
ArrApr 7, 2026 1:40 AM
DepApr 7, 2026 6:15 AM
Hrs4H35M
DemPHP 0.00
Edit