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?

What is the least dense liquid under normal conditions?

What *exactly* is electrical current, voltage, and resistance?

My admission is revoked after accepting the admission offer

"Whatever a Russian does, they end up making the Kalashnikov gun"? Are there any similar proverbs in English?

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

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?

Mistake in years of experience in resume?

What ability score does a Hexblade's Pact Weapon use for attack and damage when wielded by another character?

Has a Nobel Peace laureate ever been accused of war crimes?

Contradiction proof for inequality of P and NP?

Justification for leaving new position after a short time

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

Are these square matrices always diagonalisable?

How to translate "red flag" into Spanish?

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

How can I wire a 9-position switch so that each position turns on one more LED than the one before?

How to not starve gigantic beasts

Multiple fireplaces in an apartment building?

The art of proof summarizing. Are there known rules, or is it a purely common sense matter?

Is Bran literally the world's memory?

Are all CP/M-80 implementations binary compatible?

Holes in ElementMesh with ToElementMesh of ImplicitRegion

With indentation set to `0em`, when using a line break, there is still an indentation of a size of a space

Is it acceptable to use working hours to read general interest books?



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;








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






























    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


























      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
















      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














      share












      share



      share








      edited 3 mins ago







      Praveen Negimani

















      asked 9 mins ago









      Praveen NegimaniPraveen Negimani

      458




      458




















          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

          Disable / Remove link to Product Items in Cart Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern) Announcing the arrival of Valued Associate #679: Cesar Manara Unicorn Meta Zoo #1: Why another podcast?How can I limit products that can be bought / added to cart?Remove item from cartHide “Add to Cart” button if specific products are already in cart“Prettifying” the custom options in cart pageCreate link in cart sidebar to view all added items After limit reachedLink products together in checkout/cartHow to Get product from cart and add it againHide action-edit on cart page if simple productRemoving Cart items - ObserverRemove wishlist items when added to cart

          Helsingin valtaus Sisällysluettelo Taustaa | Yleistä sotatoimista | Osapuolet | Taistelut Helsingin ympäristössä | Punaisten antautumissuunnitelma | Taistelujen kulku Helsingissä | Valtauksen jälkeen | Tappiot | Muistaminen | Kirjallisuutta | Lähteet | Aiheesta muualla | NavigointivalikkoTeoksen verkkoversioTeoksen verkkoversioGoogle BooksSisällissota Helsingissä päättyi tasan 95 vuotta sittenSaksalaisten ylivoima jyräsi punaisen HelsinginSuomalaiset kuvaavat sotien jälkiä kaupungeissa – katso kuvat ja tarinat tutuilta kulmiltaHelsingin valtaus 90 vuotta sittenSaksalaiset valtasivat HelsinginHyökkäys HelsinkiinHelsingin valtaus 12.–13.4. 1918Saksalaiset käyttivät ihmiskilpiä Helsingin valtauksessa 1918Teoksen verkkoversioTeoksen verkkoversioSaksalaiset hyökkäävät Etelä-SuomeenTaistelut LeppävaarassaSotilaat ja taistelutLeppävaara 1918 huhtikuussa. KapinatarinaHelsingin taistelut 1918Saksalaisten voitonparaati HelsingissäHelsingin valtausta juhlittiinSaksalaisten Helsinki vuonna 1918Helsingin taistelussa kaatuneet valkokaartilaisetHelsinkiin haudatut taisteluissa kaatuneet punaiset12.4.1918 Helsingin valtauksessa saksalaiset apujoukot vapauttavat kaupunginVapaussodan muistomerkkejä Helsingissä ja pääkaupunkiseudullaCrescendo / Vuoden 1918 Kansalaissodan uhrien muistomerkkim

          Adjektiivitarina Tarinan tekeminen | Esimerkki: ennen | Esimerkki: jälkeen | Navigointivalikko