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