TestLocallySyncVariants.php

<?php

namespace App\Console\Commands;

use App\Models\LocallyProduct;
use Illuminate\Console\Command;

class TestLocallySyncVariants extends Command
{
    /**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'test-locally-sync-variants';

    /**
     * The console command description.
     *
     * @var string
     */
    protected $description = 'Command description';

    /**
     * Create a new command instance.
     *
     * @return void
     */
    public function __construct()
    {
        parent::__construct();
    }

    /**
     * Execute the console command.
     *
     * @return int
     */
    public function handle()
    {
        $results = (object) [
            'matches' => 0,
            'no_matches' => 0,
        ];

        $allLocallyProducts = LocallyProduct::where('product_id', '!=', '')->get();

        $locallyProductGroups = $allLocallyProducts->groupBy('handle');

        foreach ($locallyProductGroups as $handle => $locallyProducts) {
            $product = $locallyProducts->first()->product;

            $variantSkus = $product->variants->pluck('sku')->toArray();
            $barcodes = $locallyProducts->pluck('barcode')->toArray();

            if (array_values_match($variantSkus, $barcodes)) {
                $this->info('Product #' . $product->id . ' matches');
                $results->matches++;
            } else {
                $this->warn('Product #' . $product->id . ' no match');
                $results->no_matches++;

                $this->line('Locally barcodes');
                dump($barcodes);
                $this->line('Variant SKUs:');
                dump($variantSkus);
                $this->line('');
            }
        }

        $this->line('');
        $this->info('Results:');
        dump($results);

        return 0;
    }
}