def _system_table(group_id):
sid = c.session['store']
if c.is_json():
if c.is_GET():
with orm.session_scope() as ss: # type:c.typeof_Session
l = c.for_json_l(table_query(ss, sid, group_id).all())
return c.jsonify(l)
elif c.is_PUT():
with orm.session_scope() as ss: # type:c.typeof_Session
for k, v in c.data_POST().items():
ol = json.loads(k)
for o in ol:
r = c.newitem_web(orm.설정_테이블, c.session)
c.merge_(o, r)
r.group_id = group_id
r.issync = None
ss.merge(r)
return 'modified'
else:
with orm.session_scope() as ss: # type:c.typeof_Session
if c.is_GET():
gl = c.for_json_l(tablegroup_query(ss, sid).all())
return c.display(item=c.newitem_web(orm.설정_테이블그룹, c.session),
form_types=form_types, gl=gl, selected=group_id,
TABLEBORDER_WIDTH=c.TABLEBORDER_WIDTH, TABLEBORDER_HEIGHT=c.TABLEBORDER_HEIGHT, )
c.abort(404)
def _system_menu(group_id):
sid = c.session['store']
id = c.dict_item(orm, sid)
il = list(id.values())
# print(id, il)
form_types[0]['l'] = il
if c.is_json():
if c.is_GET():
with orm.session_scope() as ss: # type:c.typeof_Session
l = c.for_json_l(menu_query(ss, sid, group_id).all())
for i in l:
try:
i['메뉴명'] = id[i['품목코드']]
except:
i['메뉴명'] = '미지정'
return c.jsonify(l)
elif c.is_PUT():
with orm.session_scope() as ss: # type:c.typeof_Session
for k, v in c.data_POST().items():
ol = json.loads(k)
for o in ol:
r = c.newitem_web(orm.설정_메뉴, c.session)
c.merge_(o, r)
r.group_id = group_id
try:
r.품목코드 = c.fs2i(o['메뉴명'].split('|', 1)[0].strip())
except:
r.품목코드 = 0
r.issync = None
ss.merge(r)
return 'modified'
else:
with orm.session_scope() as ss: # type:c.typeof_Session
if c.is_GET():
gl = c.for_json_l(menugroup_query(ss, sid).all())
_g = [i for i in gl if i['id'] == group_id][0]
return c.display(
item=c.newitem_web(orm.설정_메뉴그룹, c.session),
form_types=form_types,
gl=gl,
selected=group_id,
상하칸=_g['상하칸'],
좌우칸=_g['좌우칸'],
MENUBORDER_WIDTH=c.MENUBORDER_WIDTH,
MENUBORDER_HEIGHT=c.MENUBORDER_HEIGHT,
)
c.abort(404)
def _system_menu2():
store_id = c.session['store']
only = c.get_settings(orm, store_id)
id = c.dict_item(orm, store_id)
il = list(id.values())
# print(id, il)
form_types[0]['l'] = il
if c.is_GET():
if c.is_json():
with orm.session_scope() as ss: # type:c.typeof_Session
menu2 = ss.query(orm.상품_품목) \
.filter_by(s=store_id) \
.filter_by(isdel=c.X) \
.all()
menu2 = c.for_json_l(menu2)
menu2 = {i['i']: i for i in menu2}
menu2[0] = {'품목명': '미지정', '단가': 0}
return c.jsonify(d=only.j['메뉴'], l=menu2)
else:
return c.render_template('system/menu2.html',
item=None, form_types=form_types,
MENUBORDER_WIDTH=c.MENUBORDER_WIDTH, MENUBORDER_HEIGHT=c.MENUBORDER_HEIGHT, )
elif c.is_POST():
with orm.session_scope() as ss: # type:c.typeof_Session
next_one = c.newitem_web(orm.setting, c.session)
next_one.j = only.j.copy()
for each in c.data_POST():
next_one.j['메뉴'] = c.json.loads(each)
ss.add(next_one)
return 'modified'
def _system_menugroup():
sid = c.session['store']
if c.is_GET():
if c.is_json():
with orm.session_scope() as ss: # type:c.typeof_Session
l = c.for_json_l(menugroup_query(ss, sid).all())
return c.jsonify(l)
return c.display(item=c.newitem_web(orm.설정_메뉴그룹, c.session),
thead=thead, form_types=form_types, id=sid)
def _goods_itemgroup():
store_id = c.session['store']
if c.is_GET():
if c.is_json():
with orm.session_scope() as ss: # type:c.typeof_Session
lst = c.for_json_l(itemgroup_query(ss, store_id).all())
return c.jsonify(lst)
return c.display(item=c.newitem_web(orm.상품_분류, c.session),
thead=thead,
form_types=form_types,
no=store_id)
def _goods_item_modify():
store_id = c.session['store']
with orm.session_scope() as ss: # type:c.typeof_Session
gd = c.dict_itemgroup(orm, store_id)
gl = list(gd.values())
form_types[0]['l'] = gl
# print(gd, gl)
if c.is_GET():
if c.is_json():
l = c.for_json_l(
c.simple_query(ss, orm.상품_품목, s=store_id, order_by_asc='no'))
for i in l:
i['분류'] = gd[i['분류no']]
i['idx'] = i['no']
i['enabled'] = True
return c.jsonify(l)
return c.display(item=c.newitem_web(orm.상품_품목, c.session),
thead=thead,
form_types=form_types,
no=store_id,
gl=gl)