def pay_bill(Bid):
sqlhelper.insert_or_delet("""
update bill set Bstate = 2 where Bid = %s
"""%Bid)
sqlhelper.insert_or_delet("""
update Rtable set Tstate = 0 where Tid in (select Tid from B_D_T where Bid = %s)
"""%Bid)
return redirect(url_for('display_bill'))
def order_order():
Bid = sqlhelper.insert_get_seed("""
insert into bill (Bsun,Bstate) values (%f,0)
""" % session['menu']['Psum'])
for d in session['menu']['dishes']:
sqlhelper.insert_or_delet("""
insert into B_D_T (Bid,Did,Tid,nstate) values (%s,%s,%s,0)
"""% (str(Bid),str(d['Did']),str(session['menu']['Tid'])))
session['menu']['state']=1
session['menu']['Bid']=str(Bid)
print(session['menu'])
return render_template('wait_dishes.html',dishes=sqlhelper.select_excution("""
select id,Dname,Dpice,nstate from B_D_T left join dish on B_D_T.Did = dish.Did where B_D_T.Bid = %s
"""% str(Bid)))
def finish_order():
rows = sqlhelper.select_excution("""
select * from B_D_T where nstate != 3 and nstate !=4 and Bid = %s
""" % str(session['menu']['Bid']))
if len(rows) != 0 :
return """
<script>
alert("you can't do that,still unfinish dish");
history.go(-1);
</script>
"""
sqlhelper.insert_or_delet("""
update bill set Bstate = 1 where Bid = %s
"""% str(session['menu']['Bid']))
session.pop('menu', None)
return redirect(url_for('waiterLogin'))
def select_table(Tid,where):
result = sqlhelper.insert_or_delet("""
update Rtable set Tstate = 1 where Tid=%s;
""" % Tid)
if(where==0):
return redirect(url_for('select_hall'))
else:
return redirect(url_for('select_room'))
def add_cook():
if request.method == 'GET':
return render_template('add_cook.html', sorts=sqlhelper.select_excution('''
select Soid,Sname from Sort;
'''))
result = sqlhelper.insert_or_delet("""
insert into cook (Soid,Cname,Cage,Csex) values (%s,N'%s',%s,N'%s');
""" % (request.form['Soid'], request.form['Cname'], request.form['Cage'], request.form['Csex']))
return redirect(url_for('cookers'))
def add_waiter():
if request.method == 'GET':
return render_template('add_waiter.html', Rooms=sqlhelper.select_excution("""
select Tname from Rtable where Tname!=N'´óÌü';
"""))
result = sqlhelper.insert_or_delet("""
insert into Waiter (Wname,Wage,wsex,Wroom) values (N'%s',%s,N'%s',N'%s');
""" % (request.form['Wname'], request.form['Wage'], request.form['wsex'], request.form['Wroom']))
return redirect(url_for('waiters'))
def add_sort():
if request.method == 'GET':
return render_template('add_sort.html', sorts=sqlhelper.select_excution('''
select Soid,Sname from Sort;
'''))
result = sqlhelper.insert_or_delet("""
insert into Sort (Sname) values (N'%s');
""" % (request.form['Sname']))
return redirect(url_for('add_sort'))
def add_roomTable():
if request.method == 'GET':
return render_template('add_roomTable.html', Tables=sqlhelper.select_excution("""
select Tname,Tsize,Tid from Rtable where Tname!=N'´óÌü';
"""))
result = sqlhelper.insert_or_delet("""
insert into Rtable (Tsize,Tstate,Tname) values (%s,0,N'%s');
""" % (request.form['Tsize'], request.form['Tname']))
return redirect(url_for('add_roomTable'))
def add_dish():
if request.method == 'GET':
return render_template('add_dish.html', sorts=sqlhelper.select_excution('''
select Soid,Sname from Sort;
'''))
file = request.files['picture']
if file and allowed_file(file.filename):
savefile = str(uuid.uuid1()) + '.' + file.filename.rsplit('.', 1)[1];
file.save(os.path.join(app.config['UPLOAD_FOLDER'], savefile))
result = sqlhelper.insert_or_delet("""
insert into dish (Soid,Dname,Dpice,Dpic) values (%s,N'%s',%f,'%s');
""" % (request.form['Soid'], request.form['Dname'], float(request.form['Dpice']), savefile))
return redirect(url_for('dishes'))
def cook_job():
unfinish=sqlhelper.select_excution("""
select top 1 id,Dname,Dpic,Sname from B_D_T
left join dish on B_D_T.Did=dish.Did
left join Sort on dish.Soid=Sort.Soid
where B_D_T.nstate = 1 and B_D_T.Cid = %s
order by id
"""%session['cooker']['Cid'])
if(len(unfinish)==1):
return render_template('cook_job.html',row=unfinish[0])
row=sqlhelper.select_excution("""
select top 1 id,Dname,Dpic,Sname from B_D_T
left join dish on B_D_T.Did=dish.Did
left join Sort on dish.Soid=Sort.Soid
where B_D_T.nstate = 0 and (dish.Soid = %s or Sort.Sname=N'¼Ò³£²Ë')
order by id
"""% str(session['cooker']['Soid']))
if(len(row)>0):
sqlhelper.insert_or_delet("""
update B_D_T set nstate = 1,Cid=%s where id = %s
""" % (session['cooker']['Cid'],row[0].id))
return render_template('cook_job.html',row=row[0])
return (render_template('cook_job.html'))
def send_dish(id):
sqlhelper.insert_or_delet("""
update B_D_T set nstate=3 where id = %s
"""% str(id))
return redirect(url_for('wait_dishes'))
def cancel_dish(id):
sqlhelper.insert_or_delet("""
update B_D_T set nstate = 4 where id = %s
""" % str(id))
return redirect(url_for('cook_job'));
def delet_sort(delet_id):
result = sqlhelper.insert_or_delet("""
delete from Sort where Soid=%s;
""" % (delet_id))
return redirect(url_for('add_sort'))
def delet_dish(Did):
result = sqlhelper.insert_or_delet('''
delete from dish where Did = %s;
''' % Did)
return str(result)
def deltable(Tid):
result = sqlhelper.insert_or_delet("""
delete from Rtable where Tid=%s;
""" % Tid)
return str(result)
def delcook(Cid):
result = sqlhelper.insert_or_delet('''
delete from Cook where Cid = %s;
''' % Cid)
return str(result)
def delwaiter(Wid):
result = sqlhelper.insert_or_delet('''
delete from Waiter where Wid = %s;
''' % Wid)
return str(result)
