想要根据位置获取产品可用数量(odoo 12)

import xmlrpc.client

# 连接到Odoo实例
url = 'http://localhost:8069'
db = 'your_database_name'
username = 'admin'
password = 'admin'

common = xmlrpc.client.ServerProxy('{}/xmlrpc/2/common'.format(url))
uid = common.authenticate(db, username, password, {})

models = xmlrpc.client.ServerProxy('{}/xmlrpc/2/object'.format(url))

# 查询特定位置的可用产品数量
location_id = 1  # 假设位置ID为1
product_id = 1   # 假设产品ID为1

# 获取库存数量
inventory_data = models.execute_kw(db, uid, password, 'stock.quant', 'search_read', [[['location_id', '=', location_id], ['product_id', '=', product_id]]], {'fields': ['quantity']})

if inventory_data:
    available_quantity = inventory_data[0]['quantity']
    print(f"产品ID {product_id} 在位置ID {location_id} 的可用数量为: {available_quantity}")
else:
    print(f"没有找到产品ID {product_id} 在位置ID {location_id} 的库存记录")