Php and Database Site Design

We need some web pages in php (object oriented preferred) and a database mysql to implement the following features: 1)one table with our products and their key characteristics. This table should have the following fields: "Unique Id" for the product, "product name", "version number", "Operating System", "Other" field. 2)one table with the users of our products and the administrators. The fields should be Unique User ID, name, surname, Valid Email, password, User Level (Admin, Customer, etc..). 3)A Sales table to link the users to the products. We expect each record of this table to have a unique Id, a User Id, a Product Id, and the following fields: Registration name, Registration Code, Other Registration ID, Registration Date 4) Allow users to be registered into the database (with a newsletter subscription mechanism). 5) Allow users after log-in to register a purchase of a product. We define two levels of user and we expect to have a different control panel for them: one for the administrator and one for the customer. Other levels are not part of this project. 5a)Administrator Control Panel We need access to the following tables and full administrator rights to add records and maybe also deleting and editing. Tables: Users, User Levels, Products, Sales 5b)Customer Control Panel Must consist of two pages. One to display info about his purchase records, and one to let users register a purchase. User shall fill-in the registration data for his purchase and the data entered should match the criteria that we will write in a key-generator which is a function in a separate script. The code inside this function is not part of this project but must be implemented empty for us to be filled with our algorithm. Only users that pass validation function should be allowed to register a purchase. 6)We need ability for administrators to upload files using the control panel, the files are for customers to download. We want the ability to set a date range during which the file can be downloaded. 7)Finally admin. should be able to send emails to all users that have purchased a given product from the control panel. We will provide a basic html template in which to insert the php modules. ## Deliverables We are a software company and we need some web pages written in php (object oriented highly preferred) and a database mysql to implement the following features: 1)one table with our products and their key characteristics. This table should have the following fields: "Unique Id" for the product, "product name", "version number", "Operating System", "Other" field. We will need an interface as administrators to add our products to this table when needed. 2)one data table with the users of our products and the administrators. The fields should be Unique User ID, name, surname, Valid Email, password, User Level (Admin, Customer, etc..). The user levels should be in a separate table so that we can add new records to it. The USer Levels table should have unique ID field and a hierarchy index field, so that we can establish for each level the number in the hierarchy. For example Administrator Level could be 0, Customer Level could be 1. Of course we can later change the record if it fits our need, adding new user levels and new numbers. 3)One cross table. This table could be named Sales to link the users to the products. We expect each record of this table to have a unique Id, a User Id, a Product Id, and the following fields: Registration name, Registration Code, Other Registration ID, Registration Date 4)Database and scripts must be compliant to highest security standards. The developer which is willing to work on this project must state clearly before the work which measures he /she is willing to adopt to make sure that there are no security holes in the code or in the database permissions, including the version of php his/her code is going to be compliant with. Also we expect an adequate documentation for the mantainence of the database and of web code. 5) Allow users to be registered into the database (with a newsletter subscription mechanism). This is the first step to define the user data. This can be achieved through a simple interface where the user must fill a form. The form will call the registration script to verify whether the user is already in database, if so a message will warn the user he is already registered. In case the user does not appear in the database (by verifying the required email field) a verification of email procedure must be completed to insert the user successfully in the database. Public Forms should have a captcha mechanism to avoid spamming. 6) Allow the Login of existing users by a login module with the use of password and email. Login should have a password recovery procedure. 7) Allow users that have successfully logged-in to register a purchase of a product. When they login the user will access a control panel. We define two levels of user and we expect to have a different control panel for them: one for the administrator and one for the customer. Other levels are not part of this project. 7a)Administrator Control Panel We need access to the following tables of the database and full administrator rights to add records to the table. We do not require the delete and edit existing records ability in this interface. Tables: Users, User Levels, Products, Sales 7b)Customer Control Panel Must consist of two pages. One to display to the user a welcome text and the information about his purchase records, and another one is to let the user to register a purchase by him/herself. The first page must list all the relevant fields of the purchase records of the user. The second page should have a form where the user can fill-in the registration data for his purchase and eventually add a record to the sales table. All relevant fields of the sales table must be available for the user to be filled. Users may not register the same product multiple times if they use the same registration data of the product. The requisite for the registration is that the registration data entered match the criteria that we will write in a function in a separate script. This function is the key-generator for our product that compares the Registration Data in the input with the ones it generates. The code inside this function is not part of this project but must be implemented empty for us to be filled with our algorithm. Only those users whose input data for the purchase will pass the validating function should be allowed to register a purchase. 8)We also would like ability for administrators to upload files using the control panel, the files are for customers to download. We need customers that purchased a given product to be able to download a given file. We want also the ability to set a date range during which the file can be downloaded. The customer should be able download the file from the welcome page of his control panel or from a separate page. How to implement this feature exactly can be discussed with the bidders. 9)Finally it is needed the ability to send simple emails to all users that have purchased a given product from the administrator control panel. 10)All forms and web pages must be easily integrated in our chosen web-site layout. We will provide a basic html template in which to insert the php modules. We will be more than glad to evaluate candidates profiles for this offer and to further work with the chosen candidate in the future for extensions of this project. * * *This broadcast message was sent to all bidders on Tuesday Jan 31, 2012 5:18:12 PM (by sub-account person id [#8115140][1]): Please Read more carefully the Project Description, it has been updated and in bigger font size. It is clear in terms of our requirements. Make your bid please in $ * * *This broadcast message was sent to all bidders on Wednesday Feb 1, 2012 3:51:51 PM (by sub-account person id [#8115140][1]): For the bidders who asked, there is no need for payment onsite, that's why our budget for this project is low. We already have a merchant that provides the keys and data for our users. We only need a system to store these data on our site, to manage the relation with our users and give them some downloads, keep them informed about our offers, etc..All specifications have already been given, there is no other requirement for this work.