def get_invoice_nos(doctype, txt, searchfield, start, page_len, filters): from erpnext.utilities import build_filter_conditions conditions, filter_values = build_filter_conditions(filters) return frappe.db.sql("""select name from `tabSales Invoice` where docstatus = 1 and c_form_applicable = 'Yes' and ifnull(c_form_no, '') = '' %s and %s like %s order by name limit %s, %s""" % (conditions, searchfield, "%s", "%s", "%s"), tuple(filter_values + ["%%%s%%" % txt, start, page_len]))
def get_cost_center_list(doctype, txt, searchfield, start, page_len, filters): if not filters.get("group_or_ledger"): filters["group_or_ledger"] = "Ledger" conditions, filter_values = build_filter_conditions(filters) return frappe.db.sql("""select name, parent_cost_center from `tabCost Center` where docstatus < 2 %s and %s like %s order by name limit %s, %s""" % (conditions, searchfield, "%s", "%s", "%s"), tuple(filter_values + ["%%%s%%" % txt, start, page_len]))
def get_cost_center_list(doctype, txt, searchfield, start, page_len, filters): if not filters.get("group_or_ledger"): filters["group_or_ledger"] = "Ledger" conditions, filter_values = build_filter_conditions(filters) return frappe.db.sql( """select name, parent_cost_center from `tabCost Center` where docstatus < 2 %s and %s like %s order by name limit %s, %s""" % (conditions, searchfield, "%s", "%s", "%s"), tuple(filter_values + ["%%%s%%" % txt, start, page_len]), )
def get_invoice_nos(doctype, txt, searchfield, start, page_len, filters): from erpnext.utilities import build_filter_conditions conditions, filter_values = build_filter_conditions(filters) return frappe.db.sql( """select name from `tabSales Invoice` where docstatus = 1 and c_form_applicable = 'Yes' and ifnull(c_form_no, '') = '' %s and %s like %s order by name limit %s, %s""" % (conditions, searchfield, "%s", "%s", "%s"), tuple(filter_values + ["%%%s%%" % txt, start, page_len]), )