<?php

namespace App\Http\Controllers;

use DB;
use DataTables;
use App\Product;
use App\Parameter;
use App\Attribute;
use App\ProductAttribute;
use Illuminate\Http\Request;
use App\Http\Controllers\ShopifyController;
use App\Http\Controllers\WoocommerceController;

class ProductAttributeController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index($product_id)
    {
        $parameter = Parameter::find(1);
        return view('product_attributes.list',compact('product_id'))
                ->with('parameter', $parameter);
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create($product_id)
    {
        $attributes = Attribute::where('active', true)->get();
        return view('product_attributes.create', compact('attributes','product_id'));
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request,$product_id,$sync = true)
    {
        $attribute = Attribute::where('id', $request->input('attribute_id'))->first();
        $product = Product::select('reference_woocommerce_product_id','reference_shopify_id','price')->where('id', $product_id)->first();

        $reference_shopify_variation_id = null;
        $reference_shopify_id = null;
        $reference_id = null;
        $reference_varation_id = null;
        $array_data = [];
        if($sync){
            $woo = new WoocommerceController();
            $data = [
                'name' => $request->input('value'),
            ];
            $reference_id = $woo->createAttributeTerm($attribute->reference_woocommerce_attribute_id,$data);
            if($reference_id){
                $data_pro = [
                    'attributes' => [
                        [
                            'id' => $attribute->reference_woocommerce_attribute_id,
                            'option' => $request->input('value')
                        ]
                    ]
                ];
                $reference_varation_id = $woo->createProductVariation($product->reference_woocommerce_product_id,$data_pro);
            }

            $sho = new ShopifyController();
            $data_sho = [
                "option1"               => $request->input('value'),
                "price"                 => $product->price + intval($request->input('price_additional')),
                "sku"                   => $request->input('sku'),
                "inventory_management"  => "shopify",
            ];
            $variant = $sho->createVariant($product->reference_shopify_id,$data_sho);
            if($variant){
                $reference_shopify_variation_id = $variant->getInventoryItemId();
                $reference_shopify_id = $variant->getId();
                $sho->updateInventoryLevel($reference_shopify_variation_id,$request->input('available_units'));
            }
            $array_data = array_merge($request->all(),[
                            'reference_woocommerce_id' => $reference_id,
                            'reference_woocommerce_variation_id' => $reference_varation_id,
                            'reference_shopify_variation_id'     => $reference_shopify_variation_id,
                            'reference_shopify_id'     => $reference_shopify_id,
                        ]);
        }else{
            $array_data = $request->all();
        }

        if (ProductAttribute::create($array_data)) {
            return response(array("r" => true, "type" => "success", "title" => "", "m" => __('messages.created_successfully'), "data" => null));
        } else {
            return response(array("r" => false, "type" => "error", "title" => "Oops...", "m" => __('messages.error_creating'), "data" => null));
        }
    }

    /**
     * Display the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function show($id)
    {
        //
    }

    /**
     * Show the form for editing the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function edit($product_id,$product_attribute_id)
    {
        $attributes = Attribute::where('active', true)->get();
        $product_attribute = ProductAttribute::where('id', $product_attribute_id)->first();
        if ($product_attribute) {
            return view('product_attributes.edit', compact('attributes','product_attribute','product_id'));
        } else {
            return redirect()->back();
        }
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, $product_id,$product_attribute_id)
    {
        $attribute = Attribute::where('id', $request->input('attribute_id'))->first();
        $product_attribute = ProductAttribute::where('id', $product_attribute_id)->first();
        $product = Product::select('reference_woocommerce_product_id','price')->where('id', $product_id)->first();
        $woo = new WoocommerceController();
        $data = [
            'name' => $request->input('value'),
        ];
        $data_pro = [
            'attributes' => [
                [
                    'id' => $attribute->reference_woocommerce_attribute_id,
                    'option' => $request->input('value')
                ]
            ]
        ];
        $woo->updateAttributeTerm($product_attribute->reference_woocommerce_id,$attribute->reference_woocommerce_attribute_id,$data);
        $woo->updateProductVariation($product->reference_woocommerce_product_id,$product_attribute->reference_woocommerce_variation_id,$data_pro);

        $sho = new ShopifyController();
        $data_sho = [
            "option1"               => $request->input('value'),
            "price"                 => $product->price + intval($request->input('price_additional')),
            "sku"                   => $request->input('sku'),
        ];
        $sho->updateVariant($product_attribute->reference_shopify_id,$data_sho);

        if (ProductAttribute::where('id', $product_attribute_id)->update(array_slice($request->all(), 1))) {
            return response(array("r" => true, "type" => "success", "title" => "", "m" => __('messages.updated_successfully'), "data" => null));
        } else {
            return response(array("r" => false, "type" => "error", "title" => "Oops...", "m" => __('messages.error_updating'), "data" => null));
        }
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function destroy($product_id,$product_attribute_id)
    {
        $product_attribute = ProductAttribute::where('id', $product_attribute_id)->first();
        $attribute = Attribute::where('id', $product_attribute->attribute_id)->first();
        $product = Product::select('reference_woocommerce_product_id','reference_shopify_id')->where('id', $product_id)->first();

        $woo = new WoocommerceController();
        $woo->deleteAttributeTerm($product_attribute->reference_woocommerce_id,$attribute->reference_woocommerce_attribute_id);
        $woo->deleteProductVariation($product->reference_woocommerce_product_id,$product_attribute->reference_woocommerce_variation_id);

        $sho = new ShopifyController();
        $sho->deleteVariant($product_attribute->reference_shopify_id,$product->reference_shopify_id);

        if (ProductAttribute::where('id', $product_attribute_id)->delete()) {
            return response(array("r" => true, "type" => "success", "title" => "", "m" => __('messages.updated_successfully'), "data" => null));
        } else {
            return response(array("r" => false, "type" => "error", "title" => "Oops...", "m" => __('messages.error_updating'), "data" => null));
        }
    }

    public function tableFilter($product_id){
        $obj = ProductAttribute::where('product_id', $product_id)->with('product','attribute');
        return DataTables::of($obj)
        ->addColumn('actions', function ($obj) {
            return '
               <i class="fa fa-pencil iconMini " onClick="clickEdit('.$obj->id.','.$obj->product_id.')" data-toggle="tooltip" data-placement="bottom"  style="cursor:pointer;"></i>
               <i class="fa fa-trash iconMini " onClick="clickDelete('.$obj->id.','.$obj->product_id.')" data-toggle="tooltip" data-placement="bottom"  style="cursor:pointer;"></i>
            ';
        })
        ->rawColumns(['actions'])
        ->make(true);
    }
}