public function _toHtml() { $script = '<script type="text/javascript"> if(typeof(jQueryIWD) == "undefined"){if(typeof(jQuery) != "undefined") {jQueryIWD = jQuery;}} $ji = jQueryIWD; if($ji("#customer_orders_grid_table").length) { IWD.OrderManager.Grid.ColorGridRow(); if($ji.isFunction($ji.fn.stickyTableHeaders)){$ji("#customer_orders_grid_table").stickyTableHeaders();} } </script>'; return parent::_toHtml() . $script; }
protected function _prepareColumns() { parent::_prepareColumns(); $_39cc59a647aed4446ab8f3ef32b7135f664a845f = Mage::getModel('sublogin/sublogin')->getCollection(); if (Mage::registry('current_customer')->getId()) { $_39cc59a647aed4446ab8f3ef32b7135f664a845f->addFieldToFilter('entity_id', Mage::registry('current_customer')->getId()); } $_18254cfced00997c538772b34da78f09931948f4 = array(); foreach ($_39cc59a647aed4446ab8f3ef32b7135f664a845f as $_17fe0f58f521a1d8d613a93097a5a22f2074c04f) { $_18254cfced00997c538772b34da78f09931948f4[$_17fe0f58f521a1d8d613a93097a5a22f2074c04f->getId()] = $_17fe0f58f521a1d8d613a93097a5a22f2074c04f->getEmail(); } $this->addColumnAfter('sublogin_id', array('header' => Mage::helper('customer')->__('Sublogin Email'), 'index' => 'sublogin_id', 'type' => 'options', 'options' => $_18254cfced00997c538772b34da78f09931948f4), 'created_at'); $this->sortColumnsByOrder(); return $this; }
/** * Prepare columns for orders grid in customer account (Admin side) * * @return $this * @throws Exception */ protected function _prepareColumns() { $helper = Mage::helper('mageworx_orderspro'); if (!$helper->isEnabled()) { return parent::_prepareColumns(); } $listColumns = $helper->getCustomerGridColumns(); //$currencyCode = $helper->getCurrentCurrencyCode(); foreach ($listColumns as $column) { switch ($column) { // standard fields case 'increment_id': $this->addColumn('increment_id', array('header' => Mage::helper('customer')->__('Order #'), 'width' => '80px', 'type' => 'text', 'index' => 'increment_id')); break; case 'created_at': $this->addColumn('created_at', array('header' => Mage::helper('customer')->__('Purchase On'), 'index' => 'created_at', 'type' => 'datetime', 'width' => '100px')); break; case 'billing_name': $this->addColumn('billing_name', array('header' => Mage::helper('customer')->__('Bill to Name'), 'index' => 'billing_name')); break; case 'shipping_name': $this->addColumn('shipping_name', array('header' => Mage::helper('customer')->__('Shiped to Name'), 'index' => 'shipping_name')); break; case 'grand_total': $this->addColumn('grand_total', array('header' => Mage::helper('customer')->__('Order Total'), 'index' => 'grand_total', 'type' => 'currency', 'currency' => 'order_currency_code')); break; case 'store_id': if (!Mage::app()->isSingleStoreMode()) { $this->addColumn('store_id', array('header' => Mage::helper('customer')->__('Bought From'), 'index' => 'store_id', 'type' => 'store', 'store_view' => true)); } break; case 'action': $this->addColumn('action', array('header' => ' ', 'filter' => false, 'sortable' => false, 'width' => '100px', 'renderer' => 'adminhtml/sales_reorder_renderer_action')); break; // additional fields // additional fields case 'product_names': $this->addColumn('product_names', array('renderer' => 'mageworx_orderspro/adminhtml_sales_order_grid_renderer_products', 'header' => $helper->__('Product Name(s)') . ' ', 'index' => 'product_names')); break; case 'product_skus': $this->addColumn('product_skus', array('renderer' => 'mageworx_orderspro/adminhtml_sales_order_grid_renderer_products', 'header' => $helper->__('SKU(s)'), 'index' => 'skus')); break; case 'product_options': $this->addColumn('product_options', array('renderer' => 'mageworx_orderspro/adminhtml_sales_order_grid_renderer_products', 'header' => $helper->__('Product Option(s)'), 'index' => 'product_options', 'filter' => false, 'sortable' => false)); break; case 'customer_email': $this->addColumn('customer_email', array('type' => 'text', 'header' => $helper->__('Customer Email'), 'index' => 'customer_email')); break; case 'customer_group': $this->addColumn('customer_group', array('renderer' => 'mageworx_orderspro/adminhtml_sales_order_grid_renderer_registry', 'type' => 'options', 'options' => $helper->getCustomerGroups(), 'header' => $helper->__('Customer Group'), 'index' => 'customer_group_id', 'align' => 'center')); break; case 'payment_method': $this->addColumn('payment_method', array('renderer' => 'mageworx_orderspro/adminhtml_sales_order_grid_renderer_registry', 'type' => 'options', 'options' => $helper->getAllPaymentMethods(), 'header' => $helper->__('Payment Method'), 'index' => 'method', 'align' => 'center')); break; case 'base_total_refunded': $this->addColumn('base_total_refunded', array('type' => 'currency', 'currency' => 'base_currency_code', 'header' => $helper->__('Total Refunded (Base)'), 'index' => 'base_total_refunded', 'total' => 'sum')); break; case 'total_refunded': $this->addColumn('total_refunded', array('type' => 'currency', 'currency' => 'order_currency_code', 'header' => $helper->__('Total Refunded (Purchased)'), 'index' => 'total_refunded', 'total' => 'sum')); break; case 'shipping_method': $this->addColumn('shipping_method', array('renderer' => 'mageworx_orderspro/adminhtml_sales_order_grid_renderer_registry', 'type' => 'options', 'options' => $helper->getAllShippingMethods(), 'filter' => 'mageworx_orderspro/adminhtml_sales_order_grid_filter_shipping', 'header' => $helper->__('Shipping Method'), 'index' => 'shipping_method', 'align' => 'center')); break; case 'tracking_number': $this->addColumn('tracking_number', array('renderer' => 'mageworx_orderspro/adminhtml_sales_order_grid_renderer_street', 'type' => 'text', 'header' => $helper->__('Tracking Number'), 'index' => 'tracking_number')); break; case 'shipped': $this->addColumn('shipped', array('renderer' => 'mageworx_orderspro/adminhtml_sales_order_grid_renderer_registry', 'type' => 'options', 'options' => $helper->getShippedStatuses(), 'header' => $helper->__('Shipped'), 'index' => 'shipped', 'align' => 'center')); break; case 'order_group': $this->addColumn('order_group', array('renderer' => 'mageworx_orderspro/adminhtml_sales_order_grid_renderer_registry', 'type' => 'options', 'options' => $helper->getOrderGroups(), 'header' => $helper->__('Group'), 'index' => 'order_group_id', 'align' => 'center')); break; case 'qnty': $this->addColumn('qnty', array('renderer' => 'mageworx_orderspro/adminhtml_sales_order_grid_renderer_qnty', 'filter' => false, 'sortable' => false, 'header' => $helper->__('Qnty'), 'index' => 'total_qty')); break; case 'weight': $this->addColumn('weight', array('type' => 'number', 'header' => $helper->__('Weight'), 'index' => 'weight')); break; case 'base_tax_amount': $this->addColumn('base_tax_amount', array('type' => 'currency', 'currency' => 'base_currency_code', 'header' => $helper->__('Tax Amount (Base)'), 'index' => 'base_tax_amount')); break; case 'tax_amount': $this->addColumn('tax_amount', array('type' => 'currency', 'currency' => 'order_currency_code', 'header' => $helper->__('Tax Amount (Purchased)'), 'index' => 'tax_amount')); break; case 'base_discount_amount': $this->addColumn('base_discount_amount', array('type' => 'currency', 'currency' => 'base_currency_code', 'header' => $helper->__('Discount (Base)'), 'index' => 'base_discount_amount')); break; case 'discount_amount': $this->addColumn('discount_amount', array('type' => 'currency', 'currency' => 'order_currency_code', 'header' => $helper->__('Discount (Purchased)'), 'index' => 'discount_amount')); break; case 'base_internal_credit': if (Mage::getConfig()->getModuleConfig('MageWorx_CustomerCredit')->is('active', true)) { $this->addColumn('base_internal_credit', array('type' => 'currency', 'currency' => 'base_currency_code', 'header' => $helper->__('Internal Credit (Base)'), 'index' => 'base_customer_credit_amount')); } break; case 'internal_credit': if (Mage::getConfig()->getModuleConfig('MageWorx_CustomerCredit')->is('active', true)) { $this->addColumn('internal_credit', array('type' => 'currency', 'currency' => 'order_currency_code', 'header' => $helper->__('Internal Credit (Purchased)'), 'index' => 'customer_credit_amount')); } break; case 'coupon_code': $this->addColumn('coupon_code', array('type' => 'text', 'header' => $helper->__('Coupon Code'), 'align' => 'center', 'index' => 'coupon_code')); break; case 'is_edited': $this->addColumn('is_edited', array('renderer' => 'mageworx_orderspro/adminhtml_sales_order_grid_renderer_registry', 'type' => 'options', 'options' => $helper->getEditedStatuses(), 'header' => $helper->__('Edited'), 'index' => 'is_edited', 'align' => 'center')); break; case 'status': $this->addColumn('status', array('header' => Mage::helper('sales')->__('Status'), 'index' => 'status', 'type' => 'options', 'width' => '70px', 'options' => Mage::getSingleton('sales/order_config')->getStatuses())); break; case 'order_comment': $this->addColumn('order_comment', array('renderer' => 'mageworx_orderspro/adminhtml_sales_order_grid_renderer_comments', 'header' => $helper->__('Order Comment(s)'), 'index' => 'order_comment')); break; } } $this->sortColumnsByOrder(); return $this; }
protected function _prepareColumns() { $enabledCustomGrid = Mage::getStoreConfig('orderview/general/enabled'); if (isset($enabledCustomGrid) && $enabledCustomGrid == 1) { $selectedColumns = Mage::getStoreConfig('orderview/general/order_grid_col'); $selectedColumnsArray = explode(",", $selectedColumns); /* Active payment methods*/ $payments = Mage::getSingleton('payment/config')->getActiveMethods(); $methods = array(); foreach ($payments as $paymentCode => $paymentModel) { $paymentTitle = Mage::getStoreConfig('payment/' . $paymentCode . '/title'); $methods[$paymentCode] = $paymentTitle; } /* Active payment methods ends*/ foreach ($selectedColumnsArray as $orderColumn) { switch ($orderColumn) { case 'real_order_id': $this->addColumn('real_order_id', array('header' => Mage::helper('sales')->__('Order #'), 'width' => '80px', 'type' => 'text', 'index' => 'increment_id')); break; case 'store_id': if (!Mage::app()->isSingleStoreMode()) { $this->addColumn('store_id', array('header' => Mage::helper('sales')->__('Purchased From (Store)'), 'index' => 'store_id', 'type' => 'store', 'store_view' => true, 'display_deleted' => true)); } break; case 'created_at': $this->addColumn('created_at', array('header' => Mage::helper('sales')->__('Purchased On'), 'index' => 'created_at', 'type' => 'datetime', 'width' => '100px')); break; case 'product_detail': $this->addColumn('name', array('header' => Mage::helper('catalog')->__('Product Name'), 'index' => 'name', 'type' => 'text', 'renderer' => new Magedev_Ordermanager_Block_Adminhtml_Ordermanager_Grid_Renderer_Customertarget())); break; case 'product_options': $this->addColumn('product_options', array('header' => Mage::helper('sales')->__('Product Option(s) '), 'type' => 'text', 'width' => '1550px', 'index' => 'product_options', 'renderer' => new Magedev_Ordermanager_Block_Adminhtml_Ordermanager_Grid_Renderer_Options())); break; case 'product_sku': $this->addColumn('sku', array('header' => Mage::helper('sales')->__('SKU'), 'index' => 'sku', 'type' => 'text')); break; case 'qty': $this->addColumn('qty', array('header' => Mage::helper('sales')->__('Quantity '), 'index' => 'qty', 'type' => 'text', 'filter' => false, 'sortable' => false, 'width' => '150px', 'renderer' => new Magedev_Ordermanager_Block_Adminhtml_Ordermanager_Grid_Renderer_Quantity())); break; case 'weight': $this->addColumn('weight', array('header' => Mage::helper('sales')->__('Weight'), 'index' => 'weight', 'type' => 'number', 'filter_index' => 'sales_flat_order.weight')); break; case 'payment_method': $this->addColumn('method', array('header' => Mage::helper('sales')->__('Payment Method'), 'index' => 'method', 'type' => 'options', 'width' => '70px', 'options' => $methods)); break; case 'shipping_method': $this->addColumn('shipping_method', array('type' => 'options', 'options' => $this->getAvailableShippingMethods(), 'header' => Mage::helper('sales')->__('Shipping Method'), 'index' => 'shipping_method', 'align' => 'center')); break; case 'customer_email': $this->addColumn('customer_email', array('type' => 'text', 'header' => Mage::helper('sales')->__('Customer Email'), 'index' => 'customer_email')); break; case 'customer_group': $this->addColumn('customer_group_id', array('type' => 'options', 'options' => $this->getCustomerGroup(), 'header' => Mage::helper('sales')->__('Customer Group'), 'index' => 'customer_group_id')); break; case 'coupon_code': $this->addColumn('coupon_code', array('type' => 'text', 'header' => Mage::helper('sales')->__('Coupon Code'), 'align' => 'center', 'index' => 'coupon_code')); break; case 'billing_name': $this->addColumn('billing_name', array('header' => Mage::helper('sales')->__('Bill to Name'), 'index' => 'billing_name')); break; case 'billing_company': $this->addColumn('company', array('header' => Mage::helper('sales')->__('Bill Company'), 'index' => 'company', 'filter_index' => 'sfoab.company')); break; case 'billing_street': $this->addColumn('street', array('header' => Mage::helper('sales')->__('Bill Street'), 'index' => 'street', 'filter_index' => 'sfoab.street')); break; case 'billing_postcode': $this->addColumn('postcode', array('header' => Mage::helper('sales')->__('Bill Postcode'), 'index' => 'postcode', 'filter_index' => 'sfoab.postcode')); break; case 'billing_state': $this->addColumn('region', array('header' => Mage::helper('sales')->__('Bill Region'), 'index' => 'region', 'filter_index' => 'sfoab.region')); break; case 'billing_country': $this->addColumn('country_id', array('type' => 'country', 'header' => Mage::helper('sales')->__('Bill Country'), 'index' => 'country_id', 'filter_index' => 'sfoab.country_id')); break; case 'shipping_name': $this->addColumn('shipping_name', array('header' => Mage::helper('sales')->__('Ship to Name'), 'index' => 'shipping_name')); break; case 'shipping_company': $this->addColumn('shipcompany', array('header' => Mage::helper('sales')->__('Ship Company'), 'index' => 'shipcompany', 'filter_index' => 'sfoas.company')); break; case 'shipping_street': $this->addColumn('shipstreet', array('header' => Mage::helper('sales')->__('Ship Street'), 'index' => 'shipstreet', 'filter_index' => 'sfoas.street')); break; case 'shipping_postcode': $this->addColumn('shippostcode', array('header' => Mage::helper('sales')->__('Ship Postcode'), 'index' => 'shippostcode', 'filter_index' => 'sfoas.postcode')); break; case 'shipping_state': $this->addColumn('shipregion', array('header' => Mage::helper('sales')->__('Ship Region'), 'index' => 'shipregion', 'filter_index' => 'sfoas.region')); break; case 'shipping_country': $this->addColumn('shipcountry_id', array('type' => 'country', 'header' => Mage::helper('sales')->__('Ship Country'), 'index' => 'shipcountry_id', 'filter_index' => 'sfoas.country_id')); break; case 'base_tax_amount': $this->addColumn('base_tax_amount', array('header' => Mage::helper('sales')->__('Tax (Base)'), 'index' => 'base_tax_amount', 'type' => 'currency', 'currency' => 'base_currency_code')); break; case 'tax_amount': $this->addColumn('tax_amount', array('header' => Mage::helper('sales')->__('Tax (Purchased)'), 'index' => 'tax_amount', 'type' => 'currency', 'currency' => 'order_currency_code')); break; case 'base_discount_amount': $this->addColumn('base_discount_amount', array('header' => Mage::helper('sales')->__('Discount (Base)'), 'index' => 'base_discount_amount', 'type' => 'currency', 'currency' => 'base_currency_code')); break; case 'discount_amount': $this->addColumn('discount_amount', array('header' => Mage::helper('sales')->__('Discount (Purchased)'), 'index' => 'discount_amount', 'type' => 'currency', 'currency' => 'order_currency_code')); break; case 'base_total_refunded': $this->addColumn('base_total_refunded', array('header' => Mage::helper('sales')->__('Total Refunded (Base)'), 'index' => 'base_total_refunded', 'type' => 'currency', 'currency' => 'base_currency_code')); break; case 'total_refunded': $this->addColumn('total_refunded', array('header' => Mage::helper('sales')->__('Total Refunded (Purchased)'), 'index' => 'total_refunded', 'type' => 'currency', 'currency' => 'order_currency_code')); break; case 'base_grand_total': $this->addColumn('base_grand_total', array('header' => Mage::helper('sales')->__('G.T. (Base)'), 'index' => 'base_grand_total', 'type' => 'currency', 'currency' => 'base_currency_code')); break; case 'grand_total': $this->addColumn('grand_total', array('header' => Mage::helper('sales')->__('G.T. (Purchased)'), 'index' => 'grand_total', 'type' => 'currency', 'currency' => 'order_currency_code')); break; case 'status': $this->addColumn('status', array('header' => Mage::helper('sales')->__('Status'), 'index' => 'status', 'type' => 'options', 'width' => '70px', 'options' => Mage::getSingleton('sales/order_config')->getStatuses())); break; case 'tracking_number': $this->addColumn('tracking_number', array('header' => Mage::helper('catalog')->__('Tracking Number'), 'index' => 'tracking_number', 'filter' => false, 'sortable' => false, 'renderer' => new Magedev_Ordermanager_Block_Adminhtml_Ordermanager_Grid_Renderer_Tracking())); break; case 'order_type': $orderGroups = array('1' => 'Archived', '0' => 'Active'); $this->addColumn('is_archieved', array('type' => 'options', 'options' => $orderGroups, 'header' => Mage::helper('sales')->__('Order Type'), 'index' => 'is_archieved', 'filter_index' => 'main_table.is_archieved', 'align' => 'center')); break; /*case 'order_invoiced': $orderInvoiced = array('1'=>'Yes','0'=>'No'); $this->addColumn('total_invoiced', array( 'type' => 'options', 'options' => $orderInvoiced, 'header' => Mage::helper('sales')->__('Invoiced'), 'index'=>'total_invoiced', 'renderer' => new Magedev_Ordermanager_Block_Adminhtml_Ordermanager_Grid_Renderer_Invoiced(), // show comments row 'align' => 'center', )); break; case 'order_refunded': $orderRefunded = array('1'=>'Yes','0'=>'No'); $this->addColumn('total_refunded', array( 'type' => 'options', 'options' => $orderRefunded, 'header' => Mage::helper('sales')->__('Refunded'), 'index'=>'total_refunded', 'align' => 'center', )); break;*/ /*case 'order_invoiced': $orderInvoiced = array('1'=>'Yes','0'=>'No'); $this->addColumn('total_invoiced', array( 'type' => 'options', 'options' => $orderInvoiced, 'header' => Mage::helper('sales')->__('Invoiced'), 'index'=>'total_invoiced', 'renderer' => new Magedev_Ordermanager_Block_Adminhtml_Ordermanager_Grid_Renderer_Invoiced(), // show comments row 'align' => 'center', )); break; case 'order_refunded': $orderRefunded = array('1'=>'Yes','0'=>'No'); $this->addColumn('total_refunded', array( 'type' => 'options', 'options' => $orderRefunded, 'header' => Mage::helper('sales')->__('Refunded'), 'index'=>'total_refunded', 'align' => 'center', )); break;*/ case 'is_edited': $isEdited = array('1' => 'Yes', '0' => 'No'); $this->addColumn('is_edit', array('type' => 'options', 'options' => $isEdited, 'header' => Mage::helper('sales')->__('Is Edited'), 'index' => 'is_edit', 'filter_index' => 'main_table.is_edit', 'align' => 'center')); break; case 'comments': $this->addColumn('comment', array('type' => 'text', 'header' => Mage::helper('sales')->__('Comment(s)'), 'index' => 'comment', 'align' => 'center', 'renderer' => new Magedev_Ordermanager_Block_Adminhtml_Ordermanager_Grid_Renderer_Comments())); break; case 'edit_reason': $this->addColumn('edit_comments', array('type' => 'text', 'header' => Mage::helper('sales')->__('Order Note'), 'index' => 'edit_comments', 'filter_index' => 'main_table.edit_comments', 'align' => 'center')); break; case 'action': if (Mage::getSingleton('admin/session')->isAllowed('sales/order/actions/view')) { $this->addColumn('action', array('header' => Mage::helper('sales')->__('Action'), 'width' => '50px', 'type' => 'action', 'getter' => 'getId', 'actions' => array(array('caption' => Mage::helper('sales')->__('Re-Order'), 'url' => array('base' => '*/sales_order/view'), 'field' => 'order_id')), 'filter' => false, 'sortable' => false, 'index' => 'stores', 'is_system' => true)); } break; } } $this->sortColumnsByOrder(); return $this; } else { return parent::_prepareColumns(); } }