programming help wanted

From: Date: Tue, 25 Feb 2003 04:55:57 +0000
Subject: programming help wanted
References: 1  Groups: php.windows 
Request: Send a blank email to php-windows+get-18691@lists.php.net to get a copy of this message
I am currently writing a access db program to php www site conversion. It is a maintenance work 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

« previous php.windows (#18691) next »