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() FoodService.setStockChangeLog(model_food.id, int(stock) - int(before_stock), "后台修改") # 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.build_url("/food/index")) cat_list = FoodCat.query.all() resp_data['info'] = info resp_data['cat_list'] = cat_list resp_data['current'] = 'index' return ops_render("food/set.html", resp_data) 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 '' 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 not price or len(price) < 1: resp['code'] = -1 resp['msg'] = "请输入符合规范的售卖价格~~" return jsonify(resp) price = Decimal(price).quantize(Decimal('0.00')) 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 = get_current_date() 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 = get_current_date() db.session.add(model_food) db.session.commit() FoodService.setStockChangeLog(model_food.id, int(stock) - int(before_stock), "后台修改") return jsonify(resp)
def set(): if request.method == 'GET': resp_data = {} req = request.args ids = req.get('id', '') id = int(ids) if ids.isdigit() else 0 food_info = Food.query.filter_by(id=id).first() if food_info and food_info.status != 1: return redirect(UrlManager.buildUrl('/food/index')) cat_list = FoodCat.query.all() resp_data['current'] = 'index' resp_data['cat_list'] = cat_list resp_data['food_info'] = food_info return ops_render('food/set.html', resp_data) resp = {'code': 200, 'msg': '操作成功', 'data': {}} req = request.values id = int(req['id']) if 'id' in req and req['id'].isdigit() else 0 cat_id = int( req['cat_id']) if 'cat_id' in req and req['cat_id'].isdigit() else 0 name = req['name'] if 'name' in req else '' price = req['price'] if 'price' in req else 0 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 and req['stock'].isdigit() else 0 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 not name or len(name) < 1: resp['code'] = -1 resp['msg'] = '请输入符合规范的名字' return jsonify(resp) if price <= 0: resp['code'] = -1 resp['msg'] = '请输入符合规范的售卖价格' return jsonify(resp) if not main_image or len(main_image) < 3: resp['code'] = -1 resp['msg'] = '请上传封面图' return jsonify(resp) if not summary or len(summary) < 10: resp['code'] = -1 resp['msg'] = '请输入描述,并且不能少于10个字符' return jsonify(resp) if stock < 1: resp['code'] = -1 resp['msg'] = '请输入符合规范的库存量' return jsonify(resp) if not tags or len(tags) < 1: resp['code'] = -1 resp['msg'] = '请输入标签,便于搜索' return jsonify(resp) # has_food_name = Food.query.filter(Food.name==name).first() # if has_food_name: # 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.created_time = getCurrentDate() model_food.cat_id = cat_id model_food.name = name model_food.main_image = main_image model_food.stock = stock model_food.price = price model_food.summary = summary 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 = model_food.stock - 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() FoodService.setFoodStockChangeLog(model_food.id, int(stock) - int(before_stock), '后台修改') return jsonify(resp)
def foot_set(): # 修改食物库存等信息 if request.method == "GET": resp_data = {} input_id = request.args.get('id', 0, type=int) target_info = Food.query.filter_by(id=input_id).first() if target_info and target_info.status != 1: return redirect(UrlManager.buildUrl("/food/index")) cat_list = FoodCat.query.all() resp_data['info'] = target_info resp_data['cat_list'] = cat_list resp_data['current'] = 'index' return ops_render("food/set.html", **resp_data) resp = {'code': 200, 'msg': '操作成功~~', 'data': {}} req = request.values input_id = ParamsValidator.GetORSetValue(req, 'id', value=0) cat_id = ParamsValidator.GetORSetValue(req, 'cat_id', value=0) name = ParamsValidator.GetORSetValue(req, 'name', value="") price = ParamsValidator.GetORSetValue(req, 'price', value="") main_image = ParamsValidator.GetORSetValue(req, 'main_image', value="") summary = ParamsValidator.GetORSetValue(req, 'summary', value="") stock = ParamsValidator.GetORSetValue(req, 'stock', value=0) tags = ParamsValidator.GetORSetValue(req, 'tags', value="") converted_price = 0.00 try: converted_price = Decimal(price).quantize(Decimal('0.00')) except Exception: pass if cat_id < 1: resp['code'] = -1 resp['msg'] = "请选择分类~~" elif name is None or len(name) < 1: resp['code'] = -1 resp['msg'] = "请输入符合规范的名称" elif not price or len(price) < 1: resp['code'] = -1 resp['msg'] = "请输入符合规范的售卖价格" elif converted_price <= 0: resp['code'] = -1 resp['msg'] = "请输入符合规范的售卖价格" elif main_image is None or len(main_image) < 3: resp['code'] = -1 resp['msg'] = "请上传封面图" elif summary is None or len(summary) < 3: resp['code'] = -1 resp['msg'] = "请输入食物描述,并不能少于10个字符" elif stock < 1: resp['code'] = -1 resp['msg'] = "请输入符合规范的库存量" elif tags is None or len(tags) < 1: resp['code'] = -1 resp['msg'] = "请输入标签,便于搜索" else: food_info = Food.query.filter_by(id=input_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) db.session.commit() FoodService.setStockChangeLog(model_food.id, int(stock) - int(before_stock), "后台修改") return jsonify(resp)
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 food_set(): """编辑、添加美食""" if request.method == 'GET': res = {} req_data = request.args fid = int(req_data.get('id', 0)) food_info = Food.query.filter_by(id=fid).first() if food_info and food_info.status != 1: return redirect(UrlManager.buildUrl('/food/index')) cat_list = FoodCat.query.all() res['info'] = food_info res['cat_list'] = cat_list res['current'] = 'index' return ops_render("food/set.html", res) res = {'code': 200, 'msg': '操作成功', 'data': {}} req_data = request.values fid = int(req_data['id']) if 'id' in req_data and req_data['id'] else 0 cat_id = int(req_data['cat_id']) if 'cat_id' in req_data else 0 name = req_data['name'] if 'name' in req_data else '' price = req_data['price'] if 'price' in req_data else '' main_image = req_data['main_image'] if 'main_image' in req_data else '' summary = req_data['summary'] if 'summary' in req_data else '' stock = int(req_data['stock']) if 'stock' in req_data else '' tags = req_data['tags'] if 'tags' in req_data else '' if cat_id < 1: res['code'] = -1 res['msg'] = "请选择分类~~" return jsonify(res) if name is None or len(name) < 1: res['code'] = -1 res['msg'] = "请输入符合规范的名称~~" return jsonify(res) if not price or len(price) < 1: res['code'] = -1 res['msg'] = "请输入符合规范的售卖价格~~" return jsonify(res) price = Decimal(price).quantize(Decimal('0.00')) if price <= 0: res['code'] = -1 res['msg'] = "请输入符合规范的售卖价格~~" return jsonify(res) if main_image is None or len(main_image) < 3: res['code'] = -1 res['msg'] = "请上传封面图~~" return jsonify(res) if summary is None or len(summary) < 3: res['code'] = -1 res['msg'] = "请输入图书描述,并不能少于10个字符~~" return jsonify(res) if stock < 1: res['code'] = -1 res['msg'] = "请输入符合规范的库存量~~" return jsonify(res) if tags is None or len(tags) < 1: res['code'] = -1 res['msg'] = "请输入标签,便于搜索~~" return jsonify(res) # 数据库操作 food_info = Food.query.filter_by(id=fid).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 = get_current_time() model_food.cat_id = cat_id model_food.name = name model_food.price = price model_food.summary = summary model_food.stock = stock model_food.main_image = main_image model_food.updated_time = get_current_time() model_food.tags = tags db.session.add(model_food) db.session.commit() FoodService.set_stock_change_log(model_food.id, int(stock) - int(before_stock), '后台修改') return jsonify(res)
def set(): if request.method == "GET": resp_data = {} req = request.args # 参数多时用values ,参数少时用args id = req['id'] if 'id' in req else 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.filter_by(status=1).all() resp_data['info'] = info resp_data['cat_list'] = cat_list resp_data['current'] = 'index' return ops_render("peixun/set.html", resp_data) # 下面是POST处理 resp = {'code': 200, 'msg': '操作成功', 'data': ''} req = request.values # 参数多时用values ,参数少时用args id = req['id'] if 'id' in req else 0 # 获取当前用户id cat_id = 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 = req['stock'] if 'stock' in req else '' tags = req['tags'] if 'tags' in req else '' # price = Decimal(price).quantize(Decimal('0.00')) # 转换价格格式 if len(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 summary is None or len(summary) < 3: 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)
def set(): if request.method == 'GET': resp_data = {} #传到前台信息展示 req = request.values 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['current'] = 'index' resp_data['list'] = cat_list resp_data['info'] = info return ops_render("food/set.html", resp_data) 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.Decimal(price).quantize(decimal.Decimal('0.00')) if cat_id < 1: resp['code'] = -1 resp['mag'] = '请输入符合规范的分类名!!!' 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.stock = stock model_food.main_image = main_image model_food.summary = summary 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)
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() current_user = g.current_user communities = Community.query.filter( Community.platform_id == current_user.platform_id).filter_by( status=1) resp_data['info'] = info resp_data['cat_list'] = cat_list resp_data['current'] = 'index' resp_data['communities'] = communities resp_data['current_user'] = current_user return ops_render("food/set.html", resp_data) 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 platform_id = int(req['platform_id']) if 'platform_id' in req else 0 platform_name = req['platform_name'] if 'platform_name' in req else '' communities = req['communities'] if 'communities' in req else '' date_from = req['date_from'] if 'date_from' in req else None date_to = req['date_to'] if 'date_to' in req else None name = req['name'] if 'name' in req else '' ratio = req['ratio'] if 'ratio' in req else '' market_price = req['market_price'] if 'market_price' 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 '' limit_quantity = int( req['limit_quantity'] ) if 'limit_quantity' in req and req['limit_quantity'] else 0 if cat_id < 1: resp['code'] = -1 resp['msg'] = "请选择分类~~" return jsonify(resp) if date_from is None or len(date_from) < 1: resp['code'] = -1 resp['msg'] = "请输入开始日期~~" return jsonify(resp) if date_to is None or len(date_to) < 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 not price or len(price) < 1: resp['code'] = -1 resp['msg'] = "请输入符合规范的售卖价格~~" return jsonify(resp) if not market_price or len(market_price) < 1: resp['code'] = -1 resp['msg'] = "请输入符合规范的市场价格~~" return jsonify(resp) if not ratio or len(ratio) < 1: resp['code'] = -1 resp['msg'] = "请输入符合规范的提成比例~~" return jsonify(resp) market_price = Decimal(market_price).quantize(Decimal('0.00')) if market_price <= 0: resp['code'] = -1 resp['msg'] = "请输入符合规范的售卖价格~~" return jsonify(resp) price = Decimal(price).quantize(Decimal('0.00')) if price <= 0: resp['code'] = -1 resp['msg'] = "请输入符合规范的售卖价格~~" return jsonify(resp) ratio = Decimal(ratio).quantize(Decimal('0.00')) if ratio <= 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) # print(platform_name) 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.platform_id = g.current_user.platform_id model_food.platform_name = g.current_user.platform_name model_food.cat_id = cat_id model_food.platform_id = platform_id model_food.platform_name = platform_name model_food.communities = communities model_food.date_from = date_from model_food.date_to = date_to model_food.name = name model_food.ratio = ratio model_food.market_price = market_price model_food.price = price model_food.main_image = main_image model_food.summary = summary model_food.stock = stock model_food.tags = tags model_food.limit_quantity = limit_quantity model_food.updated_time = getCurrentDate() db.session.add(model_food) ret = db.session.commit() FoodService.setStockChangeLog(model_food.id, int(stock) - int(before_stock), "后台修改") return jsonify(resp)
def set(): if request.method == "GET": resp_data = {} req = request.args id = int(req.get('id', 0)) # 获取查询的美食信息 id info = Food.query.filter_by(id=id).first() # 获取美食信息 if info and info.status != 1: # 如果存在info,但是它的状态 !=1,即被删除了,那么返回首页 return redirect(UrlManager.buildUrl("/food/index")) cat_list = FoodCat.query.all() # 查询所有分类 resp_data['info'] = info resp_data['cat_list'] = cat_list resp_data['current'] = 'index' return ops_render("food/set.html", resp_data) 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 '' # 标签 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 not price or len(price) <= 0: resp['code'] = -1 resp['msg'] = "请输入符合规范的售卖价格~~" return jsonify(resp) price = Decimal(price).quantize(Decimal('0.00')) # 价格,换成0.00 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 # 修改时,当前库存量before_stock就是 数据表里面的 else: model_food = Food() model_food.status = 1 model_food.created_time = getCurrentData() 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 = getCurrentData() db.session.add(model_food) ret = db.session.commit() FoodService.setStockChangeLog(model_food.id, int(stock) - int(before_stock), "后台修改") # 商品数量变更记录。商品id,变更的数量,备注 return jsonify(resp)