Subversion Repositories SmartDukaan

Rev

Rev 20806 | Rev 20812 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 20806 Rev 20811
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