def removeOrRecover():
resp = {'code': 200, 'msg': '操作成功', 'data': {}}
req = request.values
id = req['id'] if 'id' in req else 0
acts = req['acts'] if 'acts' in req else ''
if not id:
resp['code'] = -1
resp['msg'] = "未操作操作账号"
return jsonify(resp)
if acts not in ['remove', 'recover']:
resp['code'] = -1
resp['msg'] = "操作有误"
return jsonify(resp)
user_info = User.query.filter_by(uid=id).first()
if not user_info:
resp['code'] = -1
resp['msg'] = "指定的账号不存在"
return jsonify(resp)
if user_info and user_info.uid == 1:
resp['code'] = -1
resp['msg'] = "该用户为L，不允许修改"
return jsonify(resp)
if acts == "remove":
user_info.status = 0
elif acts == "recover":
user_info.status = 1
user_info.updated_time = getCurrentDate()
db.session.add(user_info)
db.session.commit()
return jsonify(resp)
def ops():
resp = {'code': 200, 'msg': "success", 'data': {}}
req = request.values
id = req['id'] if 'id' in req else 0
act = req['act'] if 'id' in req else ""
if not id:
resp['code'] = -1
resp['msg'] = "请选择要操作的账号~~"
return jsonify(resp)
if act not in ['remove', 'recover']:
resp['code'] = -1
resp['msg'] = "操作有误，请重试~~"
return jsonify(resp)
user_info = User.query.filter_by(uid=id).first()
if not user_info:
resp['code'] = -1
resp['msg'] = "指定账号不存在~~"
return jsonify(resp)
if act == "remove":
user_info.status = 0
elif act == "recover":
user_info.status = 1
user_info.update_time = getCurrentDate()
db.session.add(user_info)
db.session.commit()
return jsonify(resp)
def ops():
# 定义json数据格式用于交互
resp = {'code': 200, 'msg': '操作成功!', 'data': {}}
req = request.values
id = req['id'] if 'id' in req else ''
act = req['act'] if 'act' in req else ''
if not id:
resp['code'] = -1
resp['msg'] = '请选择要操作的帐号'
return jsonify(resp)
if act not in ['remove', 'recover']:
resp['code'] = -1
resp['msg'] = '操作有误,请重试'
return jsonify(resp)
user_info = User.query.filter_by(uid=id).first()
if not user_info:
resp['code'] = -1
resp['msg'] = '指定帐号不存在'
return jsonify(resp)
# 接下来是查到有用户数据的判断
if act == 'remove':
user_info.status = 0
elif act == 'recover':
user_info.status = 1
# 保存进数据库
# 更新用户的'更新'字段
user_info.update_time = getCurrentDate()
db.session.add(user_info)
db.session.commit()
return jsonify(resp)
def uploadByFile(file):
config_upload = app.config['UPLOAD']
resp = {'code': 200, 'msg': "操作成功", 'data': {}}
filename = secure_filename(file.filename)
ext = filename.rsplit(".", 1)[1] # 取切割之后的第一个，[0]是文件名
if ext not in config_upload['ext']:
resp['code'] = -1
resp['msg'] = '不受支持的格式'
return resp
#上传
root_path = os.getcwd() + config_upload['prefix_path']
file_dir = datetime.datetime.now().strftime("%Y%m%d")
save_dir = root_path + file_dir
if not os.path.exists(save_dir):
os.mkdir(save_dir)
os.chmod(save_dir, stat.S_IRWXU | stat.S_IRGRP | stat.S_IRWXO)
#https://www.runoob.com/python/os-chmod.html 权限分配
file_name = str(uuid.uuid4()).replace("-", "") + "." + ext
file.save("{0}/{1}".format(save_dir, file_name))
model_image = Image()
model_image.file_key = file_dir + "/" + file_name
model_image.member_id = g.member_info.id
model_image.random_code = ''.join(
random.sample(string.ascii_letters + string.digits, 8))
model_image.created_time = getCurrentDate()
db.session.add(model_image)
db.session.commit()
resp['data'] = {
'file_key': model_image.file_key,
'random_code': model_image.random_code
}
return resp
def ops():
resp = {"code": 200, "msg": "操作成功", "data": {}}
req = request.values
id = req['id'] if 'id' in req else 0
action = req['action'] if 'action' in req else ''
if not id:
resp['code'] = -1
resp['msg'] = "该选择要操作的账号!"
return jsonify(resp)
if action not in ['remove', 'recovery']:
resp['code'] = -1
resp['msg'] = "操作有误，请重试!"
return jsonify(resp)
product_cat_info = ProductCat.query.filter_by(id=id).first()
if not product_cat_info:
resp['code'] = -1
resp['msg'] = "指定分类不存在!"
return jsonify(resp)
if action == "remove":
product_cat_info.status = 0
elif action == "recovery":
product_cat_info.status = 1
product_cat_info.updated_time = getCurrentDate()
db.session.add(product_cat_info)
db.session.commit()
return jsonify(resp)
def uploadImageFile(file, order_id, url):
config_upload = app.config['UPLOAD']
resp = {'code': '200', 'msg': '', 'data': {}}
filename = secure_filename(file.filename)
app.logger.info(filename)
ext_taget = filename.split(".")
ext_length = len(ext_taget)
ext = ext_taget[ext_length - 1]
if ext not in config_upload['ext']:
resp['code'] = -1
resp['msg'] = "不允许的扩展性文件"
return resp
root_path = app.root_path + url
file_dir = getCurrentDate("%Y%m%d")
save_dir = root_path + file_dir
if not os.path.exists(save_dir):
os.mkdir(save_dir)
os.chmod(save_dir, stat.S_IRWXU | stat.S_IRGRP | stat.S_IRWXO)
save_dir = save_dir + '/' + order_id
if not os.path.exists(save_dir):
os.mkdir(save_dir)
os.chmod(save_dir, stat.S_IRWXU | stat.S_IRGRP | stat.S_IRWXO)
file_name = str(uuid.uuid4()).replace("-", "") + "." + ext
file.save("{0}/{1}".format(save_dir, file_name))
resp['data'] = {
'file_key': file_dir + '/' + order_id + "/" + file_name
}
return resp
def courseCommentAdd():
resp = {'code': 200, 'msg': '操作成功', 'data': {}}
req = request.values
course_id = int(req['course_id']) if 'course_id' in req else 0
score = int(req['score']) if 'score' in req else 0
content = req['content'] if 'content' in req else ''
member_info = session.member_info
if not member_info:
resp['code'] = -1
resp['msg'] = '获取信息失败，未登录'
return jsonify(resp)
model_comment = MemberComments()
model_comment.member_id = member_info.id
model_comment.course_id = course_id
model_comment.score = score
model_comment.content = content
model_comment.created_time = getCurrentDate()
db.session.add(model_comment)
db.session.commit()
return jsonify(resp)
def removeOrRecover():
resp = {
'code':200,
'msg':"操作成功",
'data':{}
}
req = request.values
id = req['id'] if 'id' in req else 0
acts = req['acts'] if 'acts' in req else ''
if not id:
resp['code'] = -1
resp['msg'] = "请选择要操作的账号"
return jsonify(resp)
if acts not in ['remove','recover']:
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)
if acts == 'remove':
member_info.status = 0
elif acts == 'recover':
member_info.status = 1
member_info.updated_time = getCurrentDate()
db.session.add(member_info)
db.session.commit()
return jsonify(resp)
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)
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)
def ops():
resp_data = {'code': 200, 'msg': '操作成功', 'data': {}}
req = request.values
id = req['id'] if 'id' in req else 0
act = req['act'] if 'act' in req else ''
if not id:
resp_data['code'] = -1
resp_data['msg'] = '请选择正确的账号'
return jsonify(resp_data)
if act not in ['remove', 'recover']:
resp_data['code'] = -1
resp_data['msg'] = '操作有误请重试'
return jsonify(resp_data)
user_info = User.query.filter_by(uid=id).first()
if not user_info:
resp_data['code'] = -1
resp_data['msg'] = '该账号不存在'
return jsonify(resp_data)
if act == 'remove':
user_info.status = 0
else:
user_info.status = 1
user_info.update_time = getCurrentDate()
db.session.add(user_info)
db.session.commit()
return jsonify(resp_data)
def ops():
resp = {'code': 200, 'msg': '操作成功', 'data': {}}
req = request.values
id = req['id'] if 'id' in req else ''
act = req['act'] if 'act' in req else ''
if not id:
resp['code'] = -1
resp['msg'] = "操作失败1"
return jsonify(resp)
if act not in ['remove', 'recover']:
resp['act'] = -1
resp['act'] = "操作失败2"
return jsonify(resp)
user_info = User.query.filter_by(uid=id).first()
if not user_info:
resp['code'] = -1
resp['msg'] = "操作失败3"
if act == "remove":
user_info.status = 0
elif act == "recover":
user_info.status = 1
user_info.updated_time = getCurrentDate()
db.session.add(user_info)
db.session.commit()
return jsonify(resp)
def setItems(member_id=0,food_id=0,number=0):
if member_id < 1 or food_id < 1 or number < 1:
return False
cart_info = MemberCart.query.filter_by(food_id=food_id,member_id=member_id).first()
if cart_info:
model_cart = cart_info
else:
model_cart = MemberCart()
model_cart.member_id = member_id
model_cart.created_time = getCurrentDate()
model_cart.food_id = food_id
model_cart.quantity = number
model_cart.updated_time = getCurrentDate()
db.session.add(model_cart)
db.session.commit()
return True
def index_ops():
resp = {'code': 200, 'msg': '操作成功!!!', 'data': {}}
req = request.values
id = req['id'] if 'id' in req else 0
act = req['act'] if 'act' in req else ''
if not id:
resp['code'] = -1
resp['msg'] = '请选择要操作的账号!!!'
return jsonify(resp)
if act not in ['remove', 'recover']:
resp['code'] = -1
resp['msg'] = '操作有误,请重试!!'
return jsonify(resp)
food_info = Food.query.filter_by(id=id).first()
if not food_info:
resp['code'] = -1
resp['msg'] = '指定会员不存在!!!'
return jsonify(resp)
if act == 'remove':
food_info.status = 0
elif act == 'recover':
food_info.status = 1
food_info.updated_time = getCurrentDate()
db.session.add(food_info)
db.session.commit()
return jsonify(resp)
def orderOps():
resp = {'code': 200, 'msg': '操作成功', 'data': {}}
req = request.values
member_info = g.member_info
order_sn = req['order_sn'] if 'order_sn' in req else ''
act = req['act'] if 'act' in req else ''
pay_order_info = PayOrder.query.filter_by(order_sn=order_sn, member_id=member_info.id).first()
if not pay_order_info:
resp['code'] = -1
resp['msg'] = "系统繁忙。请稍后再试"
return jsonify(resp)
if act == "cancel":
target_pay = PayService()
ret = target_pay.closeOrder(pay_order_id=pay_order_info.id)
if not ret:
# return some error
resp['code'] = -1
resp['msg'] = "系统繁忙。请稍后再试"
return jsonify(resp)
elif act == "confirm":
pay_order_info.express_status = 1
pay_order_info.updated_time = getCurrentDate()
db.session.add(pay_order_info)
db.session.commit()
return jsonify(resp)
def ops():
resp = {'code': 200, 'msg': '操作成功', 'data': {}}
req = request.values
id = req['id'] if 'id' in req else 0
act = req['act'] if 'act' in req else ''
#校验
if not id:
resp['code'] = -1
resp['msg'] = "请选择要操作的账户"
return jsonify(resp)
if act not in ['remove', 'recover']:
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)
#操作
if act == "remove":
member_info.status = 0
elif act == "recover":
member_info.status = 1
#更新数据库
member_info.updated_time = getCurrentDate()
db.session.add(member_info)
db.session.commit()
return jsonify(resp)
def ops():
resp = {'code': 200, 'msg': '操作成功', 'data': ''}
req = request.values
id = req['id'] if 'id' in req else 0
act = req['act'] if 'act' in req else ''
if not id:
resp['code'] = -1
resp['msg'] = "请选择要操作的菜品"
return jsonify(resp)
if act not in ['remove', 'recover']:
resp['code'] = -1
resp['msg'] = "操作有误，请重试"
return jsonify(resp)
people_info = People.query.filter_by(id=id).first()
if not people_info:
resp['code'] = -1
resp['msg'] = "指定人员不存在，请重试"
return jsonify(resp)
if act == "remove":
people_info.status = 0
elif act == "recover":
people_info.status = 1
# 提交信息
people_info.update_time = getCurrentDate()
db.session.add(people_info)
db.session.commit()
return jsonify(resp)
def ops():
resp = {"code": 200, "msg": "操作成功~", "data": {}}
req = request.values
id = req["id"] if "id" in req else 0
act = req["act"] if "act" in req else ""
if not id:
resp["code"] = -1
resp["msg"] = "请选择要操作的账号~~"
return jsonify(resp)
if act not in ["remove", "recover"]:
resp["code"] = -1
resp["msg"] = "操作有误，请重试~~"
return jsonify(resp)
food_info = Food.query.filter_by(id=id).first()
if not food_info:
resp["code"] = -1
resp["msg"] = "指定美食不存在~~"
return jsonify(resp)
if act == "remove":
food_info.status = 0
resp["msg"] = "美食删除~~"
else:
food_info.status = 1
resp["msg"] = "美食恢复~~"
food_info.update_time = getCurrentDate()
db.session.add(food_info)
db.session.commit()
return jsonify(resp)
def ops():
req = request.values
resp = {'code':200,'msg':'操作成功','data':{}}
id = req['id'] if 'id' in req else ''
act = req['act'] if 'act' in req else ''
if not id:
resp['code'] = -1
resp['msg'] = '请选择要操作的账号~~'
return jsonify(resp)
if act not in ['remove','recover']:
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)
if act == 'remove':
member_info.status = 0
elif act == 'recover':
member_info.status = 1
member_info.updated_time = getCurrentDate()
db.session.add(member_info)
db.session.commit()
return jsonify(resp)
def ops():
resp = {'code': 200, 'msg': '操作成功', 'data': {}}
req = request.values
id = req['id'] if 'id' in req else 0
act = req['act'] if 'act' in req else ''
# app.logger.info(type(id))
if not id:
resp['code'] = -1
resp['msg'] = "请选择要操作的帐户"
return jsonify(resp)
if act not in ['remove', 'recover']:
resp['code'] = -1
resp['msg'] = "操作有误，请重试!"
return jsonify(resp)
user_info = User.query.filter_by(uid=id).first()
if not user_info:
resp['code'] = -1
resp['msg'] = "指定帐户不存在"
return jsonify(resp)
if act == 'remove':
user_info.status = 0
elif act == 'recover':
user_info.status = 1
user_info.updated_time = getCurrentDate()
db.session.add(user_info)
db.session.commit()
return jsonify(resp)
def ops():
resp = {'code': 200, 'msg': '操作成功~~', 'data': {}}
req = request.values
id = req['id'] if 'id' in req else 0
act = req['act'] if 'act' in req else ''
if not id:
resp['code'] = -1
resp['msg'] = "请选择要操作的货物~~"
return jsonify(resp)
if act not in ['remove', 'recover']:
resp['code'] = -1
resp['msg'] = "操作有误，请重试~~"
return jsonify(resp)
goods_info = Goods.query.filter_by(id=id).first()
if not goods_info:
resp['code'] = -1
resp['msg'] = "货物不存在~~"
return jsonify(resp)
if act == "remove":
goods_info.is_delete = 1
elif act == "recover":
goods_info.is_delete = 0
goods_info.updated_time = getCurrentDate()
db.session.add(goods_info)
db.session.commit()
return jsonify(resp)
def ops():
resp = {'code': 200, 'msg': '操作成功~~', 'data': {}}
req = request.values
id = req['id'] if 'id' in req else 0
act = req['act'] if 'act' in req else ''
if not id:
resp['code'] = -1
resp['msg'] = "请选择要操作的账号~~"
return jsonify(resp)
if act not in ['remove', 'recover']:
resp['code'] = -1
resp['msg'] = "操作有误，请重试~~"
return jsonify(resp)
food_info = Food.query.filter_by(id=id).first()
if not food_info:
resp['code'] = -1
resp['msg'] = "指定美食不存在~~"
return jsonify(resp)
if act == "remove":
food_info.status = 0
elif act == "recover":
food_info.status = 1
food_info.updated_time = getCurrentDate()
db.session.add(food_info)
db.session.commit()
return jsonify(resp)
def uploadByFile( file ):
config_upload = app.config['UPLOAD']
resp = { 'code':200,'msg':'操作成功~~','data':{} }
filename = file.filename
ext = filename.rsplit(".",1)[1]
if ext not in config_upload['ext']:
resp['code'] = -1
resp['msg'] = "不允许的扩展类型文件"
return resp
root_path = app.root_path + config_upload['prefix_path']
#不使用getCurrentDate创建目录，为了保证其他写的可以用，这里改掉，服务器上好像对时间不兼容
file_dir = datetime.datetime.now().strftime("%Y%m%d")
save_dir = root_path + file_dir
if not os.path.exists( save_dir ):
os.mkdir( save_dir )
os.chmod( save_dir,stat.S_IRWXU | stat.S_IRGRP | stat.S_IRWXO )
file_name = str( uuid.uuid4() ).replace("-","") + "." + ext
file.save( "{0}/{1}".format( save_dir,file_name ) )
model_image = Image()
model_image.file_key = file_dir + "/" + file_name
model_image.created_time = getCurrentDate()
db.session.add( model_image)
db.session.commit()
resp['data'] = {
'file_key': model_image.file_key
}
return resp
def login():
resp = {'code': 200, 'msg': '操作成功~', 'data': {}}
req = request.values
code = req['code'] if 'code' in req else ''
if not code or len(code) < 1:
resp['code'] = -1
resp['msg'] = "需要code"
return jsonify(resp)
openid = MemberService.getWeChatOpenId(code)
if openid is None:
resp['code'] = -1
resp['msg'] = "调用微信出错"
return jsonify(resp)
nickname = req['nickName'] if 'nickName' in req else ''
sex = req['gender'] if 'gender' in req else 0
avatar = req['avatarUrl'] if 'avatarUrl' in req else ''
'''
判断是否已经测试过，注册了直接返回一些信息
'''
bind_info = OauthMemberBind.query.filter_by(openid=openid, type=1).first()
if not bind_info:
model_member = Member()
model_member.nickname = nickname
model_member.sex = sex
model_member.avatar = avatar
model_member.salt = MemberService.geneSalt()
model_member.updated_time = model_member.created_time = getCurrentDate(
)
db.session.add(model_member)
db.session.commit()
model_bind = OauthMemberBind()
model_bind.member_id = model_member.id
model_bind.type = 1
model_bind.openid = openid
model_bind.extra = ''
model_bind.updated_time = model_bind.created_time = getCurrentDate()
db.session.add(model_bind)
db.session.commit()
bind_info = model_bind
member_info = Member.query.filter_by(id=bind_info.member_id).first()
token = "%s#%s" % (MemberService.geneAuthCode(member_info), member_info.id)
resp['data'] = {'token': token}
return jsonify(resp)
def kaodianSet():
if request.method == "GET":
resp_data = {}
req = request.args # 参数少时用args
id = int(req.get("id", 0)) # 获取当前id
info = None
if id: # 如果uid存在,说明进入的是编辑页面，否则进入的是新增页面
info = Kaodian.query.filter_by(id=id).first() # 前端页面显示当前用户信息
resp_data['info'] = info # 把当前登录账户信息返回前端显示
resp_data['current'] = 'cat'
return ops_render( "exam/kaodian_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
name = req['name'] if 'name' in req else ''
address = req['address'] if 'address' in req else ''
tel = req['tel'] if 'tel' in req else ''
linkman = req['linkman'] if 'linkman' in req else ''
kaochang = int(req['kaochang']) if ('kaochang' in req and int(req['kaochang']) > 0) else 1
# 参数有效性判断
if name is None or len(name) < 1:
resp['code'] = -1
resp['msg'] = "请输入符合规范的考点名称"
return jsonify(resp)
kaodian_info = Kaodian.query.filter_by(id=id).first()
if kaodian_info: # 进入的是编辑功能
model_kaodian_info = kaodian_info
else: # 进入的是新增功能
model_kaodian_info = Kaodian()
model_kaodian_info.created_time = getCurrentDate()
model_kaodian_info.name = name
model_kaodian_info.address = address
model_kaodian_info.tel = tel
model_kaodian_info.linkman = linkman
model_kaodian_info.kaochang = kaochang
model_kaodian_info.updated_time = getCurrentDate()
# 提交信息
db.session.add( model_kaodian_info )
db.session.commit()
return jsonify( resp )
def login():
resp = {"code": 200, "msg": "操作成功~", "data": {}}
req = request.values
code = req["code"] if "code" in req else ""
if not code or len(code) < 1:
resp["code"] = -1
resp["msg"] = "需要code~~"
return jsonify(resp)
openid = MemberService.getWeChatOpenId(code)
if openid is None:
resp["code"] = -1
resp["msg"] = "调用微信出错"
return jsonify(resp)
nickname = req["nickName"] if "nickName" in req else ""
sex = req["gender"] if "gender" in req else 0
avatar = req["avatarUrl"] if "avatarUrl" in req else ""
# 判断是否已经注册过，注册了直接返回信息
bind_info = OauthMemberBind.query.filter_by(openid=openid, type=1).first()
if not bind_info:
model_member = Member()
model_member.nickname = nickname
model_member.sex = sex
model_member.avatar = avatar
model_member.salt = MemberService.geneSalt()
model_member.created_time = model_member.updated_time = getCurrentDate(
)
db.session.add(model_member)
db.session.commit()
model_bind = OauthMemberBind()
model_bind.member_id = model_member.id
model_bind.type = 1
model_bind.openid = openid
model_bind.extra = ""
model_bind.created_time = model_bind.updated_time = getCurrentDate()
db.session.add(model_bind)
db.session.commit()
bind_info = model_bind
member_info = Member.query.filter_by(id=bind_info.member_id).first()
token = "%s#%s" % (MemberService.geneAuthCode(member_info), member_info.id)
resp["data"] = {"token": token}
return jsonify(resp)
def orderSuccess(self, pay_order_id=0, params=None):
'''
订单付款成功后的操作
status 变为1 支付成功
express_status 为-7 付款待发货
改变销售订单
:param pay_order_id:
:param params:
:return:
'''
try:
pay_order_info = PayOrder.query.filter(id=pay_order_id).first()
if not pay_order_info or pay_order_info.status not in [-8, -7]:
return False
pay_order_info.pay_sn = params[
'pay_sn'] if params and 'pay_sn' in params else ''
pay_order_info.status = 1
pay_order_info.express_status = -7
pay_order_info.pay_time = getCurrentDate()
pay_order_info.updated_time = getCurrentDate
db.session.add(pay_order_info)
# 插入售卖记录 进行统计
pay_order_items = PayOrderItem.query.filter_by(
pay_order_id=pay_order_id).all()
for order_item in pay_order_items:
tmp_model_sale_log = FoodSaleChangeLog()
tmp_model_sale_log.id = order_item.food_id
tmp_model_sale_log.quantity = order_item.quantity
tmp_model_sale_log.price = order_item.price
tmp_model_sale_log.member_id = order_item.member_id
tmp_model_sale_log.created_time = getCurrentDate()
db.session.add(tmp_model_sale_log)
db.session.commit()
except Exception as e:
db.session.rollback()
return False
QueueService.addQueue(
"pay", {
"member_id": pay_order_info.member_id,
"pay_order_id": pay_order_info.id,
})
def statSite(self,params):
act = params['act']
date = params['date']
date_from = params['date_from']
date_to = params['date_to']
app.logger.info( "act:{0},from:{1},to:{2}".format( act,date_from,date_to ) )
stat_pay = db.session.query(func.sum(PayOrder.total_price).label("total_pay_money")) \
.filter(PayOrder.status == 1) \
.filter(PayOrder.created_time >= date_from, PayOrder.created_time <= date_to).first()
stat_member_count = Member.query.count()
stat_new_member_count = Member.query.filter(Member.created_time >= date_from,
Member.created_time <= date_to).count()
stat_order_count = PayOrder.query.filter_by( status = 1 )\
.filter(PayOrder.created_time >= date_from, PayOrder.created_time <= date_to)\
.count()
stat_share_count = WxShareHistory.query.filter(WxShareHistory.created_time >= date_from
, WxShareHistory.created_time <= date_to).count()
tmp_stat_site = StatDailySite.query.filter_by(date=date).first()
if tmp_stat_site:
tmp_model_stat_site = tmp_stat_site
else:
tmp_model_stat_site = StatDailySite()
tmp_model_stat_site.date = date
tmp_model_stat_site.created_time = getCurrentDate()
tmp_model_stat_site.total_pay_money = stat_pay[ 0 ] if stat_pay[ 0 ] else 0.00
tmp_model_stat_site.total_new_member_count = stat_new_member_count
tmp_model_stat_site.total_member_count = stat_member_count
tmp_model_stat_site.total_order_count = stat_order_count
tmp_model_stat_site.total_shared_count = stat_share_count
tmp_model_stat_site.updated_time = getCurrentDate()
'''
为了测试效果模拟数据
'''
tmp_model_stat_site.total_pay_money = random.randint(1000, 1010)
tmp_model_stat_site.total_new_member_count = random.randint(50, 100)
tmp_model_stat_site.total_member_count += tmp_model_stat_site.total_new_member_count
tmp_model_stat_site.total_order_count = random.randint(900, 1000)
tmp_model_stat_site.total_shared_count = random.randint(1000, 2000)
db.session.add(tmp_model_stat_site)
db.session.commit()
def cat_set():
if request.method == "GET":
resp_data = {}
req = request.args
id = int(req.get("id", 0))
cat_info =None
if id:
cat_info = FoodCat.query.filter_by(id = id).first()
resp_data['info'] = cat_info
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 ''
name = req['name'] if 'name' in req else ''
weight = int(req['weight']) if 'weight' in req else 0
if name is None or len(name) < 1:
resp['code'] = -1
resp['msg'] = '分类名称填写不正确'
return jsonify(resp)
if weight is None or weight < 1:
resp['code'] = -1
resp['msg'] = '权重填写不正确'
return jsonify(resp)
food_info = FoodCat.query.filter_by(id = id).first()
if food_info:
model_food = food_info
else:
model_food = FoodCat()
model_food.name = name
model_food.weight = weight
model_food.updated_time = getCurrentDate()
model_food.created_time = getCurrentDate()
db.session.add(model_food)
db.session.commit()
return jsonify(resp)
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
food_cat_info = FoodCat.query.filter_by(id=id).first() # 获取uid，判断是否存在，存在是更新，否则就新增
if name is None or len(name) < 1: # 判断用户名长度
resp['code'] = -1
resp['msg'] = "请输入符合规范的分类名称"
return jsonify(resp)
if weight is None or weight < 1: # 判断邮箱长度
resp['code'] = -1
resp['msg'] = '请输入符合规范的权重，并且至少要大于1'
return jsonify(resp)
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 memberBind():
resp = {'code': 200, 'msg': '操作成功~', 'data': {}}
req = request.values
# 获取member信息
auth_cookie = request.headers.get("Authorization")
if auth_cookie is None:
return False
auth_info = auth_cookie.split("#")
if len(auth_info) != 2:
return False
member_id = auth_info[1]
# 获取绑定信息
try:
bind_info = MemberPeopleBind.query.filter_by(
member_id=member_id).first()
except Exception:
return False
if bind_info:
resp['code'] = -1
resp['msg'] = "当前微信已绑定，不要重复绑定"
return jsonify(resp)
# 人员信息
people_name = req['name'] if 'name' in req else ''
people_info = People.query.filter_by(name=people_name).first()
if not people_info:
resp['code'] = -1
resp['msg'] = "当前姓名不存在，请联系系统管理员录入"
return jsonify(resp)
bind_info = MemberPeopleBind() # 实例化新的绑定关系对象
bind_info.member_id = member_id
bind_info.people_id = people_info.id
bind_info.beizhu1 = people_name
bind_info.created_time = getCurrentDate()
bind_info.updated_time = getCurrentDate()
# 提交信息
try:
db.session.add(bind_info)
db.session.commit()
except Exception as e:
print(e)
resp['code'] = -1
resp['msg'] = "提交数据库出错"
db.session.rollback()
return jsonify(resp)
