def _goods_itemgroup_(_id): store_id = c.session['store'] if c.is_json(): if c.is_GET(): with orm.session_scope() as ss: # type:c.typeof_Session only = c.simple_query(ss, orm.상품_분류, no=_id) return c.jsonify(c.for_json(only)) elif c.is_POST(): with orm.session_scope() as ss: # type:c.typeof_Session only = c.newitem_web(orm.상품_분류, c.session) cnt = itemgroup_query(ss, store_id).count() only.번호 = cnt + 1 for k, v in c.data_POST().items(): if hasattr(only, k) and k != 'no': if getattr(only, k) != v: setattr(only, k, v) ss.add(only) return 'added' elif c.is_PUT(): with orm.session_scope() as ss: # type:c.typeof_Session only = c.simple_query(ss, orm.상품_분류, no=_id) if only.s == c.session['store']: for k, v in c.data_POST().items(): if hasattr(only, k) and k != 'no': if getattr(only, k) != v: print(k, 'is changed') setattr(only, k, v) only.issync = None return 'modified' else: c.abort(403) elif c.is_DELETE(): with orm.session_scope() as ss: # type:c.typeof_Session only = c.simple_query(ss, orm.상품_분류, no=_id) if only.s == c.session['store']: only.isdel = c.O l = itemgroup_query(ss, store_id).all() for i in range(len(l)): l[i].번호 = i + 1 only.issync = None return 'deleted' else: c.abort(403) c.abort(404)
def _system_menugroup_(_id): sid = c.session['store'] if c.is_json(): if c.is_GET(): with orm.session_scope() as ss: # type:c.typeof_Session r = c.simple_query(ss, orm.설정_메뉴그룹, id=_id) return c.jsonify(c.for_json(r)) elif c.is_POST(): with orm.session_scope() as ss: # type:c.typeof_Session r = c.newitem_web(orm.설정_메뉴그룹, c.session) cnt = menugroup_query(ss, sid).count() r.번호 = cnt + 1 for k, v in c.data_POST().items(): if hasattr(r, k) and k != 'id': if getattr(r, k) != v: setattr(r, k, v) ss.add(r) return 'added' elif c.is_PUT(): with orm.session_scope() as ss: # type:c.typeof_Session r = c.simple_query(ss, orm.설정_메뉴그룹, id=_id) if r.sid == c.session['store']: for k, v in c.data_POST().items(): if hasattr(r, k) and k != 'id': if getattr(r, k) != v: print(k, 'is changed') setattr(r, k, v) r.issync = None return 'modified' else: c.abort(403) elif c.is_DELETE(): with orm.session_scope() as ss: # type:c.typeof_Session r = c.simple_query(ss, orm.설정_메뉴그룹, id=_id) if r.sid == c.session['store']: r.isdel = c.O l = menugroup_query(ss, sid).all() for i in range(len(l)): l[i].번호 = i + 1 r.issync = None return 'deleted' else: c.abort(403) c.abort(404)
def _goods_item_upload_(_id): store_id = c.session['store'] gd = c.dict_itemgroup(orm, store_id) if c.is_json(): if c.is_GET(): with orm.session_scope() as ss: # type:c.typeof_Session only = c.simple_query(ss, orm.상품_품목, no=_id) only.분류 = gd[only.분류no] return c.jsonify(c.for_json(only)) elif c.is_POST(): with orm.session_scope() as ss: # type:c.typeof_Session only = c.newitem_web(orm.상품_품목, c.session) for k, v in c.data_POST().items(): if hasattr(only, k) and k != 'no': if getattr(only, k) != v: setattr(only, k, v) only.분류no = c.fs2i(c.data_POST()['분류'].split('|', 1)[0].strip()) ss.add(only) return 'added' elif c.is_PUT(): with orm.session_scope() as ss: # type:c.typeof_Session only = c.simple_query(ss, orm.상품_품목, no=_id) if only.s == c.session['store']: for k, v in c.data_POST().items(): if hasattr(only, k) and k != 'no': if getattr(only, k) != v: print(k, 'is changed') setattr(only, k, v) only.분류no = c.fs2i(c.data_POST()['분류'].split('|', 1)[0].strip()) only.issync = None return 'modified' else: c.abort(403) elif c.is_DELETE(): with orm.session_scope() as ss: # type:c.typeof_Session only = c.simple_query(ss, orm.상품_품목, no=_id) if only.s == c.session['store']: only.isdel = c.O only.issync = None return 'deleted' else: c.abort(403) c.abort(404)
def _board_board_(_id): store_id = c.session['store'] if c.is_GET(): if True: # c.is_json() l = [] with orm.session_scope() as ss: # type:c.typeof_Session q1 = ss.query(orm.상품_품목) \ .filter_by(s=store_id) \ .filter_by(isdel='X') \ .all() for x in q1: dummy = x.__dict__.copy() del dummy['_sa_instance_state'] for k, v in dummy.items(): if v is None: dummy[k] = '' elif isinstance(v, date): dummy[k] = v.isoformat() elif isinstance(v, datetime): dummy[k] = v.isoformat(' ') l.append(dummy) return c.jsonify(l) elif c.is_POST(): with orm.session_scope() as ss: # type:c.typeof_Session if c.data_POST()['i'] == '신규': only = c.newitem_web(orm.상품_품목, c.session) for k, v in c.data_POST().items(): if hasattr(only, k) and k != 'i': if getattr(only, k) != v: setattr(only, k, v) ss.add(only) return 'modified' elif c.data_POST()['i'] != '신규': only = c.simple_query(ss, orm.상품_품목, s=c.session['store']) for x in only: if int(x.i) == int(c.data_POST()['i']): for k, v in c.data_POST().items(): if hasattr(x, k) and k != 'i': if getattr(x, k) != v: print(k, 'is changed') setattr(x, k, v) x.issync = None return 'modified' return 'modified'
def _goods_itemgroup_(_id): store_id = c.session['store'] if c.is_GET(): if True: # c.is_json() l = [] with orm.session_scope() as ss: # type:c.typeof_Session q1 = ss.query(orm.상품_분류) \ .filter_by(s=c.session['store']) \ .filter_by(isdel='X') \ .all() for x in q1: dummy = x.__dict__.copy() del dummy['_sa_instance_state'] for k, v in dummy.items(): if v is None: dummy[k] = '' elif isinstance(v, date): dummy[k] = v.isoformat() elif isinstance(v, datetime): dummy[k] = v.isoformat(' ') l.append(dummy) return c.jsonify(l) elif c.is_PUT(): with orm.session_scope() as ss: # type:c.typeof_Session temp = [] for i in c.data_POST(): for j in c.json.loads(i): temp.append(j) only = c.simple_query(ss, orm.상품_분류, s=c.session['store']) for i in temp: if '코드' not in i: only1 = c.newitem_web(orm.상품_분류, c.session) only1.분류명 = i['대분류'] ss.add(only1) elif i['코드'] != None: for x in only: if x.i == i['코드']: x.분류명 = i['대분류'] x.isdel = i['isdel'] return 'modified'
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)
def _system_menugroup_movedown(_id): sid = c.session['store'] if c.is_json(): if c.is_PUT(): with orm.session_scope() as ss: # type:c.typeof_Session r = c.simple_query(ss, orm.설정_메뉴그룹, id=_id).번호 l = menugroup_query(ss, sid).all() if sid == c.session['store']: if r >= len(l): return 'modified' else: for i in l: if i.번호 == r: i.번호 += 1 elif i.번호 == r + 1: i.번호 -= 1 return 'modified' else: c.abort(403) c.abort(404)
def _system_tablegroup_moveup(_id): sid = c.session['store'] if c.is_json(): if c.is_PUT(): with orm.session_scope() as ss: # type:c.typeof_Session r = c.simple_query(ss, orm.설정_테이블그룹, id=_id).번호 l = tablegroup_query(ss, sid).all() if sid == c.session['store']: if r <= 1: return 'modified' else: for i in l: if i.번호 == r - 1: i.번호 += 1 elif i.번호 == r: i.번호 -= 1 return 'modified' else: c.abort(403) c.abort(404)
def _goods_item_(_id): store_id = c.session['store'] if c.is_GET(): if True: # c.is_json() l = [] with orm.session_scope() as ss: # type:c.typeof_Session q1 = ss.query(orm.상품_품목) \ .filter_by(s=store_id) \ .filter_by(isdel='X') \ .all() for x in q1: dummy = x.__dict__.copy() del dummy['_sa_instance_state'] for k, v in dummy.items(): if v is None: dummy[k] = '' elif isinstance(v, date): dummy[k] = v.isoformat() elif isinstance(v, datetime): dummy[k] = v.isoformat(' ') l.append(dummy) return c.jsonify(l) elif c.is_POST(): with orm.session_scope() as ss: # type:c.typeof_Session if c.data_POST()['i'] == '신규': only = c.newitem_web(orm.상품_품목, c.session) for k, v in c.data_POST().items(): if hasattr(only, k) and k != 'i': if getattr(only, k) != v: if k == '프린터j': _lst = [] if v != '': for ch in v.split(','): _lst.append(int(ch.strip())) v = _lst setattr(only, k, v) ss.add(only) return 'modified' elif c.data_POST()['i'] != '신규': only = c.simple_query(ss, orm.상품_품목, s=c.session['store']) for x in only: if int(x.i) == int(c.data_POST()['i']): for k, v in c.data_POST().items(): if hasattr(x, k) and k != 'i': if getattr(x, k) != v: if k == '프린터j': _lst = [] if v != '': for ch in v.split(','): _lst.append(int(ch.strip())) v = _lst print(k, 'is changed') setattr(x, k, v) x.issync = None return 'modified' temp = [] # for i in c.data_POST(): # for j in c.json.loads(i): # temp.append(j) # print(temp) # only = c.simple_query(ss, orm.상품_품목, s=c.session['store']) # for i in temp: # if '코드' not in i: # only1 = c.newitem_web(orm.상품_품목, c.session) # only1.품목명 = i['명'] # ss.add(only1) # # elif i['코드'] != None: # # for x in only: # if x.i == i['코드']: # x.품목명 = i['명'] # x.isdel = i['isdel'] return 'modified'