def info():
res = {'code': 1, 'msg': '成功', 'data': {}}
try:
id = request.args.get('id')
if not id:
res['code'] = -1
res['msg'] = '参数不能为空'
return jsonify(res)
id = int(id)
if id <= 0:
res['code'] = -1
res['msg'] = '参数有误'
return jsonify(res)
# """
# "info": {
# "id": 1,
# "name": "小鸡炖蘑菇",
# "summary": '<p>多色可选的马甲</p><p><img src="http://www.timeface.cn/uploads/times/2015/07/071031_f5Viwp.jpg"/></p><p><br/>相当好吃了</p>',
# "total_count": 2,
# "comment_count": 2,
# "stock": 2,
# "price": "80.00",
# "main_image": "/images/food.jpg",
# "pics": ['/images/food.jpg', '/images/food.jpg']
# },
# """
food = Food.query.get(id)
info = {}
info['id'] = food.id
info['name'] = food.name
info['summary'] = food.summary
info['total_count'] = food.total_count
info['comment_count'] = food.comment_count
info['stock'] = food.stock
info['price'] = str(food.price)
info['main_image'] = buildPicUrl(food.main_image)
info['pics'] = [
buildPicUrl(food.main_image),
buildPicUrl(food.main_image),
buildPicUrl(food.main_image)
]
res['data']['info'] = info
# """
# 一个商品对应多个图片 图片表
# 以空间换时间
# """
return jsonify(res)
except Exception as e:
res['code'] = -1
res['msg'] = '参数错误'
return jsonify(res)
def list():
res = {'code': 1, 'msg': '成功', 'data': {}}
status = request.args.get('status')
member = g.member
if not member:
res['code'] = -1
res['msg'] = '用户不存在'
return jsonify(res)
order_list = []
payorders = PayOrder.query.filter_by(member_id=member.id,status=status).all()
for payorder in payorders:
temp_data = {}
temp_data['status'] = payorder.status
temp_data['status_desc'] = payorder.status_desc
temp_data['date'] = payorder.create_time.strftime('%Y-%m-%d %H:%M:%S')
temp_data['note'] = payorder.note
temp_data['total_price'] =str(payorder.total_price)
temp_data['order_number'] = payorder.create_time.strftime('%Y%m%d%H%M%S')+str(payorder.id).zfill(5)
goods_list =[]
payorderitems = PayOrderItem.query.filter_by(pay_order_id=payorder.id).all()
for payorderitme in payorderitems:
food = Food.query.get(payorderitme.food_id)
temp_food = {}
temp_food['pic_url'] = buildPicUrl(food.main_image)
goods_list.append(temp_food)
temp_data['goods_list'] = goods_list
order_list.append(temp_data)
res['data']['order_list'] = order_list
return jsonify(res)
def list():
res = {'code': 1, 'msg': '成功', 'data': {}}
member = g.member
if not member:
res['code'] = -1
res['msg'] = '用户不存在'
return jsonify(res)
membercarts = MemberCart.query.filter_by(member_id=member.id).all()
list = []
totalPrice = 0
for cart in membercarts:
temp_food = {}
food = Food.query.get(cart.food_id)
if not food:
continue
if food.status != 1:
continue
temp_food['id'] = cart.id
temp_food['food_id'] = food.id
temp_food['pic_url'] = buildPicUrl(food.main_image)
temp_food['name'] = food.name
temp_food['price'] = str(food.price)
temp_food['active'] = 'true'
temp_food['number'] = cart.quantity
list.append(temp_food)
totalPrice += cart.quantity * food.price
res['data']['list'] = list
res['data']['totalPrice'] = str(totalPrice)
return jsonify(res)
def list():
res = {'code': 1, 'msg': '成功', 'data': {}}
'''
order_list: [
{
status: -8,
status_desc: "待支付",
date: "2018-07-01 22:30:23",
order_number: "20180701223023001",
note: "记得周六发货",
total_price: "85.00",
goods_list: [
{
pic_url: "/images/food.jpg"
},
{
pic_url: "/images/food.jpg"
}
]
}
]
'''
status = request.args.get('status')
member = g.member
if not member:
res['code'] = -1
res['msg'] = '用户不存'
return jsonify(res)
# 1 ---> 00001
order_list = []
payorders = PayOrder.query.filter_by(member_id=member.id,
status=status).all()
for payorder in payorders:
temp_data = {}
temp_data['status'] = payorder.status
temp_data['status_desc'] = payorder.status_desc
temp_data['date'] = payorder.create_time.strftime('%Y-%m-%d %H:%M:%S')
temp_data['note'] = payorder.note
temp_data['total_price'] = str(payorder.total_price)
temp_data['order_sn'] = payorder.order_sn
temp_data['order_number'] = payorder.create_time.strftime(
'%Y%m%d%H%M%S') + str(payorder.id).zfill(5)
goods_list = []
# 查订单商品
payorderitems = PayOrderItem.query.filter_by(
pay_order_id=payorder.id).all()
for payorderitem in payorderitems:
food = Food.query.get(payorderitem.food_id)
temp_food = {}
temp_food['pic_url'] = buildPicUrl(food.main_image)
goods_list.append(temp_food)
temp_data['goods_list'] = goods_list
order_list.append(temp_data)
res['data']['order_list'] = order_list
return jsonify(res)
def all():
res = {'code': 1, 'msg': '成功', 'data': {}}
try:
cid = request.args.get('cid')
page = request.args.get('page')
#如果没传id 就设置这个
if not cid:
cid = '0'
if not page:
page = '1'
#如果传字符串就设置这个
cid = int(cid)
page = int(page)
"""
每页1个
"""
pagesize = 1
# offset偏移量公式
offset = (page - 1) * pagesize
goods = []
query = Food.query.filter_by(status=1)
if cid == 0:
foods = query.offset(offset).limit(pagesize).all()
else:
foods = query.filter_by(
cat_id=cid).offset(offset).limit(pagesize).all()
for food in foods:
temp_food = {}
temp_food['id'] = food.id
temp_food['name'] = food.name
temp_food['min_price'] = str(food.price)
temp_food['price'] = str(food.price)
temp_food['pic_url'] = buildPicUrl(food.main_image)
goods.append(temp_food)
res['data']['goods'] = goods
#是否还有数据
if len(foods) < pagesize:
res['data']['ismore'] = 0
else:
res['data']['ismore'] = 1
# time.sleep(10)
return jsonify(res)
except Exception as e:
res['code'] = -1
res['msg'] = '参数错误'
return jsonify(res)
def commit():
res = {'code': 1, 'msg': 'success', 'data': {}}
# 接受前端传递的ids
ids = request.form.get('ids')
ids = json.loads(ids) # 转成列表
if not ids:
res['code'] = -1
res['msg'] = '参数不全'
return jsonify(res)
# 验证登陆
member = g.member
if not member:
res['code'] = -1
res['msg'] = '请先登陆'
return jsonify(res)
goods_list = [] # 商品
yun_price = 0 # 运费
pay_price = 0 # 商品金额
for id in ids:
temp_data = {}
# pycharm大写改小写ctrl+shift+u
membercart = MemberCart.query.filter_by(member_id=member.id, food_id=id).first()
food = Food.query.get(id)
temp_data['id'] = id
temp_data['name'] = food.name
temp_data['price'] = str(food.price)
temp_data['pic_url'] = buildPicUrl(food.main_image)
temp_data['number'] = membercart.quantity
goods_list.append(temp_data)
pay_price += food.price * membercart.quantity
# 查询会员的默认地址
# 查询条件有两个 1.当前会员的id 数据库中相对应的默认地址isdefault=1
memberaddress = MemberAddress.query.filter_by(member_id=member.id, is_default=1).first()
default_address = {}
# ctrl+D复制当前行到下一行
default_address['id'] = memberaddress.id
default_address['nickname'] = memberaddress.nickname
default_address['mobile'] = memberaddress.mobile
default_address['address'] = memberaddress.showAddress()
# 总价
total_price = yun_price + pay_price
# 数据返回
res['data']['goods_list'] = goods_list
res['data']['default_address'] = default_address
res['data']['yun_price'] = str(yun_price)
res['data']['pay_price'] = str(pay_price)
res['data']['total_price'] = str(total_price)
return jsonify(res)
def info():
res = {'code': 1, 'msg': '成功', 'data': {}}
try:
id = request.args.get('id')
if not id :
res['code'] = -1
res['msg'] = '参数有误'
return jsonify(res)
id = int(id)
if id <= 0:
res['code'] = -1
res['msg'] = '参数有误'
return jsonify(res)
food = Food.query.get(id)
# if not food:
# res['code'] = -1
# res['msg'] = '食品不存在'
# return jsonify(res)
# if food.status != 1:
# res['code'] = -1
# res['msg'] = '食品已下架'
# return jsonify(res)
info = {}
info['id'] = food.id
info['name'] = food.name
info['summary'] = food.summary
info['total_count'] = food.total_count
info['comment_count'] = food.comment_count
info['stock'] = food.stock
info['price'] = str(food.price)
info['main_image'] = buildPicUrl(food.main_image)
info['pics'] = [buildPicUrl(food.main_image),buildPicUrl(food.main_image),buildPicUrl(food.main_image)]
res['data']['info'] = info
return jsonify(res)
except Exception as e:
res['code'] = -1
res['msg'] = '参数错误'
return jsonify(res)
def center():
res = {'code': 1, 'msg': '成功', 'data': {}}
ids = request.form.get('ids') # 商品的ids
ids = json.loads(ids) # 转成列表
member = g.member
if not member:
res['code'] = -1
res['msg'] = '用户不存在'
return jsonify(res)
yun_price = 0
pay_price = 0
goods_list = []
for id in ids:
temp_data = {}
membercart = MemberCart.query.filter_by(food_id=id, member_id=member.id).first()
food = Food.query.get(id)
# 可能需要判断商品是否存在和状态
temp_data['id'] = id
temp_data['name'] = food.name
temp_data['price'] = str(food.price)
temp_data['pic_url'] = buildPicUrl(food.main_image)
temp_data['number'] = membercart.quantity
goods_list.append(temp_data)
pay_price += food.price * membercart.quantity
# 查询此会员的默认地址
memberaddress = MemberAddress.query.filter_by(member_id=member.id, is_default=1).first()
# 地址
default_address = {}
default_address['id'] = memberaddress.id
default_address['name'] = memberaddress.nickname
default_address['mobile'] = memberaddress.mobile
default_address['address'] = memberaddress.showAddress()
total_price = yun_price + pay_price
res['data']['goods_list'] = goods_list
res['data']['default_address'] = default_address
res['data']['total_price'] = str(total_price)
res['data']['yun_price'] = str(yun_price)
res['data']['pay_price'] = str(pay_price)
return jsonify(res)
def detail():
res = {'code': 1, 'msg': '成功', 'data': {}}
member = g.member
if not member:
res['code'] = -1
res['msg'] = '该用户不存在'
return jsonify(res)
status = request.args.get('status')
print(
status,
'===================================================================================='
)
ordr_list = []
payorders = PayOrder.query.filter_by(member_id=member.id,
status=status).all()
for payorder in payorders:
temp_data = {}
temp_data['order_sn'] = payorder.order_sn
temp_data['status'] = payorder.status
temp_data['status_desc'] = payorder.status_desc
temp_data['deadline'] = payorder.create_time.strftime(
'%Y-%m-%d %H:%M:%S')
temp_data['pay_price'] = str(payorder.pay_price)
temp_data['yun_price'] = str(payorder.yun_price)
temp_data['total_price'] = str(payorder.total_price)
memberaddress = MemberAddress.query.filter_by(
id=payorder.express_address_id).first()
address = {}
address['name'] = memberaddress.nickname
address['mobile'] = memberaddress.mobile
address['address'] = str(memberaddress.province_str +
memberaddress.city_str +
memberaddress.area_str)
temp_data['address'] = address
goods = []
payorderitems = PayOrderItem.query.filter_by(
pay_order_id=payorder.id).all()
for payorderitem in payorderitems:
food = Food.query.get(payorderitem.food_id)
temp_food = {}
temp_data['name'] = food.name
temp_data['price'] = str(food.price)
temp_data['unit'] = payorderitem.quantity
temp_data['pic_url'] = buildPicUrl(food.main_image)
goods.append(temp_food)
temp_data['goods'] = goods
ordr_list.append(temp_data)
res['data']['order_list'] = ordr_list
return jsonify(res)
def search():
"""
banners: [
{
"id": 1,
"pic_url": "/images/food.jpg"
},
{
"id": 2,
"pic_url": "/images/food.jpg"
},
{
"id": 3,
"pic_url": "/images/food.jpg"
}
],
categories: [
{id: 0, name: "全部"},
{id: 1, name: "川菜"},
{id: 2, name: "东北菜"},
],
:return:
"""
res = {'code': 1, 'msg': '成功', 'data': {}}
categories = []
categories.append({'id': 0, 'name': '全部'})
#根据状态和权重查分类
all_category = Category.query.filter_by(status=1).order_by(
Category.weight.desc()).all()
for category in all_category:
temp_data = {}
temp_data['id'] = category.id
temp_data['name'] = category.name
categories.append(temp_data)
banners = []
foods = Food.query.filter_by(status=1).order_by(
Food.month_count.desc()).limit(3).all()
for food in foods:
temp_data = {}
temp_data['id'] = food.id
temp_data['pic_url'] = buildPicUrl(food.main_image)
banners.append(temp_data)
#创建数据
res['data']['categories'] = categories
res['data']['banners'] = banners
return jsonify(res)
def list():
res = {'code': 1, 'msg': '成功', 'data': {}}
# 验证登陆
member = g.member
if not member:
res['code'] = -1
res['msg'] = '用户不存在'
return jsonify(res)
# status=request.args.get('status')
# print(status,'=========================================================')
# if str(status)=='-8':
# pass
# if str(status)=='-7':
# pass
# if str(status)=='-5':
# pass
# if str(status)=='-1':
# pass
# if str(status)=='-0':
# pass
order_list=[]
# 查询该用户名下的所有订单消息
payorders=PayOrder.query.filter_by(member_id=member.id).all()
for payorder in payorders:
temp_data={}
temp_data['status']=payorder.status
temp_data['status_desc']=payorder.status_desc
temp_data['date']=payorder.create_time.strftime('%Y-%m-%d %H:%M:%S')
temp_data['note']=payorder.note
temp_data['total_price']=str(payorder.total_price)
temp_data['order_number']=payorder.create_time.strftime('%Y-%m-%d %H:%M:%S')+str(payorder.id).zfill(5)
goods_list=[]
# 查看订单商品
payorderitems=PayOrderItem.query.filter_by(pay_order_id=payorder.id).all()
for payorderitem in payorderitems:
food=Food.query.get(payorderitem.food_id)
temp_food={}
temp_food['pic_url']=buildPicUrl(food.main_image)
goods_list.append(temp_food)
temp_data['goods_list']=goods_list
order_list.append(temp_data)
res['data']['order_list']=order_list
return jsonify(res)
def index():
res = {'code': 1, 'msg': '成功', 'data': {}}
ids = request.form.get('ids')
note = request.form.get('note')
member = g.member
if not member:
res['code'] = -1
res['msg'] = '该用户不存在'
return jsonify(res)
ids = json.loads(ids)
goods_list = []
yun_price = 0
pay_price = 0
for id in ids:
temp_data = {}
membercart = MemberCart.query.filter_by(food_id=id,
member_id=member.id).first()
food = Food.query.get(id)
temp_data['id'] = id
temp_data['name'] = food.name
temp_data['price'] = str(food.price)
temp_data['pic_url'] = buildPicUrl(food.main_image)
temp_data['number'] = membercart.quantity
goods_list.append(temp_data)
pay_price += membercart.quantity * food.price
address = MemberAddress.query.filter_by(member_id=member.id,
is_default=1).first()
default_address = {}
default_address['id'] = address.id
default_address['name'] = address.nickname
default_address['mobile'] = address.mobile
default_address['detail'] = str(address.province_str + address.city_str +
address.area_str)
total_price = yun_price + pay_price
res['data']['goods_list'] = goods_list
res['data']['default_address'] = default_address
res['data']['total_price'] = str(total_price)
res['data']['yun_price'] = str(yun_price)
res['data']['pay_price'] = str(pay_price)
return jsonify(res)
def all():
try:
res = {'code': 1, 'msg': '成功', 'data': {}}
cid = request.args.get('cid')
page = request.args.get('page')
cid = int(cid)
if not page:
page = '1'
page = int(page)
pagesize = 2
offset = (page-1) * pagesize
# query= Food.query.filter(Food.status == 1)
#
# if cid == 0 :
# all_good = query.order_by(Food.month_count.desc()).offset(offset).limit(pagesize).all()
# else:
# all_good = query.filter(Food.cat_id == cid).order_by(Food.month_count.desc()).all()
goods = []
query = Food.query.filter_by(status=1)
if cid == 0:
all_good = query.all()
else:
all_good = query.filter_by(cat_id = cid).offset(offset).limit(pagesize).all()
for good in all_good:
temp_data = {}
temp_data['id'] = good.id
temp_data['name'] = good.name
temp_data['min_price'] = str(good.price)
temp_data['price'] = str(good.price)
temp_data['pic_url'] = buildPicUrl(good.main_image)
goods.append(temp_data)
res['data']['goods'] = goods
if len(all_good)< pagesize:
res['data']['ismore'] = 0
else:
res['data']['ismore'] = 1
return jsonify(res)
except Exception as e:
res['code'] = -1
res['msg'] = '参数错误'
return jsonify(res)
def purchase():
res = {'code': 1, 'msg': '成功', 'data': {}}
ids = request.args.get('id')
print('======================================================', ids)
num = request.args.get('num')
print('=======================================================', type(num))
num = int(num)
member = g.member
if not member:
res['code'] = -1
res['msg'] = '该用户不存在'
return jsonify(res)
goods_list = []
yun_price = 0
pay_price = 0
temp_data = {}
# membercart = MemberCart.query.filter_by(food_id=id,member_id=member.id).first()
food = Food.query.get(ids)
temp_data['id'] = ids
temp_data['name'] = food.name
temp_data['price'] = str(food.price)
temp_data['pic_url'] = buildPicUrl(food.main_image)
temp_data['number'] = num
goods_list.append(temp_data)
pay_price += num * food.price
address = MemberAddress.query.filter_by(member_id=member.id,
is_default=1).first()
default_address = {}
default_address['id'] = address.id
default_address['name'] = address.nickname
default_address['mobile'] = address.mobile
default_address['detail'] = address.showAddress()
total_price = yun_price + pay_price
res['data']['goods_list'] = goods_list
res['data']['default_address'] = default_address
res['data']['total_price'] = str(total_price)
res['data']['yun_price'] = str(yun_price)
res['data']['pay_price'] = str(pay_price)
return jsonify(res)
def search():
res = {'code': 1, 'msg': '成功', 'data': {}}
categories = []
categorys = Category.query.filter(Category.status == 1).order_by(
Category.weight.desc()).all()
categories.append({"id": 0, "name": "全部"})
for category in categorys:
temp_data = {}
temp_data['id'] = category.id
temp_data['name'] = category.name
categories.append(temp_data)
res['data']['categories'] = categories
foods = []
all_foods = Food.query.filter(Food.status == 1).order_by(
Food.month_count.desc()).limit(3).all()
for food in all_foods:
temp_data = {}
temp_data['id'] = food.id
temp_data['pic_url'] = buildPicUrl(food.main_image)
foods.append(temp_data)
res['data']['banners'] = foods
return jsonify(res)
def index():
res = {'code': 1, 'msg': '成功', 'data': {}}
ids = request.form.get('ids') # 商品的ids
type = request.form.get('type')
if type == '1':
num = request.form.get('num') # 从立即购买
ids = json.loads(ids) # 转成列表
member = g.member
if not member:
res['code'] = -1
res['msg'] = '用户不存'
return jsonify(res)
'''
goods_list: [
{
id: 22,
name: "小鸡炖蘑菇",
price: "85.00",
pic_url: "/images/food.jpg",
number: 1,
},
default_address: {
name: "编程浪子",
mobile: "12345678901",
detail: "上海市浦东新区XX",
},
yun_price: "1.00",
pay_price: "85.00",
total_price: "86.00",
params: null
'''
yun_price = 0
pay_price = 0
goods_list = []
if type == '0':
for id in ids:
temp_data = {}
membercart = MemberCart.query.filter_by(
food_id=id, member_id=member.id).first()
food = Food.query.get(id)
# 可能需要判断商品是否存在 和状态
temp_data['id'] = id
temp_data['name'] = food.name
temp_data['price'] = str(food.price)
temp_data['pic_url'] = buildPicUrl(food.main_image)
temp_data['number'] = membercart.quantity
goods_list.append(temp_data)
pay_price += food.price * membercart.quantity
else:
for id in ids:
temp_data = {}
food = Food.query.get(id)
# 可能需要判断商品是否存在 和状态
temp_data['id'] = id
temp_data['name'] = food.name
temp_data['price'] = str(food.price)
temp_data['pic_url'] = buildPicUrl(food.main_image)
temp_data['number'] = int(num)
goods_list.append(temp_data)
pay_price += food.price * int(num)
memberaddress = MemberAddress.query.filter_by(member_id=member.id,
is_default=1).first()
# 地址
default_address = {}
default_address['id'] = memberaddress.id
default_address['name'] = memberaddress.nickname
default_address['mobile'] = memberaddress.mobile
default_address['address'] = memberaddress.showAddress()
total_price = yun_price + pay_price
# 查询此会员的默认地址
# 计算总价
res['data']['goods_list'] = goods_list
res['data']['default_address'] = default_address
res['data']['total_price'] = str(total_price)
res['data']['yun_price'] = str(yun_price)
res['data']['pay_price'] = str(pay_price)
# 返回
return jsonify(res)