Simple Load more in HubDB
/************ HTML or HUBDB *************/
{% set page_size = 12 %} {# Define Page Size Here #}
{% set rowCount = hubdb_table(HubDBTableID).row_count %}
{% set pageCount =(rowCount/page_size)|round(0, 'ceil') %}
{% if request.query_dict.page %}
{% set page_num = request.query_dict.page|int %}
{% else %}
{% set page_num = 1 %}
{% endif %}
{% set offsetNum = (page_num-1)*page_size %}
{% set filterData = '&offset='+offsetNum+'&limit='+page_size %}
{% set dataList = hubdb_table_rows(HubDBTableID,filterData) %}
{% for row in dataList %}
{% endfor %}
{% set last_page = page_num - 1 %}
{% if page_num <= 1 %} {% set last_page="" %} {% endif %}
{% set next_page=page_num + 1 %}
{% if page_num>= pageCount %}
{% set next_page = "" %}
{% endif %}
{% set paginationPath = request.path+'?page=' %}
{% set page_list = [-2, -1, 0, 1, 2] %}
{% if pageCount - page_num == 1 %}
{% set offset = -1 %}
{% elif pageCount - page_num == 0 %}
{% set offset = -2 %}
{% elif page_num == 2 %}
{% set offset = 1 %}
{% elif page_num == 1 %}
{% set offset = 2 %}
{% else %}
{% set offset = 0 %}
{% endif %}
{% if next_page %}
Load More
{% endif %}
// js
$(document).on('click',"a.resources-load-more",function(e){
// e.preventDefault();
var targetPage = $(this).attr('href');
$("#bioList").load(targetPage+" .custom-resources-news-item",function(){
$('.bioListInner .custom-resources-news-item').insertBefore('.bioListInner');
});
$(".bio-pagination").load(targetPage+" a.resources-load-more");
return false;
});
Comments
Post a Comment