Subversion Repositories SmartDukaan

Rev

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

Rev 4326 Rev 4332
Line 90... Line 90...
90 
    return item.status_description
 90 
    return item.status_description
91
91
92 
def get_Warehouse(warehouse_id):
 92 
def get_Warehouse(warehouse_id):
93 
    return Warehouse.get_by(id=warehouse_id)
 93 
    return Warehouse.get_by(id=warehouse_id)
94 
 
 94 
 
- 
 
 95 
def get_Vendor(vendorId):
- 
 
 96 
    return Vendor.get_by(id=vendorId)
- 
 
 97 
 
95 
def get_all_warehouses_by_status(status):
 98 
def get_all_warehouses_by_status(status):
96 
    if not status:
 99 
    if not status:
97 
        warehouses = Warehouse.query.all()
 100 
        warehouses = Warehouse.query.all()
98 
    else:
 101 
    else:
99 
        warehouses = Warehouse.query.filter_by(status=status).all()
 102 
        warehouses = Warehouse.query.filter_by(status=status).all()
Line 1304... Line 1307...
1304 
    try:
 1307 
    try:
1305 
        session.query(Item.id).limit(1).one()
 1308 
        session.query(Item.id).limit(1).one()
1306 
        return True
 1309 
        return True
1307 
    except:
 1310 
    except:
1308 
        return False
 1311 
        return False
- 
 
 1312 
 
- 
 
 1313 
def add_vendor(vendor):
- 
 
 1314 
    if not vendor:
- 
 
 1315 
        raise InventoryServiceException(108, "Bad vendor")
- 
 
 1316 
    if get_Vendor(vendor.id):
- 
 
 1317 
        #vendor is already present.
- 
 
 1318 
        raise InventoryServiceException(101, "Vendor already present")
- 
 
 1319
- 
 
 1320 
    ds_vendor = Vendor()
- 
 
 1321 
    ds_vendor.id = vendor.id
- 
 
 1322 
    ds_vendor.name = vendor.name
- 
 
 1323 
    session.commit()
- 
 
 1324 
    return ds_vendor.id
- 
 
 1325 
 
- 
 
 1326 
def add_warehouse_vendor_mapping(warehouse_id, VendorId):
- 
 
 1327 
    return True
- 
 
 1328 
 
- 
 
 1329 
def get_vendors_for_warehouse(warehouse_id):
- 
 
 1330 
    try:
- 
 
 1331 
        warehouse = Warehouse.get_by(id=warehouse_id)
- 
 
 1332 
        return warehouse.vendors
- 
 
 1333 
    except:
- 
 
 1334 
        raise InventoryServiceException(108, "Bad Warehouse Id")
- 
 
 1335 
 
- 
 
 1336 
def get_warehouses_for_vendor(vendorId):
- 
 
 1337 
    try:
- 
 
 1338 
        vendor = get_Vendor(vendorId)
- 
 
 1339 
        return vendor.warehouses
- 
 
 1340 
    except:
- 
 
 1341 
        raise InventoryServiceException(108, "Bad Vendor Id")
1309 

            1342