Magento – Magento2 How to Get Newsletter Subscribed Collection into phtml file

collection;datamagento2newsletterPHP

I used Magento 2.2.4 Version.

Magento2 How to Get Newsletter Subscribed Collection into phtml file

Best Answer

Not recommended way:

$objectManager =  \Magento\Framework\App\ObjectManager::getInstance();
$subscriberCollection = $objectManager->create('Magento\Newsletter\Model\ResourceModel\Subscriber\Collection');

foreach($subscriberCollection as $subscriber):
   print_r($subscriber->getData());
endforeach;

Recommended way:

protected $subscriberCollection;

public function __construct(
    \Magento\Newsletter\Model\ResourceModel\Subscriber\CollectionFactory $subscriberCollectiona
) {
    $this->subscriberCollection = $subscriberCollection;
}

public function getSubscriberCollection() {
    $subscriberCollection =$this->subscriberCollection->create();
    return $subscriberCollection;
}

In phtml:

$subscriberCollection = $block->getSubscriberCollection();
foreach($subscriberCollection as $subscriber):
    print_r($subscriber->getData());
endforeach;

Related Solutions

Magento 1 – Get Customer Collection Subscribed to Newsletters

You have to join EAV collection with regular table. It is achievable with joinTable method of Mage_Eav_Model_Entity_Collection_Abstract class. The forth parameter defines the WHERE condition because apparently you can't use addAttributeToFilter method here.

$collection = Mage::getModel('customer/customer')->getCollection();
$collection->addNameToSelect()
    ->joinTable('newsletter_subscriber', 'customer_id=entity_id', array('subscriber_status'), '{{table}}.subscriber_status=1');

Please let me know if something is unclear.

Newsletter Subscribed but No Confirmation Email – Magento 1.7.0.2

As Sander Mangel pointed out the solution is in app/code/core/Mage/Newsletter/Model/Subscriber.php. Copy this file to app/code/local/Mage/Newsletter/Model/Subscriber.php

Find function confirm($code) (Line 470 in CE-1.7.0.2) and add $this->sendConfirmationSuccessEmail();

Now the function should look like this:

public function confirm($code)
{
    if($this->getCode()==$code) {
        $this->setStatus(self::STATUS_SUBSCRIBED)
            ->setIsStatusChanged(true)
            ->save();
        // This is new:
        $this->sendConfirmationSuccessEmail();
        return true;
    }

    return false;
}

Best Answer

Related Solutions

Magento 1 – Get Customer Collection Subscribed to Newsletters

Newsletter Subscribed but No Confirmation Email – Magento 1.7.0.2

Related Topic