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 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 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 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 allmymsg():
c, cnx = connection()
c.execute("SELECT * FROM `toadmin` ORDER BY `mid` DESC LIMIT 1000 ")
data = c.fetchall()
print(data)
session['allmymsgs'] = data
return render_template("allrecivedmsg.html")
def vae():
c, cnx = connection()
c.execute("SELECT * FROM `events` ORDER BY `eventid` DESC LIMIT 1000")
data = c.fetchall()
session['allevt'] = data
print(data)
return render_template("allevt.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 mymsg():
c, cnx = connection()
c.execute("SELECT * FROM `toadmin` WHERE `status`='unread'")
data = c.fetchall()
print(data)
session['mymsgs'] = data
return render_template("recivedmsg.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 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 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 vde():
c, cnx = connection()
c.execute(
"SELECT * FROM `events` WHERE `status`='done' ORDER BY `eventid` DESC LIMIT 1000"
)
data = c.fetchall()
session['allevt'] = data
print(data)
return render_template("vde.html")
def vca():
c, cnx = connection()
c.execute(
"SELECT * FROM `appointment` where `status`='Canceled' ORDER BY `AppointmentID` DESC LIMIT 1000"
)
data = c.fetchall()
session['canapp'] = data
print(data)
return render_template("viewcancelappoinment.html")
def vaa():
c, cnx = connection()
c.execute(
"SELECT * FROM `appointment` ORDER BY `AppointmentID` DESC LIMIT 1000"
)
data = c.fetchall()
session['allapi'] = data
print(data)
return render_template("Viewallappoinment.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 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 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 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"))
