| Line 6096... |
Line 6096... |
| 6096 |
salesnapshotfordate = AmazonFbaSalesSnapshot.get_by(item_id = amazonfbasalessnapshot.item_id,dateOfSale=to_py_date(amazonfbasalessnapshot.dateOfSale).date())
|
6096 |
salesnapshotfordate = AmazonFbaSalesSnapshot.get_by(item_id = amazonfbasalessnapshot.item_id,dateOfSale=to_py_date(amazonfbasalessnapshot.dateOfSale).date())
|
| 6097 |
if salesnapshotfordate is None:
|
6097 |
if salesnapshotfordate is None:
|
| 6098 |
amazon_fba_sales_snapshot = AmazonFbaSalesSnapshot()
|
6098 |
amazon_fba_sales_snapshot = AmazonFbaSalesSnapshot()
|
| 6099 |
amazon_fba_sales_snapshot.dateOfSale = to_py_date(amazonfbasalessnapshot.dateOfSale).date()
|
6099 |
amazon_fba_sales_snapshot.dateOfSale = to_py_date(amazonfbasalessnapshot.dateOfSale).date()
|
| 6100 |
amazon_fba_sales_snapshot.item_id = amazonfbasalessnapshot.item_id
|
6100 |
amazon_fba_sales_snapshot.item_id = amazonfbasalessnapshot.item_id
|
| 6101 |
amazon_fba_sales_snapshot.orderCount = amazonfbasalessnapshot.orderCount
|
6101 |
amazon_fba_sales_snapshot.totalOrderCount = amazonfbasalessnapshot.totalOrderCount
|
| 6102 |
amazon_fba_sales_snapshot.amazonFbaInventory = amazonfbasalessnapshot.amazonFbaInventory
|
6102 |
amazon_fba_sales_snapshot.amazonFbaInventory = amazonfbasalessnapshot.amazonFbaInventory
|
| 6103 |
amazon_fba_sales_snapshot.isOutOfStock = amazonfbasalessnapshot.isOutOfStock
|
6103 |
amazon_fba_sales_snapshot.isOutOfStock = amazonfbasalessnapshot.isOutOfStock
|
| 6104 |
amazon_fba_sales_snapshot.salePrice = amazonfbasalessnapshot.salePrice
|
6104 |
amazon_fba_sales_snapshot.salePrice = amazonfbasalessnapshot.salePrice
|
| 6105 |
amazon_fba_sales_snapshot.minFbaPrice = amazonfbasalessnapshot.minFbaPrice
|
6105 |
amazon_fba_sales_snapshot.minFbaPrice = amazonfbasalessnapshot.minFbaPrice
|
| 6106 |
amazon_fba_sales_snapshot.minMfnPrice = amazonfbasalessnapshot.minMfnPrice
|
6106 |
amazon_fba_sales_snapshot.minMfnPrice = amazonfbasalessnapshot.minMfnPrice
|
| - |
|
6107 |
amazon_fba_sales_snapshot.promotionOrderCount = amazonfbasalessnapshot.promotionOrderCount
|
| - |
|
6108 |
amazon_fba_sales_snapshot.totalSale = amazonfbasalessnapshot.totalSale
|
| - |
|
6109 |
amazon_fba_sales_snapshot.promotionSale = amazonfbasalessnapshot.promotionSale
|
| 6107 |
else:
|
6110 |
else:
|
| - |
|
6111 |
salesnapshotfordate.promotionOrderCount = amazonfbasalessnapshot.promotionOrderCount
|
| - |
|
6112 |
salesnapshotfordate.totalSale = amazonfbasalessnapshot.totalSale
|
| - |
|
6113 |
salesnapshotfordate.promotionSale = amazonfbasalessnapshot.promotionSale
|
| 6108 |
salesnapshotfordate.orderCount = amazonfbasalessnapshot.orderCount
|
6114 |
salesnapshotfordate.totalOrderCount = amazonfbasalessnapshot.totalOrderCount
|
| - |
|
6115 |
|
| 6109 |
session.commit()
|
6116 |
session.commit()
|
| 6110 |
|
6117 |
|
| 6111 |
def get_amazon_fba_sales_snapshot_for_days(interval):
|
6118 |
def get_amazon_fba_sales_snapshot_for_days(interval):
|
| 6112 |
toDate = datetime.datetime.now()
|
6119 |
toDate = datetime.datetime.now()
|
| 6113 |
fromDate = toDate-timedelta(days = interval)
|
6120 |
fromDate = toDate-timedelta(days = interval)
|
| 6114 |
fbasalessnapshot = AmazonFbaSalesSnapshot.query.filter(AmazonFbaSalesSnapshot.dateOfSale.between (fromDate.date(),toDate.date())).order_by(AmazonFbaSalesSnapshot.dateOfSale).all()
|
6121 |
fbasalessnapshot = AmazonFbaSalesSnapshot.query.filter(AmazonFbaSalesSnapshot.dateOfSale.between (fromDate.date(),toDate.date())).order_by(AmazonFbaSalesSnapshot.dateOfSale).all()
|
| 6115 |
print fbasalessnapshot
|
6122 |
print fbasalessnapshot
|
| 6116 |
return fbasalessnapshot
|
6123 |
return fbasalessnapshot
|
| 6117 |
|
6124 |
|
| 6118 |
def get_amazon_fba_sales_latest_snapshot_for_item(item_id):
|
6125 |
def get_amazon_fba_sales_latest_snapshot_for_item(item_id):
|
| 6119 |
print session.query(func.max(AmazonFbaSalesSnapshot.dateOfSale),AmazonFbaSalesSnapshot).filter(AmazonFbaSalesSnapshot.item_id==item_id).first()
|
- |
|
| 6120 |
return session.query(func.max(AmazonFbaSalesSnapshot.dateOfSale),AmazonFbaSalesSnapshot).filter(AmazonFbaSalesSnapshot.item_id==item_id).first()
|
6126 |
return AmazonFbaSalesSnapshot.query.filter(AmazonFbaSalesSnapshot.item_id==item_id).order_by(desc(AmazonFbaSalesSnapshot.dateOfSale)).first()
|
| 6121 |
|
6127 |
|
| 6122 |
|
6128 |
|
| 6123 |
if __name__ == '__main__':
|
6129 |
if __name__ == '__main__':
|
| 6124 |
print get_orders_by_mobile_number("9650889334")
|
6130 |
print get_orders_by_mobile_number("9650889334")
|
| 6125 |
|
6131 |
|