def userInsertFeedback():
try:
if adminLoginSession() == 'user':
feedbackSubject = request.form['feedbackSubject']
feedbackDescription = request.form['feedbackDescription']
feedbackRating = request.form['feedbackRating']
feedbackDate = date.today()
feedbackTime = datetime.now().strftime("%H:%M:%S")
feedbackFrom_LoginId = session['session_loginId']
feedbackVO = FeedbackVO()
feedbackDAO = FeedbackDAO()
feedbackVO.feedbackSubject = feedbackSubject
feedbackVO.feedbackDescription = feedbackDescription
feedbackVO.feedbackRating = feedbackRating
feedbackVO.feedbackDate = feedbackDate
feedbackVO.feedbackTime = feedbackTime
feedbackVO.feedbackFrom_LoginId = feedbackFrom_LoginId
feedbackDAO.insertFeedback(feedbackVO)
return redirect(url_for('userViewFeedback'))
else:
return adminLogoutSession()
except Exception as ex:
print(ex)
def userLoadDashboard():
try:
if adminLoginSession() == 'user':
pendingComplainCount = 0
repliedComplainCount = 0
loginID = session['session_loginId']
complainDAO = ComplainDAO()
complainList = complainDAO.viewComplain(loginID)
print('complainList>>>>>', complainList)
for i in complainList:
if i.complainStatus == 'replied':
repliedComplainCount += 1
elif i.complainStatus == 'Pending':
pendingComplainCount += 1
feedbackVO = FeedbackVO()
feedbackDAO = FeedbackDAO()
feedbackVO.feedbackFrom_LoginId = loginID
feedbackList = feedbackDAO.viewFeedback(feedbackVO)
feedbackCount = len(feedbackList)
return render_template('user/index.html',
pendingComplainCount=pendingComplainCount,
repliedComplainCount=repliedComplainCount,
feedbackCount=feedbackCount)
else:
return adminLogoutSession()
except Exception as ex:
print(ex)
def userInsertFeedback():
try:
feedbackSubject = request.form['feedbackSubject']
feedbackDescription = request.form['feedbackDescription']
feedbackRating = request.form['feedbackRating']
feedbackVO = FeedbackVO()
feedbackDAO = FeedbackDAO()
todayDate = str(datetime.now().date())
timeNow = datetime.now().strftime("%H:%M:%S")
feedbackVO.feedbackFrom_LoginId = session['session_loginId']
feedbackVO.feedbackSubject = feedbackSubject
feedbackVO.feedbackDescription = feedbackDescription
feedbackVO.feedbackRating = feedbackRating
feedbackVO.feedbackDate = todayDate
feedbackVO.feedbackTime = timeNow
feedbackDAO.insertFeedback(feedbackVO)
return redirect(url_for('userViewFeedback'))
except Exception as ex:
print(ex)
def viewUserFeedback():
if session['loginRole']!= 'user':
return redirect(url_for('login'))
feedbackDAO = FeedbackDAO()
feedbackVO = FeedbackVO()
feedbackVO.feedbackFrom_LoginId = session['loginId']
feedbackDict = feedbackDAO.searchFeedbackById(feedbackVO)
return render_template('user/viewFeedback.html',feedbackDict=feedbackDict)
def userViewFeedback():
try:
if adminLoginSession() == "user":
feedbackDAO = FeedbackDAO()
feedbackVO = FeedbackVO()
feedbackFrom_LoginId = session['session_loginId']
feedbackVO.feedbackFrom_LoginId = feedbackFrom_LoginId
feedbackVOList = feedbackDAO.userViewFeedback(feedbackVO)
return render_template('user/viewFeedback.html', feedbackVOList=feedbackVOList)
else:
return adminLogoutSession()
except Exception as ex:
print(ex)
def userViewFeedback():
try:
if adminLoginSession() == 'user':
feedbackDAO = FeedbackDAO()
feedbackVO = FeedbackVO()
feedbackFrom_LoginId = session['session_loginId']
feedbackVO.feedbackFrom_LoginId = feedbackFrom_LoginId
feedbackVOList = feedbackDAO.userViewFeedback(feedbackVO)
print("______________", feedbackVOList)
return render_template("user/viewFeedback.html", feedbackVOList=feedbackVOList)
else:
return redirect(url_for("adminLogoutSession"))
except Exception as ex:
print(ex)
def viewFeedback():
try:
if session['loginRole'] == 'admin':
feedbackDAO = FeedbackDAO()
feedbackDict = feedbackDAO.searchFeedback()
return render_template('admin/viewFeedback.html',
feedbackDict=feedbackDict)
else:
feedbackDAO = FeedbackDAO()
feedbackVO = FeedbackVO()
feedbackVO.feedbackFrom_LoginId = session['loginId']
feedbackDict = feedbackDAO.searchFeedbackById(feedbackVO)
return render_template('user/viewFeedback.html',
feedbackDict=feedbackDict)
except:
return render_template('admin/login.html')
def userViewFeedback():
try:
feedbackDAO = FeedbackDAO()
feedbackVO = FeedbackVO()
feedbackFrom_LoginId = session['session_loginId']
print(feedbackFrom_LoginId)
feedbackVO.feedbackFrom_LoginId = feedbackFrom_LoginId
print(feedbackVO.feedbackFrom_LoginId)
feedbackVOList = feedbackDAO.viewFeedback(feedbackVO)
print("______________", feedbackVOList)
return render_template('user/viewFeedback.html',
feedbackVOList=feedbackVOList)
except Exception as ex:
print(ex)
def insertFeedback():
if session['loginRole'] != 'user':
return redirect(url_for('login'))
else:
feedbackDAO = FeedbackDAO()
feedbackVO = FeedbackVO()
feedbackVO.feedbackRating = request.form['feedbackRating']
feedbackVO.feedbackMessage = request.form['feedbackMessage']
feedbackVO.feedbackDate, feedbackVO.feedbackTime = str(
datetime.now()).split(' ')
feedbackVO.feedbackActiveStatus = 'active'
feedbackVO.feedbackFrom_LoginId = session['loginId']
feedbackDAO.insertFeedback(feedbackVO)
return redirect(url_for('postFeedback'))
def userLoadDashboard():
try:
if adminLoginSession() == 'user':
complainVO = ComplainVO()
complainDAO = ComplainDAO()
feedbackVO = FeedbackVO()
feedbackDAO = FeedbackDAO()
pendingComplainCount = 0
repliedComplainCount = 0
totalFeedbackCount = 0
reviewFeedbackCount = 0
loginId = session['session_loginId']
complainVO.complainFrom_LoginId = loginId
complainVOList = complainDAO.userViewComplain(complainVO)
for i in complainVOList:
if i.complainStatus == 'Pending':
pendingComplainCount += 1
elif i.complainStatus == 'Replied':
repliedComplainCount += 1
feedbackVO.feedbackFrom_LoginId = loginId
feedbackVOList = feedbackDAO.userViewFeedback(feedbackVO)
for i in feedbackVOList:
if i.feedbackTo_LoginId is not None:
reviewFeedbackCount += 1
totalFeedbackCount += 1
return render_template('user/Index.html',
pendingComplainCount=pendingComplainCount,
repliedComplainCount=repliedComplainCount,
totalFeedbackCount=totalFeedbackCount,
reviewFeedbackCount=reviewFeedbackCount)
else:
return adminLogoutSession()
except Exception as ex:
print(ex)