ionghitun / laravel-lumen-mysql-encryption

src/Models/BaseModel.php

Spacing +5 added lines, -5 removed lines

@@ -218,7 +218,7 @@ 
      */
     public function scopeWhereEncrypted($query, $column, $value)
     {
-        return $query->whereRaw('AES_DECRYPT('.$column.', "'.getenv('ENCRYPTION_KEY').'") LIKE ? COLLATE utf8mb4_general_ci', [$value]);
+        return $query->whereRaw('AES_DECRYPT(' . $column . ', "' . getenv('ENCRYPTION_KEY') . '") LIKE ? COLLATE utf8mb4_general_ci', [$value]);
     }
 
     /**
@@ -232,7 +232,7 @@ 
      */
     public function scopeWhereNotEncrypted($query, $column, $value)
     {
-        return $query->whereRaw('AES_DECRYPT('.$column.', "'.getenv('ENCRYPTION_KEY').'") NOT LIKE ? COLLATE utf8mb4_general_ci', [$value]);
+        return $query->whereRaw('AES_DECRYPT(' . $column . ', "' . getenv('ENCRYPTION_KEY') . '") NOT LIKE ? COLLATE utf8mb4_general_ci', [$value]);
     }
 
     /**
@@ -246,7 +246,7 @@ 
      */
     public function scopeOrWhereEncrypted($query, $column, $value)
     {
-        return $query->orWhereRaw('AES_DECRYPT('.$column.', "'.getenv('ENCRYPTION_KEY').'") LIKE ? COLLATE utf8mb4_general_ci', [$value]);
+        return $query->orWhereRaw('AES_DECRYPT(' . $column . ', "' . getenv('ENCRYPTION_KEY') . '") LIKE ? COLLATE utf8mb4_general_ci', [$value]);
     }
 
     /**
@@ -260,7 +260,7 @@ 
      */
     public function scopeOrWhereNotEncrypted($query, $column, $value)
     {
-        return $query->orWhereRaw('AES_DECRYPT('.$column.', "'.getenv('ENCRYPTION_KEY').'") NOT LIKE ? COLLATE utf8mb4_general_ci', [$value]);
+        return $query->orWhereRaw('AES_DECRYPT(' . $column . ', "' . getenv('ENCRYPTION_KEY') . '") NOT LIKE ? COLLATE utf8mb4_general_ci', [$value]);
     }
 
     /**
@@ -274,6 +274,6 @@ 
      */
     public function scopeOrderByEncrypted($query, $column, $direction)
     {
-        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

@@ -28,7 +28,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');
             }
@@ -36,7 +36,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 ? 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 ? COLLATE utf8mb4_general_ci" . ($ignore ? " AND id != " . $ignore : ''),
                 [$value]);
 
             return $items[0]->aggregate === 0;
@@ -45,14 +45,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 ? COLLATE utf8mb4_general_ci",
+            $items = DB::select("SELECT count(*) as aggregate FROM `" . $parameters[0] . "` WHERE AES_DECRYPT(`" . $field . "`, '" . getenv("ENCRYPTION_KEY") . "') LIKE ? COLLATE utf8mb4_general_ci",
                 [$value]);
 
             return $items[0]->aggregate > 0;