how to do pagination to display collection at admin panel custom table in magento 2 Unicorn Meta Zoo #1: Why another podcast? Announcing the arrival of Valued Associate #679: Cesar ManaraMaking a custom collection support paginationhow to add pagination on custom collection in Magento 2Magento 2 : Problem while adding custom button order view page?Magento 2: How to override newsletter Subscriber modelWhy Getting categories and names on product view page Magento 2 fails?Magento 2 Add new field to Magento_User admin formMagento 2: toolbar url problems in custom module with custom routerMagento 2 Create dynamic array From different Model Collection to use in multi select in gridMagento 2.2.5: Overriding Admin Controller sales/orderMagento 2.3 Can't view module's front end page output?

As an international instructor, should I openly talk about my accent?

What do you call the part of a novel that is not dialog?

A Dictionary or Encyclopedia of Fantasy or Fairy Tales from the 1960s

I preordered a game on my Xbox while on the home screen of my friend's account. Which of us owns the game?

Multiple options vs single option UI

My bank got bought out, am I now going to have to start filing tax returns in a different state?

Arriving in Atlanta after US Preclearance in Dublin. Will I go through TSA security in Atlanta to transfer to a connecting flight?

Prove the alternating sum of a decreasing sequence converging to 0 is Cauchy.

How long after the last departure shall the airport stay open for an emergency return?

c++ diamond problem - How to call base method only once

What is /etc/mtab in Linux?

Protagonist's race is hidden - should I reveal it?

Putting Ant-Man on house arrest

Mistake in years of experience in resume?

Implementing 3DES algorithm in Java: is my code secure?

"Rubric" as meaning "signature" or "personal mark" -- is this accepted usage?

How would this chord from "Rocket Man" be analyzed?

Why isn't everyone flabbergasted about Bran's "gift"?

Can you stand up from being prone using Skirmisher outside of your turn?

Additive group of local rings

"My boss was furious with me and I have been fired" vs. "My boss was furious with me and I was fired"

Does Mathematica have an implementation of the Poisson binomial distribution?

Are there moral objections to a life motivated purely by money? How to sway a person from this lifestyle?

Is accepting an invalid credit card number a security issue?



how to do pagination to display collection at admin panel custom table in magento 2



Unicorn Meta Zoo #1: Why another podcast?
Announcing the arrival of Valued Associate #679: Cesar ManaraMaking a custom collection support paginationhow to add pagination on custom collection in Magento 2Magento 2 : Problem while adding custom button order view page?Magento 2: How to override newsletter Subscriber modelWhy Getting categories and names on product view page Magento 2 fails?Magento 2 Add new field to Magento_User admin formMagento 2: toolbar url problems in custom module with custom routerMagento 2 Create dynamic array From different Model Collection to use in multi select in gridMagento 2.2.5: Overriding Admin Controller sales/orderMagento 2.3 Can't view module's front end page output?



.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;








1















Here a trying to create a pagination for my collection to display in a .phtml file, but am getting error page Invalid template file: 'Magento_Theme::html/pager.phtml here is my code



code/Retailinsights/Promotion/Block/Adminhtml/Index/index.php
<?php
namespace RetailinsightsPromotionBlockAdminhtmlIndex;
use RetailinsightsPromotionModelPostTableFactory;

class Index extends MagentoFrameworkViewElementTemplate

public function __construct(MagentoBackendBlockWidgetContext $context,
PostTableFactory $PostTableFactory,
array $data = [])

$this->_PostTableFactory = $PostTableFactory;
parent::__construct($context, $data);

public function getPostCollection()

$page = ($this->getRequest()->getParam('p'))? $this->getRequest()->getParam('p') : 1;
$limit = ($this->getRequest()->getParam('limit'))? $this->getRequest()->getParam('limit') : 1;

$collection = $this->_PostTableFactory->create()->getCollection();

$collection->setPageSize($limit);
$collection->setCurPage($page);
/// $collection->setPageSize(3); // fetching only 3 products

return $collection;

protected function _prepareLayout()
parent::_prepareLayout();
$this->pageConfig->getTitle()->set(__('Price Rules'));

if ($this->getPostCollection())
$pager = $this->getLayout()->createBlock('MagentoThemeBlockHtmlPager',
'retailinsights.promotion.pager')
->setAvailableLimit(array(2=>2,10=>10,15=>15,20=>20))
->setShowPerPage(true)
->setCollection($this->getPostCollection());


$this->setChild('pager', $pager);

$this->getPostCollection()->load();

return $this;


public function getPagerHtml()

return $this->getChildHtml('pager');







its layout file
code/Retailinsights/Promotion/view/adminhtml/layout



Promo Store Mapping



 </head> 
<body>
<referenceContainer name="content">
<block class="RetailinsightsPromotionBlockAdminhtmlIndexIndex"
name="Promotion"
template="Retailinsights_Promotion::promotion_index_index.phtml" />
</referenceContainer>
</body>
</page>


Its .phtml file



code/Retailinsights/Promotion/view/adminhtml/templates
<h2>Promotions Details</h2>
<table>
<tr>
<th>S.no.</th>
<th>Store Name</th>
<th>Promotion Name</th>
<th>Start Date</th>
<th>End Date</th>
<th>Status</th>
</tr>
<?php
$postCollection = $block->getPostCollection();
foreach ($postCollection as $promo)
$status = "Disabled";
if($promo->getData('status')==1)
$status = "Enabled";

// print_r($promo->getData());
echo "<tr>";
echo "<td>".$promo->getData('p_id')."</td>";
echo "<td>".$promo->getData('seller_name')."</td>";
echo "<td>".$promo->getData('description')."</td>";
echo "<td>".$promo->getData('pstart_date')."</td>";
echo "<td>".$promo->getData('pend_date')."</td>";
echo "<td>".$status."</td>";
echo "</tr>";




?>
</table>

<?php
if ($this->getPagerHtml())
echo $this->getPagerHtml();
else
echo 'records not available.';


?>


I am not understanding why Pager not creating, can get help? Thank you in advance










share|improve this question
























  • Any reason to avoid magento grid system?

    – Sohel Rana
    11 mins ago











  • Thank you @SohelRana Rana for replying, requirement is to avoid grid system. can we add pagination here

    – Praveen Negimani
    53 secs ago

















1















Here a trying to create a pagination for my collection to display in a .phtml file, but am getting error page Invalid template file: 'Magento_Theme::html/pager.phtml here is my code



code/Retailinsights/Promotion/Block/Adminhtml/Index/index.php
<?php
namespace RetailinsightsPromotionBlockAdminhtmlIndex;
use RetailinsightsPromotionModelPostTableFactory;

class Index extends MagentoFrameworkViewElementTemplate

public function __construct(MagentoBackendBlockWidgetContext $context,
PostTableFactory $PostTableFactory,
array $data = [])

$this->_PostTableFactory = $PostTableFactory;
parent::__construct($context, $data);

public function getPostCollection()

$page = ($this->getRequest()->getParam('p'))? $this->getRequest()->getParam('p') : 1;
$limit = ($this->getRequest()->getParam('limit'))? $this->getRequest()->getParam('limit') : 1;

$collection = $this->_PostTableFactory->create()->getCollection();

$collection->setPageSize($limit);
$collection->setCurPage($page);
/// $collection->setPageSize(3); // fetching only 3 products

return $collection;

protected function _prepareLayout()
parent::_prepareLayout();
$this->pageConfig->getTitle()->set(__('Price Rules'));

if ($this->getPostCollection())
$pager = $this->getLayout()->createBlock('MagentoThemeBlockHtmlPager',
'retailinsights.promotion.pager')
->setAvailableLimit(array(2=>2,10=>10,15=>15,20=>20))
->setShowPerPage(true)
->setCollection($this->getPostCollection());


$this->setChild('pager', $pager);

$this->getPostCollection()->load();

return $this;


public function getPagerHtml()

return $this->getChildHtml('pager');







its layout file
code/Retailinsights/Promotion/view/adminhtml/layout



Promo Store Mapping



 </head> 
<body>
<referenceContainer name="content">
<block class="RetailinsightsPromotionBlockAdminhtmlIndexIndex"
name="Promotion"
template="Retailinsights_Promotion::promotion_index_index.phtml" />
</referenceContainer>
</body>
</page>


Its .phtml file



code/Retailinsights/Promotion/view/adminhtml/templates
<h2>Promotions Details</h2>
<table>
<tr>
<th>S.no.</th>
<th>Store Name</th>
<th>Promotion Name</th>
<th>Start Date</th>
<th>End Date</th>
<th>Status</th>
</tr>
<?php
$postCollection = $block->getPostCollection();
foreach ($postCollection as $promo)
$status = "Disabled";
if($promo->getData('status')==1)
$status = "Enabled";

// print_r($promo->getData());
echo "<tr>";
echo "<td>".$promo->getData('p_id')."</td>";
echo "<td>".$promo->getData('seller_name')."</td>";
echo "<td>".$promo->getData('description')."</td>";
echo "<td>".$promo->getData('pstart_date')."</td>";
echo "<td>".$promo->getData('pend_date')."</td>";
echo "<td>".$status."</td>";
echo "</tr>";




?>
</table>

<?php
if ($this->getPagerHtml())
echo $this->getPagerHtml();
else
echo 'records not available.';


?>


I am not understanding why Pager not creating, can get help? Thank you in advance










share|improve this question
























  • Any reason to avoid magento grid system?

    – Sohel Rana
    11 mins ago











  • Thank you @SohelRana Rana for replying, requirement is to avoid grid system. can we add pagination here

    – Praveen Negimani
    53 secs ago













1












1








1


1






Here a trying to create a pagination for my collection to display in a .phtml file, but am getting error page Invalid template file: 'Magento_Theme::html/pager.phtml here is my code



code/Retailinsights/Promotion/Block/Adminhtml/Index/index.php
<?php
namespace RetailinsightsPromotionBlockAdminhtmlIndex;
use RetailinsightsPromotionModelPostTableFactory;

class Index extends MagentoFrameworkViewElementTemplate

public function __construct(MagentoBackendBlockWidgetContext $context,
PostTableFactory $PostTableFactory,
array $data = [])

$this->_PostTableFactory = $PostTableFactory;
parent::__construct($context, $data);

public function getPostCollection()

$page = ($this->getRequest()->getParam('p'))? $this->getRequest()->getParam('p') : 1;
$limit = ($this->getRequest()->getParam('limit'))? $this->getRequest()->getParam('limit') : 1;

$collection = $this->_PostTableFactory->create()->getCollection();

$collection->setPageSize($limit);
$collection->setCurPage($page);
/// $collection->setPageSize(3); // fetching only 3 products

return $collection;

protected function _prepareLayout()
parent::_prepareLayout();
$this->pageConfig->getTitle()->set(__('Price Rules'));

if ($this->getPostCollection())
$pager = $this->getLayout()->createBlock('MagentoThemeBlockHtmlPager',
'retailinsights.promotion.pager')
->setAvailableLimit(array(2=>2,10=>10,15=>15,20=>20))
->setShowPerPage(true)
->setCollection($this->getPostCollection());


$this->setChild('pager', $pager);

$this->getPostCollection()->load();

return $this;


public function getPagerHtml()

return $this->getChildHtml('pager');







its layout file
code/Retailinsights/Promotion/view/adminhtml/layout



Promo Store Mapping



 </head> 
<body>
<referenceContainer name="content">
<block class="RetailinsightsPromotionBlockAdminhtmlIndexIndex"
name="Promotion"
template="Retailinsights_Promotion::promotion_index_index.phtml" />
</referenceContainer>
</body>
</page>


Its .phtml file



code/Retailinsights/Promotion/view/adminhtml/templates
<h2>Promotions Details</h2>
<table>
<tr>
<th>S.no.</th>
<th>Store Name</th>
<th>Promotion Name</th>
<th>Start Date</th>
<th>End Date</th>
<th>Status</th>
</tr>
<?php
$postCollection = $block->getPostCollection();
foreach ($postCollection as $promo)
$status = "Disabled";
if($promo->getData('status')==1)
$status = "Enabled";

// print_r($promo->getData());
echo "<tr>";
echo "<td>".$promo->getData('p_id')."</td>";
echo "<td>".$promo->getData('seller_name')."</td>";
echo "<td>".$promo->getData('description')."</td>";
echo "<td>".$promo->getData('pstart_date')."</td>";
echo "<td>".$promo->getData('pend_date')."</td>";
echo "<td>".$status."</td>";
echo "</tr>";




?>
</table>

<?php
if ($this->getPagerHtml())
echo $this->getPagerHtml();
else
echo 'records not available.';


?>


I am not understanding why Pager not creating, can get help? Thank you in advance










share|improve this question
















Here a trying to create a pagination for my collection to display in a .phtml file, but am getting error page Invalid template file: 'Magento_Theme::html/pager.phtml here is my code



code/Retailinsights/Promotion/Block/Adminhtml/Index/index.php
<?php
namespace RetailinsightsPromotionBlockAdminhtmlIndex;
use RetailinsightsPromotionModelPostTableFactory;

class Index extends MagentoFrameworkViewElementTemplate

public function __construct(MagentoBackendBlockWidgetContext $context,
PostTableFactory $PostTableFactory,
array $data = [])

$this->_PostTableFactory = $PostTableFactory;
parent::__construct($context, $data);

public function getPostCollection()

$page = ($this->getRequest()->getParam('p'))? $this->getRequest()->getParam('p') : 1;
$limit = ($this->getRequest()->getParam('limit'))? $this->getRequest()->getParam('limit') : 1;

$collection = $this->_PostTableFactory->create()->getCollection();

$collection->setPageSize($limit);
$collection->setCurPage($page);
/// $collection->setPageSize(3); // fetching only 3 products

return $collection;

protected function _prepareLayout()
parent::_prepareLayout();
$this->pageConfig->getTitle()->set(__('Price Rules'));

if ($this->getPostCollection())
$pager = $this->getLayout()->createBlock('MagentoThemeBlockHtmlPager',
'retailinsights.promotion.pager')
->setAvailableLimit(array(2=>2,10=>10,15=>15,20=>20))
->setShowPerPage(true)
->setCollection($this->getPostCollection());


$this->setChild('pager', $pager);

$this->getPostCollection()->load();

return $this;


public function getPagerHtml()

return $this->getChildHtml('pager');







its layout file
code/Retailinsights/Promotion/view/adminhtml/layout



Promo Store Mapping



 </head> 
<body>
<referenceContainer name="content">
<block class="RetailinsightsPromotionBlockAdminhtmlIndexIndex"
name="Promotion"
template="Retailinsights_Promotion::promotion_index_index.phtml" />
</referenceContainer>
</body>
</page>


Its .phtml file



code/Retailinsights/Promotion/view/adminhtml/templates
<h2>Promotions Details</h2>
<table>
<tr>
<th>S.no.</th>
<th>Store Name</th>
<th>Promotion Name</th>
<th>Start Date</th>
<th>End Date</th>
<th>Status</th>
</tr>
<?php
$postCollection = $block->getPostCollection();
foreach ($postCollection as $promo)
$status = "Disabled";
if($promo->getData('status')==1)
$status = "Enabled";

// print_r($promo->getData());
echo "<tr>";
echo "<td>".$promo->getData('p_id')."</td>";
echo "<td>".$promo->getData('seller_name')."</td>";
echo "<td>".$promo->getData('description')."</td>";
echo "<td>".$promo->getData('pstart_date')."</td>";
echo "<td>".$promo->getData('pend_date')."</td>";
echo "<td>".$status."</td>";
echo "</tr>";




?>
</table>

<?php
if ($this->getPagerHtml())
echo $this->getPagerHtml();
else
echo 'records not available.';


?>


I am not understanding why Pager not creating, can get help? Thank you in advance







magento2 collection pagination






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited 20 mins ago







Praveen Negimani

















asked 27 mins ago









Praveen NegimaniPraveen Negimani

458




458












  • Any reason to avoid magento grid system?

    – Sohel Rana
    11 mins ago











  • Thank you @SohelRana Rana for replying, requirement is to avoid grid system. can we add pagination here

    – Praveen Negimani
    53 secs ago

















  • Any reason to avoid magento grid system?

    – Sohel Rana
    11 mins ago











  • Thank you @SohelRana Rana for replying, requirement is to avoid grid system. can we add pagination here

    – Praveen Negimani
    53 secs ago
















Any reason to avoid magento grid system?

– Sohel Rana
11 mins ago





Any reason to avoid magento grid system?

– Sohel Rana
11 mins ago













Thank you @SohelRana Rana for replying, requirement is to avoid grid system. can we add pagination here

– Praveen Negimani
53 secs ago





Thank you @SohelRana Rana for replying, requirement is to avoid grid system. can we add pagination here

– Praveen Negimani
53 secs ago










0






active

oldest

votes












Your Answer








StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "479"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);













draft saved

draft discarded


















StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f272371%2fhow-to-do-pagination-to-display-collection-at-admin-panel-custom-table-in-magent%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown

























0






active

oldest

votes








0






active

oldest

votes









active

oldest

votes






active

oldest

votes















draft saved

draft discarded
















































Thanks for contributing an answer to Magento Stack Exchange!


  • Please be sure to answer the question. Provide details and share your research!

But avoid


  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.




draft saved


draft discarded














StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f272371%2fhow-to-do-pagination-to-display-collection-at-admin-panel-custom-table-in-magent%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







Popular posts from this blog

منجزی محتویات تیره‌های طایفه منجزی[ویرایش] مشاهیر طایفه منجزی[ویرایش] محل سکونت[ویرایش] پانویس[ویرایش] منابع[ویرایش] منوی ناوبری«نمودار اجتماعی طوایف بختیاری»«BakhtyārBAḴTĪĀRĪ TRIBE»«اسامی طوایف و شعب ایل بختیاری»ووگسترش آن

بیوانفورماتیک محتویات تاریخچه[ویرایش] اهداف[ویرایش] کاربردهای بیوانفورماتیک[ویرایش] زمینه‌های مهم بیوانفورماتیک[ویرایش] موضوعات سیستم نرم‌افزاری بیوانفورماتیک[ویرایش] مراکز و ابزار[ویرایش] جستارهای وابسته[ویرایش] پیوند به بیرون[ویرایش] منابع[ویرایش] منوی ناوبریووانجمن بیوانفورماتیک ایرانمرکز بیوانفورماتیک دانشگاه تهرانمرکز ملی تحقیقات بیوانفورماتیکانستیتو بیو-آی‌تیبانک داده‌های دی ان ایمرکز ملی اطلاعات بیوتکنولوژیانستیتوی بیوانفورماتیک اروپاپورتال بیوانفورماتیک ایران«فرهنگ واژه‌های مصوب فرهنگستان ـ دفتر هشتم، بخش لاتین»وووو4611085-900870420ووو