web based clocking in system?

AHarvey

AHarvey

AHarvey

Soldato
Joined
6 Mar 2008
Posts
10,084
Location
Stoke area
Hi all,

At work we currently do not have any form of clocking in and out and all time sheets are done manually which is a real pita!

How easy would it be to create a secure web based clocking in and out system that could not only record total hours worked including overtime/night/holidays and sickness but also be able to print off a list of all office based workers in case of fire?

I am guessing a PHP/SQL based solution will be suggested but my knowledge in it is very limited!

Thanks
 
Are there multiple office locations you'd need to do this from?

If not I'd do it with a windows app and database backend of your choosing. I made one years and years ago (VB5 + Access... whatever version was before 2000!).

The front end was just a dropdown of current jobs, a start/end button, and another button to be used when on phone calls to pause time on the job you're working on. It would then minimize to tray until needed again when changing jobs.

If you have limited knowledge it could be a bit tricky though.
 
you could probably do it...

check for a record on today's date... if there is no record then your clocking in... which would create a new record with today's date, the time they clicked the link (to clock in) and a Boolean for if they're clocking in or out (1 or 0)

If there is a record for today in the database then you'll be clocking out...

PHP is quite good with date and time comparisons... you could make a secure web page with each users username and password stored in a database so they can only access their own records and hash the password using PHP

the total hours worked would probably be easy enough to work out but working out if the hours done included overtime etc. may be a bit more difficult... but probably do-able.
 
Thanks for all the comments and suggestions, we currently have several departments for our accounts spread out between home and office.

Our offices are based all over the place as well hence the reason for a web based solution.

However I may try and develop one just for my departments chat & customer support areas.

Good reason to learn php/sql I suppose :D

If I can't do it I'll write up a design and send it to our web guys :D
 
I would say that PHP/ASP and a database would most likely offer you everything you'd need to build something like this if you wanted to take a web-based approach, but how easy it would be is determined by system complexity and how confident you are with the programming tools available.

A system where the user inputs details will probably take less time to build than something that is automated though.

I'd sit down and discuss what the system needs to do with the various people who'd be using it and then you can get a better grasp of how big a project it's going to be :)
 
You must log in or register to reply here.
Back
Top Bottom