<?php
namespace Modules\Company\Admin;

use Illuminate\Http\Request;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\DB;
use Modules\AdminController;
use Modules\Company\Models\CompanyCategory as Category;
use Illuminate\Support\Str;
use Modules\Company\Models\CompanyCategoryTranslation as CategoryTranslation;

class CompanyCategoryController extends AdminController
{
    public function __construct()
    {
        $this->setActiveMenu('admin/module/company/category');
        parent::__construct();
    }

    public function index(Request $request)
    {
        $this->checkPermission('employer_manage_others');

        $catlist = new Category;
        if ($catename = $request->query('s')) {
            $catlist = $catlist->where('name', 'LIKE', '%' . $catename . '%');
        }
        $catlist = $catlist->orderby('id', 'desc');
        $rows = $catlist->get();

        $data = [
            'rows'        => $rows->toTree(),
            'row'         => new Category(),
            'breadcrumbs' => [
                [
                    'name' => __('Company'),
                    'url'  => 'admin/module/company'
                ],
                [
                    'name'  => __('Category'),
                    'class' => 'active'
                ],
            ],
            'translation'=>new CategoryTranslation()
        ];
        return view('Company::admin.category.index', $data);
    }

    public function edit(Request $request, $id)
    {
        $this->checkPermission('employer_manage_others');
        $row = Category::find($id);

        $translation = $row->translateOrOrigin($request->query('lang'));

        if (empty($row)) {
            return redirect('admin/module/company/category');
        }
        $data = [
            'row'     => $row,
            'translation'     => $translation,
            'parents' => Category::get()->toTree(),
            'enable_multi_lang'=>true
        ];
        return view('Company::admin.category.detail', $data);
    }

    public function store(Request $request, $id){
        $this->checkPermission('employer_manage_others');

        if($id>0){
            $row = Category::find($id);
            if (empty($row)) {
                return redirect(route('company.admin.category.index'));
            }
        }else{
            $row = new Category();
            $row->status = "publish";
        }

        $row->fill($request->input());
        $res = $row->saveOriginOrTranslation($request->input('lang'));

        if ($res) {
            if($id > 0 ){
                return back()->with('success',  __('Category updated') );
            }else{
                return redirect(route('company.admin.category.index'))->with('success', __('Category created') );
            }
        }
    }

    public function bulkEdit(Request $request)
    {
        $this->checkPermission('employer_manage_others');
        $ids = $request->input('ids');
        $action = $request->input('action');
        if (empty($ids) or !is_array($ids)) {
            return redirect()->back()->with('error', __('Please select at least 1 item!'));
        }
        if (empty($action)) {
            return redirect()->back()->with('error', __('Please select an Action!'));
        }
        if ($action == 'delete') {
            foreach ($ids as $id) {
                $query = Category::where("id", $id)->first();
                if(!empty($query)){
                    $query->delete();
                }
            }
        }else{

            foreach ($ids as $id) {
                $query = Category::where("id", $id)->update(['status' => $action]);
            }
        }
        return redirect()->back()->with('success', __('Update success!'));
    }

    public function getForSelect2(Request $request)
    {
        $pre_selected = $request->query('pre_selected');
        $selected = $request->query('selected');

        if($pre_selected && $selected){
            if(is_array($selected))
            {
                $query = Category::query()->select('id', DB::raw('name as text'));
                $items = $query->whereIn('bc_categories.id', $selected)->take(50)->get();
                return response()->json([
                    'items'=>$items
                ]);
            }
            $item = Category::find($selected);
            if(empty($item)){
                return response()->json([
                    'text'=>''
                ]);
            }else{
                return response()->json([
                    'text'=>$item->name
                ]);
            }
        }
        $q = $request->query('q');
        $query = Category::select('id', 'name as text')->where("status","publish");
        if ($q) {
            $query->where('name', 'like', '%' . $q . '%');
        }
        $res = $query->orderBy('id', 'desc')->limit(20)->get();
        return response()->json([
            'results' => $res
        ]);
    }
}