Pa help sa algo sa pag compute ng attendance.. :)

[xloverboyx]

Sino jan yung may algorithm sa pag compute ng Attendance based sa schedule na naka setup per employee. Nakakalito kasi. Given this scenario for example:

Schedule of Employee:
TimeInAM=8:00 AM
TimeOutAM=12:00 PM
TimeInPM=1:00 PM
TimeOutPM=5:00 PM

LogIns of Employee:
AM In=7:55AM
AM Out=12:04 PM
PM In = 12:57 PM
PM Out = 5:10 PM

Ang gagawin is dapat ma-capture ng Attendance program kung saan na belong ang mga LogIns, kung In or Out ba sa AM, or di kaya In or Out sa PM.

Any suggestions po para madaling ma calculate to. Any language lng po, ok lng din po kung nka pseudo code. Gusto ko lng malaman ang logic sa pag compute neto.

Aside from this marami pang mga conditions na isisingit like yung late at undertimes, yung multiple logins, pero yung basic lng muna, sana ma tulungan nyo ako.. Hehe.. Matsalam!

 

[lobaloba000]

Schedule of Employee:
TimeInAM=8:00 AM
TimeOutAM=12:00 PM
TimeInPM=1:00 PM
TimeOutPM=5:00 PM

LogIns of Employee:
AM In=7:55AM
AM Out=12:04 PM
PM In = 12:57 PM
PM Out = 5:10 PM

maraming ways TS

start
Check if "AM" or "PM"
then Capture whether it is "AM" or "PM"
Check if employee has "TimeIn"
if true
then "TimeOut" na gagawin niya
else //meaning wala pa siyang "TimeIn"
then "TimeIn" gagawin niya
end

or

start

let clock = ((currentClock == 'AM') ? 'AM' : 'PM') //CurrentClock para kunin mo kung yung currentTime ba is 'AM' or 'PM'
Check if employee has "TimeIn"
clock // clock will be 'AM' if the value is true and 'PM' if the value is false
"TimeOut"
else
clock // clock will be 'AM' if the value is true and 'PM' if the value is false
"TimeIn"

end

I hope it helps

 

[nicetryghw]

Sino jan yung may algorithm sa pag compute ng Attendance based sa schedule na naka setup per employee. Nakakalito kasi. Given this scenario for example:

Schedule of Employee:
TimeInAM=8:00 AM
TimeOutAM=12:00 PM
TimeInPM=1:00 PM
TimeOutPM=5:00 PM

LogIns of Employee:
AM In=7:55AM
AM Out=12:04 PM
PM In = 12:57 PM
PM Out = 5:10 PM

Ang gagawin is dapat ma-capture ng Attendance program kung saan na belong ang mga LogIns, kung In or Out ba sa AM, or di kaya In or Out sa PM.

Any suggestions po para madaling ma calculate to. Any language lng po, ok lng din po kung nka pseudo code. Gusto ko lng malaman ang logic sa pag compute neto.

Aside from this marami pang mga conditions na isisingit like yung late at undertimes, yung multiple logins, pero yung basic lng muna, sana ma tulungan nyo ako.. Hehe.. Matsalam!

Very Basic TS.

Wag ka gumamit ng Date Time,
Gawin mo syang numeric para macompute mo. Pag ganyan logs mo TS dami mong problema d mo magagawa yung sa Late and Undertime kasi how about nagnight shift sya e di next day ung out nya.
Column mo si meron kang Date na datetime, then logs un ung halimbawa
Date:04/18/2018
Logs:7.55,12.04,12.57,17.10