fuel usage file "fuel_use.txt"...
date time,machine number,meter reading
sample...
20260326064521100450

data entry is the machine number and meter reading...that's it...
Special usage machine numbers are...
600-filling gasoline cans
700-filling diesel cans
900-diesel used by outside contractor
901-gasoline used by outside contractor
902-diesel used by clubhouse operations
903-gasoline used by clubhouse operations
904-diesel used by greens dept. member for personal vehicle or equipment
905-gasoline used by greens dept. member for personal vehicle or equipment
980-daily running-total reading off diesel meter
981-daily running-total reading off gasoline meter
990-diesel DELIVERY by vendor 
991-gasoline DELIVERY by vendor

IF FILLING A NON-NUMBERED MACHINE
 (like a rented piece of equipment or a demo)
USE 600 FOR GASOLINE or 700 FOR DIESEL


machine number database file...
101gChevy Van
102dKubota M6060D
103d
104d
106d
107d
108d
109d
110d
120d
121d
123d
124d
211g
212g
213g
220g
221g
222g
240g
301d
302d
303d
304d
305d
306d
307d
308d
315g
320g
321g
332g
350g
401d
402d
403d
526g
527g
528g
529g
530g
531g
532g
533g
535g
536g
537g
591g
592g
593g
594g
600g ...gasoline cans
601g
602g
603g
604g
605g
606g
607g
608g
609g
610g
611g
650g
651g
652g
670g
675g
680g
682g
683g
686g
688g
689g
690g
700d ...diesel cans
705g
706g
707g
710d
722g
900g ...diesel used by outside contractor
901g ...gasoline used by outside contractor
902d ...diesel used by clubhouse operations
903g ...gasoline used by clubhouse operations
904d ...diesel used by greens dept. member for personal vehicle or equipment
905g ...gasoline used by greens dept. member for personal vehicle or equipment
980d ...daily running-total reading off diesel meter
981g ...daily running-total reading off gasoline meter
990d ...diesel DELIVERY by vendor 
991g ...gasoline DELIVERY by vendor


fuel data entry program tasks (fh_fuel_input.php)
wait for machine number input,
ask again if "machine number not found",
display number's description and "DIESEL" or "GASOLINE",
wait for meter reading input,
wait for "correct? Y or N" answer...pass reading record to fh_fuel_store.php...

reading storage program tasks...
determin weather gasoline or diesel then get last record..

IF machine number is lower than 980 create a diesel OR gasoline usage record,
Deduct current reading from last tank balance to get the new record's tank balance,copy the last audited tank balance and last daily totals numbers to the new record,then store the new record.

If the machine number is 980 or 981 the new record is a daily running totals audit record...deduct the new reading from the last daily totals number to get the actual usage
after the last reading ... deduct that usage from the last audited tank balance...compare the new audited tank balance with the current tank balance,then create one of two
text lines to store in the "machine name" slot.
if the new audited balance is LESS than current balance.."Current tank balance decreased to (new audited balance)... (difference) gallons were NOT LOGGED since last daily reading"
if that number is more than the current balance.."Currentr tank balance increased to (new audited balance) ... (difference) gallons were LOGGED IN ERROR since last daily reading".
Then store the new record with reading = last daily total,and current balance = last audited balance....and the difference number.

IF machine number is 990 or 991 the reading number is the gallons delivered which gets added to BOTH the current tank balance AND to the last audited tank balance with the text line
"(reading) GALLONS OF (fuel type) DELIVERED...TANK BALANCE INCRESED TO (current tank balance)".


Input log record fields...
fuel type (0,1)
time stamp YYYYMMDDHHMMSS (1,14)
machine number NNN (15,3)
reading NNNNNNNNNN (18,10)
machine name (28,)



diesel and gasoline.dat record fields...
time stamp YYYYMMDDHHMMSS (0-14)
machine number NNN (14,3)
reading    NNNNNNNNNN (17,10)
current tank balance NNNNNNNNNN (27,10)
last audited tank balance NNNNNNNNNN (37,10)
last daily total NNNNNNNNNN (47,10)
audit record difference NNNNNNNNNN (57,10)[only an audit record uses this field]
description [machine name] (67,)