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)