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

          Magento 2 duplicate PHPSESSID cookie when using session_start() in custom php scriptMagento 2: User cant logged in into to account page, no error showing!Magento duplicate on subdomainGrabbing storeview from cookie (after using language selector)How do I run php custom script on magento2Magento 2: Include PHP script in headerSession lock after using Cm_RedisSessionscript php to update stockMagento set cookie popupMagento 2 session id cookie - where to find it?How to import Configurable product from csv with custom attributes using php scriptMagento 2 run custom PHP script

          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

          How to solve knockout JS error in Magento 2 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?(Magento2) knockout.js:3012 Uncaught ReferenceError: Unable to process bindingUnable to process binding Knockout.js magento 2Cannot read property `scopeLabel` of undefined on Product Detail PageCan't get Customer Data on frontend in Magento 2Magento2 Order Summary - unable to process bindingKO templates are not loading in Magento 2.1 applicationgetting knockout js error magento 2Product grid not load -— Unable to process binding Knockout.js magento 2Product form not loaded in magento2Uncaught ReferenceError: Unable to process binding “if: function()return (isShowLegend()) ” magento 2