status report tool (SRtool)
===========================
The status report tool makes it easy to input and report on the status of projects or individual tasks. The tool breaks down and organizes the reports by teams or groups, making it ideal for departments or development teams to collaboratively manage their projects.
The status report tool is a simple interface to help groups manage and report status on projects. It's main purpose is to provide a vehicle to deliver project and task information to management in real time. The app is written in PHP and stores all information in a mysql database for quick and easy report generation. The user database is based on LDAP. It was tested and implemented on Redhat Linux.
The app was designed so that an IT department (or any other department) can report the status of projects to the management team every week. Previously this was accomplished by each team passing around a Word doc... It was ugly...
Currently the app is functional, but there a still some things that need to be added for portability and additional functionality. Please see the TODO file for more info.
Requirements
------------
* Apache
* PHP
* MySQL
* LDAP (Currently authenticates with LDAP, should be easy to change to MySQL auth. The auth.php page is the only thing that does authentication, once authenticated, a session is kept on the server. All of the other pages check that a session is active.)
Installation
------------
1. untar srtool-x.x.x.tgz into your webroot (or create a virtualhost in apache to point to where you put the directory), and rename the dir. *note* it is a good idea to do IP based virtualhosts and use SSL since we are passing usernames and passwords...
tar -xzvf srtool-0.4.1.tgz -C /var/www/html/
mv /var/www/html/srtool-0.4.1 /var/www/html/srtool
2. change the db passwd (optional)
replace the 2 instances of status_pwd in /var/www/html/srtool/etc/createdb.sh
set the mysql server settings in conf.php
3. run the script that creates the database
cd /var/www/html/srtool/etc/
./createdb
4. configure ldap access
change ldapServer variable in auth.php to the name of your ldap server
5. change the redirHost variable in conf.php (this is used to redirect the browser after a form is completed, I am sure there is a more elegant way of doing this)
That's it...
Go to the site and login as a user you have defined in ldap. The first time any other user logs in, they will be asked to enter their full name and the group they belong to. This will add the user info to the database so they will not be asked again.
Some of the custimization currently needs to be done in the php pages, the css file or conf.php. I am working on making a lot more customizable in conf.php.
SRtool Project Page