we want to do a system for our work..
the system is in spanish, english is not my native language,
but i can help you with the translations
i will explain the details the best i can,
we have a clock checker and we can export all the data to a txt file
se attachment
i///////////////////////////////////////////////////////////////////////////example./////////////////////////////////////////////
REPORTE DE CHECADAS ", 3:27 pm,"Trabajad:","Nombre Trabajador","Fecha","Hora","Reloj","Depto.","Categ.","Turno","Supervisor","Tipo de Checado","00000053","VELA MARQUEZ","JULIO CESAR","Sa",6.00,"-DIC",2008.00,"12:45","GEN","06","002","","",30,"EMPLEADO CONFIANZA E IDENTIFICACION","Pag:",1," [FECHA INICIAL:] 06/12/08 [FECHA FINAL:] 12/12/08 [CLASIFICADO POR:] CODIGO DE TRABAJADOR [ORDEN:] ASCENDENTE "
Jueves, 18/12/08," REPORTE DE CHECADAS ", 3:27 pm,"Trabajad:","Nombre Trabajador","Fecha","Hora","Reloj","Depto.","Categ.","Turno","Supervisor","Tipo de Checado","00000053","VELA MARQUEZ","JULIO CESAR","Sa",6.00,"-DIC",2008.00,"12:46","GEN","06","002","","",30,"EMPLEADO CONFIANZA E IDENTIFICACION","Pag:",1," [FECHA INICIAL:] 06/12/08 [FECHA FINAL:] 12/12/08 [CLASIFICADO POR:] CODIGO DE TRABAJADOR [ORDEN:] ASCENDENTE "
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
00000053 is the id
you can see that the name of the employee is VELA MARQUEZ JULIO CESAR
next to it is "Sa": stands for saturday 6 december 2008 he arrived at 12:45 and on the next report he went home at 12:46
okk.. i know. he only work one minute ..jeje someone on that date made a mistake and got the wrong card
this file is going to be exported weekly
our week starts on saturday and ends on friday
so we need on our system something to select that specific file for the week and
what we need from that file is to get the "work hours" dates, name of the employer, id,
after that, we need to manage our employees and make a report for every employee with the following details
a) signup new employee, make changes, and termination
1 tell the system how much the employer earn for hour
2 if the employeer arrived early all the week gets a bonus and we need to set the limit of minutes
3 extras for example is the employer work extra hours
4 extras quality of the work,.. sometimes people work harder than anyone else and the get another bonus
5 loans example, someone needs money, so we lend the employer money, and he will pay "x" amount of money weekly and will be deducted from the total of the payment
6 loans this type of loan is the same as above but the total loan will be deducted at the end of the week only
7 total paid...