HubDb Multiple Filter Search with Load More
{% if module.hubdb_table %}
{% endif %}
{% set page_size = 12 %} {# Define Page Size Here #}
{% set rowCount = hubdb_table(module.hubdb_table).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 %}
{% if page_num == "" or page_num == "1"%}
{% set offsetNum = page_size %}
{% else %}
{% set offsetNum = (page_num)*page_size %}
{% endif %}
{% set queryparam = "" %}
{% if request.query_dict.market_segment in ["1", "2", "3", "4", "5", "6" , "7"] and request.query_dict.resource_type =="" and request.query_dict.Name =="" and request.query_dict.product =="" %}
{% set queryparam = queryparam ~ "&market_segment__in="~request.query_dict.market_segment|urlencode %}
{% elif request.query_dict.market_segment in ["1", "2", "3", "4", "5", "6" , "7"] and request.query_dict.resource_type !="" and request.query_dict.Name =="" and request.query_dict.product =="" %}
{% set queryparam = queryparam ~ "&market_segment__in="~request.query_dict.market_segment|urlencode ~ "&resource_type__in="~request.query_dict.resource_type|urlencode %}
{% elif request.query_dict.market_segment in ["1", "2", "3", "4", "5", "6" , "7"] and request.query_dict.resource_type !="" and request.query_dict.Name !="" and request.query_dict.product =="" %}
{% set queryparam = queryparam ~ "&market_segment__in="~request.query_dict.market_segment|urlencode ~ "&resource_type__in="~request.query_dict.resource_type|urlencode~"&Name__icontains="~request.query_dict.Name|urlencode %}
{% elif request.query_dict.market_segment in ["1", "2", "3", "4", "5", "6" , "7"] and request.query_dict.resource_type !="" and request.query_dict.Name =="" and request.query_dict.product !="" %}
{% set queryparam = queryparam ~ "&market_segment__in="~request.query_dict.market_segment|urlencode ~ "&resource_type__in="~request.query_dict.resource_type|urlencode~"&product__in="~request.query_dict.product|urlencode %}
{% elif request.query_dict.market_segment in ["1", "2", "3", "4", "5", "6" , "7"] and request.query_dict.resource_type !="" and request.query_dict.Name !="" and request.query_dict.product !="" %}
{% set queryparam = queryparam ~ "&market_segment__in="~request.query_dict.market_segment|urlencode ~ "&resource_type__in="~request.query_dict.resource_type|urlencode~"&Name__icontains="~request.query_dict.Name|urlencode ~"&product__in="~request.query_dict.product|urlencode %}
{% elif request.query_dict.resource_type in ["1", "2", "3", "4", "5", "6" , "7" , "8"] and request.query_dict.market_segment =="" and request.query_dict.Name =="" and request.query_dict.product =="" %}
{% set queryparam = queryparam ~ "&resource_type__in="~request.query_dict.resource_type|urlencode %}
{% elif request.query_dict.resource_type =="" and request.query_dict.market_segment =="" and request.query_dict.Name !="" and request.query_dict.product =="" %}
{% set queryparam = queryparam ~ "&Name__icontains="~request.query_dict.Name|urlencode %}
{% elif request.query_dict.resource_type =="" and request.query_dict.market_segment =="" and request.query_dict.Name =="" and request.query_dict.product !="" %}
{% set queryparam = queryparam ~ "&product__in="~request.query_dict.product|urlencode %}
{% elif request.query_dict.resource_type !="" and request.query_dict.Name !="" and request.query_dict.market_segment =="" and request.query_dict.product =="" %}
{% set queryparam = queryparam ~ "&resource_type__in="~request.query_dict.resource_type|urlencode ~ "&Name__icontains="~request.query_dict.Name|urlencode %}
{% elif request.query_dict.resource_type =="" and request.query_dict.Name !="" and request.query_dict.market_segment !="" and request.query_dict.product =="" %}
{% set queryparam = queryparam ~ "&market_segment__in="~request.query_dict.market_segment|urlencode ~ "&Name__icontains="~request.query_dict.Name|urlencode %}
{% elif request.query_dict.resource_type =="" and request.query_dict.Name !="" and request.query_dict.market_segment =="" and request.query_dict.product !="" %}
{% set queryparam = queryparam ~ "&product__in="~request.query_dict.product|urlencode ~ "&Name__icontains="~request.query_dict.Name|urlencode %}
{% elif request.query_dict.resource_type =="" and request.query_dict.Name =="" and request.query_dict.market_segment !="" and request.query_dict.product !="" %}
{% set queryparam = queryparam ~ "&product__in="~request.query_dict.product|urlencode ~ "&market_segment__in="~request.query_dict.market_segment|urlencode %}
{% elif request.query_dict.resource_type !="" and request.query_dict.Name =="" and request.query_dict.market_segment =="" and request.query_dict.product !="" %}
{% set queryparam = queryparam ~ "&product__in="~request.query_dict.product|urlencode %}
{% endif %}
{% set count = hubdb_table_rows(module.hubdb_table, queryparam) %}
{% set pageCount3 = count|length %}
{% set pageCount4 =(pageCount3/page_size)|round(0, 'ceil') %}
{% if offsetNum =="0" %}
{% set queryparam = queryparam~"&limit=" + page_size %}
{% else %}
{% set queryparam = queryparam~"&limit="~offsetNum %}
{% endif %}
{% set table = hubdb_table_rows(module.hubdb_table, queryparam) %}
{% if table == [] %}
{% else %}
{% endif %}
/*************************************** Jquery **********************************************/
document.getElementById("searchByName").addEventListener("input", myFunction);
function myFunction() {
var t1 = document.getElementById("market_segment").value;
var t2 = document.getElementById("resource_type").value;
var t3 = document.getElementById("searchByName").value;
var t4 = document.getElementById("product").value;
// var d = "/resources?market_segment=&resource_type=" + "&Name=" + t3 + "&product=";
var d = "/resources?market_segment="+ t1 +"&resource_type=" + t2+ "&Name=" + t3 + "&product=" + t4;
console.table(d);
console.table(t1);
console.table(t2);
console.table(t3);
console.table(t4);
// $(".resources-container .row").load(d + " .resource-item");
$( ".resources-container .row" ).load(d + " .resource-item", function( response, status, xhr ) {
if ( $('.resource-item').length < 1 ) {
$( ".resources-container .row" ).html('
No matching results
{% for row in table %}
{% endfor %}
{% set page_num = page_num + 1 %}
{% if page_num <= pageCount4 %}
{% if request.query_dict %}
{% set paginationPath = request.path + "?market_segment="+ request.query_dict.market_segment|urlencode +"&resource_type=" + request.query_dict.resource_type|urlencode + "&Name=" + request.query_dict.Name|urlencode + "&product=" + request.query_dict.product|urlencode + "&page=" + page_num %}
{% else %}
{% set paginationPath = request.path + "?&page=" + page_num %}
{% endif %}
{% endif %}
{% else %}
{% endif %}
{% endfor %}
No matching results
');
}
});
}
$('.resourcesCt').on('click', ".resources-load-more", function(e){
e.preventDefault();
var loadUrl = $('.resources-load-more').attr('href');
console.log(loadUrl);
$( ".resources-container .resourcesCt" ).load(loadUrl + " .resources-container .resourcesCt", function(){
var tt = $('.resources-load-more').attr('href');
});
loadUrl = tt;
console.log(loadUrl);
});
Comments
Post a Comment