<?php

namespace App\Console\Commands;

use Illuminate\Console\Command;
use App\Models\ProductPrice;
use GuzzleHttp\Client;
use Carbon\Carbon;

class UpdateOrvermountingsPrice extends Command
{
    /**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'update:overmountings-price';

    /**
     * The console command description.
     *
     * @var string
     */
    protected $description = 'For update overmountings price hit this command';

    /**
     * Create a new command instance.
     *
     * @return void
     */
    public function __construct()
    {
        parent::__construct();
    }
    /**
     * Execute the console command.
     *
     * @return int
     */
    public function handle()
    {
        // $priceData = ProductPrice::where('created_at', '<', Carbon::now()->subDays(3));
        // $priceData = ProductPrice::orderBy('id','ASC');
        // $priceData = ProductPrice::where('price','0');
        // $priceData = ProductPrice::WhereNull('price');
        $priceData = ProductPrice::where('status', 'true');
        $this->info("TOTAL COUNT IS = " . $priceData->count());
        $prices = $priceData->get();
        $count = 1;
        foreach ($prices as $price) {
            $id = $price['id'];
            $sku = $price['product_sku'];
            $url = 'http://www.overnightmountings.com/priceapi/service.php?action=pricecalculation&type=json';
            $url .= '&metaltype=' . urlencode($price['metalType']);
            $url .= '&metalcolor=' . urlencode($price['metalColor']);
            $url .= '&stylenumber=' . urlencode($price['product_sku']);
            $url .= '&quality=' . urlencode($price['diamondQuality']);
            $url .= '&level=' . urlencode($price['finishLevel']);
            $this->info(urldecode($url));

            $client = new Client();

            try {
                $response = $client->request('GET', $url);
                $price_data = json_decode($response->getBody(), true);
                if (!isset($price_data['errorMessage'])) {
                    $PriceUpdate = [
                        'reference_price' => round($price_data['price']),
                        'discount_percentage' => 0,
                        'price' => round($price_data['price']),
                    ];
                    // var_dump($PriceUpdate);
                    // exit;
                    $is_saved = ProductPrice::where('id', $id)->update($PriceUpdate);
                    $this->info($count . " = " . $sku  . " has been updated ");
                } else {

                    $PriceUpdate = [
                        'reference_price' => $price['reference_price'],
                        'discount_percentage' => 10,
                        'price' => $price['reference_price'],
                    ];

                    // var_dump($PriceUpdate);
                    // exit;
                    $is_saved = ProductPrice::where('id', $id)->update($PriceUpdate);
                    $this->info($count . " = " . $sku  . " has been updated ");
                }
                $count++;
            } catch (\Throwable $th) {
                $this->info($count . " = " . $sku  . "error occord for this sku" . $th);
                // dd($count . " = " . $sku  . "error occord for this sku" . $th);
            }
        }
    }
}