WareHouse.py

parent_warehouse=""
if filters.get("parent_warehouse"):
    escaped_input = frappe.db.escape(filters.get("parent_warehouse"))
    parent_warehouse = f" WHERE `tabWarehouse`.parent_warehouse = {escaped_input}"
   
item_code=""
if filters.get("item_code"):
    escaped_input = frappe.db.escape(filters.get("item_code"))
    item_code = f" AND `tabBin`.item_code = {escaped_input}"
       
    
res = frappe.db.sql(f"""SELECT
`tabWarehouse`.parent_warehouse,
`tabBin`.item_code,
`tabBin`.actual_qty,
`tabBin`.stock_uom
FROM `tabBin`
INNER JOIN `tabWarehouse`
on `tabWarehouse`.name = `tabBin`.warehouse
{parent_warehouse}
{item_code}

   """, as_dict=True)
result = res