def post(self): json = request.get_json(force=True) manu_serial = json.get('manu_serial', None) description = json.get('desc', None) category_id = json.get('category_id', None) manufacturer_id = json.get('manufacturer_id', None) if not manu_serial or not desc or not category_id or not manufacturer_id: return result.create_response(result.DATA_NO_EXIST) category = Category.query.filter_by(id=category_id).first() manufacturer = Manufacturer.query.filter_by(id=manufacturer_id).first() if not category or not manufacturer: return result.create_response(result.DATA_NO_EXIST) material = Material.query.filter_by(manu_serial=manu_serial).first() if material: return result.create_response(result.DATA_IS_EXIST) serial = '' tmp = Material.query.filter_by(category_id=category.id).order_by(desc(Material.serial)).first() if not tmp: serial = str(int(category.encode_rules) + 1) else: serial = str(int(tmp.serial) + 1) material = Material() material.serial = serial material.manu_serial = manu_serial material.desc = description material.category = category material.manufacturer = manufacturer material.lc_code = json.get('lc_code') material.save() return result.create_response(result.OK, material)
def delete(self, id): user = User.query.filter(User.id == id).first() if not user: return result.create_response(result.USER_NO_EXIST) if user.isActive(): user.active = False user.save() return result.create_response(result.OK)
def put(self, id): category = Category.query.filter_by(id=id).first() if category is None: return result.create_response(result.ID_NOT_EXIST) json = request.get_json(force=True) name = json.get('name', None) if name: category.name = name category.save() return result.create_response(result.OK, category)
def put(self, id): manufacturer = Manufacturer.query.filter_by(id=id).first() if not manufacturer: return result.create_response(result.ID_NOT_EXIST) json = request.get_json(force=True) name = json.get('name', None) if name: manufacturer.name = name manufacturer.save() return result.create_response(result.OK, manufacturer)
def post(self): user = g.current_user if not user: return result.create_response(result.USER_NO_EXIST) json = request.get_json(force=True) data = json.get('data', None) if not data: return result.create_response(result.DATA_NO_EXIST) mark_dyn_data(user.id, data) return result.create_response(result.OK)
def post(self): json = request.get_json(force=True) name = json.get('name', None) if name is None: return result.create_response(result.DATA_NO_EXIST) manufacturer = Manufacturer.query.filter_by(name=name).first() if manufacturer: return result.create_response(result.DATA_IS_EXIST) manufacturer = Manufacturer() manufacturer.name = name manufacturer.save() return result.create_response(result.OK, manufacturer)
def post(self): json = request.get_json(force=True) username = json['user_name'] if User.query.filter_by(name=username).scalar() is None: password = json['password'] admin = json['admin'] user = User() user.name = username user.password = password if admin: user.permission = Permission.ADMINISTRATOR user.save() return result.create_response(result.OK, user) return result.create_response(result.USER_EXIST)
def post(self): json = request.get_json(force=True) name = json.get('name', None) encode_rules = json.get('encode_rules', None) if name is None or encode_rules is None: return result.create_response(result.DATA_NO_EXIST) category = Category.query.filter_by(name=name).first() if category: return result.create_response(result.DATA_IS_EXIST) category = Category() category.name = name category.encode_rules = encode_rules category.save() return result.create_response(result.OK, category)
def get(self): offset = int(request.args['offset']) if request.args['offset'] else 0 limit = int(request.args['limit']) if request.args['limit'] else 20 manufactures = Manufacturer.query.order_by(desc(Manufacturer.id)).limit(limit).offset(offset) count = Manufacturer.query.with_entities(func.count(Manufacturer.id)).scalar() return result.create_response(result.OK, { 'count': count, 'manufacturer': [x.to_dict() for x in manufactures] })
def get(self): offset = int(request.args['offset']) if request.args['offset'] else 0 limit = int(request.args['limit']) if request.args['limit'] else 20 users = User.query.order_by(desc(User.id)).limit(limit).offset(offset) count = User.query.with_entities(func.count(User.id)).scalar() return result.create_response(result.OK, { 'count': count, 'users': [x.to_json() for x in users], })
def put(self, id): material = Material.query.filter_by(id=id).first() if not material: return result.create_response(result.ID_NOT_EXIST) json = request.get_json(force=True) material.serial = json.get('serial') if json.get('serial', None) else material.serial material.manu_serial = json.get('manu_serial') if json.get('manu_serial', None) else material.manu_serial material.desc = json.get('desc') if json.get('desc', None) else material.desc material.lc_code = json.get('lc_code') if json.get('lc_code') else material.lc_code category_id = json.get('category_id', None) manufacturer_id = json.get('manufacturer_id', None) category = Category.query.filter_by(id=category_id).first() manufacturer = Manufacturer.query.filter_by(id=manufacturer_id).first() if category: material.category = category if manufacturer: material.manufacturer = manufacturer material.save() return result.create_response(result.OK, material)
def put(self, id): user = User.query.filter(User.id == id).first() if not user: return result.create_response(result.USER_NO_EXIST) json = request.get_json(force=True) password = json['password'] admin = json['admin'] active = json['active'] logger.info(json) if password is not None: user.password = password if admin: user.permission = Permission.ADMINISTRATOR else: user.permission = 0 if active is not None: user.active = active user.save() return result.create_response(result.OK, user)
def put(self, id): vendor = Vendor.query.filter_by(id=id).first() if vendor is None: return result.create_response(result.ID_NOT_EXIST) json = request.get_json(force=True) if json.get('name', None): vendor.name = json.get('name') if json.get('address', None): vendor.tel = json.get('address') if json.get('tax_number', None): vendor.qq = json.get('tax_number') liaison_id = json.get('liaison_id', None) if liaison_id is not None: liaison = Vendor.query.filter_by(id=liaison_id).first() if liaison is None: return result.create_response(result.DATA_NO_EXIST) vendor.liaison.append(liaison) vendor.save() return result.create_response(result.OK, vendor)
def put(self, id): liaison = Liaison.query.filter_by(id=id).first() if liaison is None: return result.create_response(result.ID_NOT_EXIST) json = request.get_json(force=True) if json.get('name', None): liaison.name = json.get('name') if json.get('tel', None): liaison.tel = json.get('tel') if json.get('qq', None): liaison.qq = json.get('qq') vendor_id = json.get('vendor_id', None) if vendor_id is not None: vendor = Vendor.query.filter_by(id=vendor_id).first() if vendor is None: return result.create_response(result.DATA_NO_EXIST) liaison.vendor = vendor liaison.save() return result.create_response(result.OK, liaison)
def post(self): json = request.get_json(force=True) name = json.get('name', None) if name is None: return result.create_response(result.DATA_NO_EXIST) vendor = Vendor.query.filter_by(name=name).first() if vendor is not None: return result.create_response(result.DATA_IS_EXIST) vendor = Vendor() vendor.name = name vendor.address = json.get('address', None) vendor.tax_number = json.get('tax_number', None) lialison_id = json.get('liaison_id', None) if lialison_id: liaison = Liaison.query.filter_by(id=lialison_id).first() if liaison is None: return result.create_response(result.DATA_NO_EXIST) vendor.liaison.append(liaison) vendor.save() return result.create_response(result.OK, vendor)
def post(self): json = request.get_json(force=True) name = json.get('name', None) if name is None: return result.create_response(result.DATA_NO_EXIST) liaison = Liaison.query.filter_by(name=name).first() if liaison: return result.create_response(result.DATA_IS_EXIST) liaison = Liaison() liaison.name = name liaison.tel = json.get('tel', None) liaison.qq = json.get('qq', None) vendor_id = json.get('vendor_id', None) if vendor_id is not None: vendor = Vendor.query.filter_by(id=vendor_id).first() if vendor is None: return result.create_response(result.DATA_NO_EXIST) liaison.vendor = vendor liaison.save() return result.create_response(result.OK, liaison)
def get(self): offset = int(request.args['offset']) if request.args['offset'] else 0 limit = int(request.args['limit']) if request.args['limit'] else 20 liaisons = Liaison.query.order_by(desc( Liaison.id)).limit(limit).offset(offset) count = Liaison.query.with_entities(func.count(Liaison.id)).scalar() return result.create_response( result.OK, { 'count': count, 'liaison': [x.to_dict() for x in liaisons] })
def get(self): offset = int(request.args['offset']) if request.args['offset'] else 0 limit = int(request.args['limit']) if request.args['limit'] else 20 vendors = Vendor.query.order_by(desc( Vendor.id)).limit(limit).offset(offset) count = Vendor.query.with_entities(func.count(Vendor.id)).scalar() return result.create_response( result.OK, { 'count': count, 'vendors': [x.to_dict(show=['liaison'], _hide=[]) for x in vendors] })
def post(self): json = request.get_json(force=True) username = json['user_name'] password = json['password'] user = User.query.filter_by(name=username).first() if not user or not user.check_password(password): return result.create_response(result.NAME_PASS_ERROR) if not user.isActive(): return result.create_response(result.USER_NO_ACTIVE) token = user.generate_auth_token( app=current_app, expiration=current_app.config['TOKEN_EXPIRE']) expire = time.mktime(datetime.datetime.now().timetuple() ) + current_app.config['TOKEN_EXPIRE'] return result.create_response( result.OK, { 'token': token.decode('utf-8'), 'expire': time.strftime("%Y-%m-%d %H:%M:%S", time.localtime(expire)), 'admin': user.check_permission(Permission.ADMINISTRATOR), 'name': user.name })
def get(self): offset = int(request.args['offset']) if request.args['offset'] else 0 limit = int(request.args['limit']) if request.args['limit'] else 20 categorys = Category.query.order_by(desc(Category.id)).limit(limit).offset(offset) count = Category.query.with_entities(func.count(Category.id)).scalar() category_list = [] for category in categorys: number = Material.query.with_entities(func.count(Material.id)) \ .filter_by(category_id=Category.id).scalar() data = { 'id' : category.id, 'name' : category.name, 'encode_rules' : category.encode_rules, 'material_count' : number } category_list.append(data) return result.create_response(result.OK, { 'count': count, 'category': category_list })
def get(self, id): liaison = Liaison.query.filter_by(id=id).first() if liaison is None: return result.create_response(result.ID_NOT_EXIST) return result.create_response(result.OK, liaison)
def get(self, id): user = User.query.filter(User.id == id).first() if user: return result.create_response(result.OK, user) return result.create_response(result.USER_NO_EXIST)
def get(self, id): vendor = Vendor.query.filter_by(id=id).first() if vendor is None: return result.create_response(result.ID_NOT_EXIST) return result.create_response(result.OK, vendor)
def get(self, id): manufacturer = Manufacturer.query.filter_by(id=id).first() if not manufacturer: return result.create_response(result.ID_NOT_EXIST) return result.create_response(result.OK, manufacturer)
def get(self, id): material = Material.query.filter_by(id=id).first() if not material: return result.create_response(result.ID_NOT_EXIST) return result.create_response(result.OK, material)
def get(self): user = g.current_user if not user: return result.create_response(result.USER_NO_EXIST) data = get_dyn_data(user.id) return result.create_response(result.OK, data)
def get(self, id): category = Category.query.filter_by(id=id).first() if category is None: return result.create_response(result.ID_NOT_EXIST) return result.create_response(result.OK, category)