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
