def question_detail(page=1, page_size=20): """回答详情""" g.page_type = '' g.title = u'回答详情' args = request.args question_id = toint(args.get('question_id', '0')) uid = toint(args.get('uid', '0')) check_type = toint(args.get('check_type', '1')) query_type = toint(args.get('query_type', '1')) user = User.get(uid) if not user: return u'找不到用户' question = Question.get(question_id) if not question: return u'找不到提问的问题' qa_query = QuestionAnswer.query.filter(QuestionAnswer.uid == uid).\ filter(QuestionAnswer.question_id == question_id) qa_count = get_count(qa_query) qa_list = qa_query.order_by(QuestionAnswer.add_time.desc()).\ offset((page-1)*page_size).limit(page_size).all() pagination = Pagination(None, page, page_size, qa_count, None) return render_template('user/question_detail.html.j2', f=question, **locals())
def index(page=1, page_size=20): """快递列表""" g.page_type = 'search' g.title = u'快递列表' g.add_new = True g.button_name = u'新增快递' args = request.args shipping_name = args.get('shipping_name', '').strip() shipping_code = args.get('shipping_code', '').strip() is_default = toint(args.get('is_default', '-1')) q = Shipping.query if shipping_name: q = q.filter(Shipping.shipping_name.like(u'%' + shipping_name + u'%')) if shipping_code: q = q.filter(Shipping.shipping_code.like(u'%' + shipping_code + u'%')) if is_default >= 0: q = q.filter(Shipping.is_default == is_default) s_count = get_count(q) shipping_list = q.order_by(Shipping.shipping_id.desc()).offset((page-1)*page_size).\ limit(page_size).all() pagination = Pagination(None, page, page_size, s_count, None) res = make_response(render_template('shipping/index.html.j2', **locals())) res.set_cookie('goback_url', request.url) return res
def index(page=1, page_size=20): """用户列表""" g.page_type = 'search' g.title = u'用户列表' args = request.args mobile = args.get('mobile', '').strip() nickname = args.get('nickname', '').strip() gender = toint(args.get('gender', '0')) q = User.query if gender > 0: q = q.filter(User.gender == gender) if nickname: like_nickname = u'%' + nickname + u'%' q = q.filter(User.nickname.like(like_nickname)) if mobile: like_mobile = u'%' + mobile + u'%' q = q.filter(User.mobile.like(like_mobile)) user_count = get_count(q) user_list = q.order_by(User.uid.desc()).offset((page-1)*page_size).\ limit(page_size).all() pagination = Pagination(None, page, page_size, user_count, None) res = make_response(render_template('user/index.html.j2', user_list=user_list, pagination=pagination)) res.set_cookie('goback_url', request.url) return res
def goods_index(page=1, page_size=20): """商品评价列表""" g.title = u'商品评价列表' g.page_type = 'search' args = request.args goods_id = toint(args.get('goods_id', '0')) goods_name = args.get('goods_name', '') q = Goods.query if goods_id > 0: q = q.filter(Goods.goods_id == goods_id) if goods_name: q = q.filter(Goods.goods_name.like(u'%' + goods_name + u'%')) goods_count = get_count(q) goods_list = q.order_by(Goods.goods_id.desc()).offset((page-1)*page_size).\ limit(page_size).all() pagination = Pagination(None, page, page_size, goods_count, None) res = make_response( render_template('comment/goods_index.html', goods_list=goods_list, pagination=pagination)) res.set_cookie('goback_url', request.url) return res
def index(page=1, page_size=20): """优惠券列表""" g.title = u'优惠券列表' g.page_type = 'search' g.add_new = True g.button_name = u'发放优惠券' args = request.args cb_name = args.get('cb_name', '').strip() coupon_name = args.get('coupon_name', '').strip() is_valid = toint(args.get('is_valid', -1)) begin_add_time = args.get('begin_add_time', '') end_add_time = args.get('end_add_time', '') query_dict = { 'cb_name': cb_name, 'coupon_name': coupon_name, 'is_valid': is_valid, 'begin_add_time': begin_add_time, 'end_add_time': end_add_time, } q = CouponBatch.query q = easy_query_filter(CouponBatch, q, query_dict) coupon_count = get_count(q) coupon_list = q.order_by(CouponBatch.add_time.desc()).offset((page-1)*page_size).\ limit(page_size).all() pagination = Pagination(None, page, page_size, coupon_count, None) res = make_response(render_template('coupon/index.html', **locals())) res.set_cookie('goback_url', request.url) return res
def troy_list(page=1, page_size=20): """ 马甲用户列表 """ g.page_type = 'search' g.title = u'马甲用户列表' g.add_new = True g.button_name = u'添加马甲用户' args = request.args uid = toint(args.get('uid', 0)) nickname = args.get('nickname', '').strip() q = db.session.query(UserTroy.add_time, User.uid, User.nickname, User.avatar).\ filter(UserTroy.uid == User.uid) if uid: q = q.filter(UserTroy.uid == uid) if nickname: like_nickname = u'%' + nickname + u'%' q = q.filter(User.nickname.like(like_nickname)) troy_count = get_count(q) troy_list = q.order_by(UserTroy.uid.desc()).\ offset((page-1)*page_size).limit(page_size).all() pagination = Pagination(None, page, page_size, troy_count, None) res = make_response(render_template('user/troy_list.html.j2', troy_list=troy_list, pagination=pagination)) res.set_cookie('goback_url', request.url) return res
def attr_group_list(page=1, page_size=20): """ 属性组列表 """ g.page_type = 'search' g.title = u'属性组列表' args = request.args ag_name = args.get('ag_name', '').strip() ag_type = toint(args.get('ag_type', -1)) q = AttrGroup.query if ag_name: like_ag_name = u'%' + ag_name + u'%' q = q.filter(AttrGroup.ag_name.like(like_ag_name)) if ag_type >= 0: ag_type = ag_type if ag_type in (1,2) else 0 q = q.filter(AttrGroup.ag_type == ag_type) group_count = get_count(q) group_list = q.order_by(AttrGroup.ag_id.desc()).all() pagination = Pagination(None, page, page_size, group_count, None) res = make_response(render_template('goods/attr_group_list.html.j2', group_list=group_list, pagination=pagination)) res.set_cookie('goback_url', request.url) return res
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_list(page=1, page_size=20): """ 商品栏目列表 """ g.page_type = 'search' g.title = u'商品栏目列表' args = request.args gc_id = toint(args.get('gc_id', '0')) column_name = args.get('column_name', '').strip() status = toint(args.get('status', '-1')) begin_add_time = args.get('begin_add_time', '') end_add_time = args.get('end_add_time', '') gc_id = gc_id if gc_id > 0 or args.get('gc_id', '') == '0' else -1 query_dict = {'gc_id':gc_id,'column_name':column_name,'status':status,'begin_add_time':begin_add_time,'end_add_time':end_add_time,} q = GoodsColumn.query q = easy_query_filter(GoodsColumn,q,query_dict) column_count = get_count(q) column_list = q.order_by(GoodsColumn.gc_id.desc()).all() pagination = Pagination(None, page, page_size, column_count, None) res = make_response(render_template('goods/column.html.j2', column_list=column_list, pagination=pagination)) res.set_cookie('goback_url', request.url) return res
def ic_list(page=1, page_size=20): """图片分类列表""" g.page_type = 'search' g.title = u'图片分类列表' g.add_new = True g.button_name = u'新增分类' args = request.args ic_name = args.get('ic_name', '').strip() q = ImgCategory.query if ic_name: like_mobile = u'%' + ic_name + u'%' q = q.filter(ImgCategory.ic_name.like(like_mobile)) ic_count = get_count(q) ic_list = q.order_by(ImgCategory.add_time.desc()).offset((page-1)*page_size).\ limit(page_size).all() pagination = Pagination(None, page, page_size, ic_count, None) res = make_response(render_template('img/ic_list.html.j2', **locals())) res.set_cookie('goback_url', request.url) return res
def admin_add(page=1, page_size=20): """用户角色添加""" g.title = u'用户角色添加' g.page_type = '' args = request.args errmsg = args.get('errmsg', '') mobile = args.get('mobile', '') role_id = toint(args.get('role_id', '0')) if errmsg: g.errmsg = eval(errmsg) log_debug('errmsg:%s'%g.errmsg) q = db.session.query(User.uid, User.avatar, User.mobile, User.nickname, UserAdmin.id, UserAdmin.role_id).\ filter(User.uid == UserAdmin.uid).\ filter(UserAdmin.role_id > 1) admin_count = get_count(q) admin_list = q.order_by(UserAdmin.id.desc()).offset((page-1)*page_size).limit(page_size).all() role_list = db.session.query(Role.role_id, Role.role_name).\ order_by(Role.role_id.asc()).all() # html页面显示角色名称 role_dict = role_name() pagination = Pagination(None, page, page_size, admin_count, None) return render_template('power/admin_add.html.j2', f={'mobile':mobile},**locals())
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 index(page=1, page_size=20): """图片列表""" g.page_type = 'search' g.title = u'图片列表' g.add_new = True g.button_name = u'新增图片' args = request.args img_title = args.get('img_title', '').strip() ic_id = toint(args.get('ic_id', '0')) img_id = toint(args.get('img_id', '0')) is_display = toint(args.get('is_display', '-1')) begin_add_time = args.get('begin_add_time', '').strip() end_add_time = args.get('end_add_time', '').strip() q = Img.query if ic_id > 0: q = q.filter(Img.ic_id == ic_id) if img_id > 0: q = q.filter(Img.img_id == img_id) if is_display > 0: q = q.filter(Img.is_display == is_display) if img_title: like_mobile = u'%' + img_title + u'%' q = q.filter(Img.img_title.like(like_mobile)) if begin_add_time: begin_time = time.mktime(time.strptime(begin_add_time, '%Y-%m-%d')) q = q.filter(Img.add_time >= begin_time) if end_add_time: end_add_time = time.mktime(time.strptime(end_add_time, '%Y-%m-%d')) + 24 * 3600 q = q.filter(Img.add_time < end_add_time) img_count = get_count(q) img_list = q.order_by(Img.img_id.desc()).offset((page-1)*page_size).\ limit(page_size).all() ic_temp = db.session.query(ImgCategory.ic_id, ImgCategory.ic_name).\ order_by(ImgCategory.ic_id.desc()).all() ic_dict, ic_list = {}, [] for ic in ic_temp: if ic.ic_name: ic_dict = {'value': ic.ic_id, 'name': ic.ic_name} ic_list.append(ic_dict) pagination = Pagination(None, page, page_size, img_count, None) res = make_response(render_template('img/index.html.j2', **locals())) res.set_cookie('goback_url', request.url) return res
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 goods_list(page=1, page_size=20): """ 商品列表 """ g.page_type = 'search' g.title = u'商品列表' g.add_new = True g.button_name = u'添加商品' args = request.args goods_id = toint(args.get('goods_id', 0)) goods_name = args.get('goods_name', '').strip() gc_id = toint(args.get('gc_id', 0)) is_sale = toint(args.get('is_sale', -1)) kind = toint(args.get('kind', '-1')) q = db.session.query(Goods.gc_id, Goods.goods_name, GoodsCategory.category_name, Goods.goods_img, Goods.goods_name, Goods.sort_order, Goods.goods_price, Goods.sale_count, Goods.kind, Goods.is_sale, Goods.goods_id, Goods.add_time).\ filter(GoodsCategory.gc_id == Goods.gc_id) if goods_id: q = q.filter(Goods.goods_id == goods_id) if goods_name: like_goods_name = u'%' + goods_name + u'%' q = q.filter(Goods.goods_name.like(like_goods_name)) if gc_id > 0: q = q.filter(Goods.gc_id == gc_id) if is_sale in (0, 1): q = q.filter(Goods.is_sale == is_sale) if kind >= 0: q = q.filter(Goods.kind == kind) # 商品分类列表 goods_cat_list = [{'name':u'请选择……', 'value':'-1'}] goods_cat_list_temp = db.session.query(GoodsCategory.category_name, GoodsCategory.gc_id).\ filter(GoodsCategory.gc_id == Goods.gc_id).\ group_by(GoodsCategory.gc_id).all() for goods_cat in goods_cat_list_temp: gc = {'name':goods_cat.category_name, 'value':goods_cat.gc_id} goods_cat_list.append(gc) goods_count = get_count(q) goods_list = q.order_by(Goods.goods_id.desc()).all() pagination = Pagination(None, page, page_size, goods_count, None) res = make_response(render_template('goods/goods_list.html.j2',**locals())) res.set_cookie('goback_url', request.url) return res
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 index(page=1, page_size=20): """售后列表""" g.page_type = 'search' g.title = u'售后列表' args = request.args order_id = args.get('order_id', '0').strip() goods_id = args.get('goods_id', '0').strip() after_type = args.get('after_type', '-1').strip() status = args.get('status', '-1').strip() begin_add_time = args.get('begin_add_time', '').strip() end_add_time = args.get('end_add_time', '').strip() q = After.query if toint(order_id) > 0: q = q.filter(After.order_id == order_id) if toint(goods_id) > 0: q = q.filter(After.goods_id == goods_id) if toint(after_type) > -1: q = q.filter(After.after_type == after_type) if toint(status) > -1: q = q.filter(After.status == status) if begin_add_time: begin_add_time = time.mktime(time.strptime(begin_add_time,'%Y-%m-%d')) q = q.filter(After.add_time >= begin_add_time) if end_add_time: end_add_time = time.mktime(time.strptime(end_add_time,'%Y-%m-%d')) + 24*3600 q = q.filter(After.add_time < end_add_time) a_count = get_count(q) a_list = q.order_by(After.add_time.desc()).offset((page-1)*page_size).\ limit(page_size).all() pagination = Pagination(None, page, page_size, a_count, None) USER_NAME = user_name_dict() res = make_response(render_template('after/index.html.j2', a_list=a_list, pagination=pagination, USER_NAME=USER_NAME)) res.set_cookie('goback_url', request.url) return res
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 getcode(): """获取验证码""" form = request.form mobile = form.get('mobile', '') check_type = 2 # 24小时内不能超过5次获取验证码 current_time = int(time.time()) min_time = current_time - 24 * 60 * 60 day_limit_query = UserCheckCode.query.filter(UserCheckCode.mobile == mobile).\ filter(UserCheckCode.check_type == check_type).\ filter(UserCheckCode.expire_time >= min_time).\ filter(UserCheckCode.expire_time < current_time) day_sms_count = get_count(day_limit_query) if day_sms_count >= 5: return u'一天之内只能获取5次验证码,请明天再来获取' # 一分钟内不重复发短信 one_ucc = UserCheckCode.query.filter(UserCheckCode.mobile == mobile).\ filter(UserCheckCode.check_type == check_type).\ filter(UserCheckCode.expire_time >= current_time).first() if one_ucc is not None: return u'请2分钟后再获取' code = randomstr(6, 1) content = u'【101计划】您的验证码是%s。如非本人操作,请忽略本短信' % (code, ) log_debug(content) sms = YunPian() res = sms.send_sms_text(mobile, content) result = json.loads(res) log_debug(result) # if result['code'] != 0: # return u'发送验证码失败,请重新获取。' ucc = UserCheckCode() ucc.mobile = mobile ucc.check_code = code ucc.expire_time = current_time + 150 ucc.check_type = check_type db.session.add(ucc) db.session.commit() return 'ok'
def index(page=1, page_size=20): """权限列表""" g.page_type = 'search' g.title = u'权限列表' g.add_new = True g.button_name = u'角色管理' args = request.args endpoint_name = args.get('endpoint_name', '') role_id = toint(args.get('role_id', '0')) q = db.session.query(RolePermission.role_id, RolePermission.endpoint_list, RolePermission.rp_id, Permission.permission_id, Permission.sort_order, Permission.endpoint_name).\ filter(RolePermission.permission_id == Permission.permission_id) if endpoint_name: q = q.filter(Permission.endpoint_name.like(u'%'+endpoint_name+u'%')) if role_id > 0: q = q.filter(RolePermission.role_id == role_id) # 角色列表 role_list = get_role_list() permission_id_list = db.session.query(Permission.permission_id).all() permission_id_list = map(lambda permission:permission.permission_id, permission_id_list) power_count = get_count(q) power_list = q.order_by(RolePermission.role_id.asc()).\ order_by(Permission.permission_id.desc()).\ offset((page-1)*page_size).limit(page_size).all() pagination = Pagination(None, page, page_size, power_count, None) # html页面显示角色名称 role_dict = role_name() res = make_response(render_template('power/index.html.j2',**locals())) res.set_cookie('goback_url', request.url) return res
def news_list(page=1, page_size=20): """ 资讯列表 """ g.page_type = 'search' g.title = u'资讯列表' g.add_new = True g.button_name = u'添加资讯' args = request.args title = args.get('title', '').strip() begin_add_time = args.get('begin_add_time', '').strip() end_add_time = args.get('end_add_time', '').strip() nc_id = toint(args.get('nc_id', '-1')) status = toint(args.get('status', '-1')) q = News.query query_dict = { 'title': title, 'nc_id': nc_id, 'status': status, 'begin_add_time': begin_add_time, 'end_add_time': end_add_time, } q = News.query q = easy_query_filter(News, q, query_dict) news_count = get_count(q) news_list = q.order_by(News.news_id.desc()).\ offset((page-1)*page_size).limit(page_size).all() pagination = Pagination(None, page, page_size, news_count, None) res = make_response( render_template( 'news/news_list.html.j2', news_list=news_list, pagination=pagination, Object=News, )) res.set_cookie('goback_url', request.url) return res
def user_detail(page=1, page_size=20): """用户详情""" g.page_type = '' g.title = u'用户详情' uid = toint(request.args.get('uid', '0')) check_type = request.args.get('check_type', '1') user_info = User.query.filter(User.uid == uid).first() if user_info is None: return u'用户不存在' user_acount_info = UserAccount.query.filter(UserAccount.uid == User.uid).\ filter(UserAccount.uid == user_info.uid).first() user_acount_detail_list = UserAccountDetail.query.filter(UserAccountDetail.uid == User.uid).\ filter(User.uid == user_info.uid).all() pagination_info = list_pagination(user_acount_detail_list, page,page_size) user_acount_detail_list = pagination_info[0] pagination = pagination_info[1] q = Question.query.filter(Question.uid == User.uid).\ filter(Question.uid == uid) q_count = get_count(q) q_pagination = Pagination(None, page, page_size, q_count, None) question_list = q.order_by(Question.add_time.desc()).offset((page-1)*page_size).\ limit(page_size).all() return render_template('user/detail.html.j2', user=user_info, ua=user_acount_info, user_acount_detail_list=user_acount_detail_list, pagination=pagination, check_type=check_type, q_pagination = q_pagination, question_list=question_list)
def menu_list(page=1, page_size=20): """菜单列表""" g.page_type = 'search' g.title = u'菜单列表' g.add_new = True g.button_name = u'新增菜单' args = request.args endpoint = args.get('endpoint', '') endpoint_name = args.get('endpoint_name', '') menu_type = toint(args.get('menu_type', '-1')) q = Permission.query if endpoint: q = q.filter(Permission.endpoint.like(u'%' + endpoint + u'%')) if endpoint_name: q = q.filter(Permission.endpoint_name.like(u'%' + endpoint_name + u'%')) if menu_type == 0: q = q.filter(Permission.parent_id == 0) if menu_type > 0: q = q.filter(Permission.parent_id > 0) menu_count = get_count(q) menu_list = q.order_by(Permission.permission_id.desc()).\ offset((page-1)*page_size).limit(page_size).all() pagination = Pagination(None, page, page_size, menu_count, None) session['menu'] = menu(session.get('role_id')) res = make_response( render_template('sys/menu_list.html.j2', menu_list=menu_list, pagination=pagination)) res.set_cookie('goback_url', request.url) return res
def user_coupon(page=1, page_size=20): """ 用户优惠券 """ g.title = u'用户优惠券' g.page_type = 'search' args = request.args uid = toint(args.get('uid', 0)) mobile = args.get('mobile', '') cb_id = toint(args.get('cb_id', 0)) coupon_id = toint(args.get('coupon_id', 0)) q = Coupon.query if uid > 0: q = q.filter(Coupon.uid == uid) if cb_id: q = q.filter(Coupon.cb_id == cb_id) if coupon_id: q = q.filter(Coupon.coupon_id == coupon_id) if mobile: q = q.filter(Coupon.uid == User.uid).\ filter(User.mobile == mobile) user_coupon_count = get_count(q) user_coupon_list = q.order_by(Coupon.add_time.desc()).\ offset((page-1)*page_size).limit(page_size).all() pagination = Pagination(None, page, page_size, user_coupon_count, None) res = make_response( render_template('coupon/user_coupon.html.j2', user_coupon_list=user_coupon_list, pagination=pagination)) res.set_cookie('goback_url', request.url) return res
def role_admin(page=1, page_size=20): """角色管理""" g.page_type = '' args = request.args role_id = toint(args.get('role_id', '0')) g.title = u'角色管理' if role_id <= 0 else u'角色详情' q = Role.query role_count = get_count(q) role_query_list = q.order_by(Role.role_id.asc()).offset((page-1)*page_size).limit(page_size).all() role = Role.query.get(role_id) # 获取角色权限permission_id字符串列表 permission_id_list = db.session.query(RolePermission.permission_id).\ filter(RolePermission.role_id == role_id).all() permission_id_list = map(lambda permission:str(permission.permission_id), permission_id_list) permission_id_str = ','.join(permission_id_list) # 获取权限列表 # permission_list = db.session.query(Permission.permission_id, Permission.endpoint_name).\ # order_by(Permission.parent_id.asc()).\ # order_by(Permission.permission_id.asc()).all() # 获取一级菜单列表 menu_list = db.session.query(Permission.permission_id, Permission.endpoint_name).\ filter(Permission.parent_id == 0).\ order_by(Permission.permission_id.asc()).all() pagination = Pagination(None, page, page_size, role_count, None) res = make_response(render_template('power/role_admin.html.j2',f=role if role else {},**locals())) res.set_cookie('goback_url', request.url) return res
def spec(page=1, page_size=20): """ 规格模板列表 """ g.page_type = 'search' g.title = u'规格模板列表' g.add_new = True g.button_name = u'新增规格模板' args = request.args st_name = args.get('st_name', '').strip() q = SpecTemplate.query if st_name: q = q.filter(SpecTemplate.st_name.like(u'%' + st_name + u'%')) spec_count = get_count(q) st_list = q.order_by(SpecTemplate.add_time.desc()).all() pagination = Pagination(None, page, page_size, spec_count, None) res = make_response(render_template('goods/spec_template.html.j2',**locals())) res.set_cookie('goback_url', request.url) return res
def category_list(page=1, page_size=20): """ 分类列表 """ g.page_type = 'search' g.title = u'分类列表' g.add_new = True g.button_name = u'创建分类' args = request.args gc_id = toint(args.get('gc_id', 0)) category_name = args.get('category_name', '').strip() begin_add_time = args.get('begin_add_time', '') end_add_time = args.get('end_add_time', '') q = GoodsCategory.query if category_name: q = q.filter(GoodsCategory.category_name.like(u'%'+category_name+u'%')) if gc_id > 0: q = q.filter(GoodsCategory.gc_id == gc_id) if begin_add_time: begin_add_time = time.mktime(time.strptime(begin_add_time,'%Y-%m-%d')) q = q.filter(GoodsCategory.add_time >= begin_add_time) if end_add_time: end_add_time = time.mktime(time.strptime(end_add_time,'%Y-%m-%d')) q = q.filter(GoodsCategory.add_time <= end_add_time) category_count = get_count(q) category_list = q.order_by(GoodsCategory.gc_id.desc()).all() pagination = Pagination(None, page, page_size, category_count, None) res = make_response(render_template('goods/category_list.html.j2', category_list=category_list, pagination=pagination)) res.set_cookie('goback_url', request.url) return res