how to fetch order number, payment method and customer name according to invoice number in admin panel grid? ...

Need some help with wall behind rangetop

Describing a person. What needs to be mentioned?

WOW air has ceased operation, can I get my tickets refunded?

Example of a Mathematician/Physicist whose Other Publications during their PhD eclipsed their PhD Thesis

Can a caster that cast Polymorph on themselves stop concentrating at any point even if their Int is low?

How do we know the LHC results are robust?

Is HostGator storing my password in plaintext?

What does "Its cash flow is deeply negative" mean?

Why do remote companies require working in the US?

Is it my responsibility to learn a new technology in my own time my employer wants to implement?

Opposite of a diet

Only print output after finding pattern

What makes a siege story/plot interesting?

Can I equip Skullclamp on a creature I am sacrificing?

India just shot down a satellite from the ground. At what altitude range is the resulting debris field?

Horror movie/show or scene where a horse creature opens its mouth really wide and devours a man in a stables

Anatomically Correct Strange Women In Ponds Distributing Swords

Term for the "extreme-extension" version of a straw man fallacy?

Why doesn't a table tennis ball float on the surface? How do we calculate buoyancy here?

How do I go from 300 unfinished/half written blog posts, to published posts?

If the heap is initialized for security, then why is the stack uninitialized?

How easy is it to start Magic from scratch?

Why didn't Theresa May consult with Parliament before negotiating a deal with the EU?

How did people program for Consoles with multiple CPUs?



how to fetch order number, payment method and customer name according to invoice number in admin panel grid?



The Next CEO of Stack OverflowHow to remove invoice, shipment and creditmemo from Admin grid in magento1.9.0.1 programmaticallyAuto Invoice Check/Money Order Payment methodHow to get paid invoice collection filter by payment methodGrandTotal(excl. tax) and Payment Method in Admin >> Sales >> Invoice gridHow to obtain customer attribute in sales order grid?Removing columns and adding columns in Invoice Admin Grid pageCapture payment from invoice create and view from adminChange Order Number and Invoice NumberMagento 2.2: Order, Invoice, and Shipment do not display in admin gridPayment Method Sales/Order grid - Magento 1.9












0















I`m fetching invoice collection using Mage::getModel('sales/order_invoice')->getCollection(); but I also want Order number, payment method and customer name according to the invoice number. How to fetch that and display in grid?










share|improve this question





























    0















    I`m fetching invoice collection using Mage::getModel('sales/order_invoice')->getCollection(); but I also want Order number, payment method and customer name according to the invoice number. How to fetch that and display in grid?










    share|improve this question



























      0












      0








      0








      I`m fetching invoice collection using Mage::getModel('sales/order_invoice')->getCollection(); but I also want Order number, payment method and customer name according to the invoice number. How to fetch that and display in grid?










      share|improve this question
















      I`m fetching invoice collection using Mage::getModel('sales/order_invoice')->getCollection(); but I also want Order number, payment method and customer name according to the invoice number. How to fetch that and display in grid?







      magento-1.9 sales-order invoice






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited 24 mins ago









      Teja Bhagavan Kollepara

      3,01241949




      3,01241949










      asked Jun 26 '18 at 22:14









      Darshan JethwaDarshan Jethwa

      166




      166






















          1 Answer
          1






          active

          oldest

          votes


















          0














          Please find the below answer to get order number,order information,payment method and customer name based on invoice id --



          <?php
          require_once('./app/Mage.php');
          Mage::app();

          $invoiceid =15;

          /* get invoice collection */
          $invoicecollection = Mage::getModel("sales/order_invoice")->getCollection()
          ->addFieldToFilter('entity_id',$invoiceid)
          ->getData();

          /* get order number and collection with customer name */
          $orderId = $invoicecollection[0]['order_id'];
          $order = Mage::getModel('sales/order')->load($orderId);

          //echo "<pre>"; print_r($order->getData());
          echo $order->getCustomerFirstname();

          /* get payment information and card type */
          $payment = $order->getPayment();
          //echo "<pre>"; print_r($payment->getData());
          echo $payment['cc_type'];

          //Get Payment Info
          echo $payment->getMethodInstance()->getCode();
          echo $payment->getMethodInstance()->getTitle();

          ?>





          share|improve this answer
























          • This might be correct but what I`m looking is for to fetch the order number, customer name and payment method according to invoice number on admin panel grid!

            – Darshan Jethwa
            Jun 26 '18 at 23:41












          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%2f231457%2fhow-to-fetch-order-number-payment-method-and-customer-name-according-to-invoice%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          1 Answer
          1






          active

          oldest

          votes








          1 Answer
          1






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes









          0














          Please find the below answer to get order number,order information,payment method and customer name based on invoice id --



          <?php
          require_once('./app/Mage.php');
          Mage::app();

          $invoiceid =15;

          /* get invoice collection */
          $invoicecollection = Mage::getModel("sales/order_invoice")->getCollection()
          ->addFieldToFilter('entity_id',$invoiceid)
          ->getData();

          /* get order number and collection with customer name */
          $orderId = $invoicecollection[0]['order_id'];
          $order = Mage::getModel('sales/order')->load($orderId);

          //echo "<pre>"; print_r($order->getData());
          echo $order->getCustomerFirstname();

          /* get payment information and card type */
          $payment = $order->getPayment();
          //echo "<pre>"; print_r($payment->getData());
          echo $payment['cc_type'];

          //Get Payment Info
          echo $payment->getMethodInstance()->getCode();
          echo $payment->getMethodInstance()->getTitle();

          ?>





          share|improve this answer
























          • This might be correct but what I`m looking is for to fetch the order number, customer name and payment method according to invoice number on admin panel grid!

            – Darshan Jethwa
            Jun 26 '18 at 23:41
















          0














          Please find the below answer to get order number,order information,payment method and customer name based on invoice id --



          <?php
          require_once('./app/Mage.php');
          Mage::app();

          $invoiceid =15;

          /* get invoice collection */
          $invoicecollection = Mage::getModel("sales/order_invoice")->getCollection()
          ->addFieldToFilter('entity_id',$invoiceid)
          ->getData();

          /* get order number and collection with customer name */
          $orderId = $invoicecollection[0]['order_id'];
          $order = Mage::getModel('sales/order')->load($orderId);

          //echo "<pre>"; print_r($order->getData());
          echo $order->getCustomerFirstname();

          /* get payment information and card type */
          $payment = $order->getPayment();
          //echo "<pre>"; print_r($payment->getData());
          echo $payment['cc_type'];

          //Get Payment Info
          echo $payment->getMethodInstance()->getCode();
          echo $payment->getMethodInstance()->getTitle();

          ?>





          share|improve this answer
























          • This might be correct but what I`m looking is for to fetch the order number, customer name and payment method according to invoice number on admin panel grid!

            – Darshan Jethwa
            Jun 26 '18 at 23:41














          0












          0








          0







          Please find the below answer to get order number,order information,payment method and customer name based on invoice id --



          <?php
          require_once('./app/Mage.php');
          Mage::app();

          $invoiceid =15;

          /* get invoice collection */
          $invoicecollection = Mage::getModel("sales/order_invoice")->getCollection()
          ->addFieldToFilter('entity_id',$invoiceid)
          ->getData();

          /* get order number and collection with customer name */
          $orderId = $invoicecollection[0]['order_id'];
          $order = Mage::getModel('sales/order')->load($orderId);

          //echo "<pre>"; print_r($order->getData());
          echo $order->getCustomerFirstname();

          /* get payment information and card type */
          $payment = $order->getPayment();
          //echo "<pre>"; print_r($payment->getData());
          echo $payment['cc_type'];

          //Get Payment Info
          echo $payment->getMethodInstance()->getCode();
          echo $payment->getMethodInstance()->getTitle();

          ?>





          share|improve this answer













          Please find the below answer to get order number,order information,payment method and customer name based on invoice id --



          <?php
          require_once('./app/Mage.php');
          Mage::app();

          $invoiceid =15;

          /* get invoice collection */
          $invoicecollection = Mage::getModel("sales/order_invoice")->getCollection()
          ->addFieldToFilter('entity_id',$invoiceid)
          ->getData();

          /* get order number and collection with customer name */
          $orderId = $invoicecollection[0]['order_id'];
          $order = Mage::getModel('sales/order')->load($orderId);

          //echo "<pre>"; print_r($order->getData());
          echo $order->getCustomerFirstname();

          /* get payment information and card type */
          $payment = $order->getPayment();
          //echo "<pre>"; print_r($payment->getData());
          echo $payment['cc_type'];

          //Get Payment Info
          echo $payment->getMethodInstance()->getCode();
          echo $payment->getMethodInstance()->getTitle();

          ?>






          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered Jun 26 '18 at 23:22









          ramesh dramesh d

          162




          162













          • This might be correct but what I`m looking is for to fetch the order number, customer name and payment method according to invoice number on admin panel grid!

            – Darshan Jethwa
            Jun 26 '18 at 23:41



















          • This might be correct but what I`m looking is for to fetch the order number, customer name and payment method according to invoice number on admin panel grid!

            – Darshan Jethwa
            Jun 26 '18 at 23:41

















          This might be correct but what I`m looking is for to fetch the order number, customer name and payment method according to invoice number on admin panel grid!

          – Darshan Jethwa
          Jun 26 '18 at 23:41





          This might be correct but what I`m looking is for to fetch the order number, customer name and payment method according to invoice number on admin panel grid!

          – Darshan Jethwa
          Jun 26 '18 at 23:41


















          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%2f231457%2fhow-to-fetch-order-number-payment-method-and-customer-name-according-to-invoice%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

          “%fieldName is a required field.”, in Magento2 REST API Call for GET Method Type The Next...

          How to change City field to a dropdown in Checkout step Magento 2Magento 2 : How to change UI field(s)...

          夢乃愛華...