How to pass multiple variables?

[airliajsmith]

I need to pass a few variables to the Export. I have tried the example in the documentation, but I must be missing something.

The error I am getting is Undefined Variable: startDate.

Controller:
return (new TimecardExport())->startDate($lastPayPeriod->start)->download('timecards.xlsx');
Export File:
`
use Exportable;

private $startDate;

public function startDate(string $startDate)
{
    $this->startDate = $startDate;

    return $this;
}

public function query()
{
    return Employee::query()
        ->where('active', 1)
            ->where('salary', 0)
            ->with('punches', 'user')
            ->whereHas('punches', function (\Illuminate\Database\Eloquent\Builder $query) use ($startDate, $endDate) {
                return $query->where('date', '>=', $startDate)
                    ->where('date', '<=', $endDate);
            })
            ->get();
}`

[patrickbrouwers]

You'll have to use it as a class property instead of a variable: return $query->where('date', '>=', $this->startDate)

[airliajsmith]

I am now using your code, but have a different error: Illegal operator and value combination.

`
private $startDate;

public function startDate(string $startDate)
{
    $this->startDate = $startDate;

    return $this;
}

public function query()
{
    return Employee::query()
        ->where('active', 1)
        ->where('salary', 0)
        ->with('punches', 'user')
        ->whereHas('punches', function (\Illuminate\Database\Eloquent\Builder $query) {
            return $query->where('date', '>=', $this->startDate)
                ->where('date', '<=', '2022-02-16');
        })
        ->get();
}`

[airliajsmith]

Had to change to View, but get the same error.
`
private $startDate, $endDate;

public function startDate(string $startDate)
{
    $this->startDate = $startDate;

    return $this;
}

public function endDate(string $endDate)
{
    $this->endDate = $endDate;

    return $this;
}

public function view(): View
{
    return view('hr.punches.export.last-period', [
        'punches' => Employee::query()
            ->where('active', 1)
            ->where('salary', 0)
            ->with('punches', 'user')
            ->whereHas('punches', function (\Illuminate\Database\Eloquent\Builder $query) {
                return $query->where('date', '>=', $this->startDate)
                    ->where('date', '<=', $this->endDate);
            })
            ->get()
    ]);
}

`

[patrickbrouwers]

I believe Illegal operator and value combination is an Eloquent builder exception, I'd recommend asking for help on Laracasts/Stackoverflow for that issue as it's unrelated to this package.

[airliajsmith]

Yes, after messing with it a bit, that is related to my query. Thanks.