Laravel? ???, ?? ???? ?? ??? ?? ? ??????? ???? ? ?? ??? ??? ???? ?? ?? PHP ? ?????? ????????. ??? ?? ? ??? ??? ?? ?? ?? ??? ??? ? ?? ???????. ?? ???? ????? ???? ???? Excel ??? ???? ??? ?? ?????.

1. Creating Laravel ??????

?? Laravel ??????? ???? ???. ??? ?? ???? ???? ??? Laravel ????? ??? ? ????:

$ composer create-project --prefer-dist laravel/laravel myapp

??? ?? myapp??? Laravel ????? ?????.

2. ???? ???

Laravel?? ????? HTTP ??? ???? ?? ?? ?????. ??? ???? ??? ??? ????? ???? ???. ?? ??? ???? ????? ?????:

$ php artisan make:controller ExportController

??? ?? ImportController?? ? ????? ?????. ??????? ???? ??? ???? ???? ???? ???. ? ???? ????() ???? ???? ???? ??? ?????.

3. Create Middleware

Laravel ????? HTTP ?? ?? ?? ??? ??? ? ????. ???? ??? ???? ??? ???? ?? ???? ???? ??? ???? ?? ImportMiddleware?? ????? ????.

?? ??? ???? ????? ?????.

$ php artisan make:middleware ExportMiddleware

??? ?? ImportMiddleware?? ? ????? ?????. ?????? ???? ??? ????? ??() ???? ???? ???. ? ???? ??? ???? ???? ??? ????, ???? ???? ???? ??? ? Laravel Excel ?????? ???? Excel ??? ?????.

4. Laravel Excel ?? ? ??

Laravel Excel? Excel ??? ???? ??? ??? ??? ???? ?? ?? ?? Laravel ?? ??????. ?? ??? ???? Laravel Excel? ??? ? ????:

$ composer require maatwebsite/excel

??? ???? Laravel Excel? ?? ??? ???? ??? ???? ???. config/app.php ??? ?? ??? ??? ?? ??? ?????.

MaatwebsiteExcelExcelServiceProvider::class,

?? ??? ?? ??? ?????.

'Excel' => MaatwebsiteExcelFacadesExcel::class,

5. ???? ?? ??

?? ????? ??? ??? ?????. ??. ImportMiddleware??? ?? ??? ???? ???? ??? ???? Excel ??? ?????.

use Excel;

public function handle($request, Closure $next)
{
    if (!$request->has('data')) {
        return response()->json([
            'message' => 'No data to export'
        ], 400);
    }

    $data = $request->get('data');

    return Excel::download(new ExportData($data), 'data.xlsx');
}

????? Excel::download() ???? ???? ???? Excel ??? ?????. ? ???? ??? ???? ???? ?? ????? ? ?? ?? ??? ?????. ??? ???? ???? FromCollection ?????? ???? ????? ??? ???? Excel ??? ???? ? ?????.

? ???? ??? ????? ???? ?? ImportData?? ??? ???? ???? ??????. ??? ImportData ???? ??? ????.

use MaatwebsiteExcelConcernsFromCollection;

class ExportData implements FromCollection
{
    protected $data;

    public function __construct($data)
    {
        $this->data = $data;
    }

    public function collection()
    {
        return collect($this->data);
    }
}

? ?????? FromCollection ?????? ???? ??? ???? Excel ??? ?????. collection() ???? Laravel Excel?? Excel ??? ??? ??? ???? ?????.

6. ???? ??

?? Laravel ??????? ????? ???? ???. app/Http/Kernel.php ??? ?? $routeMiddleware ??? ?? ??? ?????:

'export' => AppHttpMiddlewareExportMiddleware::class,

7. ?? ???

????? ???? ??? ??? ??? ???? ???. ??/web.php ??? ?? ?? ??? ?????.

Route::get('export', 'ExportController@export')->middleware('export');

? ????? ?????? GET ??? ???? ?? ???? ????? ????() ???? ??????. ?? ??? ????? ???? ?? ???? ????? ????? ???? ????? ? ??? ?????.

8. ???

?? ??? ?? ??? ??????. ?? URL? ???? ???? ??? ???? ? ????.

http://localhost:8000/export?data=[{"id":1,"name":"John"},{"id":2,"name":"Jane"}]

??? ???? data.xlsx?? Excel ??? ?? ???.

?? ?? ?:

ExportMiddleware.php

<?php

namespace AppHttpMiddleware;

use Closure;
use Excel;

use MaatwebsiteExcelConcernsFromCollection;

class ExportMiddleware
{
    public function handle($request, Closure $next)
    {
        if (!$request->has('data')) {
            return response()->json([
                'message' => 'No data to export'
            ], 400);
        }

        $data = $request->get('data');

        return Excel::download(new ExportData($data), 'data.xlsx');
    }
}

class ExportData implements FromCollection
{
    protected $data;

    public function __construct($data)
    {
        $this->data = $data;
    }

    public function collection()
    {
        return collect($this->data);
    }
}

ExportController.php

<?php

namespace AppHttpControllers;

class ExportController extends Controller
{
    public function export()
    {
        return response()->json([
            'message' => 'Export completed successfully'
        ]);
    }
}

routes/web.php

Route::get('export', 'ExportController@export')->middleware('export');

app/Http/Kernel.php

protected $routeMiddleware = [
    ...
    'export' => AppHttpMiddlewareExportMiddleware::class,
];

Summary

? ???? ??? Laravel? ???? ??? ?????. ????? ???? Excel ??? ?????. Laravel Excel ?????? ???? ???? Excel ??? ???? ?? ImportMiddleware?? ??? ????? ??? ? ????? Laravel ??????? ??????. ????? ???? ??? ????? ??? Excel ??? ??????. ? ?? Laravel? ???? ???? ???? ? ??? ??? ????.

? ??? Laravel?? ??? ????? ?? ????? ???? ??? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!