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
magento2 collection pagination
asked 27 mins ago
Praveen NegimaniPraveen Negimani
458
add a comment |
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
magento2 collection pagination
asked 27 mins ago
Praveen NegimaniPraveen Negimani
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
add a comment |
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
magento2 collection pagination
asked 27 mins ago
Praveen NegimaniPraveen Negimani
458
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
asked 27 mins ago
Praveen NegimaniPraveen Negimani
458
asked 27 mins ago
Praveen NegimaniPraveen Negimani
458
edited 20 mins ago
Praveen Negimani
asked 27 mins ago
Praveen NegimaniPraveen Negimani
458
asked 27 mins ago
Praveen NegimaniPraveen Negimani
458
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
add a comment |
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
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
);
);
draft saved
draft discarded
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
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
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
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