Ejemplo n.º 1
0
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)))
Ejemplo n.º 2
0
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'))