Mryntu

Multi tool use

How to write the block matrix in LaTex?

When Does an Atlas Uniquely Define a Manifold?

What can we do to stop prior company from asking us questions?

Why is there a PLL in CPU?

What's the point of interval inversion?

Is a stroke of luck acceptable after a series of unfavorable events?

What is the purpose of the Evocation wizard's Potent Cantrip feature?

Why does standard notation not preserve intervals (visually)

Can I equip Skullclamp on a creature I am sacrificing?

Rotate a column

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

How to use tikz in fbox?

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

Implement the Thanos sorting algorithm

Is it okay to store user locations?

How to write papers efficiently when English isn't my first language?

Is HostGator storing my password in plaintext?

Why does C# sound extremely flat when saxophone is tuned to G?

I believe this to be a fraud - hired, then asked to cash check and send cash as Bitcoin

How should I support this large drywall patch?

How can I get through very long and very dry, but also very useful technical documents when learning a new tool?

Was a professor correct to chastise me for writing "Prof. X" rather than "Professor X"?

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

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?

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?

magento-1.9 sales-order invoice

share|improve this question

edited 31 mins ago

Teja Bhagavan Kollepara

3,01241949

asked Jun 26 '18 at 22:14

Darshan JethwaDarshan Jethwa

166

add a comment | 

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?

magento-1.9 sales-order invoice

share|improve this question

edited 31 mins ago

Teja Bhagavan Kollepara

3,01241949

asked Jun 26 '18 at 22:14

Darshan JethwaDarshan Jethwa

166

add a comment | 

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

edited 31 mins ago

Teja Bhagavan Kollepara

3,01241949

asked Jun 26 '18 at 22:14

Darshan JethwaDarshan Jethwa

166

share|improve this question

edited 31 mins ago

Teja Bhagavan Kollepara

3,01241949

asked Jun 26 '18 at 22:14

Darshan JethwaDarshan Jethwa

166

share|improve this question

edited 31 mins ago

Teja Bhagavan Kollepara

3,01241949

asked Jun 26 '18 at 22:14

Darshan JethwaDarshan Jethwa

166

edited 31 mins ago

Teja Bhagavan Kollepara

3,01241949

edited 31 mins ago

Teja Bhagavan Kollepara

3,01241949

asked Jun 26 '18 at 22:14

Darshan JethwaDarshan Jethwa

166

asked Jun 26 '18 at 22:14

Darshan JethwaDarshan Jethwa

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

answered Jun 26 '18 at 23:22

ramesh dramesh d

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
  

  
  
  
  

add a comment | 

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

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

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

Name

Email

Required, but never shown

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

answered Jun 26 '18 at 23:22

ramesh dramesh d

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
  

  
  
  
  

add a comment | 

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

answered Jun 26 '18 at 23:22

ramesh dramesh d

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
  

  
  
  
  

add a comment | 

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

answered Jun 26 '18 at 23:22

ramesh dramesh d

162

<?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

answered Jun 26 '18 at 23:22

ramesh dramesh d

162

answered Jun 26 '18 at 23:22

ramesh dramesh d

162

answered Jun 26 '18 at 23:22

ramesh dramesh d

162