EncryptionUpdate.php

Go to the documentation of this file.

<?php
declare(strict_types=1);

namespace Magento\Sales\Model\ResourceModel\Order\Payment;

class EncryptionUpdate
{
    const LEGACY_PATTERN = '^[[:digit:]]+:[^%s]:.*$';

    private $paymentResource;

    private $encryptor;

    public function __construct(
        \Magento\Sales\Model\ResourceModel\Order\Payment $paymentResource,
        \Magento\Framework\Encryption\Encryptor $encryptor
    ) {
        $this->paymentResource = $paymentResource;
        $this->encryptor = $encryptor;
    }

    public function reEncryptCreditCardNumbers()
    {
        $connection = $this->paymentResource->getConnection();
        $table = $this->paymentResource->getMainTable();
        $select = $connection->select()->from($table, ['entity_id', 'cc_number_enc'])
            ->where(
                'cc_number_enc REGEXP ?',
                sprintf(self::LEGACY_PATTERN, \Magento\Framework\Encryption\Encryptor::CIPHER_LATEST)
            )->limit(1000);

        while ($attributeValues = $connection->fetchPairs($select)) {
                // save new values
            foreach ($attributeValues as $valueId => $value) {
                $connection->update(
                    $table,
                    ['cc_number_enc' => $this->encryptor->encrypt($this->encryptor->decrypt($value))],
                    ['entity_id = ?' => (int)$valueId, 'cc_number_enc = ?' => (string)$value]
                );
            }
        }
    }
}