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;








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






























    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


























      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 4 mins ago







      Praveen Negimani

















      asked 10 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

          Can not update quote_id field of “quote_item” table magento 2Magento 2.1 - We can't remove the item. (Shopping Cart doesnt allow us to remove items before becomes empty)Add value for custom quote item attribute using REST apiREST API endpoint v1/carts/cartId/items always returns error messageCorrect way to save entries to databaseHow to remove all associated quote objects of a customer completelyMagento 2 - Save value from custom input field to quote_itemGet quote_item data using quote id and product id filter in Magento 2How to set additional data to quote_item table from controller in Magento 2?What is the purpose of additional_data column in quote_item table in magento2Set Custom Price to Quote item magento2 from controller

          Nissan Patrol Зміст Перше покоління — 4W60 (1951-1960) | Друге покоління — 60 series (1960-1980) | Третє покоління (1980–2002) | Четверте покоління — Y60 (1987–1998) | П'яте покоління — Y61 (1997–2013) | Шосте покоління — Y62 (2010- ) | Посилання | Зноски | Навігаційне менюОфіційний український сайтТест-драйв Nissan Patrol 2010 7-го поколінняNissan PatrolКак мы тестировали Nissan Patrol 2016рвиправивши або дописавши її

          Перекидне табло Зміст Переваги | Недоліки | Будова | Посилання | Навігаційне менюПерекидне таблоU.S. Patent 3 220 174U.S. Patent 3 501 761Split-flap-display