4 hours rewrote the SQL for index.php to something much simpiler. I was originally working towards "grab all the info, just in case" but instead rewrote it to grab exactly what was needed. Also, in doing this, it was possible to do it all via SQL instead of using a unique PHP function. I will need to apply this to the other two display functions on index.php I am going to seperate the index.php and view_all routines. I would like for index.php to just be a intro / overview, whereas to view all of a given type of project would be better on its own page. Plus, in doing this, it would be even easier to recycle code.
Additional pages and progress: each display mode is going to need an admin option (or 4) view project page will need to have manager and admin functions important distinction: admin != manager, though an admin could add themselves as a manager can users create projects? needs to be an option. if so, users become managers of their project managers can add managers, and managers can add users managers can remove managers, but not the manager who created the project users can view public projects, but only managers can add
I think that makes things a heirarchy... project creation: admins create through cp project managers don't create users (if enabled) can create, and then become manager of that project [config option]
project modification admin: can modify any project manager: can modify any project they are a manager of users: can not modify project
task: creation admin: can create a task for a project, and assign a project team member to it manager: can assign a member of that project's team to a task the manager creates user (if allowed) can create own task and become first user assigned [db variable]
task modification admin: can modify any task manager: can modify any task in their project user: can only modify task if they were allowed to create tasks (same property)
task status update admin: can change status of any task manager: can change status of any task in their project user: can change status if they are assigned to the task
I think that's it for now
In response to "NetProject: 01/09":