Jump to content

Pagination on record view template

Recommended Posts

On a record view template of a database (brand database), I want to show records from another database that are related (products from the brand).

The custom code:

{{$baseUrl = $record->url( "getPrefComment" );}}
{{$page 	= (isset( \IPS\Request::i()->page ) and (intval( \IPS\Request::i()->page ) > 0)) ? \IPS\Request::i()->page : 1;}}
{{$start 	= ( $limit * ( $page - 1 ) );}}
{{$total = \IPS\Db::i()->select( 'COUNT(*)', 'cms_custom_database_8', array( 'field_140=?', $record->primary_id_field ) )->first();}}
{{$select = \IPS\Db::i()->select( 'cms_custom_database_8.field_68 as nome_do_suplemento, cms_custom_database_8.record_image_thumb as imagem, cms_custom_database_8.primary_id_field as id_do_suplementos, cms_custom_database_8.member_id as autor, cms_custom_database_8.record_updated as data_de_atualizacao, cms_custom_database_8.record_comments as numero_de_comentarios', 'cms_custom_database_8', array( 'field_140=?', $record->primary_id_field ), 'cms_custom_database_8.field_68 ASC', array( $start, $limit ) );}}
{{$pages = ceil($total / $limit);}}
{template="pagination" group="global" app="core" location="global" params="$baseUrl, $pages, $page, $limit, TRUE, 'page'"}

The problem is that when page 2 and so on are requested, IPS automatically redirects the URL to original record url (no pagination at all).

Is there a way to add pagination on record view template (avoid auto redirect)?

Link to comment
Share on other sites

I have changed the $baseUrl to:

{{$baseUrl = \IPS\Http\Url::internal( 'app=cms&module=pages&controller=page', 'front', 'content_page_path');}}

But now there is no pagination number attached to the pages URL.

I see that on record view there is pagination for comments (?tab=comments) and reviews (?tab=reviews).

Can I add my own custom tab to paginate the records from another database?

Link to comment
Share on other sites

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...