Ladybirdweb\ImportExport\Jobs\ExportJob

Complexity

Total Complexity

3

Size/Duplication

Total Lines	66
Duplicated Lines	0 %

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	handle()	0	43	2
A	__construct()	0	3	1

<?php

namespace Ladybirdweb\ImportExport\Jobs;

use Illuminate\Bus\Queueable;
use Illuminate\Contracts\Queue\ShouldQueue;
use Illuminate\Foundation\Bus\Dispatchable;
use Illuminate\Queue\SerializesModels;
use Illuminate\Queue\InteractsWithQueue;
use Carbon\Carbon;
use Ladybirdweb\ImportExport\Models\Export;
use Maatwebsite\Excel\Facades\Excel;

class ExportJob implements ShouldQueue
{
    use Dispatchable, InteractsWithQueue, Queueable, SerializesModels;

The trait Illuminate\Queue\SerializesModels requires some properties which are not provided by Ladybirdweb\ImportExport\Jobs\ExportJob: $id, $class, $relations

    public $tries = 1;

    protected $export;

    /**
     * Create a new job instance.
     *
     * @return void
     */
    public function __construct(Export $export)
    {
        $this->export = $export;
    }

    /**
     * Execute the job.
     *
     * @return void
     */
    public function handle()
    {
        // Custom file path
        $file_path = date( 'Y/m' );

        // Export instance assign to variable
        $export = $this->export;

        // Store total row count
        $export->result_rows = $export->query->count();
        $export->save();

        // Create export file
        $excel = Excel::create( 'export-' . date( 'dmYhis' ), function($excel) use ($export) {

            // Create new sheet
            $excel->sheet( 'export', function($sheet) use ($export) {

                // Retrive data in chunk
                $export->query->chunk( 10, function($data) use ($export, $sheet) {

                    // Process chunk data
                    foreach ( $data as $row ) {
                        
                        // Append row to sheet
                        $sheet->appendRow( $row->toArray() );

                    }

                    // Store processed row count
                    $export->row_processed += 10;
                    $export->save();

                } );

            });

        })->store( $this->export->type, storage_path( 'app/exports/' . $file_path ), true );

        // Update export data
        $export->file = $file_path . '/' . $excel['file'];
        $export->completed_at = Carbon::now();
        $export->save();

    }
}