Gaurav Sinha

**// Filter (Show only Upcoming Event Posts) with Sorting (By Event Date)** {% 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 current_dt = unixtimestamp(local_dt) %} {% set query = "event_date__gte="~current_dt~"&orderBy=event_date&limit=" ~ batch_num ~ "&offset=" ~ offset_num %} {% set eventsList = hubdb_table_rows(dynamic_page_hubdb_table_id, query) %} {% for item in eventsList %} {% if (item['eve...

// HubDB Post Number Pagination {% if dynamic_page_hubdb_table_id %} {% set paginationPost = hubdb_table_rows(dynamic_page_hubdb_table_id) %} {% set totalPostCount = paginationPost|length %} {% for post in paginationPost %} {% if dynamic_page_hubdb_row.hs_path == post.hs_path %} {{ loop.index }} {% endif %} {% if loop.last %} / {{ totalPostCount }} {% endif %} {% endfor %} {% endif %} // HubDB Post Pagination (Next|Previous) Posts {% if dynamic_page_hubdb_table_id %} {% set filterData = 'orderBy=hs_name' %} {% set paginationPost = hubdb_table_rows(dynamic_page_hubdb_table_id, filterData) %} {% for post in paginationPost %} {% if dynamic_page_hubdb_row.hs_path == post.hs_path %} {% set prevPostIndex = loop.index + 1 %} {% set nextCount = loop.i...

{% set tableId = module.hubdb_table %} {% set my_tag = module.select_category %} {% set page_size = '5' %} {% set myfilter = "&tag__in="+my_tag|urlencode+'&limit='+page_size%} {% set table = hubdb_table_rows(tableId, myfilter+"&date__gt="~local_dt|unixtimestamp)|sort(False, False, 'date') %} {% if table == [] %} Sorry, no listings found for that Search. Try changing your fiter and search again. {% else %} {{ module.select_category }} {% for item in table %} {% if item.date %} {% if (item['date']|datetimeformat('%Y-%m-%d')) >= (local_dt|datetimeformat('%Y-%m-%d')) %} {{ item.date|datetimeformat('%b') }} {{ item.date|datet...

{% set my_page = page_by_id(pageID) %} {% for item1 in my_page.widget_containers %} {% for item2 in item1.widgets %} {% if item2.body.widget_name == "Custom Module Name" %} {% for item in item2.body.items %} {{ item.content }} {% endfor %} {% endif %} {% endfor %} {% endfor %}

/************ 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 %} {{ row.title }} {{ row.summary }} Read More {% endfor %} {% set last_page = page_num - 1 %} {% if page_num = pageCount %} {% set next_page = "" %} {% endif %} {% set paginationPath = request.path+'?page=' %} {% set pa...

// html + hubl <form class="form-horizontal" method="get"> <div class="form-cat-group"> <p>Nutzen Sie den Filter, um auf Ihre Bedürfnissen zugeschnitte Artikel anzuzeigen.</p> <div class="form-group"> {% set types = hubdb_table_column(module.select_hubdb_table, "category").options %} {% for choice in types %} {% set type_list = type_list~choice.id|list %} <label class="radio-inline" for="radios-{{ choice.id }}"> <input type="radio" name="category" id="radios-{{ choice.id }}" value="{{ choice.id }}"> <span>{{ choice.name }}</span> </label> {% endfor %} </div> </div> <div class="form-sub-cat-group"> {% set types1 = hubdb_table_column(module.select_hubdb_table, "sub_category").options %} <div class="filter-in-wrap"> <div class=...