Nova Support (search and sorting)

[u12206050]

In order for translations to work in nova and not break global search and sorting of columns that are translated update your app/Nova/Resource.php by adding the following code which overwrites the search and ordering functions:

protected static function applyTranslation($query, $columns, $callback, $values = null) {
        $base = $query->getModel();
        $baseTable = $base->getTable();
        $translatedTable = false;
        $attrs = $base->translatedAttributes;
        if (!empty($attrs)) {
            $translatedClass = static::$model . "Translation";
            $T = new $translatedClass();
            $translatedTable = $T->getTable();
            $translatedTableId = "$translatedTable." . str_replace('_translations', '_id', $translatedTable);

            $subQuery = DB::table($translatedTable)->select($translatedTableId);
            foreach ($columns as $column) {
                if (in_array($column, $attrs)) {
                    $subQuery->addSelect($column);
                }
            }
            $subQuery->where('locale', '=', app()->getLocale());
            $subQuery->orWhere('locale', '=', config('translatable.fallback_locale'));

            $query->joinSub($subQuery, $translatedTable, function ($join) use ($translatedTable, $translatedTableId, $baseTable) {
                $join->on("$translatedTableId", '=', "$baseTable.id");
            });
        }

        foreach ($columns as $column) {
            if ($translatedTable && in_array($column, $attrs)) {
                $nsColumn = "$translatedTable.$column";
            } else $nsColumn = "$baseTable.$column";

            if (isset($values)) $callback($query, $nsColumn, $values[$column]);
            else $callback($query, $nsColumn);
        }

        return $query;
    }

    /**
     * Apply the search query to the query.
     *
     * @param  \Illuminate\Database\Eloquent\Builder  $query
     * @param  string  $search
     * @return \Illuminate\Database\Eloquent\Builder
     */
    protected static function applySearch($query, $search)
    {
        $connectionType = $query->getModel()->getConnection()->getDriverName();
        $likeOperator = $connectionType == 'pgsql' ? 'ilike' : 'like';

        $searchable = static::searchableColumns();
        if (empty($searchable)) return $query;

        return static::applyTranslation($query, $searchable, function($query, $column) use ($likeOperator, $search) {
            $query->orWhere($column, $likeOperator, '%'.$search.'%');
        });
    }

    /**
     * Apply any applicable orderings to the query.
     *
     * @param  \Illuminate\Database\Eloquent\Builder  $query
     * @param  array  $orderings
     * @return \Illuminate\Database\Eloquent\Builder
     */
    protected static function applyOrderings($query, array $orderings)
    {
        $orderings = array_filter($orderings);

        if (empty($orderings)) {
            return empty($query->getQuery()->orders)
                        ? $query->latest($query->getModel()->getQualifiedKeyName())
                        : $query;
        }

        return static::applyTranslation($query, array_keys($orderings), function($query, $column, $direction) {
            $query->orderBy($column, $direction);
        }, $orderings);
    }

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

[stale]

This issue has been automatically closed because it has not had recent activity. Thank you for your contributions.