dyo Posts - Answer Overflow

dyo

Posts Comments

FFilament

•Created by dyo on 2/10/2025 in #❓┊help

Listing multiple values in TextColumn with groupby a certain attribute

How can I Listing multiple values in TextColumn with groupby a certain attribute?

8 replies

FFilament

•Created by dyo on 2/4/2025 in #❓┊help

make form in modal is centered

8 replies

FFilament

•Created by dyo on 1/30/2025 in #❓┊help

Error in searchable TextColumn

I have attributes of name and phone using TextColumn searchable method. the user sometimes accidentally paste the text in search input with emoticon in it, and these error appeared.. Error: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb3_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,COERCIBLE) for operation 'like' (Connection: mysql, SQL: select * from prospek where phone LIKE %asyaaAllahAlhamdul% or name LIKE %Maa syaa Allah Alhamdulillah.. 🤲🤲% limit 10) how can I return the search result to null, or remove the emoticon if it exist in the string again?

3 replies

FFilament

•Created by dyo on 1/28/2025 in #❓┊help

Having a tooltip in Stat description()

5 replies

FFilament

•Created by dyo on 11/28/2024 in #❓┊help

Problem in running render test at ManageRelatedRecords class

This is my test code

$this->actingAs($this->user)
    ->livewire(ManageCampaignRef::class, [
        'ownerRecord' => $this->sample_data,
        'pageClass' => EditCampaign::class,
    ])
    ->assertCanSeeTableRecords($this->sample_data->campaign_ref);

$this->actingAs($this->user)
    ->livewire(ManageCampaignRef::class, [
        'ownerRecord' => $this->sample_data,
        'pageClass' => EditCampaign::class,
    ])
    ->assertCanSeeTableRecords($this->sample_data->campaign_ref);

And I got error when I run the test:

Unable to resolve dependency [Parameter #0 [ <required> string|int $record ]] in class Filament\Resources\Pages\ManageRelatedRecords

Unable to resolve dependency [Parameter #0 [ <required> string|int $record ]] in class Filament\Resources\Pages\ManageRelatedRecords

I already make sure that the global variable above is correct. $this->user is a model record user. $this->sample_data is a model record of campaign. What probably did I missed?

4 replies

FFilament

•Created by dyo on 11/26/2024 in #❓┊help

Problems in updating page global variable

4 replies

FFilament

•Created by dyo on 11/12/2024 in #❓┊help

table filter with right-left navigation

6 replies

FFilament

•Created by dyo on 11/11/2024 in #❓┊help

Adjust the component height

8 replies

FFilament

•Created by dyo on 10/26/2024 in #❓┊help

Before method in repeater delete action

How can I have like a before method in repeater delete action?

23 replies

FFilament

•Created by dyo on 10/16/2024 in #❓┊help

isTableRecordSelectable is not working

I want to hide bulk select in certain records with the following conditions, but when it met, the bulk checkbox is still exist, what did I miss?

public function isTableRecordSelectable(): ?Closure
    {
        return fn(Model $record): bool => !in_array($record->status_konf, ['Sukses', 'success', 'Paid']);
    }

public function isTableRecordSelectable(): ?Closure
    {
        return fn(Model $record): bool => !in_array($record->status_konf, ['Sukses', 'success', 'Paid']);
    }

3 replies

FFilament

•Created by dyo on 10/10/2024 in #❓┊help

Problem in table tabs at the custom page

Why my tabs modified query in not applied to the table when the tab is selected? Can someon tell me what is missing?

9 replies

FFilament

•Created by dyo on 9/25/2024 in #❓┊help

Optimize duplicate queries in 2 method at the same TextColumn Class

Can someone help me to optimize with this case, TextColumn::make('jenisDonasi.nama_jenis') ->tooltip(function ($record) { if ($record->campaign) { return 'Campaign: ' . $record->campaign->judul; } }) ->description(function ($record) { if ($record->campaign) { return 'Lihat campaign'; } }) The $record->campaign is a belongsTo relationship query, which is duplicate. How can I execute only one $record->campaign to both method above in TextColumn?

10 replies

FFilament

•Created by dyo on 9/21/2024 in #❓┊help

Problems in duplicate query detected at debugbar

Here's a table action I'm using, with some conditions to be visible Action::make('verifikasi') ->icon('heroicon-o-magnifying-glass') ->visible(function ($record) { if ( $record->trans_ref != null && in_array($record->status_konf, ['Baru', 'Pending', 'Cek Lagi']) ) { return Setoran::unconfirm() ->where('rekening_id', $record->rekening_id) ->whereDate('tanggal', '>=', date('Y-m-d', strtotime($record->tanggal))) ->where('dana', $record->dana) ->exists(); } }) The problem is, why the query of model Setoran above is detected duplicate or executed twice in debugbar queries tab? The conditions above is only met in one record at the table. I hope someone can explain me what's wrong.

2 replies

FFilament

•Created by dyo on 9/14/2024 in #❓┊help

Problem getting multiple select value in action modal form

How can I get multiple select values of form method in action method in Action class? I didn't find it when I check in $data at action method function.

Action::make('masuka_label')
    ->action(function ($record, array $data, $livewire): void {
        dd(
            $record,
            $data,
            $livewire
        );

        $user = auth()->user();

        $label = [
            'label_id' => $data['label_id'],
            'prospek_id' => $record->id,
            'prioritas_id' => $user->prioritas_id,
            'cms_users_id' => $user->id,
            'lembagaId' => $user->lembaga_id,
        ];

        if ($data['label_baru'] == null) {
            LabelProspek::updateOrCreate($label, $label);
        } else {
            $label['label_id'] = Label::create(['label' => $data['label_baru']])->id;
            LabelProspek::create($label);
        }
    })
    ->fillForm(fn($record) => [
        'label_prospek' => $record->label_prospek->pluck('id')
    ])
    ->form([
        Select::make('label_prospek')
            ->multiple()
            ->relationship(
                'label_prospek',
                'label',
                fn(Builder $query) => $query
                    ->whereHas('label_prospek', function (Builder $q) {
                        return $q->where('cms_users_id', auth()->user()->id);
                    })
            )
            ->preload(),

        TextInput::make('label_baru')
    ])
    ->requiresConfirmation(),

Action::make('masuka_label')
    ->action(function ($record, array $data, $livewire): void {
        dd(
            $record,
            $data,
            $livewire
        );

        $user = auth()->user();

        $label = [
            'label_id' => $data['label_id'],
            'prospek_id' => $record->id,
            'prioritas_id' => $user->prioritas_id,
            'cms_users_id' => $user->id,
            'lembagaId' => $user->lembaga_id,
        ];

        if ($data['label_baru'] == null) {
            LabelProspek::updateOrCreate($label, $label);
        } else {
            $label['label_id'] = Label::create(['label' => $data['label_baru']])->id;
            LabelProspek::create($label);
        }
    })
    ->fillForm(fn($record) => [
        'label_prospek' => $record->label_prospek->pluck('id')
    ])
    ->form([
        Select::make('label_prospek')
            ->multiple()
            ->relationship(
                'label_prospek',
                'label',
                fn(Builder $query) => $query
                    ->whereHas('label_prospek', function (Builder $q) {
                        return $q->where('cms_users_id', auth()->user()->id);
                    })
            )
            ->preload(),

        TextInput::make('label_baru')
    ])
    ->requiresConfirmation(),

12 replies

FFilament

•Created by dyo on 9/10/2024 in #❓┊help

Alpine Expression Error: error is not defined when using fileupload

Why I got error in console, said: "Alpine Expression Error: error is not defined" When I'm using Fileupload, with only method required() at it?

5 replies

FFilament

•Created by dyo on 8/16/2024 in #❓┊help

Problem in modal form

Action::make('import') ->form([ FileUpload::make('upload'), ]) ->action(function (array $data) { Excel::import(new DistribusiFirstSheet, $data['upload']); }), I want to create a modal form with FileUpload in it, but when i submit the uploaded form i got error: Illuminate \ Contracts \ Filesystem \ FileNotFoundException What did I miss?

9 replies

FFilament

•Created by dyo on 8/16/2024 in #❓┊help

Set dependant value of Datepicker in form() Filter

In table filter class, how can I set other Filter form based on other value? In my example, if konfirmasi_hari_ini is checked, then the value of filter ['tanggal']['from'] and ['tanggal']['until'] is set to now()

Filter::make('konfirmasi_hari_ini')
    ->toggle()
    ->query(
        fn(Builder $query) => $query->whereDate('tanggal', '>=', date('Y-m-d'))
    )
    ->columnSpanFull(),

Filter::make('tanggal')
    ->form([
        Forms\Components\DatePicker::make('from')
            // ->maxDate(now()) // sementara tidak perlu karena perlu tranking data yang salah input dari user jk tgl nya lebih besar dari hari ini
            ->label('Dari Tanggal')
            ->default(now())
            ->native(false)
            ->reactive()
            ->closeOnDateSelection(),

        Forms\Components\DatePicker::make('until')
            // ->maxDate(now()) // sementara tidak perlu karena perlu tranking data yang salah input dari user jk tgl nya lebih besar dari hari ini
            ->label('Sampai Tanggal')
            ->minDate(fn($get) => $get('from'))
            ->native(false)
            ->closeOnDateSelection(),
    ])

Filter::make('konfirmasi_hari_ini')
    ->toggle()
    ->query(
        fn(Builder $query) => $query->whereDate('tanggal', '>=', date('Y-m-d'))
    )
    ->columnSpanFull(),

Filter::make('tanggal')
    ->form([
        Forms\Components\DatePicker::make('from')
            // ->maxDate(now()) // sementara tidak perlu karena perlu tranking data yang salah input dari user jk tgl nya lebih besar dari hari ini
            ->label('Dari Tanggal')
            ->default(now())
            ->native(false)
            ->reactive()
            ->closeOnDateSelection(),

        Forms\Components\DatePicker::make('until')
            // ->maxDate(now()) // sementara tidak perlu karena perlu tranking data yang salah input dari user jk tgl nya lebih besar dari hari ini
            ->label('Sampai Tanggal')
            ->minDate(fn($get) => $get('from'))
            ->native(false)
            ->closeOnDateSelection(),
    ])

3 replies

FFilament

•Created by dyo on 8/5/2024 in #❓┊help

Problem with bulk selection in custom page table

I'm using filament table on a custom page. If I select bulk data, and I choose to select all, why is it only selected the first row? What am I missing?

6 replies

FFilament

•Created by dyo on 8/2/2024 in #❓┊help

Using global variable in form input method at resource class

How can I use like a global variable in form input method at resource class? Here's my case:

TextInput::make('jumlah')
    ->prefixIcon(
        function ($record) {
            if ($record->retur_vendor_detail->sum('jumlah') != $record->jumlah) {
                return 'heroicon-o-exclamation-triangle';
            }

            return null;
        }
    )
    ->prefixIconColor('danger')
    ->helperText(function ($record) {
        if ($record->retur_vendor_detail->sum('jumlah') != $record->jumlah) {
            return '* Jumlah tidak sesuai dengan data retur vendor detail.';
        }

        return null;
    }),

TextInput::make('jumlah')
    ->prefixIcon(
        function ($record) {
            if ($record->retur_vendor_detail->sum('jumlah') != $record->jumlah) {
                return 'heroicon-o-exclamation-triangle';
            }

            return null;
        }
    )
    ->prefixIconColor('danger')
    ->helperText(function ($record) {
        if ($record->retur_vendor_detail->sum('jumlah') != $record->jumlah) {
            return '* Jumlah tidak sesuai dengan data retur vendor detail.';
        }

        return null;
    }),

I want $record->retur_vendor_detail->sum('jumlah') to be called only once.

8 replies

FFilament

•Created by dyo on 7/22/2024 in #❓┊help

send parameter to create record page

How can I send parameter to create record page? I want to create the record in other related record header page.

5 replies

Gaming

Programming