def userEditProfile():
try:
if adminLoginSession() == "user":
areaDAO = AreaDAO()
areaVOList = areaDAO.viewArea()
print(areaVOList)
cityDAO = CityDAO()
cityVOList = cityDAO.viewCity()
print(cityVOList)
bloodGroupDAO = BloodGroupDAO()
bloodGroupVOList = bloodGroupDAO.viewBloodGroup()
print(bloodGroupVOList)
userDAO = UserDAO()
loginId = session['session_loginId']
userVOList = userDAO.getUserData(loginId)
userVOAllList = userDAO.getUserAllData(loginId)
print("@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@")
print(userVOList)
return render_template('user/editProfile.html',
userVOList=userVOList,
userVOAllList=userVOAllList,
areaVOList=areaVOList,
cityVOList=cityVOList,
bloodGroupVOList=bloodGroupVOList)
else:
return adminLogoutSession()
except Exception as ex:
print(ex)
def bloodbankCompleteEmergencyRequest():
try:
if adminLoginSession() == "bloodbank":
userDAO = UserDAO()
emergencyRequestDAO = EmergencyRequestDAO()
emergencyRequestVO = EmergencyRequestVO()
emergencyRequestId = request.args.get('emergencyRequestId')
emergencyRequest_BloodGroupId = request.args.get(
'emergencyRequest_BloodGroupId')
emergencyRequest_AreaId = request.args.get(
'emergencyRequest_AreaId')
emergencyRequestStatus = "Complete"
emergencyRequestVO.emergencyRequestId = emergencyRequestId
emergencyRequestVO.emergencyRequestStatus = emergencyRequestStatus
#_______________________________________________MAIL___________________________________________________________________
userVOList = userDAO.getUserForEmergencyRequest(
emergencyRequest_AreaId, emergencyRequest_BloodGroupId)
userId = []
for i in userVOList:
userId.append(i[1].loginUsername)
print(userId)
sender = "*****@*****.**"
receiver = userId
msg = MIMEMultipart()
msg['From'] = sender
msg['To'] = ",".join(receiver)
msg['Subject'] = "EMERGENCY BLOOD REQUEST FULFILL"
msg.attach(
MIMEText(
'Dear User,\nAs of now,the requirement of the needed blood is fulfilled.We will keep you updated whenever the need arises.\n\nThank you'
))
server = smtplib.SMTP('smtp.gmail.com', 587)
server.starttls()
server.login(sender, "Qwer123@")
text = msg.as_string()
server.sendmail(sender, receiver, text)
#_______________________________________________________________________________________________________________________
emergencyRequestDAO.completeEmergencyRequest(emergencyRequestVO)
return redirect(url_for('bloodbankViewEmergencyRequest'))
else:
return adminLogoutSession()
except Exception as ex:
print(ex)
def userViewEmergencyRequest():
try:
if adminLoginSession() == "user":
print(
"VVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVV"
)
emergencyRequestDAO = EmergencyRequestDAO()
loginId = session["session_loginId"]
loginUsername = session['session_loginUsername']
userVO = UserVO()
userDAO = UserDAO()
userList = userDAO.getUserAllData(loginId)
user_BloodGroupId = userList[0].user_BloodGroupId
user_AreaId = userList[0].user_AreaId
print("area:", user_AreaId)
print("blood group:", user_BloodGroupId)
status = "Pending"
emergencyRequestList = emergencyRequestDAO.viewUserEmergencyRequest(
user_BloodGroupId, user_AreaId, status)
#_____________________________________________________________________________________________________________________
emergencyRequestAllList = emergencyRequestDAO.viewEmergencyRequest(
)
acceptEmergencyRequestList = emergencyRequestDAO.viewAcceptEmergencyRequest(
)
print(
"@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@"
)
list1 = []
list2 = []
for i in emergencyRequestAllList:
count = 0
for j in acceptEmergencyRequestList:
if i[0].emergencyRequestId == j.acceptEmergencyRequest_EmergencyRequestId and loginId == j.acceptEmergencyRequest_LoginId:
count += 1
print("Veer")
list1.append(i[0].emergencyRequestId)
list2.append(count)
acceptCount = list(zip(list1, list2))
print(list1)
print(list2)
print(acceptCount)
print(emergencyRequestList)
print(
"EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE"
)
return render_template('user/viewEmergencyRequest.html',
emergencyRequestList=emergencyRequestList,
acceptCount=acceptCount)
else:
return adminLogoutSession()
except Exception as ex:
print(ex)
def home():
try:
page = request.args.get('page', 1, type=int)
per_page = request.args.get('per_page', 10, type=int)
userDAO = UserDAO()
results = userDAO.viewUsers(page, per_page)
return render_template('home.html', results=results)
except Exception as ex:
print(ex)
def updateUserProfile():
try:
if adminLoginSession() == "user":
userVO = UserVO()
userDAO = UserDAO()
print("@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@")
userFirstName = request.form['userFirstName']
userLastName = request.form['userLastName']
userBirthDate = request.form['userBirthDate']
user_BloodGroupId = request.form['user_BloodGroupId']
userGender = request.form['userGender']
userWeight = request.form['userWeight']
userHeight = request.form['userHeight']
user_CityId = request.form['user_CityId']
userDiseases = request.form['userDiseases']
user_AreaId = request.form['user_AreaId']
userAddress = request.form['userAddress']
userContact = request.form['userContact']
userId = request.form['userId']
print("$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$")
userVO.user_CityId = user_CityId
userVO.user_BloodGroupId = user_BloodGroupId
userVO.userFirstName = userFirstName
userVO.userLastName = userLastName
userVO.userBirthDate = userBirthDate
userVO.userGender = userGender
userVO.userWeight = userWeight
userVO.userHeight = userHeight
userVO.userDiseases = userDiseases
userVO.user_AreaId = user_AreaId
userVO.userAddress = userAddress
userVO.userContact = userContact
userVO.userId = userId
print("!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!")
print(userId)
userDAO.editProfile(userVO)
print("^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^")
return render_template("user/index.html")
else:
return adminLogoutSession()
except Exception as ex:
print(ex)
def adminViewUser():
try:
if adminLoginSession() == "admin":
userDAO = UserDAO()
userVOList = userDAO.viewAdminUser()
return render_template('admin/viewUser.html',
userVOList=userVOList)
else:
return adminLogoutSession()
except Exception as ex:
print(ex)
def adminManageUser():
try:
if adminLoginSession() == "admin":
loginVO = LoginVO()
userDAO = UserDAO()
loginId = request.args.get('loginId')
userList = userDAO.getUserData(loginId)
userDictList = [i.as_dict() for i in userList]
if userDictList[0]['loginStatus'] == "inactive":
loginStatus = "active"
loginVO.loginId = loginId
loginVO.loginStatus = loginStatus
userDAO.manageUser(loginVO)
elif userDictList[0]['loginStatus'] == "active":
loginStatus = "inactive"
loginVO.loginId = loginId
loginVO.loginStatus = loginStatus
userDAO.manageUser(loginVO)
return redirect(url_for('adminViewUser'))
else:
return adminLogoutSession()
except Exception as ex:
print(ex)
def userInsertUser():
try:
loginVO = LoginVO()
loginDAO = LoginDAO()
userVO = UserVO()
userDAO = UserDAO()
loginUsername = request.form['loginUsername']
userFirstName = request.form['userFirstName']
userLastName = request.form['userLastName']
userBirthDate = request.form['userBirthDate']
user_BloodGroupId = request.form['user_BloodGroupId']
userGender = request.form['userGender']
userWeight = request.form['userWeight']
userHeight = request.form['userHeight']
user_CityId = request.form['user_CityId']
userDiseases = request.form['userDiseases']
user_AreaId = request.form['user_AreaId']
userAddress = request.form['userAddress']
userContact = request.form['userContact']
userFile = request.files['userFile']
print(userFile)
userFileName = secure_filename(userFile.filename)
print(userFileName)
userFilePath = os.path.join(app.config['UPLOAD_FOLDER'])
print(userFilePath)
userFile.save(os.path.join(userFilePath, userFileName))
userVO.userFileName = userFileName
userVO.userFilePath = userFilePath.replace("project", "..")
print("!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!")
loginPassword = ''.join(
(random.choice(string.ascii_letters + string.digits))
for x in range(8))
print("loginPassword="******"*****@*****.**"
sender = "*****@*****.**"
receiver = loginUsername
msg = MIMEMultipart()
msg['From'] = sender
msg['To'] = receiver
msg['Subject'] = "LOGIN PASSWORD"
msg.attach(MIMEText('Your Password is:' + loginPassword, 'plain'))
server = smtplib.SMTP('smtp.gmail.com', 587)
server.starttls()
#server.login(sender, "qazwsxedcrfvtgb1234567890")
server.login(sender, "Qwer123@")
text = msg.as_string()
server.sendmail(sender, receiver, text)
loginVO.loginUsername = loginUsername
loginVO.loginPassword = loginPassword
loginVO.loginRole = "user"
loginVO.loginStatus = "active"
loginVO.loginFileName = "None"
loginDAO.insertLogin(loginVO)
userVO.user_CityId = user_CityId
userVO.user_BloodGroupId = user_BloodGroupId
userVO.userFirstName = userFirstName
userVO.userLastName = userLastName
userVO.userBirthDate = userBirthDate
userVO.userGender = userGender
userVO.userWeight = userWeight
userVO.userHeight = userHeight
userVO.userDiseases = userDiseases
userVO.user_AreaId = user_AreaId
userVO.userAddress = userAddress
userVO.userContact = userContact
userVO.user_LoginId = loginVO.loginId
userDAO.insertUser(userVO)
server.quit()
return render_template("admin/takePicture.html",
loginUsername=loginUsername)
except Exception as ex:
print(ex)
def bloodbankInsertEmergencyRequest():
try:
if adminLoginSession() == "bloodbank":
print(
"00000000000000000000000000000000000000000000000000000000000000000"
)
emergencyRequestVO = EmergencyRequestVO()
emergencyRequestDAO = EmergencyRequestDAO()
userDAO = UserDAO()
loginId = session["session_loginId"]
bloodBankDAO = BloodBankDAO()
bloodBankList = bloodBankDAO.getBloodBank(loginId)
print(bloodBankList)
emergencyRequestQuantity = request.form['emergencyRequestQuantity']
emergencyRequest_BloodGroupId = request.form[
'emergencyRequest_BloodGroupId']
print("1111111111111111111111111111111111111111111111")
emergencyRequest_CityId = bloodBankList[0].bloodBank_CityId
emergencyRequest_AreaId = bloodBankList[0].bloodBank_AreaId
emergencyRequest_BloodBankId = bloodBankList[0].bloodBankId
emergencyRequest_LoginId = bloodBankList[0].bloodBank_LoginId
print("22222222222222222222222222222222222222222222222")
bloodGroupDAO = BloodGroupDAO()
bloodGroupList = bloodGroupDAO.getBloodGroupName(
emergencyRequest_BloodGroupId)
print(bloodGroupList)
emergencyRequestDate = str(datetime.now().date())
emergencyRequestTime = datetime.now().strftime("%H:%M:%S")
emergencyRequestStatus = "Pending"
print("333333333333333333333333333333333333333333333333333")
emergencyRequestPersonRequire = int(
emergencyRequestQuantity) * 525 / 350
emergencyRequestPersonRequire = math.ceil(
emergencyRequestPersonRequire)
print(emergencyRequestPersonRequire)
emergencyRequestVO.emergencyRequest_AreaId = emergencyRequest_AreaId
emergencyRequestVO.emergencyRequest_BloodBankId = emergencyRequest_BloodBankId
emergencyRequestVO.emergencyRequest_CityId = emergencyRequest_CityId
emergencyRequestVO.emergencyRequest_BloodGroupId = emergencyRequest_BloodGroupId
emergencyRequestVO.emergencyRequest_LoginId = emergencyRequest_LoginId
emergencyRequestVO.emergencyRequestQuantity = emergencyRequestQuantity
emergencyRequestVO.emergencyRequestDate = emergencyRequestDate
emergencyRequestVO.emergencyRequestTime = emergencyRequestTime
emergencyRequestVO.emergencyRequestStatus = emergencyRequestStatus
emergencyRequestVO.emergencyRequestPersonRequire = emergencyRequestPersonRequire
userVOList = userDAO.getUserForEmergencyRequest(
emergencyRequest_AreaId, emergencyRequest_BloodGroupId)
print(
"############################################################3"
)
userId = []
for i in userVOList:
userId.append(i[1].loginUsername)
print(userId)
#----------------------------------------------------MAIL SEND------------------------------------------------
sender = "*****@*****.**"
receiver = userId
msg = MIMEMultipart()
msg['From'] = sender
msg['To'] = ",".join(receiver)
msg['Subject'] = "EMERGENCY BLOOD REQUEST"
msg.attach(
MIMEText(
'Dear User,\nWe ' + str(bloodBankList[0].bloodBankName) +
' are in need of ' + str(bloodGroupList.bloodGroupName) +
".It would be very thankful of you if you come forward and donate."
))
server = smtplib.SMTP('smtp.gmail.com', 587)
server.starttls()
server.login(sender, "Qwer123@")
text = msg.as_string()
server.sendmail(sender, receiver, text)
#----------------------------------------------------------------------------------------------------
emergencyRequestDAO.insertEmergencyRequest(emergencyRequestVO)
return redirect(url_for('bloodbankViewEmergencyRequest'))
else:
return adminLogoutSession()
except Exception as ex:
print(ex)
def userAcceptEmergencyRequest():
try:
if adminLoginSession() == "user":
userDAO = UserDAO()
acceptEmergencyRequestVO = AcceptEmergencyRequestVO()
emergencyRequestDAO = EmergencyRequestDAO()
emergencyRequestVO = EmergencyRequestVO()
acceptEmergencyRequest_EmergencyRequestId = request.args.get(
'emergencyRequestId')
print(acceptEmergencyRequest_EmergencyRequestId)
acceptEmergencyRequest_LoginId = session["session_loginId"]
userAllList = userDAO.getUserAllData(
acceptEmergencyRequest_LoginId)
acceptEmergencyRequest_UserId = userAllList[0].userId
acceptEmergencyRequestDate = str(datetime.now().date())
acceptEmergencyRequestTime = datetime.now().strftime("%H:%M:%S")
acceptEmergencyRequestStatus = "Accepted"
acceptEmergencyRequestVO.acceptEmergencyRequest_EmergencyRequestId = acceptEmergencyRequest_EmergencyRequestId
acceptEmergencyRequestVO.acceptEmergencyRequest_LoginId = acceptEmergencyRequest_LoginId
acceptEmergencyRequestVO.acceptEmergencyRequest_UserId = acceptEmergencyRequest_UserId
acceptEmergencyRequestVO.acceptEmergencyRequestDate = acceptEmergencyRequestDate
acceptEmergencyRequestVO.acceptEmergencyRequestTime = acceptEmergencyRequestTime
acceptEmergencyRequestVO.acceptEmergencyRequestStatus = acceptEmergencyRequestStatus
emergencyRequestDAO.insertAcceptEmergencyRequest(
acceptEmergencyRequestVO)
acceptEmergencyRequestPersonList = emergencyRequestDAO.findPersonCount(
acceptEmergencyRequest_EmergencyRequestId)
acceptEmergencyRequestPersonDictList = [
i.as_dict() for i in acceptEmergencyRequestPersonList
]
print(acceptEmergencyRequestPersonDictList)
lenAcceptEmergencyRequestPersonDictList = len(
acceptEmergencyRequestPersonDictList)
print(
"############################################################33333333333333333"
)
print(lenAcceptEmergencyRequestPersonDictList)
emergencyRequestPersonList = emergencyRequestDAO.findPersonCountFromEmergencyRequest(
acceptEmergencyRequest_EmergencyRequestId)
print(emergencyRequestPersonList)
if emergencyRequestPersonList[0][
0].emergencyRequestPersonRequire == lenAcceptEmergencyRequestPersonDictList:
emergencyRequestVO.emergencyRequestId = acceptEmergencyRequest_EmergencyRequestId
emergencyRequestVO.emergencyRequestStatus = "Complete"
emergencyRequestDAO.completeEmergencyRequest(
emergencyRequestVO)
#___________________________________________________MAIL________________________________________________________________
emergencyRequest_BloodGroupId = request.args.get(
'emergencyRequest_BloodGroupId')
emergencyRequest_AreaId = request.args.get(
'emergencyRequest_AreaId')
userVOList = userDAO.getUserForEmergencyRequest(
emergencyRequest_AreaId, emergencyRequest_BloodGroupId)
print(
"############################################################3"
)
userId = []
for i in userVOList:
userId.append(i[1].loginUsername)
print(userId)
sender = "*****@*****.**"
receiver = userId
msg = MIMEMultipart()
msg['From'] = sender
msg['To'] = ",".join(receiver)
msg['Subject'] = "EMERGENCY BLOOD REQUEST FULFILL"
msg.attach(
MIMEText(
'Dear User,\nAs of now,the requirement of the needed blood is fulfilled.We will keep you updated whenever the need arises.\n\nThank you'
))
server = smtplib.SMTP('smtp.gmail.com', 587)
server.starttls()
server.login(sender, "Qwer123@")
text = msg.as_string()
server.sendmail(sender, receiver, text)
#_______________________________________________________________________________________________________________________
return redirect(url_for('userViewEmergencyRequest'))
else:
return adminLogoutSession()
except Exception as ex:
print(ex)