Subversion Repositories SmartDukaan

Rev

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

Rev Author Line No. Line
6048 rajveer 1
from suds.client import Client
2
import base64, re
3
from xml.dom.minidom import parseString
6092 rajveer 4
import logging
6235 rajveer 5
from datetime import datetime
6
import time
6338 rajveer 7
from shop2020.config.client.ConfigClient import ConfigClient
6345 rajveer 8
from decimal import Decimal
12979 kshitij.so 9
from shop2020.thriftpy.model.v1.order.ttypes import RechargeMode
6092 rajveer 10
logging.basicConfig(level=logging.INFO)
6048 rajveer 11
 
12991 kshitij.so 12
username = base64.b64encode('saholic20')
13
password = base64.b64encode('ap2020sh')
14
account_url = 'https://api.spicesafar.com/McommWebServices/AccountApiMcomm?wsdl'
15
recharge_url = 'https://api.spicesafar.com/McommWebServices/RechargeApiMcomm?wsdl'
6144 rajveer 16
aclient = None
17
raclient = None
6338 rajveer 18
allow_recharge = False
6048 rajveer 19
 
20251 amit.gupta 20
store_map = {
21
             'H01':'105',
22
'H02':'109',
23
'H03':'113',
24
'H04':'115',
25
'H05':'116',
26
'H06':'119',
27
'H07':'120',
28
'H08':'125',
29
'H09':'129',
30
'H10':'130',
31
'H11':'131',
32
'H12':'132',
33
'H13':'133',
34
'H14':'134',
35
'H15':'135',
36
'H16':'141',
37
'H17':'143',
38
'H18':'144',
39
'H19':'146',
40
'H20':'147',
41
'H21':'150',
42
'H22':'151',
43
'H23':'153',
44
'H24':'159',
45
'H25':'164',
46
'H26':'189',
47
'H27':'226',
48
'H28':'230',
49
'H29':'253',
50
'H30':'254',
51
'H31':'265',
52
'H32':'281',
53
'H33':'296',
54
'H34':'327',
55
'H35':'358',
56
'H36':'425',
57
'H37':'427',
58
'H38':'440',
59
'H39':'441',
60
'H40':'469',
61
'H41':'475',
62
'H42':'502',
63
'H43':'C31',
64
'H44':'C33',
65
'H45':'C34',
66
'H46':'C52',
67
'H47':'C70',
68
'H48':'C76',
69
'H49':'C86',
70
'H50':'C87',
71
'H51':'CA6',
72
'H52':'CB7',
73
'H53':'CC5',
74
'H54':'CC9',
75
'H55':'CE0',
76
'H56':'CF6',
77
'H57':'CF8',
78
'H58':'CG3',
79
'H59':'CQ0',
80
'H60':'CQ9',
81
'H61':'CR4',
82
'H62':'CS0',
83
'H70':'M01',
84
'H71':'M02',
85
'H72':'M07',
86
'H73':'M08',
87
'H74':'MB5',
88
'H75':'CM8',
89
'H76':'M78',
90
'H77':'112',
91
'H78':'137',
92
'H79':'138',
93
'H80':'165',
94
'H81':'255',
95
'H82':'317',
96
'H83':'347',
97
'H84':'476',
98
'H85':'477',
99
'H86':'518',
100
'H87':'C49',
101
'H88':'CC4',
102
'H89':'CF9',
103
'H90':'178',
104
'H91':'183',
105
'H92':'200',
106
'H93':'239',
107
'H94':'309',
108
'H95':'CD1',
109
'H96':'CD8',
110
'H97':'CE1',
111
'H98':'CI5',
112
'H99':'CK6',
113
'HA0':'CL2',
114
'HA1':'CN5',
115
'HA2':'G02',
116
'HA3':'G03',
117
'HA4':'G04',
118
'HA5':'G05',
119
'HA6':'G06',
120
'HA7':'G07',
121
'HA8':'G10',
122
'HA9':'G12',
123
'HB0':'G14',
124
'HB1':'G15',
125
'HB2':'G17',
126
'HB3':'M49',
127
'HB4':'M51',
128
'HB5':'M54',
129
'HB6':'353',
130
'HB7':'414',
131
'HB8':'431',
132
'HB9':'CA0',
133
'HC0':'CK4',
134
'HC1':'M26',
135
'HC2':'M27',
136
'HC3':'208',
137
'HC4':'215',
138
'HC5':'231',
139
'HC6':'240',
140
'HC7':'252',
141
'HC8':'289',
142
'HC9':'383',
143
'HD0':'CB3',
144
'HD1':'CD7',
145
'HD2':'CJ0',
146
'HD3':'CM3',
147
'HD4':'CN9',
148
'HD5':'CO3',
149
'HD6':'CQ1',
150
'HD7':'M46',
151
'HD8':'424',
152
'HD9':'M64',
153
'HE0':'145',
154
'HE1':'160',
155
'HE2':'328',
156
'HE3':'331',
157
'HE4':'343',
158
'HE5':'393',
159
'HE6':'460',
160
'HE7':'C25',
161
'HE8':'C84',
162
'HE9':'CB2',
163
'HF0':'CC3',
164
'HF1':'CC7',
165
'HF2':'CH5',
166
'HF3':'CP3',
167
'HF7':'M15',
168
'HF8':'471',
169
'HF9':'472',
170
'HG0':'481',
171
'HG1':'483',
172
'HG2':'484',
173
'HG3':'486',
174
'HG4':'C14',
175
'HG5':'C15',
176
'HG6':'C21',
177
'HG7':'C23',
178
'HG8':'C98',
179
'HG9':'CD2',
180
'HH0':'CD4',
181
'HH1':'CD5',
182
'HH2':'CG4',
183
'HH3':'CG5',
184
'HH4':'CG7',
185
'HH5':'CG8',
186
'HH6':'CI1',
187
'HH7':'CJ1',
188
'HH8':'CJ7',
189
'HH9':'CK1',
190
'HI0':'CK2',
191
'HI1':'CM1',
192
'HI2':'CM2',
193
'HI3':'CM5',
194
'HI4':'CN0',
195
'HI5':'CN4',
196
'HI6':'CO0',
197
'HI7':'CQ4',
198
'HI8':'CQ5',
20256 kshitij.so 199
'HI9':'CR8',
20304 kshitij.so 200
'H64':'CS3',
20348 kshitij.so 201
'H68':'CT4',
20349 kshitij.so 202
'H63':'CS1',
203
'H65':'CS6'
20251 amit.gupta 204
            }
205
 
6338 rajveer 206
allow_recharge_string = ConfigClient().get_property('allow_recharge')
6048 rajveer 207
 
6338 rajveer 208
if allow_recharge_string in ['True', 'true']:
209
    allow_recharge = True    
210
 
6144 rajveer 211
def getAccountClient():
212
    global aclient
213
    if aclient is None:
6227 rajveer 214
        aclient = Client(account_url, timeout=70)
6144 rajveer 215
    return aclient
216
 
217
def getRechargeClient():
218
    global raclient
219
    if raclient is None:
6227 rajveer 220
        raclient = Client(recharge_url, timeout=70)    
6144 rajveer 221
    return raclient
222
 
12979 kshitij.so 223
def rechargeDevice(transactionId, rechargeType, strProviderCode, deviceNumber, amount, plan, storeCode = '', rechargeMode=None):
6338 rajveer 224
    if not allow_recharge:
7996 anupam.sin 225
        return 'S', '00', 'spiceTID', 'SUCCESS', 'aggTID', 'providerTID'
20251 amit.gupta 226
    if storeCode:
21089 kshitij.so 227
        if store_map.get(storeCode) is not None:
228
            storeCode = store_map.get(storeCode)
7669 rajveer 229
    spString = getRechargeClient().service.getRecharge(username, password, '919650889334', 'SOAP', '115.249.47.66', transactionId, rechargeType, strProviderCode, deviceNumber, amount, 'DEBIT', plan, storeCode)
6093 rajveer 230
    print spString
6048 rajveer 231
    spString = re.sub('<\?.*\?>','',spString)
232
    spString = "<dom>" + spString + "</dom>"
233
    dom = parseString(spString)
234
    response = dom.getElementsByTagName('ActiveServicesPojo')[0]
235
    retStatus = response.getElementsByTagName('resStatus')[0].childNodes[0].data
236
    retCode = response.getElementsByTagName('respCode')[0].childNodes[0].data
237
    spiceTID = response.getElementsByTagName('SpiceTID')[0].childNodes[0].data
6092 rajveer 238
    retDesc = response.getElementsByTagName('shotDesc')[0].childNodes[0].data
12979 kshitij.so 239
 
7369 rajveer 240
    try:
241
        aggTID = response.getElementsByTagName('aggregatorId')[0].childNodes[0].data
242
        providerTID = response.getElementsByTagName('ProviderTID')[0].childNodes[0].data
243
    except:
244
        aggTID = ''
245
        providerTID = ''
12979 kshitij.so 246
 
247
    if (retCode !='00' or retStatus !='S') and rechargeMode == RechargeMode._NAMES_TO_VALUES.get('SYNC'):
12780 kshitij.so 248
        try:
249
            if (checkTransactionStatus('',transactionId))[0]:
250
                return 'S','00', spiceTID, retDesc, aggTID, providerTID
251
        except:
252
            pass
253
 
254
    return retStatus, retCode, spiceTID, retDesc, aggTID, providerTID
6048 rajveer 255
 
12780 kshitij.so 256
def checkTransactionStatus(spiceTID='', merchantTxnId=''):
12991 kshitij.so 257
    if not allow_recharge:
258
        return True, ''
12780 kshitij.so 259
    spString = getRechargeClient().service.getCheckStatus(username,password,spiceTID,merchantTxnId)
260
    print spString
261
    spString = re.sub('<\?.*\?>','',spString)
262
    spString = "<dom>" + spString + "</dom>"
263
    dom = parseString(spString)
264
    response = dom.getElementsByTagName('CheckStatusObj')[0]
265
    transStatus = response.getElementsByTagName('transStatus')[0].childNodes[0].data
266
    responseCode = response.getElementsByTagName('ResponseCode')[0].childNodes[0].data
267
    try:
268
        responseDescription = response.getElementsByTagName('ResponseDescription')[0].childNodes[0].data
269
    except:
270
        responseDescription = ""
271
    aggregatorRespCode = response.getElementsByTagName('aggregatorRespCode')[0].childNodes[0].data
272
    if responseCode == '00' and transStatus == 'S':
273
        return True, responseDescription
12979 kshitij.so 274
    elif responseCode == 'STP' and transStatus == 'S':
275
        raise Exception(111, "Still status is not known")
12780 kshitij.so 276
    elif responseCode in ('STO','US', 'UP') and transStatus == 'S':
277
        if aggregatorRespCode == '00':
278
            return True, responseDescription
279
        if aggregatorRespCode != 'NA':
280
            return False, responseDescription
281
        raise Exception(111, "Still status is not known")
282
    else:
283
        return False, responseDescription 
284
 
6048 rajveer 285
def getAccountdetail():
6144 rajveer 286
    return getAccountClient().service.getAccountdetail(username, password)
6151 rajveer 287
 
6048 rajveer 288
def getBalance():
6151 rajveer 289
    spString = getAccountClient().service.getBalance(username, password)
290
    print spString
291
    spString = re.sub('<\?.*\?>','',spString)
292
    spString = "<dom>" + spString + "</dom>"
293
    dom = parseString(spString)
294
    response = dom.getElementsByTagName('BalancePojo')[0]
295
    balanceAmount = response.getElementsByTagName('balance_amt')[0].childNodes[0].data
6345 rajveer 296
    return Decimal(balanceAmount)
6048 rajveer 297
 
298
def checkServiceProviderApi(strServiceCode, strDeviceNumber):
6144 rajveer 299
    spString = getAccountClient().service.checkServiceProviderApi(username, password, strServiceCode, strDeviceNumber)
6093 rajveer 300
    print spString
6054 rajveer 301
    spString = re.sub('<\?.*\?>','',spString)
302
    spString = "<dom>" + spString + "</dom>"
303
    dom = parseString(spString)
304
    response = dom.getElementsByTagName('CheckServiceProviderPojo')[0]
305
    providerCode = response.getElementsByTagName('providerCode')[0].childNodes[0].data
6235 rajveer 306
    try:
307
        operatorCircle = response.getElementsByTagName('operatorCircle')[0].childNodes[0].data
308
    except:
309
        operatorCircle = ""
310
    return providerCode, operatorCircle
6048 rajveer 311
 
312
def validateService(strServiceCode, strProviderCode, strDeviceNumber, dbAmount, strPlan):
6144 rajveer 313
    return getAccountClient().service.validateService(username, password, strServiceCode, strProviderCode, strDeviceNumber, dbAmount, strPlan)
6048 rajveer 314
 
315
def getAvailableServices():
6144 rajveer 316
    spString = getAccountClient().service.getServiceApi(username, password)
6109 rajveer 317
    print spString
6048 rajveer 318
    spString = re.sub('<\?.*\?>','',spString)
319
    spString = "<dom>" + spString + "</dom>"
320
    dom = parseString(spString)
321
    serviceApis = dom.getElementsByTagName('ServiceApiPojo')
322
    services = {}
323
    for serviceApi in serviceApis:
324
        services[serviceApi.getElementsByTagName('serviceCode')[0].childNodes[0].data] = serviceApi.getElementsByTagName('serviceDescription')[0].childNodes[0].data 
325
    return services
326
 
327
 
328
def getServiceProvidersForMobile():
329
    return getServiceProvider('MTP')
330
 
331
def getServiceProvidersForDTH():
332
    return getServiceProvider('RCH')
333
 
334
def getServiceProvider(strServiceCode):
6144 rajveer 335
    spString = getAccountClient().service.getServiceProvider(username, password, strServiceCode)
6109 rajveer 336
    print spString
6048 rajveer 337
    spString = re.sub('<\?.*\?>','',spString)
338
    spString = "<dom>" + spString + "</dom>"
339
    dom = parseString(spString)
340
    providers = dom.getElementsByTagName('ServicesProviderPojo')
341
    serviceProviders = {}
342
    for provider in providers:
343
        serviceProviders[provider.getElementsByTagName('providerCode')[0].childNodes[0].data] = provider.getElementsByTagName('providerDescription')[0].childNodes[0].data 
344
    return serviceProviders
6151 rajveer 345
 
6048 rajveer 346
def getServiceDetails(strServiceCode, strProviderCode):
6144 rajveer 347
    spString = getAccountClient().service.getServiceDetail(username, password, strServiceCode, strProviderCode)
6109 rajveer 348
    print spString
6048 rajveer 349
    spString = re.sub('<\?.*\?>','',spString)
350
    spString = "<dom>" + spString + "</dom>"
351
    dom = parseString(spString)
352
    details = dom.getElementsByTagName('ServiceDetailPojo')
353
    serviceDetails = {}
354
    for detail in details:
355
        serviceDetails['Denomination Type'] = detail.getElementsByTagName('DenominationType')[0].childNodes[0].data
356
        serviceDetails['Denomination Value'] = detail.getElementsByTagName('DenominationValue')[0].childNodes[0].data 
357
    return serviceDetails
358
 
6235 rajveer 359
 
360
def getRefunds(forDate):
361
    spString = getRechargeClient().service.checkRefundHistory(username, password, '3306', forDate.strftime("%d-%m-%Y"))
362
    print spString
363
    refundDetails = {}
364
    if spString is None or spString == "":
365
        return refundDetails
366
    spString = re.sub('<\?.*\?>','',spString)
367
    spString = "<dom>" + spString + "</dom>"
368
    dom = parseString(spString)
369
    refunds = dom.getElementsByTagName('checkRefundHistoryPojo')
370
    for refund in refunds:
6317 rajveer 371
        try:
372
            respStatus = refund.getElementsByTagName('respStatus')[0].childNodes[0].data
373
            respCode = refund.getElementsByTagName('respCode')[0].childNodes[0].data
374
            respDesc = refund.getElementsByTagName('respDesc')[0].childNodes[0].data
375
            refundAmmount = refund.getElementsByTagName('refundAmmount')[0].childNodes[0].data
376
            transId = refund.getElementsByTagName('transId')[0].childNodes[0].data
377
            deviceNo = refund.getElementsByTagName('deviceNo')[0].childNodes[0].data
378
            refundDateString = refund.getElementsByTagName('refundDate')[0].childNodes[0].data
379
            transactionDate  = refund.getElementsByTagName('transactionDate')[0].childNodes[0].data
380
            openningBalance  = refund.getElementsByTagName('openningBalance')[0].childNodes[0].data
381
            closingBalance  = refund.getElementsByTagName('closingBalance')[0].childNodes[0].data
382
            refundTime = time.strptime(refundDateString, "%Y-%m-%d %H:%M:%S.0")
383
            refundDate = datetime(*refundTime[0:6])
384
            refundDetails[transId] = int(refundAmmount), refundDate
385
        except:
386
            continue
9321 anupam.sin 387
    return refundDetails
388
 
389
def getAllTransactions(startDate, endDate):
390
    spString = getRechargeClient().service.getTransactionHistory(username, password, startDate.strftime("%d-%m-%Y"), endDate.strftime("%d-%m-%Y"))
391
    txnDetails = {}
392
    transactions = []
393
    if spString is None or spString == "":
394
        return txnDetails
395
    spString = re.sub('<\?.*\?>','',spString)
396
    spString = "<dom>" + spString + "</dom>"
397
    dom = parseString(spString)
398
    try:
399
        transactions = dom.getElementsByTagName('TransactionHistoryPojo')
400
    except:
9345 anupam.sin 401
        pass
11488 kshitij.so 402
    return transactions
403
 
404
def getRechargeStatus(spiceTID='', merchantTxnId=''):
405
    spString = getRechargeClient().service.getCheckStatus(username,password,spiceTID,merchantTxnId)
406
    print spString
407
    spString = re.sub('<\?.*\?>','',spString)
408
    spString = "<dom>" + spString + "</dom>"
409
    dom = parseString(spString)
410
    response = dom.getElementsByTagName('CheckStatusObj')[0]
411
    transStatus = response.getElementsByTagName('transStatus')[0].childNodes[0].data
412
    responseCode = response.getElementsByTagName('ResponseCode')[0].childNodes[0].data
413
    try:
414
        responseDescription = response.getElementsByTagName('ResponseDescription')[0].childNodes[0].data
415
    except:
416
        responseDescription = ""
417
    return responseCode, responseDescription
12979 kshitij.so 418
 
419
def main():
420
    #print rechargeDevice(20141031157,'MTP','BSP','9459060666',1,'')
21089 kshitij.so 421
    print checkTransactionStatus("", 1004866117)
12979 kshitij.so 422
 
423
if __name__=='__main__':
424
    main()