I need modifications to the following version of Project Pier
http://www.projectpier.org/projectrelease/projectpier-087beta (make sure you use 8.7 beta)
———————————————————————————-
Modifications needed:
1) Add sign-up form with username, password, password repeat, sub-domain (this is a new field)
2) Create new global site/users table that includes admin username, site id, sub-domain, create date, last login, project count, milestone count, user count, message count, task list count, task count, link count, file count, size of file directory (updated on each upload)
3) Upon successful signup, a duplicate set of database tables needs to be installed for each user (like wordpress multi-user)
3b) Upon successful signup, an email with username, and site URL (newsite.mysite.com) needs to be sent to user
4) The site DB logic needs to be altered so that upon logging in, users are using the correct set of DB tables for their site (key on site ID)
5) The site file storage logic needs to be altered to create sub-directories for each sign-up under the main file storage directory (so sites can’t overwrite each others files)
6) The platform allows user creation within each install. Created users will exist only in the DB tables for each account (current behavior). The login script needs to be modified to look for sub-domain so that users of each account ( subdomainname.projectsite.com ) login to the correct set of database tables. I will add a mod-rewrite rule to pass the sub-domain to the login page as a variable. (like wordpress multi-user)
7) Need an admin page that shows all global ‘sites’ with the data tables requested in # 2 above (sortable by each metric), paginated at 25 results
8) Need a delete site option on this admin page that deletes all tables associated with the site, as well as the file folder for that site
http://www.projectpier.org/projectrelease/projectpier-087beta (make sure you use 8.7 beta)
———————————————————————————–
Here is the desired user signup flow after modifications are complete:
1) User visits mysite.com and uses signup form to create a new account.
2) Upon signup, a new set of db tables is created to support this user at the sub-domain they created at signup.
(DB tables could look like site1_tables )
3) User is sent an email to welcome them to the site and give them their username and url to their new site
4) User can then visit either mysite.com or subdomain.mysite.com and login to their account
5) As the user sets up their account, the DB tables created for them are used, and the newly created sub-folder for their uploaded files is used
Selected developer will have experience with PHP & MySql (Project Pier uses a view/model/controller model), and will need to install the software on their own development machine. All new code and modifications to the existing code need to be well documented for easy future reference.
Thank for your bid. Preference will be given to developers that can start on the project ASAP.
