Magento – Getting payment info on help

magento-1.7

Here us the whole thing that i am not able to solve it. i am trying to pass all order info, customer info and payment info through an event oberver and inserting to another db. Right now everything is working fine and i successfully insert order info,customer info. What i can not get is the payment info such as credit card info, authorization code info.

Here is my code:

On the config.xml file i have this event observer:

<sales_order_place_after>
            <observers>
                <insertorder_orderexport>
                    <class>insertorder_orderexport/observer</class>
                    <method>exportOrder</method>
                </insertorder_orderexport>
            </observers>
</sales_order_place_after>

On my function i have this observer.php i have this code:

class InsertOrder_OrderExport_Model_Observer {


public function exportOrder(Varien_Event_Observer $observer) {

    $order = $observer->getEvent()->getOrder();

    Mage::getModel('insertorder_orderexport/export')->exportOrder($order);

return true;

}

}

on my export.php i have this code:

class InsertOrder_OrderExport_Model_Export
{

public function exportOrder($order)
{

    include('classes.php');

 $getCcInfo = Mage::getModel('sales/order')->getCollection()->setPageSize(1)->setOrder('created_at')->getFirstItem();
    $order_data = $getCcInfo->getPayment()->getData('additional_information');

    if(!empty($order_data)){

    foreach($order_data as $value){

        $aPayment = new OrderPayment;
        $aPayment->CreditCardNumber    = $value['cc_last4'];
        $aPayment->AuthorisationNumber = $value['approval_code'];
    }

    }

The code continue with other classes and insertions like order and customer info but eveything is tested and works fine beside this block of code which ends up empty.

The strange thing is that when i test this code on magento root folder i get the results i want lets say when i print_r($order_data); i get this result:

Array
(

[1dccc017a3fa2a84bad51ece5cbffd20] => Array
    (
        [id] => 1dccc017a3fa2a84bad51ece5cbffd20
        [requested_amount] => 
        [balance_on_card] => 
        [last_trans_id] => 2201005063
        [processed_amount] => 6.94
        [cc_type] => VI
        [cc_owner] => 
        [cc_last4] => 1111
        [cc_exp_month] => 4
        [cc_exp_year] => 2018
        [cc_ss_issue] => 
        [cc_ss_start_month] => 
        [cc_ss_start_year] => 
        [approval_code] => 8Z0LNX
    )
)

So it means that $order_data is full with values but i don't understand why it ends up empty after.

Also i have tried other events like:

checkout_onepage_controller_success_action

checkout_submit_all_after

Still no results. And i don't have any error in my log file.

Please professional users help me, Thank you

Best Answer

I think you simply need to remove the foreach loop.

foreach($order_data as $value){
    // $value is now $order_data['id'] or some such
    // and when you call $value['cc_last4']
    // you're mistakenly looking in $order_data['id']['cc_last4']
}

Just use this instead:

if(!empty($order_data)){
    $aPayment = new OrderPayment;
    $aPayment->CreditCardNumber    = $value['cc_last4'];
    $aPayment->AuthorisationNumber = $value['approval_code'];
}

Related Solutions

Magento Config.xml – Using Dynamic Info

See my example:
1.Your cron configuration in config.xml:

 <crontab>
        <jobs>
            <uzkart_fetch_payment>
                <run>
                    <model>uzkart/observer::uzkart_fetch_payment</model>
                </run>
            </uzkart_fetch_payment>
        </jobs>
  </crontab>

2.Create cron time configuration in your system.xml:

<config>
    <sections>
        <payment>
            <groups>
                <uzkart_standard translate="label" module="uzkart">
                    <label>Uzkart Standard Payment</label>
                    <sort_order>1</sort_order>
                    <show_in_default>1</show_in_default>
                    <show_in_website>1</show_in_website>
                    <show_in_store>1</show_in_store>
                    <fields>
                        <!--maybe another fields here-->
                        <frequency translate="label">
                            <label>Frequency</label>
                            <frontend_type>select</frontend_type>
                            <source_model>adminhtml/system_config_source_cron_frequency</source_model>
                            <!-- Custom backend model which saves cron configuration -->
                            <backend_model>uzkart/adminhtml_system_config_backend_payment_cron</backend_model>
                            <sort_order>200</sort_order>
                            <show_in_default>1</show_in_default>
                            <show_in_website>1</show_in_website>
                            <show_in_store>1</show_in_store>
                            <comment>Payment Fetch Frequency</comment>
                        </frequency>
                        <!-- Cron job time -->
                        <time translate="label">
                            <label>Start Time</label>
                            <frontend_type>time</frontend_type>
                            <sort_order>201</sort_order>
                            <show_in_default>1</show_in_default>
                            <show_in_website>1</show_in_website>
                            <show_in_store>1</show_in_store>
                        </time>
                    </fields>
                </uzkart_standard>
            </groups>
        </payment>
    </sections>
</config>

It shows following configuration in admin: enter image description here

3.Backend model
<backend_model>uzkart/adminhtml_system_config_backend_payment_cron</backend_model>
refers to this model:

class SSD_Uzkart_Model_Adminhtml_System_Config_Backend_Payment_Cron extends Mage_Core_Model_Config_Data
{
    const CRON_STRING_PATH = 'crontab/jobs/uzkart_fetch_payment/schedule/cron_expr';
    const CRON_MODEL_PATH = 'crontab/jobs/uzkart_fetch_payment/run/model';

    protected function _afterSave()
    {
        $time = $this->getData('groups/uzkart_standard/fields/time/value');
        $frequncy = $this->getData('groups/uzkart_standard/frequency/value');

        $frequencyDaily = Mage_Adminhtml_Model_System_Config_Source_Cron_Frequency::CRON_DAILY;
        $frequencyWeekly = Mage_Adminhtml_Model_System_Config_Source_Cron_Frequency::CRON_WEEKLY;
        $frequencyMonthly = Mage_Adminhtml_Model_System_Config_Source_Cron_Frequency::CRON_MONTHLY;

        $cronDayOfWeek = date('N');

        $cronExprArray = array(
            intval($time[1]),                                   # Minute
            intval($time[0]),                                   # Hour
            ($frequncy == $frequencyMonthly) ? '1' : '*',       # Day of the Month
            '*',                                                # Month of the Year
            ($frequncy == $frequencyWeekly) ? '1' : '*',        # Day of the Week
        );

        $cronExprString = join(' ', $cronExprArray);

        try {
            Mage::getModel('core/config_data')
                ->load(self::CRON_STRING_PATH, 'path')
                ->setValue($cronExprString)
                ->setPath(self::CRON_STRING_PATH)
                ->save();
            Mage::getModel('core/config_data')
                ->load(self::CRON_MODEL_PATH, 'path')
                ->setValue((string) Mage::getConfig()->getNode(self::CRON_MODEL_PATH))
                ->setPath(self::CRON_MODEL_PATH)
                ->save();
        } catch (Exception $e) {
            throw new Exception(Mage::helper('cron')->__('Unable to save the cron expression.'));
        }
    }
}

4.When you save your configuration in admin, it will generate following lines in core_config_data table of magento and magento cron scheduler will use this config:

enter image description here

Magento – Show popup with item info on clicking add to cart

Follow below steps for creating popup window, you will need to create your block for displaying the attributes.

add include below files using layout xml

<action method="addItem"><type>js</type><name>prototype/window.js</name></action>
<action method="addItem"><type>js_css</type><name>prototype/windows/themes/default.css</name></action>
<action method="addCss"><name>lib/prototype/windows/themes/magento.css</name></action>

below is the prototype function which will invoke the widowbox

function showPopup(sUrl) {
    oPopup = new Window({
    id:'popup_window',
    className: 'magento',
    url: sUrl,
    width: 820,
    height: 600,
    minimizable: false,
    maximizable: false,
    showEffectOptions: {
        duration: 0.4
    },
    hideEffectOptions:{
        duration: 0.4
    },
    destroyOnClose: true
    });
    oPopup.setZIndex(100);
    oPopup.showCenter(true);
}

function closePopup() {
    Windows.close('popup_window');
}

invoke function using below code

$('test_me').observe('click', function(event) {
    showPopup('<?php echo Mage::getUrl("here_url_of_block_which_will_have_those_attributes") ?>');
    //Event.stop(oEvent);
});

Best Answer

Related Solutions

Magento Config.xml – Using Dynamic Info

Magento – Show popup with item info on clicking add to cart

Related Topic