109743 Silent Vehicle Salvage Auction

Very simple auction database (our server uses/supports Apache, PHP, mySQL) We are looking for a quote to do the following for a client of ours. GOOD EXAMPLE: [login to view URL] Front End •“Silent Auction” (does not show current Stock) •Registration page: (all fields are required and cannot be left blank for use with bill of sale and Final Statement for insurance company if they are high bidder) - Name - Address - City - Province - Postal Code -Drivers License - e-mail (verify e-mail after registration NOT required) - Phone Number •Categories for each vehicle on Front End PLUS PHOTOS: (from the admin side being able to search by any category if looking for 1978 all 1978’s will come up, etc.) - Stall Number - Stock Number - Year - Make - Model - Serial Number/V.I.N - Color - Vehicle Description - Status - Odometer Reading Bidding: - MAX MID (for customer to enter the most they are willing to pay for a vehicle) - Cancel MAX STOCK (NO! Customer must phone in admin control only!) Back End (Administration) Categories for each vehicle are as follows: Company Information: Name Address City Province Postal Code Phone Phone (24 Hrs.) FAX G.S.T. Number *Remember when a vehicle sells the registered customer must then be attached to that vehicle, also so that in the future they can pull up and see all vehicles purchased by that customer. PHOTO UPLOADER (AS MANY PICTURES AS THEY WANT) -The photo could go a lot of ways but have 1 box that rotated through the pictures would be nice. -Being able to delete a picture is a must in case the wrong one is uploaded. Date of Release and up for Stocks (released by insurance company) this tells the website when vehicle can be viewed by customers on the web page. Date of Sale (buyer) Vendor ** Remember Vendors ** Usually repeat Vendors/Insurance company's(for Vendor/Insurance Company Receipt) Reference Number (for Vendor/Insurance Company Receipt) Owner (for Vendor/Insurance Company Receipt) Insured (for Vendor/Insurance Company Receipt) Special Notes (for Vendor/Insurance Company Receipt) Previous Charges $ (for Vendor/Insurance Company Receipt) TOW From $ (for Vendor/Insurance Company Receipt) Other $ (for Vendor/Insurance Company Receipt) FEE $ (for Vendor/Insurance Company Receipt) G.S.T. $ (for Vendor/Insurance Company Receipt) Total Deductions $ (for Vendor/Insurance Company Receipt) Net Recovery $ (for Vendor/Insurance Company Receipt) Stall Number Stock Number Year Make Model Serial Number/V.I.N Color Vehicle Description Status Odometer Reading Particulars Condition Amount Stock (Final Sale Price) * Pulled from Auction or can be manual entry Bidding FEES (maybe a customizable pull down here incase prices change) = $ (ZERO is allowed) $1 - $100 = $10 $101 - $500 = $20 $501 and up = $30 Impact Auto Auction FEES (maybe a customizable pull down here incase prices change) = $ (ZERO is allowed) $0 - $299 = $55 $300 - $599 = $105 $600 - $1499 = $185 $1500 - $2499 = $235 $2500 - $3499 = $275 $3500 - $9999 = $325 $10,000 and up = $375 Subtotal = (Amount Stock + Bidding FEES + Impact Auction FEES) G.S.T. 6% = (Subtotal X .06) TOTAL = (Subtotal + G.S.T) PRINTING OPTIONS FOR ADMINSTRATION Customer Receipt (Company Information pulled from admin information at top of Receipt) SOLD TO: Customer Name Drivers License Address City Province Postal Code Amount Stock FEE G.S.T. TOTAL Stock Number Stall Number Status Year Make Model Serial/V.I.N Color Particulars Condition NO WARRANTY. The purchaser hereby acknowledges that the item(s) named herein have been purchased on an “AS IS WHERE IS” basis and further agrees that Lethbridge Storage & Salvage Disposal and our vendor are in no way responsible for any conditions not apparent at time of purchase. Vendor X______________________________ Purchaser X_____________________________ PRINTING OPTIONS FOR ADMINSTRATION Vendor/Insurance Company Receipt “Final Statement” (Company Information pulled from admin information at top of Receipt) Vendor Reference Number Owner Insured Special Notes Dear Sir/Madam: Sale of the below noted unit has been concluded as per your instructions. We trust that this final statement meets with your approval. Previous Charges $ TOW From $ Other $ FEE $ G.S.T. $ Total Deductions $ Net Recovery $ SOLD TO: (pulled from customer information and auction) Customer Name Drivers License Address City Province Postal Code Amount Stock G.S.T. TOTAL Stock Number Stall Number Status Year Make Model Serial/V.I.N Color Particulars Condition NO WARRANTY. The purchaser hereby acknowledges that the item(s) named herein have been purchased on an “AS IS WHERE IS” basis and further agrees that Lethbridge Storage & Salvage Disposal and our vendor are in no way responsible for any conditions not apparent at time of purchase. Vendor X______________________________ Purchaser X_____________________________ Any additional ideas or suggestions would be appreciated. We plan and hope to just apply this to their existing html website that we are already working on. PRINTING OPTIONS FOR ADMINSTRATION Insurance/Vendor Bid History Reports Able to run Query (reports) on Insurnace/Vendor (print list from each vendor)