php postgresql website art register

IN PROGRESS
Bids
9
Avg Bid (AUD)
$587
Project Budget (AUD)
$250 - $750

Project Description:
Website Art Register
Objective:
To record pieces of art and their artists, agents and owners. Owners can sell to one another - the seller enters details of the buyer onto the website. The website generates emails to seller and buyer requesting/confirming information provided.
Each art piece has a unique serial generated by the superadmin of website, plus a mod5 check digit that is passed to the buyer.
The website allows for franchisees to buy serial numbers from the superadmin and in turn on-sell these to the owner. The Agent (eg insurance agent) must be able to query information as well.
CSS:
The website should allow for layout by divisions wherever possible, and standard fonts and colours that can be adjusted by the buyer later. Database PostgreSQL not MySQL.
Home Page
• General description of application (text to be added by this buyer later)
• Contact details
• Logo
• Login box
• Forgotten password email generator
Login In
EMAIL ADDRESS and PASSWORD
Verify Page
• Match email to databse contact list
• Match password to email
• Write login log entry
• Branch to user type pages
o Super admin
o Franchisee
o Agent
o Owner
o Error page
Error Page
• Opportunity for
• re-input of email/password
• forgotten password routine
• return to Home Page
• exit

User Type Page: SuperAdmin
Example: owner only
Input Facilities
• Form: add /edit Website serial
o Unique job serial
o Generate check digit modulus 11
• Form: add/edit asset
• Form: add/edit owner
• Form: add/edit franchisee
• Form: add/edit agent
• Form: Agent purchase of kits
Output Facilities
• Button: Generate owner verification emails
• List: login log list (date range input form)
• List: transaction log list (date range input form)
• List: active Website serials
• List: available Website serials
• List: agent purchase details
Transaction Log
• Log: all queries
• Log: all email requests
Log out

User Type Page: Franchisee
Example: Tali Gallery
Input Facilities
• Form: add/edit asset
• Form: add/edit customer
• Form: query Website serial for items
• Form: query customer for Website items
• Form: Owner purchase of kits
Output Facilities
• List: assets and serials for given owner
• List: assets for given serial
Transaction Log
• Log: all queries
• Log: all email requests
Log out
User Type Page: Agent
Example: Insurance Agent
Input Facilities
• Form: query Website serial for items
• Form: Query title for items
• Form: query customer for Website items
Output Facilities
• List: assets and serials for given owner
• List: assets for given serial
Transaction Log
• Log: all queries
• Log: all email requests
Log out

User Type Page: Owner
Example: Tali Gallery ??
Input Facilities
• Form: Register Transfer
• Form: new contact details
• Form: change my contact details
• Form: add/edit asset
Output Facilities
• Email: sent to new contact
• List: assets and serials
Transaction Log
• Log: all queries
• Log: all email requests
Log out
Program Logic
• Needs https?
• Hide contact ID in URL
• No prices in system

Program Validation
SuperAdmin
• Check digit modulus for entering Website
Agent
• Match serial to contact
• Match contact to admin list??
Database Schema
Asset Table
• Primary Key: AssetID
• Foreign key: AssetCatID
• Foreign key: SourceID (SerialSource)
• ItemName
• Description
• Artist
• Medium
• CreatedDate
• Size
• Framed
• Condition
• Photo (attachment)
• Acquired Date
• SellDate
• Location
• Agent
• Model
• Comments
• Retired Date
• Inventory
• AlternateCode
• ArtCodeCountry
• ArtCodeSerial
• SerialMod5
Asset Category Table
• Primary Key: AssetCatID
• AssetCategory
Serial Source Table
• Primary Key: SourceID
• SerialSource
Contacts Table
• Primary Key: ContactID
• Foreign key: ContactTYpeID (ContactType)
• Company
• Last Name
• First Name
• E-mail Address
• ContactPassword
• Business Phone
• Mobile Phone
• Fax Number
• Address
• City
• State/Province
• ZIP/Postal Code
• Country/Region
• Web Page
• Notes
Contact Types Table
• Primary Key: ContactTypeID
• Con

Skills required:
PHP, SQL, Website Design
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 500
in 10 days
Hire webphpworld
$ 600
in 15 days
$ 500
in 12 days
Hire Expertever
$ 500
in 10 days
Hire YashpalSingh123
$ 550
in 5 days
$ 734
in 35 days
Hire papanbamba
$ 700
in 14 days
Hire heroncosmo
$ 500
in 30 days
Hire dangerousinminds
$ 700
in 12 days