| Line 1733... |
Line 1733... |
| 1733 |
toDaysSale = getTodaysSale(sku)
|
1733 |
toDaysSale = getTodaysSale(sku)
|
| 1734 |
sheet.write(sheet_iterator, 52, toDaysSale[0])
|
1734 |
sheet.write(sheet_iterator, 52, toDaysSale[0])
|
| 1735 |
sheet.write(sheet_iterator, 53, str(toDaysSale[1]))
|
1735 |
sheet.write(sheet_iterator, 53, str(toDaysSale[1]))
|
| 1736 |
|
1736 |
|
| 1737 |
#sheet.write(sheet_iterator, 44, round(amScraping.proposedSp - getNewLowestPossibleSp(amScraping,12.36,getNewVatRate(amScraping.item_id,amScraping.warehouseLocation,amScraping.proposedSp))))
|
1737 |
#sheet.write(sheet_iterator, 44, round(amScraping.proposedSp - getNewLowestPossibleSp(amScraping,12.36,getNewVatRate(amScraping.item_id,amScraping.warehouseLocation,amScraping.proposedSp))))
|
| 1738 |
sheet.write(sheet_iterator, 56, getInventoryMovementStatus(amScraping))
|
1738 |
sheet.write(sheet_iterator, 58, getInventoryMovementStatus(amScraping))
|
| 1739 |
sheet_iterator+=1
|
1739 |
sheet_iterator+=1
|
| 1740 |
#TODO : Take excell sheet generation code inside a function
|
1740 |
#TODO : Take excell sheet generation code inside a function
|
| 1741 |
competitiveItems = session.query(AmazonScrapingHistory,Item).join((Item,AmazonScrapingHistory.item_id==Item.id)).filter(AmazonScrapingHistory.competitiveCategory==CompetitionCategory.COMPETITIVE).filter(AmazonScrapingHistory.timestamp==timestamp).all()
|
1741 |
competitiveItems = session.query(AmazonScrapingHistory,Item).join((Item,AmazonScrapingHistory.item_id==Item.id)).filter(AmazonScrapingHistory.competitiveCategory==CompetitionCategory.COMPETITIVE).filter(AmazonScrapingHistory.timestamp==timestamp).all()
|
| 1742 |
for competitiveItem in competitiveItems:
|
1742 |
for competitiveItem in competitiveItems:
|
| 1743 |
amScraping = competitiveItem[0]
|
1743 |
amScraping = competitiveItem[0]
|
| Line 2440... |
Line 2440... |
| 2440 |
sheet.write(sheet_iterator, 50, str(inStockStats[2]))
|
2440 |
sheet.write(sheet_iterator, 50, str(inStockStats[2]))
|
| 2441 |
sheet.write(sheet_iterator, 51, getAvgSale(inStockStats[2], inStockStats[1]))
|
2441 |
sheet.write(sheet_iterator, 51, getAvgSale(inStockStats[2], inStockStats[1]))
|
| 2442 |
toDaysSale = getTodaysSale(sku)
|
2442 |
toDaysSale = getTodaysSale(sku)
|
| 2443 |
sheet.write(sheet_iterator, 52, toDaysSale[0])
|
2443 |
sheet.write(sheet_iterator, 52, toDaysSale[0])
|
| 2444 |
sheet.write(sheet_iterator, 53, str(toDaysSale[1]))
|
2444 |
sheet.write(sheet_iterator, 53, str(toDaysSale[1]))
|
| 2445 |
sheet.write(sheet_iterator, 56, getInventoryMovementStatus(amScraping))
|
2445 |
sheet.write(sheet_iterator, 58, getInventoryMovementStatus(amScraping))
|
| 2446 |
sheet_iterator+=1
|
2446 |
sheet_iterator+=1
|
| 2447 |
|
2447 |
|
| 2448 |
sheet = wbk.add_sheet('Exception List')
|
2448 |
sheet = wbk.add_sheet('Exception List')
|
| 2449 |
xstr = lambda s: s or ""
|
2449 |
xstr = lambda s: s or ""
|
| 2450 |
heading_xf = xlwt.easyxf('font: bold on; align: wrap off, vert centre, horiz center')
|
2450 |
heading_xf = xlwt.easyxf('font: bold on; align: wrap off, vert centre, horiz center')
|