Subversion Repositories SmartDukaan

Rev

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

Rev 8954 Rev 9404
Line 13... Line 13...
13
from shop2020.model.v1.inventory.impl.DataService import Warehouse, \
13
from shop2020.model.v1.inventory.impl.DataService import Warehouse, \
14
    ItemInventoryHistory, CurrentInventorySnapshot, VendorItemPricing, \
14
    ItemInventoryHistory, CurrentInventorySnapshot, VendorItemPricing, \
15
    VendorItemMapping, Vendor, MissedInventoryUpdate, BadInventorySnapshot, \
15
    VendorItemMapping, Vendor, MissedInventoryUpdate, BadInventorySnapshot, \
16
    VendorHolidays, ItemAvailabilityCache, \
16
    VendorHolidays, ItemAvailabilityCache, \
17
    CurrentReservationSnapshot, IgnoredInventoryUpdateItems, ItemStockPurchaseParams, \
17
    CurrentReservationSnapshot, IgnoredInventoryUpdateItems, ItemStockPurchaseParams, \
18
    OOSStatus, AmazonInventorySnapshot, StateMaster, HoldInventoryDetail,AmazonFbaInventorySnapshot
18
    OOSStatus, AmazonInventorySnapshot, StateMaster, HoldInventoryDetail, AmazonFbaInventorySnapshot, \
-
 
19
    SnapdealInventorySnapshot
19
from shop2020.thriftpy.model.v1.inventory.ttypes import \
20
from shop2020.thriftpy.model.v1.inventory.ttypes import \
20
    InventoryServiceException, HolidayType, InventoryType, WarehouseType
21
    InventoryServiceException, HolidayType, InventoryType, WarehouseType
21
from shop2020.thriftpy.model.v1.order.ttypes import AlertType
22
from shop2020.thriftpy.model.v1.order.ttypes import AlertType
22
from shop2020.thriftpy.purchase.ttypes import PurchaseServiceException
23
from shop2020.thriftpy.purchase.ttypes import PurchaseServiceException
23
from shop2020.utils import EmailAttachmentSender
24
from shop2020.utils import EmailAttachmentSender
Line 1221... Line 1222...
1221
    print holddetails
1222
    print holddetails
1222
    hold = 0
1223
    hold = 0
1223
    for holddetail in holddetails:
1224
    for holddetail in holddetails:
1224
        if holddetail.source !=source and holddetail.warehouse_id == warehouse_id:
1225
        if holddetail.source !=source and holddetail.warehouse_id == warehouse_id:
1225
            hold = hold + holddetail.held
1226
            hold = hold + holddetail.held
1226
    return hold        
1227
    return hold
-
 
1228
 
-
 
1229
def get_snapdeal_inventory_for_item(id):
-
 
1230
    print SnapdealInventorySnapshot.get_by(item_id = id)
-
 
1231
    return SnapdealInventorySnapshot.get_by(item_id = id)
-
 
1232
 
-
 
1233
def add_or_update_snapdeal_inventor_for_item(snapdealinventoryitem):
-
 
1234
    snapdeal_inventory_item = SnapdealInventorySnapshot.get_by(item_id = snapdealinventoryitem.item_id)
1227
        
1235
    if snapdeal_inventory_item is None:
-
 
1236
        snapdeal_inventory_item = SnapdealInventorySnapshot()
-
 
1237
        snapdeal_inventory_item.item_id = snapdealinventoryitem.item_id
-
 
1238
        snapdeal_inventory_item.availability = snapdealinventoryitem.availability
-
 
1239
        snapdeal_inventory_item.lastUpdatedOnSnapdeal = to_py_date(snapdealinventoryitem.lastUpdatedOnSnapdeal)
1228
        
1240
    else:
-
 
1241
        snapdeal_inventory_item.availability = snapdealinventoryitem.availability
-
 
1242
        snapdeal_inventory_item.lastUpdatedOnSnapdeal = to_py_date(snapdealinventoryitem.lastUpdatedOnSnapdeal)
1229
    
1243
    session.commit()
1230
    
1244
    
-
 
1245
def get_nlc_for_warehouse(warehouse_id,itemid):
-
 
1246
    warehouse = Warehouse.get_by(id=warehouse_id)
-
 
1247
    if warehouse is None:
-
 
1248
        return 0
-
 
1249
    vendoritempricing = VendorItemPricing.query.filter_by(item_id=itemid, vendor_id=warehouse.vendor_id).first()
-
 
1250
    '''vendoritempricing = VendorItemPricing.get_by(id=warehouse.vendor_id,item_id=itemid)'''
-
 
1251
    if vendoritempricing is None:
-
 
1252
        return 0
-
 
1253
    return vendoritempricing.nlc
1231
1254