Looking for a programmer to write a program for me. Asking for those interested to submit how much they would charge to create the script. Below is a description of project.
I want the project written in php maybe some javascript and utilizing a mysql db.
The office I work for is having trouble with losing requests for money because it has to be submitted and approved by many layers of people. I am looking for an app that our office could utilize to help us keep track of these requests. The organization works with troubled children and often a counselor needs to request money for a child. this paper request form must go through at least 3 levels of approval before it makes its way to the finance department to be cut as a check. Oftentimes the process is slowed and paperwork is lost and no one ever really knows the status of any particular request. I want to streamline this process to make everyone's lives easier and simplier.
Below is an example of how a particular request might go:
Counselor completes check request form and submits it to his/her supervisor for approval. Supervisor approves or denies request. If denied the request is sent back to counselor with reason why (sometimes this is requesting more information or whatever...comments will be written on the request identifying the reason for denial) If approved the request is sent on to the regional supervisor for approval/denial. If regional supervisor denies request then request is sent back to supervisor with comments. the supervisor then might send it back to counselor. If regional supervisor approves the request then it goes to the regional manager for approval/denial. If the regional manager approves request then it goes to finance to print the check. The check is then interoffice mailed to the regional supervisor to be dispersed to the counselors.
Once a counselor submits a request to their supervisor it is rare for a counselor to know the status of that request for several days. This system should fix this.
the system needs to be setup so that all users can log in and check on the status of each request. Finance needs the ability to mark a request as printed and checks returned to regional supervisor with a date printed and returned. The regional supervisor then needs to be able to mark returned items as dispersed to counselors. The counselor then must submit a receipt to the regional supervisor showing where the money was spent as proof it was spent on the appropriate item. So once the regional supervisor marks an item as dispersed it should go into a que marked as waiting for evidence/receipt. then once the request is marked as
completed it should archive itself. Each request should be able to be viewed even from the archive.
this system could be implemented by multiple offices within our organization. The system needs the ability to specify which office each user is in and keep those separate.
REQUIRED FEATURES
*ability to add new users and for each user to "edit" their profile (password, title, email, etc)
*system should include an email notification system to notify of updates to request.
*system should utilize a login/password system
*system should have administrator which can edit anyone's information
*system should be able to search requests to check on status
*each person should be able to add comments to the request which can be viewed in the history
*requests should be able to be canceled and a comment required as to why it was canceled
*ability to add/edit/delete users, funding sources, etc. (I can provide more info on this)
*supervisors have the ability to add or remove counselors from their team.
*ability to create a pdf report from a request in order to print it.
*Automatic email when request isn't "touched" for XX amount of time. Ability to specify multiple amounts of time and notifications.
example:
10 hours email que owner
15 hours email request submitter
20 hours email administrator
24 hours email everyone (requestor, supervisor, regional supervisor, regional manager, etc.) these should be able to be configured.
*ability to run reports based on date, team, funding source, etc to be printed/viewed on screen.
*ability to have access levels to various parts of system (ie. some reports only certain access levels should have access to)
*quick links for each user such as My Requests, My Que, etc. each of these should list in a table format with basic info displayed...each should have link to display details which will have the ability to add comments, approve, deny, cancel, complete, etc.
I'm sure as I go along I'll think of other things.
I will want to see some examples of your designs. This system needs to be extremely user friendly due to many of the users who will be using it are not computer literate. It should be straight forward and easy to use.
Please remember when submitting your bid that this is for a nonprofit organization and I will be paying for this system out of my own pocket.