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,549.00

Excess weight

PHP 349.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 1,000.00

Helper

PHP 1,549.00

Allowance

200 x 4

PHP 800.00

Grand total

PHP 3,349.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 309-315 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
Apr 7, 2026 GLENN JAY MANGSAT
Elf
KAS7581
Pangasinan
BAUTISTA
Kg3,748.60
Helpers1
262420
Local
PHP 600.00 PHP 600.00 PHP 300.00 PHP 1,500.00 Settled
ArrApr 11, 2026 10:37 AM
DepApr 11, 2026 12:30 PM
Hrs1H53M
DemPHP 0.00
Edit
Apr 9, 2026 ARTEMIO BIDA
Elf
CBR6827
Pangasinan
ASINGAN
Kg1,417.80
Helpers1
262368
Local
PHP 600.00 PHP 600.00 PHP 300.00 PHP 1,500.00 --
ArrApr 10, 2026 2:33 PM
DepApr 11, 2026 12:20 AM
Hrs9H47M
DemPHP 0.00
Edit
Apr 14, 2026 JOHN PAUL ROCAPOR
Elf
NAK9638
La Union
BANGAR
Kg5,369.70
Helpers2
261333
Long Distance
PHP 800.00 PHP 800.00 PHP 600.00 PHP 2,200.00 For Releasing
ArrApr 15, 2026 9:24 PM
DepApr 15, 2026 11:20 PM
Hrs1H56M
DemPHP 0.00
Edit
Apr 12, 2026 JOHN PAUL ROCAPOR
Elf
NAK9638
La Union
CABA
Kg2,685.38
Helpers2
261332
Long Distance
PHP 800.00 PHP 800.00 PHP 600.00 PHP 2,200.00 For Releasing
ArrApr 13, 2026 8:19 PM
DepApr 14, 2026 12:45 PM
Hrs16H26M
DemPHP 0.00
Edit
Apr 10, 2026 JOHN PAUL ROCAPOR
Forward
CBR7063
Pangasinan
SISON
Kg12,209.60
Helpers3
262404
Local
PHP 800.00 PHP 1,221.00 PHP 600.00 PHP 2,621.00 For Releasing
ArrApr 10, 2026 4:56 PM
DepApr 11, 2026 12:56 AM
Hrs8H
DemPHP 0.00
Edit
Apr 11, 2026 JOHN PAUL ROCAPOR
Forward
CBR7063
La Union
BALAOAN
Kg12,494.86
Helpers3
261302
Long Distance
PHP 1,000.00 PHP 1,549.00 PHP 800.00 PHP 3,349.00 For Releasing
ArrApr 12, 2026 10:00 PM
DepApr 14, 2026 4:05 PM
Hrs42H5M
DemPHP 900.00
Edit
Apr 9, 2026 JOHN PAUL ROCAPOR
Elf
NAK9638
Pangasinan
SISON
Kg3,593.80
Helpers2
262433
Local
PHP 600.00 PHP 600.00 PHP 450.00 PHP 1,650.00 For Releasing
ArrApr 10, 2026 8:21 PM
DepApr 12, 2026 11:50 PM
Hrs51H29M
DemPHP 1,400.00
Edit