def getInvestmentProfileService(userName):
try:
customerDetailsobjs = getCustomerDetailsDB(userName)
custTaskObj = checkTaskStatusByCustIdAndNameDB(
customerDetailsobjs[0].id, 'Investment')
investmentData = False
if len(custTaskObj) == 0:
custInvestmentgProfileObjs = getInvestmentProfileDB(
customerDetailsobjs[0].id)
investmentData = []
for custInvestmentgProfileObj in custInvestmentgProfileObjs:
obj = {
'order': custInvestmentgProfileObj.order,
'attribute': custInvestmentgProfileObj.attribute,
'custresponse': custInvestmentgProfileObj.custresponse,
'attributetype': custInvestmentgProfileObj.attributetype
}
investmentData.append(obj)
return investmentData
except Exception as e:
logging.error(
"Error in retreving Investment profile By custID service" + str(e))
raise
def getCustomerDetailsService(userName):
try:
customerDetailsObj = getCustomerDetailsDB(userName)
if len(customerDetailsObj) == 1:
return customerDetailsObj[0]
except Exception as e:
logging.error("Error in retrieving customer details service " + str(e))
raise
def sendOTPByEmailService(dataObj):
try:
otp = generateOTP()
getOTPByEmail(dataObj['email'], otp)
customerDetailsobjs = getCustomerDetailsDB(dataObj['custregmobile'])
updateEmailOTPDB(otp, customerDetailsobjs[0].id)
updateCustomerEmailDB(dataObj['email'], dataObj['custregmobile'])
except Exception as e:
logging.error("Error in sending OTP by email service " + str(e))
raise
def saveDocumentsService(userName):
try:
customerObj = getCustomerDetailsDB(userName)
customerObj = customerObj[0]
updateTaskByCustIdAndNameDB(customerObj.id,'Document','C')
except Exception as e:
logging.error("Error in save documents service "+str(e))
raise
def updateInvestmentProfileService(investmentProfileList, userName):
try:
customerDetailsobjs = getCustomerDetailsDB(userName)
print(investmentProfileList)
updateInvestmentProfileDB(investmentProfileList,
customerDetailsobjs[0].id)
except Exception as e:
logging.error("Error in updating Investment profile service" + str(e))
raise
def savePersonalProfileService(personal_profile, userName):
try:
customerDetailsobjs = getCustomerDetailsDB(userName)
updateCustomerProfileDB(personal_profile['cust'])
savePersonalProfileDB(personal_profile['custProfile'],
customerDetailsobjs[0].id)
updateTaskByCustIdAndNameDB(customerDetailsobjs[0].id, 'Personal', 'C')
except Exception as e:
logging.error("Error in saving personal profile " + str(e))
raise
def saveInvestmentProfileService(investmentProfileList, userName):
try:
customerDetailsobjs = getCustomerDetailsDB(userName)
saveInvestmentProfileDB(investmentProfileList,
customerDetailsobjs[0].id)
updateTaskByCustIdAndNameDB(customerDetailsobjs[0].id, 'Investment',
'C')
except Exception as e:
logging.error("Error in saving Investment profile service" + str(e))
raise
def validateMobileandSaveService(dataObj, ip, device):
try:
customerDetailsobjs = getCustomerDetailsDB(dataObj['custregmobile'])
if len(customerDetailsobjs) != 0:
clientDetails = validateClientMobileDB(customerDetailsobjs[0].id,
ip, device)
if len(clientDetails) == 0:
getOTP(dataObj['custcountrycode'] + dataObj['custregmobile'])
saveCustomerDetailsDB({
'custregmobile':
dataObj['custregmobile'],
'custstatus':
'P',
'custstatusold':
'P',
'custcountrycode':
dataObj['custcountrycode']
})
customerDetailsobjs = getCustomerDetailsDB(
dataObj['custregmobile'])
saveClientMobileService(dataObj, ip, device,
customerDetailsobjs[0].id)
return True
else:
return False
else:
getOTP(dataObj['custcountrycode'] + dataObj['custregmobile'])
saveCustomerDetailsDB({
'custregmobile': dataObj['custregmobile'],
'custstatus': 'P',
'custstatusold': 'P',
'custcountrycode': dataObj['custcountrycode']
})
customerDetailsobjs = getCustomerDetailsDB(
dataObj['custregmobile'])
saveClientMobileService(dataObj, ip, device,
customerDetailsobjs[0].id)
return True
except Exception as msg:
logging.error('Error in validating mobile service ' + str(msg))
raise
def updateCustPersonalProfileService(custPersonalProfileUpdatedata, userName):
try:
customerDetailsobjs = getCustomerDetailsDB(userName)
print(custPersonalProfileUpdatedata['custProfile'])
updateCustomerProfileDB(custPersonalProfileUpdatedata['cust'])
updatecustPersonalProfileDB(
custPersonalProfileUpdatedata['custProfile'],
customerDetailsobjs[0].id)
except Exception as e:
logging.error("Error in updating Personal Profile service" + str(e))
raise
def resendOTPService(dataObj):
try:
if dataObj['otpType'] == 'mobile':
reSendOTP(dataObj['custcountrycode'] + dataObj['custregmobile'])
elif dataObj['otpType'] == 'email':
otp = generateOTP()
getOTPByEmail(dataObj['email'], otp)
customerDetailsobjs = getCustomerDetailsDB(
dataObj['custregmobile'])
updateEmailOTPDB(otp, customerDetailsobjs[0].id)
except Exception as e:
logging.error("Error in resending OTP service " + str(e))
raise
def verifyOTPByEmailService(dataObj):
try:
customerDetailsobjs = getCustomerDetailsDB(dataObj['custregmobile'])
clientList = validateClientOTPByEmailDB(dataObj['otp'],
customerDetailsobjs[0].id)
if len(clientList) != 0:
return True
else:
return False
except Exception as e:
logging.error("Error in verifyting OTP by email" + str(e))
raise
def validateClientPasswordService(dataObj):
try:
customerDetailsobjs = getCustomerDetailsDB(dataObj['custregmobile'])
clientList = validateClientPasswordDB(dataObj['password'],
customerDetailsobjs[0].id)
if len(clientList) != 0:
return True
else:
return False
except Exception as e:
logging.error("Error in validating client credentials service " +
str(e))
raise
def saveClientPasswordService(dataObj, userName):
try:
customerDetailsobjs = getCustomerDetailsDB(userName)
custRegistrationObj = getCustRegistrationDB(customerDetailsobjs[0].id)
if custRegistrationObj.password == 'None':
saveClientPasswordDB(dataObj, customerDetailsobjs[0].id)
custObj = {'custregmobile': userName, 'customerStatus': 'R'}
updateCustomerDetailsDB(custObj)
custTasksObjs = getCustTasksByCustIdDB(customerDetailsobjs[0].id)
if len(custTasksObjs) != 3:
profileTaskStatusList = []
obj = {
'custid': customerDetailsobjs[0].id,
'taskname': 'Personal',
'status': 'P',
'tasktype': 'P'
}
profileTaskStatusList.append(obj)
obj = {
'custid': customerDetailsobjs[0].id,
'taskname': 'Investment',
'status': 'P',
'tasktype': 'P'
}
profileTaskStatusList.append(obj)
obj = {
'custid': customerDetailsobjs[0].id,
'taskname': 'Document',
'status': 'P',
'tasktype': 'D'
}
profileTaskStatusList.append(obj)
updateCustTaskStatusDB(profileTaskStatusList)
else:
saveClientPasswordDB(dataObj, customerDetailsobjs[0].id)
except Exception as e:
logging.error("Error in saving client password service " + str(e))
raise
def checkSubscriptionExpirationService(userName):
try:
customerObj = getCustomerDetailsDB(userName)
customerObj = customerObj[0]
custSubscriptionObjs = getCustSubscriptionByStatusAndCustIdDB(customerObj.id,'A')
for custSubscriptionObj in custSubscriptionObjs:
utc=pytz.UTC
expirationDt = custSubscriptionObj.servexpdt.replace(tzinfo=utc)
presentDt = datetime.datetime.now().replace(tzinfo=utc)
if presentDt<expirationDt:
return True
else:
updateCustSubscriptionStatusDB(customerObj.id,'E')
return False
except Exception as e:
logging.error("Error in checking subscription expiration "+str(e))
raise
def getcustPersonalProfileService(userName):
try:
customerDetailsobjs = getCustomerDetailsDB(userName)
custTaskObj = checkTaskStatusByCustIdAndNameDB(
customerDetailsobjs[0].id, 'Personal')
custPersonalProfileData = False
print(customerDetailsobjs[0].id)
print(len(custTaskObj))
if len(custTaskObj) == 0:
custPersonalProfileObjs = getcustPersonalProfileDB(
customerDetailsobjs[0].id)
custPersonalProfileData = []
for custPersoanlProfileObj in custPersonalProfileObjs:
obj = {
'order': custPersoanlProfileObj.order,
'attribute': custPersoanlProfileObj.attribute,
'custresponse': custPersoanlProfileObj.custresponse,
'attributetype': custPersoanlProfileObj.attributetype
}
custPersonalProfileData.append(obj)
elif len(custTaskObj) != 0:
custMblandEmail = Customer.objects.get(
id=customerDetailsobjs[0].id)
custPersonalProfileData = {
"custregmobile": custMblandEmail.custregmobile,
"custemail": custMblandEmail.custemail
}
return custPersonalProfileData
except Exception as e:
logging.error(
"Error in retrieving Personal profile By custID service" + str(e))
raise
def saveSubscriptionService(subscriptionDetils,userName):
try:
customerObj = getCustomerDetailsDB(userName)
customerObj = customerObj[0]
servsigneddt=datetime.datetime.now()
for servid in subscriptionDetils['servidList']:
servexpdt= servsigneddt+datetime.timedelta(365)
servexpdt = servsigneddt + datetime.timedelta(0,600)
obj = {
'custid':customerObj.id,
'servid':servid,
'servsigneddt':servsigneddt,
'servexpdt':servexpdt,
'servstatus':'A'
}
saveSubscriptionDetailsDB(obj)
custSubscriptionObj = getCustSubscriptionByServIDAndCustIdDB(customerObj.id,servid,'A')
if len(custSubscriptionObj) == 1:
custSubscriptionObj = custSubscriptionObj[0]
obj = {
'custid':customerObj.id,
'servid':servid,
'custsubid':custSubscriptionObj.id,
'paymentmod':subscriptionDetils['paymentmod'],
'paygateway':subscriptionDetils['paygateway'],
'payamount':subscriptionDetils['payamount'],
'payreference': subscriptionDetils['payreference']
}
savePaymentDetailsDB(obj)
custPaymentObj = getCustPaymentByIDsDB(customerObj.id,servid,custSubscriptionObj.id)
if len(custPaymentObj) == 1:
custPaymentObj = custPaymentObj[0]
updateCustSubscriptionPaymentIDDB(custSubscriptionObj.id,custPaymentObj.id)
if customerObj.custstatus == 'R' and customerObj.custstatusold == 'P':
dataObj ={
'custregmobile':userName,
'customerStatus':'S'
}
updateCustomerDetailsDB(dataObj)
elif customerObj.custstatus == 'E' and customerObj.custstatusold == 'S' :
dataObj ={
'custregmobile':userName,
'customerStatus':'S'
}
updateCustomerDetailsDB(dataObj)
elif customerObj.custstatus == 'E' and customerObj.custstatusold == 'I' :
dataObj ={
'custregmobile':userName,
'customerStatus':'I'
}
updateCustomerDetailsDB(dataObj)
except Exception as e:
logging.error("Error in saving subscription service "+str(e))
raise
