Stack Overflow
Stack Overflow

Questions tagged [time-and-attendance]

Time and Attendance systems are those that keep track of people's comings and goings. Typically this refers to employees working in a business. However it can also be used in other contexts, such as students attending a class.

Time and attendance systems are those that keep track of people's comings and goings. Typically this refers to employees working in a business. However it can also be used in other contexts, such as students attending a class.

There are a whole range of technical problems involved with this category of business systems, such as:

  • Date/Time Set and Interval mathematics
  • Nuances of date and time in the real world
  • Pattern recognition in event streams
  • Business rules engines
  • And much more.

Time and Attendance systems also tend to overlap (Venn diagram style) with the following:

  • Payroll Systems
  • Scheduling Systems
  • Access Control Systems
  • Employee Benefits Systems

The broader category of these systems is known as Workforce Management.

StackOverflow is not the place to discuss commercial Time and Attendance products. However, there are many programming problems associated with building these products, or integrating with them, that may be appropriate if phrased properly.

Also appropriate are generalized questions that would be useful if building an in-house Time and Attendance system.

165 questions
0
votes
1 answer

Time Attendances query in Microsoft Access

I'm having troubles with writing a query in Microsoft Access. This is how my table looks like and where i want to retrieve data from: I want to write a query that has the following result: As you can see in the first table an employee can check…
Tan Nguyen
  • 21
  • 6
0
votes
0 answers

unable to write to socket [1]: Operation not permitted in web server but working ok on localhost why?

I am trying to connect to a attendance device on ethernet by ip address and get data from it. I am working with zklib library for this. Problem is it is working ok in localhost but when I am trying on web server it is showing A PHP Error was…
M. Alim
  • 153
  • 16
0
votes
0 answers

Taking Attendance in Django Python

I am trying to mark attendance. But I am not able to get the code. My submit should send the input to database for each student. Any suggestion for doing this in better way is welcome. My models.py is as follows It has Employee, Mentor and Student…
Ishma
  • 1
  • 1
0
votes
0 answers

MYSQL aggregate report on Student attendance count by week and per day

I have a challenge to report on attendance for students per unique week per day for a given date range. So I currently can extract weekly attendance per day but it summed (aggregated) over the days of the week, so that if there were 4 weeks and 4…
luhfluh
  • 487
  • 2
  • 8
  • 26
0
votes
1 answer

Calculate absence time in day for employee

I have table to store attendance data of my employee as below: EmployeeID| Date |EnterTime|ExitTime| 1 |2017-01-01|07:11:00 |15:02:00| 2 |2017-01-01|07:30:00 |12:00:00| 2 |2017-01-02|07:00:00 |15:00:00| 1 …
MahdiIBM
  • 55
  • 7
0
votes
1 answer

How to do multiple selection in radio button in HTML

Here https://i.stack.imgur.com/by7Y0.jpg is the screenshot of attendance panel what I want to make. I am making an attendance panel but I am not able to select single radio button in single row which is iterating in a loop and on submit value of…
Sambhav Khare
  • 61
  • 3
  • 9
0
votes
1 answer

How to add multiple row values into database with php codeigniter

I'm trying to make a school attendance tracker with codeigniter. I don't know how to get both the Student_no AND the radio button value Present or Absent to enter into the database. The values of student_no and the radio buttons are both being…
Glen
  • 3
  • 2
0
votes
0 answers

Matching user time logs to day shift in an attendance system

I'm trying to create a simple attendance application with Laravel. I'm just a little stuck with the logic side. What I'm trying to do is to match up the time logs of users to the correct schedule. So in our office, we could have from 2 to 3 breaks,…
kazuo
  • 297
  • 1
  • 6
  • 15
0
votes
0 answers

Attendance application useing Qrcode c# winform

i have been searching everywhere for an example to create Attendance system using Qrcode. As Employee having cards with Qrcode with their details like Employee Id, Name, Position. Fixed Qrcode Scanner/Webcam attached with Computer (Device…
Bukhalifa
  • 13
  • 1
  • 8
0
votes
1 answer

barcode scanner can not connect to the application to call the data from the database

I am currently working on software for student attendance. I use the flex / flash and php to create the software but I faced a problem barcode scanner, can not connect to the application to call the data from the database when students scan the…
richard
  • 1
  • 1
0
votes
0 answers

How to get an employee's attendance if it does not log out on a particular date

I am looking for some basic attendance logic. What I have done so far is that employees can click on two different kinds of buttons and mark themselves as Signed In, Signed Out (status 1 and 2) using one button and Break Start, Break Over (status 3…
Kapil Sharma
  • 1
  • 1
0
votes
1 answer

convert join query into nested query

how to convert this query into a nested query which uses where in condition? SELECT schedule.subcode,attendance.usn,avg(attendance.ispresent)*100 as Attendance_Percentage FROM schedule JOIN attendance ON schedule.sched_id=attendance.sched_id WHERE…
Haadi Owais
  • 3
  • 3
0
votes
1 answer

In / Out Update Attendance System SQL Yii2

I have this cases if Button "In" clicked,it will create a new record for attendance.and if Button "Out" clicked,it will update the record created from the new record before. for cases like this,it should be done on SQL using query,or on Yii itself…
Bakti Wijaya
  • 447
  • 1
  • 6
  • 21
0
votes
0 answers

Communicate and Download data from attendance Machine in LAN with JAVA

I am trying to make an API to read from attendance machine. I find the port from which it is communicating and made successfull connection to it by Java Socket Programming. Now I am trying to get data from it but don't know how to do it. I tried…
jatz2012
  • 31
  • 9
0
votes
0 answers

rsInvalidAggregateScope error in SSRS Report

Dataset: select col1, col2, col3, Possible_Duration, Present_Duration from table I am designing a report which shows student data and calculating attendance as SUM(Present duration)/SUM(Possible duration) in an expression. Detail text…
Aruna Raghunam
  • 903
  • 7
  • 22
  • 43
1 2 3
…
10 11