| Line 162... |
Line 162... |
| 162 |
autoDecrementItem.ourEnoughStock=True
|
162 |
autoDecrementItem.ourEnoughStock=True
|
| 163 |
autoDecrementItem.decision = Decision.AUTO_DECREMENT_SUCCESS
|
163 |
autoDecrementItem.decision = Decision.AUTO_DECREMENT_SUCCESS
|
| 164 |
autoDecrementItem.reason = 'All conditions for auto decrement true'
|
164 |
autoDecrementItem.reason = 'All conditions for auto decrement true'
|
| 165 |
successfulAutoDecrease.append(autoDecrementItem)
|
165 |
successfulAutoDecrease.append(autoDecrementItem)
|
| 166 |
session.commit()
|
166 |
session.commit()
|
| 167 |
session.close()
|
- |
|
| 168 |
return successfulAutoDecrease
|
167 |
return successfulAutoDecrease
|
| 169 |
|
168 |
|
| 170 |
def fetchItemsForAutoIncrease(time):
|
169 |
def fetchItemsForAutoIncrease(time):
|
| 171 |
successfulAutoIncrease = []
|
170 |
successfulAutoIncrease = []
|
| 172 |
autoIncrementItems = session.query(AmazonScrapingHistory).join((Amazonlisted,AmazonScrapingHistory.item_id==Amazonlisted.itemId))\
|
171 |
autoIncrementItems = session.query(AmazonScrapingHistory).join((Amazonlisted,AmazonScrapingHistory.item_id==Amazonlisted.itemId))\
|
| Line 618... |
Line 617... |
| 618 |
print val.vatRate
|
617 |
print val.vatRate
|
| 619 |
print val.otherCost
|
618 |
print val.otherCost
|
| 620 |
print spm.commission
|
619 |
print spm.commission
|
| 621 |
print spm.emiFee
|
620 |
print spm.emiFee
|
| 622 |
print spm.returnProvision
|
621 |
print spm.returnProvision
|
| 623 |
lowestPossibleSp = (val.nlc+(val.courierCost)*(1+(spm.serviceTax/100))*(1+(val.vatRate/100))+(15+val.otherCost)*(1+(val.vatRate)/100))/(1-(spm.commission/100+spm.emiFee/100)*(1+(spm.serviceTax/100))*(1+(val.vatRate)/100)-(spm.returnProvision/100)*(1+(val.vatRate)/100));
|
622 |
lowestPossibleSp = (val.nlc+(val.courierCost)*(1+(spm.serviceTax/100))*(1+(val.vatRate/100))+(15.0+val.otherCost)*(1+(val.vatRate)/100))/(1-(spm.commission/100+spm.emiFee/100)*(1+(spm.serviceTax/100))*(1+(val.vatRate)/100)-(spm.returnProvision/100)*(1+(val.vatRate)/100));
|
| 624 |
if val.isPromo:
|
623 |
if val.isPromo:
|
| 625 |
if amazonLongTermActivePromotions.has_key(val.sku):
|
624 |
if amazonLongTermActivePromotions.has_key(val.sku):
|
| 626 |
subsidy = (amazonLongTermActivePromotions.get(val.sku)).subsidy
|
625 |
subsidy = (amazonLongTermActivePromotions.get(val.sku)).subsidy
|
| 627 |
else:
|
626 |
else:
|
| 628 |
subsidy = (amazonShortTermActivePromotions.get(val.sku)).subsidy
|
627 |
subsidy = (amazonShortTermActivePromotions.get(val.sku)).subsidy
|