296039 PHP Program

Here's the details of Project 2: 1. A PHP password protected area 2. Admin will set up rep accounts with unique usernames. -Data will be: username, password, firstname, lastname, address, address2, city, state, phone, cell, email, social security number, total_sales, percentage, commission, account-length -Data will be saved to table 'salesreps' -Email confirmation sent to sales reps when added to system. (full customization) 4. Admin will allow admin to search delete and edit user's details of reps and customers. - Search for reps -Search for customers 5.. PHP will generate 8 character passwords. 6. Cron will run a PHP script that will automatically make rep's account inactive once 'account-length' has been passed. 7. Once logged in, system will show a "Add Customer" screen with a form: First Name Last Name Email address Address Address2 City State Zip Phone cardedition (drop down menu) with Utah County-2for20, Rexburg-2for20, Pocatello-2for20, Utah County 15, Rexburg 15, Pocatello 15, purchasedate (Drop down menu, with javascript popup date adder) customer_type (drop down menu) Student, Family Hidden field, Salesrep, taken from username used to login. 8. When submitted, data will be save to mysql table 'customers' 9. After form submitted, confirmation screen will show form again so user can submit more customers. 10. Admin will be able to see total sales count, and sales per rep, , and total commissions. Commission should be shown for up to 3 levels. 11. Allow for uploading of a CSV file with data for 'customers' table via admin 12. Makes backups of database to a backup folder each night at 1am server time. TABLE STRUCTURS: Table MYSQL stuctors are already set up. Please ask questions before bidding.