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 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 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 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 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)