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

          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

          Magento 2 disable Secret Key on URL's from terminal The Next CEO of Stack OverflowMagento 2 Shortcut/GUI tool to perform commandline tasks for windowsIn menu add configuration linkMagento oAuth : Generating access token and access secretMagento 2 security key issue in Third-Party API redirect URIPublic actions in admin controllersHow to Disable Cache in Custom WidgetURL Key not changing in Magento 2Product URL Key gets deleted when importing custom options - Magento 2Problem with reindex terminalMagento 2 - bin/magento Commands not working in Cpanel Terminal

          Aasi (pallopeli) Navigointivalikko