Magento add Custom column to order and quote entity

127 篇文章 0 订阅

1. in upgrade script:

<?php
$installer = new Mage_Sales_Model_Resource_Setup('core_setup');
/**
 * Add 'checkout_process' attribute for entities
*/
$entities = array(
		'quote',
		'order'
);
$options = array(
		'type'     => Varien_Db_Ddl_Table::TYPE_INTEGER,
		'visible'  => true,
		'required' => false
);
foreach ($entities as $entity) {
	$installer->addAttribute($entity, 'checkout_process', $options);
}
$installer->endSetup();

 2. in config.xml file:

 

  <global>
<fieldsets>
    	 <sales_convert_quote>                           
                <checkout_process><to_order>*</to_order></checkout_process>
            </sales_convert_quote>
            <sales_convert_order>                                              
                <checkout_process><to_quote>*</to_quote></checkout_process>
            </sales_convert_order>
<fieldsets>
<events>
        <checkout_type_onepage_save_order>
			<observers>
				<change_checkout_process_observer>
					<type>singleton</type>
					<class>mycheckout/observer</class>
					<method>saveCheckoutProcessToOrder</method>
				</change_checkout_process_observer>
			</observers>
		</checkout_type_onepage_save_order>
    </events>
</global>

 in Observer file:

   public function saveCheckoutProcessToOrder($observer) {
	   	$event = $observer->getEvent();
	   	$order = $event->getOrder();
	   	$quote = $event->getQuote();
	   	$ordered_items = $order->getAllItems();
	   	foreach ($ordered_items as $item) {
	   		$product = Mage::getModel('catalog/product')->loadByAttribute('sku', $item->getSku());
	   		$checkout_process= $product->getData('checkout_process');
	   		$order->setData('checkout_process', $checkout_process);
	   		$quote->setData('checkout_process', $checkout_process);
	   		return $this;
	   	}
   }

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值