| Line 8754... |
Line 8754... |
| 8754 |
orders = Order.query.filter(Order.logisticsTransactionId==logisticsTxnId).all()
|
8754 |
orders = Order.query.filter(Order.logisticsTransactionId==logisticsTxnId).all()
|
| 8755 |
if not orders:
|
8755 |
if not orders:
|
| 8756 |
orders = []
|
8756 |
orders = []
|
| 8757 |
return orders
|
8757 |
return orders
|
| 8758 |
|
8758 |
|
| 8759 |
def add_billing_details_for_groupped_orders(orderIds, invoice_number, itemNumbersMap, serialNumbersMap, freebieWarehouseIdMap, billed_by, jacketNumber, billingType, authorize, invoiceType, packageDimensions):
|
8759 |
def add_billing_details_for_groupped_orders(orderIds, invoice_number, itemNumbersMap, serialNumbersMap, freebieWarehouseIdMap, billed_by, jacketNumber, billingType, authorize, invoiceType):
|
| 8760 |
# print 'orderIds',orderIds
|
8760 |
# print 'orderIds',orderIds
|
| 8761 |
# print 'invoice_number', invoice_number
|
8761 |
# print 'invoice_number', invoice_number
|
| 8762 |
# print 'itemNumbersMap', itemNumbersMap
|
8762 |
# print 'itemNumbersMap', itemNumbersMap
|
| 8763 |
# print 'serialNumbersMap', serialNumbersMap
|
8763 |
# print 'serialNumbersMap', serialNumbersMap
|
| 8764 |
# print 'freebieWarehouseIdMap', freebieWarehouseIdMap
|
8764 |
# print 'freebieWarehouseIdMap', freebieWarehouseIdMap
|
| Line 9343... |
Line 9343... |
| 9343 |
for order in ordersList:
|
9343 |
for order in ordersList:
|
| 9344 |
order.invoice_number = invoiceNumber
|
9344 |
order.invoice_number = invoiceNumber
|
| 9345 |
order.seller_id = seller_id
|
9345 |
order.seller_id = seller_id
|
| 9346 |
order.warehouse_address_id = whaddressmapping.address_id
|
9346 |
order.warehouse_address_id = whaddressmapping.address_id
|
| 9347 |
|
9347 |
|
| 9348 |
logisticCostDetail= ShipmentLogisticsCostDetail.get_by(logisticsTransactionId=ordersList[0].logisticsTransactionId)
|
9348 |
# logisticCostDetail= ShipmentLogisticsCostDetail.get_by(logisticsTransactionId=ordersList[0].logisticsTransactionId)
|
| 9349 |
logisticCostDetail.packageDimensions = packageDimensions
|
9349 |
# logisticCostDetail.packageDimensions = packageDimensions
|
| 9350 |
|
9350 |
|
| 9351 |
session.commit()
|
9351 |
session.commit()
|
| 9352 |
|
9352 |
|
| 9353 |
return True
|
9353 |
return True
|
| 9354 |
|
9354 |
|
| Line 10066... |
Line 10066... |
| 10066 |
order.tracking_id = airwaybill_no
|
10066 |
order.tracking_id = airwaybill_no
|
| 10067 |
shipmentAmount = shipmentAmount + order.total_amount
|
10067 |
shipmentAmount = shipmentAmount + order.total_amount
|
| 10068 |
shipmentWeight = shipmentWeight + order.total_weight
|
10068 |
shipmentWeight = shipmentWeight + order.total_weight
|
| 10069 |
shipmentLogisticsCost = shipmentLogisticsCost + order.lineitems[0].logisticsCost
|
10069 |
shipmentLogisticsCost = shipmentLogisticsCost + order.lineitems[0].logisticsCost
|
| 10070 |
shipmentCodCollectionCharges = shipmentCodCollectionCharges + order.lineitems[0].codCollectionCharges
|
10070 |
shipmentCodCollectionCharges = shipmentCodCollectionCharges + order.lineitems[0].codCollectionCharges
|
| 10071 |
session.commit()
|
- |
|
| 10072 |
|
10071 |
|
| 10073 |
shipmentLogisticsCostObj = TShipmentLogisticsCostDetail()
|
10072 |
shipmentLogisticsCostObj = TShipmentLogisticsCostDetail()
|
| 10074 |
shipmentLogisticsCostObj.airwayBillNo = airwaybill_no
|
10073 |
shipmentLogisticsCostObj.airwayBillNo = airwaybill_no
|
| 10075 |
shipmentLogisticsCostObj.logisticsTransactionId = logisticsTransactionId
|
10074 |
shipmentLogisticsCostObj.logisticsTransactionId = logisticsTransactionId
|
| 10076 |
shipmentLogisticsCostObj.shipmentAmount = shipmentAmount
|
10075 |
shipmentLogisticsCostObj.shipmentAmount = shipmentAmount
|
| 10077 |
shipmentLogisticsCostObj.shipmentCodCollectionCharges = shipmentCodCollectionCharges
|
10076 |
shipmentLogisticsCostObj.shipmentCodCollectionCharges = shipmentCodCollectionCharges
|
| Line 10085... |
Line 10084... |
| 10085 |
return True
|
10084 |
return True
|
| 10086 |
|
10085 |
|
| 10087 |
def add_or_update_shipment_logistics_cost_details(shipmentLogisticsCostDetails):
|
10086 |
def add_or_update_shipment_logistics_cost_details(shipmentLogisticsCostDetails):
|
| 10088 |
currentTime = datetime.datetime.now()
|
10087 |
currentTime = datetime.datetime.now()
|
| 10089 |
for shipmentLogisticsCostDetail in shipmentLogisticsCostDetails:
|
10088 |
for shipmentLogisticsCostDetail in shipmentLogisticsCostDetails:
|
| 10090 |
shipment_logisticsCostDetail = ShipmentLogisticsCostDetail.get_by(logisticsTransactionId=shipmentLogisticsCostDetail.logisticsTransactionId, airwayBillNo = shipmentLogisticsCostDetail.airwayBillNo)
|
10089 |
shipment_logisticsCostDetail = ShipmentLogisticsCostDetail.get_by(logisticsTransactionId=shipmentLogisticsCostDetail.logisticsTransactionId)
|
| 10091 |
if shipment_logisticsCostDetail:
|
10090 |
if shipment_logisticsCostDetail:
|
| 10092 |
shipment_logisticsCostDetail.shipmentAmount = round(shipmentLogisticsCostDetail.shipmentAmount,2)
|
10091 |
shipment_logisticsCostDetail.shipmentAmount = round(shipmentLogisticsCostDetail.shipmentAmount,2)
|
| 10093 |
shipment_logisticsCostDetail.shipmentWeight = round(shipmentLogisticsCostDetail.shipmentWeight,3)
|
10092 |
shipment_logisticsCostDetail.shipmentWeight = round(shipmentLogisticsCostDetail.shipmentWeight,3)
|
| 10094 |
shipment_logisticsCostDetail.shipmentLogsiticsCost = round(shipmentLogisticsCostDetail.shipmentLogsiticsCost,2)
|
10093 |
shipment_logisticsCostDetail.shipmentLogsiticsCost = round(shipmentLogisticsCostDetail.shipmentLogsiticsCost,2)
|
| 10095 |
shipment_logisticsCostDetail.shipmentCodCollectionCharges = round(shipmentLogisticsCostDetail.shipmentCodCollectionCharges,2)
|
10094 |
shipment_logisticsCostDetail.shipmentCodCollectionCharges = round(shipmentLogisticsCostDetail.shipmentCodCollectionCharges,2)
|
| 10096 |
shipment_logisticsCostDetail.updatedAt = currentTime
|
10095 |
shipment_logisticsCostDetail.updatedAt = currentTime
|
| - |
|
10096 |
shipment_logisticsCostDetail.airwayBillNo = shipmentLogisticsCostDetail.airwayBillNo
|
| 10097 |
else:
|
10097 |
else:
|
| 10098 |
shipment_logisticsCostDetail = ShipmentLogisticsCostDetail()
|
10098 |
raise RuntimeError("Unable to add ShipmentLogisticsCostDetail.")
|
| 10099 |
shipment_logisticsCostDetail.logisticsTransactionId = shipmentLogisticsCostDetail.logisticsTransactionId
|
- |
|
| 10100 |
shipment_logisticsCostDetail.airwayBillNo = shipmentLogisticsCostDetail.airwayBillNo
|
- |
|
| 10101 |
shipment_logisticsCostDetail.shipmentAmount = round(shipmentLogisticsCostDetail.shipmentAmount,2)
|
- |
|
| 10102 |
shipment_logisticsCostDetail.shipmentWeight = round(shipmentLogisticsCostDetail.shipmentWeight,3)
|
- |
|
| 10103 |
shipment_logisticsCostDetail.shipmentLogsiticsCost = round(shipmentLogisticsCostDetail.shipmentLogsiticsCost,2)
|
- |
|
| 10104 |
shipment_logisticsCostDetail.shipmentCodCollectionCharges = round(shipmentLogisticsCostDetail.shipmentCodCollectionCharges,2)
|
- |
|
| 10105 |
shipment_logisticsCostDetail.updatedAt = currentTime
|
- |
|
| 10106 |
|
- |
|
| 10107 |
session.commit()
|
10099 |
session.commit()
|
| 10108 |
return True
|
10100 |
return True
|
| 10109 |
|
10101 |
|
| 10110 |
def logisticsProviderFinalCheck(ordersList):
|
10102 |
def logisticsProviderFinalCheck(ordersList):
|
| 10111 |
shipmentAmount = 0
|
10103 |
shipmentAmount = 0
|
| Line 11156... |
Line 11148... |
| 11156 |
def get_cost_detail_for_logistics_txn_id(logisticsTxnId):
|
11148 |
def get_cost_detail_for_logistics_txn_id(logisticsTxnId):
|
| 11157 |
logisticCostDetail= ShipmentLogisticsCostDetail.get_by(logisticsTransactionId=logisticsTxnId)
|
11149 |
logisticCostDetail= ShipmentLogisticsCostDetail.get_by(logisticsTransactionId=logisticsTxnId)
|
| 11158 |
if logisticCostDetail is None:
|
11150 |
if logisticCostDetail is None:
|
| 11159 |
raise
|
11151 |
raise
|
| 11160 |
return logisticCostDetail
|
11152 |
return logisticCostDetail
|
| - |
|
11153 |
|
| - |
|
11154 |
def add_shipment_logistic_detail(shipmentLogisticsCostDetail):
|
| - |
|
11155 |
if shipmentLogisticsCostDetail.logisticsTransactionId is None or shipmentLogisticsCostDetail.packageDimensions is None:
|
| - |
|
11156 |
raise ValueError("Null fields logisticsTransactionId/packageDimensions")
|
| 11161 |
|
11157 |
|
| - |
|
11158 |
logisticCostDetail = get_cost_detail_for_logistics_txn_id(shipmentLogisticsCostDetail.logisticsTransactionId)
|
| - |
|
11159 |
if logisticCostDetail is not None:
|
| - |
|
11160 |
raise ValueError("Something is wrong with the order")
|
| - |
|
11161 |
|
| - |
|
11162 |
d_ShipmentLogisticsCostDetail = ShipmentLogisticsCostDetail()
|
| - |
|
11163 |
d_ShipmentLogisticsCostDetail.logisticsTransactionId = shipmentLogisticsCostDetail.logisticsTransactionId
|
| - |
|
11164 |
d_ShipmentLogisticsCostDetail.packageDimensions = shipmentLogisticsCostDetail.packageDimensions
|
| - |
|
11165 |
session.commit()
|
| 11162 |
|
11166 |
|
| 11163 |
|
11167 |
|
| 11164 |
|
11168 |
|
| 11165 |
if __name__ == '__main__':
|
11169 |
if __name__ == '__main__':
|
| 11166 |
pass
|
11170 |
pass
|