<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Company;
use App\sitehelpcategory;
use App\sitehelp;
use App\emkahelpcategory;
use App\emkahelp;
use Illuminate\Support\Str;
class HelpController extends Controller
{

    public function HelpSite()
    {
        $company = Company::first();
        $category = sitehelpcategory::orderBy('urutan','asc')->get();
return redirect('https://binggo.co.id/site/help/selamat-datang-di-site');
        //return view('help.site.index', compact('company','category'));
    }

    public function HelpSiteDetail($slug) {
        $help = sitehelp::where('slug',$slug)->first();
        $company = Company::first();
        $category = sitehelpcategory::all();
        return view('help.site.detail', compact('help','company','category'));
    }

    public function sitedashboard(){
        $help = sitehelp::all();
        return view('help.site.dashboard', compact('help'));
    }
    public function sitecreate(){
        $category = sitehelpcategory::all();
        return view('help.site.create', compact('category'));
    }

    public function sitestore(Request $request){
        $category_type = $request->get('category_type');
        $help = new sitehelp();
        $help->content = $request->get('content');
        $help->title = $request->get('title');
        $help->slug = Str::slug($request->get('title'), '-');
        if($category_type == 'select') {
            $help->idsitehelp_category = $request->get('category');
        } else {
            $check_category = sitehelpcategory::where('category', $request->get('category'))->first();

            if($check_category) {
                $help->idsitehelp_category = $check_category->idsitehelp_category;
            } else {
                $category = new sitehelpcategory();
                $category->category = $request->get('category_name');
                $category->save();
                $idnew = sitehelpcategory::orderBy('idsitehelp_category','DESC')->first()->idsitehelp_category;
                $help->idsitehelp_category = $idnew;
            }  
        }
        $help->save();

        return redirect()->route('site.help')->with('message', 'Data Successfully Added');
    }
    public function editsite($id){
        $help = sitehelp::where('id',$id)->get()->first();
        $category = sitehelpcategory::all();
        return view('help.site.edit', compact('help','category'));
    }

    public function updatesite(Request $request){
        $id = $request->get('id');
        $category_type = $request->get('category_type');
        $help = sitehelp::findOrFail($id);
        $help->content = $request->get('content');
        $help->title = $request->get('title');
        $help->slug = Str::slug($request->get('title'), '-');
        if($category_type == 'select') {
            $help->idsitehelp_category = $request->get('category');
        } else {
            $check_category = sitehelpcategory::where('category', $request->get('category'))->first();

            if($check_category) {
                $help->idsitehelp_category = $check_category->idsitehelp_category;
            } else {
                $category = new sitehelpcategory();
                $category->category = $request->get('category_name');
                $category->save();
                $idnew = sitehelpcategory::orderBy('idsitehelp_category','DESC')->first()->idsitehelp_category;
                $help->idsitehelp_category = $idnew;
            }  
        }
        $help->save();

        return redirect()->route('site.help')->with('message', 'Data Successfully Added');
    }
    public function deletesite($id){
        sitehelp::destroy($id);
        return redirect()->route('site.help')->with('message', 'Data Successfully Deleted');
    }

    public function HelpEmka()
    {
        $company = Company::first();
        $category = emkahelpcategory::all();
	return redirect('https://binggo.co.id/emka/help/selamat-datang');
        //return view('help.emka.index', compact('company','category'));
    }

    public function HelpEmkaDetail($slug) {
        $help = emkahelp::where('slug',$slug)->first();
        $company = Company::first();
        $category = emkahelpcategory::all();
        return view('help.emka.detail', compact('help','company','category'));
    }

    public function emkadashboard(){
        $help = emkahelp::all();
        return view('help.emka.dashboard', compact('help'));
    }
    public function emkacreate(){
        $category = emkahelpcategory::all();
        return view('help.emka.create', compact('category'));
    }

    public function emkastore(Request $request){
        $category_type = $request->get('category_type');
        $help = new emkahelp();
        $help->content = $request->get('content');
        $help->title = $request->get('title');
        $help->slug = Str::slug($request->get('title'), '-');
        if($category_type == 'select') {
            $help->idemkahelp_category = $request->get('category');
        } else {
            $check_category = emkahelpcategory::where('category', $request->get('category'))->first();

            if($check_category) {
                $help->idemkahelp_category = $check_category->idemkahelp_category;
            } else {
                $category = new emkahelpcategory();
                $category->category = $request->get('category_name');
                $category->save();
                $idnew = emkahelpcategory::orderBy('idemkahelp_category','DESC')->first()->idemkahelp_category;
                $help->idemkahelp_category = $idnew;
            }  
        }
        $help->save();

        return redirect()->route('emka.help')->with('message', 'Data Successfully Added');
    }
    public function editemka($id){
        $help = emkahelp::where('id',$id)->get()->first();
        $category = emkahelpcategory::all();
        return view('help.emka.edit', compact('help','category'));
    }

    public function updateemka(Request $request){
        $id = $request->get('id');
        $category_type = $request->get('category_type');
        $help = emkahelp::findOrFail($id);
        $help->content = $request->get('content');
        $help->title = $request->get('title');
        $help->slug = Str::slug($request->get('title'), '-');
        if($category_type == 'select') {
            $help->idemkahelp_category = $request->get('category');
        } else {
            $check_category = emkahelpcategory::where('category', $request->get('category'))->first();

            if($check_category) {
                $help->idemkahelp_category = $check_category->idemkahelp_category;
            } else {
                $category = new emkahelpcategory();
                $category->category = $request->get('category_name');
                $category->save();
                $idnew = emkahelpcategory::orderBy('idemkahelp_category','DESC')->first()->idemkahelp_category;
                $help->idemkahelp_category = $idnew;
            }  
        }
        $help->save();

        return redirect()->route('emka.help')->with('message', 'Data Successfully Added');
    }
    public function deleteemka($id){
        emkahelp::destroy($id);
        return redirect()->route('emka.help')->with('message', 'Data Successfully Deleted');
    }
    public function categorysite(){
        $category = sitehelpcategory::all();
        return view('help.site.category', compact('category'));
    }
    public function editsitecategory($id){
        $category = sitehelpcategory::where('idsitehelp_category',$id)->get()->first();
        return view('help.site.editcategory', compact('category'));
    }
    public function updatesitecategory(Request $request)
    {
        // untuk validasi form
        $this -> validate($request, [
            'category' => 'required',
            'urutan' => 'required',
        ]);
        $category = sitehelpcategory::where('idsitehelp_category', $request -> id) -> update([
            'category' => $request -> category,
            'urutan' => $request -> urutan,
        ]);
        return redirect()->route('site.help')->with('message', 'Data Successfully Updated');
    }
    public function deletesitecategory($id){
        sitehelpcategory::where('idsitehelp_category', $id) -> delete();
        return redirect()->route('site.help')->with('message', 'Data Successfully Deleted');
    }
    public function categoryemka(){
        $category = emkahelpcategory::all();
        return view('help.emka.category', compact('category'));
    }
    public function editemkacategory($id){
        $category = emkahelpcategory::where('idemkahelp_category',$id)->get()->first();
        return view('help.emka.editcategory', compact('category'));
    }
    public function updateemkacategory(Request $request)
    {
        // untuk validasi form
        $this -> validate($request, [
            'category' => 'required',
        ]);
        $category = emkahelpcategory::where('idemkahelp_category', $request -> id) -> update([
            'category' => $request -> category,
        ]);
        return redirect()->route('emka.help')->with('message', 'Data Successfully Added');
    }
    public function deleteemkacategory($id){
        emkahelpcategory::where('idemkahelp_category', $id) -> delete();
        return redirect()->route('emka.help')->with('message', 'Data Successfully Deleted');
    }
}