def view_table():
d = Db()
qry = "SELECT * FROM table_hotel where table_hotel.status='pending'"
print(qry)
res = d.select(qry)
print(res)
return jsonify(status='ok', data=res)
def addservice1():
service = request.form['txt_service']
description = request.form['txt_service1']
db = Db()
db.insert("insert into service VALUES ('','" + service + "','1','" +
description + "')")
return '<script>alert("Service added");window.location="/addservice"</script>'
def adm_edit_add_table():
db = Db()
y = session['rid']
tabnum = request.form['textfield']
charge = request.form['textfield1']
qry = "select * from table_hotel where table_num='" + tabnum + "' and table_hotel_id!='" + str(
y) + "'"
res = db.select(qry)
print(res)
if len(res) > 0:
return 'Table Number Already Existing'
else:
qry = "update table_hotel set table_num='" + tabnum + "',charge='" + charge + "' "
if request.files is not None:
if 'filefield' in request.files:
img = request.files['filefield']
if img.filename != "":
img.save(static_path + "Table\\" + img.filename)
path = "/static/Table/" + img.filename
qry = qry + ",picture='" + path + "'"
else:
return 'no'
qry = qry + " where table_hotel_id='" + str(y) + "'"
res = db.update(qry)
return adm_view_tables()
def view_vehicle():
d = Db()
qry = "SELECT `vehicle`.*,`staff`.* FROM `vehicle`,`staff` WHERE `vehicle`.`tid`=`staff`.`login_id` and vehicle.status='yes'"
print(qry)
res = d.select(qry)
print(res)
return jsonify(status='ok', data=res)
def adm_edit_table(id):
db = Db()
qry = "select * from table_hotel where table_hotel_id='" + id + "'"
res = db.selectOne(qry)
print(res)
session['rid'] = id
return render_template("Admin/edit add table.html", data=res)
def login_page():
db = Db()
username = request.form['username']
password = request.form['password']
type = ""
qr = "select * from login where username='******' and password='******'"
res = db.selectOne(qr)
if res is not None:
type = res['type']
session['id'] = res['login_id']
session['typeu'] = res['type']
if type == "admin":
return redirect('/adm_Homepage')
elif type == "manager":
return redirect('/ManagerHomepage')
elif type == "waitor":
return redirect('/WaitorHomepage')
elif type == "transport":
return redirect('/TransportHomepage')
elif type == "billing":
return redirect('/BillingHomepage')
else:
return "Invalid Username or Password"
else:
return "Invalid Username or Password"
def adm_edit_staff(fid):
session['rid'] = fid
qr = "select * from staff where staff_id='" + str(session['rid']) + "'"
db = Db()
res = db.selectOne(qr)
return render_template("Admin/edit staff.html", values=res)
def addworker1():
name = request.form['txt_name']
dob = request.form['txt_dob']
mobile = request.form['txt_mobile']
adhar = request.form['txt_adhar']
email = request.form['txt_email']
house = request.form['txt_house']
place = request.form['txt_place']
post = request.form['txt_post']
pin = request.form['txt_pin']
photo = request.files['photo']
date = datetime.datetime.now().strftime("%y%m%d-%H%M%S")
photo.save(path + date + ".jpg")
wages = request.form['wages']
pth = "/static/photos/" + date + ".jpg"
db = Db()
pwd = random.randint(0000, 9999)
qry = db.insert("insert into login VALUES('','" + email + "','" +
str(pwd) + "','worker')")
db.insert("insert into worker VALUES ('" + str(qry) + "','" + name +
"','" + dob + "','" + mobile + "','" + adhar + "','" + email +
"','" + house + "','" + place + "','" + post + "','" + pin +
"','" + pth + "','" + wages + "')")
return '<script>alert("inserted successfully");window.location="/addworker"</script>'
def channel_add_post():
channel = request.form['ch_name']
channel_type = request.form['t']
db = Db()
query = db.insert("insert into channel VALUES ('','" + channel + "','" +
channel_type + "')")
return '<script>alert("success");window.location="/add_channel"</script>'
def view_cat():
d = Db()
qry = "SELECT * FROM category"
print(qry)
res = d.select(qry)
print(res)
return jsonify(status='ok', category=res)
def view_food_all():
d = Db()
qry = "SELECT `food_items`.*,`category`.* FROM `food_items`,`category` WHERE `food_items`.`category_id`=`category`.`category_id` "
print(qry)
res = d.select(qry)
print(res)
return jsonify(status='ok', food=res)
def adm_noty_post():
obj1=Db()
Notification=request.form['fb']
qry= "insert into notification values(null,'"+Notification+"',CURDATE()) "
obj1.insert(qry)
return ''' <script> alert('send succesfully');window.location="/adm_vnoti"; </script> '''
def Admin_reply_post():
cid=request.form["cid"]
reply=request.form ["textarea"]
db=Db()
qry="update complaint set C_reply='"+reply+"' where C_id='"+cid+"'"
res = db.update(qry)
return admin_view_complaint()
def dr_register():
name=request.form["textfield"]
Dob=request.form["textfield2"]
gender=request.form["Gender"]
email=request.form["textfield3"]
experince=request.form["textfield4"]
image=request.files["fileField"]
phone=request.form["textfield5"]
area_of_spec=request.form["textfield6"]
state=request.form["state"]
district=request.form["select2"]
place=request.form["textfield7"]
pin=request.form["textfield8"]
password=request.form["password"]
latitude=request.form["lat"]
longitude=request.form["lon"]
db=Db()
image.save("C:\\Users\\Hridhin\\PycharmProjects\\smpl\\static\\doctor\\"+image.filename)
path='/static/doctor/'+image.filename
QRY="insert into login (Login_type,Login_Name,Password) values ('pending','"+email+"','"+password+"')"
lid=str(db.insert(QRY))
qry2="insert into doctor(Doc_name,Doc_dob,Doc_gender,Doc_email,Doc_phone,Doc_area_of_spec,Doc_state,Doc_district,Doc_place,Doc_pin,Doc_lat,Doc_log,Doc_Experince,Doc_login_id,Doc_img)values('"+name+"','"+Dob+"','"+gender+"','"+email+"','"+phone+"','"+area_of_spec+"','"+state+"','"+district+"','"+place+"','"+pin+"','"+latitude+"','"+longitude+"','"+experince+"','"+lid+"','"+str(path)+"')"
print(qry2)
res=db.insert(qry2)
return render_template('/LOGIN.html')
def reply():
c = Db()
response = request.form['textfield']
q = "update complaint set response='" + response + "' where cmpid='" + session[
"id"] + "'"
r = c.update(q)
return adm_cmplnt()
def adm_vuser():
if session['lin'] == "lin":
obj = Db()
qry = "select * from user"
res = obj.select(qry)
return render_template("admin/viewuser.html", data=res)
else:
return render_template("login.html")
def adm_vfbk():
if session['lin'] == "lin":
obj = Db()
qry = "select user.fname,user.email,feedback.feedback,feedback.create_at from user,feedback where feedback.user_id=user.login_id"
res = obj.select(qry)
return render_template("admin/viewfeedbk.html",data=res)
else:
return render_template("login.html")
def doctor_add_presciption_post():
db=Db()
ulid=request.form["ulid"]
pres=request.form["view_prescription"]
dr_lid =session["lid"]
qry ="insert into prescription(U_id,prescription,Doc_id,pres_date,pres_time) values ('"+ulid+"','"+pres+"','"+dr_lid+"',curdate(),curtime())"
res = db.insert(qry)
return render_template("doctor/View_prescription.html")
def fd():
c = Db()
x = session["userid"]
feedback = request.form['textfield']
q = "insert into feedback (flid,feedback,fdate) values('" + str(
x) + "','" + feedback + "',curdate())"
r = c.insert(q)
return '''<script>alert('Thank you for the feedback!!!');window.location='/user_feed';</script>'''
def cmplnt():
c = Db()
x = session["userid"]
complaint = request.form['textfield2']
q = "insert into complaint (clid,complaint,response,cdate) values('" + str(
x) + "','" + complaint + "','pending',curdate())"
r = c.insert(q)
return '''<script>alert('Your complaint placed successfully');window.location='/user_newcmplnt';</script>'''
def adm_feed():
c = Db()
if session["userid"] != None:
qry = "select feedback.*,user.* from user,feedback where user.loginid=feedback.flid"
rslt = c.select(qry)
return render_template('admin/adminFeedback.html', feeds=rslt)
else:
return render_template('form.html')
def d_history(id):
if session['lin'] == "lin":
obj1=Db()
qry1="delete from song where song_id='"+id+"'"
obj1.delete(qry1)
return user_history()
else:
return render_template("login.html")
def delt_user(id):
if session['lin'] == "lin":
obj = Db()
qry = "delete from user where user_id='" + id + "'"
obj.delete(qry)
return adm_vuser()
else:
return render_template("login.html")
def workallocate_cashcollector2(i):
area = request.form['t']
db = Db()
qry = db.insert("insert into cashcollector_work VALUES ('','" + area +
"','" + i + "',curdate())")
return '<script>alert("Updated Successfully");window.location="/view_work_allocated"</script>'
def view_assign_work():
db = Db()
id = session['lid']
# print(str(id)+"=================")
qry = "select * from workassign,work where workassign.emp_id='" + str(
id) + "' AND work.workid=workassign.workid"
res = db.select(qry)
return render_template("employee/view_assign_work.html", data=res)
def addrawmaterial1():
rawname = request.form['raw_name']
rawquantity = request.form['raw_quantity']
descr = request.form['description']
db1 = Db()
db1.insert("insert into rawmaterial VALUES ('','" + rawname + "','" +
rawquantity + "','" + descr + "')")
return '<script>alert("inserted...."); window.location="/addrawmaterial"</script>'
def adm_vcomt():
if session['lin']=="lin":
obj=Db()
qry="select user.fname,user.email,complaint.* from user ,complaint where complaint.user_id=user.login_id"
res=obj.select(qry)
return render_template("admin/viewcomplaint.html",data=res)
else:
return render_template("login.html")
def adm_users():
c = Db()
if session["userid"] != None:
qry = "select user.*,login.* from login,user where user.loginid=login.lid"
res = c.select(qry)
return render_template('admin/allUsers.html', data=res)
else:
return render_template('form.html')
def view_rating():
db = Db()
q = db.select(
"select * from review,client WHERE review.client_id=client.client_id")
res = {}
res['status'] = "ok"
res['data'] = q
return demjson.encode(res)
def adm_cmplnt():
a = Db()
if session["userid"] != None:
q = "select complaint.*,user.* from user,complaint where complaint.clid=user.loginid"
r = a.select(q)
return render_template('admin/adminComplaintform.html', cmplnts=r)
else:
return render_template('form.html')
