public function prepareCollection(Mzax_Emarketing_Model_Object_Collection $collection)
{
parent::prepareCollection($collection);
$collection->addField('store_id');
$collection->addField('created_at');
$collection->addField('status');
$collection->addField('increment_id');
}
public function prepareCollection(Mzax_Emarketing_Model_Object_Collection $collection)
{
parent::prepareCollection($collection);
$collection->addField('sent_at');
$collection->addField('object_id');
$collection->addField('variation_id');
$collection->addField('campaign_id');
}
public function prepareCollection(Mzax_Emarketing_Model_Object_Collection $collection)
{
parent::prepareCollection($collection);
$collection->addField('store_id');
$collection->addField('created_at');
$collection->addField('updated_at');
$collection->addField('customer_id');
$collection->addField('email');
}
public function prepareCollection(Mzax_Emarketing_Model_Object_Collection $collection)
{
parent::prepareCollection($collection);
$collection->addField('order_item_id');
$collection->addField('product_type');
$collection->addField('product_id');
$collection->addField('sku');
$collection->addField('name');
$collection->addField('qty_invoiced');
}
public function prepareCollection(Mzax_Emarketing_Model_Object_Collection $collection)
{
parent::prepareCollection($collection);
$adapter = $this->getResourceHelper()->getAdapter();
$nameExpr[] = "LTRIM(RTRIM({firstname}))";
$nameExpr[] = "LTRIM(RTRIM({lastname}))";
$nameExpr = $adapter->getConcatSql($nameExpr, ' ');
$collection->addField('name', $nameExpr);
$collection->addField('email', 'email');
$collection->addField('city', 'city');
$collection->addField('postcode', 'postcode');
}
public function prepareCollection(Mzax_Emarketing_Model_Object_Collection $collection)
{
parent::prepareCollection($collection);
$firstname = $collection->getQuery()->joinAttribute('customer_id', 'customer/firstname');
$lastname = $collection->getQuery()->joinAttribute('customer_id', 'customer/lastname');
$adapter = $this->getResourceHelper()->getAdapter();
$nameExpr[] = "LTRIM(RTRIM({$firstname}))";
$nameExpr[] = "LTRIM(RTRIM({$lastname}))";
$nameExpr = $adapter->getConcatSql($nameExpr, ' ');
$collection->addField('name', $nameExpr);
$collection->addField('email', 'email');
$collection->addField('newsletter_status', 'subscriber_status');
}
/**
* Add name, city and postcode to collection as
* we use them to show in every grid
*
* @see Mzax_Emarketing_Model_Object_Customer_Address::prepareGridColumns()
*/
public function prepareCollection(Mzax_Emarketing_Model_Object_Collection $collection)
{
parent::prepareCollection($collection);
$firstname = $collection->getQuery()->joinAttribute('{id}', 'customer_address/firstname');
$lastname = $collection->getQuery()->joinAttribute('{id}', 'customer_address/lastname');
$postcode = $collection->getQuery()->joinAttribute('{id}', 'customer_address/city');
$city = $collection->getQuery()->joinAttribute('{id}', 'customer_address/postcode');
$adapter = $this->getResourceHelper()->getAdapter();
$nameExpr[] = "LTRIM(RTRIM({$firstname}))";
$nameExpr[] = "LTRIM(RTRIM({$lastname}))";
$nameExpr = $adapter->getConcatSql($nameExpr, ' ');
$collection->addField('name', $nameExpr);
$collection->addField('city', $city);
$collection->addField('postcode', $postcode);
}
public function prepareCollection(Mzax_Emarketing_Model_Object_Collection $collection)
{
parent::prepareCollection($collection);
$collection->addField('sku');
}
/**
* (non-PHPdoc)
* @see Mzax_Emarketing_Model_Object_Abstract::prepareRecipient()
*/
public function prepareRecipient(Mzax_Emarketing_Model_Recipient $recipient)
{
parent::prepareRecipient($recipient);
/* @var $customer Mage_Customer_Model_Customer */
$customer = $recipient->getObject();
$recipient->setCustomer($customer);
$recipient->setEmail($customer->getEmail());
$recipient->setName($customer->getName());
}
