def foodInfo(): resp = {'code': 200, 'msg': '操作成功~', 'data': {}} req = request.values id = int(req['id']) if 'id' in req else 0 food_info = Food.query.filter_by(id=id).first() print('food_info', food_info.id) if not food_info or not food_info.status: resp['code'] = -1 resp['msg'] = "美食已下架" return jsonify(resp) member_info = g.member_info cart_number = 0 if member_info: membercart_obj = MemberCart.query.filter_by( member_id=member_info.id, food_id=food_info.id).first() if membercart_obj: cart_number = membercart_obj.quantity else: cart_number = 0 resp['data']['info'] = { "id": food_info.id, "name": food_info.name, "summary": food_info.summary, "total_count": food_info.total_count, "comment_count": food_info.comment_count, 'main_image': UrlManager.buildImage(food_info.main_image), "price": str(food_info.price), "stock": food_info.stock, "pics": [UrlManager.buildImage(food_info.main_image)] } resp['data']['cart_number'] = cart_number return jsonify(resp)
def cartIndex(): resp = {'code': 200, 'msg': '添加购物车成功~', 'data': {}} member_info = g.member_info if not member_info: resp['code'] = -1 resp['msg'] = "获取失败,伪登录~~" return jsonify(resp) cart_list = MemberCart.query.filter_by(member_id=member_info.id).all() data_cart_list = [] if cart_list: food_ids = selectFilterObj(cart_list, "food_id") food_map = getDictFilterField(Food, Food.id, "id", food_ids) for item in cart_list: tmp_food_info = food_map[item.food_id] tmp_data = { "id": item.id, "number": item.quantity, "food_id": item.food_id, "name": tmp_food_info.name, "price": str(tmp_food_info.price), "pic_url": UrlManager.buildImage(tmp_food_info.main_image), "active": True } data_cart_list.append(tmp_data) resp['data']['list'] = data_cart_list return jsonify(resp)
def foodIndex(): resp = {'code': 200, 'msg': '操作成功~', 'data': {}} cat_list = FoodCat.query.filter_by(status=1).order_by( FoodCat.weight.desc()).all() data_cat_list = [] data_cat_list.append({'id': 0, 'name': "全部"}) if cat_list: for item in cat_list: tmp_data = {'id': item.id, 'name': item.name} data_cat_list.append(tmp_data) resp['data']['cat_list'] = data_cat_list food_list = Food.query.filter_by(status=1) \ .order_by(Food.total_count.desc(), Food.id.desc()).limit(3).all() data_food_list = [] if food_list: for item in food_list: tmp_data = { 'id': item.id, 'pic_url': UrlManager.buildImage(item.main_image) } data_food_list.append(tmp_data) resp['data']['banner_list'] = data_food_list return jsonify(resp)
def orderInfo(): resp = {'code': 200, 'msg': '操作成功~', 'data': {}} req = request.values params_goods = req['goods'] if 'goods' in req else None member_info = g.member_info params_goods_list = [] if params_goods: params_goods_list = json.loads(params_goods) food_dic = {} for item in params_goods_list: food_dic[item['id']] = item['number'] food_ids = food_dic.keys() food_list = Food.query.filter(Food.id.in_(food_ids)).all() data_food_list = [] yun_price = pay_price = decimal.Decimal(0.00) if food_list: for item in food_list: tmp_data = { "id": item.id, "name": item.name, "price": str(item.price), 'pic_url': UrlManager.buildImage(item.main_image), 'number': food_dic[item.id] } pay_price = pay_price + item.price * int(food_dic[item.id]) data_food_list.append(tmp_data) # 获取地址 address_info = MemberAddress.query.filter_by(is_default=1, member_id=member_info.id, status=1).first() default_address = '' if address_info: default_address = { "id": address_info.id, "name": address_info.nickname, "mobile": address_info.mobile, "address": "%s%s%s%s" % (address_info.province_str, address_info.city_str, address_info.area_str, address_info.address) } resp['data']['food_list'] = data_food_list resp['data']['pay_price'] = str(pay_price) resp['data']['yun_price'] = str(yun_price) resp['data']['total_price'] = str(pay_price + yun_price) resp['data']['default_address'] = default_address print('default_address', default_address) return jsonify(resp)
def myOrderInfo(): resp = {'code': 200, 'msg': '操作成功~', 'data': {}} member_info = g.member_info req = request.values order_sn = req['order_sn'] if 'order_sn' in req else '' pay_order_info = PayOrder.query.filter_by(member_id=member_info.id, order_sn=order_sn).first() if not pay_order_info: resp['code'] = -1 resp['msg'] = "系统繁忙,请稍后再试~~" return jsonify(resp) express_info = {} if pay_order_info.express_info: express_info = json.loads(pay_order_info.express_info) tmp_deadline = pay_order_info.created_time + datetime.timedelta(minutes=30) info = { "order_sn": pay_order_info.order_sn, "status": pay_order_info.pay_status, "status_desc": pay_order_info.status_desc, "pay_price": str(pay_order_info.pay_price), "yun_price": str(pay_order_info.yun_price), "total_price": str(pay_order_info.total_price), "address": express_info, "goods": [], "deadline": tmp_deadline.strftime("%Y-%m-%d %H:%M") } pay_order_items = PayOrderItem.query.filter_by( pay_order_id=pay_order_info.id).all() if pay_order_items: food_ids = selectFilterObj(pay_order_items, "food_id") food_map = getDictFilterField(Food, Food.id, "id", food_ids) for item in pay_order_items: tmp_food_info = food_map[item.food_id] tmp_data = { "name": tmp_food_info.name, "price": str(item.price), "unit": item.quantity, "pic_url": UrlManager.buildImage(tmp_food_info.main_image), } info['goods'].append(tmp_data) resp['data']['info'] = info return jsonify(resp)
def uploadImage(): # 统一的返回格式 resp = {'state': 'SUCCESS', 'url': '', 'title': '', 'original': ''} file_target = request.files # 取出文件对象 upfile = file_target['upfile'] if 'upfile' in file_target else None if upfile is None: resp['state'] = '上传失败' return jsonify(resp) # 调用保存方法 ret = UploadService.uploadByFile(upfile) if ret['code'] != 200: resp['state'] = '上传失败' + ret['msg'] return jsonify(resp) resp['url'] = ret['data']['file_key'] resp['url'] = UrlManager.buildImage(resp['url']) return jsonify(resp)
def listImage(): resp = {'state': 'SUCCESS', 'list': [], 'start': 0, 'total': 0} req = request.values start = int(req['start']) if 'start' in req else 0 page_size = int(req['size']) if 'size' in req else 20 query = Image.query if start > 0: query = query.filter(Image.id < start) list = query.order_by(Image.id.desc()).limit(page_size).all() images = [] if list: for item in list: images.append({'url': UrlManager.buildImage(item.file_key)}) start = item.id resp['list'] = images resp['start'] = start resp['total'] = len(images) return jsonify(resp)
def foodSearch(): resp = {'code': 200, 'msg': '操作成功~', 'data': {}} req = request.values cat_id = int(req['cat_id']) if 'cat_id' in req else 0 mix_kw = str(req['mix_kw']) if 'mix_kw' in req else '' p = int(req['p']) if 'p' in req else 1 if p < 1: p = 1 page_size = 10 offset = (p - 1) * page_size query = Food.query.filter_by(status=1) if cat_id > 0: query = query.filter_by(cat_id=cat_id) if mix_kw: rule = or_(Food.name.ilike("%{0}%".format(mix_kw)), Food.tags.ilike("%{0}%".format(mix_kw))) query = query.filter(rule) food_list = query.order_by(Food.total_count.desc(), Food.id.desc()) \ .offset(offset).limit(page_size).all() print('food_list', food_list) data_food_list = [] if food_list: for item in food_list: tmp_data = { 'id': item.id, 'name': "%s" % (item.name), 'price': str(item.price), 'min_price': str(item.price), 'pic_url': UrlManager.buildImage(item.main_image) } data_food_list.append(tmp_data) resp['data']['list'] = data_food_list resp['data']['has_more'] = 0 if len(data_food_list) < page_size else 1 return jsonify(resp)
def myOrderList(): resp = {'code': 200, 'msg': '操作成功~', 'data': {}} member_info = g.member_info req = request.values status = int(req['status']) if 'status' in req else 0 query = PayOrder.query.filter_by(member_id=member_info.id) if status == -8: # 等待付款 query = query.filter(PayOrder.status == -8) elif status == -7: # 待发货 query = query.filter(PayOrder.status == 1, PayOrder.express_status == -7, PayOrder.comment_status == 0) elif status == -6: # 待确认 query = query.filter(PayOrder.status == 1, PayOrder.express_status == -6, PayOrder.comment_status == 0) elif status == -5: # 待评价 query = query.filter(PayOrder.status == 1, PayOrder.express_status == 1, PayOrder.comment_status == 0) elif status == 1: # 已完成 query = query.filter(PayOrder.status == 1, PayOrder.express_status == 1, PayOrder.comment_status == 1) else: query = query.filter(PayOrder.status == 0) pay_order_list = query.order_by(PayOrder.id.desc()).all() print('pay_order_list', pay_order_list) data_pay_order_list = [] if pay_order_list: pay_order_ids = selectFilterObj(pay_order_list, "id") pay_order_item_list = PayOrderItem.query.filter( PayOrderItem.pay_order_id.in_(pay_order_ids)).all() food_ids = selectFilterObj(pay_order_item_list, "food_id") food_map = getDictFilterField(Food, Food.id, "id", food_ids) pay_order_item_map = {} if pay_order_item_list: for item in pay_order_item_list: if item.pay_order_id not in pay_order_item_map: pay_order_item_map[item.pay_order_id] = [] tmp_food_info = food_map[item.food_id] pay_order_item_map[item.pay_order_id].append({ 'id': item.id, 'food_id': item.food_id, 'quantity': item.quantity, 'price': str(item.price), 'pic_url': UrlManager.buildImage(tmp_food_info.main_image), 'name': tmp_food_info.name }) for item in pay_order_list: tmp_data = { 'status': item.pay_status, 'status_desc': item.status_desc, 'date': item.created_time.strftime("%Y-%m-%d %H:%M:%S"), 'order_number': item.order_number, 'order_sn': item.order_sn, 'note': item.note, 'total_price': str(item.total_price), 'goods_list': pay_order_item_map[item.id] } data_pay_order_list.append(tmp_data) resp['data']['pay_order_list'] = data_pay_order_list return jsonify(resp)