def data_list(): #console.log("data start") #name=request.args.get('type') name = request.args.get('type') c_data = [] #return render_template('showdata.html',entries=entries) search = False q = request.args.get('q') if q: search = True try: page = int(request.args.get('page', 1)) except ValueError: page = 1 per_page = 10 logging.info(name) if search == True: # console.log("search==True") data = db.findQuery(name, q) else: data = db.findAll(name) index = (page - 1) * per_page delta = per_page if (len(data) - index) / per_page == 0: delta = len(data) - index for i in range(index, index + delta): c_data.append(data[i]) if search == True: pagination = Pagination( page=page, total=len(data), search=search, record_name='Id', found=len(data), search_msg=q, ) else: pagination = Pagination( page=page, total=len(data), search=search, record_name='Id', ) keys = [] if len(c_data) > 0: keys = c_data[0].keys() return render_template( 'list.html', c_data=c_data, keys=keys, page=page, per_page=per_page, total=len(data), pagination=pagination, name=name, )
def show_script(): name = 'script' c_data = [] #return render_template('showdata.html',entries=entries) search = False q = request.args.get('q') if q: search = True try: page = int(request.args.get('page', 1)) except ValueError: page = 1 per_page = 10 if search == True: # console.log("search==True") data = db.findQuery(name, q) else: data = db.findAll(name) index = (page - 1) * per_page delta = per_page if (len(data) - index) / per_page == 0: delta = len(data) - index for i in range(index, index + delta): c_data.append(data[i]) if search == True: pagination = Pagination( page=page, total=len(data), search=search, record_name='script', found=len(data), search_msg=q, ) else: pagination = Pagination( page=page, total=len(data), search=search, record_name='script', ) return render_template( 'script_data.html', c_data=c_data, page=page, per_page=per_page, total=len(data), pagination=pagination, name=name, )
def list(): search = False q = request.args.get('q') if q: search = True try: page = int(request.args.get('page', 1)) except ValueError: page = 1 users = [ 'a', 'a', 'a', 'a', 'a', 'a', 'a', 'a', 'a', 'a', 'a', 'a', 'b', 'b', 'b', 'b', 'b', 'b', 'b', 'b', 'b', 'b', 'b', 'b', 'b' ] print users pagination = Pagination( page=page, total=len(users), search=search, record_name='users', ) return render_template( 'hello.html', users=users, page=page, pagination=pagination, )
def manufacturer_page(category, manufacturer): if not request.headers.getlist("X-Forwarded-For"): ip = request.remote_addr else: ip = request.headers.getlist("X-Forwarded-For")[0] log_ip("/cat_man %s : %s %s\n" % (str(datetime.now().time()), ip, request.headers.get('User-Agent'))) if db.stoves.find_one({ "category": category, "manufacturer": manufacturer }) == None: abort(404) temp = db.stoves.find({"category": category, "manufacturer": manufacturer}) page = int(request.args.get('page', 1)) per_page = 9 offset = (page - 1) * per_page pagination_users = get_users(temp, offset=offset, per_page=per_page) pagination = Pagination(page=page, per_page=per_page, offset=offset, total=temp.count(), css_framework='bootstrap4') return render_template('product.html', category=category, manufacturer=manufacturer, stoves=temp, goods=pagination_users, pagination=pagination)
def hero_matches(name, page=1): hero_name_query = Hero.query.filter(Hero.name == HERO_PREFIX + name).all() if len(hero_name_query) != 1: abort(404) else: hero_name = hero_name_query[0].localized_name hero_id = hero_name_query[0].id all_heroes = Hero.query.order_by(Hero.localized_name.asc()).all() matches_query = Match.query.join(Player).\ filter(Player.hero_id==hero_id, Match.is_significant_p==True).\ order_by(Match.starttime.desc()) display_msg = '''Matches <b>{start} - {end}</b> of <b>{total}</b>''' matches_pagination = Pagination(per_page=MATCHES_PER_PAGE, total=matches_query.count(), display_msg=display_msg, page=page) matches_query = matches_query.paginate(page, MATCHES_PER_PAGE, False) (matches, players_for_match) = matches_and_players(matches_query.items) title = hero_name return render_template("hero-matches.html", matches=matches_query, pagination=matches_pagination, players_for_match=players_for_match, hero_name=hero_name, fields=prepare_match_preview(), all_heroes=all_heroes, title=title)
def player(name, page=1): if str(name) in NAME_ID.keys(): player_name = name player_id = NAME_ID[str(name)] else: abort(404) matches_query = Match.query.join(Player).\ filter(Player.account_id==player_id, Match.is_significant_p==True).\ order_by(Match.starttime.desc()) display_msg = '''Matches <b>{start} - {end}</b> of <b>{total}</b>''' matches_pagination = Pagination(per_page=MATCHES_PER_PAGE, total=matches_query.count(), display_msg=display_msg, page=page) matches_query = matches_query.paginate(page, MATCHES_PER_PAGE, False) (matches, players_for_match) = matches_and_players(matches_query.items) title = player_name return render_template("player.html", matches=matches_query, pagination=matches_pagination, players_for_match=players_for_match, player_name=player_name, fields=prepare_match_preview(), title=title)
def index(page=1): matches_query = Match.query.filter( Match.is_significant_p == True).order_by(Match.starttime.desc()) display_msg = '''Matches <b>{start} - {end}</b> of <b>{total}</b>''' matches_pagination = Pagination(page=page, per_page=MATCHES_PER_PAGE, total=matches_query.count(), display_msg=display_msg) matches_query = matches_query.paginate(page, MATCHES_PER_PAGE, False) (matches, players_for_match) = matches_and_players(matches_query.items) sorted_players = sorted(NAME_ID.iteritems(), key=operator.itemgetter(0)) sorted_players = sorted(sorted_players, key=lambda s: s[0].lower()) start = 1 + (matches_pagination.page - 1) * matches_pagination.per_page end = start + matches_pagination.per_page - 1 title = "Matches " + str(start) + " - " + str(end) + " of " + str( matches_pagination.total) return render_template("index.html", matches=matches_query, pagination=matches_pagination, players_for_match=players_for_match, player_pages=sorted_players, fields=prepare_match_preview(), title=title)
def manufacturer_page(category, manufacturer): temp = db.stoves.find({"category": category, "manufacturer": manufacturer}) page = int(request.args.get('page', 1)) per_page = 9 offset = (page - 1) * per_page pagination_users = get_users(temp, offset=offset, per_page=per_page) pagination = Pagination(page=page, per_page=per_page, offset=offset, total=temp.count(), css_framework='bootstrap4') return render_template('product.html', category=category, manufacturer=manufacturer, stoves=temp, goods=pagination_users, pagination=pagination)
def topics(): page, per_page, offset = get_page_args(page_parameter='page', per_page_parameter='per_page') order = request.args.get('order') or "time" database = db.Database() subjects = database.get_topics(order, offset=offset, per_page=per_page) pagination = Pagination( css_framework='bootstrap4', link_size='sm', show_single_page=False, page=page, per_page=per_page, total=database.get_num_topics(), record_name='Topics', format_total=True, format_number=True, ) context = {'subjects': subjects, 'pagination': pagination} return render_template('topics.html', **context)