public function setCollection($collection)
{
$collection->getSelect();
/* ->joinleft(array('ncs'=>'newsletter_contest_subcriber'),'ncs.last_contest_id=main_table.contest_id',array('last_contest_id'))
->joinleft(array('ns'=>'newsletter_subscriber'),'ns.subscriber_id=ncs.subscriber_id',array('subscriber_status'))
->group('main_table.contest_participant_id');*/
parent::setCollection($collection);
}
public function setCollection($collection)
{
$collection->getSelect()->join(array('sfo' => Mage::getSingleton('core/resource')->getTableName('sales_flat_order')), 'main_table.order_id = sfo.entity_id', array('main_table.order_id as entity_id', 'start_datetime', 'end_datetime', 'send_datetime', 'return_datetime'));
/**
* Join send return table and remove rows that are blank dates for return
* and end_date (due date) is after today
*/
$collection->getSelect()->join(array('s2' => Mage::getSingleton('core/resource')->getTableName('payperrentals/sendreturn')), 'main_table.order_id = s2.order_id', array('return_date', 'res_enddate'))->group('s2.order_id');
$collection->addAttributeToFilter('s2.return_date', array(array("eq" => '0000-00-00 00:00:00'), array("eq" => '1970-01-01 00:00:00')));
$collection->addAttributeToFilter('s2.res_enddate', array("lt" => date('Y-m-d H:i:s')));
parent::setCollection($collection);
return parent::_prepareCollection();
}
public function setCollection($collection)
{
$listing = Mage::helper('M2ePro/Data_Global')->getValue('temp_data');
$storeId = 0;
if ($listing) {
$storeId = $listing['store_id'];
}
$collection->setStoreId($storeId);
/** @var $ruleModel Ess_M2ePro_Model_Magento_Product_Rule */
$ruleModel = Mage::helper('M2ePro/Data_Global')->getValue('rule_model');
$ruleModel->setAttributesFilterToCollection($collection);
parent::setCollection($collection);
}
protected function _prepareCollection()
{
$helper = Mage::helper('mailinglist');
//$data = $helper->getAllSubscribersInfo();
$data = $helper->getAllSubscribers();
$total = $helper->getCollectionTotal();
$current_offset = $helper->getCurrentOffset();
$collection = new Varien_Data_Collection();
foreach ($data as $item) {
$varienObject = new Varien_Object();
$varienObject->setSubscriberId($item['id']);
$varienObject->setEmail($item['email']);
$varienObject->setFirstName($item['first_name']);
$varienObject->setLastName($item['last_name']);
$collection->addItem($varienObject);
}
parent::setCollection($collection);
return parent::_prepareCollection();
}
public function setCollection($collection)
{
$this->_prepareCache(clone $collection);
parent::setCollection($collection);
}
/**
* Set collection object
*
* @param Varien_Data_Collection $collection
* @return mixed
*/
public function setCollection($collection)
{
if (!is_null($this->_blcg_typeModel)) {
$this->_blcg_typeModel->beforeGridSetCollection($this, $collection);
}
$return = parent::setCollection($collection);
if (!is_null($this->_blcg_typeModel)) {
$this->_blcg_typeModel->afterGridSetCollection($this, $collection);
}
return $return;
}
public function setCollection($collection)
{
$collection->addFieldToFilter('return_date', array("neq" => '0000-00-00 00:00:00'));
$collection->getSelect()->joinLeft(array('s' => Mage::getSingleton('core/resource')->getTableName('sales_flat_order')), 'main_table.order_id = s.entity_id', array('start_datetime', 'end_datetime', 'send_datetime', 'return_datetime', 'increment_id', 'created_at'));
parent::setCollection($collection);
}
