Hướng dẫn sao lưu dữ liệu hàng ngày với Laravel Excel

composer require maatwebsite/excel:^3.1

php artisan make:export AccountExport

<?php

namespace App\Exports;

use App\Models\Account;
use Illuminate\Support\Collection;
use Maatwebsite\Excel\Concerns\Exportable;
use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\WithHeadings;
use Maatwebsite\Excel\Concerns\ShouldAutoSize;
use Maatwebsite\Excel\Concerns\WithMapping;

class AccountExport implements FromCollection, WithHeadings, ShouldAutoSize, WithMapping
{
    use Exportable;
    private $stt;

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

    public function collection(): Collection
    {
        return Account::query()->select([
            'name',
            'name_org',
            'phone_number',
            'email',
            'class',
            'status',
            'created_at'
        ])->where('deleted_at', null)->get();
    }

    public function headings(): array
    {
        return [
            'STT',
            'Tên',
            'Tên tổ chức',
            'Số điện thoại',
            'Email',
            'Lớp',
            'Trạng thái',
            'Tạo ngày'
        ];
    }

    public function map($row): array
    {
        return [
            $this->stt++,
            $row->name,
            $row->name_org,
            $row->phone_number,
            $row->email,
            $row->class,
            $row->status == 1 ? 'Hoạt động' : 'Khóa',
            $row->created_at->format('d/m/Y H:i')
        ];
    }
}

Schema::create('account_backups', function (Blueprint $table) {
    $table->id();
    $table->string('file_name');
    $table->timestamps();
});

php artisan make:job BackupAccountDataJob

public function handle()
{
    $folder = 'backup/';
    $name = 'account-' . now()->format('Y-m-d') . '.csv';
    $path = $folder . $name;

    Excel::store(new AccountExport(), $path, 'public', \Maatwebsite\Excel\Excel::CSV);

    $backupFile = new AccountBackup();
    $backupFile->fill([
        'file_name' => $name
    ]);
    $backupFile->save();
}

php artisan make:command BackupAccountDataCommand

class BackupAccountDataCommand extends Command
{
    protected $signature = 'account:backup';
    protected $description = 'Backup account data';

    public function handle()
    {
        BackupAccountDataJob::dispatch();
    }
}

$schedule->command('account:backup')->daily();

* * * * * php /path/to/your/project/artisan schedule:run

Route::group(['namespace' => 'App\Http\Controllers', 'prefix' => 'account-backup'], function () {
    Route::get('/', 'AccountBackupController@index')->name('account_backup');
    Route::get('/download/{id}', 'AccountBackupController@download')->name('account_backup.download');
});

class AccountBackupController extends Controller
{
    public function index()
    {
        $files = AccountBackup::orderBy('created_at', 'desc')->paginate(15);
        return view('account_backup.index', compact('files'));
    }

    public function download($id)
    {
        $file = AccountBackup::find($id);
        if (!$file) {
            return redirect()->route('account_backup')->with('warning', 'File không tìm thấy.');
        }

        return response()->download(storage_path('app/public/backup/' . $file->file_name));
    }
}