Subversion Repositories SmartDukaan

Rev

Rev 483 | Rev 501 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 483 Rev 494
Line 44... Line 44...
44 
    except:
 44 
    except:
45 
        raise InventoryServiceException(109, "Item not found")
 45 
        raise InventoryServiceException(109, "Item not found")
46
46
47 
def get_item_by_vendor_id(vendor_id):
 47 
def get_item_by_vendor_id(vendor_id):
48 
    query = Item.query.filter_by(vendor_item_id=vendor_id)
 48 
    query = Item.query.filter_by(vendor_item_id=vendor_id)
- 
 
 49 
    #query = Item.query.filter_by(vendor_item_id='6417182037054')
49 
    try:
 50 
    try:
50 
        return query.one()
 51 
        return query.one()
51 
    except:
 52 
    except:
52 
        raise InventoryServiceException(109, "Item not found")
 53 
        raise InventoryServiceException(109, "Item not found")
53
54
Line 230... Line 231...
230 
    warehouse.vendorString = timestamp
 231 
    warehouse.vendorString = timestamp
231
232
232 
    for k,v in availability.iteritems():
 233 
    for k,v in availability.iteritems():
233 
        vendor_id = k
 234 
        vendor_id = k
234 
        quantity = v
 235 
        quantity = v
- 
 
 236 
        try:
235 
        item = get_item_by_vendor_id(vendor_id)
237 
            item = Item.query.filter_by(vendor_item_id=vendor_id).one()
236 
        if not item:
 238 
        except:
237 
            raise InventoryServiceException(106, "Item not found, how did you get this?")
 239 
            continue
238 
        try:
 240 
        try:
239 
            item_inventory_history = ItemInventoryHistory()
 241 
            item_inventory_history = ItemInventoryHistory()
240 
            item_inventory_history.warehouse = warehouse
 242 
            item_inventory_history.warehouse = warehouse
241 
            item_inventory_history.item = item
 243 
            item_inventory_history.item = item
242 
            item_inventory_history.timestamp = time
 244 
            item_inventory_history.timestamp = time
Line 375... Line 377...
375 
    item = get_Item(item_id)
 377 
    item = get_Item(item_id)
376
378
377 
    if not item:
 379 
    if not item:
378 
            raise InventoryServiceException(108, "item does not exist")
 380 
            raise InventoryServiceException(108, "item does not exist")
379
381
- 
 
 382 
    query = CurrentInventorySnapshot.query.filter_by(warehouse_id = warehouse_id)
- 
 
 383 
    query = query.filter_by(item_id = item_id)
- 
 
 384 
    try:
- 
 
 385 
        current_inventory_snapshot = query.one()
- 
 
 386 
        return current_inventory_snapshot.availibility
- 
 
 387 
    except:
- 
 
 388 
        return 0
- 
 
 389 
    """
380 
    current_inventory_snapshot = CurrentInventorySnapshot.query.filter(CurrentInventorySnapshot.warehouse.id == warehouse_id, CurrentInventorySnapshot.item.id == item_id).one()
 390 
    current_inventory_snapshot = CurrentInventorySnapshot.query.filter(CurrentInventorySnapshot.warehouse_id == warehouse_id, CurrentInventorySnapshot.item_id == item_id).one()
381 
    if not current_inventory_snapshot:
 391 
    if not current_inventory_snapshot:
382 
        return 0
 392 
        return 0
383 
    else:
 393 
    else:
384 
        return current_inventory_snapshot.availibility
 394 
        return current_inventory_snapshot.availibility
385
395 
    """
386 
def get_warehouses_for_item(item_id):
 396 
def get_warehouses_for_item(item_id):
387 
    if not item_id:
 397 
    if not item_id:
388 
        raise InventoryServiceException(101, "bad item_id")
 398 
        raise InventoryServiceException(101, "bad item_id")
389 
    item = get_Item(item_id)
 399 
    item = get_Item(item_id)
390
400