Inactive employees show up in report
diff --git a/erpnext/hr/report/monthly_attendance_sheet/monthly_attendance_sheet.py b/erpnext/hr/report/monthly_attendance_sheet/monthly_attendance_sheet.py
index d7787b5..68914ea 100644
--- a/erpnext/hr/report/monthly_attendance_sheet/monthly_attendance_sheet.py
+++ b/erpnext/hr/report/monthly_attendance_sheet/monthly_attendance_sheet.py
@@ -27,7 +27,7 @@
total_p = total_a = 0.0
for day in range(filters["total_days_in_month"]):
status = att_map.get(emp).get(day + 1, "None")
- status_map = {"Present": "P", "Absent": "A", "Half Day": "H", "None":" "}
+ status_map = {"Present": "P", "Absent": "A", "Half Day": "H", "None": ""}
row.append(status_map[status])
if status == "Present":
@@ -39,7 +39,6 @@
total_a += 0.5
row += [total_p, total_a]
-
data.append(row)
return columns, data
@@ -96,9 +95,8 @@
def get_employee_details():
emp_map = frappe._dict()
for d in frappe.db.sql("""select name, employee_name, designation,
- department, branch, company
- from tabEmployee where docstatus < 2
- and status = 'Active'""", as_dict=1):
+ department, branch, company, status
+ from tabEmployee""", as_dict=1):
emp_map.setdefault(d.name, d)
return emp_map