Search for project

More than 2000 projects issued through our platform and this
amount increases very fast.

web site development (ID:3641)

Project Creator: juliandean
FC Member For 6406 Days
Credits 20
Completed Proj. Num. 0 / 1
Total payment USD 250.00
Avg Daily Online
0.00 h (From 21/5/2007)
Available on MSN/Skype No
Last Login 10/24/2008
Peers Rating 0.00%
      
Budget: Less than 250
Created: 12/28/2007 9:27:56 AM EST
Bidding Ends: 1/2/2008 9:27:56 AM EST
( Expired )
Development Cycle: 10 Days
Bid Count: 23
Average Bid: 236.70  
Project Description:

I need web site that allows users to login & access information from a database. Usernames and passwords will be stored in the database. Users must be able to create new data records & view or edit their own data records. Technology is apache + php + mysql on windows.

Newly added descriptions:
The database design is intended to allow administrators to manage users and document templates, and to allow ordinary users to create new document & versions based upon those templates.

All id fields in this database design are numeric, and all other fields are text unless otherwise stated. DateTime values will be stored as text in the format "yy/mm/dd hh:nn:ss".

The entire site must be secure, and protected by SSL encryption. Session security can use cookies. The home page of the web site will require user login, which will be verified against the usernames and passwords in the database.

The look'n'feel of the web site should be defined by CSS templates, so that it can be easily modified in future, or even "skinned" for particular groups of users.


The configuration for the web site is contained in 4 tables:
- group table contains {id, name}
- user table contains {id, name, password, groupId}
- template table contains {id, name}
- item table contains {id, name, itemOrder, templateId}

if no users exist then the following user will be created on startup:
- {0, "administrator", "password", 0}

if groupId = 0 does not exist then it will be created on startup:
- {0, administrators}


The data for the web site is contained in 3 tables:
- document table contains {id, name}
- version table contains {id, documentId, datetime}
- data table contains {itemId, versionId, itemValue}

The administrators will be able to list / view / create / modify / delete any table. This functionality is designed to give full administrative control over the contents of the database, and is distinct from the ordinary user access, which is intended to provide business functionality. Hence, the access provided needs to be very flexible, but does not need to be particularly easy to use.

The administrator functionality is:
- select table {group / user / template / item / document / version / data}
- results will be sorted by second field in the table, which is normally "name", followed by the first field
- display first 50 records, with option to filter, or create new record, or edit selected record
- filter will perform a sub-string match against the "name" field (by default)
- filter for version or data tables will match against the name of the document
- edit selected record

Ordinary users will only be able to list / view / create documents, versions and data. This is the business functionality of the web site, and must be very easy for the user to operate.

the ordinary user functionality is:
- filter by document name and/or DateTime
- display filtered list of versions, showing document name and version date, then allow user to select a version
- results will be sorted by document name followed by version dateTime
- display the version info, starting with a summary, followed by each item name & value, displayed on a separate line
- items will be sorted by "itemOrder" followed by itemId
- allow user to modify the displayed items & create a new version (automatically set the version dateTime)
- allow user to create a new document, specifying the document name, and selecting the template from a list
- creating a document automatically creates a version & creates data records for each item specified in the template
- allow user to modify the items before the document, version and items are saved





Job Type PHP 
Attached Files: N/A

Bids placed

(There are 23 bids on this project, these are listed below)
 
Contact*:
Email*:
Telephone:
(Include country code)
Enquiry*