Payroll Period - get payroll period days
diff --git a/erpnext/hr/doctype/payroll_period/payroll_period.py b/erpnext/hr/doctype/payroll_period/payroll_period.py
index 1e18388..c95c7bd 100644
--- a/erpnext/hr/doctype/payroll_period/payroll_period.py
+++ b/erpnext/hr/doctype/payroll_period/payroll_period.py
@@ -4,7 +4,27 @@
from __future__ import unicode_literals
import frappe
+from frappe.utils import date_diff, getdate
from frappe.model.document import Document
class PayrollPeriod(Document):
pass
+
+def get_payroll_period_days(start_date, end_date, company):
+ payroll_period_dates = frappe.db.sql("""
+ select ppd.start_date, ppd.end_date from `tabPayroll Period Date` ppd, `tabPayroll Period` pp
+ where pp.company=%(company)s
+ and ppd.parent = pp.name
+ and (
+ (%(start_date)s between ppd.start_date and ppd.end_date)
+ or (%(end_date)s between ppd.start_date and ppd.end_date)
+ or (ppd.start_date between %(start_date)s and %(end_date)s)
+ )""", {
+ 'company': company,
+ 'start_date': start_date,
+ 'end_date': end_date
+ })
+
+ if len(payroll_period_dates) > 0:
+ print payroll_period_dates[0][0], payroll_period_dates[0][1]
+ return date_diff(getdate(payroll_period_dates[0][1]), getdate(payroll_period_dates[0][0])) + 1