[Bug]:

[palashcn]

Is the bug applicable and reproducable to the latest version of the package and hasn't it been reported before?

• Yes, it's still reproducable

What version of Laravel Excel are you using?

3.1

What version of Laravel are you using?

9.x

What version of PHP are you using?

8.1

Describe your issue

Hi

We have a large data which we want to export it to excel,
we use FromQuery, ShouldQueue, WithHeadings, WithCustomQuerySize, WithMapping
now in config we set chunksize 1000
now whenever we export with queue we got 1k line of records
if we set chunksize 500 then with queue export 500 line of records

How can the issue be reproduced?

issue with queue with chunk record

What should be the expected behaviour?

we should get at least 14k records

[patrickbrouwers]

Sounds like you are not using the WithCustomQuerySize correct, but as you didn't share any code I cannot tell you why it's not working for you.

[palashcn]

Hi
Thanks for your response
pls check my below code:

`<?php

namespace App\Exports;

use Maatwebsite\Excel\Concerns\FromArray;
use Maatwebsite\Excel\Concerns\WithHeadings;
use Illuminate\Contracts\Queue\ShouldQueue;
use Illuminate\Bus\Queueable;
use Illuminate\Database\Connection;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Queue\InteractsWithQueue;
use Illuminate\Queue\SerializesModels;
use Maatwebsite\Excel\Concerns\Exportable;
use Maatwebsite\Excel\Concerns\FromQuery;
use Maatwebsite\Excel\Concerns\WithCustomQuerySize;
use Maatwebsite\Excel\Concerns\WithMapping;
use Maatwebsite\Excel\Concerns\ShouldAutoSize;
use Carbon\Carbon;
use App\Models\Event;
use App\Models\SessionFormTemplate;
use App\Models\SessionNoteHelper;
use Maatwebsite\Excel\Concerns\FromCollection;

class SessionExport implements FromQuery, ShouldQueue, WithHeadings, WithCustomQuerySize, WithMapping
{
use Queueable, Exportable, InteractsWithQueue;
private $input = [];
//private $sessions;
public function __construct(array $input=[])
{
$this->input = $input;
}

public function query()
{
    $inputDate = $this->input['dateRange'];
    $startDate = Carbon::parse($inputDate[0])->format('Y-m-d');
    $endDate = Carbon::parse($inputDate[1])->format('Y-m-d');

     

    $eventTable = (new Event)->getTable();
    $sessionTable = (new SessionFormTemplate)->getTable();
    $sessionNoteHelperTable = (new SessionNoteHelper)->getTable();

    return Event::query()->with(['services' => function ($q) {
        $q->select('id','name');
    },
        'student.studentAuthorization' => function ($q) {
            $q->with(['serviceLine' => function ($p) {
                $p->select('id','name');
            },
                'studentAuthorizationService' => function ($q) {
                    $q->whereHas('sessionFormTemplate')
                      ->with(['agency' => function ($q) {
                        $q->select('id','name');
                      }
                  ]);
                },
            ]);
            
        }, 'user' => function ($q){
            $q->select('id','name');
        }
    ])->select([$eventTable.'.id',
              $eventTable.'.parentId',
              $eventTable.'.type',
              $eventTable.'.startDate',
              $eventTable.'.endDate',
              $eventTable.'.startTime',
              $eventTable.'.endTime',
              $eventTable.'.userId',
              $eventTable.'.studentId',
              $eventTable.'.appointmentDays',
              $eventTable.'.locationId',
              $eventTable.'.created_at',
              $eventTable.'.serviceId', \DB::raw('COUNT('.$sessionTable.'.id) as session_count'), $sessionTable.'.signature_status as staff_verify','location'])
    ->leftJoin($sessionTable, function ($join) use ($eventTable, $sessionTable) {
      $join->on($eventTable.'.id', '=', $sessionTable.'.eventId');
    })->whereBetween($eventTable.'.appointmentDays', [$startDate, $endDate])->groupBy($eventTable.'.id')->orderBy($eventTable.'.id', 'desc')->groupBy($eventTable.'.id')->orderBy($eventTable.'.id', 'desc'); 

}

public function querySize(): int
{ 
    $inputDate = $this->input['dateRange'];
    $startDate = Carbon::parse($inputDate[0])->format('Y-m-d');
    $endDate = Carbon::parse($inputDate[1])->format('Y-m-d');

     

    $eventTable = (new Event)->getTable();
    $sessionTable = (new SessionFormTemplate)->getTable();
    $sessionNoteHelperTable = (new SessionNoteHelper)->getTable();

    $size =  Event::query()->with(['services' => function ($q) {
        $q->select('id','name');
    },
        'student.studentAuthorization' => function ($q) {
            $q->with(['serviceLine' => function ($p) {
                $p->select('id','name');
            },
                'studentAuthorizationService' => function ($q) {
                    $q->whereHas('sessionFormTemplate')
                      ->with(['agency' => function ($q) {
                        $q->select('id','name');
                      }
                  ]);
                },
            ]);
            
        }, 'user' => function ($q){
            $q->select('id','name');
        }
    ])->select([$eventTable.'.id',
              $eventTable.'.parentId',
              $eventTable.'.type',
              $eventTable.'.startDate',
              $eventTable.'.endDate',
              $eventTable.'.startTime',
              $eventTable.'.endTime',
              $eventTable.'.userId',
              $eventTable.'.studentId',
              $eventTable.'.appointmentDays',
              $eventTable.'.locationId',
              $eventTable.'.created_at',
              $eventTable.'.serviceId', \DB::raw('COUNT('.$sessionTable.'.id) as session_count'), $sessionTable.'.signature_status as staff_verify','location'])
    ->leftJoin($sessionTable, function ($join) use ($eventTable, $sessionTable) {
      $join->on($eventTable.'.id', '=', $sessionTable.'.eventId');
    })->whereBetween($eventTable.'.appointmentDays', [$startDate, $endDate])
    ->groupBy($eventTable.'.id')->orderBy($eventTable.'.id', 'desc')->count();
    return $size;
}


public function headings(): array
{
    return [
        'Service Line',
        'Service',
        'Place of Service',
        'Duration(Hours)',
        'Day',
        'Month of Session',
        'Date',
        'Client',
        'Staff Member',
        'Session Note',
        'Staff Verification',
        'Guardian/Principal Verification',
        'Group Size',
        'Session Time In',
        'Session Time Out',
        'Session Data',
        'Session Notes',
        'Billed?',
        'Session Entered Day And Time',
        'Agency Name (Client\'s Authorization)',
        'Name of Person Entering the Session',
        'Amount of Money for Payroll',
        'Payroll Date',
        'Session Picture',
        'Teacher Mandate',
        'Template Code',
    ];
}



public function map($sessions): array
{
    //dd(collect($sessions));
    return [
        $sessions->student->studentAuthorization[0]->serviceLine->name ?? '',
        $sessions->services->name ?? '',
        $sessions->location->name ?? '',
        $sessions->duration,
        date('l', strtotime($sessions->startDate)),
        date('M', strtotime($sessions->startDate)),
        date('m/d/Y', strtotime($sessions->startDate)),
        $sessions->student->name ?? '',
         $sessions->user->name ?? '',
         ($sessions->session_count > 0) ? 'Yes' : 'No',
        '',
        ($sessions->staff_verify > 0) ? 'Verified' : 'Need Verification',
         count(explode(',', $sessions->groupStudentIds)),
        explode('-', $sessions->fulltime)[0],
        explode('-', $sessions->fulltime)[1],
        (count($sessions->notehelpers_data) > 0) ? 'Yes' : 'No',
        ($sessions->session_count > 0) ? 'Yes' : 'No',
        $sessions->isPaid? 'Yes':'No',
        date('m/d/Y h:i:s', strtotime($sessions->created_at)),
        $sessions->student->studentAuthorization[0]->studentAuthorizationService[0]->agency->name ?? '',
        $sessions->sessiontemplate->createdBy_user->name ?? '',
         $sessions->staffPayCode? '$'.$sessions->staffPayCode->price*$sessions->duration:'',
        $sessions->staffChecksData? $sessions->staffChecksData->check_date:'',
         '',
        '',
        $sessions->sessiontemplate->template_details->hcode
    ];
}

public function failed(\Throwable $exception): void
{
    throw $exception;
}

}
`

[patrickbrouwers]

Please try to provide an easy to reproduce scenario, I don't have the time to parse through all your application specific logic