IonGhitun\MysqlEncryption\MysqlEncryptionServiceProvider

Complexity

Total Complexity

7

Size/Duplication

Total Lines	51
Duplicated Lines	0 %

Importance

Changes	2
Bugs	0	Features	0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	boot()	0	3	1
A	addValidators()	0	30	5
A	register()	0	2	1

<?php

namespace IonGhitun\MysqlEncryption;

use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Validator;
use Illuminate\Support\ServiceProvider;

/**
 * Class MysqlEncryptionServiceProvider
 *
 * @package IonGhitun\MysqlEncryption\Providers
 */
class MysqlEncryptionServiceProvider extends ServiceProvider
{
    /**
     * Bootstrap the application services.
     */
    public function boot()
    {
        $this->addValidators();
    }

    /**
     * Add validators for unique and exists.
     */
    private function addValidators()
    {
        /**
         * Validate unique binary encrypted
         */
        Validator::extend('unique_encrypted', function ($attribute, $value, array $parameters) {
            if (!isset($parameters[0])) {
                throw new \Exception('unique_encrypted requires at least one parameter');
            }

            $field = isset($parameters[1]) ? $parameters[1] : $attribute;

            $items = DB::select("SELECT count(*) as aggregate FROM `" . $parameters[0] . "` WHERE AES_DECRYPT(`" . $field . "`, '" . env("ENCRYPTION_KEY") . "') LIKE '" . $value . "' COLLATE utf8mb4_general_ci");

            return $items[0]->aggregate === 0;
        });

        /**
         * Validate exists binary encrypted
         */
        Validator::extend('exists_encrypted', function ($attribute, $value, array $parameters) {
            if (!isset($parameters[0])) {
                throw new \Exception('exists_encrypted requires at least one parameter');
            }

            $field = isset($parameters[1]) ? $parameters[1] : $attribute;

            $items = DB::select("SELECT count(*) as aggregate FROM `" . $parameters[0] . "` WHERE AES_DECRYPT(`" . $field . "`, '" . env("ENCRYPTION_KEY") . "') LIKE '" . $value . "' COLLATE utf8mb4_general_ci");

            return $items[0]->aggregate > 0;
        });
    }

    /**
     * Register the application services.
     */
    public function register()
    {
    }
}