CommerceLeague\ActiveCampaign\Model\ResourceModel\Magento\CustomerCollection

Complexity

Total Complexity

4

Size/Duplication

Total Lines	50
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	addContactOmittedFilter()	0	4	1
A	_initSelect()	0	17	1
A	addEmailFilter()	0	4	1
A	addCustomerOmittedFilter()	0	4	1

<?php
declare(strict_types=1);
/**
 */

namespace CommerceLeague\ActiveCampaign\Model\ResourceModel\Magento;

use CommerceLeague\ActiveCampaign\Setup\SchemaInterface;
use Magento\Customer\Model\ResourceModel\Customer\Collection as ExtendCustomerCollection;

/**
 * Class CustomerCollection
 * @codeCoverageIgnore
 */
class CustomerCollection extends ExtendCustomerCollection
{
    /**
     * @inheritDoc
     */
    protected function _initSelect()
    {
        parent::_initSelect();

        $this->getSelect()->joinLeft(
            ['ac_contact' => $this->_resource->getTableName(SchemaInterface::CONTACT_TABLE)],

The call to Magento\Framework\DB\Select::joinLeft() has too many arguments starting with array('ac_contact' => $this->_resource->getTableName(CommerceLeague\ActiveCampaign\Setup\SchemaInterface::CONTACT_TABLE)).

            'ac_contact.email = e.email',
            ['ac_contact.activecampaign_id']
        );

        $this->getSelect()->joinLeft(
            ['ac_customer' => $this->_resource->getTableName(SchemaInterface::CUSTOMER_TABLE)],
            'ac_customer.magento_customer_id = e.entity_id',
            ['ac_customer.activecampaign_id']
        );

        return $this;
    }

    /**
     * @param string $email
     * @return CustomerCollection
     */
    public function addEmailFilter(string $email): self
    {
        $this->getSelect()->where('e.email = ?', $email);
        return $this;
    }

    /**
     * @return CustomerCollection
     */
    public function addContactOmittedFilter(): self
    {
        $this->getSelect()->where('ac_contact.activecampaign_id IS NULL');
        return $this;
    }

    /**
     * @return CustomerCollection
     */
    public function addCustomerOmittedFilter(): self
    {
        $this->getSelect()->where('ac_customer.activecampaign_id IS NULL');
        return $this;
    }
}