Laravel Blade Excel导入导出页面开发及语法错误排查求助

Let's tackle your syntax error first, then build out the full import/export functionality for your customer Blade page.

The Root Cause of Your Syntax Error #

The error occurs because you opened an @if directive (@if(Session::has('success'))) but never closed it with @endif. Blade requires all conditional directives to be properly closed, otherwise it throws that "unexpected end of file" error.

Complete & Fixed Blade Template Code #

Here's the full, working version of customers_blade.php with proper syntax, import form, export button, and session message handling:

@extends('layouts.app')

@section('content')
<div class="container">
    <div class="panel panel-default">
        <div class="panel-heading">Import and Export Customer Data (Excel)</div>
        <div class="panel-body">
            <!-- Success Message -->
            @if(Session::has('success'))
                <div class="alert alert-success alert-dismissible fade in" role="alert">
                    <button type="button" class="close" data-dismiss="alert" aria-label="Close">
                        <span aria-hidden="true">&times;</span>
                    </button>
                    {{ Session::get('success') }}
                </div>
            @endif

            <!-- Error Message -->
            @if(Session::has('error'))
                <div class="alert alert-danger alert-dismissible fade in" role="alert">
                    <button type="button" class="close" data-dismiss="alert" aria-label="Close">
                        <span aria-hidden="true">&times;</span>
                    </button>
                    {{ Session::get('error') }}
                </div>
            @endif

            <!-- Import Form -->
            {!! Form::open(['route' => 'customer.import', 'method' => 'POST', 'files' => true, 'class' => 'form-horizontal']) !!}
                <div class="form-group{{ $errors->has('file') ? ' has-error' : '' }}">
                    <label for="file" class="col-md-4 control-label">Upload Excel File</label>
                    <div class="col-md-6">
                        {!! Form::file('file', ['class' => 'form-control']) !!}
                        @if ($errors->has('file'))
                            <span class="help-block">
                                <strong>{{ $errors->first('file') }}</strong>
                            </span>
                        @endif
                    </div>
                </div>

                <div class="form-group">
                    <div class="col-md-6 col-md-offset-4">
                        <button type="submit" class="btn btn-primary">
                            Import Customers
                        </button>
                    </div>
                </div>
            {!! Form::close() !!}

            <!-- Export Button -->
            <div class="row">
                <div class="col-md-6 col-md-offset-4">
                    <a href="{{ route('customer.export') }}" class="btn btn-success">
                        Export All Customers to Excel
                    </a>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection

Key Improvements & Notes #

1. Fixed Syntax: All @if directives are now properly closed with @endif to resolve the syntax error.
2. Message Handling: Added dismissible success and error alerts to give users clear feedback on import/export status.
3. Form Validation: Included error handling for the file input field to validate file types and show validation messages.
4. Export Functionality: Added a dedicated export button that links to your customer.export route for one-click exports.
5. Bootstrap Styling: Used Bootstrap classes to match typical Laravel app layouts and ensure a clean, responsive design.

Required Backend Setup (Critical!) #

To make this page fully functional, you'll need to set up the corresponding routes, controller methods, and use an Excel package like Maatwebsite/Laravel-Excel (the standard choice for Laravel Excel operations):

1. Install Laravel Excel

composer require maatwebsite/excel

2. Define Routes (in routes/web.php)

use App\Http\Controllers\CustomerController;

Route::post('/customers/import', [CustomerController::class, 'import'])->name('customer.import');
Route::get('/customers/export', [CustomerController::class, 'export'])->name('customer.export');

3. Controller Methods (in CustomerController.php)

use Maatwebsite\Excel\Facades\Excel;
use App\Imports\CustomersImport;
use App\Exports\CustomersExport;
use Illuminate\Http\Request;

// Handle Excel import
public function import(Request $request)
{
    $request->validate([
        'file' => 'required|mimes:xlsx,xls',
    ]);

    try {
        Excel::import(new CustomersImport, $request->file('file'));
        return back()->with('success', 'Customers imported successfully!');
    } catch (\Exception $e) {
        return back()->with('error', 'Import failed: ' . $e->getMessage());
    }
}

// Handle Excel export
public function export()
{
    return Excel::download(new CustomersExport, 'customers_' . date('Y-m-d') . '.xlsx');
}

4. Create Import/Export Classes

Generate the required classes with Artisan, then customize them to match your Customer model's fields:

php artisan make:import CustomersImport --model=Customer
php artisan make:export CustomersExport --model=Customer

内容的提问来源于stack exchange，提问作者Cugurel