def get_item_conditions(filters, for_item_dt): conditions = [] if filters.get("item_code"): conditions.append("item.{} = %(item_code)s".format( "name" if for_item_dt else "item_code")) else: if filters.get("brand"): conditions.append("item.brand=%(brand)s") if filters.get("item_group"): conditions.append( get_item_group_condition(filters.get("item_group"))) if filters.get("supplier") and for_item_dt: supplier_conditions = [] if frappe.get_meta("Item").has_field("default_supplier"): supplier_conditions.append("item.default_supplier = %(supplier)s") supplier_conditions.append( """exists (select id.name from `tabItem Default` id where id.parent = item.name and id.parenttype = 'Item' and id.default_supplier = %(supplier)s)""" ) conditions.append("({0})".format(" or ".join(supplier_conditions))) return " and " + " and ".join(conditions) if conditions else ""
def get_item_info(filters): from erpnext.stock.report.stock_ledger.stock_ledger import get_item_group_condition conditions = [get_item_group_condition(filters.get("item_group"))] if filters.get("brand"): conditions.append("item.brand=%(brand)s") return frappe.db.sql("""select name, item_name, description, brand, item_group, safety_stock, lead_time_days from `tabItem` item where {}""" .format(" and ".join(conditions)), filters, as_dict=1)
def get_item_info(filters): from erpnext.stock.report.stock_ledger.stock_ledger import get_item_group_condition conditions = [get_item_group_condition(filters.get("item_group"))] if filters.get("brand"): conditions.append("item.brand=%(brand)s") return frappe.db.sql("""select name, item_name, description, brand, item_group, safety_stock, lead_time_days from `tabItem` item where {}""" .format(" and ".join(conditions)), filters, as_dict=1)
def get_items(filters): conditions = [] if filters.get("item_code"): conditions.append("item.name=%(item_code)s") else: if filters.get("item_group"): conditions.append(get_item_group_condition(filters.get("item_group"))) items = [] if conditions: items = frappe.db.sql_list("""select name from `tabItem` item where {}""" .format(" and ".join(conditions)), filters) return items
def get_item_conditions(filters): conditions = [] if filters.get("item_code"): conditions.append("item.item_code = %(item_code)s") else: if filters.get("brand"): conditions.append("item.brand=%(brand)s") if filters.get("item_group"): conditions.append(get_item_group_condition(filters.get("item_group"))) conditions = " and ".join(conditions) return "and {0}".format(conditions) if conditions else ""
def get_item_conditions(filters, use_doc_name): conditions = [] if filters.get("item_code"): conditions.append("item.{} = %(item_code)s".format( "name" if use_doc_name else "item_code")) else: if filters.get("brand"): conditions.append("item.brand=%(brand)s") if filters.get("item_group"): conditions.append( get_item_group_condition(filters.get("item_group"))) return " and " + " and ".join(conditions) if conditions else ""
def get_items(filters): conditions = [] if filters.get("item_code"): conditions.append("item.name=%(item_code)s") else: if filters.get("brand"): conditions.append("item.brand=%(brand)s") if filters.get("item_group"): conditions.append(get_item_group_condition(filters.get("item_group"))) items = [] if conditions: items = frappe.db.sql_list("""select name from `tabItem` item where {}""" .format(" and ".join(conditions)), filters) return items
def get_items(filters): "Get items based on item code, item group or brand." conditions = [] if filters.get("item_code"): conditions.append("item.name=%(item_code)s") else: if filters.get("item_group"): conditions.append(get_item_group_condition(filters.get("item_group"))) if filters.get("brand"): # used in stock analytics report conditions.append("item.brand=%(brand)s") items = [] if conditions: items = frappe.db.sql_list( """select name from `tabItem` item where {}""".format(" and ".join(conditions)), filters ) return items
def get_item_conditions(filters): from erpnext.stock.report.stock_ledger.stock_ledger import get_item_group_condition conditions = [] if filters.get("item_code"): conditions.append("item.name=%(item_code)s") else: if filters.get("brand"): conditions.append("item.brand=%(brand)s") if filters.get("item_group"): conditions.append( get_item_group_condition(filters.get("item_group"))) items = [] if conditions: items = frappe.db.sql_list( """select name from `tabItem` item where {}""".format( " and ".join(conditions)), filters) item_conditions_sql = '' if items: item_conditions_sql = ' and sle.item_code in ({})' \ .format(', '.join(['"' + frappe.db.escape(i, percent=False) + '"' for i in items])) return item_conditions_sql
def get_items(filters): conditions = [] if filters.get("item_code"): conditions.append("item.name=%(item_code)s") else: if filters.get("brand"): conditions.append("item.brand=%(brand)s") if filters.get("therapeutic_usage"): conditions.append("item.therapeutic_usage=%(therapeutic_usage)s") if filters.get("formulation_type"): conditions.append("item.formulation_type=%(formulation_type)s") if filters.get("scientific_type"): conditions.append("item.scientific_type=%(scientific_type)s") if filters.get("item_group"): conditions.append( get_item_group_condition(filters.get("item_group"))) items = [] if conditions: items = frappe.db.sql_list( """select name from `tabItem` item where {}""".format( " and ".join(conditions)), filters) return items