protected function _prepareColumns() { $this->addColumn('name', array('header' => $this->__('Name'), 'index' => 'name')); $this->addColumn('email', array('header' => $this->__('Email'), 'index' => 'email')); $this->addColumn('description', array('header' => $this->__('Description'), 'width' => '150px', 'index' => 'description', 'renderer' => 'Forkel_Grids_Block_Adminhtml_Dashboard_Custom_Renderer_Truncate')); return parent::_prepareColumns(); }
protected function _prepareColumns() { $this->addColumn('name', array('header' => AO::helper('reports')->__('Product Name'), 'sortable' => false, 'index' => 'name')); $this->addColumn('price', array('header' => AO::helper('reports')->__('Price'), 'width' => '120px', 'type' => 'currency', 'currency_code' => (string) AO::app()->getStore((int) $this->getParam('store'))->getBaseCurrencyCode(), 'sortable' => false, 'index' => 'price')); $this->addColumn('views', array('header' => AO::helper('reports')->__('Number of Views'), 'width' => '120px', 'align' => 'right', 'sortable' => false, 'index' => 'views')); $this->setFilterVisibility(false); $this->setPagerVisibility(false); return parent::_prepareColumns(); }
protected function _prepareColumns() { $this->addColumn('search_query', array('header' => $this->__('Search Term'), 'sortable' => false, 'index' => 'query_text')); $this->addColumn('num_results', array('header' => $this->__('Results'), 'sortable' => false, 'index' => 'num_results', 'type' => 'number')); $this->addColumn('popularity', array('header' => $this->__('Number of Uses'), 'sortable' => false, 'index' => 'popularity', 'type' => 'number')); $this->setFilterVisibility(false); $this->setPagerVisibility(false); return parent::_prepareColumns(); }
protected function _prepareColumns() { $this->addColumn('sku', array('header' => $this->__('Product SKU'), 'sortable' => false, 'index' => 'sku')); $this->addColumn('name', array('header' => $this->__('Product Name'), 'sortable' => false, 'index' => 'name')); $this->addColumn('creator_id', array('header' => $this->__('Supplier Name'), 'sortable' => false, 'index' => 'creator_id', 'renderer' => 'Cminds_Supplierfrontendproductuploader_Block_Adminhtml_Dashboard_Supplier_Products_Renderer_Name')); $this->setFilterVisibility(false); $this->setPagerVisibility(false); return parent::_prepareColumns(); }
protected function _prepareColumns() { $this->addColumn('search_query', array('header' => $this->__('Search Term'), 'sortable' => false, 'index' => 'name', 'renderer' => 'Mage_Adminhtml_Block_Dashboard_Searches_Renderer_Searchquery')); $this->addColumn('num_results', array('header' => $this->__('Results'), 'sortable' => false, 'index' => 'num_results', 'type' => 'number')); $this->addColumn('popularity', array('header' => $this->__('Number of Uses'), 'sortable' => false, 'index' => 'popularity', 'type' => 'number')); $this->setFilterVisibility(false); $this->setPagerVisibility(false); return parent::_prepareColumns(); }
protected function _prepareColumns() { $this->addColumn('firstname', array('header' => $this->__('Firstname'), 'sortable' => false, 'index' => 'firstname')); $this->addColumn('lastname', array('header' => $this->__('Lastname'), 'sortable' => false, 'index' => 'lastname')); $this->addColumn('logdate', array('header' => $this->__('Date'), 'type' => 'datetime', 'sortable' => false, 'index' => 'logdate')); $this->setFilterVisibility(false); $this->setPagerVisibility(false); return parent::_prepareColumns(); }
protected function _prepareCollection() { $collection = Mage::getResourceModel('affiliateplus/account_collection'); if ($storeId = $this->getRequest()->getParam('store')) { $collection->setStoreId($storeId); } $this->setCollection($collection); return parent::_prepareCollection(); }
protected function _prepareColumns() { $this->addColumn('name', array('header' => Mage::helper('sales')->__('Product Name'), 'sortable' => false, 'index' => 'product_name')); $this->addColumn('price', array('header' => Mage::helper('sales')->__('Price'), 'width' => '120px', 'type' => 'currency', 'currency_code' => (string) Mage::app()->getStore((int) $this->getParam('store'))->getBaseCurrencyCode(), 'sortable' => false, 'index' => 'product_price')); $this->addColumn('ordered_qty', array('header' => Mage::helper('sales')->__('Quantity Ordered'), 'width' => '120px', 'align' => 'right', 'sortable' => false, 'index' => 'qty_ordered', 'type' => 'number')); $this->setFilterVisibility(false); $this->setPagerVisibility(false); return parent::_prepareColumns(); }
protected function _prepareCollection() { $collection = Mage::getResourceModel('affiliateplus/transaction_collection'); $collection->setModel('adminhtml/report_item'); $itemTable = $collection->getTable('sales/order_item'); $collection->getSelect()->join(array('i' => $itemTable), 'main_table.order_id = i.order_id AND FIND_IN_SET(i.product_id, main_table.order_item_ids)', array('name', 'product_id', 'product_type', 'sku', 'base_price', 'num_order_placed' => 'SUM(i.qty_ordered)'))->where('type = 3')->group('product_id')->order('num_order_placed DESC')->order('base_price DESC'); $this->setCollection($collection); return parent::_prepareCollection(); }
protected function _prepareColumns() { $this->addColumn('title', array('header' => $this->__('Title'), 'sortable' => false, 'index' => 'title')); $this->addColumn('identifier', array('header' => $this->__('Identifier'), 'sortable' => false, 'index' => 'identifier')); $this->addColumn('update_time', array('header' => $this->__('Last Modified'), 'sortable' => false, 'index' => 'update_time')); $this->setFilterVisibility(false); $this->setPagerVisibility(false); return parent::_prepareColumns(); }
protected function _prepareColumns() { $this->addColumn('month', array('header' => Mage::helper('compta_invoice')->__('Mois'), 'align' => 'left', 'index' => 'month')); $this->addColumn('amount', array('header' => Mage::helper('compta_invoice')->__('Montant BRUT'), 'align' => 'left', 'index' => 'amount', 'renderer' => 'Compta_Invoice_Block_Adminhtml_Renderer_Amount')); $this->addColumn('amount_net', array('header' => Mage::helper('compta_invoice')->__('Montant NET'), 'align' => 'left', 'index' => 'amount_net', 'renderer' => 'Compta_Invoice_Block_Adminhtml_Renderer_Amount')); $this->setFilterVisibility(false); $this->setPagerVisibility(false); return parent::_prepareColumns(); }
protected function _prepareColumns() { $this->addColumn('number', array('header' => Mage::helper('compta_invoice')->__('Numéro'), 'align' => 'left', 'index' => 'number')); $this->addColumn('nom', array('header' => Mage::helper('compta_invoice')->__('Client'), 'align' => 'left', 'index' => 'nom')); $this->addColumn('amount', array('header' => Mage::helper('compta_invoice')->__('Montant'), 'align' => 'left', 'index' => 'amount', 'renderer' => 'Compta_Invoice_Block_Adminhtml_Renderer_Amount')); $this->addColumn('payment_date', array('header' => Mage::helper('compta_invoice')->__('Date de paiement'), 'index' => 'payment_date', 'type' => 'date')); $this->setFilterVisibility(false); $this->setPagerVisibility(false); return parent::_prepareColumns(); }
protected function _prepareCollection() { $collection = Mage::getResourceModel('affiliateplus/action_collection'); $collection->getSelect()->reset(Zend_Db_Select::COLUMNS)->columns(array('referer' => 'domain', 'clicks' => 'SUM(totals)', 'uniques' => 'SUM(is_unique)'))->group('referer')->order('clicks DESC'); if ($storeId = $this->getRequest()->getParam('store')) { $collection->addFieldToFilter('store_id', $storeId); } $this->setCollection($collection); return parent::_prepareCollection(); }
protected function _prepareColumns() { $this->addColumn('customer', array('header' => $this->__('Customer'), 'sortable' => false, 'index' => 'customer', 'default' => $this->__('Guest'))); $this->addColumn('items', array('header' => $this->__('Items'), 'align' => 'right', 'type' => 'number', 'sortable' => false, 'index' => 'items_count')); $baseCurrencyCode = Mage::app()->getStore((int) $this->getParam('store'))->getBaseCurrencyCode(); $this->addColumn('total', array('header' => $this->__('Grand Total'), 'align' => 'right', 'sortable' => false, 'type' => 'currency', 'currency_code' => $baseCurrencyCode, 'index' => 'revenue')); $this->setFilterVisibility(false); $this->setPagerVisibility(false); return parent::_prepareColumns(); }
protected function _prepareColumns() { $this->addColumn('name', array('header' => $this->__('Customer Name'), 'sortable' => false, 'index' => 'name')); $this->addColumn('orders_count', array('header' => $this->__('Number of Orders'), 'sortable' => false, 'index' => 'orders_count', 'type' => 'number')); $baseCurrencyCode = (string) Mage::app()->getStore((int) $this->getParam('store'))->getBaseCurrencyCode(); $this->addColumn('orders_avg_amount', array('header' => $this->__('Average Order Amount'), 'align' => 'right', 'sortable' => false, 'type' => 'currency', 'currency_code' => $baseCurrencyCode, 'index' => 'orders_avg_amount', 'renderer' => 'adminhtml/report_grid_column_renderer_currency')); $this->addColumn('orders_sum_amount', array('header' => $this->__('Total Order Amount'), 'align' => 'right', 'sortable' => false, 'type' => 'currency', 'currency_code' => $baseCurrencyCode, 'index' => 'orders_sum_amount', 'renderer' => 'adminhtml/report_grid_column_renderer_currency')); $this->setFilterVisibility(false); $this->setPagerVisibility(false); return parent::_prepareColumns(); }
protected function _prepareCollection() { $collection = Mage::getResourceModel('affiliateplus/account_collection'); $transactionTable = $collection->getTable('affiliateplus/transaction'); $collection->getSelect()->joinLeft(array('ts' => $transactionTable), 'main_table.account_id = ts.account_id AND ts.type = 3', array('amount' => 'SUM(ts.total_amount)', 'num_order_placed' => 'COUNT(ts.transaction_id)'))->where('ts.status = 1')->group('ts.account_id')->order('amount DESC'); if ($storeId = $this->getRequest()->getParam('store')) { $collection->setStoreId($storeId); $collection->getSelect()->where("ts.store_id = {$storeId}"); } $this->setCollection($collection); return parent::_prepareCollection(); }
/** * Prepares the columns and specifies * the templates to use. * * @return Faett_Piwik_Block_Adminhtml_Dashboard_Tab_Live_User The instance */ protected function _prepareColumns() { // add a column for the visitor data $this->addColumn('visitor', array('header' => Mage::helper('piwik')->__('Visitor'), 'sortable' => false, 'renderer' => 'piwik/adminhtml_report_grid_column_renderer_generic', 'tmpl' => 'piwik/report/grid/column/renderer/visitor.phtml', 'width' => 200)); // add a column for the referer data $this->addColumn('referer', array('header' => Mage::helper('piwik')->__('Referer'), 'sortable' => false, 'renderer' => 'piwik/adminhtml_report_grid_column_renderer_generic', 'tmpl' => 'piwik/report/grid/column/renderer/referer.phtml')); // add a column for the pages visited $this->addColumn('pages', array('header' => Mage::helper('piwik')->__('Pages'), 'sortable' => false, 'renderer' => 'piwik/adminhtml_report_grid_column_renderer_generic', 'tmpl' => 'piwik/report/grid/column/renderer/pages.phtml')); // turn off filter and pager $this->setFilterVisibility(false); $this->setPagerVisibility(false); // call the method of the parent class return parent::_prepareColumns(); }