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)
