/**
* add column to group by (in sql query)
*
* @param string $column
* @return Magestore_Affiliateplusstatistic_Model_Reports
*/
public function addGroupColumn($column = null)
{
if ($column) {
$this->_collection->getSelect()->group($column);
}
return $this;
}
/**
* Apply price grant on price index select
*
* @param Varien_Object $data
* @param int $customerGroupId
* @return Enterprise_CatalogPermissions_Model_Mysql4_Permission_Index
*/
public function applyPriceGrantToPriceIndex($data, $customerGroupId)
{
$select = $data->getSelect();
$parts = $select->getPart(Zend_Db_Select::FROM);
if (!isset($parts['permission_index_product'])) {
$select->joinLeft(array('permission_index_product' => $this->getTable('permission_index_product')), 'permission_index_product.category_id IS NULL AND
permission_index_product.product_id = ' . $data->getTable() . '.entity_id AND
permission_index_product.store_id = ' . (int) $data->getStoreId() . ' AND
permission_index_product.customer_group_id = ' . (int) $customerGroupId, array());
}
if (!Mage::helper('enterprise_catalogpermissions')->isAllowedProductPrice()) {
$select->where('permission_index_product.grant_catalog_product_price = ' . Enterprise_CatalogPermissions_Model_Permission::PERMISSION_ALLOW);
} else {
$select->where('permission_index_product.grant_catalog_product_price != ' . Enterprise_CatalogPermissions_Model_Permission::PERMISSION_DENY . '
OR permission_index_product.grant_catalog_product_price IS NULL');
}
return $this;
}
