def setStockChangeLog(food_id=0, quantity=0, note=''):
print(food_id, quantity)
print('22222222222222222222')
# 库存变更表操作
if food_id < 1:
return False
print('333333333333333')
food_info = Food.query.filter_by(id=food_id).first()
if not food_id:
return False
print('4444444444444')
model_stock_change = FoodStockChangeLog()
model_stock_change.food_id = food_id
# 变更的库存
model_stock_change.unit = quantity
model_stock_change.total_stock = food_info.stock
model_stock_change.note = note
model_stock_change.created_time = getCurrentDate()
print('55555555555555')
db.session.add(model_stock_change)
db.session.commit()
print('666666666')
return True
def setStockChangeLog(food_id=0, quantity=0, note=''):
if food_id < 1:
return False
food_info = Food.query.filter_by(id=food_id).first()
if not food_info:
return False
model_stock_change = FoodStockChangeLog()
model_stock_change.food_id = food_id
model_stock_change.unit = quantity
model_stock_change.total_stock = food_info.stock
model_stock_change.note = note
model_stock_change.created_time = getCurrentDate()
db.session.add(model_stock_change)
db.session.commit()
return True
def setStockChangeLog( food_id = 0,quantity = 0,note = '' ):
# 差错处理
if food_id < 1 :
return False
# or quantity < 1,不能加，因为 本来库存就是有正有负的 有变化！
food_info = Food.query.filter_by( id = food_id ).first()
if not food_id:
return False
model_stock_chage = FoodStockChangeLog()
model_stock_chage.food_id = food_id
model_stock_chage.unit = quantity # 变化改变数量
model_stock_chage.total_stock = food_info.stock # 现在的视频库存数量
model_stock_chage.note = note
model_stock_chage.created_time = getCurrentDate()
db.session.add( model_stock_chage )
db.session.commit()
return True
def set():
if request.method == 'GET':
resp_data = {}
req = request.args
cat_list = FoodCat.query.all()
id = int(req.get('id', 0))
info = None
if id:
info = Food.query.filter_by(id=id).first()
if info and info.status != 1:
return redirect(UrlManager('/food/index'))
resp_data['cat_list'] = cat_list
resp_data['info'] = info
resp_data['current'] = 'index'
return ops_render("food/set.html", resp_data)
req = request.values
resp = {'code': 200, 'msg': '操作成功', 'data': {}}
id = int(req['id']) if 'id' in req else ''
cat_id = int(req['cat_id']) if 'cat_id' in req else ''
name = req['name'] if 'name' in req else ''
price = req['price'] if 'price' in req else ''
main_image = req['main_image'] if 'main_image' in req else ''
summary = req['summary'] if 'summary' in req else ''
stock = int(req['stock']) if 'stock' in req else ''
tags = req['tags'] if 'tags' in req else ''
price = Decimal(price).quantize(Decimal('0.00'))
if cat_id < 1:
resp['code'] = -1
resp['msg'] = '请选择分类~~'
return jsonify(resp)
if name is None or len(name) < 1:
resp['code'] = -1
resp['msg'] = '请输入符合规范的名称~~'
return jsonify(resp)
if price <= 0:
resp['code'] = -1
resp['msg'] = '请输入符合规范售卖价格~~'
return jsonify(resp)
if main_image is None or len(main_image) < 3:
resp['code'] = -1
resp['msg'] = '请上传封面图片~~'
return jsonify(resp)
if summary is None or len(summary) < 3:
resp['code'] = -1
resp['msg'] = '请输入图文描述，并且不能少于10个字符~~'
return jsonify(resp)
if stock < 1:
resp['code'] = -1
resp['msg'] = '请输入符合规范库存量~~'
return jsonify(resp)
if tags is None or len(tags) < 1:
resp['code'] = -1
resp['msg'] = '请输入标签，便于搜索~~'
return jsonify(resp)
# 美食信息
food_info = Food.query.filter_by(id=id).first()
app.logger.info(food_info)
# 变更之前的库存
before_stock = 0
if food_info:
model_food = food_info
before_stock = model_food.stock
else:
model_food = Food()
model_food.status = 1
model_food.created_time = getCurrentDate()
model_food.cat_id = cat_id
model_food.name = name
model_food.price = price
model_food.main_image = main_image
model_food.summary = summary
model_food.stock = stock
model_food.tags = tags
model_food.updated_time = getCurrentDate()
db.session.add(model_food)
db.session.commit()
model_stock_change = FoodStockChangeLog()
model_stock_change.food_id = model_food.id
model_stock_change.unit = int(stock) - int(before_stock)
model_stock_change.total_stock = stock
model_stock_change.note = ''
model_stock_change.created_time = getCurrentDate()
db.session.add(model_stock_change)
db.session.commit()
return jsonify(resp)
def set():
if request.method == 'GET':
resp_data = {}
req = request.args
id = int(req.get('id', 0))
info = Food.query.filter_by(id=id).first()
if info and info.status != 1:
return redirect(UrlManager.buildUrl('/food/index'))
cat_list = FoodCat.query.all()
resp_data['info'] = info
resp_data['current'] = 'set'
resp_data['cat_list'] = cat_list
return ops_render("food/set.html", resp_data)
elif request.method == 'POST':
resp = {'code': 200, 'msg': '操作成功', 'data': {}}
req = request.values
id = int(req['id']) if ('id' in req and req['id']) else 0
cat_id = int(req['cat_id']) if 'cat_id' in req else 0
name = req['name'] if 'name' in req else ''
price = req['price'] if 'price' in req else ''
main_image = req['main_image'] if 'main_image' in req else ''
summary = req['summary'] if 'summary' in req else ''
stock = int(req['stock']) if 'stock' in req else ''
tags = req['tags'] if 'tags' in req else ''
price = Decimal(price).quantize(Decimal('0.00'))
if cat_id < 1:
resp['code'] = -1
resp['msg'] = '请选择分类'
return jsonify(resp)
if name is None or len(name) < 1:
resp['code'] = -1
resp['msg'] = '请输入符合会犯的名称'
return jsonify(resp)
if price <= 0:
resp['code'] = -1
resp['msg'] = '请输入符合规范的售卖价格'
return jsonify(resp)
if main_image is None or len(main_image) < 3:
resp['code'] = -1
resp['msg'] = '请上传封面图'
return jsonify(resp)
if summary is None or len(summary) < 3:
resp['code'] = -1
resp['msg'] = "请输入图书描述，并不能少于10个字符"
return jsonify(resp)
if stock < 1:
resp['code'] = -1
resp['msg'] = '请输入符合规范的库存量'
return jsonify(resp)
if tags is None or len(tags) < 1:
resp['code'] = -1
resp['msg'] = '请输入标签，便于搜索'
return jsonify(resp)
food_info = Food.query.filter_by(id=id).first()
before_stock = 0
if food_info:
model_food = food_info
before_stock = model_food.stock
else:
model_food = Food()
model_food.status = 1
model_food.created_time = getCurrentDate()
model_food.cat_id = cat_id
model_food.name = name
model_food.price = price
model_food.main_image = main_image
model_food.summary = summary
model_food.stock = stock
model_food.tags = tags
model_food.updated_time = getCurrentDate()
db.session.add(model_food)
ret = db.session.commit()
model_stock_change = FoodStockChangeLog()
model_stock_change.food_id = model_food.id
# 当前的库存减去未修改前的库存，减少的话就是负数，增加就是正数
model_stock_change.unit = int(stock) - int(before_stock)
model_stock_change.total_stock = stock
model_stock_change.note = ''
model_stock_change.created_time = getCurrentDate()
db.session.add(model_stock_change)
db.session.commit()
return jsonify(resp)
