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 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 and_delete_cart():
db = Db()
cart_id = request.form['cart_id']
qry = "delete from cart where cart_id='" + cart_id + "'"
print(qry)
res = db.delete(qry)
if res > 0:
return jsonify(status="ok")
else:
return jsonify(status="cant")
def and_payment_food():
acc = request.form['acnt']
val = request.form['mmyy']
pinno = request.form['pin']
ccv = request.form['ccv']
total = request.form['amnt']
lid = request.form['custid']
qry = "select * from bank where customer_id='" + lid + "' and card_number='" + acc + "' and valid_thru='" + val + "' and cvv='" + ccv + "' and pin='" + pinno + "'"
d = Db()
res = d.selectOne(qry)
if res is None:
return jsonify(status="invalid")
else:
balance = res['bal']
session['a'] = balance
if int(balance) < int(total):
return jsonify(status="insuff")
else:
print("ok")
qry2 = "select * from cart where cust_id='" + lid + "'"
res2 = d.select(qry2)
qqq = "select table_hotel_id from table_booking where cust_id='" + lid + "'"
rrr = d.selectOne(qqq)
session['ti'] = rrr['table_hotel_id']
oid = d.insert(
"insert into order_master(`customer_id`,`total`,`date`,`status`,`type`,`table_hotel_id`) values('"
+ lid + "','" + total + "',curdate(),'success','food','" +
str(session['ti']) + "')")
for i in res2:
qry3 = "insert into order_table(`food_items_id`,`quantity`,`order_master_id`) values('" + str(
i['food_id']) + "','" + str(
i['quantity']) + "','" + str(oid) + "')"
d.insert(qry3)
d.delete("delete from cart where cart_id='" +
str(i['cart_id']) + "'")
d.update("update bank set bal='" + str(session['a']) + "'-'" +
str(total) + "' where bank_id='" +
str(res['bank_id']) + "'")
return jsonify(status="ok")
def delete(id):
c = Db()
c.delete("delete from details where upid='" + id + "'")
return result_history()
def rem(id):
c = Db()
res = c.delete("delete from login where lid='" + id + "'")
c.delete("delete from user where loginid='" + id + "'")
return adm_users()
def delete_channel(i):
db = Db()
qry = db.delete("delete from channel where channel_id='" + str(i) + "'")
return view_channel()
def delete_internet_package(i):
db = Db()
qry = db.delete("delete from internet_package where int_package_id='" +
str(i) + "'")
return view_internet_package()
def delete_cash_collector(i):
db = Db()
qry = db.delete("delete from cash_collector where cash_collector_id='" +
str(i) + "'")
return view_maintenance()
def adm_view_tables_delete(fid):
qr = "delete from table_hotel where table_hotel_id='" + fid + "'"
db = Db()
res = db.delete(qr)
return adm_view_tables()
def delt_noty(id):
obj=Db()
qry="delete from notification where n_id='"+id+"'"
obj.delete(qry)
return view_noti()
def deleteworker(a):
db = Db()
qry = db.delete("delete from worker where workerid='" + a + "'")
return '<script>alert("Removeed..."); window.location="/viewworker"</script>'
def deleteraw(a):
db = Db()
qry = db.delete("delete from rawmaterial where raw_id='" + a + "'")
return '<script>alert("Removed..."); window.location="/viewrawmaterial"</script>'
def trn_vehicle_delete(fid):
qr = "delete from vehicle where vehicle_id='" + fid + "'"
db = Db()
res = db.delete(qr)
return trn_view_vehicles()
def adm_delete_service(lid):
qr = "delete from service where service_id ='" + lid + "'"
db = Db()
res = db.delete(qr)
return adm_view_service()
def adm_view_food_items_delete(fid):
qr = "delete from food_items where food_item_id='" + fid + "'"
db = Db()
res = db.delete(qr)
return adm_view_food_items()
def adm_view_category_delete(fid):
qr = "delete from category where category_id='" + fid + "'"
db = Db()
res = db.delete(qr)
return adm_View_Category()
def Dr_schedule_Delete(sid):
qry ="delete from schedule where S_id ='"+sid+"' "
db=Db()
res=db.delete(qry)
return Dr_schedule()
def adm_view_spl_food_items_delete(fid):
qr = "delete from spl_food where special_food_id='" + fid + "'"
db = Db()
res = db.delete(qr)
return adm_view_spl_food_item()
def delete_maintenance(i):
db = Db()
qry = db.delete("delete from maintenance where maintenance_id='" + str(i) +
"'")
return view_maintenance()
def delete_notification(i):
db = Db()
qry = db.delete("delete from notification where notification_id='" +
str(i) + "'")
return view_notification()
def adm_delete_staff(fid):
qr = "delete from staff where staff_id='" + fid + "'"
db = Db()
res = db.delete(qr)
return adm_view_staff()