| Line 1... |
Line 1... |
| 1 |
from elixir import *
|
1 |
from elixir import *
|
| 2 |
from sqlalchemy.sql import or_ ,func, asc
|
2 |
from sqlalchemy.sql import or_ ,func, asc
|
| 3 |
from shop2020.config.client.ConfigClient import ConfigClient
|
3 |
from shop2020.config.client.ConfigClient import ConfigClient
|
| 4 |
from shop2020.model.v1.catalog.impl import DataService
|
4 |
from shop2020.model.v1.catalog.impl import DataService
|
| 5 |
from shop2020.model.v1.catalog.impl.DataService import SnapdealItem, MarketplaceItems, Item, \
|
5 |
from shop2020.model.v1.catalog.impl.DataService import SnapdealItem, MarketplaceItems, Item, \
|
| 6 |
Category, SourcePercentageMaster, MarketPlaceHistory, SnapdealItemUpdateHistory, MarketPlaceItemPrice
|
6 |
Category, SourcePercentageMaster, MarketPlaceHistory, MarketPlaceUpdateHistory, MarketPlaceItemPrice
|
| 7 |
from shop2020.thriftpy.model.v1.order.ttypes import OrderSource
|
7 |
from shop2020.thriftpy.model.v1.order.ttypes import OrderSource
|
| 8 |
from shop2020.thriftpy.model.v1.catalog.ttypes import CompetitionCategory, CompetitionBasis, SalesPotential,\
|
8 |
from shop2020.thriftpy.model.v1.catalog.ttypes import CompetitionCategory, CompetitionBasis, SalesPotential,\
|
| 9 |
Decision, RunType
|
9 |
Decision, RunType
|
| 10 |
from shop2020.clients.CatalogClient import CatalogClient
|
10 |
from shop2020.clients.CatalogClient import CatalogClient
|
| 11 |
from shop2020.clients.InventoryClient import InventoryClient
|
11 |
from shop2020.clients.InventoryClient import InventoryClient
|
| Line 1468... |
Line 1468... |
| 1468 |
mpItem.minimumPossibleSp = getNewLowestPossibleSp(mpItem,item.ourNlc,vatRate)
|
1468 |
mpItem.minimumPossibleSp = getNewLowestPossibleSp(mpItem,item.ourNlc,vatRate)
|
| 1469 |
markStatusForMarketplaceItems(sdItem,mpItem)
|
1469 |
markStatusForMarketplaceItems(sdItem,mpItem)
|
| 1470 |
session.commit()
|
1470 |
session.commit()
|
| 1471 |
|
1471 |
|
| 1472 |
def addHistory(item):
|
1472 |
def addHistory(item):
|
| 1473 |
itemHistory = SnapdealItemUpdateHistory()
|
1473 |
itemHistory = MarketPlaceUpdateHistory()
|
| 1474 |
itemHistory.item_id = item.item_id
|
1474 |
itemHistory.item_id = item.item_id
|
| - |
|
1475 |
itemHistory.source = OrderSource.SNAPDEAL
|
| 1475 |
itemHistory.exceptionPrice = item.exceptionPrice
|
1476 |
itemHistory.exceptionPrice = item.exceptionPrice
|
| 1476 |
itemHistory.warehouseId = item.warehouseId
|
1477 |
itemHistory.warehouseId = item.warehouseId
|
| 1477 |
itemHistory.isListedOnSnapdeal = item.isListedOnSnapdeal
|
1478 |
itemHistory.isListedOnSource = item.isListedOnSnapdeal
|
| 1478 |
itemHistory.transferPrice = item.transferPrice
|
1479 |
itemHistory.transferPrice = item.transferPrice
|
| 1479 |
itemHistory.sellingPrice = item.sellingPrice
|
1480 |
itemHistory.sellingPrice = item.sellingPrice
|
| 1480 |
itemHistory.courierCost = item.courierCost
|
1481 |
itemHistory.courierCost = item.courierCost
|
| 1481 |
itemHistory.commission = item.commission
|
1482 |
itemHistory.commission = item.commission
|
| 1482 |
itemHistory.serviceTax = item.serviceTax
|
1483 |
itemHistory.serviceTax = item.serviceTax
|
| 1483 |
itemHistory.suppressPriceFeed = item.suppressPriceFeed
|
1484 |
itemHistory.suppressPriceFeed = item.suppressPriceFeed
|
| 1484 |
itemHistory.suppressInventoryFeed = item.suppressInventoryFeed
|
1485 |
itemHistory.suppressInventoryFeed = item.suppressInventoryFeed
|
| 1485 |
itemHistory.updatedOn = item.updatedOn
|
1486 |
itemHistory.updatedOn = item.updatedOn
|
| 1486 |
itemHistory.maxNlc = item.maxNlc
|
1487 |
itemHistory.maxNlc = item.maxNlc
|
| 1487 |
itemHistory.skuAtSnapdeal = item.skuAtSnapdeal
|
1488 |
itemHistory.skuAtSource = item.skuAtSnapdeal
|
| 1488 |
itemHistory.supc = item.supc
|
1489 |
itemHistory.marketPlaceSerialNumber = item.supc
|
| 1489 |
itemHistory.priceUpdatedBy = item.priceUpdatedBy
|
1490 |
itemHistory.priceUpdatedBy = item.priceUpdatedBy
|
| 1490 |
|
1491 |
|
| 1491 |
def markStatusForMarketplaceItems(snapdealItem,marketplaceItem):
|
1492 |
def markStatusForMarketplaceItems(snapdealItem,marketplaceItem):
|
| 1492 |
markUpdatedItem = MarketPlaceItemPrice.query.filter(MarketPlaceItemPrice.item_id==snapdealItem.item_id).filter(MarketPlaceItemPrice.source==marketplaceItem.source).first()
|
1493 |
markUpdatedItem = MarketPlaceItemPrice.query.filter(MarketPlaceItemPrice.item_id==snapdealItem.item_id).filter(MarketPlaceItemPrice.source==marketplaceItem.source).first()
|
| 1493 |
if markUpdatedItem is None:
|
1494 |
if markUpdatedItem is None:
|