| Line 43... |
Line 43... |
| 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,AmazonFbaSalesSnapshot, \
|
46 |
FRC, OperatorSeries, SourceDetail, Company, EbayOrder,AmazonFbaSalesSnapshot, \
|
| 47 |
AmazonOrder, StoreOrderDetail, EdcBank, StoreOrderCollection, HotspotServiceMatrix,\
|
47 |
AmazonOrder, StoreOrderDetail, EdcBank, StoreOrderCollection, HotspotServiceMatrix,\
|
| 48 |
SnapdealOrder,FlipkartOrder ,DataInsuranceDetailForOrder
|
48 |
SnapdealOrder,FlipkartOrder ,DataInsuranceDetailForOrder, AmazonFbaOrderReturns
|
| 49 |
from shop2020.model.v1.order.impl.model.BaseOrder import BaseOrder
|
49 |
from shop2020.model.v1.order.impl.model.BaseOrder import BaseOrder
|
| 50 |
from shop2020.model.v1.order.impl.model.DTHRechargeOrder import DTHRechargeOrder
|
50 |
from shop2020.model.v1.order.impl.model.DTHRechargeOrder import DTHRechargeOrder
|
| 51 |
from shop2020.model.v1.order.impl.model.MobileRechargeOrder import \
|
51 |
from shop2020.model.v1.order.impl.model.MobileRechargeOrder import \
|
| 52 |
MobileRechargeOrder
|
52 |
MobileRechargeOrder
|
| 53 |
from shop2020.model.v1.order.impl.model.RechargeDenomination import \
|
53 |
from shop2020.model.v1.order.impl.model.RechargeDenomination import \
|
| Line 6653... |
Line 6653... |
| 6653 |
print "order count"
|
6653 |
print "order count"
|
| 6654 |
print item[1]
|
6654 |
print item[1]
|
| 6655 |
item_ordercount[item[0]] = item[1]
|
6655 |
item_ordercount[item[0]] = item[1]
|
| 6656 |
print item_ordercount
|
6656 |
print item_ordercount
|
| 6657 |
return item_ordercount
|
6657 |
return item_ordercount
|
| 6658 |
'''
|
6658 |
|
| 6659 |
def change_easyship_mfn_order_txn_status(transaction_id, new_status, description, pickUp, orderType, source, shipTimestamp, deliveryTimeStamp):
|
6659 |
def change_easyship_mfn_order_txn_status(transaction_id, new_status, description, pickUp, orderType, source, shipTimestamp, deliveryTimeStamp):
|
| 6660 |
transaction = get_transaction(transaction_id)
|
6660 |
transaction = get_transaction(transaction_id)
|
| 6661 |
transaction.status = new_status
|
6661 |
transaction.status = new_status
|
| 6662 |
transaction.status_message = description
|
6662 |
transaction.status_message = description
|
| 6663 |
## Assign runner in case of delhi pincodes
|
6663 |
## Assign runner in case of delhi pincodes
|
| Line 6841... |
Line 6841... |
| 6841 |
order.otg = False
|
6841 |
order.otg = False
|
| 6842 |
except Exception as e:
|
6842 |
except Exception as e:
|
| 6843 |
print "Error inserting transaction Id: " + str(transaction_id) + " due to " + str(e)
|
6843 |
print "Error inserting transaction Id: " + str(transaction_id) + " due to " + str(e)
|
| 6844 |
|
6844 |
|
| 6845 |
return True
|
6845 |
return True
|
| - |
|
6846 |
|
| - |
|
6847 |
def update_amazon_fba_order_returns(fbaOrderReturns):
|
| - |
|
6848 |
for order_return in fbaOrderReturns:
|
| - |
|
6849 |
orderReturn = AmazonFbaOrderReturns.query.filter(AmazonFbaOrderReturns.amazonOrderId==order_return.amazonOrderId).filter(AmazonFbaOrderReturns.insertionTimestamp == to_py_date(order_return.insertionTimestamp)).filter(AmazonFbaOrderReturns.sku==order_return.sku).first()
|
| - |
|
6850 |
if orderReturn:
|
| - |
|
6851 |
orderReturn.sellableReturnQuantity = order_return.sellableReturnQuantity
|
| - |
|
6852 |
orderReturn.nonSellableReturnQuantity = order_return.nonSellableReturnQuantity
|
| - |
|
6853 |
session.commit()
|
| - |
|
6854 |
else:
|
| - |
|
6855 |
orderReturn = AmazonFbaOrderReturns()
|
| - |
|
6856 |
orderReturn.amazonOrderId = order_return.amazonOrderId
|
| - |
|
6857 |
orderReturn.insertionTimestamp = to_py_date(order_return.insertionTimestamp)
|
| - |
|
6858 |
orderReturn.sku = order_return.sku
|
| - |
|
6859 |
orderReturn.creationTimestamp = to_py_date(order_return.creationTimestamp)
|
| - |
|
6860 |
orderReturn.shippedQuantity = order_return.shippedQuantity
|
| - |
|
6861 |
orderReturn.sellableReturnQuantity = order_return.sellableReturnQuantity
|
| - |
|
6862 |
orderReturn.nonSellableReturnQuantity = order_return.nonSellableReturnQuantity
|
| - |
|
6863 |
session.commit()
|
| - |
|
6864 |
|
| - |
|
6865 |
def get_all_amazon_fba_order_returns(insertionTimestamp):
|
| - |
|
6866 |
returns = AmazonFbaOrderReturns.query.filter(AmazonFbaOrderReturns.insertionTimestamp==to_py_date(insertionTimestamp)).all()
|
| - |
|
6867 |
if not returns:
|
| - |
|
6868 |
returns = []
|
| - |
|
6869 |
return returns
|
| - |
|
6870 |
|
| - |
|
6871 |
def get_total_sale_returns_fba_skus_curent_time(insertionTimestamp):
|
| 6846 |
'''
|
6872 |
allFbaSkuDetails = session.query(AmazonFbaOrderReturns.sku, func.sum(AmazonFbaOrderReturns.shippedQuantity), func.sum(AmazonFbaOrderReturns.sellableReturnQuantity), func.sum(AmazonFbaOrderReturns.nonSellableReturnQuantity)).group_by(AmazonFbaOrderReturns.sku).filter(AmazonFbaOrderReturns.insertionTimestamp == to_py_date(insertionTimestamp)).all()
|
| - |
|
6873 |
|
| - |
|
6874 |
returnAllFbaSkuDetails = {}
|
| - |
|
6875 |
|
| - |
|
6876 |
for fbaSkuDetail in allFbaSkuDetails:
|
| - |
|
6877 |
saleReturnDetail = {}
|
| - |
|
6878 |
saleReturnDetail['Sale'] = fbaSkuDetail[1]
|
| - |
|
6879 |
saleReturnDetail['SaleableReturn'] = fbaSkuDetail[2]
|
| - |
|
6880 |
saleReturnDetail['NonSaleableReturn'] = fbaSkuDetail[3]
|
| - |
|
6881 |
returnAllFbaSkuDetails[fbaSkuDetail[0]]= saleReturnDetail
|
| - |
|
6882 |
|
| - |
|
6883 |
return returnAllFbaSkuDetails
|
| 6847 |
|
6884 |
|
| 6848 |
if __name__ == '__main__':
|
6885 |
if __name__ == '__main__':
|
| 6849 |
print get_orders_by_mobile_number("9650889334")
|
6886 |
print get_orders_by_mobile_number("9650889334")
|