php postgresql website art register

  • Status Closed
  • Budget $250 - $750 AUD
  • Total Bids 9

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

Get free quotes for a project like this
Awarded to:
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online