def approveLoanRequest(args):
expr = {constants.loanCust.LOAN_CUST_ID.name: args[constants.loanCust.LOAN_CUST_ID.name]}
req_coll = db.find_docs(constants.collectionName.loan_customer_counter.name, expr)
inserted_id = None
if req_coll.count() == 0:
return False
inserted_id = utils.return_first_row(req_coll)[constants.misc_webargs.INSERTED_ID.name]
## find loan
expr = {"_id": inserted_id, constants.loanCust.LOAN_STATE.name: constants.loanState.NEW.name}
projection = {"_id": 0}
req_coll = db.find_docs_projection(constants.collectionName.loan_customer.name, expr, projection)
if req_coll.count() == 0:
return False
data = utils.return_first_row(req_coll)
# we have data
## find corresponding loan offer
expr = {constants.loanInv.ID.name: data[constants.loanCust.LOAN_INVT_ID.name]}
req_coll_2 = db.find_docs(constants.collectionName.loan_inventory.name, expr)
if req_coll_2.count() == 0:
return False
validation_data = utils.return_first_row(req_coll_2)
data[constants.loanCust.LOAN_STATE.name] = args[constants.loanCust.LOAN_STATE.name]
data[constants.misc_webargs.TIMESTAMP.name] = utils.generate_current_utc()
inserted_id = db.insert_one_doc(constants.collectionName.loan_customer.name, data).inserted_id
##update insert id
expr = {constants.loanCust.LOAN_CUST_ID.name: args[constants.loanCust.LOAN_CUST_ID.name]}
updt = {'$set': {constants.misc_webargs.INSERTED_ID.name: inserted_id}}
db.find_and_modify(constants.collectionName.loan_customer_counter.name, expr, updt, {})
return True
def checkPassword(username, password):
expr = {constants.misc_webargs.USERNAME.name: {'$regex': generateExactMatchPattern(username), '$options': 'i'}}
cursor = db.find_docs(constants.collectionName.users.name, expr)
for val in cursor: # first object and return
hash = val[constants.misc_webargs.PASSWORD.name]
return utils.verify_hashedPassword(password, hash)
return False
def editUserInfo(args):
expr = {constants.misc_webargs.USERNAME.name: {
'$regex': generateExactMatchPattern(args[constants.misc_webargs.REFERRER_USERNAME.name]), '$options': 'i'}}
cursor = db.find_docs(constants.collectionName.users.name, expr)
updt = {}
role = None
for val in cursor:
role = val[constants.misc_webargs.ROLE.name]
if role == constants.roles.ADMIN.name:
if constants.misc_webargs.CREDIT_SCORE.name in args and \
args[constants.misc_webargs.CREDIT_SCORE.name] is not None:
updt["constants.misc_webargs.CREDIT_SCORE.name"] = args[constants.misc_webargs.CREDIT_SCORE.name]
if constants.misc_webargs.DOCUMENT1_VER_STATUS.name in args and \
args[constants.misc_webargs.DOCUMENT1_VER_STATUS.name] is not None:
updt["constants.misc_webargs.DOCUMENT1_VER_STATUS.name"] = args[
constants.misc_webargs.DOCUMENT1_VER_STATUS.name]
if constants.misc_webargs.DOCUMENT2_VER_STATUS.name in args and \
args[constants.misc_webargs.DOCUMENT2_VER_STATUS.name] is not None:
updt["constants.misc_webargs.DOCUMENT2_VER_STATUS.name"] = args[
constants.misc_webargs.DOCUMENT2_VER_STATUS.name]
elif role == constants.roles.AGENT.name:
if constants.misc_webargs.TIMEZONE.name in args and args[constants.misc_webargs.TIMEZONE.name] is not None:
updt["constants.misc_webargs.TIMEZONE.name"] = args[constants.misc_webargs.TIMEZONE.name]
else:
return False
try:
db.find_and_modify(constants.collectionName.users.name, expr, updt, False)
except:
return False
return True
def listCustomers(username):
expr = {constants.misc_webargs.AGENT_NAME.name: {'$regex': generateExactMatchPattern(username), '$options': 'i'}}
cursor = db.find_docs(constants.collectionName.relations.name, expr)
listData = []
for val in cursor:
customer = val[constants.misc_webargs.CUSTOMER_NAME.name]
listData.append(customer)
return listData
def addLoan(args):
expr = {constants.loanInv.ID.name: args[constants.loanCust.LOAN_INVT_ID.name]}
loan_object = db.find_docs(constants.collectionName.loan_inventory.name, expr).limit(1)
minimum_Dur = minimum_Amt = maximum_Dur = maximum_Amt = is_Emi_Avail = None
for loan_item in loan_object:
minimum_Amt = loan_item[constants.loanInv.MIN_AMT.name]
maximum_Amt = loan_item[constants.loanInv.MAX_AMT.name]
minimum_Dur = loan_item[constants.loanInv.MIN_DURATION.name]
maximum_Dur = loan_item[constants.loanInv.MAX_DURATION.name]
is_Emi_Avail = loan_item[constants.loanInv.EMI_AVAILABLE.name]
cust_amt = args[constants.loanCust.AMT.name]
cust_dur = args[constants.loanCust.DURATION.name]
cust_emi_status = args[constants.loanCust.EMI_CHOSEN.name]
if not (cust_amt <= maximum_Amt and cust_amt >= minimum_Amt):
return False
if not (cust_dur <= maximum_Dur and cust_dur >= minimum_Dur):
return False
if cust_emi_status == True:
if is_Emi_Avail != True:
return False
loan_cust_id = str(getCustomerLoanId())
loan_doc = {
constants.loanCust.LOAN_CUST_ID.name: loan_cust_id,
constants.misc_webargs.CUSTOMER_NAME.name: args[constants.misc_webargs.CUSTOMER_NAME.name],
constants.misc_webargs.REFERRER_USERNAME.name: args[constants.misc_webargs.REFERRER_USERNAME.name],
constants.loanCust.LOAN_INVT_ID.name: args[constants.loanCust.LOAN_INVT_ID.name],
constants.loanCust.AMT.name: cust_amt,
constants.loanCust.DURATION.name: args[constants.loanCust.DURATION.name],
constants.loanCust.MANDATORY_REQUIREMENT1_LOC.name: args[constants.loanCust.MANDATORY_REQUIREMENT1_LOC.name],
constants.loanCust.MANDATORY_REQUIREMENT2_LOC.name: args[constants.loanCust.MANDATORY_REQUIREMENT2_LOC.name],
constants.loanCust.EMI_CHOSEN.name: cust_emi_status,
constants.loanCust.LOAN_STATE.name: constants.loanState.NEW.name,
constants.misc_webargs.TIMESTAMP.name: utils.generate_current_utc()
}
try:
loan_inserted_id = db.insert_one_doc(constants.collectionName.loan_customer.name, loan_doc).inserted_id
loan_customer_counter_doc = {constants.loanCust.LOAN_CUST_ID.name: loan_cust_id,
constants.misc_webargs.INSERTED_ID.name: loan_inserted_id,
constants.misc_webargs.USERNAME.name: args[
constants.misc_webargs.CUSTOMER_NAME.name]}
db.insert_one_doc(constants.collectionName.loan_customer_counter.name, loan_customer_counter_doc)
except Exception as e:
print(e)
return False
return True
def getListOfUsers(username):
expr = {constants.misc_webargs.USERNAME.name: {'$regex': generateExactMatchPattern(username), '$options': 'i'}}
cursor = db.find_docs(constants.collectionName.users.name, expr)
role = None
for val in cursor:
role = val[constants.misc_webargs.ROLE.name]
if role == constants.roles.ADMIN.name:
adminList = listOtherUsers(constants.roles.ADMIN.name, username)
agentList = listOtherUsers(constants.roles.AGENT.name, username)
customerList = listOtherUsers(constants.roles.CUSTOMER.name, username)
return utils.generate_response(1, {constants.roles.ADMIN.name: adminList, constants.roles.AGENT.name: agentList,
constants.roles.CUSTOMER.name: customerList})
elif role == constants.roles.AGENT.name:
adminList = listOtherUsers(constants.roles.ADMIN.name, username)
agentList = listOtherUsers(constants.roles.AGENT.name, username)
customerList = listCustomers(username)
return utils.generate_response(1, {constants.roles.ADMIN.name: adminList, constants.roles.AGENT.name: agentList,
constants.roles.CUSTOMER.name: customerList})
else:
return utils.generate_response(0, "FAILURE")
def viewLoansRequest(username):
expr = {constants.misc_webargs.USERNAME.name: {'$regex': generateExactMatchPattern(username), '$options': 'i'}}
cursor = db.find_docs(constants.collectionName.users.name, expr)
role = None
for val in cursor:
role = val[constants.misc_webargs.ROLE.name]
if role == constants.roles.ADMIN.name:
expr = [{"$lookup": {"from": "loan_customer", "localField": "INSERTED_ID", "foreignField": "_id", "as": "R"}},
{"$project":{"R._id":0, "INSERTED_ID":0,"_id":0,"R.TIMESTAMP":0,"LOAN_CUST_ID":0,"USERNAME":0}},{"$unwind": "$R"}]
elif role == constants.roles.AGENT.name:
expr = [{"$lookup": {"from": "loan_customer", "localField": "INSERTED_ID", "foreignField": "_id", "as": "R"}},
{"$project":{"R._id":0, "INSERTED_ID":0,"_id":0,"R.TIMESTAMP":0,"LOAN_CUST_ID":0,"USERNAME":0}},{"$match":{"R.REFERRER_USERNAME":username}},{"$unwind": "$R"}]
else:
expr = [{"$lookup": {"from": "loan_customer", "localField": "INSERTED_ID", "foreignField": "_id", "as": "R"}},
{"$project":{"R._id":0, "INSERTED_ID":0,"_id":0,"R.TIMESTAMP":0,"LOAN_CUST_ID":0,"USERNAME":0}},{"$match":{"R.CUSTOMER_NAME":username}},{"$unwind": "$R"}]
listData = []
req_coll = db.aggregate_db(constants.collectionName.loan_customer_counter.name, expr)
for val in list(req_coll):
listData.append(val)
return utils.generate_response(1, listData)
def editLoanRequest(args):
# expr = {[{"$lookup": {"from": "loan_customer", "localField": "INSERTED_ID", "foreignField": "_id", "as": "R"}},
# {"$unwind": "$R"},{"$project":{"R._id":0}}, {"$match":{"LOAN_CUST_ID":args[constants.loanCust.LOAN_CUST_ID.name]}}]}
# req_coll = db.aggregate_db(constants.collectionName.loan_customer_counter.name,expr)
# print (req_coll["LOAN_CUST_ID"])
# return False
## find id
expr = {constants.loanCust.LOAN_CUST_ID.name: args[constants.loanCust.LOAN_CUST_ID.name],
constants.misc_webargs.USERNAME.name: args[constants.misc_webargs.CUSTOMER_NAME.name]}
req_coll = db.find_docs(constants.collectionName.loan_customer_counter.name, expr)
inserted_id = None
if req_coll.count() == 0:
return False
inserted_id = utils.return_first_row(req_coll)[constants.misc_webargs.INSERTED_ID.name]
## find loan
expr = {"_id": inserted_id, constants.loanCust.LOAN_STATE.name: constants.loanState.NEW.name}
projection = {"_id": 0}
req_coll = db.find_docs_projection(constants.collectionName.loan_customer.name, expr, projection)
if req_coll.count() == 0:
return False
data = utils.return_first_row(req_coll)
# we have data
## find corresponding loan offer
expr = {constants.loanInv.ID.name: data[constants.loanCust.LOAN_INVT_ID.name]}
req_coll_2 = db.find_docs(constants.collectionName.loan_inventory.name, expr)
if req_coll_2.count() == 0:
return False
validation_data = utils.return_first_row(req_coll_2)
minimum_Amt = validation_data[constants.loanInv.MIN_AMT.name]
maximum_Amt = validation_data[constants.loanInv.MAX_AMT.name]
minimum_Dur = validation_data[constants.loanInv.MIN_DURATION.name]
maximum_Dur = validation_data[constants.loanInv.MAX_DURATION.name]
if constants.loanCust.AMT.name in args :
if args[constants.loanCust.AMT.name] != None and args[constants.loanCust.AMT.name] >= minimum_Amt and args[constants.loanCust.AMT.name] <= maximum_Amt:
data[constants.loanCust.AMT.name] = args[constants.loanCust.AMT.name]
else:
return False
if constants.loanCust.DURATION.name in args:
if args[constants.loanCust.DURATION.name] != None and args[
constants.loanCust.DURATION.name] >= minimum_Dur and args[constants.loanCust.DURATION.name] <= maximum_Dur:
data[constants.loanCust.DURATION.name] = args[constants.loanCust.DURATION.name]
else:
return False
if constants.loanCust.MANDATORY_REQUIREMENT1_LOC in args and args[
constants.loanCust.MANDATORY_REQUIREMENT1_LOC.name] != None:
data[constants.loanCust.MANDATORY_REQUIREMENT1_LOC.name] = args[
constants.loanCust.MANDATORY_REQUIREMENT1_LOC.name]
if constants.loanCust.MANDATORY_REQUIREMENT2_LOC.name in args and args[
constants.loanCust.MANDATORY_REQUIREMENT2_LOC.name] != None:
data[constants.loanCust.MANDATORY_REQUIREMENT2_LOC.name] = args[
constants.loanCust.MANDATORY_REQUIREMENT2_LOC.name]
## insert loan with new data
data[constants.misc_webargs.TIMESTAMP.name] = utils.generate_current_utc()
inserted_id = db.insert_one_doc(constants.collectionName.loan_customer.name, data).inserted_id
##update insert id
expr = {constants.loanCust.LOAN_CUST_ID.name: args[constants.loanCust.LOAN_CUST_ID.name]}
updt = {'$set': {constants.misc_webargs.INSERTED_ID.name: inserted_id}}
db.find_and_modify(constants.collectionName.loan_customer_counter.name, expr, updt, {})
return True