如何在Laravel中导出日期范围的Excel数据？

php artisan make:export DateRangeExport

use App\Models\YourModel;

public function collection()
{
    $startDate = request('start_date');
    $endDate = request('end_date');

    return YourModel::whereBetween('date_column', [$startDate, $endDate])->get();
}

use Maatwebsite\Excel\Concerns\WithHeadings;
use Maatwebsite\Excel\Concerns\WithMapping;

class DateRangeExport implements FromCollection, WithHeadings, WithMapping
{
    // ...

    public function headings(): array
    {
        return [
            'Column 1 Header',
            'Column 2 Header',
            // ...
        ];
    }

    public function map($row): array
    {
        return [
            $row->column1,
            $row->column2,
            // ...
        ];
    }
}

use App\Exports\DateRangeExport;
use Maatwebsite\Excel\Facades\Excel;

public function export()
{
    $startDate = request('start_date');
    $endDate = request('end_date');

    return Excel::download(new DateRangeExport($startDate, $endDate), 'data.xlsx');
}