12-24-2003, 10:24 AM
I need to include a script on my company web-site that will allow employees to enter their monthly expenses in an on-line form, this form can then be submitted to their department for processing.
I have seen a few timeshet scripts for sale but these are much too complex (and expensive) so any ideas on this type of script would be much apreciated.
12-26-2003, 04:45 AM
its a big question unless we know
1) if you have a database available (and then which one)
2) what format you wish to present the data in to thier department .. ? view online , convert to spreadsheet , transfer into system database , just email results ..etc ?
note you do not need a database but it would be easier with than without.
12-27-2003, 06:49 PM
Currently we are using the archaic method where at the end of every month each member of staff (over 80 people) are required to enter details [name], department] etc, plus details of their expenses - [date],[journey from], [journey to], [milage], [subsistence] on to a paper form and then fax this form to the accounts department for processing.
I am desparate to change this problem so that each member of staff can acces an on-line form, enter the relevant details and at the end ot the month submit these details to the accounts dept. (All memebers of staff have access to the web).
I have administration access to the server and have MySql available. As for which format would be best to view the data then I am open to suggestions.
Thank you for replying to my question and hope you have a solution available.
12-30-2003, 10:24 PM
If you have MySQL you could have it set up so each department has a table and then when the user posts the information it adds it to the department he specified. Then have an admin or secure area where the departments who view them could log in and view them. Each department could only have access the thier reports but there is an overal admin which can change permissions. (Probably you I presume). But this may be easier said than done. But it would allow you to customize the look of the report and if needed print it out. Just and idea.
Once the expense report is finished it can be removed from the database by you or the expense people, or marked that it has been completed.
12-30-2003, 11:06 PM
Sorry Dawson , if you want to make commercial offers you will have to do so in a PM , this it not the place for such