Subversion Repositories SmartDukaan

Rev

Rev 19951 | Rev 19953 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
104 ashish 1
'''
2
Created on 29-Mar-2010
3
 
4
@author: ashish
5
'''
6
 
19950 amit.gupta 7
import datetime
8
 
9
from shop2020.config.client.ConfigClient import ConfigClient
10
from shop2020.model.v1.order.impl.DataService import Alert, Transaction
11
from shop2020.thriftpy.model.v1.order.ttypes import Transaction as T_Transaction, \
12
    LineItem as T_LineItem, Order as T_Order, Alert as T_Alert, OrderStatus, \
13
    DelayReason, PaymentSettlement as T_PaymentSettlement, \
14
    CODVerificationAgent as T_CODVerificationAgent, Attribute as T_Attribute, \
15
    EmiScheme as T_EmiScheme, RechargeTransaction as T_rechargeTransaction, \
16
    FRC as T_FRC, HotspotStore as T_HotSpotStore, SourceDetail as T_SourceDetail, \
17
    AmazonOrder as T_AmazonOrder, StoreOrderDetail as T_StoreOrderDetail, \
18
    StoreOrderCollection as T_StoreOrderCollection, \
8488 amar.kumar 19
    HotspotServiceMatrix as T_HotspotServiceMatrix, EbayOrder as T_EbayOrder, \
19950 amit.gupta 20
    AmazonFbaSalesSnapshot as T_AmazonFbaSalesSnapshot, \
21
    SnapdealOrder as T_SnapdealOrder, FlipkartOrder as flipkartOrder, \
22
    AmazonFbaOrderReturns as amazonFbaOrderReturn, \
23
    FlipkartAdvantageOrder as flipkartAdvantageOrder, HsOrder as homeshopOrder, \
24
    ReturnTransaction as RTransaction, ReturnOrderInfo as returnOrderInfo, \
25
    ReturnTransactionStatus, ReturnTxnResolutionStatus, \
26
    ReturnPickupRequest as RPickupRequest, ReturnTxnPickupStatus, \
27
    Creditor as TCreditor, CreditHistory as TCreditHistory, \
28
    UserSanction as TUserSanction, CreditTxnType, LoanHistory as TLoanHistory, \
29
    PaginatedCreditHistory as TPaginatedCreditHistory, \
30
    PaginatedLoanHistory as TPaginatedLoanHistory, \
31
    PaginatedUserSanction as TPaginatedUserSanction, \
19952 amit.gupta 32
    ShipmentLogisticsCostDetail as TShipmentLogisticsCostDetail, \
33
    OutstandingPayments as TOutstandingPayments
104 ashish 34
from shop2020.utils.Utils import to_java_date
35
 
19950 amit.gupta 36
 
37
cutoff_date = ConfigClient().get_property("warehouse_company_cutoff_date")
19951 amit.gupta 38
cutoff_date = datetime.datetime.strptime(cutoff_date,'%Y-%m-%d')
19950 amit.gupta 39
 
104 ashish 40
def to_t_transaction(transaction):
41
    t_transaction = T_Transaction()
42
    t_transaction.id = transaction.id
483 rajveer 43
    t_transaction.createdOn = to_java_date(transaction.createdOn)
699 chandransh 44
    t_transaction.transactionStatus = transaction.status
483 rajveer 45
    t_transaction.statusDescription = transaction.status_message
46
    t_transaction.customer_id = transaction.customer_id
47
    t_transaction.shoppingCartid = transaction.shopping_cart_id
2219 varun.gupt 48
    t_transaction.coupon_code = transaction.coupon_code
2815 vikas 49
    t_transaction.sessionSource = transaction.session_source
50
    t_transaction.sessionStartTime = to_java_date(transaction.session_start_time)
3858 vikas 51
    t_transaction.firstSource = transaction.first_source
52
    t_transaction.firstSourceTime = to_java_date(transaction.first_source_start_time)
17470 manish.sha 53
    t_transaction.totalShippingCost = transaction.totalShippingCost
18590 manish.sha 54
    t_transaction.payment_option = transaction.payment_option
483 rajveer 55
    t_transaction.orders = []
56
    #populate orders
57
    for order in transaction.orders:
58
        t_order = to_t_order(order)
59
        t_transaction.orders.append(t_order)
60
    return t_transaction
61
 
62
def to_t_order(order):
63
    t_order = T_Order()
64
    t_order.id = order.id
19950 amit.gupta 65
    if cutoff_date < t_order.billing_timestamp and t_order.billing_timestamp==7:
66
        t_order.warehouse_id = 6575
67
    else:
68
        t_order.warehouse_id = order.warehouse_id
483 rajveer 69
    t_order.logistics_provider_id = order.logistics_provider_id
4815 phani.kuma 70
    if order.doa_logistics_provider_id is not None:
71
        t_order.doa_logistics_provider_id = order.doa_logistics_provider_id
483 rajveer 72
    t_order.airwaybill_no = order.airwaybill_no
73
    t_order.tracking_id = order.tracking_id
74
    t_order.expected_delivery_time = to_java_date(order.expected_delivery_time)
3986 chandransh 75
    t_order.promised_delivery_time = to_java_date(order.promised_delivery_time)
4004 chandransh 76
    t_order.expected_shipping_time = to_java_date(order.expected_shipping_time)
4102 chandransh 77
    t_order.promised_shipping_time = to_java_date(order.promised_shipping_time)
6726 rajveer 78
    t_order.courier_delivery_time = to_java_date(order.courier_delivery_time)
19950 amit.gupta 79
    t_order.billing_timestamp = to_java_date(order.billing_timestamp)
483 rajveer 80
    t_order.customer_id = order.customer_id
81
    t_order.customer_name = order.customer_name
82
    t_order.customer_mobilenumber = order.customer_mobilenumber
83
    t_order.customer_pincode = order.customer_pincode
738 chandransh 84
    t_order.customer_address1 = order.customer_address1
85
    t_order.customer_address2 = order.customer_address2
669 chandransh 86
    t_order.customer_city = order.customer_city
87
    t_order.customer_state = order.customer_state
483 rajveer 88
    t_order.customer_email = order.customer_email    
699 chandransh 89
    t_order.status = order.status 
483 rajveer 90
    t_order.statusDescription = order.statusDescription
91
    t_order.total_amount = order.total_amount
6318 rajveer 92
    t_order.gvAmount = order.gvAmount
483 rajveer 93
    t_order.total_weight = order.total_weight
94
    t_order.created_timestamp = to_java_date(order.created_timestamp)
95
    t_order.invoice_number = order.invoice_number
96
    t_order.billed_by = order.billed_by
986 chandransh 97
    t_order.accepted_timestamp = to_java_date(order.accepted_timestamp)
98
    t_order.billing_timestamp = to_java_date(order.billing_timestamp)
99
    t_order.shipping_timestamp = to_java_date(order.shipping_timestamp)
100
    t_order.delivery_timestamp = to_java_date(order.delivery_timestamp)
1208 chandransh 101
    t_order.outofstock_timestamp = to_java_date(order.outofstock_timestamp)
4004 chandransh 102
    t_order.verification_timestamp = to_java_date(order.verification_timestamp)
642 chandransh 103
    t_order.jacket_number = order.jacket_number
1220 chandransh 104
    t_order.receiver = order.receiver
105
    t_order.batchNo = order.batchNo
106
    t_order.serialNo = order.serialNo
2536 chandransh 107
    t_order.doaFlag = order.doaFlag
108
    t_order.pickupRequestNo = order.pickupRequestNo
3064 chandransh 109
    t_order.cod = order.cod
5062 varun.gupt 110
    t_order.originalOrderId = order.originalOrderId
3581 chandransh 111
    if order.delay_reason:
112
        t_order.delayReason = DelayReason._NAMES_TO_VALUES[order.delay_reason]
4647 rajveer 113
    t_order.delayReasonText = order.delayReasonText
2676 vikas 114
    t_order.transactionId = order.transaction_id
483 rajveer 115
    t_order.lineitems = []
116
    for lineitem in order.lineitems:
117
        t_lineitem = to_t_lineitem(lineitem)
118
        t_order.lineitems.append(t_lineitem)
4192 anupam.sin 119
    if order.reship_timestamp:
120
        t_order.reship_timestamp = to_java_date(order.reship_timestamp)
121
    if order.refund_timestamp:
122
        t_order.refund_timestamp = to_java_date(order.refund_timestamp)
4506 phani.kuma 123
    if order.doa_auth_timestamp:
124
        t_order.doa_auth_timestamp = to_java_date(order.doa_auth_timestamp)
4192 anupam.sin 125
    if order.new_order_id:
126
        t_order.new_order_id = order.new_order_id
4581 phani.kuma 127
    t_order.pickup_timestamp = to_java_date(order.pickup_timestamp)
4269 anupam.sin 128
    t_order.previousStatus = order.previousStatus
129
    t_order.vendorId = order.vendorId
4709 rajveer 130
    t_order.refundReason = order.refund_reason
5110 mandeep.dh 131
    t_order.fulfilmentWarehouseId = order.fulfilmentWarehouseId
5189 varun.gupt 132
    t_order.vendorPaid = order.vendor_paid
4758 mandeep.dh 133
    if order.purchase_order_id:
134
        t_order.purchaseOrderId = order.purchase_order_id
5354 anupam.sin 135
    if order.received_return_timestamp:
136
        t_order.received_return_timestamp = to_java_date(order.received_return_timestamp)
137
    if order.first_dlvyatmp_timestamp:
138
        t_order.first_attempt_timestamp = to_java_date(order.first_dlvyatmp_timestamp)
5527 anupam.sin 139
    t_order.orderType = order.orderType
5555 rajveer 140
    t_order.pickupStoreId = order.pickupStoreId
141
    t_order.logisticsCod = not order.pickupStoreId and order.cod
6525 rajveer 142
    t_order.otg = order.otg
6903 anupam.sin 143
    t_order.insurer = order.insurer
144
    t_order.insuranceAmount = order.insuranceAmount
7190 amar.kumar 145
    t_order.freebieItemId = order.freebieItemId
7293 anupam.sin 146
    t_order.source = order.source
147
    t_order.storeId = order.storeId
148
    t_order.advanceAmount = order.advanceAmount
8717 amar.kumar 149
    t_order.productCondition = order.productCondition
9299 kshitij.so 150
    t_order.dataProtectionInsurer = order.dataProtectionInsurer
151
    t_order.dataProtectionAmount = order.dataProtectionAmount
9494 amit.gupta 152
    t_order.taxType = order.taxType
13146 manish.sha 153
    if order.logisticsTransactionId:
154
        t_order.logisticsTransactionId = order.logisticsTransactionId
17470 manish.sha 155
    t_order.shippingCost = order.shippingCost
156
    t_order.codCharges = order.codCharges
483 rajveer 157
    return t_order
158
 
159
def to_t_lineitem(lineitem):
160
    t_lineitem = T_LineItem()
161
    t_lineitem.id = lineitem.id
699 chandransh 162
    t_lineitem.item_id = lineitem.item_id
970 chandransh 163
    t_lineitem.productGroup = lineitem.productGroup
164
    t_lineitem.brand = lineitem.brand
165
    t_lineitem.model_number = lineitem.model_number
166
    t_lineitem.color = lineitem.color
167
    t_lineitem.model_name = lineitem.model_name
168
    t_lineitem.extra_info = lineitem.extra_info
483 rajveer 169
    t_lineitem.unit_weight = lineitem.unit_weight
170
    t_lineitem.unit_price = lineitem.unit_price
171
    t_lineitem.total_price = lineitem.total_price
996 varun.gupt 172
    t_lineitem.transfer_price = lineitem.transfer_price
7672 rajveer 173
    t_lineitem.nlc = lineitem.nlc
483 rajveer 174
    t_lineitem.total_weight = lineitem.total_weight 
669 chandransh 175
    t_lineitem.quantity = lineitem.quantity
2783 chandransh 176
    t_lineitem.item_number = lineitem.item_number
4658 mandeep.dh 177
    t_lineitem.serial_number = lineitem.serial_number
4172 rajveer 178
    t_lineitem.dealText = lineitem.dealText
4295 varun.gupt 179
    t_lineitem.warrantry_expiry_timestamp = to_java_date(lineitem.warranty_expiry_timestamp)
6039 amit.gupta 180
    t_lineitem.vatRate = lineitem.vatRate
12339 amit.gupta 181
    t_lineitem.mrp = lineitem.mrp
19421 manish.sha 182
    t_lineitem.logisticsCost = lineitem.logisticsCost
183
    t_lineitem.codCollectionCharges = lineitem.codCollectionCharges
19714 manish.sha 184
    t_lineitem.returnQty = lineitem.returnQty
185
    t_lineitem.damaged_expiry_timestamp = to_java_date(lineitem.damaged_expiry_timestamp)
483 rajveer 186
    return t_lineitem
187
 
188
def to_t_alert(alert):
189
    t_alert = T_Alert()
190
    t_alert.id = alert.id
4394 rajveer 191
    t_alert.description = alert.description
483 rajveer 192
    try:
4394 rajveer 193
        t_alert.timestamp = to_java_date(alert.timestamp)
483 rajveer 194
    except:
195
        pass
196
    t_alert.type = alert.type
4394 rajveer 197
    t_alert.status = alert.status
2783 chandransh 198
    return t_alert
4600 varun.gupt 199
 
200
def to_t_payment_settlement(payment_settlement):
201
    t_payment_settlement = T_PaymentSettlement()
202
 
203
    if payment_settlement:
4905 varun.gupt 204
        t_payment_settlement.referenceId = payment_settlement.referenceId
4600 varun.gupt 205
        t_payment_settlement.paymentGatewayId = payment_settlement.paymentGatewayId
206
        t_payment_settlement.settlementDate = to_java_date(payment_settlement.settlementDate)
207
        t_payment_settlement.serviceTax = payment_settlement.serviceTax
208
        t_payment_settlement.otherCharges = payment_settlement.otherCharges
209
        t_payment_settlement.netCollection = payment_settlement.netCollection
5447 anupam.sin 210
    return t_payment_settlement
211
 
212
def to_t_verification_agent(codVerificationAgent):
213
    t_verification_agent = T_CODVerificationAgent()
214
 
215
    if codVerificationAgent:
216
        t_verification_agent.orderId = codVerificationAgent.orderId
217
        t_verification_agent.agentEmailId = codVerificationAgent.verificationAgent
5527 anupam.sin 218
    return t_verification_agent    
219
 
220
def to_t_attribute(attribute):
6396 amit.gupta 221
    t_attribute = T_Attribute() 
5527 anupam.sin 222
    if attribute:
223
        t_attribute.name = attribute.name
224
        t_attribute.value = attribute.value
6396 amit.gupta 225
    return t_attribute
226
 
227
def to_t_emi_scheme(emi_scheme):
228
    t_emi_scheme = T_EmiScheme()
229
    if emi_scheme:
230
        t_emi_scheme.id = emi_scheme.id
231
        t_emi_scheme.bankId = emi_scheme.bankId
232
        t_emi_scheme.bankName = emi_scheme.bankName
233
        t_emi_scheme.gatewayId = emi_scheme.gatewayId
234
        t_emi_scheme.tenure = emi_scheme.tenure
235
        t_emi_scheme.tenureDescription = emi_scheme.tenureDescription
236
        t_emi_scheme.minAmount = emi_scheme.minAmount
237
        t_emi_scheme.chargeType = emi_scheme.chargeType
238
        t_emi_scheme.chargeValue = emi_scheme.chargeValue
8942 rajveer 239
        t_emi_scheme.interestRate = emi_scheme.interestRate
7073 anupam.sin 240
    return t_emi_scheme
241
 
242
def to_t_rechargeTransaction(rechargeTransaction):
243
    t_recharge = T_rechargeTransaction()
244
    if rechargeTransaction:
7080 anupam.sin 245
        t_recharge.id = rechargeTransaction.id
246
        t_recharge.amount = rechargeTransaction.amount 
7075 rajveer 247
        t_recharge.circleId = rechargeTransaction.circleId
248
        t_recharge.operatorId = rechargeTransaction.operatorId
249
        t_recharge.plan = rechargeTransaction.plan 
7073 anupam.sin 250
        t_recharge.deviceNum = rechargeTransaction.deviceNum
251
        t_recharge.deviceType = rechargeTransaction.deviceType
252
        t_recharge.discount = rechargeTransaction.discount 
253
        t_recharge.email = rechargeTransaction.email
254
        t_recharge.name = rechargeTransaction.name
255
        t_recharge.cafNum = rechargeTransaction.cafNum
256
        t_recharge.simNum = rechargeTransaction.simNum
257
        t_recharge.isFrc = rechargeTransaction.isFrc
258
        t_recharge.status = rechargeTransaction.status
259
        t_recharge.storeId = rechargeTransaction.storeId
7080 anupam.sin 260
        t_recharge.alternateNum = rechargeTransaction.alternateNumber
261
        t_recharge.transactionTime = to_java_date(rechargeTransaction.transactionTime)
7096 anupam.sin 262
        t_recharge.description = rechargeTransaction.description
7139 amit.gupta 263
        t_recharge.payMethod = rechargeTransaction.payMethod
7169 anupam.sin 264
        t_recharge.paymentAmount = rechargeTransaction.paymentAmount
7369 rajveer 265
        t_recharge.spiceTID = rechargeTransaction.spiceTID
266
        t_recharge.providerTID = rechargeTransaction.providerTID
267
        t_recharge.aggTID = rechargeTransaction.aggTID
7080 anupam.sin 268
    return t_recharge
269
 
270
def to_t_frc(frc):
271
    t_frc = T_FRC()
272
    if frc:
273
        t_frc.id = frc.id
274
        t_frc.operatorId =frc.operatorId
275
        t_frc.circleId = frc.circleId
276
        t_frc.denomination = frc.denomination
277
        t_frc.maxDiscount = frc.maxDiscount
7096 anupam.sin 278
    return t_frc
279
 
280
def to_t_hotspot(hotspot):
281
    t_hotspot = T_HotSpotStore();
282
    if hotspot:
283
        t_hotspot.id = hotspot.id 
284
        t_hotspot.hotspotId = hotspot.hotspotId
285
        t_hotspot.companyId = hotspot.companyId
286
        t_hotspot.name = hotspot.name
287
        t_hotspot.city = hotspot.city
288
        t_hotspot.collectedAmount = hotspot.collectedAmount
289
        t_hotspot.availableLimit = hotspot.availableLimit
290
        t_hotspot.creditLimit = hotspot.creditLimit
291
        t_hotspot.salt = hotspot.salt
292
        t_hotspot.password = hotspot.password
293
        t_hotspot.isActive = hotspot.isActive
294
        t_hotspot.circleId = hotspot.circleId
7169 anupam.sin 295
        t_hotspot.email = hotspot.email
7308 rajveer 296
        t_hotspot.line1 = hotspot.line1
297
        t_hotspot.line2 = hotspot.line2
298
        t_hotspot.state = hotspot.state
299
        t_hotspot.pin = hotspot.pin
300
        t_hotspot.phone = hotspot.phone
301
        t_hotspot.approvalEmail = hotspot.approvalEmail
302
 
303
 
7263 anupam.sin 304
    return t_hotspot
305
 
306
def to_t_sourcedetail(detail):
307
    t_sourcedetail = T_SourceDetail()
308
    if detail:
309
        t_sourcedetail.id = detail.id
310
        t_sourcedetail.name = detail.name
311
        t_sourcedetail.email = detail.email
7410 amar.kumar 312
        t_sourcedetail.tinNumber = detail.tinNumber
7530 kshitij.so 313
        t_sourcedetail.lastUpdatedOn = to_java_date(detail.lastUpdatedOn)
7311 kshitij.so 314
    return t_sourcedetail
315
 
316
def to_t_amazonorder(AmazonOrder):
317
    t_amazonorder = T_AmazonOrder()
318
    t_amazonorder.orderId=AmazonOrder.orderId
319
    t_amazonorder.amazonOrderCode=AmazonOrder.amazonOrderCode
320
    t_amazonorder.amazonOrderItemCode=AmazonOrder.amazonOrderItemCode
321
    t_amazonorder.transactionId=AmazonOrder.transactionId
322
    t_amazonorder.item_id=AmazonOrder.item_id
323
    t_amazonorder.status=AmazonOrder.status
7386 anupam.sin 324
    return t_amazonorder
325
 
326
def to_t_storeOrderDetail(storeOrderDetail):
327
    t_storeOrderDetail = T_StoreOrderDetail()
328
    if storeOrderDetail:
329
        t_storeOrderDetail.orderId = storeOrderDetail.orderId
330
        t_storeOrderDetail.storeId = storeOrderDetail.storeId
331
        t_storeOrderDetail.advanceAmount = storeOrderDetail.advanceAmount
332
        t_storeOrderDetail.cashAmount = storeOrderDetail.cashAmount
333
        t_storeOrderDetail.cardAmount = storeOrderDetail.cardAmount
334
        t_storeOrderDetail.payStatus = storeOrderDetail.payStatus
7393 anupam.sin 335
        t_storeOrderDetail.edcBank = storeOrderDetail.edcBank
336
        t_storeOrderDetail.cashRefundAmount = storeOrderDetail.cashRefundAmount
337
        t_storeOrderDetail.cardRefundAmount = storeOrderDetail.cardRefundAmount
7423 anupam.sin 338
        t_storeOrderDetail.approvalCode = storeOrderDetail.approvalCode
7611 anupam.sin 339
        t_storeOrderDetail.cardType = storeOrderDetail.cardType
7426 anupam.sin 340
    return t_storeOrderDetail
341
 
342
def to_t_storeOrderCollection(storeOrderCollection):
343
    t_storeOrderCollection = T_StoreOrderCollection()
344
    if storeOrderCollection:
345
        t_storeOrderCollection.hotspotId = storeOrderCollection.hotspotId
346
        t_storeOrderCollection.orderId = storeOrderCollection.orderId
347
        t_storeOrderCollection.collectionType = storeOrderCollection.collectionType
348
        t_storeOrderCollection.productName = storeOrderCollection.productName
349
        t_storeOrderCollection.advanceAmount = storeOrderCollection.advanceAmount
350
        t_storeOrderCollection.cash = storeOrderCollection.cash
351
        t_storeOrderCollection.card = storeOrderCollection.card
7427 anupam.sin 352
        t_storeOrderCollection.addedAt = to_java_date(storeOrderCollection.addedAt)
353
        t_storeOrderCollection.pushedAt = to_java_date(storeOrderCollection.pushedAt)
7426 anupam.sin 354
        t_storeOrderCollection.pushedToOcr = storeOrderCollection.pushedToOcr
7967 anupam.sin 355
    return t_storeOrderCollection
356
 
357
def to_t_hotspotServiceMatrix(hotspotServiceMatrix):
358
    t_hotspotServiceMatrix = T_HotspotServiceMatrix()
359
    if hotspotServiceMatrix:
360
        t_hotspotServiceMatrix.storeId = hotspotServiceMatrix.storeId
361
        t_hotspotServiceMatrix.hotspotId = hotspotServiceMatrix.hotspotId
362
        t_hotspotServiceMatrix.rechargeService = hotspotServiceMatrix.rechargeService
363
        t_hotspotServiceMatrix.storeWebsiteService = hotspotServiceMatrix.storeWebsiteService
364
        t_hotspotServiceMatrix.pickupFromStoreService = hotspotServiceMatrix.pickupFromStoreService
365
    return t_hotspotServiceMatrix
8182 amar.kumar 366
 
367
def to_t_ebayOrder(ebayOrder):
368
    t_ebayOrder = T_EbayOrder()
369
    t_ebayOrder.orderId = ebayOrder.orderId
370
    t_ebayOrder.salesRecordNumber = ebayOrder.salesRecordNumber
371
    t_ebayOrder.paisaPayId = ebayOrder.paisaPayId
372
    t_ebayOrder.ebayListingId = ebayOrder.ebayListingId
373
    t_ebayOrder.subsidyAmount = ebayOrder.subsidyAmount
374
    t_ebayOrder.ebayTxnDate = to_java_date(ebayOrder.ebayTxnDate)
375
    t_ebayOrder.transactionId = ebayOrder.transactionId
376
    t_ebayOrder.listingName = ebayOrder.listingName
377
    t_ebayOrder.listingPrice = ebayOrder.listingPrice
8247 amar.kumar 378
    t_ebayOrder.bluedartPaisaPayRef = ebayOrder.bluedartPaisaPayRef
8182 amar.kumar 379
    return t_ebayOrder 
8488 amar.kumar 380
 
381
def to_t_snapdealOrder(snapdealOrder):
382
    t_snapdealOrder = T_SnapdealOrder()
383
    t_snapdealOrder.orderId = snapdealOrder.orderId
384
    t_snapdealOrder.subOrderId = snapdealOrder.subOrderId
385
    t_snapdealOrder.referenceCode = snapdealOrder.referenceCode
386
    t_snapdealOrder.snapdealTxnDate = to_java_date(snapdealOrder.referenceCode)
387
    t_snapdealOrder.productName = snapdealOrder.productName
388
    t_snapdealOrder.listingPrice = snapdealOrder.listingPrice
9456 vikram.rag 389
    t_snapdealOrder.maxNlc = snapdealOrder.maxNlc
8488 amar.kumar 390
    return t_snapdealOrder 
8282 kshitij.so 391
 
392
def to_t_amazonFbaSalesSnapshot(amazonFbaSalesSnapshot):
393
    t_amazonFbaSalesSnapshot = T_AmazonFbaSalesSnapshot()
394
    if amazonFbaSalesSnapshot:
395
        t_amazonFbaSalesSnapshot.dateOfSale = to_java_date(datetime.datetime.combine(amazonFbaSalesSnapshot.dateOfSale,datetime.time(0,0)))
396
        t_amazonFbaSalesSnapshot.item_id    = amazonFbaSalesSnapshot.item_id 
8363 vikram.rag 397
        t_amazonFbaSalesSnapshot.totalOrderCount = amazonFbaSalesSnapshot.totalOrderCount 
8282 kshitij.so 398
        t_amazonFbaSalesSnapshot.amazonFbaInventory = amazonFbaSalesSnapshot.amazonFbaInventory
399
        t_amazonFbaSalesSnapshot.isOutOfStock = amazonFbaSalesSnapshot.isOutOfStock
400
        t_amazonFbaSalesSnapshot.salePrice = amazonFbaSalesSnapshot.salePrice
8445 vikram.rag 401
        t_amazonFbaSalesSnapshot.ourPrice = amazonFbaSalesSnapshot.ourPrice
8282 kshitij.so 402
        if amazonFbaSalesSnapshot.minFbaPrice is not None:
403
            t_amazonFbaSalesSnapshot.minFbaPrice = amazonFbaSalesSnapshot.minFbaPrice
404
        if amazonFbaSalesSnapshot.minMfnPrice is not None:    
405
            t_amazonFbaSalesSnapshot.minMfnPrice = amazonFbaSalesSnapshot.minMfnPrice
8363 vikram.rag 406
        t_amazonFbaSalesSnapshot.totalSale = amazonFbaSalesSnapshot.totalSale
407
        t_amazonFbaSalesSnapshot.promotionSale = amazonFbaSalesSnapshot.promotionSale    
408
        t_amazonFbaSalesSnapshot.promotionOrderCount = amazonFbaSalesSnapshot.promotionOrderCount
8532 vikram.rag 409
        t_amazonFbaSalesSnapshot.ourPriceSnapshotDate = to_java_date(amazonFbaSalesSnapshot.ourPriceSnapshotDate)
410
        t_amazonFbaSalesSnapshot.salePriceSnapshotDate = to_java_date(amazonFbaSalesSnapshot.salePriceSnapshotDate)
411
        t_amazonFbaSalesSnapshot.minFbaPriceSnapshotDate = to_java_date(amazonFbaSalesSnapshot.minFbaPriceSnapshotDate)
412
        t_amazonFbaSalesSnapshot.minMfnPriceSnapshotDate = to_java_date(amazonFbaSalesSnapshot.minMfnPriceSnapshotDate)
11173 vikram.rag 413
        t_amazonFbaSalesSnapshot.fcLocation = amazonFbaSalesSnapshot.fcLocation
8282 kshitij.so 414
    return t_amazonFbaSalesSnapshot
8990 vikram.rag 415
 
416
def to_t_flipkartOrder(flipkartorder):
9000 vikram.rag 417
    order = flipkartOrder()
8990 vikram.rag 418
    if flipkartorder:
9000 vikram.rag 419
        order.emiFee = flipkartorder.emiFee
420
        order.orderId = flipkartorder.orderId
421
        order.octroiFee = flipkartorder.octroiFee
422
        order.flipkartOrderId = flipkartorder.flipkartOrderId
423
        order.flipkartSubOrderId = flipkartorder.flipkartSubOrderId
424
        order.flipkartTxnDate = to_java_date(flipkartorder.flipkartTxnDate)
425
        order.shippingPrice = flipkartorder.shippingPrice
9456 vikram.rag 426
        order.maxNlc = flipkartorder.maxNlc
12103 manish.sha 427
    return order
428
 
429
def to_t_amazonFbaOrderReturn(amazonfbaOrderReturn):
430
    orderReturn = amazonFbaOrderReturn()
431
    if amazonfbaOrderReturn:
432
        orderReturn.amazonOrderId = amazonfbaOrderReturn.amazonOrderId
433
        orderReturn.insertionTimestamp = to_java_date(amazonfbaOrderReturn.insertionTimestamp)
434
        orderReturn.sku = amazonfbaOrderReturn.sku
435
        orderReturn.creationTimestamp = to_java_date(amazonfbaOrderReturn.creationTimestamp)
436
        orderReturn.shippedQuantity = amazonfbaOrderReturn.shippedQuantity
437
        orderReturn.sellableReturnQuantity = amazonfbaOrderReturn.sellableReturnQuantity
438
        orderReturn.nonSellableReturnQuantity = amazonfbaOrderReturn.nonSellableReturnQuantity
439
    return orderReturn
8990 vikram.rag 440
 
12772 manish.sha 441
def to_t_flipkartAdvantageOrder(faOrder):
442
    fa_Order = flipkartAdvantageOrder()
443
    if faOrder:
444
        fa_Order.fkOrderId = faOrder.fkOrderId
445
        fa_Order.fkOrderItemId = faOrder.fkOrderItemId
446
        fa_Order.sku = faOrder.sku
447
        fa_Order.creationTimestamp = to_java_date(faOrder.creationTimestamp)
448
        fa_Order.customerName = faOrder.customerName
449
        fa_Order.customerAddress = faOrder.customerAddress
450
        fa_Order.pincode = faOrder.pincode
451
        fa_Order.customerCity = faOrder.customerCity
452
        fa_Order.customerState = faOrder.customerState
453
        fa_Order.customerPhone = faOrder.customerPhone
454
        fa_Order.status = faOrder.status
455
        fa_Order.quantity = faOrder.quantity
456
        fa_Order.totalPrice = faOrder.totalPrice
457
        fa_Order.listPrice = faOrder.listPrice
458
        fa_Order.modifiedDate = to_java_date(faOrder.modifiedDate)
459
        fa_Order.listingId = faOrder.listingId
460
        fa_Order.cancelReason = faOrder.cancelReason
461
        fa_Order.returnReason = faOrder.returnReason
462
        fa_Order.freebieItemId = faOrder.freebieItemId
463
        fa_Order.productTitle = faOrder.productTitle
12777 manish.sha 464
 
13146 manish.sha 465
    return fa_Order
13691 manish.sha 466
 
467
def to_t_hsOrder(hsOrder):
468
    hs_Order = homeshopOrder()
469
    hs_Order.orderId = hsOrder.orderId
470
    hs_Order.catalogueName = hsOrder.catalogueName
471
    hs_Order.courierName = hsOrder.courierName
13708 manish.sha 472
    hs_Order.hsItemId = hsOrder.hsItemId
13691 manish.sha 473
    hs_Order.hsOrderDate = to_java_date(hsOrder.hsOrderDate)
474
    hs_Order.hsOrderNo = hsOrder.hsOrderNo
475
    hs_Order.hsProductId = hsOrder.hsProductId
476
    hs_Order.hsSubOrderNo = hsOrder.hsSubOrderNo
477
    hs_Order.paymentMode = hsOrder.paymentMode
478
    hs_Order.sellerSku = hsOrder.sellerSku
479
    hs_Order.slaDays = hsOrder.slaDays
13734 manish.sha 480
    hs_Order.shippingName = hsOrder.shippingName
13691 manish.sha 481
    return hs_Order 
18578 manish.sha 482
 
483
 
484
def to_t_returnTransaction(returnTransaction):
485
    rTransaction = RTransaction()
486
    rTransaction.id = returnTransaction.id
487
    if returnTransaction.status:
488
        rTransaction.status = ReturnTransactionStatus._NAMES_TO_VALUES[returnTransaction.status]
489
    rTransaction.customer_email = returnTransaction.customer_email
490
    rTransaction.customer_name = returnTransaction.customer_name
491
    rTransaction.customer_id = returnTransaction.customer_id
492
    rTransaction.address_id = returnTransaction.address_id
493
    rTransaction.ticketId = returnTransaction.ticketId
494
    rTransaction.createdAt = to_java_date(returnTransaction.createdAt)
495
    if returnTransaction.processedAt:
496
        rTransaction.processedAt = to_java_date(returnTransaction.processedAt)
497
    if returnTransaction.authorizedAt:
498
        rTransaction.authorizedAt = to_java_date(returnTransaction.authorizedAt)
499
    if returnTransaction.closedAt:
500
        rTransaction.closedAt = to_java_date(returnTransaction.closedAt)
501
    if returnTransaction.customerAddress:
502
        rTransaction.customerAddress = returnTransaction.customerAddress
503
    if returnTransaction.pincode:
504
        rTransaction.pincode = returnTransaction.pincode
505
    if returnTransaction.customerCity:
506
        rTransaction.customerCity = returnTransaction.customerCity
507
    if returnTransaction.customerState:
508
        rTransaction.customerState = returnTransaction.customerState
509
    if returnTransaction.customerPhone:
510
        rTransaction.customerPhone = returnTransaction.customerPhone
511
    rTransaction.returnOrders = []
512
 
513
    for returnOrder in returnTransaction.returnOrders:
514
        rTransaction.returnOrders.append(to_t_returnOrderInfo(returnOrder))
515
    return rTransaction
516
 
517
def to_t_returnOrderInfo(returnorderInfo):
19817 manish.sha 518
    print returnorderInfo
18578 manish.sha 519
    return_OrderInfo = returnOrderInfo()
19817 manish.sha 520
    if returnorderInfo is None:
521
        return return_OrderInfo
522
    return_OrderInfo.id = returnorderInfo.id
523
    return_OrderInfo.returnTransactionId = returnorderInfo.returnTransaction_id
18578 manish.sha 524
    return_OrderInfo.masterOrderId = returnorderInfo.masterOrderId
525
    return_OrderInfo.orderId = returnorderInfo.orderId
526
    return_OrderInfo.lineItemId = returnorderInfo.lineItemId
527
    return_OrderInfo.logisticsRequestId = returnorderInfo.logisticsRequestId
528
    return_OrderInfo.returnQuantity = returnorderInfo.returnQuantity
529
    return_OrderInfo.receivedQuantity = return_OrderInfo.receivedQuantity
530
    return_OrderInfo.createdAt = to_java_date(returnorderInfo.createdAt)
531
    if returnorderInfo.processedAt:
532
        return_OrderInfo.processedAt = to_java_date(returnorderInfo.processedAt)
533
    return_OrderInfo.returnStatus = returnorderInfo.returnStatus
534
    if returnorderInfo.reshippedAt:
535
        return_OrderInfo.reshippedAt = to_java_date(returnorderInfo.reshippedAt)
536
    if returnorderInfo.receivedAt:
537
        return_OrderInfo.receivedAt = to_java_date(returnorderInfo.receivedAt)
538
    if returnorderInfo.refundReason:
539
        return_OrderInfo.refundReason = returnorderInfo.refundReason
540
    if returnorderInfo.refundedBy:
541
        return_OrderInfo.refundedBy = returnorderInfo.refundedBy
542
    if returnorderInfo.refundedAt:
543
        return_OrderInfo.refundedAt = to_java_date(returnorderInfo.refundedAt)
544
    return_OrderInfo.lineitem = to_t_lineitem(returnorderInfo.lineitem)
545
    if returnorderInfo.logisticsRequestId:
546
        return_OrderInfo.returnPickUpRequest = to_t_rPickupRequest(returnorderInfo.returnPickUpRequest)
547
    return_OrderInfo.warehouse_id = returnorderInfo.warehouse_id
548
    if returnorderInfo.refundAmount:
549
        return_OrderInfo.refundAmount = returnorderInfo.refundAmount
550
    return_OrderInfo.refundType = returnorderInfo.refundType
551
    return_OrderInfo.refundDescription = returnorderInfo.refundDescription
552
    return_OrderInfo.shippingType = returnorderInfo.shippingType
553
    return_OrderInfo.replacementOrderId = returnorderInfo.replacementOrderId
554
    return_OrderInfo.receivedReturnType = returnorderInfo.receivedReturnType
555
    return_OrderInfo.freebieItemId = returnorderInfo.freebieItemId
556
    return_OrderInfo.returnAction = returnorderInfo.returnAction
557
    if returnorderInfo.returnTxnResolutionStatus:
558
        return_OrderInfo.returnTxnResolutionStatus = ReturnTxnResolutionStatus._NAMES_TO_VALUES[returnorderInfo.returnTxnResolutionStatus]
559
    return return_OrderInfo
560
 
561
def to_t_rPickupRequest(returnPickupRequest):
562
    rPickupRequest = RPickupRequest()
19817 manish.sha 563
    if returnPickupRequest is None:
564
        return rPickupRequest
18578 manish.sha 565
    rPickupRequest.id = returnPickupRequest.id
566
    rPickupRequest.logisticsProviderId = returnPickupRequest.logisticsProviderId
567
    rPickupRequest.pickupRequestNo = returnPickupRequest.pickupRequestNo
568
    if returnPickupRequest.confirmedAt:
569
        rPickupRequest.confirmedAt = to_java_date(returnPickupRequest.confirmedAt)
570
    if returnPickupRequest.promised_pickup_timestamp:
571
        rPickupRequest.promised_pickup_timestamp = to_java_date(returnPickupRequest.promised_pickup_timestamp)
572
    if returnPickupRequest.pickedUpAt:
573
        rPickupRequest.pickedUpAt = to_java_date(returnPickupRequest.pickedUpAt)
574
    rPickupRequest.pickupStatus = ReturnTxnPickupStatus._NAMES_TO_VALUES[returnPickupRequest.pickupStatus]
575
    return rPickupRequest
18634 manish.sha 576
 
577
def to_t_Creditor(creditor):
578
    t_Creditor = TCreditor()
579
    t_Creditor.id = creditor.id
580
    t_Creditor.created = to_java_date(creditor.created)
581
    t_Creditor.name = creditor.name
582
    t_Creditor.updated = to_java_date(creditor.updated)
583
    t_Creditor.active = creditor.active
584
    return t_Creditor
585
 
586
def to_t_CreditHistory(creditHistory):
587
    t_CreditHistory = TCreditHistory()
588
    t_CreditHistory.id = creditHistory.id
589
    t_CreditHistory.user_id = creditHistory.user_id
590
    t_CreditHistory.creditor_id = creditHistory.creditor_id
591
    t_CreditHistory.payment_id = creditHistory.payment_id
592
    t_CreditHistory.amount = creditHistory.amount
593
    if creditHistory.credit_type:
594
        t_CreditHistory.credit_type = CreditTxnType._NAMES_TO_VALUES[creditHistory.credit_type]
595
    t_CreditHistory.shipping_id = creditHistory.shipping_id
596
    t_CreditHistory.created = to_java_date(creditHistory.created)
597
    return t_CreditHistory
598
 
18677 manish.sha 599
def to_t_UserSanction(userSanction, ticketSize):
18634 manish.sha 600
    t_UserSanction = TUserSanction()
601
    t_UserSanction.user_id = userSanction.user_id
602
    t_UserSanction.creditor_id = userSanction.creditor_id
603
    t_UserSanction.user_ref_id = userSanction.user_ref_id
604
    t_UserSanction.credit_limit = userSanction.credit_limit
605
    t_UserSanction.credit_blocked = userSanction.credit_blocked
606
    t_UserSanction.loan = userSanction.loan
607
    t_UserSanction.active = userSanction.active
608
    t_UserSanction.created = to_java_date(userSanction.created)
609
    if userSanction.updated:
610
        t_UserSanction.updated = to_java_date(userSanction.updated)
18677 manish.sha 611
    t_UserSanction.ticket_size = ticketSize
18634 manish.sha 612
 
613
    return t_UserSanction
614
 
615
def to_t_LoanHistory(loanHistory):
616
    t_LoanHistory = TLoanHistory()
617
    t_LoanHistory.id = loanHistory.id
618
    t_LoanHistory.user_id = loanHistory.user_id
619
    t_LoanHistory.creditor_id = loanHistory.creditor_id
620
    t_LoanHistory.payment_id = loanHistory.payment_id
621
    t_LoanHistory.amount = loanHistory.amount
622
    if loanHistory.credit_type:
623
        t_LoanHistory.credit_type = CreditTxnType._NAMES_TO_VALUES[loanHistory.credit_type]
624
    t_LoanHistory.created = to_java_date(loanHistory.created)
625
    if loanHistory.updated:
626
        t_LoanHistory.updated = to_java_date(loanHistory.updated)
627
    t_LoanHistory.loan_id = loanHistory.loan_id
628
    if loanHistory.due_date:
629
        t_LoanHistory.due_date = to_java_date(loanHistory.due_date)  
630
    if loanHistory.value_date:
631
        t_LoanHistory.value_date = to_java_date(loanHistory.value_date)
18769 manish.sha 632
    if loanHistory.invoiceNumber:
633
        t_LoanHistory.invoiceNumber = loanHistory.invoiceNumber
18634 manish.sha 634
 
635
    return t_LoanHistory
636
 
18802 manish.sha 637
def to_t_PaginatedCreditHistory(hasMore, totalCount, creditHistoryList):
18794 manish.sha 638
    t_PaginatedCreditHostory = TPaginatedCreditHistory()
639
    t_PaginatedCreditHostory.hasMore = hasMore
640
    t_PaginatedCreditHostory.totalCount = totalCount
641
    creditHistory = []
642
    for credit_history in creditHistoryList:
643
        creditHistory.append(to_t_CreditHistory(credit_history))
644
    t_PaginatedCreditHostory.creditHistoryList = creditHistory
645
 
646
    return t_PaginatedCreditHostory
647
 
648
def to_t_PaginatedLoanHistory(hasMore, totalCount, loanHistoryList):
649
    t_PaginatedLoanHistory = TPaginatedLoanHistory()
650
    t_PaginatedLoanHistory.hasMore = hasMore
651
    t_PaginatedLoanHistory.totalCount = totalCount
652
    loanHistory = []
653
    for loan_history in loanHistoryList:
654
        loanHistory.append(to_t_LoanHistory(loan_history))
655
    t_PaginatedLoanHistory.loanHistoryList = loanHistory
656
 
657
    return t_PaginatedLoanHistory
658
 
659
def to_t_PaginatedUserSanction(hasMore, totalCount, userSanctionList):
660
    t_PaginatedUserSanction = TPaginatedUserSanction()
661
    t_PaginatedUserSanction.hasMore = hasMore
662
    t_PaginatedUserSanction.totalCount = totalCount
663
    t_PaginatedUserSanction.userSanctions = userSanctionList
664
 
665
    return t_PaginatedUserSanction
666
 
19889 manas 667
def to_t_OutstandingPayments(outstandingPayment,counterName):
668
    t_OutstandingPayment = TOutstandingPayments()
669
    t_OutstandingPayment.user_id = outstandingPayment.user_id
19890 manas 670
    t_OutstandingPayment.counter_name = counterName
19889 manas 671
    t_OutstandingPayment.creditor_id = outstandingPayment.creditor_id
672
    t_OutstandingPayment.payment_id = outstandingPayment.payment_id
673
    t_OutstandingPayment.totalAmount = outstandingPayment.totalAmount 
19891 manas 674
    t_OutstandingPayment.created =  to_java_date(outstandingPayment.createdDate)
19889 manas 675
    return t_OutstandingPayment
19912 manas 676
 
677
def __loanHistoryObj(user_id, creditor_id, paymentId, amount, credit_type, loan_id, value_date=None, invoiceNumber=None):
678
    loanobj = TLoanHistory()
679
    loanobj.user_id = user_id
680
    loanobj.creditor_id = creditor_id    
681
    loanobj.payment_id = paymentId
682
    loanobj.amount = amount
683
    loanobj.credit_type = credit_type
684
    loanobj.loan_id = loan_id
685
    if value_date is not None:
686
        loanobj.value_date = to_java_date(value_date)
687
    if invoiceNumber is not None:
688
        loanobj.invoiceNumber = invoiceNumber
689
    return loanobj
19889 manas 690
 
19474 manish.sha 691
def to_t_ShipmentLogisticsCostDetail(shipmentLogisticsCostDetail):
692
    t_ShipmentLogisticsCostDetail = TShipmentLogisticsCostDetail()
693
    t_ShipmentLogisticsCostDetail.logisticsTransactionId = shipmentLogisticsCostDetail.logisticsTransactionId
694
    t_ShipmentLogisticsCostDetail.airwayBillNo = shipmentLogisticsCostDetail.airwayBillNo
695
    t_ShipmentLogisticsCostDetail.shipmentAmount = shipmentLogisticsCostDetail.shipmentAmount
696
    t_ShipmentLogisticsCostDetail.shipmentWeight = shipmentLogisticsCostDetail.shipmentWeight
697
    t_ShipmentLogisticsCostDetail.shipmentLogsiticsCost = shipmentLogisticsCostDetail.shipmentLogsiticsCost
698
    t_ShipmentLogisticsCostDetail.shipmentCodCollectionCharges = shipmentLogisticsCostDetail.shipmentCodCollectionCharges
699
    t_ShipmentLogisticsCostDetail.createdAt = to_java_date(shipmentLogisticsCostDetail.createdAt)
700
    if shipmentLogisticsCostDetail.updatedAt:
701
        t_ShipmentLogisticsCostDetail.updatedAt = to_java_date(shipmentLogisticsCostDetail.updatedAt)
702
 
703
    return t_ShipmentLogisticsCostDetail