[excel_export] Rows dismissed and incorrect data when modifying query to group based sums

[acabust0000]

Package

Actions

Package Version

v3.2.132

How can we help you?

I'm modifying the exporter query to return a custom collection of statistics based on the orders that I have.

Query seems fine as data is what I need. Unfortunately, the export seems to be incorrect as the exported data does not seem to include all of the data.

When starting the export process, the database notification notifies that rows export is incomplete (ie: 4 out of 40 rows exported)

public static function modifyQuery(Builder $query): Builder
    {
        return (new Order)->newQueryWithoutRelationships()->withoutGlobalScopes()
            ->selectRaw('COUNT(*) as total')
            ->selectRaw('SUM(estimated_weight) as estimated_weight')
            ->selectRaw('SUM(cost) as cost')
            ->selectRaw('SUM(weight_cost) as weight_cost')
            ->selectRaw('SUM(delivery_cost) as delivery_total')
            ->selectRaw('SUM(discounted_cost) as discounted_cost')
            ->selectRaw("COALESCE(order_types.label, 'Total') as label")
            ->selectRaw('COUNT(packages.id) as packages_count')
            ->selectRaw('SUM(packages.weight) as packages_weight')
            ->leftJoin('order_types', 'orders.order_type_id', '=', 'order_types.id')
            ->leftJoin('packages', 'orders.id', '=', 'packages.order_id')
            ->groupBy('orders.order_type_id');
    }

    public static function getColumns(): array
    {
        return [
            ExportColumn::make('label')
                ->label('Tip comanda')
            ,
            ExportColumn::make('total')
                ->label('Total')
            ,
            ExportColumn::make('cost')
                ->label('Cost')
            ,
             ExportColumn::make('weight_cost')
                ->label('Cost greutate')
            ,
            ExportColumn::make('delivery_cost')
                ->label('Cost livrare')
            ,
            ExportColumn::make('discounted_cost')
                ->label('Cost final')
            ,
            ExportColumn::make('estimated_weight')
                ->label('Gretutate estimata')
            ,
            ExportColumn::make('packages_weight')
                ->label('Greutate')
            ,
            ExportColumn::make('packages_count')
                ->label('Colete')
            ,
        ];
    }

Query result:

Illuminate\Database\Eloquent\Collection {#2466
    all: [
      App\Models\Order {#4390
        total: 44,
        estimated_weight: 31294.12,
        cost: 47213.83,
        weight_cost: 46829.83,
        delivery_total: 384.0,
        discounted_cost: 46856.69,
        label: "General",
        packages_count: 40,
        packages_weight: 129156.0,
      },
      App\Models\Order {#4369
        total: 11,
        estimated_weight: 4481.3,
        cost: 723.0,
        weight_cost: 595.0,
        delivery_total: 128.0,
        discounted_cost: 704.1,
        label: "Bicicleta",
        packages_count: 8,
        packages_weight: 460.0,
      },
      App\Models\Order {#4087
        total: 14,
        estimated_weight: 3474.72,
        cost: 1472.0,
        weight_cost: 1310.0,
        delivery_total: 162.0,
        discounted_cost: 1443.0,
        label: "Bicicleta Electrica",
        packages_count: 12,
        packages_weight: 545.0,
      },
      App\Models\Order {#2576
        total: 18,
        estimated_weight: 37839.5,
        cost: 81886.5,
        weight_cost: 81722.5,
        delivery_total: 164.0,
        discounted_cost: 81815.9,
        label: "Volum mare",
        packages_count: 17,
        packages_weight: 12998.0,
      },
    ],
  }

Query export result:

[acabust0000]

discord thread: https://discord.com/channels/883083792112300104/1358024574834442452