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)