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