Käynnissä

6025 Dynamic Price Quote System

Hello, A few months ago I had a programmer make me an Excel spreadsheet that helped me keep track of prices for items I use in building something. I expanded on it and it is a huge behemoth of an excel spreadsheet that does the trick, but takes much work to do - and I believe converting it to PHP/MySQL would be much better. It is embarrassing what I intend to use it for, so I will just use a automobile comparison to metaphorically setup what I am looking for. So assume I build cars. Data Tables needed: 1) Vendors: Companies I buy parts from. I keep track of Their name, contact person, phone number, fax number, email address, and 3 char abbreviation of companyname. 2) Categories: These are main categories of the parts I use to build my cars. Examples would be ENGINE, OUTSIDE, INTERIOR, etc. 3) Sub-Categories: These are the specific sub categories of the main categories. As example, a CAR has an ENGINE, which has a FUEL INJECTOR, TRANSMISSION, RADIATOR, FAN BELT, etc. 4) Items: Sub-categories have items. Example, for the RADIATOR sub-category, I might have 5 RADIATORs to choose from with different attributes. Attributes would be NAME, VENDOR bought from, VENDORPRICE, VENDORPRICEDATE (which is the date that the price was recorded), VENDORPRICEMETHOD (which is how the price was attained, like pricecheck, pricelist, or actual invoice). 5) Car Model: I would like to setup Car Models with default ITEMS preconfigured (no item or a specific item). Configuration/Quote: I would like to take those CAR MODELs and be able to adjust from the default using dropdown boxes. This would then change the final price for the CAR on the bottom. Price noting: I need to have an admin interface that allows me to change prices at will, keeping track of the pricing changes made on what day. Price note alerts: I will need to be able to add items with a simple form, as well as suspend items when they go out of salability. Items that are not sold anymore should not be listed in the dropdown box. I will need the final configured car to be printable within a simple clean webpage listing the date generated, with a default message about how long the custom car quote is saved for. Input for it would be Attn name, Company Name, address, city, state, zip, phone, email address, eprsonalized note. Ability to save my logo and the default disclaimer would be super. I feel there is something missing, but this is a good start. If I am missing something important, I will pay for it. I will post some pics of the spreadsheet I am using, and will post them tomorrow or the next day. This is for my personal use, so no real need to protect with security, and no need to pretty it up (just clean simple php forms) - so it will not be available on internet to outside world. Server installing it to is a linux server with PHPmyadmin and whatever else you need. Thank you, -WC-

Taidot: AJAX, kaikki käy, CSS, MySQL, Perl, PHP

Näytä lisää: zip car, webpage programmer, super programmer, simple spreadsheet examples, programmer spreadsheet, pricing model excel, price php programmer, php programmer prices, fan pics, make security logo, logo clean companies, logo fuel company, logo automobile company, need programmer start, need logo security company, need linux programmer much, much pay logo, much custom logo, post something internet, dynamic programmer, need buy logo, comparison price programmer, companies logo change, cars using, cars company logo

About the Employer:
( 4 reviews )

Projektin tunnus: #1756895