filter json to the table | Filament | Page 1

shell muskBOT Oct 17, 2024, 7:35 AM

#

To help others find answers, you can mark your question as solved via Right click solution message -> Apps -> ✅ Mark Solution

south siren Oct 17, 2024, 7:53 AM

#

Are you using any package for handling translations?

#

if you have that column casted as array in the Model class you can try this

TextColumn::make('value')
    ->formatStateUsing(fn (Model $record): string => $record->value["en"])

TextColumn::make('value')
    ->formatStateUsing(fn (Model $record): string => $record->value["sl"])

#

something like that, not tested

#

https://filamentphp.com/docs/3.x/tables/columns/text#custom-formatting

Text column - Table Builder - Filament

granite yacht Oct 17, 2024, 8:46 AM

#

i got this error Cannot access offset of type string on string

brave fable Oct 17, 2024, 8:54 AM

#

You might wanna look at this package, seems to do exactly what you want:
https://filamentphp.com/plugins/filament-spatie-translatable

Filament

Spatie Translatable by Filament - Filament

Filament support for Spatie's Laravel Translatable package.

granite yacht Oct 17, 2024, 8:54 AM

#

okay thanks

brave fable Oct 17, 2024, 8:56 AM

#

But if you want to keep with your original idea. You might want to check if you casted the json properly in your "Translation" model

brave fable Oct 17, 2024, 8:57 AM

#

granite yacht i got this error `Cannot access offset of type string on string`

Because this error makes it seem that it gets a string as value instead of an array (or json). Model casting would solve that

granite yacht Oct 17, 2024, 9:10 AM

#

#

its looks like this

#

in db

brave fable Oct 17, 2024, 9:12 AM

#

Yes, if you don't cast it it will return as a string

#

https://laravel.com/docs/11.x/eloquent-mutators#array-and-json-casting

Laravel - The PHP Framework For Web Artisans

Laravel is a PHP web application framework with expressive, elegant syntax. We’ve already laid the foundation — freeing you to create without sweating the small things.

granite yacht Oct 17, 2024, 9:16 AM

#

#

model looks like this

brave fable Oct 17, 2024, 9:17 AM

#

try value => 'array' instead of json

granite yacht Oct 17, 2024, 9:31 AM

#

Cannot access offset of type string on string

#

i have this error again

granite night Oct 17, 2024, 9:33 AM

#

Do you have empty values in the DB?

#

if some are null or '' you won't be able to decode it with the cast.

granite yacht Oct 17, 2024, 9:43 AM

#

#

this is my table

#

any ideas ((

#

i trying to this about 5 days ...

brave fable Oct 17, 2024, 9:50 AM

#

Can you dd the model?

so in

TextColumn::make('value')
    ->formatStateUsing(fn (Model $record): string => dd($record->value))

granite yacht Oct 17, 2024, 9:50 AM

#

okay wait

brave fable Oct 17, 2024, 9:50 AM

#

Also not sure if its allowed to have two columns with the same name 🤔
But don't quote me on that, Toeknee might know that better

granite yacht Oct 17, 2024, 9:50 AM

#

its returns 'gamarjoba'

#

like 'en' value

brave fable Oct 17, 2024, 9:51 AM

#

Can you send a screenshot?

granite yacht Oct 17, 2024, 9:51 AM

#

sure

brave fable Oct 17, 2024, 9:51 AM

#

Mmmh

#

And about your code?

#

What's the exact code that ran?

granite yacht Oct 17, 2024, 9:52 AM

#

code which u send me

#

    ->formatStateUsing(fn (Model $record): string => dd($record->value))```

#

this

#

i dd this

brave fable Oct 17, 2024, 9:52 AM

#

And the model?

granite yacht Oct 17, 2024, 9:52 AM

#

f

granite yacht Oct 17, 2024, 9:52 AM

#

granite yacht

model

#

looks like this

#

brave fable Oct 17, 2024, 9:54 AM

#

Might be the translation package intervering. Are you planning on using it? Or do you want to keep your first solution?
If you're using the package I'm pretty sure you don't need to do the ->formatStateUsing() method

granite yacht Oct 17, 2024, 9:54 AM

#

Idk for me its no problem just i want to do it

granite yacht Oct 17, 2024, 9:54 AM

#

brave fable You might wanna look at this package, seems to do exactly what you want: https:...

okay i should install this right?

brave fable Oct 17, 2024, 9:55 AM

#

I think it would work for you, but if I look at your model you already have the "HasTranslations" and public $translatable properties. So I assume you already have it installed?

granite yacht Oct 17, 2024, 9:55 AM

#

hm wait maybe its not my code only..

#

nah i iinstall it now

#

what i should do now ? 😄

brave fable Oct 17, 2024, 9:57 AM

#

Follow the documentation of the package. It should give you a step by step proces how to configure it

granite yacht Oct 17, 2024, 9:57 AM

#

ah okay thanks u ❤️

brave fable Oct 17, 2024, 9:58 AM

#

The package uses the spatie-translatable package underwater, so don't forget to read that documentation as well

#

When you're done with that remove the ->formatState() method from your column

granite yacht Oct 17, 2024, 9:59 AM

#

just TextColumn::make('value')
?

brave fable Oct 17, 2024, 9:59 AM

#

Yap I think so

granite yacht Oct 17, 2024, 10:00 AM

#

i read it but there is no example how to add table column (((

#

like its shows me only english not both

brave fable Oct 17, 2024, 10:13 AM

#

granite yacht like its shows me only english not both

If you want both at the same time the package won't work for you. In the documentation it says you need to add a switcher in the table header

#

If you want both at the same time just do your original idea

granite yacht Oct 17, 2024, 10:14 AM

#

nah i dont want this switcher,..

#

#

i already have something like this

brave fable Oct 17, 2024, 10:15 AM

#

brave fable If you want both at the same time just do your original idea

So delete the package then, remove all the configuration, debug the values you're getting back from the model and see from there

granite yacht Oct 17, 2024, 10:15 AM

#

mnehh

#

okay 😄

#

okay but u should use now formatState?

brave fable Oct 17, 2024, 10:16 AM

#

Check what data you're getting back from the model first

granite yacht Oct 17, 2024, 10:18 AM

#

like when i use only this TextColumn::make('value')

#

its shows only en text

south siren Oct 17, 2024, 10:18 AM

#

show us dd($model) instead of $model->value

granite yacht Oct 17, 2024, 10:19 AM

#

                    ->formatStateUsing(fn (Model $record): string => dd($model))        
                        ])```

#

like this?

south siren Oct 17, 2024, 10:19 AM

#

granite yacht ``` TextColumn::make('value') ->formatStateUsing(fn (Mod...

yes

#

having packages won't fix the problem because normally the package will return the value based on the locale. He wants to output all the languages on the table.

granite yacht Oct 17, 2024, 10:20 AM

#

error ```Undefined variable '$model'.intelephense(P1008)

#

but i dd $rceord and

south siren Oct 17, 2024, 10:20 AM

#

it's record, my bad

granite yacht Oct 17, 2024, 10:20 AM

#

if we go $record->attirubtes->value

#

there is

#

look

#

south siren Oct 17, 2024, 10:22 AM

#

ok, what about dd(json_decode($record->value)) ?

#

if you convert it to an array then you can json_decode($record->value)["en"] or ["sl"]

granite yacht Oct 17, 2024, 10:22 AM

#

its null

#

json_decode makes it null

south siren Oct 17, 2024, 10:23 AM

#

is the column on the database defined as text or json?

granite yacht Oct 17, 2024, 10:23 AM

#

json

south siren Oct 17, 2024, 10:25 AM

#

how are persisting the data on the database?

#

are json_encoding manually?

granite yacht Oct 17, 2024, 10:26 AM

#

look

#

south siren Oct 17, 2024, 10:26 AM

#

that doesnt answer my question xD

granite yacht Oct 17, 2024, 10:26 AM

#

hm sorry then

#

what i shouold show u ? d

south siren Oct 17, 2024, 10:27 AM

#

did you changed the creation hook function in the resource?

granite yacht Oct 17, 2024, 10:27 AM

#

    {
        $tabs = self::getTranslationTabs($form->getRecord());

        return $form
            ->schema([
                Grid::make()->schema([
                    Tabs::make('Languages')->tabs($tabs),
                    Section::make()->schema([
                        TextInput::make('alias')
                            ->label('Alias')
                            ->required()
                            ->unique(ignoreRecord: true),
                    ])->columns(1),
                ])->columns(1),
            ]);
    }

#

📎 message.txt

#

this is whole code btw

south siren Oct 17, 2024, 10:31 AM

#

it's weird that you casted the value to an array but still returns a string

granite yacht Oct 17, 2024, 10:32 AM

#

🥲

south siren Oct 17, 2024, 10:32 AM

#

try to run composer dumpautoload and php artisan optimize:clear

granite yacht Oct 17, 2024, 10:33 AM

#

i did it next?

south siren Oct 17, 2024, 10:34 AM

#

when u did dd($record) on the casts array does it show the value as an array?

granite yacht Oct 17, 2024, 10:34 AM

#

wait

#

#

nahh look

#

its json

south siren Oct 17, 2024, 10:35 AM

#

once again not what I asked xD thats the attributes, I asked for the casts (check a bit below that xD)

granite yacht Oct 17, 2024, 10:35 AM

#

#

ah sorry 😄

#

yep its json

south siren Oct 17, 2024, 10:35 AM

#

change it to array

granite yacht Oct 17, 2024, 10:36 AM

#

how 😢

#

in model?

#

okay i change it

south siren Oct 17, 2024, 10:36 AM

#

the same way you casted as json, put array xD

granite yacht Oct 17, 2024, 10:36 AM

#

its array now

south siren Oct 17, 2024, 10:36 AM

#

then dd(json_decode($record->value))

granite yacht Oct 17, 2024, 10:37 AM

#

its null again

brave fable Oct 17, 2024, 10:38 AM

#

south siren then dd(json_decode($record->value))

Don't think you need to json_decode if the field is casted to array no?

south siren Oct 17, 2024, 10:39 AM

#

brave fable Don't think you need to json_decode if the field is casted to array no?

probably xD

#

what if you do dd($record->value) is it a string or an array?

granite yacht Oct 17, 2024, 10:39 AM

#

south siren what if you do dd($record->value) is it a string or an array?

i try it and its null

#

ah no

#

its not null

#

now its shows me 'gamarjoba'

brave fable Oct 17, 2024, 10:39 AM

#

Can screenshot your code and the dd response?

granite yacht Oct 17, 2024, 10:39 AM

#

like only en value

#

south siren Oct 17, 2024, 10:40 AM

#

are you using any localization package?

granite yacht Oct 17, 2024, 10:40 AM

#

brave fable Oct 17, 2024, 10:40 AM

#

south siren are you using any localization package?

I think he is

brave fable Oct 17, 2024, 10:40 AM

#

granite yacht

^

#

"HasTranslation" & "$translatable = ['value']"

south siren Oct 17, 2024, 10:40 AM

#

brave fable ^

yeah missed that

#

maybe the package has a function to get a translatablefield by locale

granite yacht Oct 17, 2024, 10:41 AM

#

idk its not my code btw 💀

brave fable Oct 17, 2024, 10:41 AM

#

granite yacht idk its not my code btw 💀

How is it not your code?

south siren Oct 17, 2024, 10:42 AM

#

whats the package name? check composer json if you can

granite yacht Oct 17, 2024, 10:42 AM

#

brave fable How is it not your code?

someone else write it..

#

        "barryvdh/laravel-dompdf": "^3.0",
        "blade-ui-kit/blade-heroicons": "^2.3",
        "cviebrock/eloquent-sluggable": "^10.0",
        "filament/actions": "^3.2",
        "filament/filament": "3.2",
        "filament/spatie-laravel-media-library-plugin": "^3.2",
        "filament/spatie-laravel-translatable-plugin": "^3.2",
        "flowframe/laravel-trend": "^0.2.0",
        "guzzlehttp/guzzle": "^7.2",
        "laravel/framework": "^10.10",
        "laravel/sanctum": "^3.3",
        "laravel/tinker": "^2.8",
        "livewire/livewire": "^3.4",
        "mcamara/laravel-localization": "^1.8",
        "phpseclib/phpseclib": "~3.0",
        "propaganistas/laravel-phone": "^5.3",
        "pxlrbt/filament-activity-log": "^1.0",
        "saloonphp/xml-wrangler": "^1.2",
        "solution-forest/filament-tree": "^2.1",
        "spatie/laravel-permission": "^6.4",
        "spatie/laravel-sitemap": "^7.2",
        "spatie/laravel-translatable": "^6.6",
        "staudenmeir/belongs-to-through": "^2.5",
        "tymon/jwt-auth": "^2.1",
        "webbingbrasil/filament-copyactions": "^3.0"```

brave fable Oct 17, 2024, 10:43 AM

#

"filament/spatie-laravel-translatable-plugin": "^3.2",
I thought you removed this package?

granite yacht Oct 17, 2024, 10:43 AM

#

yes i remove it

brave fable Oct 17, 2024, 10:43 AM

#

Why is it still there then?

granite yacht Oct 17, 2024, 10:43 AM

#

tf its not removed

#

why

#

wait 😄

brave fable Oct 17, 2024, 10:44 AM

#

composer remove filament/spatie-laravel-translatable-plugin

granite yacht Oct 17, 2024, 10:44 AM

#

yep i run it

brave fable Oct 17, 2024, 10:44 AM

#

and there's also : spatie/laravel-translatable"

granite yacht Oct 17, 2024, 10:44 AM

#

its removed now thanks

south siren Oct 17, 2024, 10:46 AM

#

wait, dont remove the last one and instead of the dd put $record->getTranslation('value', 'en'); or $record->getTranslation('value, 'sl');

granite yacht Oct 17, 2024, 10:47 AM

#

fuck

#

$record->getTranslation('value', 'en')

#

this works now

brave fable Oct 17, 2024, 10:47 AM

#

Ah nice

granite yacht Oct 17, 2024, 10:47 AM

#

thanks lol how when

#

tf

south siren Oct 17, 2024, 10:48 AM

#

https://github.com/spatie/laravel-translatable

GitHub

GitHub - spatie/laravel-translatable: Making Eloquent models transl...

Making Eloquent models translatable. Contribute to spatie/laravel-translatable development by creating an account on GitHub.

brave fable Oct 17, 2024, 10:48 AM

#

I didn't know you were already using the spatie package

#

Well that wouldve made it easier haha

south siren Oct 17, 2024, 10:48 AM

#

and on the second textcolumn you call the sl locale

granite yacht Oct 17, 2024, 10:49 AM

#

hm but wait

#

                    ->label("English Value")
                    ->formatStateUsing(fn (Model $record): string =>$record->getTranslation('value', 'en')),
                    TextColumn::make('value')
                    ->label("Slovenian Value")
                    ->formatStateUsing(fn (Model $record): string =>$record->getTranslation('value', 'sl'))         ])

#

i write this

#

#

and its shows me only slovenian

south siren Oct 17, 2024, 10:50 AM

#

change to TextColumn::make('value_sl')

granite yacht Oct 17, 2024, 10:50 AM

#

#

now slovenian isnt showed

#

😄

south siren Oct 17, 2024, 10:51 AM

#

because the make parameter is linked to a column name I bet

#

make an attribute on the model for the sl translation and put it on the make()

granite yacht Oct 17, 2024, 10:52 AM

#

hmm okay i will try 😄

south siren Oct 17, 2024, 10:53 AM

#

or maybe a cheeky breeky way (don't think its possible) but make('value.en') and make('value.sl') 😆

granite yacht Oct 17, 2024, 10:54 AM

#

yep i try it

#

also i tryt value->en but

#

not works

south siren Oct 17, 2024, 10:55 AM

#

yeah attributes is the way to go then

granite yacht Oct 17, 2024, 10:57 AM

#

hmm how can u tellme simple way forthat?

south siren Oct 17, 2024, 10:59 AM

#

On Model

/**
     * Get the value's sl .
     */
    protected function valueSl(): Attribute
    {
        return Attribute::make(
            get: fn (string $value) => $this->getTranslation($value, 'sl'),
        );
    }

Then on the resource

TextColumn::make('value_sl')

granite yacht Oct 17, 2024, 10:59 AM

#

App\Components\Data\Translations\Models\Translations::App\Components\Data\Translations\Models{closure}(): Argument #1 ($value) must be of type string, null given

#

error is in there

#

in modle

#

but wait

south siren Oct 17, 2024, 11:00 AM

#

$value->sl? xD

granite yacht Oct 17, 2024, 11:00 AM

#

when i justimport attribiute using like this ```use Attribute;

#

same

south siren Oct 17, 2024, 11:01 AM

#

or dd($value)

granite yacht Oct 17, 2024, 11:01 AM

#

hmm wait i wiill try something

south siren Oct 17, 2024, 11:01 AM

#

use Illuminate\Database\Eloquent\Casts\Attribute;

#

https://laravel.com/docs/11.x/eloquent-mutators#defining-an-accessor

Laravel - The PHP Framework For Web Artisans

Laravel is a PHP web application framework with expressive, elegant syntax. We’ve already laid the foundation — freeing you to create without sweating the small things.

granite yacht Oct 17, 2024, 11:02 AM

#

yes and i have error `App\Components\Data\Translations\Models\Translations::App\Components\Data\Translations\Models{closure}(): Argument #1 ($value) must be of type string, null given

`

south siren Oct 17, 2024, 11:02 AM

#

try $this->getTranslation('value', 'sl')

#

or $this->getTranslation($this->value, 'sl')

granite yacht Oct 17, 2024, 11:03 AM

#

nahh same error

south siren Oct 17, 2024, 11:04 AM

#

get: fn (string $value) => dd($this)

granite yacht Oct 17, 2024, 11:04 AM

#

i try it too

#

but same error lol

south siren Oct 17, 2024, 11:04 AM

#

but the error stack is pointing to the model file or the resource?

granite yacht Oct 17, 2024, 11:05 AM

#

model

#

brave fable Oct 17, 2024, 11:07 AM

#

south siren or maybe a cheeky breeky way (don't think its possible) but make('value.en') and...

Should work normally, but the translation package is probably intervering

south siren Oct 17, 2024, 11:08 AM

#

yeah but I think there's more to it because I've used this package before and never had this problem

granite yacht Oct 17, 2024, 11:09 AM

#

hmm btw me

#

i have no idea why 😄

south siren Oct 17, 2024, 11:13 AM

#

remove the cast to array because if you're using the package it should handle itself

#

return Attribute::make(
            get: fn (string $value) => dd($value),
        );

granite yacht Oct 17, 2024, 11:31 AM

#

i remove cast and write this but same error

south siren Oct 17, 2024, 11:48 AM

#

what about

TextColumn::make('value_sl')
    ->state(function (Model $record): string {
        return $record->getTranslation('value','sl);
    })

#

remove the attribute stuff from the model

granite yacht Oct 17, 2024, 11:49 AM

#

omg

#

ur genius bro

#

but wait when i click edit

#

#

value is empty 😢 any idea how to fill automaticly this ?

south siren Oct 17, 2024, 11:50 AM

#

the edit is another issue

#

I dont know the code for the edit

granite yacht Oct 17, 2024, 11:51 AM

#

okay i will try by myself first

#

thanks btw for ur time and help

#

thank u soo much ❤️

south siren Oct 17, 2024, 11:51 AM

#

no prob

granite yacht Oct 18, 2024, 8:23 AM

#

like i have same issue in another component and its works for another component but for this not

#

` public static function form(Form $form): Form
{
$tabs = self::getTranslationTabs($form->getRecord());

    return $form
        ->schema([
            Grid::make()->schema([
                Tabs::make('Languages')->tabs($tabs),
            ])->columns(1),
            Section::make()->schema([
                TextInput::make('alias')
                    ->label('Alias')
                    ->required()
                    ->unique(ignoreRecord: true),
            ])->columns(1),
        ]);
}

`

#

like this is my code

#

public static function form(Form $form): Form { $tabs = self::getTranslationTabs($form->getRecord()); return $form ->schema([ Grid::make()->schema([ Tabs::make('Languages')->tabs($tabs) ])->columns(1), Select::make('country_id')->label('Country')->placeholder('აირჩიეთ') ->options(Country::all()->pluck('name', 'id')) ->relationship( 'country', 'name', modifyQueryUsing: function (Builder $query, string $operation) { $query->selectRaw("id, json_unquote(json_extract(name,'$.en')) as name"); }, ) ->preload(), ]); } and this is another component code

granite yacht Oct 18, 2024, 8:24 AM

#

granite yacht

and in another translations like there when i click name is filled but in mine not

#filter json to the table