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)
