| Line 1295... |
Line 1295... |
| 1295 |
return AmazonFbaInventorySnapshot.query.filter_by(item_id = itemId)
|
1295 |
return AmazonFbaInventorySnapshot.query.filter_by(item_id = itemId)
|
| 1296 |
|
1296 |
|
| 1297 |
def get_all_amazon_fba_inventory():
|
1297 |
def get_all_amazon_fba_inventory():
|
| 1298 |
return AmazonFbaInventorySnapshot.query.all()
|
1298 |
return AmazonFbaInventorySnapshot.query.all()
|
| 1299 |
|
1299 |
|
| 1300 |
def get_oursgood_warehouseids_for_location(state_id):
|
1300 |
def get_oursgood_warehouseids_for_location(stateId):
|
| 1301 |
warehouseId=[]
|
1301 |
warehouseId=[]
|
| 1302 |
x= session.query(Warehouse.id).filter(Warehouse.id==Warehouse.billingWarehouseId).filter(Warehouse.warehouseType=='OURS').filter(Warehouse.state_id==1).all()
|
1302 |
x= session.query(Warehouse.id).filter(Warehouse.id==Warehouse.billingWarehouseId).filter(Warehouse.warehouseType=='OURS').filter(Warehouse.state_id==stateId).all()
|
| 1303 |
for id in x:
|
1303 |
for id in x:
|
| 1304 |
warehouseId.append(id[0])
|
1304 |
warehouseId.append(id[0])
|
| 1305 |
return session.query(Warehouse.id).filter(Warehouse.inventoryType=='GOOD').filter(Warehouse.warehouseType=='OURS').filter(Warehouse.billingWarehouseId.in_(warehouseId)).all()
|
1305 |
return session.query(Warehouse.id).filter(Warehouse.inventoryType=='GOOD').filter(Warehouse.warehouseType=='OURS').filter(Warehouse.billingWarehouseId.in_(warehouseId)).all()
|
| 1306 |
|
1306 |
|
| 1307 |
def get_holdinventorydetail_forItem_forWarehouseId_exceptsource(item_id,warehouse_id,source):
|
1307 |
def get_holdinventorydetail_forItem_forWarehouseId_exceptsource(item_id,warehouse_id,source):
|