| Line 47... |
Line 47... |
| 47 |
AmazonFbaOrderReturns, FlipkartAdvantageOrder, InvoiceCounterGenerator, \
|
47 |
AmazonFbaOrderReturns, FlipkartAdvantageOrder, InvoiceCounterGenerator, \
|
| 48 |
TransactionShipmentSequence, HsOrder, Creditor, UserSanction, CreditHistory, \
|
48 |
TransactionShipmentSequence, HsOrder, Creditor, UserSanction, CreditHistory, \
|
| 49 |
LoanHistory, ShipmentLogisticsCostDetail, ReturnOrderInfo, ReturnTransaction, \
|
49 |
LoanHistory, ShipmentLogisticsCostDetail, ReturnOrderInfo, ReturnTransaction, \
|
| 50 |
ReturnPickupRequest, SellerWarehouse, Seller, Organisation, \
|
50 |
ReturnPickupRequest, SellerWarehouse, Seller, Organisation, \
|
| 51 |
WarehouseAddressMapping, WarehouseAddressMaster, PMSA, PMSA_Agents, \
|
51 |
WarehouseAddressMapping, WarehouseAddressMaster, PMSA, PMSA_Agents, \
|
| 52 |
AdvancePayments, CodCourierPaymentRemittance
|
52 |
AdvancePayments, CodCourierPaymentRemittance, Price_Drop, Price_Drop_IMEI
|
| 53 |
from shop2020.model.v1.order.impl.model.BaseOrder import BaseOrder
|
53 |
from shop2020.model.v1.order.impl.model.BaseOrder import BaseOrder
|
| 54 |
from shop2020.model.v1.order.impl.model.DTHRechargeOrder import DTHRechargeOrder
|
54 |
from shop2020.model.v1.order.impl.model.DTHRechargeOrder import DTHRechargeOrder
|
| 55 |
from shop2020.model.v1.order.impl.model.MobileRechargeOrder import \
|
55 |
from shop2020.model.v1.order.impl.model.MobileRechargeOrder import \
|
| 56 |
MobileRechargeOrder
|
56 |
MobileRechargeOrder
|
| 57 |
from shop2020.model.v1.order.impl.model.RechargeDenomination import \
|
57 |
from shop2020.model.v1.order.impl.model.RechargeDenomination import \
|
| Line 11539... |
Line 11539... |
| 11539 |
|
11539 |
|
| 11540 |
def get_intransit_orders_on_date(closingDate):
|
11540 |
def get_intransit_orders_on_date(closingDate):
|
| 11541 |
closingDateInclusive = to_py_date(closingDate) + datetime.timedelta(days=1)
|
11541 |
closingDateInclusive = to_py_date(closingDate) + datetime.timedelta(days=1)
|
| 11542 |
orders = Order.query.options(joinedload('lineitems')).filter(Order.billing_timestamp < closingDateInclusive).filter(or_(Order.refund_timestamp >= closingDateInclusive, Order.delivery_timestamp >= closingDateInclusive)).all()
|
11542 |
orders = Order.query.options(joinedload('lineitems')).filter(Order.billing_timestamp < closingDateInclusive).filter(or_(Order.refund_timestamp >= closingDateInclusive, Order.delivery_timestamp >= closingDateInclusive)).all()
|
| 11543 |
return [to_t_order(order) for order in orders]
|
11543 |
return [to_t_order(order) for order in orders]
|
| - |
|
11544 |
|
| - |
|
11545 |
def add_price_drop(item_id, imeis, amount, affected_on):
|
| - |
|
11546 |
priceDrop = Price_Drop()
|
| - |
|
11547 |
priceDrop.amount = amount
|
| - |
|
11548 |
priceDrop.affected_on = to_py_date(affected_on)
|
| - |
|
11549 |
priceDrop.created_on = datetime.datetime.now()
|
| - |
|
11550 |
priceDrop.item_id = item_id
|
| - |
|
11551 |
for imei in imeis:
|
| - |
|
11552 |
pdImei = Price_Drop_IMEI()
|
| - |
|
11553 |
pdImei.imei = imei
|
| - |
|
11554 |
pdImei.price_drop = priceDrop
|
| - |
|
11555 |
|
| - |
|
11556 |
session.commit()
|
| 11544 |
|
11557 |
|
| - |
|
11558 |
return True
|
| 11545 |
|
11559 |
|
| 11546 |
|
11560 |
|
| 11547 |
|
11561 |
|
| 11548 |
|
11562 |
|
| 11549 |
|
11563 |
|
| Line 11581... |
Line 11595... |
| 11581 |
#pincodes = [302006,263139,781001,834001,380051,380001,110074,400095,560037,125055,122001,700009,400709,462022,700023,400015]
|
11595 |
#pincodes = [302006,263139,781001,834001,380051,380001,110074,400095,560037,125055,122001,700009,400709,462022,700023,400015]
|
| 11582 |
#logistics_client = LogisticsClient().get_client()
|
11596 |
#logistics_client = LogisticsClient().get_client()
|
| 11583 |
#for pincode in pincodes:
|
11597 |
#for pincode in pincodes:
|
| 11584 |
# print pincode, logistics_client.getLogisticsEstimation(26385, str(pincode), 1).providerId
|
11598 |
# print pincode, logistics_client.getLogisticsEstimation(26385, str(pincode), 1).providerId
|
| 11585 |
|
11599 |
|
| - |
|
11600 |
add_price_drop(213, ['1','2'], 20, 1513686198574)
|
| 11586 |
|
11601 |
|