how to set IN and OUT

siva nathan

how to set Which is Intime and which is outtime from fingerprint device

I have 2 finger print device ,in that 2 finger print device im punching intime and outtime

Device 1 ==>intime and outtime

Device 2 ==>intime and outtime

im storing both 2 devices intime and outtime a table

how to find which is intime and which is outtime from that record

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

siva nathan9y ago
for example i have 2 device,
device 1==>only im punching intime
device2==>only im punching outtime
like below table

employeeid attendencedate
1 04-01-17 08:12:54
2 04-01-17 08:12:54
2 04-01-17 18:12:54
3 04-01-17 08:12:54
see that above table employyeid 1 punching only intime from device 1 ,not punching outtime in outdevice2,so im selecting intime as outtime like below
employyeid logintime logouttime status
1 04-01-17 08:12:54 04-01-17 08:12:54 IN
2 04-01-17 08:12:54 04-01-17 18:12:54 IN & OUT
3 04-01-17 08:12:54 04-01-17 08:12:54 IN
same way how to find IN and OUT from 2 device,that two device punching intime and outtime
0
Sameer Shaik9y ago
please make your question understandable. whats your database design? dont you have any unique Id(Say EmployeeId/StudentId) to track which record belongs to whom ?
0
Amit Gupta9y ago
As mentioned in your question 'im storing both 2 devices intime and outtime a table'

Then whats the problem?
0