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