def cat():
resp_data = {}
req = request.values
query = FoodCat.query
if 'status' in req and int(req['status']) > -1:
query = query.filter(FoodCat.status == int(req['status']))
list = query.order_by(FoodCat.weight.desc(), FoodCat.id.desc()).all()
resp_data['list'] = list
resp_data['search_con'] = req
resp_data['status_mapping'] = app.config['STATUS_MAPPING']
resp_data['current'] = 'cat'
return ops_render("food/cat.html", resp_data)
return ops_render("food/cat.html")
def index():
resp_data = {}
query = Member.query
req = request.values
page = int(req['p']) if ('p' in req and req['p']) else 1
if 'status' in req and int(req['status']) > -1:
query = query.filter(Member.status == int(req['status']))
if 'mix_kw' in req:
rule = or_(Member.nickname.ilike("%{0}%".format(req['mix_kw'])),
Member.mobile.ilike("%{0}%".format(req['mix_kw'])))
query = query.filter(rule)
params = {
"total": query.count(),
"page_size": 2,
"page": page,
"url": request.full_path.replace("&p={}".format(page), "")
}
pages = iPagenation(params)
# 当前页数据开始位置
offset = (page - 1) * 2
# 当前页数据结束位置
limit = page * 2
list = query.all()[offset:limit]
resp_data['list'] = list
resp_data['status'] = app.config['STATUS']
resp_data['pages'] = pages
return ops_render("member/index.html", resp_data)
def set():
resp_data = {}
req = request.args
id = int(req.get('id', 0)) if req['id'] else 1
member_info = Member.query.filter_by(id=id).first()
resp_data['info'] = member_info
return ops_render("member/set.html", resp_data)
def index():
resp_data = {}
req = request.values
page = int(req['p']) if ('p' in req and req['p']) else 1
query = Member.query
if 'mix_kw' in req:
query = query.filter(
Member.nickname.ilike("%{0}%".format(req['mix_kw'])))
if 'status' in req and int(req['status']) > -1:
query = query.filter(Member.status == int(req['status']))
page_params = {
'total': query.count(),
'page_size': app.config['PAGE_SIZE'],
'page': page,
'display': app.config['PAGE_DISPLAY'],
'url': request.full_path.replace("&p={}".format(page), "")
}
pages = iPagination(page_params)
offset = (page - 1) * app.config['PAGE_SIZE']
list = query.order_by(Member.id.desc()).offset(offset).limit(
app.config['PAGE_SIZE']).all()
resp_data['list'] = list
resp_data['pages'] = pages
resp_data['search_con'] = req
resp_data['status_mapping'] = app.config['STATUS_MAPPING']
return ops_render("member/index.html", resp_data)
def set():
resp_data = {}
req = request.values
page = int(req['p']) if ('p' in req and req['p']) else 1
query = PayOrder.query.filter_by( status = 1 )
page_params = {
'total': query.count(),
'page_size': app.config['PAGE_SIZE'],
'page': page,
'display': app.config['PAGE_DISPLAY'],
'url': request.full_path.replace("&p={}".format(page), "")
}
pages = iPagination(page_params)
offset = (page - 1) * app.config['PAGE_SIZE']
list = query.order_by(PayOrder.id.desc()).offset(offset).limit(app.config['PAGE_SIZE']).all()
stat_info = db.session.query( PayOrder,func.sum( PayOrder.total_price ).label("total") )\
.filter( PayOrder.status == 1 ).first()
app.logger.info ( stat_info )
resp_data['list'] = list
resp_data['pages'] = pages
resp_data['total_money'] = stat_info[ 1 ] if stat_info[ 1 ] else 0.00
resp_data['current'] = 'account'
return ops_render( "finance/account.html",resp_data )
def login():
resp = {"code": 200, "msg": "登陆成功", "data": {}}
if request.method == "GET":
if g.current_user:
return redirect(UrlManager.buildUrl("/"))
return ops_render("user/login.html")
req = request.values
login_name = req["login_name"] if "login_name" in req else ""
login_pwd = req["login_pwd"] if "login_pwd" in req else ""
if login_name is None or len(login_name) < 1:
resp["code"] = -1
resp["msg"] = "请输入正确的用户名"
return jsonify(resp)
if login_pwd is None or len(login_pwd) < 1:
resp["code"] = -1
resp["msg"] = "请输入正确的密码"
return jsonify(resp)
user_info = User.query.filter_by(login_name=login_name).first()
if not user_info:
resp["code"] = -1
resp["msg"] = "您输入的用户名或密码不正确"
return jsonify(resp)
if user_info.login_pwd != UserService.genePwd(login_pwd,
user_info.login_salt):
resp["code"] = -1
resp["msg"] = "您输入的用户名或密码不正确"
return jsonify(resp)
if user_info.status != 1:
resp["code"] = -1
resp["msg"] = "账号已被禁用，请联系管理员处理"
return jsonify(resp)
response = make_response(json.dumps(resp))
response.set_cookie(
"user", "%s#%s" % (UserService.geneAuthCode(user_info), user_info.uid))
return response
def index():
resp = {}
query = User.query
req = request.values
page = int(req['p']) if ('p' in req and req['p']) else 1
if 'mix_kw' in req:
rule = or_(User.nickname.ilike("%{0}%".format(req['mix_kw'])),
User.mobile.ilike("%{0}%".format(req['mix_kw'])))
query = query.filter(rule)
if 'status' in req and int(req['status']) > -1:
query = query.filter(User.status == int(req['status']))
page_params = {
'total': query.count(),
'page_size': app.config['PAGE_SIZE'],
'page': page,
'display': app.config['PAGE_DISPLAY'],
'url': request.full_path.replace("&p={}".format(page), "")
}
pages = iPagination(page_params)
offset = (page - 1) * app.config['PAGE_SIZE']
limit = app.config['PAGE_SIZE'] * page
list = query.order_by(User.uid.asc()).all()[offset:limit]
resp["list"] = list
resp["pages"] = pages
resp["search_con"] = req
resp['status_mapping'] = app.config['STATUS_MAPPING']
return ops_render("account/index.html", context=resp)
def index():
now = datetime.datetime.now()
date_before_30days = now + datetime.timedelta(days=-30)
default_date_from = getFormatDate(date=date_before_30days,
format="%Y-%m-%d")
default_date_to = getFormatDate(date=now, format="%Y-%m-%d")
resp_data = {}
req = request.values
page = int(req['p']) if ('p' in req and req['p']) else 1
date_from = req['date_from'] if 'date_from' in req else default_date_from
date_to = req['date_to'] if 'date_to' in req else default_date_to
query = StatDailySite.query.filter(StatDailySite.date >= date_from) \
.filter(StatDailySite.date <= date_to)
page_params = {
'total': query.count(),
'page_size': app.config['PAGE_SIZE'],
'page': page,
'display': app.config['PAGE_DISPLAY'],
'url': request.full_path.replace("&p={}".format(page), "")
}
pages = iPagination(page_params)
offset = (page - 1) * app.config['PAGE_SIZE']
list = query.order_by(StatDailySite.id.desc()).offset(offset).limit(
app.config['PAGE_SIZE']).all()
resp_data['list'] = list
resp_data['pages'] = pages
resp_data['current'] = 'index'
resp_data['search_con'] = {'date_from': date_from, 'date_to': date_to}
return ops_render("stat/index.html", resp_data)
def comment():
resp_data = {}
comment_list = MemberComment.query.all()
resp_data['list'] = comment_list
member_info = {'avatar': '', 'nickname': 'Bruce'}
for item in comment_list:
item.member_info = member_info
return ops_render("member/comment.html", resp_data)
def set():
if request.method == "GET":
resp_data = {}
req = request.args
id = int(req.get("id", 0))
reback_url = UrlManager.buildUrl("/member/index")
if id < 1:
return redirect(reback_url)
info = Member.query.filter_by(id=id).first()
if not info:
return redirect(reback_url)
if info.status != 1:
return redirect(reback_url)
resp_data['info'] = info
resp_data['current'] = 'index'
return ops_render("member/set.html", resp_data)
resp = {'code': 200, 'msg': '操作成功', 'data': {}}
req = request.values
id = req['id'] if 'id' in req else 0
nickname = req['nickname'] if 'nickname' in req else ''
if nickname is None or len(nickname) < 1:
resp['code'] = -1
resp['msg'] = "请输入符合规范的姓名"
return jsonify(resp)
member_info = Member.query.filter_by(id=id).first()
if not member_info:
resp['code'] = -1
resp['msg'] = "指定会员不存在"
return jsonify(resp)
member_info.nickname = nickname
member_info.updated_time = getCurrentDate()
db.session.add(member_info)
db.session.commit()
return jsonify(resp)
return ops_render("member/set.html")
def edit():
if request.method == "GET":
return ops_render("user/edit.html")
resp = {"code": 200, "msg": "修改成功", "data": {}}
req = request.values
nickname = req["nickname"] if "nickname" in req else ""
email = req["email"] if "email" in req else ""
user_info = g.current_user
user_info.nickname = nickname
user_info.email = email
db.session.add(user_info)
db.session.commit()
return jsonify(resp)
def info():
resp = {}
req = request.args
uid = int(req.get("id", 0))
reback = UrlManager.buildUrl("/account/index")
if uid < 1:
return redirect(reback)
info = User.query.filter_by(uid=uid).first()
if not info:
return redirect(reback)
accessLogList = AppAccessLog.query.order_by(
AppAccessLog.created_time.desc()).all()[0:5]
resp["accessLogList"] = accessLogList
resp["info"] = info
return ops_render("account/info.html", resp)
def food():
now = datetime.datetime.now()
date_before_30days = now + datetime.timedelta(days=-30)
default_date_from = getFormatDate(date=date_before_30days,
format="%Y-%m-%d")
default_date_to = getFormatDate(date=now, format="%Y-%m-%d")
resp_data = {}
req = request.values
page = int(req['p']) if ('p' in req and req['p']) else 1
date_from = req['date_from'] if 'date_from' in req else default_date_from
date_to = req['date_to'] if 'date_to' in req else default_date_to
query = StatDailyFood.query.filter(StatDailyFood.date >= date_from) \
.filter(StatDailyFood.date <= date_to)
page_params = {
'total': query.count(),
'page_size': app.config['PAGE_SIZE'],
'page': page,
'display': app.config['PAGE_DISPLAY'],
'url': request.full_path.replace("&p={}".format(page), "")
}
pages = iPagination(page_params)
offset = (page - 1) * app.config['PAGE_SIZE']
list = query.order_by(StatDailyFood.id.desc()).offset(offset).limit(
app.config['PAGE_SIZE']).all()
date_list = []
if list:
food_map = getDictFilterField(Food, Food.id, "id",
selectFilterObj(list, "food_id"))
for item in list:
tmp_food_info = food_map[
item.food_id] if item.food_id in food_map else {}
tmp_data = {
"date": item.date,
"total_count": item.total_count,
"total_pay_money": item.total_pay_money,
'food_info': tmp_food_info
}
date_list.append(tmp_data)
resp_data['list'] = date_list
resp_data['pages'] = pages
resp_data['current'] = 'food'
resp_data['search_con'] = {'date_from': date_from, 'date_to': date_to}
return ops_render("stat/food.html", resp_data)
def set():
default_pwd = "******"
if request.method == "GET":
resp_data = {}
req = request.args
uid = req.get("id", 0)
user_info = None
if uid:
user_info = User.query.filter_by(uid=uid).first()
resp_data["user_info"] = user_info
return ops_render("account/set.html", resp_data)
#添加和编辑账户的保存操作
resp = {"code": 200, "msg": "操作成功", "data": {}}
req = request.values
id = req['id'] if 'id' in req else ""
nickname = req['nickname'] if 'nickname' in req else ""
mobile = req['mobile'] if 'mobile' in req else ""
email = req['email'] if 'email' in req else ""
login_name = req['login_name'] if 'login_name' in req else ""
login_pwd = req['login_pwd'] if 'login_pwd' in req else ""
has_in = User.query.filter(User.login_name == login_name,
User.uid != id).first()
if has_in:
resp["code"] = -1
resp["msg"] = "该登录名已存在，请换一个试试"
return jsonify(resp)
user_info = User.query.filter_by(uid=id).first()
if user_info:
model_user = user_info
else:
model_user = User()
model_user.created_time = getCurrentDate()
model_user.login_salt = UserService.geneSalt()
model_user.nickname = nickname
model_user.mobile = mobile
model_user.email = email
model_user.login_name = login_name
if login_pwd != default_pwd:
model_user.login_pwd = UserService.genePwd(login_pwd,
model_user.login_salt)
model_user.updated_time = getCurrentDate()
db.session.add(model_user)
db.session.commit()
return jsonify(resp)
def index():
resp_data = {
'data': {
'finance': {
'today': 0,
'month': 0
},
'member': {
'today_new': 0,
'month_new': 0,
'total': 0
},
'order': {
'today': 0,
'month': 0
},
'shared': {
'today': 0,
'month': 0
},
}
}
now = datetime.datetime.now()
date_before_30days = now + datetime.timedelta(days=-30)
date_from = getFormatDate(date=date_before_30days, format="%Y-%m-%d")
date_to = getFormatDate(date=now, format="%Y-%m-%d")
list = StatDailySite.query.filter( StatDailySite.date >= date_from)\
.filter( StatDailySite.date <= date_to ).order_by( StatDailySite.id.asc() )\
.all()
data = resp_data['data']
if list:
for item in list:
data['finance']['month'] += item.total_pay_money
data['member']['month_new'] += item.total_new_member_count
data['member']['total'] = item.total_member_count
data['order']['month'] += item.total_order_count
data['shared']['month'] += item.total_shared_count
if getFormatDate(date=item.date, format="%Y-%m-%d") == date_to:
data['finance']['today'] = item.total_pay_money
data['member']['today_new'] = item.total_new_member_count
data['order']['today'] = item.total_order_count
data['shared']['today'] = item.total_shared_count
return ops_render("index/index.html", resp_data)
def resetPwd():
if request.method == "GET":
return ops_render("user/reset_pwd.html")
resp = {"code": 200, "msg": "密码修改成功", "data": {}}
req = request.values
old_password = req["old_password"] if "old_password" in req else ""
new_password = req["new_password"] if "new_password" in req else ""
user_info = g.current_user
user_info.login_pwd = UserService.genePwd(new_password,
user_info.login_salt)
db.session.add(user_info)
db.session.commit()
#刷新cookie
response = make_response(json.dumps(resp))
response.set_cookie(
"user", "%s#%s" % (UserService.geneAuthCode(user_info), user_info.uid))
return response
def info():
resp_data = {}
req = request.args
id = int(req.get("id", 0))
reback_url = UrlManager.buildUrl("/food/index")
if id < 1:
return redirect(reback_url)
info = Food.query.filter_by(id=id).first()
if not info:
return redirect(reback_url)
stock_change_list = FoodStockChangeLog.query.filter(FoodStockChangeLog.food_id == id) \
.order_by(FoodStockChangeLog.id.desc()).all()
resp_data['info'] = info
resp_data['stock_change_list'] = stock_change_list
resp_data['current'] = 'index'
return ops_render("food/info.html", resp_data)
def info():
resp_data = {}
req = request.values
id = int(req['id']) if 'id' in req else 0
reback_url = UrlManager.buildUrl("/finance/index")
if id < 1:
return redirect( reback_url )
pay_order_info = PayOrder.query.filter_by( id = id ).first()
if not pay_order_info:
return redirect(reback_url)
member_info = Member.query.filter_by( id = pay_order_info.member_id ).first()
if not member_info:
return redirect(reback_url)
order_item_list = PayOrderItem.query.filter_by( pay_order_id = pay_order_info.id ).all()
data_order_item_list = []
if order_item_list:
food_map = getDictFilterField(Food, Food.id, "id", selectFilterObj(order_item_list, "food_id"))
for item in order_item_list:
tmp_food_info = food_map[ item.food_id ]
tmp_data = {
"quantity":item.quantity,
"price":item.price,
"name":tmp_food_info.name
}
data_order_item_list.append( tmp_data )
address_info = {}
if pay_order_info.express_info:
address_info = json.loads(pay_order_info.express_info)
resp_data['pay_order_info'] = pay_order_info
resp_data['pay_order_items'] = data_order_item_list
resp_data['member_info'] = member_info
resp_data['address_info'] = address_info
resp_data['current'] = 'index'
return ops_render( "finance/pay_info.html",resp_data )
def info():
resp_data = {}
req = request.args
id = int(req.get("id", 0))
reback_url = UrlManager.buildUrl("/member/index")
if id < 1:
return redirect(reback_url)
info = Member.query.filter_by(id=id).first()
if not info:
return redirect(reback_url)
# pay_order_list = PayOrder.query.filter_by(member_id=id).filter(PayOrder.status.in_([-8, 1])) \
# .order_by(PayOrder.id.desc()).all()
# comment_list = MemberComments.query.filter_by(member_id=id).order_by(MemberComments.id.desc()).all()
resp_data['info'] = info
# resp_data['pay_order_list'] = pay_order_list
# resp_data['comment_list'] = comment_list
# resp_data['current'] = 'index'
return ops_render("member/info.html", resp_data)
def index():
resp_data = {}
req = request.values
page = int(req['p']) if ('p' in req and req['p']) else 1
query = Food.query
if 'mix_kw' in req:
rule = or_(Food.name.ilike("%{0}%".format(req['mix_kw'])),
Food.tags.ilike("%{0}%".format(req['mix_kw'])))
query = query.filter(rule)
if 'status' in req and int(req['status']) > -1:
query = query.filter(Food.status == int(req['status']))
if 'cat_id' in req and int(req['cat_id']) > 0:
query = query.filter(Food.cat_id == int(req['cat_id']))
page_params = {
'total': query.count(),
'page_size': app.config['PAGE_SIZE'],
'page': page,
'display': app.config['PAGE_DISPLAY'],
'url': request.full_path.replace("&p={}".format(page), "")
}
pages = iPagination(page_params)
offset = (page - 1) * app.config['PAGE_SIZE']
list = query.order_by(Food.id.desc()).offset(offset).limit(
app.config['PAGE_SIZE']).all()
cat_mapping = getDictFilterField(FoodCat, FoodCat.id, "id", [])
resp_data['list'] = list
resp_data['pages'] = pages
resp_data['search_con'] = req
resp_data['status_mapping'] = app.config['STATUS_MAPPING']
resp_data['cat_mapping'] = cat_mapping
resp_data['current'] = 'index'
return ops_render("food/index.html", resp_data)
def catSet():
if request.method == "GET":
resp_data = {}
req = request.args
id = int(req.get("id", 0))
info = None
if id:
info = FoodCat.query.filter_by(id=id).first()
resp_data['info'] = info
resp_data['current'] = 'cat'
return ops_render("food/cat_set.html", resp_data)
resp = {'code': 200, 'msg': '操作成功', 'data': {}}
req = request.values
id = req['id'] if 'id' in req else 0
name = req['name'] if 'name' in req else ''
weight = int(req['weight']) if ('weight' in req
and int(req['weight']) > 0) else 1
if name is None or len(name) < 1:
resp['code'] = -1
resp['msg'] = "请输入符合规范的分类名称"
return jsonify(resp)
food_cat_info = FoodCat.query.filter_by(id=id).first()
if food_cat_info:
model_food_cat = food_cat_info
else:
model_food_cat = FoodCat()
model_food_cat.created_time = getCurrentDate()
model_food_cat.name = name
model_food_cat.weight = weight
model_food_cat.updated_time = getCurrentDate()
db.session.add(model_food_cat)
db.session.commit()
return jsonify(resp)
def error_404(e):
LogService.addErrorLog(e)
return ops_render("error/error.html", {
"status": 404,
"msg": "很抱歉，您访问的页面不存在"
})
def index():
resp_data = {}
req = request.values
page = int(req['p']) if ('p' in req and req['p']) else 1
query = PayOrder.query
if 'status' in req:
query = query.filter( PayOrder.status == int( req['status'] ) )
page_params = {
'total': query.count(),
'page_size': app.config['PAGE_SIZE'],
'page': page,
'display': app.config['PAGE_DISPLAY'],
'url': request.full_path.replace("&p={}".format(page), "")
}
pages = iPagination(page_params)
offset = (page - 1) * app.config['PAGE_SIZE']
pay_list = query.order_by(PayOrder.id.desc()).offset(offset).limit(app.config['PAGE_SIZE']).all()
data_list = []
if pay_list:
pay_order_ids = selectFilterObj( pay_list,"id" )
pay_order_items_map = getDictListFilterField( PayOrderItem,PayOrderItem.pay_order_id,"pay_order_id", pay_order_ids )
food_mapping = {}
if pay_order_items_map:
food_ids = []
for item in pay_order_items_map:
tmp_food_ids = selectFilterObj( pay_order_items_map[ item ],"food_id" )
tmp_food_ids = {}.fromkeys(tmp_food_ids).keys()
food_ids = food_ids + list( tmp_food_ids )
#food_ids里面会有重复的，要去重
food_mapping = getDictFilterField( Food,Food.id,"id", food_ids )
for item in pay_list:
tmp_data = {
"id":item.id,
"status_desc":item.status_desc,
"order_number":item.order_number,
"price":item.total_price,
"pay_time":item.pay_time,
"created_time":item.created_time.strftime("%Y%m%d%H%M%S")
}
tmp_foods = []
tmp_order_items = pay_order_items_map[ item.id ]
for tmp_order_item in tmp_order_items:
tmp_food_info = food_mapping[ tmp_order_item.food_id ]
tmp_foods.append( {
'name':tmp_food_info.name,
'quantity':tmp_order_item.quantity
} )
tmp_data['foods'] = tmp_foods
data_list.append( tmp_data )
resp_data['list'] = data_list
resp_data['pages'] = pages
resp_data['search_con'] = req
resp_data['pay_status_mapping'] = app.config['PAY_STATUS_MAPPING']
resp_data['current'] = 'index'
return ops_render( "finance/index.html",resp_data )
def info():
resp_data = {}
return ops_render("goods/info.html")
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['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 = 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), "后台修改")
return jsonify(resp)
def set():
if request.method == "GET":
resp_data = {}
req = request.args
id = int(req.get('id',0))
info = Goods.query.filter_by(id=id).first()
if info and info.status != 1:
return redirect(UrlManager.buildUrl("/goods/index"))
resp_data['info'] = info
return ops_render("goods/set.html",resp_data)
# 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 ''
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)
goods_info = Goods.query.filter_by(uid=id).first()
before_stock = 0
if goods_info:
model_goods = goods_info
before_stock = model_goods.stock
else:
model_goods = Goods()
model_goods.status = 1
# 插入格式化的时间
model_goods.created_time = getCurrentDate()
model_goods.cat_id = cat_id
model_goods.name = name
model_goods.price = price
model_goods.main_image = main_image
model_goods.summary = summary
model_goods.stock = stock
model_goods.tags = tags
model_goods.updated_time = getCurrentDate()
db.session.add(model_goods)
db.session.commit()
return jsonify(resp)
def comment():
return ops_render("member/comment.html")
def cat_set():
resp_data = {}
return ops_render("goods/cat_set.html")
