def apmng(): c, cnx = connection() c.execute("SELECT `email` FROM `admin` WHERE `Role`='Doctor'") data = c.fetchall() print(data) session['docemail'] = data c, cnx = connection() c.execute("SELECT `petID` FROM `pets` WHERE`ownerEmail`=%s", (thawrt(session['uemail']), )) data1 = c.fetchall() session['petid'] = data1 if request.method == 'POST': apid = request.form['evtid'] session['apidss'] = apid c, cnx = connection() c.execute("SELECT * FROM `appointment` WHERE `AppointmentID`=%s", (thawrt(apid), )) data = c.fetchall() print(data) session['ap'] = data for row in data: session['apr'] = row[1] session['appetid'] = row[2] session['appetname'] = row[3] session['apdoc'] = row[4] session['apmsg'] = row[5] session['apdate'] = row[8] return render_template("apm.html")
def searchnow(): if request.method == 'POST': so = request.form['optradio'] search = request.form['search'] print(search) if so: # usermail c, cnx = connection() c.execute("SELECT * FROM `pets` WHERE `ownerEmail`=%s", (thawrt(search), )) data = c.fetchall() session['allpet'] = data return render_template("searchresult.html") else: # petid c, cnx = connection() c.execute("SELECT * FROM `pets` WHERE `petID`=%s", (thawrt(search), )) data = c.fetchall() session['allpet'] = data return render_template("searchresult.html") return redirect(url_for("searchpet"))
def mymsgfunc(): if request.method == 'POST': msgid = request.form['msgid'] print(msgid) c, cnx = connection() status = "Readed" # print(email) c.execute("UPDATE `toadmin` SET `status`=%s WHERE `mid`=%s", (thawrt(status), thawrt(msgid))) cnx.commit() flash("Done..!") return redirect(url_for("admindash")) return redirect(url_for("admindash"))
def apauth(): if request.method == 'POST': reason = request.form['name'] docmail = request.form['docid'] petid = request.form['petid'] petname = request.form['petname'] today = request.form['date'] message = request.form['message'] frommail = session['uemail'] sts = "on" c, cnx = connection() c.execute( "INSERT INTO `appointment`( `AppointmentReason`, `PetID`, `Petname`, `Doctor Mail`, `message`, `status`, `from`, `date`) VALUES (%s,%s,%s,%s,%s,%s,%s,%s)", (thawrt(reason), thawrt(petid), thawrt(petname), thawrt(docmail), thawrt(message), thawrt(sts), thawrt(frommail), thawrt(today))) cnx.commit() flash("New Appointment Created!") cnx.close c.close() gc.collect() return redirect(url_for("dash"))
def donejob(): if request.method == 'POST': eventid = request.form['evtid'] print(eventid) c, cnx = connection() status = "done" # print(email) c.execute( "UPDATE `appointment` SET `status`=%s WHERE `AppointmentID`=%s", (thawrt(status), thawrt(eventid))) cnx.commit() flash("Done..!") return redirect(url_for("admindash")) return redirect(url_for("admindash"))
def startupdate(): try: if request.method == "POST": updatepetid = request.form['petid'] if updatepetid == 'Select Pet ID': flash("Please Select a Valid Pet ID") return redirect(url_for("update")) else: c, cnx = connection() c.execute("SELECT * FROM `pets` WHERE `petID`=%s", (thawrt(updatepetid), )) data = c.fetchall() session['uppet'] = data session['oids'] = updatepetid print(updatepetid) return redirect(url_for("updateauth")) else: flash("Please Select a Valid Pet ID") return redirect(url_for("update")) except Exception as e: print(e) return redirect(url_for("update"))
def cp(): try: if request.method == "POST": image = request.files.getlist("pic") target = os.path.join(APP_ROOT, 'static/petpics') capname = now.strftime("%Y-%m-%d %H-%M") email = session['uemail'] if image == []: flash("please selct a image") else: if not os.path.isdir(target): os.mkdir(target) for file in request.files.getlist("pic"): print(file) filename = file.filename print(filename) destination = "/".join([target, filename]) # print(destination) file.save(destination) newfile = 'static/userpics/' + capname + filename newfilename = capname + filename os.rename(destination, newfile) # flash("Sucess") c, cnx = connection() # print(email) c.execute( "UPDATE `customers` SET `image`=%s WHERE `Email`=%s", (thawrt(newfilename), thawrt(email))) cnx.commit() flash("Registration successful..!") os.remove('static/userpics/' + session['profic']) session['profic'] = newfilename cnx.close c.close() return redirect(url_for("dash")) except Exception as e: print(e) flash("Upload Failed") return redirect(url_for("propic"))
def dash(): c, cnx = connection() c.execute( "SELECT COUNT(*) FROM message WHERE `REmail`=%s and `Status`='unread'", (thawrt(session['uemail']), )) rows = c.fetchone()[0] session['messages'] = rows return render_template("dashboard.html")
def delpet(): owneremail = session['uemail'] c, cnx = connection() c.execute("SELECT * FROM `pets` WHERE `ownerEmail`=%s", (thawrt(owneremail), )) data = c.fetchall() session['cat'] = data return render_template("deletepet.html")
def deluserad(): sts = "normal" c, cnx = connection() c.execute("SELECT * FROM `admin` WHERE `status`=%s", (thawrt(sts), )) data = c.fetchall() print(data) session['users'] = data return render_template("deluserad.html")
def delconf(): if request.method == 'POST': petidfordelete = request.form['petid'] c, cnx = connection() c.execute("DELETE FROM `pets` WHERE `petID`=%s", (thawrt(petidfordelete), )) cnx.commit() flash("Record has been Successfully deleted..!") return redirect(url_for("delpet"))
def update(): owneremail = session['uemail'] c, cnx = connection() c.execute("SELECT * FROM `pets` WHERE `ownerEmail`=%s", (thawrt(owneremail), )) petsid = c.fetchall() session['tempid'] = petsid return render_template("updatefront.html")
def viewmsg(): owneremail = session['uemail'] c, cnx = connection() c.execute( "SELECT * FROM `message` WHERE `REmail`=%s ORDER BY `MessageId` DESC LIMIT 25", (thawrt(owneremail), )) data = c.fetchall() session['mat'] = data return render_template("Viewmsg.html")
def ma(): c, cnx = connection() c.execute("SELECT * FROM `appointment` WHERE `from`=%s and `status`='on'", (thawrt(session['uemail']), )) data = c.fetchall() print(data) session['ap'] = data return render_template("Apoinmentmng.html")
def mngfunc(): if request.method == 'POST': if request.form['submit'] == 'btn1': print("1") evtname = request.form['name'] evtdate = request.form['edate'] evttime = request.form['etime'] evtdes = request.form['ta1'] evtven = request.form['v'] c, cnx = connection() # print(email) c.execute( "UPDATE `events` SET `eventname`=%s,`eventdate`=%s,`eventtime`=%s,`eventdes`=%s,`venue`=%s WHERE `eventid`=%s", (thawrt(evtname), thawrt(evtdate), thawrt(evttime), thawrt(evtdes), thawrt(evtven), thawrt(session['eids']))) cnx.commit() flash("Event Updated..!") return redirect(url_for("admindash")) # --------------------------------------Update event------------------------------- if request.form['submit'] == 'btn2': print("2") c, cnx = connection() c.execute("DELETE FROM `events` WHERE `eventid`=%s", (thawrt(session['eids']), )) cnx.commit() flash("Record has been Successfully deleted..!") return redirect(url_for("admindash")) # ---------------------------------Delete Event---------------------------------------- if request.form['submit'] == 'btn3': print("3") de = "done" c, cnx = connection() # print(email) c.execute("UPDATE `events` SET `status`=%s WHERE `eventid`=%s", (thawrt(de), thawrt(session['eids']))) cnx.commit() flash("Good Job..!") return redirect(url_for("admindash")) # ---------------------------------------------Event Done---------------------------------- return redirect(url_for("admindash"))
def obox(): c, cnx = connection() c.execute( "SELECT * FROM `message` WHERE `FromMail`=%s ORDER BY `MessageId` DESC LIMIT 1000", (thawrt(session['uemail']), )) data = c.fetchall() session['allevt'] = data print(data) return render_template("obox.html")
def loginauth(): print("okk") try: print("2") if request.method == "POST": print("3") email = request.form['email'] c, cnx = connection() c.execute( "SELECT `FirstName`, `LastName`, `Email`, `dateofbirth`, `password`,`image` FROM `customers` WHERE `Email`=%s", (thawrt(email), )) data = c.fetchall() print(data) for row in data: fname = row[0] lname = row[1] usermail = row[2] userdob = row[3] passw = row[4] userpic = row[5] print(fname) if sha256_crypt.verify(request.form['pass'], passw): print(request.form['pass']) session['logged'] = True session['firstname'] = fname session['lastname'] = lname session['uemail'] = usermail session['udob'] = userdob session['userpass'] = passw session['profic'] = userpic print(userpic) flash("you are now Logged in...!") return redirect(url_for('dash')) else: flash("Invalid credential, Plz try again..!") gc.collect() return redirect(url_for("login")) return redirect(url_for("login")) except Exception as e: print(e) flash("Login Error..! plz contact the Hash's Pet care Center...") return redirect(url_for("login"))
def adminlogincheck(): try: if request.method == "POST": email = request.form['email'] c, cnx = connection() c.execute("SELECT * FROM `admin` WHERE `email`=%s", (thawrt(email), )) data = c.fetchall() print(data) for row in data: myemail = row[1] fname = row[2] lname = row[3] Role = row[4] mobile = row[5] mypic = row[6] sts = row[7] passw = row[8] print(sts) if sha256_crypt.verify(request.form['pass'], passw): print(request.form['pass']) session['logged'] = True session['firstname'] = fname session['lastname'] = lname session['uemail'] = myemail session['myrole'] = Role session['mymobile'] = mobile session['mypic'] = mypic session['sts'] = sts session['passwordmy'] = passw flash("you are now Logged in...!") return redirect(url_for('admindash')) else: flash("Invalid credential, Plz try again..!") gc.collect() return redirect(url_for("admin")) return redirect(url_for("admin")) except Exception as e: print(e) flash("Login Error..! plz contact the Hash's Pet care Center...") return redirect(url_for("admin"))
def changemypass(): try: if request.method == "POST": password = request.form['pword'] newpassword = request.form['cpword'] Truepassword = sha256_crypt.encrypt((str(newpassword))) if sha256_crypt.verify(password, session['passwordmy']): c, cnx = connection() # print(email) c.execute("UPDATE `admin` SET `password`=%s WHERE `email`=%s", (thawrt(Truepassword), thawrt(session['uemail']))) cnx.commit() flash("Password Has changed successfully..!") return redirect(url_for("admindash")) else: flash("Current Passowrd is wrong..!") except Exception as e: print(e) return redirect(url_for("changeadp")) flash("Save Failled..")
def uob(): frommail = session['uemail'] c, cnx = connection() c.execute( "SELECT * FROM `toadmin` WHERE `frommail`=%s ORDER BY `mid` DESC LIMIT 1000 ", (thawrt(frommail), )) data = c.fetchall() session['uobs'] = data print(data) return render_template("userobox.html")
def deladconf(): if request.method == 'POST': userid = request.form['uid'] if userid == "Select User ID": flash("Please Select User ID") else: c, cnx = connection() c.execute("DELETE FROM `admin` WHERE`id`=%s", (thawrt(userid), )) cnx.commit() flash("Record has been Successfully deleted..!") return redirect(url_for("deluserad"))
def cna(): c, cnx = connection() c.execute("SELECT `email` FROM `admin` WHERE `Role`='Doctor'") data = c.fetchall() print(data) session['docemail'] = data c, cnx = connection() c.execute("SELECT `petID` FROM `pets` WHERE`ownerEmail`=%s", (thawrt(session['uemail']), )) data1 = c.fetchall() session['petid'] = data1 return render_template("ap.html")
def authsendmsg(): if request.method == 'POST': toname = request.form['name'] toemail = request.form['email'] petid = request.form['petid'] petname = request.form['petname'] today = request.form['date'] message = request.form['message'] frommail = session['uemail'] sts = "unread" c, cnx = connection() c.execute( "INSERT INTO `message`( `FromMail`, `REmail`, `Message`, `Status`, `date`, `petid`, `petname`, `OwnerName`) VALUES (%s,%s,%s,%s,%s,%s,%s,%s)", (thawrt(frommail), thawrt(toemail), thawrt(message), thawrt(sts), thawrt(today), thawrt(petid), thawrt(petname), thawrt(toname))) cnx.commit() flash("Mesage Sent!") smtp_ssl_host = 'smtp.gmail.com' # smtp.mail.yahoo.com smtp_ssl_port = 465 username = "******" password = "******" sender = "*****@*****.**" targets = ["*****@*****.**", toemail] msg = MIMEText("Hi Mr. " + toname + "." + "about your pet " + petname + "." + message) msg['Subject'] = 'Pet Alert' msg['From'] = sender msg['To'] = ', '.join(targets) server = smtplib.SMTP_SSL(smtp_ssl_host, smtp_ssl_port) server.login(username, password) server.sendmail(sender, targets, msg.as_string()) server.quit() cnx.close c.close() gc.collect() print(toname, toemail, today, petid, petname, message) return redirect(url_for("admindash"))
def apmauth(): if request.method == 'POST': reason = request.form['name'] docmail = request.form['docid'] petid = request.form['petid'] petname = request.form['petname'] today = request.form['date'] message = request.form['message'] if request.form['submit'] == 'btn1': c, cnx = connection() # print(email) c.execute( "UPDATE `appointment` SET `AppointmentReason`=%s,`PetID`=%s,`Petname`=%s,`Doctor Mail`=%s,`message`=%s,`date`=%s WHERE `from`=%s", (thawrt(reason), thawrt(petid), thawrt(petname), thawrt(docmail), thawrt(message), thawrt(today), thawrt(session['uemail']))) cnx.commit() flash("Appointment Updated..!") return redirect(url_for("dash")) # -----------------------------------------------------------------Cancel Appoinment----------------------- if request.form['submit'] == 'btn2': c, cnx = connection() stss = "Canceled " # print(email) c.execute( "UPDATE `appointment` SET `status`=%s WHERE `AppointmentID`=%s", ( thawrt(stss), thawrt(session['apidss']), )) cnx.commit() flash("Appointment Canceled..!") return redirect(url_for("dash")) return redirect(url_for("apmng"))
def selectmng(): if request.method == 'POST': eventid = request.form['evtid'] session['eids'] = eventid if eventid == 'Select Event ID': flash("Please Select a Event ID") return redirect(url_for("mngevt")) else: c, cnx = connection() c.execute("SELECT * FROM `events` WHERE `eventid`=%s", (thawrt(eventid), )) data = c.fetchall() for row in data: session['selevtname'] = row[1] session['seldate'] = row[2] session['seltime'] = row[3] session['seldes'] = row[4] session['selv'] = row[5] return render_template("Mangeeventsmain.html")
def addevt(): if request.method == 'POST': evtname = request.form['name'] evtdate = request.form['edate'] evttime = request.form['etime'] evtdes = request.form['ta1'] evtven = request.form['v'] sts = "open" c, cnx = connection() c.execute( "INSERT INTO `events`( `eventname`, `eventdate`, `eventtime`, `eventdes`, `venue`, `status`) VALUES (%s,%s,%s,%s,%s,%s)", (thawrt(evtname), thawrt(evtdate), thawrt(evttime), thawrt(evtdes), thawrt(evtven), thawrt(sts))) cnx.commit() flash("New Event Added") cnx.close c.close() gc.collect() return redirect(url_for("admindash"))
def sendmfunc(): if request.method == 'POST': frommail = session['uemail'] subject = request.form['name'] tomail = request.form['email'] msg = request.form['message'] dnt = now.strftime("%Y-%m-%d %H-%M -%p") stss = "unread" # print(subject,tomail,msg) c, cnx = connection() c.execute( "INSERT INTO `toadmin`( `frommail`, `tomail`, `message`, `status`, `dateandtime`,`subject`) VALUES (%s,%s,%s,%s,%s,%s)", (thawrt(frommail), thawrt(tomail), thawrt(msg), thawrt(stss), thawrt(dnt), thawrt(subject))) cnx.commit() flash("Message Sent!") cnx.close c.close() gc.collect() return redirect(url_for("dash"))
def updateconfirm(): try: if request.method == "POST": petname = request.form['petname'] pettype = request.form['type'] petbreed = request.form['Bread'] petcolor = request.form['color'] petgender = request.form['gender'] petage = request.form['age'] petbday = request.form['dob'] image = request.files.getlist("pic") target = os.path.join(APP_ROOT, 'static/petpics') capname = now.strftime("%Y-%m-%d %H-%M") updateid = session['oids'] if petgender == "Gender" or petgender == None: flash("Please Select Pet Gender...") if petage == "Age" or petage == None: flash("Please Select Pet Age...") if image == []: flash("please selct a image") else: if not os.path.isdir(target): os.mkdir(target) for file in request.files.getlist("pic"): # print(file) filename = file.filename # print(filename) destination = "/".join([target, filename]) # print(destination) file.save(destination) newfile = 'static/petpics/' + capname + filename newfilename = capname + filename os.rename(destination, newfile) # flash("Sucess") c, cnx = connection() print(updateid) c.execute( "UPDATE `pets` SET `petsname`=%s,`Breed`=%s,`type`=%s,`furColor`=%s,`gender`=%s,`Age`=%s,`dob`=%s,`image`=%s WHERE `petID`=%s", (thawrt(petname), thawrt(petbreed), thawrt(pettype), thawrt(petcolor), thawrt(petgender), thawrt(petage), thawrt(petbday), thawrt(newfilename), thawrt(updateid))) cnx.commit() flash("Registration successful..!") cnx.close c.close() return redirect(url_for("view")) except Exception as e: print(e) flash("Update were not succesfull...") os.remove(newfile) return redirect(url_for("update"))
def regdata(): try: if request.method == "POST": fullname = request.form['name'] lastname = request.form['lname'] username = request.form['email'] dateofbirth = request.form['dob'] password = request.form['pword'] confirmpassword = request.form['cpword'] Truepassword = sha256_crypt.encrypt((str(password))) if password == confirmpassword: c, cnx = connection() c.execute("SELECT `Email` FROM `customers` WHERE `Email`=%s", (thawrt(username), )) rows = c.fetchone() print(rows) if rows is 0 or rows is None: # -------------------------------------------------------------- image upload imgfile = request.files.getlist("file") # print(imgfile) capname = now.strftime("%Y-%m-%d %H-%M") target = os.path.join(APP_ROOT, 'static/userpics') # print(target) if imgfile == []: flash("please selct a image") else: if not os.path.isdir(target): os.mkdir(target) for file in request.files.getlist("file"): # print(file) filename = file.filename # print(filename) destination = "/".join([target, filename]) # print(destination) file.save(destination) newfile = 'static/userpics/' + capname + filename newfilename = capname + filename os.rename(destination, newfile) # flash("Sucess") c.execute( "INSERT INTO `customers`(`FirstName`, `LastName`, `Email`, `dateofbirth`, `password`, `image`) VALUES (%s,%s,%s,%s,%s,%s)", (thawrt(fullname), thawrt(lastname), thawrt(username), thawrt(dateofbirth), thawrt(Truepassword), thawrt(newfilename))) cnx.commit() flash("Registration successful..!") cnx.close c.close() gc.collect() session['logged'] = True session['uname'] = username return redirect(url_for('umain')) else: flash( "The email already Registered, please try another email..!" ) else: flash("Passowrd You Entered doesnt match..!") else: print("error") except Exception as e: print(e) return redirect(url_for("register"))
def adloginauth(): try: if request.method == "POST": usermail = request.form['email'] firstname = request.form['fname'] lastname = request.form['lname'] usermobile = request.form['mobile'] sts = "normal" userrole = request.form['role'] userpass1 = request.form['pass'] userpass2 = request.form['pass2'] print(usermail, firstname, lastname, usermobile, userrole, userpass1, userpass2) if userrole == 'User Role': flash("Please Select your Role here") Truepassword = sha256_crypt.encrypt((str(userpass1))) if userpass1 == userpass2: c, cnx = connection() c.execute("SELECT * FROM `admin` WHERE `email`=%s", (thawrt(usermail), )) rows = c.fetchone() print(rows) if rows is 0 or rows is None: # -------------------------------------------------------------- image upload imgfile = request.files.getlist("pic") print(imgfile) capname = now.strftime("%Y-%m-%d %H-%M") target = os.path.join(APP_ROOT, 'static/staff') print(target) if imgfile == []: flash("please selct a image") else: if not os.path.isdir(target): os.mkdir(target) for file in request.files.getlist("pic"): print(file) filename = file.filename print(filename) destination = "/".join([target, filename]) print(destination) file.save(destination) newfile = 'static/staff/' + capname + filename newfilename = capname + filename os.rename(destination, newfile) # flash("Sucess") c.execute( "INSERT INTO `admin`( `email`, `FirstName`, `LastName`, `Role`, `Mobile`, `pic`,`status`, `password`) VALUES (%s,%s,%s,%s,%s,%s,%s,%s)", (thawrt(usermail), thawrt(firstname), thawrt(lastname), thawrt(userrole), thawrt(usermobile), thawrt(newfilename), thawrt(sts), thawrt(Truepassword))) cnx.commit() flash("Registration successful..!") cnx.close c.close() gc.collect() session['logged'] = True session['uname'] = usermail return redirect(url_for('admindash')) else: flash( "The email already Registered, please try another email..!" ) else: flash("Passowrd You Entered doesnt match..!") else: print("error") except Exception as e: print(e) return redirect(url_for("reguser"))