def recharge_card_list(page=1, page_size=20): """充值卡列表""" g.page_type = 'search' g.title = u'充值卡列表' g.add_new = True g.button_name = u'新增充值卡' param_dict = get_params({'rc_id': int, 'amount': str, 'gift': str}) query_dict = { 'rc_id': param_dict['rc_id'], 'amount': param_dict['amount'], 'gift': param_dict['gift'] } q = RechargeCard.query q = easy_query_filter(RechargeCard, q, query_dict) recharge_card_count = get_count(q) recharge_card_list = q.order_by(RechargeCard.rc_id.desc()).offset((page-1)*page_size).\ limit(page_size).all() pagination = Pagination(None, page, page_size, recharge_card_count, None) res = make_response( render_template('sys/recharge_card_list.html.j2', **locals())) res.set_cookie('goback_url', request.url) return res
def column_save(): """保存商品栏目""" param_dict = get_params({'gc_id':int,'column_name':str,'column_img':None,'status':int,'sort_order':int, 'brief':str}) required_param_list = ['column_name','status'] form = request.form for param in required_param_list: val = request.form.get(param, '') val = val.strip() if not val: errmsg[param] = u'必填项' g.errmsg = errmsg log_debug('errmsg:%s'%g.errmsg) return render_template('goods/column_detail.html.j2', f=form,**locals()) # 检查 - 封面原图是否合法 column_img = param_dict['column_img'] if column_img: oss = AliyunOSS('goods', current_app.config['SAVE_TARGET_PATH']) try: oss.save(column_img) column_img = oss.put_to_oss() except UploadNotAllowed, e: errmsg['column_img'] = u'图片只允许是图片文件' except Exception, e: errmsg['column_img'] = u'图片上传失败'
def lottery_temp_detail(page=1, page_size=20): """一元云购活动模板详情""" g.page_type = '' g.title = u'一元云购活动模板详情' lt_id = toint(request.args.get('lt_id', '0')) lottery_temp_info = LotteryTemplate.query.filter( LotteryTemplate.lt_id == lt_id).first() goods_list = Goods.query.filter(Goods.kind == 2).\ filter(Goods.is_sale == 1).all() if lottery_temp_info is None: return u'一元云购活动模板不存在' param_dict = get_params({ 'lottery_id': int, 'section_number': int, 'query_goods_id': int, 'lottery_name': str, 'lottery_status': int, 'begin_add_time': str, 'end_add_time': str }) query_dict = { 'lottery_id': param_dict['lottery_id'], 'section_number': param_dict['section_number'], 'goods_id': param_dict['query_goods_id'], 'lottery_name': param_dict['lottery_name'], 'lottery_status': param_dict['lottery_status'], 'begin_add_time': param_dict['begin_add_time'], 'end_add_time': param_dict['end_add_time'], } q = db.session.query(Lottery.lottery_id, Lottery.section_number, Goods.goods_name, Lottery.goods_id, Lottery.lottery_name, Lottery.lottery_img, Lottery.lottery_price, Lottery.lottery_status, Lottery.schedule, Lottery.announced_time, Lottery.add_time).\ filter(Lottery.goods_id == Goods.goods_id).\ filter(Goods.kind == 2).\ filter(Lottery.lt_id == lt_id) q = easy_query_filter(Lottery, q, query_dict) # 商品列表 goods_query_list = [{'name': u'请选择……', 'value': '-1'}] goods_query_list_temp = db.session.query(Goods.goods_name, Goods.goods_id).\ group_by(Goods.goods_id).all() for goods in goods_query_list_temp: gs = {'name': goods.goods_name, 'value': goods.goods_id} goods_query_list.append(gs) lottery_count = get_count(q) lottery_list = q.order_by(Lottery.lottery_id.desc()).offset((page-1)*page_size).\ limit(page_size).all() pagination = Pagination(None, page, page_size, lottery_count, None) return render_template('lottery/add_template.html.j2', f=lottery_temp_info, **locals())
def ordinary_list(page=1, page_size=20): """普通订单列表""" g.title = u'普通订单列表' g.page_type = 'search' param_dict = get_params({ 'order_id': int, 'order_status': int, 'pay_status': int, 'order_amount': int, 'begin_paid_time': str, 'end_paid_time': str, 'shipping_sn': str, 'shipping_status': int, 'deliver_status': int, 'is_comment': int, 'begin_add_time': str, 'end_add_time': str }) query_dict = { 'order_id': param_dict['order_id'], 'pay_status': param_dict['pay_status'], 'order_status': param_dict['order_status'], 'order_amount': param_dict['order_amount'], 'shipping_sn': param_dict['shipping_sn'], 'shipping_status': param_dict['shipping_status'], 'deliver_status': param_dict['deliver_status'], 'is_comment': param_dict['is_comment'], 'begin_add_time': param_dict['begin_add_time'], 'end_add_time': param_dict['end_add_time'], 'begin_paid_time': param_dict['begin_paid_time'], 'end_paid_time': param_dict['end_paid_time'] } q = db.session.query(Order.order_id, Order.uid, Order.order_status, Order.order_desc, Order.order_amount, Order.shipping_sn, Order.shipping_status, Order.deliver_status, Order.is_comment, Order.add_time, Order.paid_time, Order.pay_status).\ filter(Order.uid == User.uid).\ filter(Order.order_type == 1) q = easy_query_filter(Order, q, query_dict) order_count = get_count(q) order_list = q.order_by(Order.add_time.desc()).offset((page-1)*page_size).\ limit(page_size).all() (USERNAME, MOBILE, NICKNAME, AVATAR, REALNAME, GENDER) = get_user_data() pagination = Pagination(None, page, page_size, order_count, None) res = make_response( render_template('order/ordinary_list.html.j2', f={ 'lt_id': '', 'lottery_id': '' }, **locals())) res.set_cookie('goback_url', request.url) return res
def index(page=1, page_size=20): """一元云购活动列表""" g.page_type = 'search' g.title = u'一元云购活动列表' param_dict = get_params({ 'lottery_id': int, 'section_number': int, 'goods_id': int, 'lottery_name': str, 'lottery_status': int, 'begin_add_time': str, 'end_add_time': str }) query_dict = { 'lottery_id': param_dict['lottery_id'], 'section_number': param_dict['section_number'], 'goods_id': param_dict['goods_id'], 'lottery_name': param_dict['lottery_name'], 'lottery_status': param_dict['lottery_status'], 'begin_add_time': param_dict['begin_add_time'], 'end_add_time': param_dict['end_add_time'], } q = db.session.query(Lottery.lottery_id, Lottery.section_number, Goods.goods_name, Lottery.goods_id, Lottery.lottery_name, Lottery.lottery_img, Lottery.lottery_price, Lottery.lottery_status, Lottery.schedule, Lottery.announced_time, Lottery.add_time).\ filter(Lottery.goods_id == Goods.goods_id).\ filter(Goods.kind == 2) q = easy_query_filter(Lottery, q, query_dict) lottery_count = get_count(q) lottery_list = q.order_by(Lottery.lottery_id.desc()).offset((page-1)*page_size).\ limit(page_size).all() # 商品列表 goods_id_list = [l.goods_id for l in lottery_list] goods_list = [{'name': u'请选择……', 'value': '-1'}] goods_list_temp = db.session.query(Goods.goods_name, Goods.goods_id).\ filter(Goods.goods_id.in_(goods_id_list)).\ group_by(Goods.goods_id).all() for goods in goods_list_temp: if goods.goods_name: gs = {'name': goods.goods_name, 'value': goods.goods_id} goods_list.append(gs) pagination = Pagination(None, page, page_size, lottery_count, None) res = make_response(render_template('lottery/index.html.j2', **locals())) res.set_cookie('goback_url', request.url) return res
def order_tran_list(page=1, page_size=20): """订单交易列表""" g.title = u'订单交易列表' g.page_type = 'search' param_dict = get_params({ 'tran_id': int, 'pay_status': int, 'begin_paid_time': str, 'end_paid_time': str, 'begin_add_time': str, 'end_add_time': str, 'order_id': int }) query_dict = { 'tran_id': param_dict['tran_id'], 'pay_status': param_dict['pay_status'], 'begin_paid_time': param_dict['begin_paid_time'], 'end_paid_time': param_dict['end_paid_time'], 'begin_add_time': param_dict['begin_add_time'], 'end_add_time': param_dict['end_add_time'], } q = OrderTran.query q = easy_query_filter(OrderTran, q, query_dict) order_id = param_dict['order_id'] if order_id > 0: q = q.filter( or_(OrderTran.order_id_list.like(u'%' + '%d,' % order_id + u'%'), OrderTran.order_id_list.like(u'%' + ',%d,' % order_id + u'%'), OrderTran.order_id_list.like(u'%' + ',%d' % order_id + u'%'), OrderTran.order_id_list.like(u'%' + '%d' % order_id + u'%'))) tran_count = get_count(q) order_tran_list = q.order_by(OrderTran.add_time.desc()).offset((page-1)*page_size).\ limit(page_size).all() for tran in order_tran_list: uid = tran.uid user_info = User.query.get(uid) tran.nickname = user_info.nickname if user_info else '' pagination = Pagination(None, page, page_size, tran_count, None) res = make_response( render_template('order/tran_list.html.j2', order_tran_list=order_tran_list, pagination=pagination)) res.set_cookie('goback_url', request.url) return res
def lottery_detail(page=1, page_size=30): """一元云购活动详情""" g.page_type = '' g.title = u'一元云购活动详情' lottery_id = toint(request.args.get('lottery_id', '0')) lottery_info = Lottery.query.filter( Lottery.lottery_id == lottery_id).first() goods_list = Goods.query.filter(Goods.kind == 2).\ filter(Goods.is_sale == 1).all() if lottery_info is None: return u'一元云购活动不存在' param_dict = get_params({ 'lottery_name': str, 'lottery_number': str, 'nickname': str, 'order_id': int, 'is_prize': int, 'add_time': str }) query_dict = { 'lottery_number': param_dict['lottery_number'], 'order_id': param_dict['order_id'], 'is_prize': param_dict['is_prize'], 'add_time': param_dict['add_time'] } q = db.session.query(LotteryNumber.ln_id, LotteryNumber.order_id, LotteryNumber.lottery_number, LotteryNumber.is_prize, LotteryNumber.add_time,Lottery.lottery_name,User.nickname).\ filter(Lottery.lottery_id == LotteryNumber.lottery_id).\ filter(LotteryNumber.uid == User.uid).\ filter(LotteryNumber.lottery_id == lottery_id) q = easy_query_filter(LotteryNumber, q, query_dict) if param_dict['nickname']: q = q.filter(User.nickname.like(u'%' + param_dict['nickname'] + u'%')) if param_dict['lottery_name']: q = q.filter( Lottery.lottery_name.like(u'%' + param_dict['lottery_name'] + u'%')) lottery_count = get_count(q) lottery_number_list = q.order_by(LotteryNumber.ln_id.desc()).offset((page-1)*page_size).\ limit(page_size).all() pagination = Pagination(None, page, page_size, lottery_count, None) return render_template('lottery/add.html.j2', f=lottery_info, **locals())
def temp_list(page=1, page_size=20): """一元云购模板列表""" g.page_type = 'search' g.title = u'一元云购模板列表' g.add_new = True g.button_name = u'新增一元云购模板' param_dict = get_params({ 'lt_id': int, 'section_number': int, 'goods_id': int, 'lottery_name': str, 'begin_add_time': str, 'end_add_time': str }) query_dict = { 'lt_id': param_dict['lt_id'], 'section_number': param_dict['section_number'], 'goods_id': param_dict['goods_id'], 'lottery_name': param_dict['lottery_name'], 'begin_add_time': param_dict['begin_add_time'], 'end_add_time': param_dict['end_add_time'], } q = db.session.query(LotteryTemplate.lt_id, LotteryTemplate.section_number, Goods.goods_name, LotteryTemplate.goods_id, LotteryTemplate.lottery_name, LotteryTemplate.lottery_img, LotteryTemplate.lottery_price, LotteryTemplate.add_time).\ filter(LotteryTemplate.goods_id == Goods.goods_id).\ filter(Goods.kind == 2) q = easy_query_filter(LotteryTemplate, q, query_dict) # 商品列表 goods_list = [{'name': u'请选择……', 'value': '-1'}] goods_list_temp = db.session.query(Goods.goods_name, Goods.goods_id).\ group_by(Goods.goods_id).all() for goods in goods_list_temp: gs = {'name': goods.goods_name, 'value': goods.goods_id} goods_list.append(gs) lottery_temp_count = get_count(q) lottery_temp_list = q.order_by(LotteryTemplate.lt_id.desc()).offset((page-1)*page_size).\ limit(page_size).all() pagination = Pagination(None, page, page_size, lottery_temp_count, None) res = make_response( render_template('lottery/temp_list.html.j2', **locals())) res.set_cookie('goback_url', request.url) return res
def save_card(): """保存抽奖活动""" g.title = u'保存抽奖活动' g.page_type = '' errmsg = {} param_dict = get_params({ 'rc_id': int, 'amount': Decimal, 'gift': Decimal, 'sort_order': str }) required_param_list = ['amount', 'gift'] form = request.form for param in required_param_list: val = request.form.get(param, '') val = val.strip() if not val: errmsg[param] = u'必填项' g.errmsg = errmsg log_debug('errmsg:%s' % g.errmsg) return render_template('sys/card_detail.html.j2', f=form, **locals()) if param_dict['amount'] < 0: errmsg['amount'] = u'金额不能小于0' g.errmsg = errmsg return render_template('sys/card_detail.html.j2', f=form, **locals()) if param_dict['gift'] < 0: errmsg['gift'] = u'赠送金额不能小于0' g.errmsg = errmsg return render_template('sys/card_detail.html.j2', f=form, **locals()) rc_id = param_dict['rc_id'] if rc_id > 0: recharge_card = RechargeCard.query.get_or_404(rc_id) else: recharge_card = RechargeCard.create(add_time=int(time.time()), update_time=int(time.time())) recharge_card.update(amount=param_dict['amount'], gift=param_dict['gift'], sort_order=param_dict['sort_order'], commit=True) return redirect(url_for('sys.recharge_card_list'))
def recharge_list(page=1, page_size=20): """充值订单列表""" g.title = u'充值订单列表' g.page_type = 'search' param_dict = get_params({ 'order_id': int, 'order_status': int, 'order_amount': int, 'begin_paid_time': str, 'end_paid_time': str, 'begin_add_time': str, 'end_add_time': str }) query_dict = { 'order_id': param_dict['order_id'], 'order_status': param_dict['order_status'], 'order_amount': param_dict['order_amount'], 'begin_add_time': param_dict['begin_add_time'], 'end_add_time': param_dict['end_add_time'], 'begin_paid_time': param_dict['begin_paid_time'], 'end_paid_time': param_dict['end_paid_time'] } q = db.session.query(Order.order_id, Order.order_status, Order.order_desc, Order.order_amount, Order.shipping_sn, Order.shipping_status, Order.deliver_status, Order.is_comment, Order.add_time, Order.pay_type, Order.paid_time, Order.paid_amount).\ filter(Order.order_type == 2) q = easy_query_filter(Order, q, query_dict) order_count = get_count(q) order_list = q.order_by(Order.add_time.desc()).offset((page-1)*page_size).\ limit(page_size).all() pagination = Pagination(None, page, page_size, order_count, None) res = make_response( render_template('order/recharge_list.html.j2', order_list=order_list, pagination=pagination, f={ 'lt_id': '', 'lottery_id': '' })) res.set_cookie('goback_url', request.url) return res
def goods_edit_save(): """保存编辑商品评价""" g.title = u'保存编辑商品评价' g.page_type = '' errmsg = {} param_dict = get_params({ 'comment_id': int, 'goods_id': int, 'tname': str, 'timg': None, 'star': int, 'content': str, 'add_time': str }) required_param_list = [ 'comment_id', 'tname', 'star', 'content', 'add_time' ] for param in required_param_list: val = request.form.get(param, '') val = val.strip() if not val: errmsg[param] = u'必填项' g.errmsg = errmsg log_debug('errmsg:%s' % g.errmsg) return render_template('comment/goods_edit.html.j2', f=form, **locals()) # 检查 - 封面原图是否合法 timg = param_dict['timg'] if timg: oss = AliyunOSS('comment', current_app.config['SAVE_TARGET_PATH']) try: oss.save(timg) timg = oss.put_to_oss() except UploadNotAllowed, e: errmsg['timg'] = u'图片只允许是图片文件' except Exception, e: errmsg['timg'] = u'图片上传失败'
def ad_list(page=1, page_size=20): """广告列表""" g.page_type = 'search' g.title = u'广告列表' g.add_new = True g.button_name = u'增加广告' param_dict = get_params({ 'adv_id': int, 'is_show': int, 'begin_add_time': str, 'end_add_time': str }) query_dict = { 'adv_id': param_dict['adv_id'], 'is_show': param_dict['is_show'], 'begin_add_time': param_dict['begin_add_time'], 'end_add_time': param_dict['end_add_time'], } q = Adv.query q = easy_query_filter(Adv, q, query_dict) ad_count = get_count(q) ad_list = q.order_by(Adv.add_time.desc()).offset((page-1)*page_size).\ limit(page_size).all() pagination = Pagination(None, page, page_size, ad_count, None) res = make_response( render_template('sys/ad_list.html.j2', ad_list=ad_list, pagination=pagination)) res.set_cookie('goback_url', request.url) return res
def save_temp(): """保存一元云购活动""" g.title = u'保存一元云购活动' g.page_type = '' errmsg = {} param_dict = get_params({ 'lt_id': int, 'section_number': int, 'goods_id': int, 'lottery_name': str, 'lottery_img': None, 'lottery_price': Decimal, 'max_quantity': int, 'finish_quantity': int }) lt_id = param_dict['lt_id'] is_new = True if lt_id <= 0 else False goods_list = Goods.query.filter(Goods.kind == 2).\ filter(Goods.is_sale == 1).all() finish_quantity = param_dict['finish_quantity'] if finish_quantity < 1: errmsg['finish_quantity'] = u'达到开奖人次数量不能小于1' required_param_list = [ 'goods_id', 'lottery_price', 'max_quantity', 'finish_quantity' ] form = request.form for param in required_param_list: val = request.form.get(param, '') val = val.strip() if not val: errmsg[param] = u'必填项' g.errmsg = errmsg log_debug('errmsg:%s' % g.errmsg) return render_template('lottery/add_template.html.j2', f=form, **locals()) goods = Goods.query.get_or_404(param_dict['goods_id']) # 每人最多参与次数 不能大于 达到开奖人次数量 if param_dict['max_quantity'] > finish_quantity: errmsg['max_quantity'] = u'每人最多参与次数 不能大于 达到开奖人次数量' g.errmsg = errmsg return render_template('lottery/add_template.html.j2', f=form, **locals()) # 检查 - 封面原图是否合法 lottery_img = param_dict['lottery_img'] if lottery_img: oss = AliyunOSS('lottery', current_app.config['SAVE_TARGET_PATH']) try: oss.save(lottery_img) lottery_img = oss.put_to_oss() except UploadNotAllowed, e: errmsg['lottery_img'] = u'图片只允许是图片文件' except Exception, e: errmsg['lottery_img'] = u'图片上传失败'
def lottery_index(page=1, page_size=20): """一元购订单列表""" g.title = u'一元购订单列表' g.page_type = 'search' param_dict = get_params({ 'order_id': int, 'order_status': int, 'section_number_list': str, 'order_amount': int, 'begin_paid_time': str, 'end_paid_time': str, 'shipping_sn': str, 'shipping_status': int, 'deliver_status': int, 'is_comment': int, 'begin_add_time': str, 'end_add_time': str, 'lt_id': int, 'lottery_id': int, 'is_prize': int, 'tran_id': int, 'pay_status': int }) query_dict = { 'order_id': param_dict['order_id'], 'order_status': param_dict['order_status'], 'order_amount': param_dict['order_amount'], 'shipping_sn': param_dict['shipping_sn'], 'shipping_status': param_dict['shipping_status'], 'deliver_status': param_dict['deliver_status'], 'is_comment': param_dict['is_comment'], 'begin_add_time': param_dict['begin_add_time'], 'end_add_time': param_dict['end_add_time'], 'begin_paid_time': param_dict['begin_paid_time'], 'end_paid_time': param_dict['end_paid_time'], 'pay_status': param_dict['pay_status'] } section_number = 0 if param_dict['lottery_id']: lottery = Lottery.query.get(param_dict['lottery_id']) section_number = lottery.section_number if lottery else 0 q = db.session.query(Order.order_id, Order.order_status, Order.order_desc, Order.pay_status, Order.section_number_list, Order.order_amount, Order.shipping_sn, Order.shipping_status, Order.deliver_status, Order.is_comment, Order.add_time, Order.paid_time, LotteryNumber.is_prize,LotteryNumber.ln_id).outerjoin(LotteryNumber,and_(Order.order_id == LotteryNumber.order_id)).\ group_by(Order.order_id.desc()) # 筛选是否中奖 is_prize = param_dict['is_prize'] is_prize_list = [is_prize] if is_prize >= 0 else [0, 1] if len(is_prize_list) == 1: q = db.session.query(LotteryNumber.is_prize,LotteryNumber.ln_id, Order.order_status, Order.order_desc, Order.section_number_list, Order.order_amount, Order.shipping_sn, Order.shipping_status, Order.deliver_status, Order.is_comment, Order.add_time, Order.paid_time, Order.order_id).\ outerjoin(Order,and_(Order.order_id == LotteryNumber.order_id, LotteryNumber.is_prize.in_(is_prize_list))) if section_number > 0: q = q.filter(Order.section_number_list == section_number) if param_dict['tran_id'] > 0: g.title = u'交易订单列表' q = q.filter(Order.tran_id == param_dict['tran_id']) else: q = q.filter(Order.order_type == 3) q = easy_query_filter(Order, q, query_dict) # 一元购活动模板列表 lottery_template_list = [{'name': u'请选择活动模板……', 'value': ''}] lottery_template_list_temp = db.session.query(LotteryTemplate.lt_id, LotteryTemplate.lottery_name).\ filter(LotteryTemplate.lottery_name != '').all() for lottery_template in lottery_template_list_temp: template = { 'name': lottery_template.lottery_name, 'value': lottery_template.lt_id } lottery_template_list.append(template) # 活动期数列表 section_number_list = [{'name': u'请选择活动期数……', 'value': ''}] section_number_list_temp = db.session.query(Lottery.lottery_id, Lottery.section_number).\ filter(Lottery.lt_id == param_dict['lt_id']).all() for section_number in section_number_list_temp: section_number = { 'name': section_number.section_number, 'value': section_number.lottery_id } section_number_list.append(section_number) order_count = get_count(q) order_list = q.order_by(Order.add_time.desc()).offset((page-1)*page_size).\ limit(page_size).all() pagination = Pagination(None, page, page_size, order_count, None) res = make_response( render_template('order/lottery_index.html.j2', lottery_template_list=lottery_template_list, section_number_list=section_number_list, order_list=order_list, pagination=pagination, is_prize_list=is_prize_list, f={ 'lt_id': '', 'lottery_id': '' })) res.set_cookie('goback_url', request.url) return res
def order_index(page=1, page_size=20): """订单评价列表""" g.title = u'' g.page_type = 'search' param_dict = get_params({ 'mobile': str, 'nickname': str, 'user_device': str, 'order_type': int, 'order_status': int, 'order_id': str, 'order_amount': int, 'discount_amount': int, 'discount_desc': str, 'pay_amount': int, 'pay_method': str, 'pay_type': int, 'pay_status': int, 'pay_tran_id': int, 'begin_paid_time': str, 'end_paid_time': str, 'paid_amount': int, 'shipping_id': int, 'shipping_name': str, 'shipping_amount': int, 'shipping_sn': str, 'shipping_status': int, 'shipping_time': str, 'deliver_status': int, 'deliver_time': str, 'milestone_status': int, 'milestone_text': str, 'is_comment': int, 'begin_add_time': str, 'end_add_time': str, 'update_time': str }) query_dict = { 'order_id': param_dict['order_id'], 'order_type': param_dict['order_type'], 'order_status': param_dict['order_status'], 'shipping_sn': param_dict['shipping_sn'], 'shipping_status': param_dict['shipping_status'], 'deliver_status': param_dict['deliver_status'], 'is_comment': param_dict['is_comment'], 'begin_add_time': param_dict['begin_add_time'], 'end_add_time': param_dict['end_add_time'], 'pay_type': param_dict['pay_type'], 'begin_paid_time': param_dict['begin_paid_time'], 'end_paid_time': param_dict['end_paid_time'] } q = db.session.query(Order.order_id, User.nickname, Order.order_type, Order.order_status, Order.order_desc, Order.order_amount, Order.shipping_sn, Order.shipping_status, Order.deliver_status, Order.is_comment, Order.add_time, Order.pay_type, Order.paid_time).\ filter(Order.uid == User.uid) q = easy_query_filter(Order, q, query_dict) order_count = get_count(q) order_list = q.order_by(Order.order_id.desc()).offset((page-1)*page_size).\ limit(page_size).all() pagination = Pagination(None, page, page_size, order_count, None) res = make_response( render_template('comment/order_index.html', order_list=order_list, pagination=pagination)) res.set_cookie('goback_url', request.url) return res