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 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 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)