| Line 1234... |
Line 1234... |
| 1234 |
snapdeal_inventory_item = SnapdealInventorySnapshot.get_by(item_id = snapdealinventoryitem.item_id)
|
1234 |
snapdeal_inventory_item = SnapdealInventorySnapshot.get_by(item_id = snapdealinventoryitem.item_id)
|
| 1235 |
if snapdeal_inventory_item is None:
|
1235 |
if snapdeal_inventory_item is None:
|
| 1236 |
snapdeal_inventory_item = SnapdealInventorySnapshot()
|
1236 |
snapdeal_inventory_item = SnapdealInventorySnapshot()
|
| 1237 |
snapdeal_inventory_item.item_id = snapdealinventoryitem.item_id
|
1237 |
snapdeal_inventory_item.item_id = snapdealinventoryitem.item_id
|
| 1238 |
snapdeal_inventory_item.availability = snapdealinventoryitem.availability
|
1238 |
snapdeal_inventory_item.availability = snapdealinventoryitem.availability
|
| - |
|
1239 |
snapdeal_inventory_item.pendingOrders = snapdealinventoryitem.pendingOrders
|
| 1239 |
snapdeal_inventory_item.lastUpdatedOnSnapdeal = to_py_date(snapdealinventoryitem.lastUpdatedOnSnapdeal)
|
1240 |
snapdeal_inventory_item.lastUpdatedOnSnapdeal = to_py_date(snapdealinventoryitem.lastUpdatedOnSnapdeal)
|
| 1240 |
else:
|
1241 |
else:
|
| 1241 |
snapdeal_inventory_item.availability = snapdealinventoryitem.availability
|
1242 |
snapdeal_inventory_item.availability = snapdealinventoryitem.availability
|
| - |
|
1243 |
snapdeal_inventory_item.pendingOrders = snapdealinventoryitem.pendingOrders
|
| 1242 |
snapdeal_inventory_item.lastUpdatedOnSnapdeal = to_py_date(snapdealinventoryitem.lastUpdatedOnSnapdeal)
|
1244 |
snapdeal_inventory_item.lastUpdatedOnSnapdeal = to_py_date(snapdealinventoryitem.lastUpdatedOnSnapdeal)
|
| 1243 |
session.commit()
|
1245 |
session.commit()
|
| 1244 |
|
1246 |
|
| 1245 |
def get_nlc_for_warehouse(warehouse_id,itemid):
|
1247 |
def get_nlc_for_warehouse(warehouse_id,itemid):
|
| 1246 |
warehouse = Warehouse.get_by(id=warehouse_id)
|
1248 |
warehouse = Warehouse.get_by(id=warehouse_id)
|
| Line 1250... |
Line 1252... |
| 1250 |
'''vendoritempricing = VendorItemPricing.get_by(id=warehouse.vendor_id,item_id=itemid)'''
|
1252 |
'''vendoritempricing = VendorItemPricing.get_by(id=warehouse.vendor_id,item_id=itemid)'''
|
| 1251 |
if vendoritempricing is None:
|
1253 |
if vendoritempricing is None:
|
| 1252 |
return 0
|
1254 |
return 0
|
| 1253 |
return vendoritempricing.nlc
|
1255 |
return vendoritempricing.nlc
|
| 1254 |
|
1256 |
|
| 1255 |
def get_lastupdatedtime_for_snapdealinventory():
|
1257 |
def get_snapdeal_inventory_snapshot():
|
| 1256 |
snapdealinventorysnapshot = session.query(func.max(SnapdealInventorySnapshot.lastUpdatedOnSnapdeal)).one()
|
- |
|
| 1257 |
if to_java_date(snapdealinventorysnapshot[0]) is None:
|
1258 |
return SnapdealInventorySnapshot.query.all()
|
| 1258 |
return 0
|
- |
|
| 1259 |
else:
|
- |
|
| 1260 |
return to_java_date(snapdealinventorysnapshot[0])
|
- |
|
| 1261 |
|
1259 |
|