@@ -19,18 +19,18 @@ discard block |
||
| 19 | 19 | { |
| 20 | 20 | static::addGlobalScope(new TranslatableScope); |
| 21 | 21 | |
| 22 | - static::saving(function ($model) { |
|
| 22 | + static::saving(function($model) { |
|
| 23 | 23 | $model->translatable = collect($model->attributes)->only(static::$transtableFieldName)->toArray(); |
| 24 | 24 | $model->attributes = collect($model->attributes)->except(static::$transtableFieldName)->toArray(); |
| 25 | 25 | }); |
| 26 | 26 | |
| 27 | - static::saved(function ($model) { |
|
| 27 | + static::saved(function($model) { |
|
| 28 | 28 | if ($model->translatable) { |
| 29 | 29 | (new self)->saveTranslation($model); |
| 30 | 30 | } |
| 31 | 31 | }); |
| 32 | 32 | |
| 33 | - static::deleted(function ($model) { |
|
| 33 | + static::deleted(function($model) { |
|
| 34 | 34 | if ((new $model)->has('translations')) { |
| 35 | 35 | $model->translations()->delete(); |
| 36 | 36 | } |
@@ -67,7 +67,7 @@ discard block |
||
| 67 | 67 | } |
| 68 | 68 | |
| 69 | 69 | // Build the sub select |
| 70 | - $fields->each(function ($key) use ($query) { |
|
| 70 | + $fields->each(function($key) use ($query) { |
|
| 71 | 71 | $this->subSelectTranslation($query, $key); |
| 72 | 72 | }); |
| 73 | 73 | |
@@ -77,13 +77,13 @@ discard block |
||
| 77 | 77 | protected function subSelectTranslation($query, $key): void |
| 78 | 78 | { |
| 79 | 79 | $query->addSelect([ |
| 80 | - $key => function ($query) use ($key) { |
|
| 81 | - $query->select(Translation::getTableName() . '.value') |
|
| 80 | + $key => function($query) use ($key) { |
|
| 81 | + $query->select(Translation::getTableName().'.value') |
|
| 82 | 82 | ->from(Translation::getTableName()) |
| 83 | - ->where(Translation::getTableName() . '.translatable_type', '=', \get_class($this)) |
|
| 84 | - ->where(Translation::getTableName() . '.locale', '=', $this->locale) |
|
| 85 | - ->where(Translation::getTableName() . '.key', '=', $key) |
|
| 86 | - ->where(Translation::getTableName() . '.translatable_id', '=', \DB::raw($this->getTable() . '.' . $this->primaryKey)); |
|
| 83 | + ->where(Translation::getTableName().'.translatable_type', '=', \get_class($this)) |
|
| 84 | + ->where(Translation::getTableName().'.locale', '=', $this->locale) |
|
| 85 | + ->where(Translation::getTableName().'.key', '=', $key) |
|
| 86 | + ->where(Translation::getTableName().'.translatable_id', '=', \DB::raw($this->getTable().'.'.$this->primaryKey)); |
|
| 87 | 87 | } |
| 88 | 88 | ]); |
| 89 | 89 | |
@@ -106,10 +106,10 @@ discard block |
||
| 106 | 106 | { |
| 107 | 107 | $table = Translation::getTableName(); |
| 108 | 108 | |
| 109 | - return DB::table($table)->select($table . '.key') |
|
| 110 | - ->where($table . '.translatable_type', \get_class($this)) |
|
| 111 | - ->where($table . '.locale', $this->locale) |
|
| 112 | - ->groupBy($table . '.key') |
|
| 109 | + return DB::table($table)->select($table.'.key') |
|
| 110 | + ->where($table.'.translatable_type', \get_class($this)) |
|
| 111 | + ->where($table.'.locale', $this->locale) |
|
| 112 | + ->groupBy($table.'.key') |
|
| 113 | 113 | ->pluck('key'); |
| 114 | 114 | } |
| 115 | 115 | |
@@ -124,20 +124,20 @@ discard block |
||
| 124 | 124 | |
| 125 | 125 | protected function fullTextWildcards($term) |
| 126 | 126 | { |
| 127 | - return collect(explode(' ', str_replace(['-', '+', '<', '>', '@', '(', ')', '~'], '', $term)))->map(function ($word, $key) { |
|
| 128 | - return strlen($word) >= 3 ? '+' . $word . '*' : ''; |
|
| 127 | + return collect(explode(' ', str_replace(['-', '+', '<', '>', '@', '(', ')', '~'], '', $term)))->map(function($word, $key) { |
|
| 128 | + return strlen($word) >= 3 ? '+'.$word.'*' : ''; |
|
| 129 | 129 | })->implode(' '); |
| 130 | 130 | } |
| 131 | 131 | |
| 132 | 132 | public function scopeSearchFullText($query, $term, $fields = []) |
| 133 | 133 | { |
| 134 | 134 | $alias = Str::random(8); |
| 135 | - return $query->join(\DB::raw('translations as ' . $alias . ' ON ' . $alias . '.translatable_id = ' . $this->getTable() . '.' . $this->primaryKey)) |
|
| 135 | + return $query->join(\DB::raw('translations as '.$alias.' ON '.$alias.'.translatable_id = '.$this->getTable().'.'.$this->primaryKey)) |
|
| 136 | 136 | ->addSelect([ |
| 137 | - 'relevance' => function ($query) use ($term, $alias) { |
|
| 138 | - $query->selectRaw("MATCH (`' . $alias . '`.`value`) AGAINST ('" . $this->fullTextWildcards($term) . "' IN BOOLEAN MODE)") |
|
| 137 | + 'relevance' => function($query) use ($term, $alias) { |
|
| 138 | + $query->selectRaw("MATCH (`' . $alias . '`.`value`) AGAINST ('".$this->fullTextWildcards($term)."' IN BOOLEAN MODE)") |
|
| 139 | 139 | ->from('translations') |
| 140 | - ->where($alias . '.translatable_id', DB::raw($this->getTable() . '.' . $this->primaryKey)) |
|
| 140 | + ->where($alias.'.translatable_id', DB::raw($this->getTable().'.'.$this->primaryKey)) |
|
| 141 | 141 | ->limit(1); |
| 142 | 142 | } |
| 143 | 143 | ]) |