| Line 2749... |
Line 2749... |
| 2749 |
|
2749 |
|
| 2750 |
def get_all_fbb_listed_items():
|
2750 |
def get_all_fbb_listed_items():
|
| 2751 |
return Amazonlisted.query.filter(Amazonlisted.isFbb==False).filter(Amazonlisted.fbbListedOn==None).filter(Amazonlisted.fbbtaxCode!=None).all()
|
2751 |
return Amazonlisted.query.filter(Amazonlisted.isFbb==False).filter(Amazonlisted.fbbListedOn==None).filter(Amazonlisted.fbbtaxCode!=None).all()
|
| 2752 |
|
2752 |
|
| 2753 |
def get_all_fbb_pricing_items():
|
2753 |
def get_all_fbb_pricing_items():
|
| - |
|
2754 |
#Removing fbbListedOn from query.Will have to fix this.(2014-10-17)
|
| 2754 |
return Amazonlisted.query.filter(Amazonlisted.isFbb==True).filter(Amazonlisted.suppressFbbPriceUpdate==False).filter(Amazonlisted.fbbListedOn != None).all()
|
2755 |
#return Amazonlisted.query.filter(Amazonlisted.isFbb==True).filter(Amazonlisted.suppressFbbPriceUpdate==False).filter(Amazonlisted.fbbListedOn != None).all()
|
| 2755 |
|
- |
|
| - |
|
2756 |
return Amazonlisted.query.filter(Amazonlisted.isFbb==True).filter(Amazonlisted.suppressFbbPriceUpdate==False).all()
|
| 2756 |
def get_count_for_marketplaceHistory(source,itemId):
|
2757 |
def get_count_for_marketplaceHistory(source,itemId):
|
| 2757 |
return len(session.query(MarketPlaceHistory).filter(MarketPlaceHistory.item_id==itemId).filter(MarketPlaceHistory.source==source).filter(or_(MarketPlaceHistory.toGroup==True,MarketPlaceHistory.toGroup==None)).all())
|
2758 |
return len(session.query(MarketPlaceHistory).filter(MarketPlaceHistory.item_id==itemId).filter(MarketPlaceHistory.source==source).filter(or_(MarketPlaceHistory.toGroup==True,MarketPlaceHistory.toGroup==None)).all())
|
| 2758 |
|
2759 |
|
| 2759 |
def get_marketplace_history_by_date(source,startDate,endDate,offset,limit,itemId):
|
2760 |
def get_marketplace_history_by_date(source,startDate,endDate,offset,limit,itemId):
|
| 2760 |
return session.query(MarketPlaceHistory).filter(MarketPlaceHistory.item_id==itemId).filter(MarketPlaceHistory.source==source).filter(MarketPlaceHistory.timestamp > to_py_date(startDate)).filter(MarketPlaceHistory.timestamp < to_py_date(endDate)).order_by(desc(MarketPlaceHistory.timestamp)).all()
|
2761 |
return session.query(MarketPlaceHistory).filter(MarketPlaceHistory.item_id==itemId).filter(MarketPlaceHistory.source==source).filter(MarketPlaceHistory.timestamp > to_py_date(startDate)).filter(MarketPlaceHistory.timestamp < to_py_date(endDate)).order_by(desc(MarketPlaceHistory.timestamp)).all()
|