export recored in csv use custome query in filament-expoter

[HENILCODES]

Package

Actions

Package Version

v3.0

How can we help you?

I want export row base on custome query in filament-expoter

<?php

namespace App\Filament\Exports\Reports;

use App\Models\Transaction\Billing;
use Filament\Actions\Exports\ExportColumn;
use Filament\Actions\Exports\Exporter;
use Filament\Actions\Exports\Models\Export;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Support\Facades\DB;

class LedgerReportsExporter extends Exporter
{
    protected static ?string $model = Billing::class;

    public static function getColumns(): array
    {
        return [
            ExportColumn::make('customer_name')->label('Customer'),
            ExportColumn::make('credit'),
            ExportColumn::make('debit'),
            ExportColumn::make('balance'),
        ];
    }
    public static function modifyQuery(Builder $query): Builder
    {
        return $query->select(
            'customer_id',
            DB::raw('SUM(grand_total) as credit'),
            DB::raw('COALESCE(0) as debit'),
            DB::raw('SUM(grand_total) - COALESCE(0) as balance'),
            'customers.name as customer_name'
        )->where('billings.deleted_at', null)->groupBy('customer_id', 'customers.name');
    }

    public function getFileName(Export $export): string
    {
        return "LedgerReport";
    }

    public static function getCompletedNotificationBody(Export $export): string
    {
        $body = 'Your customer export has completed and ' . number_format($export->successful_rows) . ' ' . str('row')->plural($export->successful_rows) . ' exported.';

        if ($failedRowsCount = $export->getFailedRowsCount()) {
            $body .= ' ' . number_format($failedRowsCount) . ' ' . str('row')->plural($failedRowsCount) . ' failed to export.';
        }

        return $body;
    }
}

[HENILCODES]

i try but it not work it show error on expot

[HENILCODES]

it show error like this on laravel.log

[2024-05-17 21:21:03] local.ERROR: SQLSTATE[42000]: Syntax error or access violation: 1055 'aalam.billings.id' isn't in GROUP BY (Connection: mysql, SQL: select distinct billings.id from billings inner join customers on billings.customer_id = customers.id where billings.deleted_at is null and billings.deleted_at is null and billings.deleted_at is null group by customer_id, customers.name, customer_id, customers.name order by billings.id asc, id asc limit 1000) {"exception":"[object] (Illuminate\Database\QueryException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1055 'aalam.billings.id' isn't in GROUP BY (Connection: mysql, SQL: select distinct billings.id from billings inner join customers on billings.customer_id = customers.id where billings.deleted_at is null and billings.deleted_at is null and billings.deleted_at is null group by customer_id, customers.name, customer_id, customers.name order by billings.id asc, id asc limit 1000) at /home/henilcode/Documents/Aalam/vendor/laravel/framework/src/Illuminate/Database/Connection.php:813)

[tudorr89]

load your relation using with and apply the grouping there