<?php

if( php_sapi_name() !== 'cli' ) {
    die("Meant to be run from command line");
}

if (!empty($argv[1])) {
    define('APPLICATION_ENV', $argv[1]);
} else {
    define('APPLICATION_ENV', 'production');
}

define( 'BASE_PATH', './public/' );
define('WP_USE_THEMES', false);

global $wpdb;
require(BASE_PATH . 'wp-load.php');
require(BASE_PATH . 'wp-content/plugins/import/class/Product.php');

$uploads_path = 'wp-content/uploads/images/maxon/';
$uploads_dir = BASE_PATH . $uploads_path;

$images_mapping = [
    '205679' => 'Produktbild-205679-Detail.jpg',
    '166143' => 'Produktbild-166143-Detail.jpg',
    '403112' => 'Produktbild-403112-Detail.jpg',
    '145391' => 'Produktbild-145391-Detail.jpg',
    '230572' => 'Produktbild-230572-Detail.jpg',
    '466023' => 'Produktbild-466023-Detail.jpg',
    '378308' => 'Produktbild-378308-Detail.jpg',
    '534130' => 'Produktbild-534130-Detail.jpg',
    '249631' => 'Produktbild-249631-Detail.jpg',
    '249632' => 'Produktbild-249632-Detail.jpg',
    '367661' => 'Produktbild-367661-Detail.jpg',
    '409510' => 'Produktbild-409510-Detail.jpg',
    '520885' => 'Produktbild-520885-Detail.jpg',
    '447293' => 'Produktbild-447293-Detail.jpg',
    '504384' => 'Produktbild-504384-Detail.jpg',
    '504383' => 'Produktbild-504383-Detail.jpg',
    '594385' => 'Produktbild-594385-Detail.jpg',
    '536630' => 'Produktbild-536630-Detail.jpg',
    '628092' => 'Produktbild-628092-Detail.jpg',
    '628094' => 'Produktbild-628094-Detail.jpg',
    '546714' => 'Produktbild-546714-Detail.jpg',
    '541718' => 'Produktbild-541718-Detail.jpg',
    '532872' => 'Produktbild-532872-Detail.jpg',
    '586137' => 'Produktbild-586137-Detail.jpg',
    '520886' => 'Produktbild-520886-Detail.jpg',
    '546047' => 'Produktbild-546047-Detail.jpg',
];

foreach ($images_mapping as $sku => $image) {

    $image_dir  = $uploads_dir . $image;
    $image_path = '/' . $uploads_path . $image;

    if(!file_exists($image_dir)) continue;

    $product = Product::getBySku($sku);

    if($product) {
        Product::saveMeta($product->id, [
            'Thumbnail URL' => $image_path,
            'Picture URL' => $image_path
        ]);

        echo 'Image "' . $image . '" is assigned to product with ID "' . $product->id . '"' . PHP_EOL;
    }

}

echo 'DONE' . PHP_EOL . PHP_EOL;