Subversion Repositories SmartDukaan

Rev

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

Rev 22566 Rev 22636
Line 3491... Line 3491...
3491
        
3491
        
3492
    return itemWarrantyMap
3492
    return itemWarrantyMap
3493
 
3493
 
3494
def get_all_fofo_deals(itemIds, tagIds):
3494
def get_all_fofo_deals(itemIds, tagIds):
3495
    returnMap = {}
3495
    returnMap = {}
-
 
3496
    
3496
    tagListings = session.query(Tag_Listing).join((Item, Item.id==Tag_Listing.item_id)).filter(or_(Item.status==status.ACTIVE).filter(Tag_Listing.active==True).filter(Item.id.in_(itemIds))).filter(Tag_Listing.tag_id.in_(tagIds)).all()
3497
    query = session.query(Tag_Listing).join((Item, Item.id==Tag_Listing.item_id)).filter(Item.status==status.ACTIVE).filter(Tag_Listing.active==True)
-
 
3498
    if itemIds:
-
 
3499
        query = query.filter(Item.id.in_(itemIds))
-
 
3500
    else:
-
 
3501
        return returnMap
-
 
3502
    if tagIds:
-
 
3503
        query.filter(Tag_Listing.tag_id.in_(tagIds))
-
 
3504
    else:
-
 
3505
        returnMap
3497
    for tagListing in tagListings:
3506
    for tagListing in tagListings:
3498
        if returnMap.has_key(tagListing.item_id):
3507
        if returnMap.has_key(tagListing.item_id):
3499
            if tagListing.selling_price > returnMap.get(tagListing.item_id):
3508
            if tagListing.selling_price > returnMap.get(tagListing.item_id):
3500
                returnMap[tagListing.item_id] = tagListing.selling_price
3509
                returnMap[tagListing.item_id] = tagListing.selling_price
3501
        else:
3510
        else:
Line 3503... Line 3512...
3503
    return returnMap
3512
    return returnMap
3504
             
3513
             
3505
 
3514
 
3506
if __name__=='__main__':
3515
if __name__=='__main__':
3507
    DataService.initialize()
3516
    DataService.initialize()
-
 
3517
    tagListings = session.query(Tag_Listing).join((Item, Item.id==Tag_Listing.item_id)).filter(Item.status==status.ACTIVE).filter(Tag_Listing.active==True).filter(Item.id.in_(itemIds)).filter(Tag_Listing.tag_id.in_(tagIds))
3508
    #update_bulk_prices_on_production(21053,[])
3518
    #update_bulk_prices_on_production(21053,[])
3509
    search_terms = ["12206"]
3519
    #search_terms = ["12206"]
3510
    print search_items(search_terms, 0, 20)
3520
    #print search_items(search_terms, 0, 20)
3511
    print get_search_result_count(search_terms)
3521
    #print get_search_result_count(search_terms)
3512
    
3522
    
3513
3523