Laravel-Backpack / CRUD

src/app/Http/Controllers/Auth/VerifyEmailController.php

Spacing +4 added lines, -4 removed lines

@@ -20,21 +20,21 @@ 
      */
     public function __construct()
     {
-        if (! app('router')->getMiddleware()['signed'] ?? null) {
+        if (!app('router')->getMiddleware()['signed'] ?? null) {
             throw new Exception('Missing "signed" alias middleware in App/Http/Kernel.php. More info: https://backpackforlaravel.com/docs/6.x/base-how-to#enable-email-verification-in-backpack-routes');
         }
 
         $this->middleware('signed')->only('verifyEmail');
         $this->middleware('throttle:'.config('backpack.base.email_verification_throttle_access'))->only('resendVerificationEmail');
 
-        if (! backpack_users_have_email()) {
+        if (!backpack_users_have_email()) {
             abort(500, trans('backpack::base.no_email_column'));
         }
         // where to redirect after the email is verified
         $this->redirectTo = $this->redirectTo ?? backpack_url('dashboard');
     }
 
-    public function emailVerificationRequired(Request $request): \Illuminate\Contracts\View\View|\Illuminate\Http\RedirectResponse
+    public function emailVerificationRequired(Request $request): \Illuminate\Contracts\View\View | \Illuminate\Http\RedirectResponse
     {
         $this->getUserOrRedirect($request);
 
@@ -77,7 +77,7 @@ 
         return $request->user(backpack_guard_name()) ?? (new UserFromCookie())();
     }
 
-    private function getUserOrRedirect(Request $request): \Illuminate\Contracts\Auth\MustVerifyEmail|\Illuminate\Http\RedirectResponse
+    private function getUserOrRedirect(Request $request): \Illuminate\Contracts\Auth\MustVerifyEmail | \Illuminate\Http\RedirectResponse
     {
         if ($user = $this->getUser($request)) {
             return $user;

src/app/Models/Traits/HasFakeFields.php

Spacing +3 added lines, -3 removed lines

@@ -20,7 +20,7 @@ 
     public function addFakes($columns = ['extras'])
     {
         foreach ($columns as $key => $column) {
-            if (! isset($this->attributes[$column])) {
+            if (!isset($this->attributes[$column])) {
                 continue;
             }
 
@@ -67,7 +67,7 @@ 
      */
     public function shouldDecodeFake($column)
     {
-        return ! in_array($column, array_keys($this->getCasts()));
+        return !in_array($column, array_keys($this->getCasts()));
     }
 
     /**
@@ -78,6 +78,6 @@ 
      */
     public function shouldEncodeFake($column)
     {
-        return ! in_array($column, array_keys($this->getCasts()));
+        return !in_array($column, array_keys($this->getCasts()));
     }
 }

tests/config/database/migrations/2024_07_30_000001_create_translatable_table.php

Spacing +1 added lines, -1 removed lines

@@ -13,7 +13,7 @@
      */
     public function up()
     {
-        Schema::create('translatable', function (Blueprint $table) {
+        Schema::create('translatable', function(Blueprint $table) {
             $table->increments('id');
             $table->json('title');
             $table->json('description')->nullable();

src/app/Library/CrudPanel/Traits/Input.php

Spacing +6 added lines, -6 removed lines

@@ -98,7 +98,7 @@ 
         }
 
         //remove fields that are not in the submitted form input
-        $relationFields = array_filter($relationFields, function ($field) use ($input) {
+        $relationFields = array_filter($relationFields, function($field) use ($input) {
             return Arr::has($input, $field['name']) || isset($input[$field['name']]) || Arr::has($input, Str::afterLast($field['name'], '.'));
         });
 
@@ -127,7 +127,7 @@ 
                     // the key used to store the values is the main relation key
                     $key = Str::beforeLast($this->getOnlyRelationEntity($field), '.');
 
-                    if (! isset($field['parentFieldName']) && isset($field['entity'])) {
+                    if (!isset($field['parentFieldName']) && isset($field['entity'])) {
                         $mainField = $field;
                         $mainField['entity'] = Str::beforeLast($field['entity'], '.');
 
@@ -185,7 +185,7 @@ 
 
             // when using dot notation if relationMethod is not set we are sure we want to exclude those relations.
             if ($this->getOnlyRelationEntity($field) !== $field['entity']) {
-                if (! $relationMethod) {
+                if (!$relationMethod) {
                     $excludedFields[] = $nameToExclude;
                 }
 
@@ -199,8 +199,8 @@ 
             }
         }
 
-        return Arr::where($input, function ($item, $key) use ($excludedFields) {
-            return ! in_array($key, $excludedFields);
+        return Arr::where($input, function($item, $key) use ($excludedFields) {
+            return !in_array($key, $excludedFields);
         });
     }
 
@@ -227,7 +227,7 @@ 
                 $jsonCastables = ['array', 'object', 'json'];
                 $fieldCasting = $casted_attributes[$field['name']];
 
-                if (in_array($fieldCasting, $jsonCastables) && isset($input[$field['name']]) && ! empty($input[$field['name']]) && ! is_array($input[$field['name']]) && ! in_array($field['name'], $translatableAttributes)) {
+                if (in_array($fieldCasting, $jsonCastables) && isset($input[$field['name']]) && !empty($input[$field['name']]) && !is_array($input[$field['name']]) && !in_array($field['name'], $translatableAttributes)) {
                     try {
                         $input[$field['name']] = json_decode($input[$field['name']]);
                     } catch (\Exception $e) {

src/app/Library/Uploaders/Support/RegisterUploadEvents.php

Spacing +12 added lines, -12 removed lines

@@ -14,18 +14,18 @@ 
     private string $crudObjectType;
 
     public function __construct(
-        private readonly CrudField|CrudColumn $crudObject,
+        private readonly CrudField | CrudColumn $crudObject,
         private readonly array $uploaderConfiguration,
         private readonly string $macro
         ) {
         $this->crudObjectType = is_a($crudObject, CrudField::class) ? 'field' : (is_a($crudObject, CrudColumn::class) ? 'column' : null);
 
-        if (! $this->crudObjectType) {
+        if (!$this->crudObjectType) {
             abort(500, 'Upload handlers only work for CrudField and CrudColumn classes.', ['developer-error-exception']);
         }
     }
 
-    public static function handle(CrudField|CrudColumn $crudObject, array $uploaderConfiguration, string $macro, ?array $subfield = null, ?bool $registerModelEvents = true): void
+    public static function handle(CrudField | CrudColumn $crudObject, array $uploaderConfiguration, string $macro, ?array $subfield = null, ?bool $registerModelEvents = true): void
     {
         $instance = new self($crudObject, $uploaderConfiguration, $macro);
 
@@ -37,7 +37,7 @@ 
      *******************************/
     private function registerEvents(?array $subfield = [], ?bool $registerModelEvents = true): void
     {
-        if (! empty($subfield)) {
+        if (!empty($subfield)) {
             $this->registerSubfieldEvent($subfield, $registerModelEvents);
 
             return;
@@ -81,7 +81,7 @@ 
         }
 
         $subfields = collect($this->crudObject->getAttributes()['subfields']);
-        $subfields = $subfields->map(function ($item) use ($subfield, $uploader) {
+        $subfields = $subfields->map(function($item) use ($subfield, $uploader) {
             if ($item['name'] === $subfield['name']) {
                 $item['upload'] = true;
                 $item['disk'] = $uploader->getDisk();
@@ -111,7 +111,7 @@ 
         }
 
         if ($this->crudObjectType === 'field') {
-            $model::saving(function ($entry) use ($uploader) {
+            $model::saving(function($entry) use ($uploader) {
                 $entry = $uploader->storeUploadedFiles($entry);
             });
         }
@@ -124,7 +124,7 @@ 
             // is not called in pivot models when loading the relations.
             $retrieveModel = $this->getModelForRetrieveEvent($model, $uploader);
 
-            $retrieveModel::retrieved(function ($entry) use ($uploader) {
+            $retrieveModel::retrieved(function($entry) use ($uploader) {
                 if ($entry->translationEnabled()) {
                     $locale = request('_locale', app()->getLocale());
                     if (in_array($locale, array_keys($entry->getAvailableLocales()))) {
@@ -135,7 +135,7 @@ 
             });
         }
 
-        $model::deleting(function ($entry) use ($uploader) {
+        $model::deleting(function($entry) use ($uploader) {
             $uploader->deleteUploadedFiles($entry);
         });
 
@@ -157,13 +157,13 @@ 
         $customUploader = isset($uploaderConfiguration['uploader']) && class_exists($uploaderConfiguration['uploader']);
 
         if ($customUploader) {
-            return $uploaderConfiguration['uploader']::for($crudObject, $uploaderConfiguration);
+            return $uploaderConfiguration['uploader']::for ($crudObject, $uploaderConfiguration);
         }
 
         $uploader = app('UploadersRepository')->hasUploadFor($crudObject['type'], $this->macro);
 
         if ($uploader) {
-            return app('UploadersRepository')->getUploadFor($crudObject['type'], $this->macro)::for($crudObject, $uploaderConfiguration);
+            return app('UploadersRepository')->getUploadFor($crudObject['type'], $this->macro)::for ($crudObject, $uploaderConfiguration);
         }
 
         throw new Exception('Undefined upload type for '.$this->crudObjectType.' type: '.$crudObject['type']);
@@ -184,7 +184,7 @@ 
 
     private function getSubfieldModel(array $subfield, UploaderInterface $uploader)
     {
-        if (! $uploader->isRelationship()) {
+        if (!$uploader->isRelationship()) {
             return $subfield['baseModel'] ?? get_class(app('crud')->getModel());
         }
 
@@ -197,7 +197,7 @@ 
 
     private function getModelForRetrieveEvent(string $model, UploaderInterface $uploader)
     {
-        if (! $uploader->isRelationship()) {
+        if (!$uploader->isRelationship()) {
             return $model;
         }
 

src/app/Library/CrudPanel/Traits/ColumnsProtectedMethods.php

Spacing +8 added lines, -9 removed lines

@@ -50,7 +50,7 @@ 
             return ['name' => Str::replace(' ', '', $column)];
         }
 
-        if (is_array($column) && ! isset($column['name'])) {
+        if (is_array($column) && !isset($column['name'])) {
             $column['name'] = 'anonymous_column_'.Str::random(5);
         }
 
@@ -68,7 +68,7 @@ 
      */
     protected function makeSureColumnHasLabel($column)
     {
-        if (! isset($column['label'])) {
+        if (!isset($column['label'])) {
             $column['label'] = mb_ucfirst($this->makeLabel($column['name']));
         }
 
@@ -153,7 +153,7 @@ 
      */
     protected function makeSureColumnHasKey($column)
     {
-        if (! isset($column['key'])) {
+        if (!isset($column['key'])) {
             $column['key'] = str_replace('.', '__', $column['name']);
         }
 
@@ -170,7 +170,7 @@ 
      */
     protected function makeSureColumnHasWrapper($column)
     {
-        if (! isset($column['wrapper'])) {
+        if (!isset($column['wrapper'])) {
             $column['wrapper'] = [];
         }
 
@@ -255,7 +255,7 @@ 
     {
         // if this is a relation type field and no corresponding model was specified,
         // get it from the relation method defined in the main model
-        if (isset($column['entity']) && $column['entity'] !== false && ! isset($column['model'])) {
+        if (isset($column['entity']) && $column['entity'] !== false && !isset($column['model'])) {
             $column['model'] = $this->getRelationModel($column['entity']);
         }
 
@@ -294,8 +294,7 @@ 
         $targetColumnName = str_replace('.', '__', $targetColumnName);
 
         if (array_key_exists($targetColumnName, $columnsArray)) {
-            $targetColumnPosition = $before ? array_search($targetColumnName, array_keys($columnsArray)) :
-                array_search($targetColumnName, array_keys($columnsArray)) + 1;
+            $targetColumnPosition = $before ? array_search($targetColumnName, array_keys($columnsArray)) : array_search($targetColumnName, array_keys($columnsArray)) + 1;
 
             $element = array_pop($columnsArray);
 
@@ -324,7 +323,7 @@ 
     {
         static $cache = [];
 
-        if (! $this->driverIsSql()) {
+        if (!$this->driverIsSql()) {
             return true;
         }
 
@@ -340,7 +339,7 @@ 
     /**
      * Prepare the column attributes and add it to operation settings.
      */
-    private function prepareAttributesAndAddColumn(array|string $column): CrudColumn
+    private function prepareAttributesAndAddColumn(array | string $column): CrudColumn
     {
         $column = $this->makeSureColumnHasNeededAttributes($column);
         $this->addColumnToOperationSettings($column);

src/app/Library/CrudPanel/Traits/Search.php

Indentation +10 added lines, -10 removed lines

@@ -301,10 +301,10 @@ 
         // add the details_row button to the first column
         if ($this->getOperationSetting('detailsRow')) {
             $details_row_button = \View::make('crud::columns.inc.details_row_button')
-                                           ->with('crud', $this)
-                                           ->with('entry', $entry)
-                                           ->with('row_number', $rowNumber)
-                                           ->render();
+                                            ->with('crud', $this)
+                                            ->with('entry', $entry)
+                                            ->with('row_number', $rowNumber)
+                                            ->render();
             $row_items[0] = $details_row_button.$row_items[0];
         }
 
@@ -500,14 +500,14 @@ 
                 if ($isJsonColumn) {
                     $subQuery->$localeOperation(function ($localeQuery) use ($searchColumn, $locale, $parsedDate) {
                         $localeQuery->whereNotNull("{$searchColumn}->{$locale}")
-                                   ->whereDate("{$searchColumn}->{$locale}", $parsedDate);
+                                    ->whereDate("{$searchColumn}->{$locale}", $parsedDate);
                     });
                 } else {
                     // For non-JSON columns storing date as string in serialized data
                     $subQuery->$localeOperation(function ($localeQuery) use ($searchColumn, $locale, $parsedDate) {
                         $dateString = $parsedDate->format('Y-m-d');
                         $localeQuery->whereRaw("LOWER({$searchColumn}) LIKE LOWER(?)", ['%"' . $locale . '":"' . $dateString . '%"%'])
-                                   ->orWhereRaw("LOWER({$searchColumn}) LIKE LOWER(?)", ['%s:' . strlen($locale) . ':"' . $locale . '"%' . $dateString . '%']);
+                                    ->orWhereRaw("LOWER({$searchColumn}) LIKE LOWER(?)", ['%s:' . strlen($locale) . ':"' . $locale . '"%' . $dateString . '%']);
                     });
                 }
             }
@@ -540,7 +540,7 @@ 
                 $query->$localeOperation(function ($localeQuery) use ($searchColumn, $locale, $searchTerm, $searchOperator, $isJsonColumn) {
                     if ($isJsonColumn) {
                         $localeQuery->whereNotNull("{$searchColumn}->{$locale}")
-                                   ->where("{$searchColumn}->{$locale}", $searchOperator, $searchTerm);
+                                    ->where("{$searchColumn}->{$locale}", $searchOperator, $searchTerm);
                     } else {
                         // For non-JSON columns, we need to search within the serialized/JSON string
                         $localeQuery->whereRaw("LOWER({$searchColumn}) LIKE LOWER(?)", ['%"' . $locale . '":"' . $searchTerm . '"%']);
@@ -565,15 +565,15 @@ 
         if ($isJsonColumn) {
             // Use proper JSON functions for JSON columns with case-insensitive search
             $query->whereRaw("JSON_EXTRACT({$searchColumn}, '$.{$locale}') IS NOT NULL")
-                  ->whereRaw("LOWER(JSON_UNQUOTE(JSON_EXTRACT({$searchColumn}, '$.{$locale}'))) LIKE LOWER(?)", ['%' . $searchTerm . '%']);
+                    ->whereRaw("LOWER(JSON_UNQUOTE(JSON_EXTRACT({$searchColumn}, '$.{$locale}'))) LIKE LOWER(?)", ['%' . $searchTerm . '%']);
         } else {
             // For text columns storing JSON as string, search within the serialized data
             // This handles both PHP serialized arrays and JSON strings with case-insensitive search
             $query->where(function ($subQuery) use ($searchColumn, $locale, $searchTerm) {
                 // Search for JSON format: "locale":"value" (case-insensitive)
                 $subQuery->whereRaw("LOWER({$searchColumn}) LIKE LOWER(?)", ['%"' . $locale . '":"%' . $searchTerm . '%"%'])
-                         // Also search for PHP serialized format (case-insensitive)
-                         ->orWhereRaw("LOWER({$searchColumn}) LIKE LOWER(?)", ['%s:' . strlen($locale) . ':"' . $locale . '"%' . $searchTerm . '%']);
+                            // Also search for PHP serialized format (case-insensitive)
+                            ->orWhereRaw("LOWER({$searchColumn}) LIKE LOWER(?)", ['%s:' . strlen($locale) . ':"' . $locale . '"%' . $searchTerm . '%']);
             });
         }
     }

Spacing +22 added lines, -22 removed lines

@@ -22,9 +22,9 @@ 
      */
     public function applySearchTerm($searchTerm)
     {
-        return $this->query->where(function ($query) use ($searchTerm) {
+        return $this->query->where(function($query) use ($searchTerm) {
             foreach ($this->columns() as $column) {
-                if (! isset($column['type'])) {
+                if (!isset($column['type'])) {
                     abort(500, 'Missing column type when trying to apply search term.', ['developer-error-exception']);
                 }
 
@@ -104,7 +104,7 @@ 
 
                 case 'select':
                 case 'select_multiple':
-                    $query->orWhereHas($column['entity'], function ($q) use ($column, $searchTerm, $searchOperator) {
+                    $query->orWhereHas($column['entity'], function($q) use ($column, $searchTerm, $searchOperator) {
                         $q->where($this->getColumnWithTableNamePrefixed($q, $column['attribute']), $searchOperator, '%'.$searchTerm.'%');
                     });
                     break;
@@ -128,7 +128,7 @@ 
                 $column_direction = (strtolower((string) $order['dir']) == 'asc' ? 'ASC' : 'DESC');
                 $column = $this->findColumnById($column_number);
 
-                if ($column['tableColumn'] && ! isset($column['orderLogic'])) {
+                if ($column['tableColumn'] && !isset($column['orderLogic'])) {
                     if (method_exists($this->model, 'translationEnabled') &&
                         $this->model->translationEnabled() &&
                         $this->model->isTranslatableAttribute($column['name']) &&
@@ -156,12 +156,12 @@ 
         $key = $this->model->getKeyName();
         $groupBy = $this->query->toBase()->groups;
 
-        $hasOrderByPrimaryKey = collect($orderBy)->some(function ($item) use ($key, $table) {
+        $hasOrderByPrimaryKey = collect($orderBy)->some(function($item) use ($key, $table) {
             return (isset($item['column']) && $item['column'] === $key)
                 || (isset($item['sql']) && str_contains($item['sql'], "$table.$key"));
         });
 
-        if (! $hasOrderByPrimaryKey && empty($groupBy)) {
+        if (!$hasOrderByPrimaryKey && empty($groupBy)) {
             $this->orderByWithPrefix($key, 'DESC');
         }
     }
@@ -345,13 +345,13 @@ 
         if (isset($column['type'])) {
             // create a list of paths to column blade views
             // including the configured view_namespaces
-            $columnPaths = array_map(function ($item) use ($column) {
+            $columnPaths = array_map(function($item) use ($column) {
                 return $item.'.'.$column['type'];
             }, ViewNamespaces::getFor('columns'));
 
             // but always fall back to the stock 'text' column
             // if a view doesn't exist
-            if (! in_array('crud::columns.text', $columnPaths)) {
+            if (!in_array('crud::columns.text', $columnPaths)) {
                 $columnPaths[] = 'crud::columns.text';
             }
 
@@ -390,7 +390,7 @@ 
      */
     private function renderCellView($view, $column, $entry, $rowNumber = false)
     {
-        if (! view()->exists($view)) {
+        if (!view()->exists($view)) {
             $view = 'crud::columns.text'; // fallback to text column
         }
 
@@ -463,7 +463,7 @@ 
         $columnType = $this->model->getColumnType($searchColumn);
         $isJsonColumn = $this->isJsonColumnType($searchColumn);
         
-        $query->orWhere(function ($subQuery) use ($searchColumn, $searchTerm, $searchOperator, $searchLocales, $isJsonColumn) {
+        $query->orWhere(function($subQuery) use ($searchColumn, $searchTerm, $searchOperator, $searchLocales, $isJsonColumn) {
             $this->applyLocaleSearchConditions($subQuery, $searchColumn, $searchTerm, $searchOperator, $searchLocales, $isJsonColumn);
         });
     }
@@ -491,23 +491,23 @@ 
         $isJsonColumn = $this->isJsonColumnType($searchColumn);
         $parsedDate = Carbon::parse($searchTerm);
         
-        $query->orWhere(function ($subQuery) use ($searchColumn, $parsedDate, $searchLocales, $isJsonColumn) {
+        $query->orWhere(function($subQuery) use ($searchColumn, $parsedDate, $searchLocales, $isJsonColumn) {
             $isFirst = true;
             foreach ($searchLocales as $locale) {
                 $localeOperation = $isFirst ? 'where' : 'orWhere';
                 $isFirst = false;
                 
                 if ($isJsonColumn) {
-                    $subQuery->$localeOperation(function ($localeQuery) use ($searchColumn, $locale, $parsedDate) {
+                    $subQuery->$localeOperation(function($localeQuery) use ($searchColumn, $locale, $parsedDate) {
                         $localeQuery->whereNotNull("{$searchColumn}->{$locale}")
                                    ->whereDate("{$searchColumn}->{$locale}", $parsedDate);
                     });
                 } else {
                     // For non-JSON columns storing date as string in serialized data
-                    $subQuery->$localeOperation(function ($localeQuery) use ($searchColumn, $locale, $parsedDate) {
+                    $subQuery->$localeOperation(function($localeQuery) use ($searchColumn, $locale, $parsedDate) {
                         $dateString = $parsedDate->format('Y-m-d');
-                        $localeQuery->whereRaw("LOWER({$searchColumn}) LIKE LOWER(?)", ['%"' . $locale . '":"' . $dateString . '%"%'])
-                                   ->orWhereRaw("LOWER({$searchColumn}) LIKE LOWER(?)", ['%s:' . strlen($locale) . ':"' . $locale . '"%' . $dateString . '%']);
+                        $localeQuery->whereRaw("LOWER({$searchColumn}) LIKE LOWER(?)", ['%"'.$locale.'":"'.$dateString.'%"%'])
+                                   ->orWhereRaw("LOWER({$searchColumn}) LIKE LOWER(?)", ['%s:'.strlen($locale).':"'.$locale.'"%'.$dateString.'%']);
                     });
                 }
             }
@@ -533,17 +533,17 @@ 
             $isFirst = false;
             
             if ($searchOperator === 'LIKE' || strtolower($searchOperator) === 'like') {
-                $query->$localeOperation(function ($localeQuery) use ($searchColumn, $locale, $searchTerm, $isJsonColumn) {
+                $query->$localeOperation(function($localeQuery) use ($searchColumn, $locale, $searchTerm, $isJsonColumn) {
                     $this->applyLocaleSearch($localeQuery, $searchColumn, $locale, $searchTerm, $isJsonColumn);
                 });
             } else {
-                $query->$localeOperation(function ($localeQuery) use ($searchColumn, $locale, $searchTerm, $searchOperator, $isJsonColumn) {
+                $query->$localeOperation(function($localeQuery) use ($searchColumn, $locale, $searchTerm, $searchOperator, $isJsonColumn) {
                     if ($isJsonColumn) {
                         $localeQuery->whereNotNull("{$searchColumn}->{$locale}")
                                    ->where("{$searchColumn}->{$locale}", $searchOperator, $searchTerm);
                     } else {
                         // For non-JSON columns, we need to search within the serialized/JSON string
-                        $localeQuery->whereRaw("LOWER({$searchColumn}) LIKE LOWER(?)", ['%"' . $locale . '":"' . $searchTerm . '"%']);
+                        $localeQuery->whereRaw("LOWER({$searchColumn}) LIKE LOWER(?)", ['%"'.$locale.'":"'.$searchTerm.'"%']);
                     }
                 });
             }
@@ -565,15 +565,15 @@ 
         if ($isJsonColumn) {
             // Use proper JSON functions for JSON columns with case-insensitive search
             $query->whereRaw("JSON_EXTRACT({$searchColumn}, '$.{$locale}') IS NOT NULL")
-                  ->whereRaw("LOWER(JSON_UNQUOTE(JSON_EXTRACT({$searchColumn}, '$.{$locale}'))) LIKE LOWER(?)", ['%' . $searchTerm . '%']);
+                  ->whereRaw("LOWER(JSON_UNQUOTE(JSON_EXTRACT({$searchColumn}, '$.{$locale}'))) LIKE LOWER(?)", ['%'.$searchTerm.'%']);
         } else {
             // For text columns storing JSON as string, search within the serialized data
             // This handles both PHP serialized arrays and JSON strings with case-insensitive search
-            $query->where(function ($subQuery) use ($searchColumn, $locale, $searchTerm) {
+            $query->where(function($subQuery) use ($searchColumn, $locale, $searchTerm) {
                 // Search for JSON format: "locale":"value" (case-insensitive)
-                $subQuery->whereRaw("LOWER({$searchColumn}) LIKE LOWER(?)", ['%"' . $locale . '":"%' . $searchTerm . '%"%'])
+                $subQuery->whereRaw("LOWER({$searchColumn}) LIKE LOWER(?)", ['%"'.$locale.'":"%'.$searchTerm.'%"%'])
                          // Also search for PHP serialized format (case-insensitive)
-                         ->orWhereRaw("LOWER({$searchColumn}) LIKE LOWER(?)", ['%s:' . strlen($locale) . ':"' . $locale . '"%' . $searchTerm . '%']);
+                         ->orWhereRaw("LOWER({$searchColumn}) LIKE LOWER(?)", ['%s:'.strlen($locale).':"'.$locale.'"%'.$searchTerm.'%']);
             });
         }
     }