def adddish():
if request.method == 'GET':
db = model('dzf', '123456', '39.108.102.21')
dish_t = dish(db)
dishes = dish_t.get_dishes()
db.close()
return render_template('adddish.html', dishes=dishes)
if request.method == 'POST':
if 'dish_id1' in request.form:
db = model('dzf', '123456', '39.108.102.21')
dish_t = dish(db)
dish_id = request.form['dish_id1']
dish_name = request.form['dish_name1']
dish_price = request.form['dish_price1']
dish_description = request.form['dish_description1']
args = [dish_id, dish_name, dish_price, dish_description]
flag = dish_t.adddish(args)
dishes = dish_t.get_dishes()
if flag:
db.close()
return render_template('adddish.html',
dishes=dishes,
error='添加成功！')
else:
db.close()
return render_template('adddish.html',
dishes=dishes,
error='添加失败！')
else:
db = model('dzf', '123456', '39.108.102.21')
dish_t = dish(db)
dish_id = request.form['dish_id']
dish_name = request.form['dish_name']
dish_price = request.form['dish_price']
dish_description = request.form['dish_description']
args = [dish_id, dish_name, dish_price, dish_description]
flag = dish_t.updatedish(args)
dishes = dish_t.get_dishes()
if flag:
db.close()
return render_template('adddish.html',
dishes=dishes,
error='修改成功！')
else:
db.close()
return render_template('adddish.html',
dishes=dishes,
error='修改失败！')
def showorderinfo():
global desk_id
db = model('dzf', '123456', '39.108.102.21')
orderinfo_t = orderinfo(db)
if request.method == 'GET':
return render_template('showorderinfo.html')
if request.method == 'POST':
if 'desk_id' in request.form:
desk_id = request.form['desk_id']
info = orderinfo_t.get_desk_info(desk_id)
if info:
return render_template('showorderinfo.html', info=info)
else:
error = '桌位号错误！'
return render_template('showorderinfo.html', error=error)
elif ('dish_id1' in request.form) and ('quantity1' in request.form):
order_id = request.form['order_id1']
dish_id = request.form['dish_id1']
quantity = request.form['quantity1']
orderinfo_t.create_info(order_id, dish_id, quantity)
info = orderinfo_t.get_desk_info(desk_id)
return render_template('showorderinfo.html', info=info)
else:
order_id = request.form['order_id']
dish_id = request.form['dish_id']
quantity = request.form['quantity']
if quantity == '0':
orderinfo_t.delete_info(order_id, dish_id)
info = orderinfo_t.get_desk_info(desk_id)
return render_template('showorderinfo.html', info=info)
else:
orderinfo_t.delete_info(order_id, dish_id)
orderinfo_t.create_info(order_id, dish_id, quantity)
info = orderinfo_t.get_desk_info(desk_id)
return render_template('showorderinfo.html', info=info)
def adddesk():
if request.method == 'GET':
db = model('dzf', '123456', '39.108.102.21')
desk_t = desk(db)
desks = desk_t.get_desk()
db.close()
return render_template('adddesk.html', desks=desks)
if request.method == 'POST':
if 'desk_id1' in request.form:
db = model('dzf', '123456', '39.108.102.21')
desk_t = desk(db)
desk_id = request.form['desk_id1']
desk_maxnum = request.form['desk_maxnum1']
args = [desk_id, desk_maxnum]
flag = desk_t.adddesk(args)
desks = desk_t.get_desk()
if flag:
db.close()
return render_template('adddesk.html',
desks=desks,
error='添加成功！')
else:
db.close()
return render_template('adddesk.html',
desks=desks,
error='添加失败！')
else:
db = model('dzf', '123456', '39.108.102.21')
desk_t = desk(db)
desk_id = request.form['desk_id']
desk_maxnum = request.form['desk_maxnum']
args = [desk_id, desk_maxnum]
flag = desk_t.updatedesk(args)
desks = desk_t.get_desk()
if flag:
db.close()
return render_template('adddesk.html',
desks=desks,
error='修改成功！')
else:
db.close()
return render_template('adddesk.html',
desks=desks,
error='修改失败！')
def checkout():
if request.method == 'GET':
return render_template('checkout.html')
if request.method == 'POST':
global desk_id
db = model('dzf', '123456', '39.108.102.21')
orderinfo_t = orderinfo(db)
order_t = order(db)
if 'desk_id' in request.form:
desk_id = request.form['desk_id']
info = order_t.total_info(desk_id)
amount = order_t.total_amount(desk_id)[0][0]
if info:
return render_template('checkout.html',
desk_id=desk_id,
info=info,
amount=amount)
else:
error = '桌位号错误！'
return render_template('checkout.html',
desk_id=desk_id,
error=error)
else:
if 'paymode' in request.form:
info = order_t.total_info(desk_id)
discount = request.form['discount']
discount = re.sub("\D", "", discount)
print(discount)
paymode = request.form['paymode']
order_id = orderinfo_t.get_desk_info(desk_id)[0][0]
amount = order_t.total_amount(desk_id)[0][0]
amount = int(discount) * 0.1 * int(amount)
order_t.checkout_order(order_id, discount, paymode)
return render_template('checkout.html',
desk_id=desk_id,
info=info,
amount=amount,
error='结账成功')
else:
order_id = orderinfo_t.get_desk_info(desk_id)[0][0]
dish_id = request.form['dish_id']
quantity = request.form['quantity']
if quantity == 0:
orderinfo_t.delete_info(order_id, dish_id)
else:
orderinfo_t.delete_info(order_id, dish_id)
orderinfo_t.create_info(order_id, dish_id, quantity)
amount = order_t.total_amount(desk_id)[0][0]
info = order_t.total_info(desk_id)
return render_template('checkout.html',
desk_id=desk_id,
info=info,
amount=amount,
error='修改成功！')
def orderdish():
if request.method == 'GET':
db = model('dzf', '123456', '39.108.102.21')
dish_t = dish(db)
dishes = dish_t.get_dishes()
return render_template('orderdish.html', dishes=dishes)
if request.method == 'POST':
db = model('dzf', '123456', '39.108.102.21')
order_t = order(db)
orderinfo_t = orderinfo(db)
dish_t = dish(db)
global order_id
global desk_id
print(('desk_id' in request.form) and ('order_id' in request.form))
if ('desk_id' in request.form) and ('order_id' in request.form):
print(request.form)
desk_id = request.form['desk_id']
order_id = request.form['order_id']
order_t.checkin_order(order_id, desk_id)
dishes = dish_t.get_dishes()
success = '创建成功！'
return render_template('orderdish.html',
success=success,
dishes=dishes,
desk_id=desk_id,
order_id=order_id)
else:
dish_id = request.form['dish_id']
quantity = request.form['quantity']
dishes = dish_t.get_dishes()
if orderinfo_t.create_info(order_id, dish_id, quantity):
print('problem\n\n\n\n')
order_info = orderinfo_t.get_info(order_id)
return render_template('orderdish.html',
dishes=dishes,
orderinfo=order_info,
desk_id=desk_id,
order_id=order_id)
def showorders():
db = model('dzf', '123456', '39.108.102.21')
orderinfo_t = orderinfo(db)
order_t = order(db)
if request.method == 'GET':
orders = order_t.show_all()
info = orderinfo_t.get_all()
return render_template('showorders.html', orders=orders, info=info)
if request.method == 'POST':
order_id = request.form['order_id']
order_s = order_t.showorder(order_id)
info = orderinfo_t.get_info(order_id)
return render_template('showorders.html', orders=order_s, info=info)
def register():
if request.method == 'GET':
if session.get('username'):
return render_template('register.html', back='返回')
else:
return "PLEASE LOGIN!"
if request.method == 'POST':
username = request.form['username']
password1 = request.form['password1']
password2 = request.form['password2']
db = model('dzf', '123456', '39.108.102.21')
usr = user(db)
if usr.register(username, password1, password2):
db.close()
return render_template('login.html')
else:
error = '用户名重复或两次密码不一致！'
db.close()
return render_template('register.html', error=error, back='返回')
def login():
if request.method == 'GET':
return render_template('login.html')
if request.method == 'POST':
username = request.form['username']
password = request.form['password']
session.permanent = False
session['username'] = username
db = model('dzf', '123456', '39.108.102.21')
usr = user(db)
if usr.check_username(username):
if usr.check_password(username, password):
db.close()
return redirect(url_for('workshope'))
else:
db.close()
return render_template('login.html', error='请输入正确的密码！')
else:
db.close()
return render_template('login.html', error='账号错误！')