Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

magento which table store the order payment method
 
esnowxu
Jr. Member
 
Total Posts:  19
Joined:  2008-12-28
 

magento which table store the order payment method.
Under magento 1.1.6 and 1.1.7
Who can help me?

 
Magento Community Magento Community
Magento Community
Magento Community
 
subesh
Sr. Member
 
Avatar
Total Posts:  145
Joined:  2009-01-08
 

sales_flat_quote_payment for 1.1.7

 
Magento Community Magento Community
Magento Community
Magento Community
 
esnowxu
Jr. Member
 
Total Posts:  19
Joined:  2008-12-28
 

search the sales_order how to join the table?

 
Magento Community Magento Community
Magento Community
Magento Community
 
subesh
Sr. Member
 
Avatar
Total Posts:  145
Joined:  2009-01-08
 

I think the flow is from

sales_order ->sales_order_entity->sales_order_entity_varchar

 
Magento Community Magento Community
Magento Community
Magento Community
 
mzentrale1
Guru
 
Total Posts:  731
Joined:  2007-12-06
Stuttgart, Germany
 

Hi,

if you want the paymentinformations of an order you can load the order and get the payment infos:

$order Mage::getModel('sales/order');
$order->loadByIncrementId($val);

echo 
"<pre>";
print_r($order->getPayment());

or 

echo 
$order->getPayment()->getMethod();

cheers

 
Magento Community Magento Community
Magento Community
Magento Community
 
esnowxu
Jr. Member
 
Total Posts:  19
Joined:  2008-12-28
 

Thank for you replay.

$collection Mage::getResourceModel('sales/order_collection')
            ->
addAttributeToSelect('*')
            ->
joinAttribute('billing_firstname''order_address/firstname''billing_address_id'null'left')
            ->
joinAttribute('billing_lastname''order_address/lastname''billing_address_id'null'left')
            ->
joinAttribute('shipping_firstname''order_address/firstname''shipping_address_id'null'left')
            ->
joinAttribute('shipping_lastname''order_address/lastname''shipping_address_id'null'left')
            ->
addExpressionAttributeToSelect('billing_name',
                
'CONCAT({{billing_firstname}}, " ", {{billing_lastname}})',
                array(
'billing_firstname''billing_lastname'))
            ->
addExpressionAttributeToSelect('shipping_name',
                
'CONCAT({{shipping_firstname}}, " ", {{shipping_lastname}})',
                array(
'shipping_firstname''shipping_lastname'));
In this scope how to get the order payment method?
Under 1.1.6 and 1.1.7 .
 
Magento Community Magento Community
Magento Community
Magento Community
 
subesh
Sr. Member
 
Avatar
Total Posts:  145
Joined:  2009-01-08
 

->joinAttribute('billing_method''sales/order_payment''quote_id, null, 'left')
Add the above code

I got by this method.....Y are you not getting I don’t know my Magento V1.1.7 rasberry

 
Magento Community Magento Community
Magento Community
Magento Community
 
esnowxu
Jr. Member
 
Total Posts:  19
Joined:  2008-12-28
 

Thank you.
Which magento version are you use?

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top