Hjdcti

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

Unreliable Magic - Is it worth it?

How long to clear the 'suck zone' of a turbofan after start is initiated?

How do I solve this limit?

Why did we only see the N-1 starfighters in one film?

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

Describing a person. What needs to be mentioned?

% symbol leads to superlong (forever?) compilations

Is it okay to store user locations?

How can I quit an app using Terminal?

Why here is plural "We went to the movies last night."

Is HostGator storing my password in plaintext?

The King's new dress

Go Pregnant or Go Home

How to start emacs in "nothing" mode (`fundamental-mode`)

What happens if you roll doubles 3 times then land on "Go to jail?"

What makes a siege story/plot interesting?

Why didn't Khan get resurrected in the Genesis Explosion?

How to get regions to plot as graphics

How to use tikz in fbox?

What do "high sea" and "carry" mean in this sentence?

How to write the block matrix in LaTex?

Text adventure game code

Implement the Thanos sorting algorithm

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

Teja Bhagavan Kollepara

3,01241949

asked Jun 26 '18 at 22:14

Darshan JethwaDarshan Jethwa

166

share|improve this question

edited 19 mins ago

Teja Bhagavan Kollepara

3,01241949

asked Jun 26 '18 at 22:14

Darshan JethwaDarshan Jethwa

166

share|improve this question

edited 19 mins ago

Teja Bhagavan Kollepara

3,01241949

asked Jun 26 '18 at 22:14

Darshan JethwaDarshan Jethwa

166

edited 19 mins ago

Teja Bhagavan Kollepara

3,01241949

edited 19 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