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();
}
