* @copyright 2018 Akeneo SAS (https://www.akeneo.com) * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0) */ class SqlFindAttributeGroupOrdersEqualOrSuperiorTo implements FindAttributeGroupOrdersEqualOrSuperiorTo { /** @var Connection */ private $connection; public function __construct(Connection $connection) { $this->connection = $connection; } public function execute(AttributeGroup $attributeGroup): array { $sql = <<= :attribute_group_order) AND ag.code != :attribute_group_code ORDER BY ag.sort_order ASC SQL; $query = $this->connection->executeQuery( $sql, [ 'attribute_group_code' => $attributeGroup->getCode(), 'attribute_group_order' => $attributeGroup->getSortOrder(), ] ); return $query->fetchFirstColumn(); } }