itsmejyv Comments - Answer Overflow

  ->summarize(
                        Summarizer::make()
                            ->label('Total Amount')
                            ->using(fn ($query) => $query->sum('debits') - $query->sum('credits')) // Calculate dynamically
                    ),

  ->summarize(
                        Summarizer::make()
                            ->label('Total Amount')
                            ->using(fn ($query) => $query->sum('debits') - $query->sum('credits')) // Calculate dynamically
                    ),

10 replies

FFilament

•Created by itsmejyv on 9/18/2024 in #❓┊help

I need to create total of debits and credits without creating column for it

Im so close to it but I'm not sure what logic need to use if I filtered the data using search or filters.

// this work but only overall total, if I use search and filter. it still get the overall total not the current total of debits and credits.

$query = SavingsDeposit::query();

        $debitsTotal = $query->sum('debits');
        $creditsTotal = $query->sum('credits');
        $total = $debitsTotal - $creditsTotal;

Tables\Columns\TextColumn::make('')
                    ->formatStateUsing(fn() => $total)
                    ->summarize(
                        Summarizer::make()
                            ->label('Total Amount')
                            ->using(fn() => $total)
                    ),

// this work but only overall total, if I use search and filter. it still get the overall total not the current total of debits and credits.

$query = SavingsDeposit::query();

        $debitsTotal = $query->sum('debits');
        $creditsTotal = $query->sum('credits');
        $total = $debitsTotal - $creditsTotal;

Tables\Columns\TextColumn::make('')
                    ->formatStateUsing(fn() => $total)
                    ->summarize(
                        Summarizer::make()
                            ->label('Total Amount')
                            ->using(fn() => $total)
                    ),

10 replies

FFilament

•Created by itsmejyv on 9/18/2024 in #❓┊help

I need to create total of debits and credits without creating column for it

I'm using the built in summarize table

10 replies

FFilament

•Created by Null Keso on 9/18/2024 in #❓┊help

Is there a way to use filament's table without passing any query, but only an array of data?

how will it get a data if there's no query?

15 replies

FFilament

•Created by itsmejyv on 9/18/2024 in #❓┊help

Is there a way to ask the user for confirmation before reloading the web page in forms?

thanks man!

5 replies

FFilament

•Created by itsmejyv on 9/15/2024 in #❓┊help

How to arrange horizontally the widgets?

Thanks man, documentation is so confusing sometimes.

4 replies

FFilament

•Created by itsmejyv on 9/7/2024 in #❓┊help

how to add recaptcha in filament login form?

Additionally information: https://www.youtube.com/watch?v=v8R0FRkFOmg

11 replies

FFilament

•Created by itsmejyv on 9/7/2024 in #❓┊help

how to add recaptcha in filament login form?

Here's how I did it for future newbie like me: Install first the dependent package:

composer require anhskohbo/no-captcha

composer require anhskohbo/no-captcha

Add these two to your .env and paste your google site and secret key there

NOCAPTCHA_SECRET=secret-key
NOCAPTCHA_SITEKEY=site-key

NOCAPTCHA_SECRET=secret-key
NOCAPTCHA_SITEKEY=site-key

Install this for filament:

composer require abanoubnassem/filament-grecaptcha-field

composer require abanoubnassem/filament-grecaptcha-field

Then publish it (required):

php artisan vendor:publish --provider="Anhskohbo\NoCaptcha\NoCaptchaServiceProvider"

php artisan vendor:publish --provider="Anhskohbo\NoCaptcha\NoCaptchaServiceProvider"

add this two code, in login.blade.php inside of the form (if you're using the built-in filament login)

 {!! NoCaptcha::renderJs() !!}
{!! NoCaptcha::display() !!}

 {!! NoCaptcha::renderJs() !!}
{!! NoCaptcha::display() !!}

Then modify it and follow other instruction after adding it. https://github.com/anhskohbo/no-captcha

11 replies

FFilament

•Created by itsmejyv on 9/7/2024 in #❓┊help

how to add recaptcha in filament login form?

Ok , I figured it out. thanks to my brain.

11 replies

FFilament

•Created by itsmejyv on 9/7/2024 in #❓┊help

how to add recaptcha in filament login form?

can't understand the entire documentation

11 replies

FFilament

•Created by itsmejyv on 9/4/2024 in #❓┊help

Class App\Models\User does not implement abstract methods:function canAccessPanel(\Filament\Panel $

Thanks man, I forgot it

6 replies

FFilament

•Created by itsmejyv on 9/4/2024 in #❓┊help

Class App\Models\User does not implement abstract methods:function canAccessPanel(\Filament\Panel $

6 replies

FFilament

•Created by itsmejyv on 9/4/2024 in #❓┊help

Plugin Recommendation: Do we have a plugin where there's a edit profile with 2FA and with 2FA login?

Found a good one: https://filamentphp.com/plugins/jeffgreco-breezy#two-factor-authentication

4 replies

FFilament

•Created by itsmejyv on 9/1/2024 in #❓┊help

Unable to find component after executing php artisan route:cache

solved by executing this command:

php artisan filament:clear-cached-component

php artisan filament:clear-cached-component

Gaming

Programming