| Server IP : 78.140.185.180 / Your IP : 3.19.75.212 Web Server : LiteSpeed System : Linux cpanel13.v.fozzy.com 4.18.0-513.11.1.lve.el8.x86_64 #1 SMP Thu Jan 18 16:21:02 UTC 2024 x86_64 User : builderbox ( 1072) PHP Version : 7.3.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/builderbox/www/common/Csv/ |
Upload File : |
<?php
namespace Common\Csv;
use Carbon\Carbon;
use Illuminate\Console\Command;
use Illuminate\Support\Collection;
use Storage;
class DeleteExpiredCsvExports extends Command
{
/**
* The name and signature of the console command.
*
* @var string
*/
protected $signature = 'csvExports:delete';
/**
* The console command description.
*
* @var string
*/
protected $description = 'Deleted csv exports that are expired.';
/**
* Create a new command instance.
*
* @return void
*/
public function __construct()
{
parent::__construct();
}
/**
* Execute the console command.
*
* @return int
*/
public function handle()
{
CsvExport::where(
'created_at',
'<',
Carbon::now()->addDays(-1),
)->chunkById(10, function (Collection $chunk) {
CsvExport::whereIn('id', $chunk->pluck('id'))->delete();
$filePaths = $chunk->map(function(CsvExport $export) {
return $export->filePath();
});
Storage::delete($filePaths);
});
return 0;
}
}