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"))