Hi Everyone,
In the above image I have 5 columns in my code but here only 4 are showing.I have checked my code too many times but instead of 5 column data I am getting 4.Why is this? If anyone can help please say.
Hi Everyone,
JS Code:
frappe.query_reports["Tearp Advance Report"] = {
"filters": [
{
"fieldname":"garden",
"label": __("Garden"),
"fieldtype": "Link",
"options": "Tearp Estate",
"default": "",
"reqd":0
}
]
}
Python Code:
# Copyright (c) 2013, Frappe and contributors
# For license information, please see license.txt
from __future__ import unicode_literals
import frappe
from frappe import _
from frappe.model.document import Document
from frappe import utils
# Function fetching the data into the columns defined
def execute(filters=None):
data = []
columns = get_columns()
worker = get_worker_id(filters)
for i in worker:
data.append([i.worker_id,i.worker_name,i.deduction,i.adv_amount,i.adv_status])
return columns, data
#Function fetching the data from Tearp Advance Entry Doctype
def get_worker_id(filters):
return frappe.db.sql("""select worker_id,worker_name,deduction,adv_amount,adv_status from `tabTearp Advance Entry` where garden = %s """,(filters.garden),as_dict=1)
#Function for appending(adding) data in report table
def get_columns():
columns = [{
"fieldname": "worker_id",
"label": _("Worker ID"),
"fieldtype": "Data",
"option":"",
"width":90
}]
columns.append({
"fieldname": "worker_name",
"label": _("Worker Name"),
"fieldtype": "Data",
"option":"",
"width":90
})
columns.append({
"fieldname": "deduction",
"label": _("Deduction"),
"fieldtype": "Float",
"option":"",
"width":90
})
columns.append({
"fieldname": "adv_amount",
"label": _("Advance Amount"),
"fieldtype": "Float",
"option":"",
"width":90
})
columns.append({
"fieldname": "adv_status",
"label": _("Advance Status"),
"fieldtype": "Data",
"option":"",
"width":10
})
return columns