Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 5 of 5

Thread: expenses script

  1. #1
    New Coder
    Join Date
    Jun 2002
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    expenses script

    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.
    Regards

    Homer

  • #2
    Super Moderator
    Join Date
    May 2002
    Location
    Perth Australia
    Posts
    4,040
    Thanks
    10
    Thanked 92 Times in 90 Posts
    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.
    resistance is...

    MVC is the current buzz in web application architectures. It comes from event-driven desktop application design and doesn't fit into web application design very well. But luckily nobody really knows what MVC means, so we can call our presentation layer separation mechanism MVC and move on. (Rasmus Lerdorf)

  • #3
    New Coder
    Join Date
    Jun 2002
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    expense sheet problem

    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.

    Regards

    Homer

  • #4
    Regular Coder dniwebdesign's Avatar
    Join Date
    Dec 2003
    Location
    Carrot River, Saskatchewan
    Posts
    838
    Thanks
    15
    Thanked 9 Times in 9 Posts
    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.
    Dawson Irvine
    CEO - DNI Web Design
    http://www.dniwebdesign.com

  • #5
    Regular Coder dniwebdesign's Avatar
    Join Date
    Dec 2003
    Location
    Carrot River, Saskatchewan
    Posts
    838
    Thanks
    15
    Thanked 9 Times in 9 Posts
    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
    Last edited by firepages; 12-31-2003 at 03:39 AM.
    Dawson Irvine
    CEO - DNI Web Design
    http://www.dniwebdesign.com


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •