| Line 41... |
Line 41... |
| 41 |
Order, BatchNoGenerator, InvoiceIDGenerator, TransactionRequiringExtraProcessing, \
|
41 |
Order, BatchNoGenerator, InvoiceIDGenerator, TransactionRequiringExtraProcessing, \
|
| 42 |
OrderInventory, Alert, PaymentSettlement, EBSSettlementSummary, \
|
42 |
OrderInventory, Alert, PaymentSettlement, EBSSettlementSummary, \
|
| 43 |
CodVerificationAgent, Attribute, RechargeVoucherTracker, EmiScheme, MiscCharges, \
|
43 |
CodVerificationAgent, Attribute, RechargeVoucherTracker, EmiScheme, MiscCharges, \
|
| 44 |
BlockedIpRange, DeniedIpAddress, InsuranceDetailForOrder, DocumentStore, \
|
44 |
BlockedIpRange, DeniedIpAddress, InsuranceDetailForOrder, DocumentStore, \
|
| 45 |
RechargeTransaction, HotspotStore, WalletForCompany, WalletHistoryForCompany, \
|
45 |
RechargeTransaction, HotspotStore, WalletForCompany, WalletHistoryForCompany, \
|
| 46 |
FRC, OperatorSeries, SourceDetail, Company, EbayOrder, \
|
46 |
FRC, OperatorSeries, SourceDetail, Company, EbayOrder,AmazonFbaSalesSnapshot, \
|
| 47 |
AmazonOrder, StoreOrderDetail, EdcBank, StoreOrderCollection, HotspotServiceMatrix
|
47 |
AmazonOrder, StoreOrderDetail, EdcBank, StoreOrderCollection, HotspotServiceMatrix
|
| 48 |
from shop2020.model.v1.order.impl.model.BaseOrder import BaseOrder
|
48 |
from shop2020.model.v1.order.impl.model.BaseOrder import BaseOrder
|
| 49 |
from shop2020.model.v1.order.impl.model.DTHRechargeOrder import DTHRechargeOrder
|
49 |
from shop2020.model.v1.order.impl.model.DTHRechargeOrder import DTHRechargeOrder
|
| 50 |
from shop2020.model.v1.order.impl.model.MobileRechargeOrder import \
|
50 |
from shop2020.model.v1.order.impl.model.MobileRechargeOrder import \
|
| 51 |
MobileRechargeOrder
|
51 |
MobileRechargeOrder
|
| Line 6066... |
Line 6066... |
| 6066 |
order.lineitems[0].total_price = order.lineitems[0].unit_price * order.lineitems[0].quantity
|
6066 |
order.lineitems[0].total_price = order.lineitems[0].unit_price * order.lineitems[0].quantity
|
| 6067 |
order.total_amount = order.lineitems[0].total_price
|
6067 |
order.total_amount = order.lineitems[0].total_price
|
| 6068 |
|
6068 |
|
| 6069 |
session.commit()
|
6069 |
session.commit()
|
| 6070 |
return new_order
|
6070 |
return new_order
|
| - |
|
6071 |
|
| - |
|
6072 |
def add_or_update_amazon_fba_sales_snapshot(amazonfbasalessnapshot):
|
| - |
|
6073 |
salesnapshotfordate = AmazonFbaSalesSnapshot.get_by(item_id = amazonfbasalessnapshot.item_id,dateOfSale=to_py_date(amazonfbasalessnapshot.dateOfSale).date())
|
| - |
|
6074 |
if salesnapshotfordate is None:
|
| - |
|
6075 |
amazon_fba_sales_snapshot = AmazonFbaSalesSnapshot()
|
| - |
|
6076 |
amazon_fba_sales_snapshot.dateOfSale = to_py_date(amazonfbasalessnapshot.dateOfSale).date()
|
| - |
|
6077 |
amazon_fba_sales_snapshot.item_id = amazonfbasalessnapshot.item_id
|
| - |
|
6078 |
amazon_fba_sales_snapshot.orderCount = amazonfbasalessnapshot.orderCount
|
| - |
|
6079 |
amazon_fba_sales_snapshot.amazonFbaInventory = amazonfbasalessnapshot.amazonFbaInventory
|
| - |
|
6080 |
amazon_fba_sales_snapshot.isOutOfStock = amazonfbasalessnapshot.isOutOfStock
|
| - |
|
6081 |
amazon_fba_sales_snapshot.salePrice = amazonfbasalessnapshot.salePrice
|
| - |
|
6082 |
amazon_fba_sales_snapshot.minFbaPrice = amazonfbasalessnapshot.minFbaPrice
|
| - |
|
6083 |
amazon_fba_sales_snapshot.minMfnPrice = amazonfbasalessnapshot.minMfnPrice
|
| - |
|
6084 |
else:
|
| - |
|
6085 |
salesnapshotfordate.orderCount = amazonfbasalessnapshot.orderCount
|
| - |
|
6086 |
session.commit()
|
| - |
|
6087 |
|
| - |
|
6088 |
def get_amazon_fba_sales_snapshot_for_days(interval):
|
| - |
|
6089 |
toDate = datetime.datetime.now()
|
| - |
|
6090 |
fromDate = toDate-timedelta(days = interval)
|
| - |
|
6091 |
fbasalessnapshot = AmazonFbaSalesSnapshot.query.filter(AmazonFbaSalesSnapshot.dateOfSale.between (fromDate.date(),toDate.date())).order_by(AmazonFbaSalesSnapshot.dateOfSale).all()
|
| - |
|
6092 |
print fbasalessnapshot
|
| - |
|
6093 |
return fbasalessnapshot
|
| - |
|
6094 |
|
| - |
|
6095 |
def get_amazon_fba_sales_latest_snapshot_for_item(item_id):
|
| - |
|
6096 |
print session.query(func.max(AmazonFbaSalesSnapshot.dateOfSale),AmazonFbaSalesSnapshot).filter(AmazonFbaSalesSnapshot.item_id==item_id).first()
|
| - |
|
6097 |
return session.query(func.max(AmazonFbaSalesSnapshot.dateOfSale),AmazonFbaSalesSnapshot).filter(AmazonFbaSalesSnapshot.item_id==item_id).first()
|
| - |
|
6098 |
|
| 6071 |
|
6099 |
|
| 6072 |
if __name__ == '__main__':
|
6100 |
if __name__ == '__main__':
|
| 6073 |
print get_orders_by_mobile_number("9650889334")
|
6101 |
print get_orders_by_mobile_number("9650889334")
|
| 6074 |
|
6102 |
|