order program for a construction business. I'm having a hard time doing what I want and was wondering
if the fresh pair of eyes approach would help me.
The person i'm doing this for (family) gets a fuel report from the drivers of the vehicles
data on it contains:
the date, odometer reading, how much fuel was put in, the price, and where the vehicle is at (job location)
I have all this historical data in a table
I'm doing the standard preventive maintenance type thing
like change the oil every 3000 miles, check the fluid levels, change tranny fluid etc...
I have a table which has the pmactionid, type of equipment it applies to "AUT" for auto "TRK" for truck etc.. , the frequency it should be done, and a few more fields
What I have done so far is @ http://www.ontheislands.com Take a look and see if you can figure out what's going on.
Most of the action stuff is done and some of the fuel log stuff and the workorder stuff I'm messing with now
What I need it to do (I have some of this done already) is when I click on "new work order" it will check the fuellog table find the last entry, check the odometer reading, and then pull the maintenance items that are due from the pmactions table onto a blank workorder. I am just having a heck of a time with how I can make this work like I want it to
If the completed workorder comes back in and the mechanic didn't do one of the items, the incomplete ones need to be flagged so they will show up on the workorder the next time it is generated also it something non PM wise needs to be done to the equipment (like replace windshield) the user can add it to the next workorder to be generated.
If someone has done something similar or thinks they can help i would appreciate it.
There may be some money in it for you but I'm doing it for cheap since it is family.
Thanks in advance -Dave
-- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
