ionghitun / laravel-lumen-mysql-encryption

src/Models/BaseModel.php

Spacing +5 added lines, -5 removed lines

@@ -223,7 +223,7 @@ 
     public function scopeWhereEncrypted($query, $column, $value)
     {
         /** @var Builder $query */
-        return $query->whereRaw('AES_DECRYPT('.$column.', "'.getenv("ENCRYPTION_KEY").'") LIKE "'.$value.'" COLLATE utf8mb4_general_ci');
+        return $query->whereRaw('AES_DECRYPT(' . $column . ', "' . getenv("ENCRYPTION_KEY") . '") LIKE "' . $value . '" COLLATE utf8mb4_general_ci');
     }
 
     /**
@@ -238,7 +238,7 @@ 
     public function scopeWhereNotEncrypted($query, $column, $value)
     {
         /** @var Builder $query */
-        return $query->whereRaw('AES_DECRYPT('.$column.', "'.getenv("ENCRYPTION_KEY").'") NOT LIKE "'.$value.'" COLLATE utf8mb4_general_ci');
+        return $query->whereRaw('AES_DECRYPT(' . $column . ', "' . getenv("ENCRYPTION_KEY") . '") NOT LIKE "' . $value . '" COLLATE utf8mb4_general_ci');
     }
 
     /**
@@ -253,7 +253,7 @@ 
     public function scopeOrWhereEncrypted($query, $column, $value)
     {
         /** @var Builder $query */
-        return $query->orWhereRaw('AES_DECRYPT('.$column.', "'.getenv("ENCRYPTION_KEY").'") LIKE "'.$value.'" COLLATE utf8mb4_general_ci');
+        return $query->orWhereRaw('AES_DECRYPT(' . $column . ', "' . getenv("ENCRYPTION_KEY") . '") LIKE "' . $value . '" COLLATE utf8mb4_general_ci');
     }
 
     /**
@@ -268,7 +268,7 @@ 
     public function scopeOrWhereNotEncrypted($query, $column, $value)
     {
         /** @var Builder $query */
-        return $query->orWhereRaw('AES_DECRYPT('.$column.', "'.getenv("ENCRYPTION_KEY").'") NOT LIKE "'.$value.'" COLLATE utf8mb4_general_ci');
+        return $query->orWhereRaw('AES_DECRYPT(' . $column . ', "' . getenv("ENCRYPTION_KEY") . '") NOT LIKE "' . $value . '" COLLATE utf8mb4_general_ci');
     }
 
     /**
@@ -283,6 +283,6 @@ 
     public function scopeOrderByEncrypted($query, $column, $direction)
     {
         /** @var Builder $query */
-        return $query->orderByRaw('AES_DECRYPT('.$column.', "'.getenv("ENCRYPTION_KEY").'") '.$direction);
+        return $query->orderByRaw('AES_DECRYPT(' . $column . ', "' . getenv("ENCRYPTION_KEY") . '") ' . $direction);
     }
 }

src/MysqlEncryptionServiceProvider.php

Spacing +4 added lines, -4 removed lines

@@ -30,7 +30,7 @@ 
         /**
          * Validate unique binary encrypted
          */
-        Validator::extend('unique_encrypted', function ($attribute, $value, array $parameters) {
+        Validator::extend('unique_encrypted', function($attribute, $value, array $parameters) {
             if (!isset($parameters[0])) {
                 throw new Exception('unique_encrypted requires at least one parameter');
             }
@@ -38,7 +38,7 @@ 
             $field = isset($parameters[1]) ? $parameters[1] : $attribute;
             $ignore = isset($parameters[2]) ? $parameters[2] : null;
 
-            $items = DB::select("SELECT count(*) as aggregate FROM `".$parameters[0]."` WHERE AES_DECRYPT(`".$field."`, '".getenv("ENCRYPTION_KEY")."') LIKE '".$value."' COLLATE utf8mb4_general_ci".($ignore ? " AND id != ".$ignore : ''));
+            $items = DB::select("SELECT count(*) as aggregate FROM `" . $parameters[0] . "` WHERE AES_DECRYPT(`" . $field . "`, '" . getenv("ENCRYPTION_KEY") . "') LIKE '" . $value . "' COLLATE utf8mb4_general_ci" . ($ignore ? " AND id != " . $ignore : ''));
 
             return $items[0]->aggregate === 0;
         });
@@ -46,14 +46,14 @@ 
         /**
          * Validate exists binary encrypted
          */
-        Validator::extend('exists_encrypted', function ($attribute, $value, array $parameters) {
+        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."`, '".getenv("ENCRYPTION_KEY")."') LIKE '".$value."' COLLATE utf8mb4_general_ci");
+            $items = DB::select("SELECT count(*) as aggregate FROM `" . $parameters[0] . "` WHERE AES_DECRYPT(`" . $field . "`, '" . getenv("ENCRYPTION_KEY") . "') LIKE '" . $value . "' COLLATE utf8mb4_general_ci");
 
             return $items[0]->aggregate > 0;
         });