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 mc in MemberCarts:
temp_food = {}
food = Food.query.get(mc.food_id)
if not food or food.status != 1:
continue
temp_food['id'] = mc.id
temp_food['food_id'] = mc.food_id
temp_food['pic_url'] = ww(food.main_image)
temp_food['name'] = food.name
temp_food['price'] = str(food.price)
temp_food['active'] = 'true'
temp_food['number'] = mc.quantity
list.append(temp_food)
totalPrice += mc.quantity * food.price
# 存入在cardService
# totalPrice, list = cardService.list(member)
res['data']['list'] = list
res['data']['totalPrice'] = str(totalPrice)
return jsonify(res)
'''
def info():
res = {'code': 1, 'msg': '成功', 'data': {}}
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)
'''
//"id": e.id,
// "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'] = ww(food.main_image)
info['pics'] = ww(food.main_image), ww(food.main_image), ww(
food.main_image)
info['data']['info'] = info
'''
一个商品对应多个图片 图片表
以空间换时间
食品表 图片表
'''
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['oder_sn'] = payorder.oder_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'] = ww(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 zhanshi():
res = {'code': 1, 'msg': '成功', 'data': {}}
try:
cid = request.args.get('cid')
page = request.args.get('page')
print(cid)
if not cid:
cid = '0'
if not page:
page = '1'
cid = int(cid)
page = int(page)
'''
每页一个数据
'''
pagesize = 1
# 分页公式
offset = (page - 1) * pagesize
goods = []
query = Food.query.filter_by(status=1)
print('经过')
if cid == 0:
foods = query.offset(offset).limit(pagesize).all()
print(len(foods))
else:
foods = query.filter_by(
cat_id=cid).offset(offset).limit(pagesize).all()
print(len(foods), '22222')
# print('我也来过')
for food in foods:
zs = {}
zs['id'] = food.id
zs["name"] = food.name
zs["min_price"] = str(food.price)
zs["price"] = str(food.price)
zs['pic_url'] = ww(food.main_image)
goods.append(zs)
res['data']['goods'] = goods
# 判断有没有数据，有数据返回1 没数据返回0
if len(foods) < 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 commit():
res = {'code': 1, 'msg': '成功', 'data': {}}
# 接收参数,商品的ids
ids = request.form.get('ids')
ids = json.loads(ids)
type = request.form.get('type')
num = request.form.get('num')
member = g.member
if not member:
res['code'] = -1
res['msg'] = "用户不存在"
return jsonify(res)
goods_list = []
default_address = {}
total_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['number'] = membercart.quantity
temp_data['pic_url'] = ww(food.main_image)
goods_list.append(temp_data)
total_price += food.price * membercart.quantity
# for id in ids:
# temp_data = {}
# food = Food.query.get(id)
# temp_data['id'] = id
# temp_data['name'] = food.name
# temp_data['number'] = int(num)
# temp_data['pic_url'] = ww(food.main_image)
# goods_list.append(temp_data)
# total_price += food.price * int(num)
memberaddress = MemberAddress.query.filter_by(is_default=1).first()
# 地址
default_address['id'] = memberaddress.id
default_address["name"] = memberaddress.nickname
default_address["mobile"] = memberaddress.mobile
default_address["detail"] = memberaddress.address
# total_price = yun_orice + pay_price
res['data']['goods_list'] = goods_list
res['data']['total_price'] = str(total_price)
res['data']['default_address'] = default_address
return jsonify(res)
def list(member):
MemberCarts = MemberCart.query.filter_by(member_id=member.id).all()
list = []
totalPrice = 0
for mc in MemberCarts:
temp_food = {}
food = Food.query.get(mc.food_id)
if not food or food.status != 1:
continue
temp_food['id'] = mc.id
temp_food['food_id'] = mc.food_id
temp_food['pic_url'] = ww(food.main_image)
temp_food['name'] = food.name
temp_food['price'] = str(food.price)
temp_food['active'] = 'true'
temp_food['number'] = mc.quantity
list.append(temp_food)
totalPrice += mc.quantity * food.price
return list, totalPrice
def foods():
res = {'code': 1, 'msg': '成功', 'data': {}}
categories = []
categories.append({'id': 0, 'name': "all"})
all_category = Category.query.filter_by(status=1).order_by(
Category.weight.desc()).all()
for category in all_category:
item_data = {}
item_data['id'] = category.id
item_data['name'] = category.name
categories.append(item_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'] = ww(food.main_image)
banners.append(temp_data)
res['data']['categories'] = categories
res['data']['banners'] = banners
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)
'''
goods_list: [
{
id: 22,
name: "小鸡炖蘑菇",
price: "85.00",
pic_url: "/images/food.jpg",
number: 1,
},
{
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 = []
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'] = ww(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)
