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 cancal_order(): sqlhelper.insert_get_seed(""" update B_D_T set nstate=%s where Bid = %s and nstate=0; """ % (str(dishstate['cancel']),str(session['menu']['Bid']))) return redirect(url_for('wait_dishes'))