php postgresql website art register

In Progress

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: PHP, SQL, Website Design

See more: write name on photo website, website out source, website layout design buy, website for numbers design seller, website for artists to sell, website design table code, website design numbers, website company that prices website, web page layout to buy, web page design notes, web page design generator, web layout buy, web design model pages, web design kits, web design generator, web design for buy artist, web design for artists, web art design buy, web application home page design, unique logo generator, types of logo for new company, the super source, the standard insurance, the register, text logo generator

About the Employer:
( 0 reviews ) Ubud, Indonesia

Project ID: #870013

Awarded to:

webphpworld

Ready to start.

$600 AUD in 15 days
(55 Reviews)
6.4

9 freelancers are bidding on average $587 for this job

SigmaVisual

We can help in your project, please check PMB and our ratings/reviews to get idea of our experience.

$500 AUD in 10 days
(245 Reviews)
7.8
GFsoul

sir please check my profile and reviews i got from different clients and see my portfolio too i can do your project according to your requireemnts

$500 AUD in 12 days
(98 Reviews)
6.1
Expertever

please see our work and lets start your work.Thanks

$500 AUD in 10 days
(3 Reviews)
4.9
YashpalSingh123

php/mysql professional

$550 AUD in 5 days
(14 Reviews)
4.8
informationaccur

Hello, please chk PMB. Thanks,

$734 AUD in 35 days
(8 Reviews)
4.7
heroncosmo

Good morning friend, I am willing in your project, we close, I'm good at it. Hugs

$500 AUD in 30 days
(0 Reviews)
0.0
dangerousinminds

Sir Please Check the message board

$700 AUD in 12 days
(0 Reviews)
0.0
papanbamba

We can develop as per your requirement. u could check that out. we can work till your satisfaction. -- Please check our PMB

$700 AUD in 14 days
(0 Reviews)
0.0