def add_post(): sname = request.form['sname'] tanka = request.form['tanka'] db = ShouhinDB() s = Shouhin(0,sname,tanka) db.insert(s) db.close() return redirect('/')
def add_post(): sname = request.form['sname'] tanka = request.form['tanka'] db = ShouhinDB() s = Shouhin(0, sname, tanka) db.insert(s) db.close() return json.dumps({"result": True})
def update_post(): sid = request.form['sid'] sname = request.form['sname'] tanka = request.form['tanka'] db = ShouhinDB() s = Shouhin(sid, sname, tanka) db.update(s) db.close() return json.dumps({"result": True})
def update_post(): sid = request.form['sid'] sname = request.form['sname'] tanka = request.form['tanka'] db = ShouhinDB() s = Shouhin(sid,sname,tanka) db.update(s) db.close() return redirect('/')
def uriage(): sid = request.args.get('sid') sdb = ShouhinDB() s = sdb.get(sid) sdb.close() udb = UriageDB() uriages = udb.find_by_sid(sid) udb.close() return json.dumps(uriages)
def uriage(): sid = request.args.get('sid') sdb = ShouhinDB() s = sdb.find(sid) sdb.close() udb = UriageDB() uriages = udb.find_by_sid(sid) udb.close() return render_template("uriage.html",title=f"{s.sname} 売り上げ",shouhin=s,uriages=uriages)
def del_post(): sid = request.form['sid'] db = ShouhinDB() db.delete(sid) db.close() return json.dumps({"result": True})
def find(): db = ShouhinDB() shouhins = db.get_all() db.close() return json.dumps(shouhins)
def index(): db = ShouhinDB() shouhins = db.find_all() db.close() return render_template("index.html",title="販売管理",shouhins=shouhins)
def update(): sid = request.args.get('sid') db = ShouhinDB() s = db.find(sid) db.close() return render_template("update.html",title="商品の更新",shouhin=s)
def del_post(): sid = request.form['sid'] db = ShouhinDB() db.delete(sid) db.close() return redirect('/')
def del_kakunin(): sid = request.args.get('sid') db = ShouhinDB() s = db.find(sid) db.close() return render_template("del.html",title="商品の削除",shouhin=s)