File: /var/www/html/laravel/app/Console/Commands/UpdateHash.php
<?php
namespace App\Console\Commands;
use App\Models\Notam;
use Illuminate\Console\Command;
class UpdateHash extends Command
{
/**
* The name and signature of the console command.
*
* @var string
*/
protected $signature = 'notam:update-hash';
/**
* The console command description.
*
* @var string
*/
protected $description = 'Update hash for all notams';
/**
* Create a new command instance.
*
* @return void
*/
public function __construct()
{
parent::__construct();
}
/**
* Execute the console command.
*
* @return int
*/
public function handle()
{
$notams = Notam::query()->select('notams.*')
->get();
$countNotams = 0;
foreach ($notams as $notam) {
$input = $notam->input;
if (!$input) {
echo "Notam {$notam->id} has no input\n";
continue;
}
$data = json_decode($input);
if (!$data) {
echo "Notam {$notam->id} has invalid input\n";
continue;
}
if (property_exists($data, 'Text')) {
$notam->request_hash = Notam::hash($input);
$notam->save();
} else {
echo "Notam {$notam->id} has no Text property\n";
}
}
}
}