attributeCases) === 0) { return $this->getDefaultMask(); } return $this->getMaskWithCases($this->formatAttributeCases()); } private function getDefaultMask(): string { return <<'), '-', IF(attribute.is_localizable, channel_locale.locale_code, '') ) ) AS mask SQL; } private function formatAttributeCases(): string { $formattedCases = []; foreach ($this->attributeCases as $attributeCase) { $formattedCases[] = $attributeCase->getCase(); } return implode(' ', $formattedCases); } private function getMaskWithCases(string $cases): string { return " JSON_ARRAYAGG( CONCAT( CASE " . $cases . " ELSE attribute.code END, '-', IF(attribute.is_scopable, channel_locale.channel_code, ''), '-', IF(attribute.is_localizable, channel_locale.locale_code, '') ) ) AS mask "; } }