PHP code example of wesleydeveloper / data-processor
1. Go to this page and download the library: Download wesleydeveloper/data-processor library. Choose the download type require.
2. Extract the ZIP file and open the index.php.
3. Add this code to the index.php.
<?php
require_once('vendor/autoload.php');
/* Start to develop here. Best regards https://php-download.com/ */
wesleydeveloper / data-processor example snippets
namespace App\Imports;
use Wesleydeveloper\DataProcessor\Contracts\Importable;
use Wesleydeveloper\DataProcessor\Contracts\ShouldQueue;
use Wesleydeveloper\DataProcessor\Contracts\WithChunking;
use Illuminate\Support\Facades\DB;
class UsersImport implements Importable, ShouldQueue, WithChunking
{
public function rules(): array
{
return [
'name' => 'unction process(array $data): void
{
DB::table('users')->insert($data);
}
public function chunkSize(): int
{
return 1000;
}
// Queue configuration
public function onQueue(): ?string
{
return 'imports';
}
public function timeout(): int
{
return 300;
}
public function memory(): int
{
return 512;
}
// Chunking configuration
public function maxFileSize(): int
{
return 50 * 1024 * 1024; // 50MB
}
public function chunkRows(): int
{
return 10000;
}
}
use Wesleydeveloper\DataProcessor\Facades\DataProcessor;
use App\Imports\UsersImport;
DataProcessor::import(new UsersImport(), 'users-import.xlsx');
namespace App\Exports;
use Wesleydeveloper\DataProcessor\Contracts\Exportable;
use App\Models\User;
use Generator;
class UsersExport implements Exportable
{
public function query(): Generator
{
User::chunk(1000, function ($users) {
foreach ($users as $user) {
yield $user;
}
});
}
public function headings(): array
{
return ['ID', 'Name', 'Email', 'Created At'];
}
public function map($user): array
{
return [
$user->id,
$user->name,
$user->email,
$user->created_at->format('Y-m-d H:i:s')
];
}
public function chunkSize(): int
{
return 1000;
}
}
use Wesleydeveloper\DataProcessor\Facades\DataProcessor;
use App\Exports\UsersExport;
DataProcessor::export(new UsersExport(), 'users-export.xlsx');
Loading please wait ...
Before you can download the PHP files, the dependencies should be resolved. This can take some minutes. Please be patient.