<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Input;
use App\Models\Category;
use App\Models\Product;
use File;

class CategoryInsideController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index(Request $request, $prod_id, $cat_id = null)
    {
        $data['mainMenu'] = 'productManagement';
        $data['subMenu'] = 'productList';
        $parent_id = (!empty($cat_id)) ? $cat_id : 0;
        $info = Product::find($prod_id);

        if ($parent_id) {
            $cat = Category::find($parent_id);
            if ($cat->type == 'content') {
                return back()->with('error', 'Sub category not possible!');
            }
        }

        if ($request->search) {
            $data['categories'] = Category::where('parent_id', $parent_id)->where('product_id', $prod_id)->where('name', 'LIKE', '%' . $request->search . '%')->paginate(10);
        } else {
            $data['categories'] = Category::where('parent_id', $parent_id)->where('product_id', $prod_id)->paginate(10);
        }
        $nav_tree = $this->parentsTree($cat_id, 'categories');
        $nav_leafs = $this->array_depth($nav_tree, array());
        $rev_leafs = array_reverse($nav_leafs);
        $final_links = array();

        foreach ($rev_leafs as $leaf) {
            $nav = Category::where('slug', $leaf)->first();
            $final_links[$nav->id] = $leaf;
        }

        $data['nav_links'] = $final_links;
        $data['info'] = $info;
        return view('admin.inside-category.category-list', $data);
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create($prod_id, $cat_id = null)
    {
        $data['mainMenu'] = 'productManagement';
        $data['subMenu'] = 'productList';
        $info = Product::find($prod_id);
        $data['info'] = $info;
        return view('admin.inside-category.add-category', $data);
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {
        $admin_id = $request->session()->get('loggedIn')['id'];
        $request->validate([
            'name' => 'required',
            'type' => 'required',
            'description' => 'required',
            //'image' => 'required|image|mimes:jpeg,png,jpg,gif,svg',
        ]);

        $imageName = "noimage.jpg";
        if ($request->hasFile('image')) {
            $imageName = time() . rand() . '.' . $request->image->extension();
            $request->image->move(public_path('uploads/category'), $imageName);
        }

        $slug =  str_replace(' ', '-', strtolower($request->name));
        if (is_null($request->parent_id)) {
            $parent_id = 0;
        } else {
            $parent_id = $request->parent_id;
        }



        $_sortOrder = Category::get()->last();
        if (empty($_sortOrder)) {
            $sort_order = 1;
        } else {
            $sort_order =  $_sortOrder->sort_order + 1;
        }


        /* Store data name in DATABASE from HERE */

        $data = array(
            'parent_id' => $parent_id,
            'product_id' => $request->product_id,
            'admin_id' => $admin_id,
            'name' => $request->name,
            'type' => $request->type,
            'description' => $request->description,
            'image' => $imageName,
            'slug' => $slug,
            'sort_order' => $sort_order,
            'status' => "1",
        );

        // dd($data);

        $res = Category::create($data);
        if ($res) {
            return back()
                ->with('success', $request->name . ' Has Been Added!.');
        } else {
            return back()
                ->with('error', 'Something Went Wrong!');
        }
    }

    /**
     * Display the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function show($id)
    {
        $data['mainMenu'] = 'categoryManagement';
        $data['subMenu'] = 'categoryList';
        $info = Category::findOrFail($id);
        $data['info'] = $info;
        return view('admin.inside-category.view-category', $data);
    }

    /**
     * Show the form for editing the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function edit($id)
    {
        $data['mainMenu'] = 'categoryManagement';
        $data['subMenu'] = 'categoryList';
        $info = Category::findOrFail($id);
        $data['info'] = $info;
        return view('admin.inside-category.edit-category', $data);
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, $id)
    {
        $admin_id = $request->session()->get('loggedIn')['id'];
        $cat = Category::findOrFail($id);



        $image_rule = (!empty($request->image)) ? 'required|image|mimes:jpeg,png,jpg,gif,svg' : '';
        $name_rule = ($request->name == $cat->name) ? 'required' : 'required|unique:categories';

        $request->validate([
            'name' => $name_rule,
            'type' => 'required',
            'status' => 'required',
            'description' => 'required',
            'sort_order' => 'required',
            'image' => $image_rule,
        ]);

        if (!empty($request->image)) {
            $imageName = time() . rand() . '.' . $request->image->extension();
            $request->image->move(public_path('uploads/category'), $imageName);
        } else {
            $imageName = $cat->image;
        }
        $slug =  str_replace(' ', '-', strtolower($request->name));
        /* Store data name in DATABASE from HERE */

        $data = array(
            'parent_id' => $cat->parent_id,
            'product_id' => $request->product_id,
            'admin_id' => $admin_id,
            'name' => $request->name,
            'type' => $request->type,
            'description' => $request->description,
            'image' => $imageName,
            'slug' => $slug,
            'sort_order' => $request->sort_order,
            'status' => $request->status,
        );

        $res = Category::where(['id' => $id])->update($data);
        if ($res) {
            return back()
                ->with('success', $request->name . ' Has Been Updated!.');
        } else {
            return back()
                ->with('error', 'Something Went Wrong!');
        }
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function destroy($id)
    {
        $cat = Category::findOrFail($id);
        // if (File::exists(public_path('uploads/category/' . $cat->image))) {
        //     File::delete(public_path('uploads/category/' . $cat->image));
        // }
        $cat->delete();
        return back()->with('success', 'Category deleted successfully');
    }
    public function changeStatus($id, $action)
    {
        $flag = 0;
        $level = 'Inactive';
        if ($action == 'true') {
            $flag = 1;
            $level = 'Active';
        }
        $cat = Category::findOrFail($id);
        $cat->status = $flag;
        if ($cat->save()) {
            $arr['status'] = $flag;
            $arr['code'] = 200;
            $arr['message'] = 'Category is successfully ' . $level;
        } else {
            $arr['status'] = $flag;
            $arr['code'] = 201;
            $arr['message'] = 'something went wrong !!';
        }
        echo json_encode($arr);
    }
    public function parentsTree($id, $tble)
    {
        $row1 = [];
        // $row = $this->db->query("SELECT id,name,parent_id,seo_url from $tble WHERE id = $id order by sort ASC")->result_array(); 
        $row = DB::table($tble)->select('*')->where('id', $id)->get();

        foreach ($row as $key => $value) {
            $id = $value->parent_id;
            $row1[$key]['id'] = $value->id;
            $row1[$key]['parent_id'] = $value->parent_id;
            $row1[$key]['name'] = $value->name;
            $row1[$key]['slug'] = $value->slug;
            $row1[$key]['parent'] = array_values($this->parentsTree($id, $tble));
        }

        return $row1;
    }

    public function array_depth(array $array, array $result)
    {
        foreach ($array as $key => $elem) {
            if (!is_array($elem)) {
                if ($key == 'slug')
                    array_push($result, $elem);
            } else {
                return $this->array_depth($elem, $result);
            }
        }

        return $result;
    }


    public function categoryChangeStatus(Request $request)
    {
        $id = $request->id;
        $bool = $request->ckb;

        $flag = "0";
        if ($bool == 'true') {
            $flag = "1";
        }
        $data = array(
            'status' => $flag,

        );


        $status =  Category::where('id', $id)->update($data);


        echo $status;
    }

    public function demoChangeStatus(Request $request)
    {

        $id = $request->id;
        $bool = $request->ckb;



        $flag = "0";
        if ($bool == 'true') {
            $flag = "1";
        }
        $data = array(
            'demo_type' => $flag,
            'locked' => $flag
        );



        $status =  Category::where('id', $id)->update($data);
    }
}