I am getting this error while making script report:
Traceback (most recent call last):
File “/home/frappe/frappe-bench/apps/frappe/frappe/app.py”, line 57, in application
response = frappe.handler.handle()
File “/home/frappe/frappe-bench/apps/frappe/frappe/handler.py”, line 22, in handle
data = execute_cmd(cmd)
File “/home/frappe/frappe-bench/apps/frappe/frappe/handler.py”, line 53, in execute_cmd
return frappe.call(method, **frappe.form_dict)
File “/home/frappe/frappe-bench/apps/frappe/frappe/init.py”, line 935, in call
return fn(*args, **newargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/desk/query_report.py”, line 96, in run
res = frappe.get_attr(method_name)(frappe._dict(filters))
File “/home/frappe/frappe-bench/apps/erpnext/erpnext/hr/report/attendance_report/attendance_report.py”, line 13, in execute
data = get_employees(filters)
File “/home/frappe/frappe-bench/apps/erpnext/erpnext/hr/report/attendance_report/attendance_report.py”, line 26, in get_employees
return frappe.db.sql(“”“select employee, employee_name, attendance_date, in_time, out_time, total_working_hours, overtime_hours, ot_rate, ot_amount from tabAttendance “”” % conditions, as_list=1)
TypeError: not all arguments converted during string formatting
My python code is:
from future import unicode_literals
import frappe
from frappe import _
from frappe.utils import flt
def execute(filters=None):
if not filters: filters = {}
columns = get_columns()
data = get_employees(filters)
return columns, data
def get_columns():
return [
_(“Employee”) + “:Link/Employee:120”, _(“Employee Name”) + “:Data:200”, _(“Attendance Date”)+ “
100”,
_(“In Time”) + “:Time:120”, _(“Out Time”) + “:Time:120”,
_(“Total Working Hours”) + “:Float:120”, _(“Overtime Hours”) + “:Float:60”, (“OT Rate”) + “:Float:120”,(“OT Amount”) + “:Data:120”
]
def get_employees(filters):
conditions = get_conditions(filters)
return frappe.db.sql(“”“select employee, employee_name, attendance_date, in_time, out_time, total_working_hours, overtime_hours, ot_rate, ot_amount from tabAttendance “”” % conditions, as_list=1)
def get_conditions(filters):
conditions = “”
if filters.get(“from_date”): conditions += " and attendance_date >= %(from_date)s"
if filters.get(“to_date”): conditions += " and attendance_date <= %(to_date)s"
return conditions
Can any1 help me to solve dis error?