How to get info_buyRequest in magento admin panel? -
hi need view 1 additional product attribute in magento admin panel. need info_buyrequest->projectid. database table sales_flat_order_item field name product_options
my record given below
a:7:{s:15:"info_buyrequest";a:9:{s:2:"id";s:3:"715";s:7:"product";s:3:"288";s:15:"related_product";s:0:"";s:15:"super_attribute";a:2:{i:143;s:2:"69";i:144;s:2:"71";}s:7:"options";a:4:{i:79;s:3:"165";i:80;s:3:"166";i:78;s:3:"163";i:81;s:3:"359";}s:15:"attachment_hash";a:1:{i:215;s:32:"cbe019a075d376c0632dae49774370bb";}s:9:"projectid";s:2:"39";s:3:"qty";i:1;s:11:"reset_count";b:1;}s:7:"options";a:4:{i:0;a:7:{s:5:"label";s:7:"coating";s:5:"value";s:21:"uv - ultra high gloss";s:11:"print_value";s:21:"uv - ultra high gloss";s:9:"option_id";s:2:"79";s:11:"option_type";s:9:"drop_down";s:12:"option_value";s:3:"165";s:11:"custom_view";b:0;}i:1;a:7:{s:5:"label";s:6:"colors";s:5:"value";s:18:"full color 2 sides";s:11:"print_value";s:18:"full color 2 sides";s:9:"option_id";s:2:"80";s:11:"option_type";s:9:"drop_down";s:12:"option_value";s:3:"166";s:11:"custom_view";b:0;}i:2;a:7:{s:5:"label";s:5:"paper";s:5:"value";s:20:"14pt thick cardstock";s:11:"print_value";s:20:"14pt thick cardstock";s:9:"option_id";s:2:"78";s:11:"option_type";s:9:"drop_down";s:12:"option_value";s:3:"163";s:11:"custom_view";b:0;}i:3;a:7:{s:5:"label";s:13:"need design";s:5:"value";s:20:"yes, need design";s:11:"print_value";s:20:"yes, need design";s:9:"option_id";s:2:"81";s:11:"option_type";s:9:"drop_down";s:12:"option_value";s:3:"359";s:11:"custom_view";b:0;}}s:15:"attributes_info";a:2:{i:0;a:2:{s:5:"label";s:8:"quantity";s:5:"value";s:4:"1000";}i:1;a:2:{s:5:"label";s:10:"turnaround";s:5:"value";s:15:"4 business days";}}s:11:"simple_name";s:34:"2.75x4 flyers-1000-4 business days";s:10:"simple_sku";s:33:"275x4-flyers-1000-4 business days";s:20:"product_calculations";i:1;s:13:"shipment_type";i:0;}
i need projectid in magento admin panel
admin/sales_order/view/order_id/43/ page
how can please advise...
take getadditionaldata()
in mage_sales_model_order_item
try
$order = mage::getmodel('sales/order')->loadbyincrementid($order_id); $items = $order->getallvisibleitems(); foreach ($items $itemid => $item){ $item->getadditionaldata('projectid') }
Comments
Post a Comment