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)