def test_monthly_attendance_sheet_report(self):
now = now_datetime()
previous_month = now.month - 1
previous_month_first = now.replace(day=1).replace(month=previous_month).date()
company = frappe.db.get_value("Employee", self.employee, "company")
# mark different attendance status on first 3 days of previous month
mark_attendance(self.employee, previous_month_first, "Absent")
mark_attendance(self.employee, previous_month_first + relativedelta(days=1), "Present")
mark_attendance(self.employee, previous_month_first + relativedelta(days=2), "On Leave")
filters = frappe._dict(
{
"month": previous_month,
"year": now.year,
"company": company,
}
)
report = execute(filters=filters)
employees = report[1][0]
datasets = report[3]["data"]["datasets"]
absent = datasets[0]["values"]
present = datasets[1]["values"]
leaves = datasets[2]["values"]
# ensure correct attendance is reflect on the report
self.assertIn(self.employee, employees)
self.assertEqual(absent[0], 1)
self.assertEqual(present[1], 1)
self.assertEqual(leaves[2], 1)
def test_monthly_attendance_sheet_with_summarized_view(self):
now = now_datetime()
previous_month = now.month - 1
previous_month_first = now.replace(day=1).replace(
month=previous_month).date()
company = frappe.db.get_value("Employee", self.employee, "company")
# attendance with shift
mark_attendance(self.employee, previous_month_first, "Absent",
"Day Shift")
mark_attendance(self.employee,
previous_month_first + relativedelta(days=1),
"Present", "Day Shift")
mark_attendance(self.employee,
previous_month_first + relativedelta(days=2),
"Half Day") # half day
mark_attendance(self.employee,
previous_month_first + relativedelta(days=3),
"Present") # attendance without shift
mark_attendance(self.employee,
previous_month_first + relativedelta(days=4),
"Present",
late_entry=1) # late entry
mark_attendance(self.employee,
previous_month_first + relativedelta(days=5),
"Present",
early_exit=1) # early exit
leave_application = get_leave_application(self.employee)
filters = frappe._dict({
"month": previous_month,
"year": now.year,
"company": company,
"summarized_view": 1
})
report = execute(filters=filters)
row = report[1][0]
self.assertEqual(row["employee"], self.employee)
# 4 present + half day absent 0.5
self.assertEqual(row["total_present"], 4.5)
# 1 present + half day absent 0.5
self.assertEqual(row["total_absent"], 1.5)
# leave days + half day leave 0.5
self.assertEqual(row["total_leaves"],
leave_application.total_leave_days + 0.5)
self.assertEqual(row["_test_leave_type"],
leave_application.total_leave_days)
self.assertEqual(row["total_late_entries"], 1)
self.assertEqual(row["total_early_exits"], 1)
def test_attendance_with_group_by_filter(self):
now = now_datetime()
previous_month = now.month - 1
previous_month_first = now.replace(day=1).replace(
month=previous_month).date()
company = frappe.db.get_value("Employee", self.employee, "company")
# attendance with shift
mark_attendance(self.employee, previous_month_first, "Absent",
"Day Shift")
mark_attendance(self.employee,
previous_month_first + relativedelta(days=1),
"Present", "Day Shift")
# attendance without shift
mark_attendance(self.employee,
previous_month_first + relativedelta(days=2),
"On Leave")
mark_attendance(self.employee,
previous_month_first + relativedelta(days=3),
"Present")
filters = frappe._dict({
"month": previous_month,
"year": now.year,
"company": company,
"group_by": "Department"
})
report = execute(filters=filters)
department = frappe.db.get_value("Employee", self.employee,
"department")
department_row = report[1][0]
self.assertIn(department, department_row["department"])
day_shift_row = report[1][1]
row_without_shift = report[1][2]
self.assertEqual(day_shift_row["shift"], "Day Shift")
self.assertEqual(day_shift_row[1],
"A") # absent on the 1st day of the month
self.assertEqual(day_shift_row[2], "P") # present on the 2nd day
self.assertEqual(row_without_shift["shift"], None)
self.assertEqual(row_without_shift[3], "L") # on leave on the 3rd day
self.assertEqual(row_without_shift[4], "P") # present on the 4th day
def test_validations(self):
# validation error for filters without month and year
self.assertRaises(frappe.ValidationError,
execute_report_with_invalid_filters)
# execute report without attendance record
now = now_datetime()
previous_month = now.month - 1
company = frappe.db.get_value("Employee", self.employee, "company")
filters = frappe._dict({
"month": previous_month,
"year": now.year,
"company": company,
"group_by": "Department"
})
report = execute(filters=filters)
self.assertEqual(report, ([], [], None, None))
def execute_report_with_invalid_filters():
filters = frappe._dict({
"company": "_Test Company",
"group_by": "Department"
})
execute(filters=filters)