Subversion Repositories SmartDukaan

            count+=1

            count+=1

            sale = sale+obj.num_orders

            sale = sale+obj.num_orders

    avgSalePerDay=0 if count==0 else (float(sale)/count)

    avgSalePerDay=0 if count==0 else (float(sale)/count)

    return round(avgSalePerDay,2)

    return round(avgSalePerDay,2)

def getNetAvailability(itemInventory):

def getNetAvailability(itemInventory):

    totalAvailability, totalReserved = 0,0

    totalAvailability, totalReserved = 0,0

    availableMap  = itemInventory.availability

    availableMap  = itemInventory.availability

    reserveMap = itemInventory.reserved

    reserveMap = itemInventory.reserved

    for warehouse,availability in availableMap.iteritems():

    for warehouse,availability in availableMap.iteritems():

    nowAutoFav = []

    nowAutoFav = []

    marketplaceItems = session.query(MarketplaceItems).filter(MarketplaceItems.source==OrderSource.SNAPDEAL).all()

    marketplaceItems = session.query(MarketplaceItems).filter(MarketplaceItems.source==OrderSource.SNAPDEAL).all()

    fromDate = datetime.now()-timedelta(days = 3, hours=datetime.now().hour, minutes=datetime.now().minute, seconds=datetime.now().second)

    fromDate = datetime.now()-timedelta(days = 3, hours=datetime.now().hour, minutes=datetime.now().minute, seconds=datetime.now().second)

    toDate = datetime.now()-timedelta(days = 0, hours=datetime.now().hour, minutes=datetime.now().minute, seconds=datetime.now().second)

    toDate = datetime.now()-timedelta(days = 0, hours=datetime.now().hour, minutes=datetime.now().minute, seconds=datetime.now().second)

    items = session.query(MarketPlaceHistory.item_id,func.max(MarketPlaceHistory.timestamp)).group_by(MarketPlaceHistory.item_id).filter(MarketPlaceHistory.source==OrderSource.SNAPDEAL).filter(MarketPlaceHistory.timestamp.between (fromDate,toDate)).filter(MarketPlaceHistory.competitiveCategory==CompetitionCategory.BUY_BOX).all()

    items = session.query(MarketPlaceHistory.item_id,func.max(MarketPlaceHistory.timestamp)).group_by(MarketPlaceHistory.item_id).filter(MarketPlaceHistory.source==OrderSource.SNAPDEAL).filter(MarketPlaceHistory.timestamp.between (fromDate,toDate)).filter(MarketPlaceHistory.competitiveCategory==CompetitionCategory.BUY_BOX).all()

    buyBoxLast3days = []

    buyBoxLast3days = []

    for item in items:

    for item in items:

        buyBoxLast3days.append(item[0])

        buyBoxLast3days.append(item[0])

    for marketplaceItem in marketplaceItems:

    for marketplaceItem in marketplaceItems:

        reason = ""

        reason = ""

        toMark = False

        toMark = False

        if marketplaceItem.itemId in toUpdate:

        if marketplaceItem.itemId in toUpdate:

            toMark = True

            toMark = True

        if marketplaceItem.itemId in buyBoxLast3days:

        if marketplaceItem.itemId in buyBoxLast3days:

            toMark = True

            toMark = True

            reason+="Item is present in buy box in last 3 days"

            reason+="Item is present in buy box in last 3 days"

        if not marketplaceItem.autoFavourite:

        if not marketplaceItem.autoFavourite:

            print "Item is not under auto favourite"

            print "Item is not under auto favourite"

        itemSaleList.append(oosForAllSources)

        itemSaleList.append(oosForAllSources)

        itemSaleList.append(oosForSnapdeal)

        itemSaleList.append(oosForSnapdeal)

        itemSaleList.append(calculateAverageSale(oosForAllSources))

        itemSaleList.append(calculateAverageSale(oosForAllSources))

        itemSaleList.append(calculateAverageSale(oosForSnapdeal))

        itemSaleList.append(calculateAverageSale(oosForSnapdeal))

        itemSaleList.append(calculateAverageSale(oosForSnapdealLastDay))

        itemSaleList.append(calculateAverageSale(oosForSnapdealLastDay))

        itemSaleMap[val.item_id]=itemSaleList

        itemSaleMap[val.item_id]=itemSaleList

        if snapdealDetails.rank==0:

        if snapdealDetails.rank==0:

            snapdealDetails.ourSp = mpItem.currentSp

            snapdealDetails.ourSp = mpItem.currentSp

            snapdealDetails.ourOfferPrice = mpItem.currentSp

            snapdealDetails.ourOfferPrice = mpItem.currentSp