Laravel Excel导出空文件：基于条件筛选的数据导出实践与问题解决

// routes/web.php
Route::post('users/export/', 'App\Http\Controllers\Admin\ReportController@exportvehicles')->name('exportVehiclesToExcel');

<!-- resources/views/your_view.blade.php -->
<form action="{{ route('exportVehiclesToExcel') }}" method="POST">
    @csrf <!-- Laravel CSRF 保护 -->

    <div class="form-group">
        <label>选择员工:</label>
        <select name="smsstaff_key" id="smsstaff_key" class="form-control">
            <option value="">----------------请选择-----------------</option>
            @foreach ($staff as $staffMember)
                <option value="{{ $staffMember->smsstaff_key }}" {{ request()->input('smsstaff_key') === $staffMember->smsstaff_key ? 'selected="selected"' : '' }}>
                    {{ $staffMember->name }}
                </option>
            @endforeach
        </select>
        <!-- 如果需要筛选按钮，可以保留，但导出按钮必须在form内 -->
        <!-- <button class="btn btn-primary">按员工筛选</button> -->
    </div>

    <div class="form-group" style="margin-left: 100px;">
        <label>从:</label>
        <input type="date" class="form-control" name="startDate" value="{{ $startDate ?? '' }}">
    </div>
    <div class="form-group" style="margin-left: 150px;">
        <label>到:</label>
        <input style="width: 14em" type="date" class="form-control" name="endDate" value="{{ $endDate ?? '' }}">
    </div>

    <button type="submit" class="btn btn-primary">导出到Excel</button>
</form>

// app/Http/Controllers/Admin/ReportController.php
<?php

namespace App\Http\Controllers\Admin;

use App\Http\Controllers\Controller;
use Illuminate\Http\Request;
use Maatwebsite\Excel\Facades\Excel;
use App\Exports\ExportV; // 确保路径正确

class ReportController extends Controller
{
    public function exportvehicles(Request $request)
    {
        $startDate = $request->input('startDate');
        $endDate = $request->input('endDate');
        $smsStaffKey = $request->input('smsstaff_key');

        // 确保日期参数有效，或提供默认值
        if (empty($startDate)) {
            $startDate = '2021-01-01'; // 示例默认值
        }
        if (empty($endDate)) {
            $endDate = '2021-12-31'; // 示例默认值
        }

        return Excel::download(new ExportV($startDate, $endDate, $smsStaffKey), 'excelname.xlsx');
    }
}

// app/Exports/ExportV.php
<?php

namespace App\Exports;

use App\Models\VehicleLog; // 确保模型路径正确
use Maatwebsite\Excel\Concerns\FromQuery;
use Maatwebsite\Excel\Concerns\Exportable;

class ExportV implements FromQuery
{
    use Exportable;

    protected $startDate;
    protected $endDate;
    protected $smsStaffKey;

    public function __construct($startDate, $endDate, $smsStaffKey = null)
    {
        $this->startDate = $startDate;
        $this->endDate = $endDate;
        $this->smsStaffKey = $smsStaffKey;
    }

    public function query()
    {
        // 直接使用构造函数中存储的属性来构建查询
        $query = VehicleLog::join('vehicle', 'vehicleslog.vehicle_id', '=', 'vehicle.id')
            ->join('smsstaff', 'vehicleslog.smsstaff_key', '=', 'smsstaff.smsstaff_key')
            ->whereDate('log_dt', '>=', $this->startDate)
            ->whereDate('log_dt', '<=', $this->endDate);

        // 根据smsStaffKey是否存在应用筛选条件
        if ($this->smsStaffKey) {
            $query->where('smsstaff.smsstaff_key', $this->smsStaffKey);
        }

        // FromQuery 接口要求返回一个查询构建器实例，而不是集合
        return $query;
    }
}