<?php

namespace App\Http\Controllers\Admin;

use App\Http\Controllers\Controller;
use App\Http\Requests\GoodsRequest;
use App\Models\Good;
use App\Models\Images;
use App\Models\Manufacturer;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Session;
use Illuminate\Support\Facades\Storage;
use Illuminate\Support\Facades\Validator;
use App\Classes\SimpleXLS;
use PhpOffice\PhpSpreadsheet\IOFactory;

class GoodController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        $goods = Good::query()->orderBy('id')->paginate(5);
        return view('admin.goods.index', compact('goods'));

    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        return view('admin.goods.create');
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(GoodsRequest $request)
    {
        $params = $request->all();

        if ($request->has('image')) {
            $params['image'] = $request->file('image')->store('goods', 'public');
        }

        Good::create($params);
        return redirect()->route('admin.goods.index');
    }

    /**
     * Display the specified resource.
     *
     * @param  \App\Models\Good  $good
     * @return \Illuminate\Http\Response
     */
    public function show(Good $good)
    {
        //
    }

    /**
     * Show the form for editing the specified resource.
     *
     * @param  \App\Models\Good  $good
     * @return \Illuminate\Http\Response
     */
    public function edit(Good $good)
    {
        return view('admin.goods.edit', compact('good'));
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  \App\Models\Good  $good
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, Good $good)
    {
        $params = $request->all();

        if ($request->has('image')) {
            if (!empty($good->image)) Storage::delete($good->image);
            $params['image'] = $request->file('image')->store('goods', 'public');
        } else {
            if (!empty($good->image)) $params['image'] = $good->image;
        }

        $good->update($params);
        return redirect()->route('admin.goods.index');
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  \App\Models\Good  $good
     * @return \Illuminate\Http\Response
     */
    public function destroy(Good $good)
    {
        if (!empty($good->image)) {
            Storage::delete($good->image);
        }
        $good->delete();
        return redirect()->route('admin.goods.index');
    }

    public function images_good(Good $good) {
       return view('admin.goods.add_image', compact('good'));
    }

    public function good_add_img(Good $good, Request $request) {
        $rules = [
            'image' => 'required|min:3',
        ];
        $messages = [
            'required' => 'Укажите картинку!',
        ];
        $validator = Validator::make($request->all(), $rules, $messages);

        if ($validator->fails()) {
            return redirect()->route('admin.img.good', ['good' => $good->id])
                ->withErrors($validator);
        } else {
            $images = new Images();
            $images->good_id = $good->id;
            $images->image =  $request->file('image')->store('goods', 'public');
            $images->sample = $request->sample;
            $images->save();

            return  redirect()->route('admin.goods.edit', ['good' => $good->id]);
        }
    }

    public function good_del_img($id, Good $good) {
        if (!empty($id)) {
            $id = (int)$id;
            $item = Images::find($id);
            Storage::delete($item->image);
            $item->delete();
            Session::flash('message','Картинка была успешно удалена!');

            return  redirect()->route('admin.goods.edit', ['good' => $good->id]);

        } else {
            return  redirect()->route('admin.goods.edit', ['good' => $good->id]);
        }
    }

    public function convert_ajax() {
        return view('admin.goods.ajax');
    }

    public function convert_xlsx(Request $request){
        //$filepath = public_path('excel\iblock_element_admin.xls');

        //echo '<pre>';
        $code = $request->category;
        $reader = IOFactory::createReader('Xlsx');
        $spreadsheet = $reader->load('1.xlsx');
        // Только чтение данных
        $reader->setReadDataOnly(true);

        // Количество листов
        $sheetsCount = $spreadsheet->getSheetCount();
        // Данные в виде массива
        $data = $spreadsheet->getActiveSheet()->toArray();
        $i = 0;
        $name_item = 0;
        $image_item = 2;
        $stock_item = 7;
        $power_item = 9;
        $price_item = 13;
        $weight_item = 14;
        $demo_item = 8;
        $manufacturer_item = 12;

        $current = 0;
        $progress = 0;
        $all = count($data);

        foreach ($data as $k => $item):
            //print_r($item);
            if ($i == 0) {
               if ($item[$k] == 'Название') $name_item = $k;
                if ($item[$k] == 'Картинка для анонса') $image_item = $k;
                if ($item[$k] == 'Мощность, кВт ') $power_item = $k;
                if ($item[$k] == 'Наличие') $stock_item = $k;
                if ($item[$k] == 'Цена') $price_item = $k;
                if ($item[$k] == 'Вес, кг') $weight_item = $k;
                if ($item[$k] == 'Посмотреть в демозале') $demo_item = $k;
                if ($item[$k] == 'Производитель') $manufacturer_item = $k;
            } else {

                if(isset($item[$image_item])){

                    $url = $item[$image_item];

                    $file_name = pathinfo($url)['basename'];
                    //$file_name=$date . '.' . $file_extension;

                    $file = file_get_contents($url);

                    $url_file = Storage::disk('public')->put('/goods/'.$file_name, $file);

                }

                //echo "url_file: goods/".$file_name."<br>";
                //echo "title: ".$item[$name_item]."<br>";
                //echo "image: ".$item[$image_item]."<br>";
                //echo "power: ".$item[$power_item]."<br>";
                //echo "stock_count: ".$item[$stock_item]."<br>";
                $price =  trim(stristr($item[$price_item], 'руб.', true));
                //echo "price: ".$price."<br>";
                //echo "weight: ".$item[$weight_item]."<br>";
                //echo "demo: ".$item[$demo_item]."<br>";
                //echo "manufacturer: ".$item[$manufacturer_item]."<br>";
                $manufactur = trim(stristr($item[$manufacturer_item], '[', true));
                $country = Manufacturer::query()->where('name', '=', $manufactur)->get();
                //echo "country: ".$country[0]->code_country."<br>";
                //echo "<br><br>";

                $good = new Good();
                $good->category_id = $code;
                $good->title = $item[$name_item];
                $good->image = "goods/".$file_name;
                if (!empty($item[$power_item]))
                   $good->power = $item[$power_item];
                else
                    $good->power = 0;
                $good->manufacturer = $manufactur;
                $good->country = $country[0]->code_country;
                if ($item[$stock_item] == "Да")
                    $good->stock_count = 1;
                else
                    $good->stock_count = 0;
                if (!empty($item[$price_item])) {
                    $good->price = $price;
                }
                $good->weight = $item[$weight_item];
                if (!empty($item[$demo_item]))
                    $good->demo = 1;

                $good->text = "Данный товар доступен на складе и в каталоге интернет-магазина";
                $good->save();

            }
            $i++;
            $current++;
            $progress = round(($current*100)/$all);

        endforeach;

        echo "<p style='color:green'>Данные успешно были загружены! Код категории: $code</p>";
        //echo '</pre>';
    }
}