def validatePayment(params):
amount = params['amount']
debtAccounttype = params['debtaccounttype']
debtAccountNumber = params['debtaccountnumber']
fromaccount = params['fromaccount']
Validation.fromaccount1(fromaccount, amount)
Dbase.pay(debtAccounttype, debtAccountNumber, fromaccount)
def loginValidate(params):
try:
if 'password' not in params:
username = params['username']
if not Dbase.usernameExists(username):
response = make_response(json.dumps('InValid Username'),
400)
response.headers['Content-Type'] = 'application/json'
return response
response = make_response(json.dumps('Valid Username'), 200)
response.headers['Content-Type'] = 'application/json'
return response
else:
username = params['username']
password = params['password']
if not Dbase.verifyLoginPassword(username, password):
response = make_response(json.dumps('Invalid Credentials'),
400)
response.headers['Content-Type'] = 'application/json'
return response
#login successful
ssn = Dbase.getSecurityNumber(username)
customername = Dbase.getCustomerName(ssn)
login_session['ssn'] = ssn
login_session['customername'] = customername
login_session['username'] = username
response = make_response(json.dumps('Valid Credentials'), 200)
response.headers['Content-Type'] = 'application/json'
return response
except Exception as e:
raise e
def getCustomerDetailsDict(ssn):
try:
customerDetails = {}
loanaccounts = Dbase.getLoanAccounts(ssn)
loanaccountlist = []
for loanaccount in loanaccounts:
loanDict = {}
loanDict['loannumber'] = loanaccount[0]
loanDict['customername'] = loanaccount[1]
loanDict['password'] = loanaccount[2]
loanDict['loantype'] = loanaccount[4]
loanDict['loanamount'] = str(loanaccount[5])
loanaccountlist.append(loanDict)
customerDetails['loanaccounts'] = loanaccountlist
creditCardAccounts = Dbase.getCreditCards(ssn)
creditCardList = []
for creditAccount in creditCardAccounts:
creditDict = {}
creditDict['cardnumber'] = creditAccount[0]
creditDict['cardholder'] = creditAccount[1]
creditDict['pin'] = creditAccount[2]
creditDict['creditlimit'] = str(creditAccount[4])
creditDict['amountdue'] = str(creditAccount[5])
creditCardList.append(creditDict)
customerDetails['creditcards'] = creditCardList
debitCardAccounts = Dbase.getDebitCards(ssn)
debitCardList = []
for debitAccount in debitCardAccounts:
debitDict = {}
debitDict['cardnumber'] = debitAccount[0]
debitDict['cardholder'] = debitAccount[2]
debitDict['pin'] = debitAccount[3]
debitDict['accountnumber'] = debitAccount[1]
debitDict['accountbalance'] = str(debitAccount[5])
debitDict['accounttype'] = debitAccount[6]
debitCardList.append(debitDict)
customerDetails['debitcards'] = debitCardList
insuranceAccounts = Dbase.getInsuranceAccounts(ssn)
insuranceList = []
for insurance in insuranceAccounts:
insuranceDict = {}
insuranceDict['number'] = insurance[0]
insuranceDict['customername'] = insurance[1]
insuranceDict['password'] = insurance[2]
insuranceDict['insurancetype'] = insurance[4]
insuranceDict['premium'] = insurance[5]
insuranceDict['duedate'] = time.strftime(
'%m\%d\%Y', time.strptime(insurance[6], '%m-%d-%Y'))
insuranceList.append(insuranceDict)
customerDetails['insurances'] = insuranceList
return customerDetails
except Exception as e:
raise e
def transferAmount(params):
try:
fromaccount = params['fromaccount']
toaccount = params['toaccount']
amount = params['amount']
Dbase.transfer(fromaccount, toaccount, amount)
except Exception as e:
raise e
def getSavingsAccounts():
try:
ssn = login_session['ssn']
accounts = Dbase.getSavingsAccounts(ssn)
return accounts
except Exception as e:
raise e
def process_pass_code(self, update, auth_code):
# type: (UpdateCmn, str) -> bool
if self.authorized_user(update.user):
self.msg.send_message(NewMessageBody(
'Вы уже являетесь авторизованным пользователем!'),
user_id=update.user_id)
return True
if auth_code == BotDevHelper.passwords.get(update.user_id):
self.msg.send_message(
NewMessageBody('Поздравляем, авторизация успешна!'),
user_id=update.user_id)
db = Dbase('localhost', 'table_name', 'login', 'pass')
db.insert(str(update.user_id))
return True
else:
self.msg.send_message(
NewMessageBody('Введён неверный код. Повторите.'),
user_id=update.user_id)
return False
def password(number, verification_type, password):
if not Dbase.verifyPassword(number, verification_type, password):
if verification_type in ("creditcard", "debitcard"):
response = make_response(json.dumps('PIN doesn\'t match.'),
400)
response.headers['Content-Type'] = 'application/json'
return response
response = make_response(json.dumps('Password doesn\'t match.'),
400)
response.headers['Content-Type'] = 'application/json'
return response
return None
def toaccount(accountno):
if re.match(r"^[0-9]{16}$", accountno) == None:
response = make_response(json.dumps('Invalid Account Number'), 400)
response.headers['Content-Type'] = 'application/json'
return response
if not Dbase.accountExists(accountno):
response = make_response(
json.dumps('Account Number doestn\'t exists'), 400)
response.headers['Content-Type'] = 'application/json'
return response
return None
def getTransactions(accounttype, accountno, startdate, enddate):
try:
# print(accounttype)
transactionDict = {}
transactions = Dbase.getTransactionDetails(accounttype, accountno)
if accounttype == "debitcard":
debit_accountno = Dbase.getDebitCardAccountno(accountno)
transactions += Dbase.getTransactionDetails(
accounttype, debit_accountno)
# print(transactions)
tranxList = []
# print(transactions)
transactions.sort(
key=lambda r: time.strptime(r[8], '%m:%d:%Y %H:%M:%S'),
reverse=True)
for trans in transactions:
tranxDict = {}
tranxDict['tranxdate'] = trans[8].split(' ')[0].replace(
':', '/')
if time.strptime(tranxDict['tranxdate'],
'%m/%d/%Y') >= startdate and time.strptime(
tranxDict['tranxdate'],
'%m/%d/%Y') <= enddate:
tranxDict['tranxid'] = trans[0]
tranxDict['account1type'] = trans[2]
tranxDict['account2'] = trans[3]
tranxDict['account2type'] = trans[4]
tranxDict['amount'] = trans[5]
tranxDict['tranxtype'] = trans[6]
tranxDict['tranxdate'] = trans[8].split(' ')[0].replace(
':', '/')
tranxDict['tranxtime'] = trans[8].split(' ')[1]
tranxDict['status'] = trans[9]
tranxList.append(tranxDict)
transactionDict['transactions'] = tranxList
return transactionDict
except Exception as e:
raise e
def mobileno(mobileno):
if re.match(r'^[0-9]{10}$', mobileno) == None:
response = make_response(json.dumps('Invalid mobile Number'), 400)
response.headers['Content-Type'] = 'application/json'
return response
if Dbase.mobilenoExists(mobileno):
response = make_response(
json.dumps('Mobile number already registered with an account'),
400)
response.headers['Content-Type'] = 'application/json'
return response
return None
def username(username):
if len(username) < 3:
response = make_response(
json.dumps('Username must have atleast 3 character'), 400)
response.headers['Content-Type'] = 'application/json'
return response
if Dbase.usernameExists(username):
response = make_response(json.dumps('Username already taken'), 400)
response.headers['Content-Type'] = 'application/json'
return response
response = make_response(json.dumps('Valid Username'), 200)
response.headers['Content-Type'] = 'application/json'
return response
def securitynumber(number, verification_type, securitynumber):
if re.match(r"^[0-9]{6}$", securitynumber) == None:
response = make_response(json.dumps('Invalid Security Number'),
400)
response.headers['Content-Type'] = 'application/json'
return response
if not Dbase.verifySecurityNumber(number, verification_type,
securitynumber):
response = make_response(
json.dumps('Security Number doesn\'t match'), 400)
response.headers['Content-Type'] = 'application/json'
return response
return None
def getDebtAccount(accounttype, number):
try:
account = Dbase.getAccountDetails(accounttype, number)
debtAccount = {}
debtAccount['accounttype'] = accounttype
debtAccount['number'] = number
if accounttype == 'creditcard':
debtAccount['amount'] = account[5]
elif accounttype == 'loanaccount':
debtAccount['amount'] = account[5]
else:
debtAccount['amount'] = account[5]
return debtAccount
except Exception as e:
raise e
def accountNumber(number, verification_type):
if re.match(r"^[0-9]{16}$", number) == None:
message = ''
if verification_type == 'loanaccount':
message = "Invalid Loan Account Number"
elif verification_type == 'insurance':
message = 'Invalid Insurance number'
else:
message = 'Invalid Card Number'
response = make_response(json.dumps(message), 400)
response.headers['Content-Type'] = 'application/json'
return response
if not Dbase.verificationNumberExists(number, verification_type):
response = make_response(
json.dumps('Account with this number hasn\'t been opened.'),
400)
response.headers['Content-Type'] = 'application/json'
return response
return None
def email(email):
if re.match(
r"^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,4})$",
email) == None:
response = make_response(json.dumps('Invalid Email Format'), 400)
response.headers['Content-Type'] = 'application/json'
return response
elif len(email) > 254:
response = make_response(json.dumps('Email too long'), 400)
response.headers['Content-Type'] = 'application/json'
return response
if Dbase.emailExists(email):
response = make_response(
json.dumps(
'This email has already been registered with an account'),
400)
response.headers['Content-Type'] = 'application/json'
return response
return None
from flask import Flask
app = Flask(__name__)
app.secret_key = b'_5#y2L"F4Q8z\n\xec]/'
from flask import request, redirect, url_for
from db import Dbase
from flask import render_template, session
import json
dba = Dbase()
@app.route('/')
def index():
return 'Index Page'
@app.route('/login', methods=['GET', 'POST'])
def login():
if request.method == 'POST':
us = {
'usuario': request.form['user'],
'auth': request.form['pass']
}
user = dba.get_user(us)
if user:
session['perfil'] = user['perfil']
print('us', user)
if us:
return redirect(url_for('consult'))
else:
return 'El usuario no existe'
def authorized_user(user):
# type: (User) -> bool
db = Dbase('localhost', 'table_name', 'login', 'pass')
#db.check(str(user.user_id)) == True:
return db.check(user.user_id)
def fromaccount(accountno, amount):
if not Dbase.hasAccountBalance(accountno, amount):
response = make_response(
json.dumps('Not enough balance in your account'), 400)
response.headers['Content-Type'] = 'application/json'
return response
def fromaccount1(accountno, amount):
if not Dbase.hasAccountBalance(accountno, amount):
raise Exception('Not enough balance in your account')
def validate(params):
try:
if params['registerno'] == '1':
verification_type = params['verificationtype']
securitynumber = params['securitynumber']
if Dbase.securitynumberExists(securitynumber):
response = make_response(
json.dumps('You have already registered with us'), 400)
response.headers['Content-Type'] = 'application/json'
return response
number = params['number'].strip()
resp = Validation.accountNumber(number, verification_type)
if resp != None:
return resp
password = params['password'].strip()
resp = Validation.password(number, verification_type, password)
if resp != None:
return resp
resp = Validation.securitynumber(number, verification_type,
securitynumber)
if resp != None:
return resp
email = params['email'].strip()
resp = Validation.email(email)
if resp != None:
return resp
mobileno = params['mobileno'].strip()
resp = Validation.mobileno(mobileno)
if resp != None:
return resp
elif params['registerno'] == '2':
username = params['username']
userpassword = params['userpassword']
resp = Validation.username(username)
if resp != None:
return resp
resp = Validation.userpassword(userpassword)
if resp != None:
return resp
elif params['registerno'] == '3':
answer = params['answer']
if len(answer) == 0:
response = make_response(json.dumps('Give a valid Answer'),
400)
response.headers['Content-Type'] = 'application/json'
return response
else:
print(params['registerno'] == 'confirm')
Dbase.register(params)
customername = Dbase.getCustomerName(params['securitynumber'])
login_session['ssn'] = params['securitynumber']
login_session['customername'] = customername
login_session['username'] = params['username']
response = make_response(json.dumps('Registered'), 200)
response.headers['Content-Type'] = 'application/json'
return response
response = make_response(json.dumps('Registered'), 200)
response.headers['Content-Type'] = 'application/json'
return response
except Exception as e:
raise e
def getAccountDetails(accounttype, accountno):
try:
detailsDict = {}
account = Dbase.getAccountDetails(accounttype, accountno)
print(account)
detailsDict['accounttype'] = accounttype
detailsDict['id'] = accountno
print(account)
if accounttype == 'loanaccount':
detailsDict['loannumber'] = account[0]
detailsDict['customername'] = account[1]
detailsDict['password'] = account[2]
detailsDict['loantype'] = account[4]
detailsDict['loanamount'] = str(amount[5])
elif accounttype == 'insurance':
detailsDict['number'] = account[0]
detailsDict['customername'] = account[1]
detailsDict['password'] = account[2]
detailsDict['insurancetype'] = account[4]
detailsDict['premium'] = account[5]
detailsDict['duedate'] = time.strftime(
'%m\%d\%Y', time.strptime(account[6], '%m-%d-%Y'))
detailsDict['insuranceamount'] = account[7]
elif accounttype == 'creditcard':
detailsDict['cardnumber'] = account[0]
detailsDict['cardholder'] = account[1]
detailsDict['pin'] = account[2]
detailsDict['creditlimit'] = str(account[4])
detailsDict['amountdue'] = str(account[5])
else:
detailsDict['cardnumber'] = account[0]
detailsDict['cardholder'] = account[2]
detailsDict['pin'] = account[3]
detailsDict['accountnumber'] = account[1]
detailsDict['accountbalance'] = str(account[5])
detailsDict['debitaccounttype'] = account[6]
transactions = Dbase.getTransactionDetails(accounttype, accountno)
if accounttype == "debitcard":
debit_accountno = Dbase.getDebitCardAccountno(accountno)
transactions += Dbase.getTransactionDetails(
accounttype, debit_accountno)
tranxList = []
transactions.sort(
key=lambda r: time.strptime(r[8], '%m:%d:%Y %H:%M:%S'),
reverse=True)
count = 0
for trans in transactions:
tranxDict = {}
tranxDict['tranxid'] = trans[0]
tranxDict['account1type'] = trans[2]
tranxDict['account2'] = trans[3]
tranxDict['account2type'] = trans[4]
tranxDict['amount'] = trans[5]
tranxDict['tranxtype'] = trans[6]
tranxDict['tranxdate'] = trans[8].split(' ')[0].replace(
':', '/')
tranxDict['tranxtime'] = trans[8].split(' ')[1]
tranxDict['status'] = trans[9]
tranxList.append(tranxDict)
count += 1
if count == 10:
break
detailsDict['transactions'] = tranxList
return detailsDict
except Exception as e:
raise e
