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 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 userdeleteComplain(): try: if adminLoginSession() == 'user': complainVO = ComplainVO() complainDAO = ComplainDAO() complainId = request.args.get('complainId') complainVO.complainId = complainId complainList = complainDAO.deleteComplain(complainVO) complainFileName = complainList.complainFileName complainFilePath = complainList.complainFilePath complainFilePath = complainFilePath.replace('..', 'project') + complainFileName os.remove(complainFilePath) if complainList.replyFileName is not None: replyFilePath = complainList.replyFilePath.replace('..', 'project') + complainList.replyFileName os.remove(replyFilePath) return redirect(url_for('userviewComplain')) else: return adminLogoutSession() except Exception as ex: print(ex)
def bloodbankDeleteComplain(): try: if adminLoginSession() == "bloodbank": complainDAO = ComplainDAO() complainVO = ComplainVO() complainId = request.args.get('complainId') complainVO.complainId = complainId print(complainId) complainList = complainDAO.deleteComplain(complainVO) complainFileName = complainList.complainFileName complainFilePath = complainList.complainFilePath path = complainFilePath.replace("..", "project") + complainFileName os.remove(path) if complainList.complainStatus == 'Replied': replyFileName = complainList.replyFileName replyFilePath = complainList.replyFilePath path = replyFilePath.replace("..", "project") + replyFileName os.remove(path) return redirect(url_for('bloodbankViewComplain')) else: return adminLogoutSession() except Exception as ex: print(ex)
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 userDeleteComplain(): try: if adminLoginSession() == 'user': complainVO = ComplainVO() complainDAO = ComplainDAO() complainId = request.args.get('complainId') complainVO.complainId = complainId complainVOList = complainDAO.viewComplain(complainVO) complainDictList = [i.as_dict() for i in complainVOList] complainFilePath = complainDictList[0]['complainFilePath'] complainFilename = complainDictList[0]['complainFilename'] replyFilePath = complainDictList[0]['replyFilePath'] replyFilename = complainDictList[0]['replyFilename'] try: path = complainFilePath.replace('..', 'project') + complainFilename os.remove(path) except Exception as ex: print("complain file not deleted") try: path = replyFilePath.replace('..', 'project') + replyFilename os.remove(path) except Exception as ex: print("reply file not deleted") complainDAO.deleteComplain(complainVO) return redirect(url_for('userLoadComplain')) else: adminLogoutSession() except Exception as ex: print(ex)
def userDeleteComplain(): try: if adminLoginSession() == 'user': complainVO = ComplainVO() complainDAO = ComplainDAO() complainId = request.args.get('complainId') complainVO.complainId = complainId complainList = complainDAO.userDeleteComplain(complainVO) if complainList.complainStatus == 'Replied': replyPath = complainList.replyFilePath.replace( "..", "project") + complainList.replyFileName os.remove(replyPath) complainPath = complainList.complainFilePath.replace( "..", "project") + complainList.complainFileName os.remove(complainPath) return redirect(url_for('userViewComplain')) else: return adminLogoutSession() except Exception as ex: print(ex)
def adminViewComplain(): complainDAO = ComplainDAO() complainVO = ComplainVO() complainVO.complainTo_LoginId = session['session_LoginId'] complainVOList = complainDAO.viewAdminComplain(complainVO) return render_template('admin/viewComplain.html', complainVOList=complainVOList)
def adminDeleteComplain(): try: if adminLoginSession() == 'user': complainVO = ComplainVO() complainDAO = ComplainDAO() complainId = request.args.get('complainId') complainVO.complainId = complainId complainList = complainDAO.deleteComplain(complainVO) print(complainList) complainFileName = complainList.complainFileName complainFilePath = complainList.complainFilePath complainFullPath = complainFilePath.replace( '..', 'project') + complainFileName os.remove(complainFullPath) if complainList.complainStatus == "Replied": replyFilePath = complainList.replyFilePath replyFileName = complainList.replyFileName replyFullPath = replyFilePath.replace( "..", "project") + replyFileName os.remove(replyFullPath) return redirect(url_for('UserViewComplain')) elif adminLoginSession() == 'admin': pass except Exception as ex: print(ex)
def loadManageComplain(): if session['loginRole']!= 'admin': return redirect(url_for('login')) complainDAO = ComplainDAO() complainDict = complainDAO.searchComplain() return render_template('admin/manageComplain.html',complainDict=complainDict)
def viewUserComplain(): if session['loginRole']!= 'user': return redirect(url_for('login')) complainDAO = ComplainDAO() complainVO = ComplainVO() complainVO.complainFrom_LoginId = session['loginId'] complainDict = complainDAO.searchComplainById(complainVO) return render_template('user/viewComplain.html',complainDict=complainDict)
def loadComplainReply(): if session['loginRole']!= 'admin': return redirect(url_for('login')) complainDAO = ComplainDAO() complainVO = ComplainVO() complainVO.complainId = request.args.get('complainId') complainDict = complainDAO.editComplain(complainVO) return render_template('admin/complainReply.html',complainDict=complainDict)
def deleteComplain(): if session['loginDictrole'] == "seller": complainDAO = ComplainDAO() complainVO = ComplainVO() complainVO.complainId = request.form['complainId'] complainDAO.deleteComplain(complainVO) return redirect('/viewcomplain')
def loadReplyComplain(): if session['loginDictrole'] == 'admin': complainDAO = ComplainDAO() complainVO = ComplainVO() complainVO.complainId = str(request.args.get('complainId')) complainDict = complainDAO.searchreplycomplain(complainVO) return render_template("admin/reply.html", complainDict1=complainDict)
def adminViewComplain(): try: if adminLoginSession() == 'admin': complainVO = ComplainVO() complainDAO = ComplainDAO() complainVO.complainStatus = "pending" complainVOList = complainDAO.adminViewComplain(complainVO) return render_template('admin/viewComplain.html', complainVOList=complainVOList) else: return adminLogoutSession() except Exception as ex: print(ex)
def UserViewComplain(): try: if adminLoginSession() == 'user': complainDAO = ComplainDAO() complainVO = ComplainVO() complainVO.complainFrom_LoginId = session['session_loginId'] complainVOlist = complainDAO.userViewComplain(complainVO) return render_template('user/viewComplain.html', complainVOlist=complainVOlist) elif adminLoginSession() == 'admin': pass except Exception as ex: print(ex)
def userViewComplain(): try: if adminLoginSession() == "user": complainDAO = ComplainDAO() complainVO = ComplainVO() complainFrom_LoginId = session['session_loginId'] complainVO.complainFrom_LoginId = complainFrom_LoginId complainVOList = complainDAO.userViewComplain(complainVO) return render_template('user/viewComplain.html', complainVOList=complainVOList) else: return adminLogoutSession() except Exception as ex: print(ex)
def userLoadComplain(): try: if adminLoginSession() == 'user': complainDAO = ComplainDAO() complainVO = ComplainVO() complainVO.complainFrom_LoginId = session['session_LoginId'] complainVOList = complainDAO.viewUserComplain(complainVO) return render_template('user/addComplain.html', complainVOList=complainVOList) else: adminLogoutSession() except Exception as ex: print(ex)
def userViewComplainReplay(): try: if adminLoginSession() == "user": complainDAO = ComplainDAO() complainVO = ComplainVO() complainId = request.args.get('complainId') complainVO.complainId = complainId complainVOList = complainDAO.userViewComplainReply(complainVO) print(complainVOList) return render_template("user/viewComplainReply.html", complainVOList=complainVOList) else: return adminLogoutSession() except Exception as ex: print(ex)
def UserViewComplainReply(): try: if adminLoginSession() == 'user': complainVO = ComplainVO() complainDAO = ComplainDAO() complainId = request.args.get('complainId') complainVO.complainId = complainId # complainVO.complainFrom_LoginId = session['session_loginId'] replyVOList = complainDAO.viewComplainReply(complainVO) return render_template('user/viewComplainReply.html', replyVOList=replyVOList) elif adminLoginSession() == 'admin': pass except Exception as ex: print(ex)
def userViewReply(): try: if adminLoginSession() == 'user': complainDAO = ComplainDAO() complainVO = ComplainVO() complainId = request.args.get('complainId') complainVO.complainId = complainId replyVOList = complainDAO.viewComplain(complainVO) return render_template('user/viewReply.html', replyVOList=replyVOList) else: adminLogoutSession() except Exception as ex: print(ex)
def UserInsertComplain(): try: if adminLoginSession() == 'user': UPLOAD_FOLDER = 'project/static/adminResources/complain/' app.config['UPLOAD_FOLDER'] = UPLOAD_FOLDER complainSubject = request.form['complainSubject'] complainDescription = request.form['complainDescription'] file = request.files['complainFile'] now = datetime.now() complainDate = now.strftime("%d/%m/%Y") complainTime = now.strftime("%H:%M:%S") complainStatus = 'Pending' complainDAO = ComplainDAO() complainVO = ComplainVO() print(file) complainFileName = secure_filename(file.filename) print(complainFileName) complainFilePath = os.path.join(app.config['UPLOAD_FOLDER']) print(complainFilePath) file.save(os.path.join(complainFilePath, complainFileName)) complainVO.complainSubject = complainSubject complainVO.complainDescription = complainDescription complainVO.complainDate = complainDate complainVO.complainTime = complainTime complainVO.complainFileName = complainFileName complainVO.complainFilePath = complainFilePath.replace( "project", "..") complainVO.complainStatus = complainStatus complainVO.complainFrom_LoginId = session['session_loginId'] # print("just before insert") complainDAO.insertComplain(complainVO) return redirect(url_for('UserViewComplain')) else: return adminLogoutSession() except Exception as ex: print(ex)
def userInsertComplain(): try: if adminLoginSession() == "user": complainVO = ComplainVO() complainDAO = ComplainDAO() complainSubject = request.form['complainSubject'] complainDescription = request.form['complainDescription'] file = request.files['file'] print(file) complainFileName = secure_filename(file.filename) print(complainFileName) complainFilePath = os.path.join( app.config['UPLOAD_FOLDER_USER_COMPLAIN']) print(complainFilePath) now = datetime.now() complainDate = now.strftime("%d/%m/%Y") complainTime = now.strftime("%H:%M:%S") file.save(os.path.join(complainFilePath, complainFileName)) complainVO.complainSubject = complainSubject complainVO.complainDescription = complainDescription complainVO.complainFileName = complainFileName complainVO.complainFilePath = complainFilePath.replace( "project", "..") complainVO.complainDate = complainDate complainVO.complainTime = complainTime complainVO.complainStatus = 'Pending' complainVO.complainFrom_LoginId = session['session_loginId'] complainDAO.insertComplain(complainVO) return redirect(url_for('userLoadComplaint')) else: return adminLogoutSession() except Exception as ex: print(ex)
def adminViewComplain(): try: if adminLoginSession() == 'admin': complainDAO = ComplainDAO() complainList = complainDAO.adminViewComplain() # print("__________________", complainVOList) return render_template('admin/viewComplain.html', complainList=complainList) else: return redirect('/admin/logoutSession') except Exception as ex: print(ex)
def complainReply(): if session['loginRole'] != 'admin': return redirect(url_for('login')) complainDAO = ComplainDAO() complainVO = ComplainVO() complainVO.complainStatus = 'replied' complainVO.complainReply = request.form['complainReply'] complainVO.complainTo_LoginId = session['loginId'] complainVO.complainId = request.form['complainId'] complainDAO.updateComplain(complainVO) return redirect(url_for('loadManageComplain'))
def admininsertComplainReply(): try: if adminLoginSession() == 'admin': complainVO = ComplainVO() complainDAO = ComplainDAO() complainId = request.form['complainId'] replySubject = request.form['replySubject'] replyMessage = request.form['replyMessage'] complainStatus = 'REPLIED' complainTo_LoginId = session['session_loginId'] file = request.files['reply'] print(file) replyFileName = secure_filename(file.filename) print(replyFileName) replyFilePath = os.path.join(app.config['UPLOAD_FOLDER_REPLY']) print(replyFilePath) file.save(os.path.join(replyFilePath, replyFileName)) replyDate = datetime.date(datetime.now()) replyTime = datetime.time(datetime.now()) complainVO.complainId = complainId complainVO.replySubject = replySubject complainVO.replyMessage = replyMessage complainVO.replyFileName = replyFileName complainVO.replyFilePath = replyFilePath.replace("project", "..") complainVO.complainStatus = complainStatus complainVO.replyDate = replyDate complainVO.replyTime = replyTime complainVO.complainTo_LoginId = complainTo_LoginId complainDAO.insertComplainReply_Admin(complainVO) return redirect(url_for('adminviewComplain')) else: return adminLogoutSession() except Exception as ex: print(ex)
def insertComplain(): if session['loginRole'] != 'user': return redirect(url_for('login')) complainDAO = ComplainDAO() complainVO = ComplainVO() complainVO.complainSubject = request.form['complainSubject'] complainVO.complainDescription = request.form['complainDescription'] complainVO.complainDate, complainVO.complainTime = str(datetime.now()).split(' ') complainVO.complainStatus = 'pending' complainVO.complainActiveStatus = 'active' complainVO.complainFrom_LoginId = session['loginId'] complainDAO.insertComplain(complainVO) return redirect(url_for('complain'))
def userViewComplainReply(): try: if adminLoginSession() == 'user': complainVO = ComplainVO() complainDAO = ComplainDAO() complainId = request.args.get("complainId") complainVO.complainId = complainId complainReplyList = complainDAO.viewComplainReply(complainVO) return render_template("user/viewComplainReply.html", complainReplyList=complainReplyList) else: return redirect('/admin/logoutSession') except Exception as ex: print(ex)
def adminInsertComplainReply(): try: if adminLoginSession() == 'admin': UPLOAD_FOLDER = 'project/static/adminResources/complainReply/' app.config['UPLOAD_FOLDER'] = UPLOAD_FOLDER complainId = request.form['complainId'] replySubject = request.form['replySubject'] replyMessage = request.form['replyMessage'] file = request.files['replyFile'] now = datetime.now() replyDate = now.strftime("%d/%m/%Y") replyTime = now.strftime("%H:%M:%S") complainDAO = ComplainDAO() complainVO = ComplainVO() print(file) replyFileName = secure_filename(file.filename) print(replyFileName) replyFilePath = os.path.join(app.config['UPLOAD_FOLDER']) print(replyFilePath) file.save(os.path.join(replyFilePath, replyFileName)) complainVO.complainId = complainId complainVO.replySubject = replySubject complainVO.replyMessage = replyMessage complainVO.replyDate = replyDate complainVO.replyTime = replyTime complainVO.replyFileName = replyFileName complainVO.replyFilePath = replyFilePath.replace("project", "..") complainVO.complainStatus = "Replied" print("just before admin's complain reply insert") complainDAO.adminInsertComplain(complainVO) return redirect(url_for('adminViewComplain')) elif adminLoginSession() == 'user': pass except Exception as ex: print(ex)
def userinsertComplain(): try: if adminLoginSession() == 'user': complainVO = ComplainVO() complainDAO = ComplainDAO() complainSubject = request.form['complainSubject'] complainDescription = request.form['complainDescription'] complainFrom_LoginId = session['session_loginId'] file = request.files['file'] print(file) complainFileName = secure_filename(file.filename) print(complainFileName) complainFilePath = os.path.join(app.config['UPLOAD_FOLDER_COMPLAIN']) print(complainFilePath) file.save(os.path.join(complainFilePath, complainFileName)) complainDate = datetime.date(datetime.now()) complainTime = datetime.time(datetime.now()) complainStatus = 'PENDING' complainVO.complainSubject = complainSubject complainVO.complainDescription = complainDescription complainVO.complainDate = complainDate complainVO.complainTime = complainTime complainVO.complainStatus = complainStatus complainVO.complainFileName = complainFileName complainVO.complainFilePath = complainFilePath.replace("project", "..") complainVO.complainFrom_LoginId = complainFrom_LoginId complainDAO.insertComplain(complainVO) return redirect(url_for('userviewComplain')) else: return adminLogoutSession() except Exception as ex: print(ex)