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 Manaramain.CRITICAL: Plugin class doesn't existMagento 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.1 Create a filter in the product grid by new attributeMagento 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?
Why didn't the Space Shuttle bounce back into space as many times as possible so as to lose a lot of kinetic energy up there?
What is the best way to deal with NPC-NPC combat?
Does Feeblemind produce an ongoing magical effect that can be dispelled?
Why does the Cisco show run command not show the full version, while the show version command does?
Is Diceware more secure than a long passphrase?
What is /etc/mtab in Linux?
What is the least dense liquid under normal conditions?
"Whatever a Russian does, they end up making the Kalashnikov gun"? Are there any similar proverbs in English?
What was Apollo 13's "Little Jolt" after MECO?
Is accepting an invalid credit card number a security issue?
Why isn't everyone flabbergasted about Bran's "gift"?
"Rubric" as meaning "signature" or "personal mark" -- is this accepted usage?
std::is_constructible on incomplete types
How to avoid introduction cliches
As an international instructor, should I openly talk about my accent?
How long after the last departure shall the airport stay open for an emergency return?
Protagonist's race is hidden - should I reveal it?
Check if a string is entirely made of the same substring
Why do games have consumables?
Why did Israel vote against lifting the American embargo on Cuba?
Seek and ye shall find
Can I criticise the more senior developers around me for not writing clean code?
Justification for leaving new position after a short time
Trumpet valves, lengths, and pitch
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 Manaramain.CRITICAL: Plugin class doesn't existMagento 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.1 Create a filter in the product grid by new attributeMagento 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;
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
add a comment |
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
add a comment |
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
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
magento2 collection pagination
edited 4 mins ago
Praveen Negimani
asked 10 mins ago
![](https://lh3.googleusercontent.com/-KHsNqdH5yr0/AAAAAAAAAAI/AAAAAAAAAH4/uow9llMq918/photo.jpg?sz=32)
![](https://lh3.googleusercontent.com/-KHsNqdH5yr0/AAAAAAAAAAI/AAAAAAAAAH4/uow9llMq918/photo.jpg?sz=32)
Praveen NegimaniPraveen Negimani
458
458
add a comment |
add a comment |
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
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
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.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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