| Line 6113... |
Line 6113... |
| 6113 |
amazon_fba_sales_snapshot.dateOfSale = to_py_date(amazonfbasalessnapshot.dateOfSale).date()
|
6113 |
amazon_fba_sales_snapshot.dateOfSale = to_py_date(amazonfbasalessnapshot.dateOfSale).date()
|
| 6114 |
amazon_fba_sales_snapshot.item_id = amazonfbasalessnapshot.item_id
|
6114 |
amazon_fba_sales_snapshot.item_id = amazonfbasalessnapshot.item_id
|
| 6115 |
amazon_fba_sales_snapshot.totalOrderCount = amazonfbasalessnapshot.totalOrderCount
|
6115 |
amazon_fba_sales_snapshot.totalOrderCount = amazonfbasalessnapshot.totalOrderCount
|
| 6116 |
amazon_fba_sales_snapshot.amazonFbaInventory = amazonfbasalessnapshot.amazonFbaInventory
|
6116 |
amazon_fba_sales_snapshot.amazonFbaInventory = amazonfbasalessnapshot.amazonFbaInventory
|
| 6117 |
amazon_fba_sales_snapshot.isOutOfStock = amazonfbasalessnapshot.isOutOfStock
|
6117 |
amazon_fba_sales_snapshot.isOutOfStock = amazonfbasalessnapshot.isOutOfStock
|
| 6118 |
amazon_fba_sales_snapshot.salePrice = amazonfbasalessnapshot.salePrice
|
- |
|
| 6119 |
amazon_fba_sales_snapshot.ourPrice = amazonfbasalessnapshot.ourPrice
|
- |
|
| 6120 |
amazon_fba_sales_snapshot.minFbaPrice = amazonfbasalessnapshot.minFbaPrice
|
- |
|
| 6121 |
amazon_fba_sales_snapshot.minMfnPrice = amazonfbasalessnapshot.minMfnPrice
|
- |
|
| 6122 |
amazon_fba_sales_snapshot.promotionOrderCount = amazonfbasalessnapshot.promotionOrderCount
|
6118 |
amazon_fba_sales_snapshot.promotionOrderCount = amazonfbasalessnapshot.promotionOrderCount
|
| 6123 |
amazon_fba_sales_snapshot.totalSale = amazonfbasalessnapshot.totalSale
|
6119 |
amazon_fba_sales_snapshot.totalSale = amazonfbasalessnapshot.totalSale
|
| 6124 |
amazon_fba_sales_snapshot.promotionSale = amazonfbasalessnapshot.promotionSale
|
6120 |
amazon_fba_sales_snapshot.promotionSale = amazonfbasalessnapshot.promotionSale
|
| - |
|
6121 |
#if amazonfbasalessnapshot.ourPrice is not None:
|
| - |
|
6122 |
amazon_fba_sales_snapshot.ourPriceSnapshotDate = to_py_date(amazonfbasalessnapshot.ourPriceSnapshotDate)
|
| - |
|
6123 |
amazon_fba_sales_snapshot.ourPrice = amazonfbasalessnapshot.ourPrice
|
| - |
|
6124 |
#if amazonfbasalessnapshot.salePrice is not None:
|
| - |
|
6125 |
amazon_fba_sales_snapshot.salePriceSnapshotDate = to_py_date(amazonfbasalessnapshot.salePriceSnapshotDate)
|
| - |
|
6126 |
amazon_fba_sales_snapshot.salePrice = amazonfbasalessnapshot.salePrice
|
| - |
|
6127 |
#if amazonfbasalessnapshot.minFbaPrice is not None:
|
| - |
|
6128 |
amazon_fba_sales_snapshot.minFbaPriceSnapshotDate = to_py_date(amazonfbasalessnapshot.minFbaPriceSnapshotDate)
|
| - |
|
6129 |
amazon_fba_sales_snapshot.minFbaPrice = amazonfbasalessnapshot.minFbaPrice
|
| - |
|
6130 |
#if amazonfbasalessnapshot.minMfnPrice is not None:
|
| - |
|
6131 |
amazon_fba_sales_snapshot.minMfnPriceSnapshotDate = to_py_date(amazonfbasalessnapshot.minMfnPriceSnapshotDate)
|
| - |
|
6132 |
amazon_fba_sales_snapshot.minMfnPrice = amazonfbasalessnapshot.minMfnPrice
|
| - |
|
6133 |
|
| 6125 |
else:
|
6134 |
else:
|
| 6126 |
salesnapshotfordate.promotionOrderCount = amazonfbasalessnapshot.promotionOrderCount
|
6135 |
salesnapshotfordate.promotionOrderCount = amazonfbasalessnapshot.promotionOrderCount
|
| 6127 |
salesnapshotfordate.totalSale = amazonfbasalessnapshot.totalSale
|
6136 |
salesnapshotfordate.totalSale = amazonfbasalessnapshot.totalSale
|
| 6128 |
salesnapshotfordate.promotionSale = amazonfbasalessnapshot.promotionSale
|
6137 |
salesnapshotfordate.promotionSale = amazonfbasalessnapshot.promotionSale
|
| 6129 |
salesnapshotfordate.totalOrderCount = amazonfbasalessnapshot.totalOrderCount
|
6138 |
salesnapshotfordate.totalOrderCount = amazonfbasalessnapshot.totalOrderCount
|
| 6130 |
|
- |
|
| 6131 |
session.commit()
|
6139 |
session.commit()
|
| 6132 |
|
6140 |
|
| 6133 |
def get_amazon_fba_sales_snapshot_for_days(interval):
|
6141 |
def get_amazon_fba_sales_snapshot_for_days(interval):
|
| 6134 |
date = datetime.datetime.now()
|
6142 |
date = datetime.datetime.now()
|
| 6135 |
toDate = date-timedelta(days = 1)
|
6143 |
toDate = date-timedelta(days = 1)
|
| 6136 |
fromDate = toDate-timedelta(days = interval)
|
6144 |
fromDate = toDate-timedelta(days = interval)
|
| 6137 |
fbasalessnapshot = AmazonFbaSalesSnapshot.query.filter(AmazonFbaSalesSnapshot.dateOfSale.between (fromDate.date(),toDate.date())).order_by(AmazonFbaSalesSnapshot.dateOfSale).all()
|
6145 |
fbasalessnapshot = AmazonFbaSalesSnapshot.query.filter(AmazonFbaSalesSnapshot.dateOfSale.between (fromDate.date(),toDate.date())).order_by(AmazonFbaSalesSnapshot.dateOfSale).all()
|
| 6138 |
print fbasalessnapshot
|
6146 |
print fbasalessnapshot
|
| 6139 |
return fbasalessnapshot
|
6147 |
return fbasalessnapshot
|
| 6140 |
|
6148 |
|
| 6141 |
def create_snapdeal_order(t_snapdeal_order):
|
6149 |
def create_snapdeal_order(t_snapdeal_order):
|
| 6142 |
snapdealOrder = SnapdealOrder()
|
6150 |
snapdealOrder = SnapdealOrder()
|
| 6143 |
snapdealOrder.orderId = t_snapdeal_order.orderId
|
6151 |
snapdealOrder.orderId = t_snapdeal_order.orderId
|
| 6144 |
snapdealOrder.subOrderId = t_snapdeal_order.subOrderId
|
6152 |
snapdealOrder.subOrderId = t_snapdeal_order.subOrderId
|
| 6145 |
snapdealOrder.referenceCode = t_snapdeal_order.referenceCode
|
6153 |
snapdealOrder.referenceCode = t_snapdeal_order.referenceCode
|
| Line 6162... |
Line 6170... |
| 6162 |
snapdeal_order = SnapdealOrder.get_by(subOrderId = suborder_id)
|
6170 |
snapdeal_order = SnapdealOrder.get_by(subOrderId = suborder_id)
|
| 6163 |
if snapdeal_order is not None:
|
6171 |
if snapdeal_order is not None:
|
| 6164 |
return True
|
6172 |
return True
|
| 6165 |
else:
|
6173 |
else:
|
| 6166 |
return False
|
6174 |
return False
|
| 6167 |
|
6175 |
|
| 6168 |
def get_amazon_fba_sales_latest_snapshot_for_item(item_id):
|
6176 |
def get_amazon_fba_sales_latest_snapshot_for_item(item_id):
|
| 6169 |
return AmazonFbaSalesSnapshot.query.filter(AmazonFbaSalesSnapshot.item_id==item_id).order_by(desc(AmazonFbaSalesSnapshot.dateOfSale)).first()
|
6177 |
return AmazonFbaSalesSnapshot.query.filter(AmazonFbaSalesSnapshot.item_id==item_id).order_by(desc(AmazonFbaSalesSnapshot.dateOfSale)).first()
|
| 6170 |
|
6178 |
|
| - |
|
6179 |
def update_latest_fba_prices_for_item(fbaitemprices):
|
| - |
|
6180 |
fbasalessnapshot = AmazonFbaSalesSnapshot.query.filter(AmazonFbaSalesSnapshot.item_id==fbaitemprices.item_id).order_by(desc(AmazonFbaSalesSnapshot.dateOfSale)).first()
|
| - |
|
6181 |
if(fbasalessnapshot.ourPriceSnapshotDate < to_java_date(fbaitemprices.ourPriceSnapshotDate) and fbaitemprices.ourPrice is not None):
|
| - |
|
6182 |
fbasalessnapshot.ourPriceSnapshotDate = to_py_date(fbaitemprices.ourPriceSnapshotDate)
|
| - |
|
6183 |
fbasalessnapshot.ourPrice = fbaitemprices.ourPrice
|
| - |
|
6184 |
if(fbasalessnapshot.salePriceSnapshotDate < to_java_date(fbaitemprices.salePriceSnapshotDate) and fbaitemprices.salePrice is not None):
|
| - |
|
6185 |
fbasalessnapshot.salePriceSnapshotDate = to_py_date(fbaitemprices.salePriceSnapshotDate)
|
| - |
|
6186 |
fbasalessnapshot.salePrice = fbaitemprices.salePrice
|
| - |
|
6187 |
if(fbasalessnapshot.minFbaPriceSnapshotDate < to_java_date(fbaitemprices.minFbaPriceSnapshotDate) and fbaitemprices.minFbaPrice is not None):
|
| - |
|
6188 |
fbasalessnapshot.minFbaPriceSnapshotDate = to_py_date(fbaitemprices.minFbaPriceSnapshotDate)
|
| - |
|
6189 |
fbasalessnapshot.minFbaPrice = fbaitemprices.minFbaPrice
|
| - |
|
6190 |
if(fbasalessnapshot.minMfnPriceSnapshotDate < to_java_date(fbaitemprices.minMfnPriceSnapshotDate) and fbaitemprices.minMfnPrice is not None):
|
| - |
|
6191 |
fbasalessnapshot.minMfnPriceSnapshotDate = to_py_date(fbaitemprices.minMfnPriceSnapshotDate)
|
| - |
|
6192 |
fbasalessnapshot.minMfnPrice = fbaitemprices.minMfnPrice
|
| - |
|
6193 |
session.commit()
|
| 6171 |
|
6194 |
|
| 6172 |
if __name__ == '__main__':
|
6195 |
if __name__ == '__main__':
|
| 6173 |
print get_orders_by_mobile_number("9650889334")
|
6196 |
print get_orders_by_mobile_number("9650889334")
|
| 6174 |
|
6197 |
|