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 and_cal_cart():
db = Db()
print("jjjj")
cid = request.form['uid']
print(cid)
qry = "select quantity,price,fname,type from cart where cust_id='" + str(
cid) + "'"
res = db.select(qry)
if res is not None:
print("entr")
ik = 0
for i in res:
ik = ik + int(i["quantity"]) * int(i["price"])
print(i)
print("ik=", ik)
qq2 = "insert into order_master(customer_id,total,date,status)values('" + str(
cid) + "','" + str(ik) + "',curdate(),'pending')"
mms = db.insert(qq2)
print("mmss=", mms)
for ii in res:
print("mmm")
qq2 = "insert into order_table(food_items,quantity,order_master_id,type)values('" + ii[
"fname"] + "','" + str(ii["quantity"]) + "','" + str(
mms) + "','" + ii["type"] + "')"
db.insert(qq2)
return jsonify(status="ok", data=res, amt=ik)
else:
return jsonify(status="cant")
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_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 payment(id, amount):
db = Db()
account = request.form['acc']
ifc = request.form['i']
total = request.form['textfield3']
a = db.selectOne("select * from account where account_no='" + account +
"' and ifsc_code='" + ifc + "'")
o_account = db.selectOne("select * from account where account_id='2'")
if a is not None:
balance = a['balance']
if float(balance) > float(total):
available_balance = float(balance) - float(total)
o_balance = o_account['balance']
o_cbalance = float(o_balance) + float(total)
db.update("update account set balance='" + str(available_balance) +
"' where account_no='" + account + "'")
db.update("update account set balance='" + str(o_cbalance) +
"' where account_id='3'")
db.update(
"update payment set status='salary_paid' where workid='" +
str(id) + "'")
qry2 = db.select(
"select * from scheduleworker where scheduleworker.workid='" +
str(id) + "'")
for i in qry2:
worker_id = i['worker_id']
q = db.insert("insert into salary values ('','" + str(amount) +
"','" + str(worker_id) + "',curdate())")
return '<script>alert("Payment successfully");window.location="/confirmwork"</script>'
else:
return '<script>alert("Insufficent Balance");window.location="/confirmwork"</script>'
else:
return '<script>alert("Invalid Account");window.location="/confirmwork"</script>'
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 view_cat():
d = Db()
qry = "SELECT * FROM category"
print(qry)
res = d.select(qry)
print(res)
return jsonify(status='ok', category=res)
def trn_view_feedbacks():
# qr = "select feedbacks.*,customer.customer_name,vehicle_booking.vehcile_id from customer,feedbacks,vehicle_booking where customer.login_id=feedbacks.customer_id=vehicle_booking.vehcile_id and type='transport'"
qr = "SELECT `feedbacks`.*,`customer`.* FROM `customer`,`feedbacks` WHERE `feedbacks`.`customer_id`=`customer`.`login_id` AND `feedbacks`.`type`='transport'"
db = Db()
res = db.select(qr)
return render_template("Transport/Transport View Feedback.html",
values=res)
def view_complient():
d = Db()
cid = request.form['cid']
type = request.form['ty']
qry = "SELECT * FROM `complaint` WHERE `customer_id`='" + str(
cid) + "' AND `type`='" + type + "' order by date "
res = d.select(qry)
return jsonify(status='ok', data=res)
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 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_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_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 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')
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 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 user_history():
if session['lin'] == "lin":
obj = Db()
x = session['userid']
qry = "select created_at,song_file,status,song_id from song where user_id='" + str(x) + "' "
res = obj.select(qry)
return render_template("user/history.html",data=res)
else:
return render_template("login.html")
def user_vcomt():
if session['lin'] == "lin":
obj = Db()
x=session['userid']
qry = "select subject,complaint,created_at,reply,reply_date from complaint where user_id='"+str(x)+"'"
res = obj.select(qry)
return render_template("user/viewcmplt.html",data=res)
else:
return render_template("login.html")
def user_cmplnt():
c = Db()
x = session["userid"]
if session["userid"] != None:
qry = "select * from complaint where clid='" + str(x) + "'"
rslt = c.select(qry)
return render_template('user/user complaint form.html', ucmplnts=rslt)
else:
return render_template('form.html')
def result_history():
c = Db()
x = session["userid"]
if session["userid"] != None:
qry = "select * from details where ulid='" + str(x) + "'"
res = c.select(qry)
return render_template('user/resultHistory.html', details=res)
else:
return render_template('form.html')
def view_food_wwweeall():
d = Db()
cid = request.form["cid"]
qry = "SELECT `vehicle_name`,`reg_no`,`vehicle_booking`.`status` FROM `vehicle_booking`,`vehicle` WHERE `vehicle`.`vehicle_id`=`vehicle_booking`.`vehcile_id` AND `vehicle_booking`.`customer_id`='" + str(
cid) + "'"
print(qry)
res = d.select(qry)
print(res)
return jsonify(status='ok', food=res)
def view_complaint():
db = Db()
q = db.select(
"select * from complaint,worktable,client WHERE worktable.workid=complaint.workid and complaint.client_id=client.client_id"
)
res = {}
res['status'] = "ok"
res['reply'] = q
return demjson.encode(res)
def adm_view_food_items_edit(fid):
qr = "select food_items.food_item_id,food_items.food_name,food_items.price,food_items.picture,food_items.description,category.* from food_items inner join category on food_items.category_id=category.category_id where food_items.food_item_id='" + fid + "' "
db = Db()
res = db.selectOne(qr)
qr2 = "select * from category"
res2 = db.select(qr2)
return render_template("Admin/edit food items.html", data=res, cat=res2)
def and_view_order():
db = Db()
cid = request.form['custid']
print(cid)
qry = "SELECT `order_master`.*,`delay_message`.* FROM `order_master`,`delay_message` WHERE `order_master`.`order_master_id`=`delay_message`.`order_master_id` and customer_id='" + cid + "' ORDER BY delay_message.date "
res = db.select(qry)
if res is not None:
return jsonify(status="ok", data=res)
else:
return jsonify(status="cant")
def view_feedback():
d = Db()
cid = request.form['cid']
type = request.form['ty']
qry = "SELECT * FROM `feedbacks` WHERE `feedbacks.`customer_id`='" + str(
cid) + "' and `feedbacks`.`type`='" + type + "'"
print(qry)
res = d.select(qry)
print(res)
return jsonify(status='ok', data=res)
def view_leave_status():
db = Db()
lid = request.form['lid']
q = db.select(
"select * from worker_leave,worker WHERE worker.workerid=worker_leave.worker_id and worker_leave.worker_id='"
+ str(lid) + "' order by apply_date desc")
res = {}
res['status'] = "ok"
res['leave'] = q
return demjson.encode(res)
def viewservice():
db = Db()
res = {}
qry = db.select("select * from service WHERE status='1'")
if len(qry) == 0:
res['status'] = "Sorry"
else:
res['data'] = qry
res['status'] = "ok"
return demjson.encode(res)
def view_food():
d = Db()
cato = request.form['cat']
qry = "SELECT `food_items`.*,`category`.* FROM `food_items`,`category` WHERE `food_items`.`category_id`=`category`.`category_id` and `food_items`.`category_id`='" + cato + "' "
print(qry)
res = d.select(qry)
print(res)
if res is not None:
return jsonify(status='ok', food=res)
else:
return jsonify(status='No Food In This Category')
def workstatus():
db = Db()
lid = request.form['lid']
res = {}
qry = db.select(
"select service.service,worktable.worksite,worktable.description,worktable.work_date,worktable.work_status,worktable.workid from client,service,worktable WHERE worktable.serviceid=service.service_id and worktable.clientid=client.client_id and client.client_id='"
+ lid + "'")
if len(qry) == 0:
res['status'] = "Sorry"
else:
res['data'] = qry
res['status'] = "ok"
return demjson.encode(res)