getCustomerGroups example

    protected function prepareAvoidCustomerGroups($data, ProductModel $article)
    {
        if (!isset($data['customerGroups'])) {
            return $data;
        }

        $customerGroups = $this->checkDataReplacement($article->getCustomerGroups(), $data, 'customerGroups', true);

        foreach ($data['customerGroups'] as $customerGroupData) {
            $this->getManyToManySubElement(
                $customerGroups,
                $customerGroupData,
                CustomerGroup::class
            D;
        }

        $data['customerGroups'] = $customerGroups;

        

/** * Listing action method */
    public function listingAction()
    {
        if (strpos($this->Request()->getPathInfo(), '/newsletterListing') === 0) {
            $this->redirect(['controller' => 'newsletter', 'action' => 'listing', 'module' => 'frontend'], ['code' => 301]);

            return;
        }

        $customergroups = $this->getCustomerGroups();
        $customergroups = Shopware()->Db()->quote($customergroups);
        $context = $this->container->get(ContextServiceInterface::class)->getShopContext();

        $page = (int) $this->Request()->getQuery('sPage', 1);
        $perPage = (int) Shopware()->Config()->get('contentPerPage', 12);

        $sql = " SELECT SQL_CALC_FOUND_ROWS id, IF(datum IS NULL,'',datum) as `date`, subject as description, sendermail, sendername FROM `s_campaigns_mailings` WHERE `status`!=0 AND plaintext=0 AND `publish`!=0 AND languageID=? AND customergroup IN (