Numbered Pagination in HubDB

{% if dynamic_page_hubdb_table_id %}

• List View
• Calendar View

{% set batch_num = 6 %} {% if not request.query_dict.page %} {% set page_num = 1 %} {% set offset_num = 0 %} {% elif request.query_dict.page %} {% set page_num = request.query_dict.page %} {% set offset_num = page_num|add(-1) * batch_num %} {% endif %} {# {% set query = "limit=" ~ batch_num ~ "&offset=" ~ offset_num %} #} {% set current_dt = unixtimestamp(local_dt) %} {% set query2 = "event_date__gte="~current_dt~"&orderBy=event_date&limit=" ~ batch_num ~ "&offset=" ~ offset_num %} {% set eventsList = hubdb_table_rows(dynamic_page_hubdb_table_id, query2) %}

{% for item in eventsList %} {% if (item['event_date']|datetimeformat('%Y-%m-%d')) > (local_dt|datetimeformat('%Y-%m-%d')) %}

{% if item.featured_image.url %}

{% endif %}

{% if item.event_date %}

{{ item.event_date|datetimeformat('%B %d, %Y') }}

{% endif %}

{% if item.hs_name %}

{% if item.hs_path %}{% endif %}{{ item.hs_name }}{% if item.hs_path %}{% endif %}

{% endif %}

{% if item.event_location %}

{% for location in item.event_location %}{{ location.name }}{% if not loop.last %}, {% endif %}{% endfor %}

{% endif %} {% if item.hs_path or item.listing_content %}

{% if item.listing_content %}

{{ item.listing_content }}…

{% endif %} {% if item.hs_path %}

Read More

{% endif %}

{% endif %}

{% endif %} {% endfor %} {% if eventsList %}

{% set query3 = "event_date__gte="~current_dt %} {% set nav = hubdb_table_rows(dynamic_page_hubdb_table_id, query3) %} {% set total_pages = nav|length|divide(batch_num) %} {% set more_pages = nav|length % batch_num %} {% if more_pages == 0 %} {% set total_pages = total_pages %} {% else %} {% set total_pages = total_pages + 1 %} {% endif %} {% if page_num > 1 %}
{% endif %} {# {% if more_pages == 0 %} {% if page_num|add(4) >= 1 %}
• {{ page_num|add(-4) }}
{% endif %} {% endif %} {% if more_pages <= 1 %} {% if page_num|add(-3) >= 1 %}
• {{ page_num|add(-3) }}
{% endif %} {% endif %} {% if page_num|add(-2) >= 1 %}
• {{ page_num|add(-2) }}
{% endif %} {% if page_num|add(-1) >= 1 %}
• {{ page_num|add(-1) }}
{% endif %} #}
• {{ page_num }}
{% if page_num|add(1) <= total_pages %}
• {{ page_num|add(1) }}
{% endif %} {% if page_num|add(2) <= total_pages %}
• {{ page_num|add(2) }}
{% endif %} {% if page_num <= 2 %} {% if page_num|add(3) <= total_pages %}
• {{ page_num|add(3) }}
{% endif %} {% endif %} {% if page_num == 1 %} {% if page_num|add(4) <= total_pages %}
• {{ page_num|add(4) }}
{% endif %} {% endif %} {% if total_pages > page_num %}
{% endif %}

{% endif %}

{% endif %} // Active JS $(".post-pagination a").filter(function(){ return this.href == location.href.replace(/#.*/, ""); }).siblings().removeClass("active"); $(".post-pagination a").filter(function(){ return this.href == location.href.replace(/#.*/, ""); }).addClass("active");