Subversion Repositories SmartDukaan

Rev

Rev 12317 | Rev 12322 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 12317 Rev 12319
Line 2734... Line 2734...
2734 
    inactiveAutoPricing = session.query(MarketPlaceHistory,Item,MarketplaceItems).join((Item,MarketPlaceHistory.item_id==Item.id)).join((MarketplaceItems,MarketPlaceHistory.item_id==MarketplaceItems.itemId)).filter(MarketplaceItems.source==OrderSource.FLIPKART).filter(MarketPlaceHistory.timestamp==timestamp).filter(MarketPlaceHistory.source==OrderSource.FLIPKART).filter(or_(MarketplaceItems.autoDecrement==0,MarketplaceItems.autoIncrement==0)).filter(MarketPlaceHistory.competitiveCategory.in_([CompetitionCategory.BUY_BOX,CompetitionCategory.COMPETITIVE,CompetitionCategory.PREF_BUT_NOT_CHEAP])).all()
 2734 
    inactiveAutoPricing = session.query(MarketPlaceHistory,Item,MarketplaceItems).join((Item,MarketPlaceHistory.item_id==Item.id)).join((MarketplaceItems,MarketPlaceHistory.item_id==MarketplaceItems.itemId)).filter(MarketplaceItems.source==OrderSource.FLIPKART).filter(MarketPlaceHistory.timestamp==timestamp).filter(MarketPlaceHistory.source==OrderSource.FLIPKART).filter(or_(MarketplaceItems.autoDecrement==0,MarketplaceItems.autoIncrement==0)).filter(MarketPlaceHistory.competitiveCategory.in_([CompetitionCategory.BUY_BOX,CompetitionCategory.COMPETITIVE,CompetitionCategory.PREF_BUT_NOT_CHEAP])).all()
2735 
    if len(inactiveAutoPricing) == 0:
 2735 
    if len(inactiveAutoPricing) == 0:
2736 
        return
 2736 
        return
2737 
    message="""<html>
 2737 
    message="""<html>
2738 
            <body>
 2738 
            <body>
2739 
            <h3 style="color:red;font-weight:bold;">Flipkart Competitive But No Inventory</h3>
 2739 
            <h3 style="color:red;font-weight:bold;">Flipkart Inactive Auto Pricing</h3>
2740 
            <table border="1" style="width:100%;">
 2740 
            <table border="1" style="width:100%;">
2741 
            <thead>
 2741 
            <thead>
2742 
            <tr><th>Item Id</th>
 2742 
            <tr><th>Item Id</th>
2743 
            <th>Product Name</th>
 2743 
            <th>Product Name</th>
2744 
            <th>Selling Price</th>
 2744 
            <th>Selling Price</th>