fix: Employee birthday reminder
diff --git a/erpnext/hr/doctype/employee/employee.py b/erpnext/hr/doctype/employee/employee.py
index c00de69..dc41285 100755
--- a/erpnext/hr/doctype/employee/employee.py
+++ b/erpnext/hr/doctype/employee/employee.py
@@ -330,12 +330,13 @@
def get_employees_who_are_born_today():
"""Get all employee born today & group them based on their company"""
from collections import defaultdict
- employees_born_today = frappe.db.get_all("Employee",
- fields=["personal_email", "company", "company_email", "user_id", "employee_name as name", "image"],
- filters={
- "date_of_birth": ("like", "{}".format(format_datetime(getdate(), "-MM-dd"))),
- "status": "Active",
- })
+ employees_born_today = frappe.db.sql("""
+ SELECT `personal_email`, `company`, `company_email`, `user_id`, `employee_name` as 'name', `image`
+ FROM `tabEmployee`
+ WHERE DAY(date_of_birth) = DAY(CURDATE())
+ AND MONTH(date_of_birth) = MONTH(CURDATE())
+ AND `status` = 'Active'
+ """, as_dict=1)
grouped_employees = defaultdict(lambda: [])