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 loadIndex(): try: if session['loginRole'] == 'admin': registerDAO = RegisterDAO() datasetDAO = DatasetDAO() blogDAO = BlogDAO() videoDAO = VideoDAO() complaintDAO = ComplaintDAO() feedbackDAO = FeedbackDAO() predictDAO = PredictDAO() userdict = registerDAO.countuser() companydict = datasetDAO.countcompany() blogDict = blogDAO.countBlog() videoDict = videoDAO.countVideo() complaintDict = complaintDAO.countComplaint() feedbackDict = feedbackDAO.countfeedback() predictDict = predictDAO.searchDPrediction() return render_template('admin/index.html', userdict=userdict, companydict=companydict, blogDict=blogDict, videoDict=videoDict, feedbackDict=feedbackDict, complaintDict=complaintDict, predictDict=predictDict) else: blogDAO = BlogDAO() blogDict = blogDAO.searchBlog() return render_template('user/index.html', blogDict=blogDict) except: return render_template('admin/login.html')
def adminLoadDashboard(): try: if adminLoginSession() == 'admin': feedbackDAO = FeedbackDAO() feedbackCount = feedbackDAO.adminFeedbackCount() complainDAO = ComplainDAO() complainCount = complainDAO.adminComplainCount() areaDAO = AreaDAO() areaCount = areaDAO.adminAreaCount() cameraDAO = CameraDAO() camaraCount = cameraDAO.adminCameraCount() trafficPoliceStationDAO = TrafficPoliceStationDAO() trafficPoliceStationVOList = trafficPoliceStationDAO.viewTrafficPoliceStation() print('TPSL >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> ', trafficPoliceStationVOList) return render_template('admin/index.html', trafficPoliceStationVOList=trafficPoliceStationVOList, feedbackCount=feedbackCount,complainCount=complainCount, areaCount=areaCount, camaraCount=camaraCount) else: adminLogoutSession() except Exception as ex: print(ex)
def adminLoadDashboard(): try: if adminLoginSession() == 'admin': complainCount = 0 feedbackCount = 0 userCount = 0 complainDAO = ComplainDAO() complainList = complainDAO.complainCount() print('complainList>>>>>', complainList) complainCount = complainList[0][0] feedbackDAO = FeedbackDAO() feedbackList = feedbackDAO.adminViewFeedback() feedbackCount = len(feedbackList) registerDAO = RegisterDAO() registerList = registerDAO.viewRegister() userCount = len(registerList) return render_template('admin/index.html', complainCount=complainCount, feedbackCount=feedbackCount, userCount=userCount) else: return adminLogoutSession() except Exception as ex: print(ex)
def insertfeedback(): if session['loginDictrole'] == 'seller': feedbackDAO = FeedbackDAO() feedbackVO = FeedbackVO() feedbackVO.feedbackSubject = str(request.form["feedbackSubject"]) feedbackVO.feedbackDescription = str( request.form["feedbackDescription"]) feedbackVO.feedbackRating = str(request.form["feedbackRating"]) datetime = time.ctime().split(" ") feedbackVO.feedbackTime = datetime[-2] feedbackVO.feedbackDate = " ".join( [datetime[1], datetime[2], datetime[4]]) feedbackVO.feedbackActivestatus = "active" feedbackVO.feedbackFrom_loginId = str(session['loginDictId']) #feedbackVO.feedback_loginId = str(session['loginDictId']) #print feedbackVO.feedback_loginId feedbackDAO.insertFeedback(feedbackVO) return "vffd"
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: 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 deleteFeedback(): if session['loginRole'] == 'admin': return redirect(url_for('login')) else: feedbackVO = FeedbackVO() feedbackDAO = FeedbackDAO() feedbackVO.feedbackId = request.args.get('feedbackId') feedbackVO.feedbackActiveStatus = 'deactive' feedbackDAO.deleteFeedback(feedbackVO) return redirect(url_for('viewFeedback'))
def loadManageFeedback(): if session['loginRole']!= 'admin': return redirect(url_for('login')) feedbackDAO = FeedbackDAO() feedbackDict = feedbackDAO.searchFeedback() return render_template('admin/manageFeedback.html',feedbackDict=feedbackDict)
def viewFeedback(): if session['loginDictrole'] == 'admin': feedbackDAO = FeedbackDAO() feedbackVO = FeedbackVO() feedbackVO.feedbackActiveStatus = 'activate' feedbackDict = feedbackDAO.searchFeedback(feedbackVO) return render_template('admin/viewfeedback.html', data2=feedbackDict) return render_template('admin/signin.html')
def adminViewFeedback(): try: if adminLoginSession() == 'admin': feedbackDAO = FeedbackDAO() feedbackVOList = feedbackDAO.adminViewFeedback() print("__________________", feedbackVOList) return render_template('admin/viewFeedback.html', feedbackVOList=feedbackVOList) else: return adminLogoutSession() except Exception as ex: print(ex)
def adminViewFeedback(): try: if adminLoginSession() == "admin": feedbackDAO = FeedbackDAO() feedbackVOList = feedbackDAO.viewBloodbankFeedback() return render_template('admin/viewFeedback.html', feedbackVOList=feedbackVOList) else: return adminLogoutSession() 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 updateFeedback(): if session['loginRole'] != 'admin': return redirect(url_for('login')) else: feedbackDAO = FeedbackDAO() feedbackVO = FeedbackVO() feedbackVO.feedbackId = request.args.get('feedbackId') feedbackVO.feedbackTo_LoginId = session['loginId'] feedbackDAO.updateFeedback(feedbackVO) return redirect(url_for('viewFeedback'))
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 bloodbankViewUserFeedback(): try: if adminLoginSession() == "bloodbank": feedbackDAO = FeedbackDAO() feedbackVOList = feedbackDAO.viewUserFeedback() print("####################################") print(feedbackVOList) return render_template('bloodbank/viewUserFeedback.html', feedbackVOList=feedbackVOList) else: return adminLogoutSession() except Exception as ex: print(ex)
def bloodbankDeleteFeedback(): try: if adminLoginSession() == "bloodbank": feedbackDAO = FeedbackDAO() feedbackId = request.args.get('feedbackId') feedbackDAO.deleteFeedback(feedbackId) return redirect(url_for('bloodbankViewFeedback')) else: return adminLogoutSession() except Exception as ex: print(ex)
def userDeleteFeedback(): try: if adminLoginSession() == "user": feedbackDAO = FeedbackDAO() feedbackId = request.args.get('feedbackId') feedbackDAO.deleteFeedback(feedbackId) return redirect(url_for('userLoadFeedback')) 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 deleteFeedback(): if session['loginDictrole'] == 'seller': feedbackDAO = FeedbackDAO() feedbackVO = FeedbackVO() feedbackVO.feedbackActiveStatus = 'deactivate' feedbackVO.feedbackId = request.args.get('feedbackId') feedbackDAO.deleteFeedback(feedbackVO) return redirect('/viewuserFeedback') else: return render_template('admin/login.html', loginerrorDict='Please login first')
def userDeleteFeedback(): try: feedbackVO = FeedbackVO() feedbackDAO = FeedbackDAO() feedbackId = request.args.get("feedbackId") feedbackVO.feedbackId = feedbackId feedbackDAO.deleteFeedback(feedbackVO) return redirect(url_for('userViewFeedback')) except Exception as ex: print(ex)
def adminReviewFeedback(): try: feedbackVO = FeedbackVO() feedbackDAO = FeedbackDAO() feedbackId = request.args.get("feedbackId") feedbackTo_LoginId = session['session_loginId'] feedbackVO.feedbackId = feedbackId feedbackVO.feedbackTo_LoginId = feedbackTo_LoginId feedbackDAO.adminReviewFeedback(feedbackVO) return redirect(url_for('adminViewFeedback')) except Exception as ex: print(ex)
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 adminUpdateFeedback(): try: if adminLoginSession() == 'admin': feedbackId = request.args.get('feedbackId') feedbackTo_LoginId = session['session_loginId'] feedbackVO = FeedbackVO() feedbackDAO = FeedbackDAO() feedbackVO.feedbackId = feedbackId feedbackVO.feedbackTo_LoginId = feedbackTo_LoginId feedbackDAO.adminUpdateFeedback(feedbackVO) return redirect(url_for('adminViewFeedback')) else: return adminLogoutSession() 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)
def userdeleteFeedback(): try: if adminLoginSession() == 'user': feedbackVO = FeedbackVO() feeedbackDAO = FeedbackDAO() feedbackId = request.args.get('feedbackId') feedbackVO.feedbackId = feedbackId print("feedbackId::", feedbackId) feeedbackDAO.deleteFeedback(feedbackVO) return redirect(url_for('userviewFeedback')) else: return adminLogoutSession() except Exception as ex: print(ex)
def ViewFeedbackReview(): try: if adminLoginSession() == "bloodbank": feedbackId = request.args.get('feedbackId') feedbackTo_LoginId = session['session_loginId'] print(feedbackId) feedbackVO = FeedbackVO() feedbackDAO = FeedbackDAO() print("####################@@@@@@@@@@@@@@@@@@@@@@@@@") feedbackVO.feedbackId = feedbackId feedbackVO.feedbackTo_LoginId = feedbackTo_LoginId print("@@@@@@@@@@@@@@@@@@@@$$$$$$$$$$$$$$$$$$$$$$$$$") feedbackDAO.viewBloodbankFeedbackReview(feedbackVO) print("^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^") return redirect(url_for('bloodbankViewUserFeedback')) else: return adminLogoutSession() except Exception as ex: print(ex)
def adminViewFeedbackReview(): try: if adminLoginSession() == "admin": feedbackId = request.args.get('feedbackId') feedbackTo_LoginId = session['session_loginId'] print(feedbackId) feedbackVO = FeedbackVO() feedbackDAO = FeedbackDAO() feedbackVO.feedbackId = feedbackId feedbackVO.feedbackTo_LoginId = feedbackTo_LoginId feedbackDAO.viewAdminFeedbackReview(feedbackVO) return redirect(url_for('adminViewFeedback')) else: return adminLogoutSession() except Exception as ex: print(ex)
def adminLoadDashboard(): try: if adminLoginSession() == 'admin': complainDAO = ComplainDAO() feedbackDAO = FeedbackDAO() registerDAO = RegisterDAO() complainVOList = complainDAO.viewComplain() totalComplainCount = len(complainVOList) feedbackVOList = feedbackDAO.adminViewFeedback() totalFeedbackCount = len(feedbackVOList) registerVOList = registerDAO.viewRegister() totalUserCount = len(registerVOList) return render_template('admin/Index.html', totalUserCount=totalUserCount, totalComplainCount=totalComplainCount, totalFeedbackCount=totalFeedbackCount) else: return adminLogoutSession() except Exception as ex: print(ex)