Level 102
What do you mean by formatted? How are you formatting it? An accessor?
Jan 30, 2025
9
Level 1
How do I get formatted table records?
How can I get table data in trait? table->getRecords() gets the database data. This is not enough for me because I show the data in the table by formatting it. Is there any way to get the fully formatted data in the table?
Level 1
@Sinnbeck For example, movement_type value comes IN with db. I show the value that matches the FormatStateUsing enum in the table. When I get the records as I mentioned, it will be necessary to redefine this and similar formats for each column. And I am trying to write a triad for many tables because I need a dynamic structure. So I need to get what is in the table as it is.
Level 73
@rmznatly The what, the what and the what? That sentence makes n o sense to me whatsoever.
Level 102
@rmznatly you can do casting on the model if that's what you mean
https://laravel.com/docs/11.x/eloquent-mutators#defining-an-accessor
https://laravel.com/docs/11.x/eloquent-mutators#enum-casting
1 like
Level 1
@Tray2 Since English is not my first language, I can make spelling mistakes.
Level 1
Tables\Columns\TextColumn::make('movement_model') ->label('Hareket Türü') ->icon(function ($state) { if (class_exists($state)) { return $state::getNavigationIcon(); } else { return 'heroicon-o-bars-3-bottom-left'; } }) ->formatStateUsing(fn($record) => CustomerAccountFinanceMovementType::tryFrom($record->movement_name)?->label() ?? 'N/A') ->size(TextColumnSize::Medium) ->badge() ->color(fn($record) => CustomerAccountFinanceMovementType::tryFrom($record->movement_name)?->color() ?? 'gray'),
Incoming “CASH_IN” value is converted to “Cash In” with formatStateUsing.
trait PdfExport { public function exportToPdf() { $data = $this->table->getRecords(); dd($data); .... } }
When I get the table records here, the data comes with the value “CASH_IN”, not “Cash In”. getRecords brings the records in their original form. Is there any way to get the transformed data in the table? This is exactly my question.
Level 73
@rmznatly Mine neither, and I wasn't refering to the spelling, just the problems I had trying the deschifer what you meant.
Level 1
@Tray2 Thx. I tried to explain my problem with detailed examples in my previous reply. Do you have a suggestion?
Level 4
@rmznatly you can mutate it in the model, you can also map using the map method after you get the data from the query, you can also try using a Resource class
Please or to participate in this conversation.