What I need is a script that checks this table for new vehicles and then adds them to the new vehicle_stats table.
Additionally the script (maybe a second script) checks the print_status table and updates vehicle_statistics when the first occurance of that vin being printed occurs
Then when the vehicle is no longer in the dealer_inventory table the vehicle_statistics entry for that VIN is updated as sold with the SOLD_DATE
2 other things, when the vehicle is printed I want the vehicle_statistics table to note the sticker print type, and when a vehicle is added its status is set to active, and when removed it's set to inactive
I basically need to know when vehicles are added to the system, when they are sold, what date the car was printed, the last scan date , and if the vehicle is active, or inactive and what type of sticker was printed.
4 freelancers are bidding on average $175 for this job
Hi, I am a web developer with exeprtiese in php and mysql mainly and have 1year of experience in it I am interested in this job and can do for you If interested please contact me back Thanks