WebSVN – SmartDukaan – Diff – /trunk/PyProj/src/shop2020/model/v1/catalog/script/SnapdealHistoryPopulator.py



        mpHistory.ourRank = snapdealDetails.rank
        mpHistory.risky = snapdealItemInfo.risky
        mpHistory.margin = mpHistory.ourTp - mpHistory.lowestPossibleTp  
        mpHistory.competitiveCategory = CompetitionCategory.NEGATIVE_MARGIN
        mpHistory.totalSeller = snapdealDetails.totalSeller
        mpHistory.avgSales = (itemSaleMap.get(snapdealItemInfo.item_id))[3]
        mpHistory.timestamp = timestamp
        mpHistory.run = RunType._NAMES_TO_VALUES.get(snapdealItemInfo.runType)
        negativeMarginItems.append(mpHistory) 
    session.commit()
    return negativeMarginItems

            proposed_tp = getTargetTp(proposed_sp,mpItem)
            mpHistory.proposedSellingPrice = round(proposed_sp,2)
            mpHistory.proposedTp = round(proposed_tp,2)
        mpHistory.margin = mpHistory.ourTp - mpHistory.lowestPossibleTp
        mpHistory.totalSeller = snapdealDetails.totalSeller
        mpHistory.avgSales = (itemSaleMap.get(snapdealItemInfo.item_id))[3]
        mpHistory.salesPotential = SalesPotential._NAMES_TO_VALUES.get(getSalesPotential(snapdealDetails.lowestOfferPrice,snapdealItemInfo.nlc))
        mpHistory.timestamp = timestamp
        mpHistory.run = RunType._NAMES_TO_VALUES.get(snapdealItemInfo.runType)
        competitiveItems.append(mpHistory) 
    session.commit()

            proposed_tp = getTargetTp(proposed_sp,mpItem)
            mpHistory.proposedSellingPrice = round(proposed_sp,2)
            mpHistory.proposedTp = round(proposed_tp,2)
        mpHistory.margin = mpHistory.ourTp - mpHistory.lowestPossibleTp
        mpHistory.totalSeller = snapdealDetails.totalSeller
        mpHistory.avgSales = (itemSaleMap.get(snapdealItemInfo.item_id))[3]
        mpHistory.salesPotential = SalesPotential._NAMES_TO_VALUES.get(getSalesPotential(snapdealDetails.lowestOfferPrice,snapdealItemInfo.nlc))
        mpHistory.timestamp = timestamp
        mpHistory.run = RunType._NAMES_TO_VALUES.get(snapdealItemInfo.runType)
        competitiveNoInventoryItems.append(mpHistory)
    session.commit()

            mpHistory.proposedSellingPrice = round(proposed_sp,2)
            mpHistory.proposedTp = round(proposed_tp,2)
            mpHistory.targetNlc = round(target_nlc,2)
        mpHistory.margin = mpHistory.ourTp - mpHistory.lowestPossibleTp
        mpHistory.totalSeller = snapdealDetails.totalSeller
        mpHistory.avgSales = (itemSaleMap.get(snapdealItemInfo.item_id))[3]
        mpHistory.salesPotential = SalesPotential._NAMES_TO_VALUES.get(getSalesPotential(snapdealDetails.lowestOfferPrice,snapdealItemInfo.nlc))
        mpHistory.timestamp = timestamp
        mpHistory.run = RunType._NAMES_TO_VALUES.get(snapdealItemInfo.runType)
        cantComepeteItems.append(mpHistory)
    session.commit()

            mpHistory.proposedTp = round(proposed_tp,2)
            #mpHistory.targetNlc = target_nlc
        mpHistory.margin = mpHistory.ourTp - mpHistory.lowestPossibleTp
        mpHistory.marginIncreasedPotential = proposed_tp - snapdealPricing.ourTp
        mpHistory.totalSeller = snapdealDetails.totalSeller
        mpHistory.avgSales = (itemSaleMap.get(snapdealItemInfo.item_id))[3]
        mpHistory.timestamp = timestamp
        mpHistory.run = RunType._NAMES_TO_VALUES.get(snapdealItemInfo.runType)
        buyBoxList.append(mpHistory)
    session.commit()
    return buyBoxList 

Subversion Repositories SmartDukaan

(root)/trunk/PyProj/src/shop2020/model/v1/catalog/script/SnapdealHistoryPopulator.py – Rev 11045 → 11060

Rev 11045		Rev 11060
Line 1254...		Line 1254...
1254	`mpHistory.ourRank = snapdealDetails.rank`	1254	`mpHistory.ourRank = snapdealDetails.rank`
1255	`mpHistory.risky = snapdealItemInfo.risky`	1255	`mpHistory.risky = snapdealItemInfo.risky`
1256	`mpHistory.margin = mpHistory.ourTp - mpHistory.lowestPossibleTp`	1256	`mpHistory.margin = mpHistory.ourTp - mpHistory.lowestPossibleTp`
1257	`mpHistory.competitiveCategory = CompetitionCategory.NEGATIVE_MARGIN`	1257	`mpHistory.competitiveCategory = CompetitionCategory.NEGATIVE_MARGIN`
1258	`mpHistory.totalSeller = snapdealDetails.totalSeller`	1258	`mpHistory.totalSeller = snapdealDetails.totalSeller`
1259	`mpHistory.avgSales = (itemSaleMap.get(snapdealItemInfo.item_id))[2]`	1259	`mpHistory.avgSales = (itemSaleMap.get(snapdealItemInfo.item_id))[3]`
1260	`mpHistory.timestamp = timestamp`	1260	`mpHistory.timestamp = timestamp`
1261	`mpHistory.run = RunType._NAMES_TO_VALUES.get(snapdealItemInfo.runType)`	1261	`mpHistory.run = RunType._NAMES_TO_VALUES.get(snapdealItemInfo.runType)`
1262	`negativeMarginItems.append(mpHistory)`	1262	`negativeMarginItems.append(mpHistory)`
1263	`session.commit()`	1263	`session.commit()`
1264	`return negativeMarginItems`	1264	`return negativeMarginItems`
Line 1302...		Line 1302...
1302	`proposed_tp = getTargetTp(proposed_sp,mpItem)`	1302	`proposed_tp = getTargetTp(proposed_sp,mpItem)`
1303	`mpHistory.proposedSellingPrice = round(proposed_sp,2)`	1303	`mpHistory.proposedSellingPrice = round(proposed_sp,2)`
1304	`mpHistory.proposedTp = round(proposed_tp,2)`	1304	`mpHistory.proposedTp = round(proposed_tp,2)`
1305	`mpHistory.margin = mpHistory.ourTp - mpHistory.lowestPossibleTp`	1305	`mpHistory.margin = mpHistory.ourTp - mpHistory.lowestPossibleTp`
1306	`mpHistory.totalSeller = snapdealDetails.totalSeller`	1306	`mpHistory.totalSeller = snapdealDetails.totalSeller`
1307	`mpHistory.avgSales = (itemSaleMap.get(snapdealItemInfo.item_id))[2]`	1307	`mpHistory.avgSales = (itemSaleMap.get(snapdealItemInfo.item_id))[3]`
1308	`mpHistory.salesPotential = SalesPotential._NAMES_TO_VALUES.get(getSalesPotential(snapdealDetails.lowestOfferPrice,snapdealItemInfo.nlc))`	1308	`mpHistory.salesPotential = SalesPotential._NAMES_TO_VALUES.get(getSalesPotential(snapdealDetails.lowestOfferPrice,snapdealItemInfo.nlc))`
1309	`mpHistory.timestamp = timestamp`	1309	`mpHistory.timestamp = timestamp`
1310	`mpHistory.run = RunType._NAMES_TO_VALUES.get(snapdealItemInfo.runType)`	1310	`mpHistory.run = RunType._NAMES_TO_VALUES.get(snapdealItemInfo.runType)`
1311	`competitiveItems.append(mpHistory)`	1311	`competitiveItems.append(mpHistory)`
1312	`session.commit()`	1312	`session.commit()`
Line 1351...		Line 1351...
1351	`proposed_tp = getTargetTp(proposed_sp,mpItem)`	1351	`proposed_tp = getTargetTp(proposed_sp,mpItem)`
1352	`mpHistory.proposedSellingPrice = round(proposed_sp,2)`	1352	`mpHistory.proposedSellingPrice = round(proposed_sp,2)`
1353	`mpHistory.proposedTp = round(proposed_tp,2)`	1353	`mpHistory.proposedTp = round(proposed_tp,2)`
1354	`mpHistory.margin = mpHistory.ourTp - mpHistory.lowestPossibleTp`	1354	`mpHistory.margin = mpHistory.ourTp - mpHistory.lowestPossibleTp`
1355	`mpHistory.totalSeller = snapdealDetails.totalSeller`	1355	`mpHistory.totalSeller = snapdealDetails.totalSeller`
1356	`mpHistory.avgSales = (itemSaleMap.get(snapdealItemInfo.item_id))[2]`	1356	`mpHistory.avgSales = (itemSaleMap.get(snapdealItemInfo.item_id))[3]`
1357	`mpHistory.salesPotential = SalesPotential._NAMES_TO_VALUES.get(getSalesPotential(snapdealDetails.lowestOfferPrice,snapdealItemInfo.nlc))`	1357	`mpHistory.salesPotential = SalesPotential._NAMES_TO_VALUES.get(getSalesPotential(snapdealDetails.lowestOfferPrice,snapdealItemInfo.nlc))`
1358	`mpHistory.timestamp = timestamp`	1358	`mpHistory.timestamp = timestamp`
1359	`mpHistory.run = RunType._NAMES_TO_VALUES.get(snapdealItemInfo.runType)`	1359	`mpHistory.run = RunType._NAMES_TO_VALUES.get(snapdealItemInfo.runType)`
1360	`competitiveNoInventoryItems.append(mpHistory)`	1360	`competitiveNoInventoryItems.append(mpHistory)`
1361	`session.commit()`	1361	`session.commit()`
Line 1404...		Line 1404...
1404	`mpHistory.proposedSellingPrice = round(proposed_sp,2)`	1404	`mpHistory.proposedSellingPrice = round(proposed_sp,2)`
1405	`mpHistory.proposedTp = round(proposed_tp,2)`	1405	`mpHistory.proposedTp = round(proposed_tp,2)`
1406	`mpHistory.targetNlc = round(target_nlc,2)`	1406	`mpHistory.targetNlc = round(target_nlc,2)`
1407	`mpHistory.margin = mpHistory.ourTp - mpHistory.lowestPossibleTp`	1407	`mpHistory.margin = mpHistory.ourTp - mpHistory.lowestPossibleTp`
1408	`mpHistory.totalSeller = snapdealDetails.totalSeller`	1408	`mpHistory.totalSeller = snapdealDetails.totalSeller`
1409	`mpHistory.avgSales = (itemSaleMap.get(snapdealItemInfo.item_id))[2]`	1409	`mpHistory.avgSales = (itemSaleMap.get(snapdealItemInfo.item_id))[3]`
1410	`mpHistory.salesPotential = SalesPotential._NAMES_TO_VALUES.get(getSalesPotential(snapdealDetails.lowestOfferPrice,snapdealItemInfo.nlc))`	1410	`mpHistory.salesPotential = SalesPotential._NAMES_TO_VALUES.get(getSalesPotential(snapdealDetails.lowestOfferPrice,snapdealItemInfo.nlc))`
1411	`mpHistory.timestamp = timestamp`	1411	`mpHistory.timestamp = timestamp`
1412	`mpHistory.run = RunType._NAMES_TO_VALUES.get(snapdealItemInfo.runType)`	1412	`mpHistory.run = RunType._NAMES_TO_VALUES.get(snapdealItemInfo.runType)`
1413	`cantComepeteItems.append(mpHistory)`	1413	`cantComepeteItems.append(mpHistory)`
1414	`session.commit()`	1414	`session.commit()`
Line 1462...		Line 1462...
1462	`mpHistory.proposedTp = round(proposed_tp,2)`	1462	`mpHistory.proposedTp = round(proposed_tp,2)`
1463	`#mpHistory.targetNlc = target_nlc`	1463	`#mpHistory.targetNlc = target_nlc`
1464	`mpHistory.margin = mpHistory.ourTp - mpHistory.lowestPossibleTp`	1464	`mpHistory.margin = mpHistory.ourTp - mpHistory.lowestPossibleTp`
1465	`mpHistory.marginIncreasedPotential = proposed_tp - snapdealPricing.ourTp`	1465	`mpHistory.marginIncreasedPotential = proposed_tp - snapdealPricing.ourTp`
1466	`mpHistory.totalSeller = snapdealDetails.totalSeller`	1466	`mpHistory.totalSeller = snapdealDetails.totalSeller`
1467	`mpHistory.avgSales = (itemSaleMap.get(snapdealItemInfo.item_id))[2]`	1467	`mpHistory.avgSales = (itemSaleMap.get(snapdealItemInfo.item_id))[3]`
1468	`mpHistory.timestamp = timestamp`	1468	`mpHistory.timestamp = timestamp`
1469	`mpHistory.run = RunType._NAMES_TO_VALUES.get(snapdealItemInfo.runType)`	1469	`mpHistory.run = RunType._NAMES_TO_VALUES.get(snapdealItemInfo.runType)`
1470	`buyBoxList.append(mpHistory)`	1470	`buyBoxList.append(mpHistory)`
1471	`session.commit()`	1471	`session.commit()`
1472	`return buyBoxList`	1472	`return buyBoxList`