<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Models\Category;
use App\Models\Main_category;
use Illuminate\Support\Facades\DB;

class CategoryController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index(Request $request, $cat_id = null)
    {
        $admin_id = $request->session()->get('loggedIn')['id'];
        $data['mainMenu'] = 'productManagement';
        $data['subMenu'] = 'categoryList';
        $parent_id = (!empty($cat_id)) ? $cat_id : 0;

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

        if ($request->search) {
            $data['categories'] = Main_category::where('parent_id', $parent_id)->where('admin_id', $admin_id)->where('name', 'LIKE', '%' . $request->search . '%')->paginate(10);
        } else {
            $data['categories'] = Main_category::where('parent_id', $parent_id)->where('admin_id', $admin_id)->paginate(10);
        }

        $nav_tree = $this->parentsTree($cat_id, 'main_categories');
        $nav_leafs = $this->array_depth($nav_tree, array());
        $rev_leafs = array_reverse($nav_leafs);
        $final_links = array();

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

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

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create(Request $request, $cat_id = null)
    {
        $admin_id = $request->session()->get('loggedIn')['id'];
        $data['mainMenu'] = 'productManagement';
        $data['subMenu'] = 'categoryList';
        $data['categories'] = Main_category::where('admin_id', $admin_id)->get();
        return view('admin.category.add-category', $data);
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function saveCategory(Request $request)
    {

        $admin_id = $request->session()->get('loggedIn')['id'];
        $request->validate([
            'name' => 'required',
            'type' => 'required',
        ]);

        $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));

        $_sortOrder = Main_category::where('admin_id', $admin_id)->get()->last();
        if (empty($_sortOrder)) {
            $sort_order = 1;
        } else {
            $sort_order =  $_sortOrder->sort_order + 1;
        }

        if (is_null($request->parent_id)) {
            $parent_id = 0;
        } else {
            $parent_id = $request->parent_id;
        }

        /* Store data name in DATABASE from HERE */

        $data = array(
            'parent_id' => $parent_id,

            'admin_id' => $admin_id,
            'name' => $request->name,
            'type' => $request->type,
            'sort_order' => $sort_order,
            'image' => $imageName,
            'slug' => $slug,


        );

        // dd($data);

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

    public function saveSubCategory(Request $request)
    {
        // dd($request->input());

        $admin_id = $request->session()->get('loggedIn')['id'];

        $slug =  str_replace(' ', '-', strtolower($request->subcatName));
        $_sortOrder = Main_category::where('admin_id', $admin_id)->get()->last();
        if (empty($_sortOrder)) {
            $sort_order = 1;
        } else {
            $sort_order =  $_sortOrder->sort_order + 1;
        }

        $data = array(

            'admin_id' => $admin_id,
            'parent_id' => $request->catId,
            'name' => $request->subcatName,
            'slug' => $slug,
            'sort_order' => $sort_order,

        );

        $res = Main_category::create($data);
        if ($res) {
            echo 1;
        } else {
            echo -1;
        }
    }

    public function getSubCategory(Request $request)
    {
        // dd($request->catId);
        $getSubCat = '';
        $catId = $request->catId;
        $getSubCategory = Main_category::where('parent_id', $catId)->get();

        // print_r($getSubCategory);exit;

        if (!empty($getSubCategory)) {
            $getSubCat  .= '<select class="form-control category">';
            $getSubCat .= '<option value="">Select Category</option>';
            foreach ($getSubCategory as $getSubCateg) {
                $getSubCat .= '<option value=' . $getSubCateg->id . '>' . $getSubCateg->name . '</option>';
            }

            $getSubCat  .= '</select">';
        }

        // dd($getSubCat);

        return response()->json($getSubCat);
    }




    /**
     * Display the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function show(Request $request, $id)
    {
        $admin_id = $request->session()->get('loggedIn')['id'];

        $data['mainMenu'] = 'productManagement';
        $data['subMenu'] = 'categoryList';
        $data['category'] = Main_category::where(['id' => $id])->first();
        // dd($data['category']);
        return view('admin.category.view-main-category', $data);
    }

    /**
     * Show the form for editing the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function edit(Request $request, $id)
    {
        $admin_id = $request->session()->get('loggedIn')['id'];

        $data['mainMenu'] = 'productManagement';
        $data['subMenu'] = 'categoryList';
        $data['category'] = Main_category::where(['id' => $id])->first();
        // dd($data['category']);
        return view('admin.category.edit-main-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)
    {
        $data = array(


            'name' => $request->name,
            'type' => $request->type,

            'sort_order' => $request->sort_order,


        );

        $res = Main_category::where(['id' => $id])->update($data);
        if ($res) {
            return back()
                ->with('success', $request->name . ' Has Been Added!.');
        } 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)
    {
        //    dd($id);
        Main_category::where(['id' => $id])->delete();
        return back()->with('success', 'Category deleted successfully');
    }

    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;
    }
}