Get Employee Total Working Hours (Missing)

Antony_Raj · December 8, 2019, 10:04pm

Hello,

The new employee checkin feature is nice, however is there any option to get employee total working hours?

kartik · December 9, 2019, 6:10am

Yes. When attendance is marked it adds number of hours worked also based on the employee checkin records for that particular day.

github.com

frappe/erpnext/blob/version-12/erpnext/hr/doctype/employee_checkin/employee_checkin.py#L120


      
          			return attendance
          		else:
          			frappe.db.sql("""update `tabEmployee Checkin`
          				set skip_auto_attendance = %s
          				where name in %s""", ('1', log_names))
          			return None
          	else:
          		frappe.throw(_('{} is an invalid Attendance Status.').format(attendance_status))
          
          

          
def calculate_working_hours(logs, check_in_out_type, working_hours_calc_type):
          	"""Given a set of logs in chronological order calculates the total working hours based on the parameters.
          	Zero is returned for all invalid cases.
          	
          	:param logs: The List of 'Employee Checkin'.
          	:param check_in_out_type: One of: 'Alternating entries as IN and OUT during the same shift', 'Strictly based on Log Type in Employee Checkin'
          	:param working_hours_calc_type: One of: 'First Check-in and Last Check-out', 'Every Valid Check-in and Check-out'
          	"""
          	total_hours = 0
          	in_time = out_time = None
          	if check_in_out_type == 'Alternating entries as IN and OUT during the same shift':

Antony_Raj · December 9, 2019, 6:22am

Where to find it in reports?

kartik · December 9, 2019, 12:49pm

In the Attendance doctype listview, on the left sidebar, click on Report Builder.

Click Menu button on right side
Pick Columns
Check working hours option in the popup and click submit.
Refresh report. You should now have a column with working hours.

Salman_Tah · December 9, 2019, 1:01pm

kartik can you help me

kartik · December 9, 2019, 3:33pm

Please post your query.

Salman_Tah · December 10, 2019, 10:30am

Select
c.name as “Attendance Name:Data:150”,
(select employee_name from tabAttendance where name = c.name) as “Employee Name:Data:120”,
(select department from tabAttendance where name = c.name) as “Department:Data:120”,
(select check_in from tabAttendance where name = c.name) as “Check in Time:Data:50”,
(select check_out from tabAttendance where name = c.name) as “Check Out Time:Data:50”,
(select working_hours from tabEmployee where employee = c.name) as “Working Hours:Currency:80”

from tabAttendance as c . I need check_in check_out get total Hours working brother

kartik · December 10, 2019, 10:40am

This might not be possible with query report. You will have to create a custom report.

clarkej · December 10, 2019, 3:19pm

See also Query Report - Query report Path on Server Side

Salman_Tah · December 11, 2019, 10:47am

Ok thankyou, Can you help me what i should start Custom report can you help me to this

clarkej · December 11, 2019, 4:05pm

This notes the three Custom report options you could use https://erpnext.com/docs/user/manual/en/customize-erpnext/articles/making-custom-reports-in-erpnext

So if neither the Report Builder nor Query reports meet your needs, your third option is to develop a Script report

Salman_Tah · December 12, 2019, 10:07am

Thankyou for this, can you guide me how to develop Cumtom Script report

tuguldurdmt · February 6, 2020, 8:53am

Hello, If there is only one log from employee checkin log how can i calculate and put value in total working hours as like half day of 4 hours. There is settings in shift type is if status is half day put work hour in 4 but when auto attendance in generated after working hour value is 0 !

Raymond_Liew · February 6, 2020, 10:19am

I know this is out of your question, but would you mind to share how you customize for the “Working Hours (min)”, “Over Time (min)”, “Late Entry (min)” and “Early Exit (min)” calculation?

kartik · February 6, 2020, 11:54am

These settings are part of Shift Type doctype. After enabling mark auto attendance, these settings section will be displayed.

tuguldurdmt · February 7, 2020, 2:20am

All these calculation of field is custom coded in server side of processing auto attendance in shift type py and employee checkin py

iMoshi · February 7, 2020, 3:00am

@tuguldurdmt welcome.

We need to look into “Timesheet” as well.

ahmedalisync · February 20, 2020, 9:51am

Hi all ,
Thanks for your efforts.
I want to know why all work hours is 0 although there are check ins and check outs
Thanks in advance
Ahmed Ali

tuguldurdmt · March 10, 2020, 2:49pm

Because it was only one attempt from log file. If any of employee make only once attempt tried in working day there is only one log file will come at program so it can not calculate working hours thats why its makes 0 value throws back

Hana_a_Salah1 · March 31, 2020, 6:31am

Hi
I’ve tried this , but the working hours shown as 0