def adminViewPurchase(): try: if adminLoginSession() == 'admin': purchaseDAO = PurchaseDAO() purchaseVOList = purchaseDAO.viewPurchase() print("__________________", purchaseVOList) loginVO = LoginVO() loginDAO = LoginDAO() packageVO = PackageVO() packageDAO = PackageDAO() purchaseDictList = [i.as_dict() for i in purchaseVOList] print('$$$$$$$$$$$$$$$$', purchaseDictList) loginVO.loginId = purchaseDictList[0]['purchase_loginId'] packageVO.packageId = purchaseDictList[0]['purchase_packageId'] packageVOList = packageDAO.viewUserPackage(packageVO) loginVOList = loginDAO.registerLogin(loginVO) print('ok') return render_template('admin/viewPurchase.html', purchaseVOList=purchaseVOList, packageVOList=packageVOList, loginVOList=loginVOList) else: adminLogoutSession() except Exception as ex: print(ex)
def adminUpdatePurchase(): try: if adminLoginSession() == 'admin': purchaseDate = date.today() purchaseTime = datetime.now().strftime("%H:%M:%S") purchase_loginId = session['session_LoginId'] packageId = request.form['packageId'] purchaseId = request.form['purchaseId'] purchaseVO = PurchaseVO() purchaseDAO = PurchaseDAO() purchaseVO.purchaseId = purchaseId purchaseVO.purchaseDate = purchaseDate purchaseVO.purchaseTime = purchaseTime purchaseVO.purchase_loginId = purchase_loginId purchaseVO.purchase_packageId = packageId purchaseDAO.insertPurchase(purchaseVO) purchaseDAO.updatePurchase(purchaseVO) return redirect(url_for('adminViewPurchase')) else: adminLogoutSession() except Exception as ex: print(ex)
def adminInsertDataset(): try: if adminLoginSession() == 'admin': UPLOAD_FOLDER = 'project/static/adminResources/dataset/' # setting path of storage data app.config[ 'UPLOAD_FOLDER'] = UPLOAD_FOLDER # update config path of folder datasetVO = DatasetVO() datasetDAO = DatasetDAO() file = request.files['file'] # getting filename from addDataset datasetFilename = secure_filename(file.filename) datasetFilepath = os.path.join( app.config['UPLOAD_FOLDER']) # setting value in variable file.save(os.path.join(datasetFilepath, datasetFilename) ) # saving file in dataset folder with filename datasetVO.datasetFilename = datasetFilename # saving filename in database todayDate = date.today() datasetVO.uploadDate = todayDate # saving current date in database nowTime = datetime.now() datasetVO.uploadTime = nowTime.strftime( "%H:%M:%S") # saving current date in database filepath = datasetFilepath.replace("project", "..") datasetVO.datasetFilePath = str( filepath) # saving filepath in database datasetDAO.insertDataset(datasetVO) return redirect(url_for('adminViewDataset')) else: adminLogoutSession() except Exception as ex: print(ex)
def adminUpdateCamera(): try: if adminLoginSession() == 'admin': cameraId = request.form['cameraId'] cameraCode = request.form['cameraCode'] camera_AreaId = request.form['camera_AreaId'] camera_CrossroadId = request.form['camera_CrossroadId'] x1 = request.form['x1'] y1 = request.form['y1'] x2 = request.form['x2'] y2 = request.form['y2'] cameraVO = CameraVO() cameraDAO = CameraDAO() cameraVO.cameraId = cameraId cameraVO.cameraCode = cameraCode cameraVO.camera_AreaId = camera_AreaId cameraVO.camera_CrossroadId = camera_CrossroadId cameraVO.x1 = x1 cameraVO.y1 = y1 cameraVO.x2 = x2 cameraVO.y2 = y2 cameraDAO.updateCamera(cameraVO) return redirect(url_for('adminViewCamera')) else: adminLogoutSession() except Exception as ex: print(ex)
def adminInsertCamera(): try: if adminLoginSession() == 'admin': # getting data from template cameraCode = request.form['cameraCode'] camera_AreaId = request.form['camera_AreaId'] camera_CrossroadId = request.form['camera_CrossroadId'] x1 = request.form['x1'] y1 = request.form['y1'] x2 = request.form['x2'] y2 = request.form['y2'] cameraVO = CameraVO() cameraDAO = CameraDAO() # setting VO object cameraVO.cameraCode = cameraCode cameraVO.camera_AreaId = camera_AreaId cameraVO.camera_CrossroadId = camera_CrossroadId cameraVO.x1 = x1 cameraVO.y1 = y1 cameraVO.x2 = x2 cameraVO.y2 = y2 # inserting method call of cameraDAO file cameraDAO.insertCamera(cameraVO) return redirect(url_for('adminViewCamera')) else: adminLogoutSession() except Exception as ex: print(ex)
def adminEditCamera(): try: if adminLoginSession() == 'admin': cameraVO = CameraVO() cameraDAO = CameraDAO() # getting data from template cameraId cameraId = request.args.get('cameraId') cameraVO.cameraId = cameraId cameraVOList = cameraDAO.editCamera(cameraVO) # getting data of Area from database areaDAO = AreaDAO() crossroadDAO = CrossroadDAO() areaVOList = areaDAO.viewArea() crossroadVOList = crossroadDAO.viewCrossroad() return render_template('admin/editCamera.html', cameraVOList=cameraVOList, crossroadVOList=crossroadVOList, areaVOList=areaVOList) else: adminLogoutSession() except Exception as ex: print(ex)
def adminEditTrafficPoliceStation(): try: if adminLoginSession() == 'admin': trafficPoliceStationVO = TrafficPoliceStationVO() trafficPoliceStationDAO = TrafficPoliceStationDAO() loginVO = LoginVO() loginDAO = LoginDAO() areaDAO = AreaDAO() trafficPoliceStationId = request.args.get('trafficPoliceStationId') trafficPoliceStation_LoginId = request.args.get( 'trafficPoliceStation_LoginId') trafficPoliceStationVO.trafficPoliceStationId = trafficPoliceStationId loginVO.loginId = trafficPoliceStation_LoginId trafficPoliceStationVOList = trafficPoliceStationDAO.editTrafficPoliceStation( trafficPoliceStationVO) loginVOList = loginDAO.editLogin(loginVO) areaVOList = areaDAO.viewArea() return render_template( 'admin/editTrafficPoliceStation.html', trafficPoliceStationVOList=trafficPoliceStationVOList, areaVOList=areaVOList, loginVOList=loginVOList) else: adminLogoutSession() except Exception as ex: print(ex)
def adminDeleteDataset(): try: if adminLoginSession() == 'admin': datasetVO = DatasetVO() datasetDAO = DatasetDAO() datasetId = request.args.get('datasetId') datasetVO.datasetId = datasetId datasetlist = datasetDAO.deleteDataset(datasetVO) path = datasetlist.datasetFilePath.replace( '..', 'project') + datasetlist.datasetFilename try: os.remove(path) except Exception as ex: print(ex) return redirect(url_for('adminViewDataset')) else: adminLogoutSession() except Exception as ex: print(ex)
def userInsertDataset(file): try: if adminLoginSession() == 'user': datasetVO = DatasetVO() datasetDAO = DatasetDAO() file = file # getting filename from addDataset datasetFilename = secure_filename(file.filename) datasetFilepath = os.path.join( app.config['UPLOAD_FOLDER']) # setting value in variable file.save(os.path.join(datasetFilepath, datasetFilename)) datasetVO.datasetFilename = datasetFilename # saving filename in database todayDate = date.today() datasetVO.uploadDate = todayDate # saving current date in database nowTime = datetime.now() datasetVO.uploadTime = nowTime.strftime( "%H:%M:%S") # saving current date in database filepath = datasetFilepath.replace("project", "..") datasetVO.datasetFilePath = str( filepath) # saving filepath in database filepath = str(filepath) datasetDAO.insertDataset(datasetVO) return datasetFilename, filepath else: adminLogoutSession() except Exception as ex: print(ex)
def userDeleteVideo(): try: if adminLoginSession() == 'user': videoVO = VideoVO() videoDAO = VideoDAO() videoId = request.args.get('videoId') videoVO.videoId = videoId videoVOList = videoDAO.deleteVideo(videoVO) inputPath = videoVOList.inputVideoFilePath.replace( '..', 'project') + videoVOList.inputVideoFilename outputPath = videoVOList.outputVideoFilePath.replace( '..', 'project') + videoVOList.outputVideoFilename try: os.remove(inputPath) os.remove(outputPath) except Exception as ex: print(ex) return redirect(url_for('userViewVideo')) else: adminLogoutSession() except Exception as ex: print(ex)
def userLoadVideo(): try: if adminLoginSession() == 'user': videoDAO = VideoDAO() videoVOList = videoDAO.viewLocalData() purchaseVO = PurchaseVO() purchaseDAO = PurchaseDAO() purchaseVO.purchase_loginId = session['session_LoginId'] purchaseVOList = purchaseDAO.viewUserPurchase(purchaseVO) purchaseVODict = [[i[0].as_dict(), i[1].as_dict()] for i in [j for j in purchaseVOList]] purchaseDate = [i[0]['purchaseDate'] for i in purchaseVODict] if len(purchaseDate) > 0: dateMax = max(purchaseDate) index = purchaseDate.index(dateMax) purchaseDuration = purchaseVODict[index][1]['packageDuration'] purchaseDuration, _ = purchaseDuration.split(' ') currentDate = date.today() dateDifference = currentDate - dateMax if int(purchaseDuration) * 28 > int(dateDifference.days): return render_template('user/addVideo.html', videoVOList=videoVOList) else: return redirect( url_for( 'userLoadPurchase', msg= 'Current Package Is Expired, Purchase Package To Continue using System' )) 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 adminLoadPackage(): try: if adminLoginSession() == 'admin': return render_template('admin/addPackage.html') else: adminLogoutSession() except Exception as ex: print(ex)
def adminLoadCrossroad(): try: if adminLoginSession() == 'admin': areaDAO = AreaDAO() areaVOList = areaDAO.viewArea() return render_template('admin/addCrossroad.html', areaVOList=areaVOList) # ,registerVOList else: adminLogoutSession() except Exception as ex: print(ex)
def adminLoadRegister(): try: if adminLoginSession() == 'admin': areaDAO = AreaDAO() areaVOList = areaDAO.viewArea() return render_template("admin/addTrafficPoliceStation.html", areaVOList=areaVOList) else: adminLogoutSession() except Exception as ex: print(ex)
def adminViewDataset(): try: if adminLoginSession() == 'admin': datasetDAO = DatasetDAO() datasetVOList = datasetDAO.viewDataset() return render_template('admin/viewDataset.html', datasetVOList=datasetVOList) else: adminLogoutSession() except Exception as ex: print(ex)
def adminViewVideo(): try: if adminLoginSession() == 'admin': videoDAO = VideoDAO() videoVOList = videoDAO.adminViewVideo() return render_template('admin/viewVideo.html', videoVOList=videoVOList) else: adminLogoutSession() except Exception as ex: print(ex)
def adminViewCrossroad(): try: if adminLoginSession() == 'admin': crossroadDAO = CrossroadDAO() crossroadVOList = crossroadDAO.viewCrossroad() return render_template('admin/viewCrossroad.html', crossroadVOList=crossroadVOList) else: adminLogoutSession() except Exception as ex: print(ex)
def adminViewFeedback(): try: if adminLoginSession() == 'admin': feedbackDAO = FeedbackDAO() feedbackVO = FeedbackVO() feedbackVOList = feedbackDAO.adminViewFeedback() return render_template('admin/viewFeedback.html', feedbackVOList=feedbackVOList) else: adminLogoutSession() except Exception as ex: print(ex)
def adminViewCamera(): try: if adminLoginSession() == 'admin': cameraDAO = CameraDAO() cameraVOList = cameraDAO.viewCamera() return render_template('admin/viewCamera.html', cameraVOList=cameraVOList) else: adminLogoutSession() except Exception as ex: print(ex)
def adminViewPurchase(): try: if adminLoginSession() == 'admin': purchaseDAO = PurchaseDAO() purchaseVOList = purchaseDAO.adminViewPurchase() return render_template('admin/viewPurchase.html', purchaseVOList=purchaseVOList) else: adminLogoutSession() except Exception as ex: print(ex)
def adminViewArea(): try: if adminLoginSession() == 'admin': areaDAO = AreaDAO() areaVOList = areaDAO.viewArea() return render_template('admin/viewArea.html', areaVOList=areaVOList) else: adminLogoutSession() except Exception as ex: print(ex)
def adminViewPackage(): try: if adminLoginSession() == 'admin': packageDAO = PackageDAO() packageVOList = packageDAO.viewPackage() return render_template('admin/viewPackage.html', packageVOList=packageVOList) else: adminLogoutSession() except Exception as ex: print(ex)
def userLoadPurchase(): try: if adminLoginSession() == 'user': packageDAO = PackageDAO() packageVOList = packageDAO.viewPackage() return render_template('user/addPurchase.html', packageVOList=packageVOList) else: adminLogoutSession() except Exception as ex: print(ex)
def adminLoadCamera(): try: if adminLoginSession() == 'admin': areaDAO = AreaDAO() crossroadDAO = CrossroadDAO() areaVOList = areaDAO.viewArea() crossroadVOList = crossroadDAO.viewCrossroad() return render_template('admin/addCamera.html', crossroadVOList=crossroadVOList, areaVOList=areaVOList) else: adminLogoutSession() except Exception as ex: print(ex)
def userViewPurchase(): try: if adminLoginSession() == 'user': purchaseDAO = PurchaseDAO() purchaseVO = PurchaseVO() purchaseVO.purchase_loginId = session['session_LoginId'] purchaseVOList = purchaseDAO.viewUserPurchase(purchaseVO) return render_template('user/viewPurchase.html', purchaseVOList=purchaseVOList) else: adminLogoutSession() 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 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 bloodbankInsertTimeSlot(): try: if adminLoginSession() == "bloodbank": timeSlotName = request.form['timeSlotName'] timeSlot = request.form['timeSlot'] timeSlotVO = TimeSlotVO() timeSlotDAO = TimeSlotDAO() loginId = session['session_loginId'] bloodBankVOList = timeSlotDAO.searchBloodBank(loginId) bloodbankDictList = [i.as_dict() for i in bloodBankVOList] timeSlot_BloodBankId = bloodbankDictList[0]["bloodBankId"] print(timeSlot_BloodBankId) timeSlotVO.timeSlotName = timeSlotName timeSlotVO.timeSlot = timeSlot timeSlotVO.timeSlot_BloodBankId = timeSlot_BloodBankId timeSlotDAO.insertTimeSlot(timeSlotVO) return redirect(url_for('bloodBankViewTimeSlot')) 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)