<?php

namespace App\Http\Controllers;

use App\{Media, SitePage, Template, Testimonial};
use Illuminate\Http\Request;
use Illuminate\Support\Str;
use App\Http\Controllers\SEOController;

class SitePageController extends Controller
{
    public function index() {
        $seo = new SEOController;
        $content = SitePage::first();
        $testi = $content->testimonial;

        $final_score = $seo->altImageCheck('site');
        $persen = $seo->keyphraseDensity('site');
        $keyphrase_check = $seo->keyphraseCheck('site');
        $total_text_length = $seo->textLength('site');

        if(json_decode($testi, true)) {
            $testimonials = Testimonial::whereIn('id', json_decode($testi, true))->get();
        } else {
            $testimonials = NULL;
        }
        return view('layout.site', compact('content', 'testimonials', 'final_score','persen','keyphrase_check','total_text_length'));
    }

    public function edit(Request $request) {
        $act = $request->get('act');

        if($act == 'section-1-image') {
            $media = Media::all();
            $section_1_image = SitePage::first()->section_1_image;

            if($section_1_image) {
                $alt = $this->checkALtMedia($section_1_image);
            } else {
                $alt = '';
            }

            $url = route('layout.site-update-image');
            $img = $request->get('img');

            return view('layout.edit-image', compact('act', 'media', 'url', 'alt', 'img'));
        } else if($act == 'section-3-image') {
            $media = Media::all();
            $section_3_image = SitePage::first()->section_3_image;

            if($section_3_image) {
                $alt = $this->checkALtMedia($section_3_image);
            } else {
                $alt = '';
            }

            $url = route('layout.site-update-image');
            $img = $request->get('img');

            return view('layout.edit-image', compact('act', 'media', 'url', 'alt', 'img'));
        } else if($act == 'section-5-image') {
            $media = Media::all();
            $section_5_image = SitePage::first()->section_5_image;

            if($section_5_image) {
                $alt = $this->checkALtMedia($section_5_image);
            } else {
                $alt = '';
            }

            $url = route('layout.site-update-image');
            $img = $request->get('img');

            return view('layout.edit-image', compact('act', 'media', 'url', 'alt', 'img'));
        } else if($act == 'section-4-1-image') {
            $media = Media::all();
            $section_4_1_image = SitePage::first()->section_4_1_image;

            if($section_4_1_image) {
                $alt = $this->checkALtMedia($section_4_1_image);
            } else {
                $alt = '';
            }

            $url = route('layout.site-update-image');
            $img = $request->get('img');

            return view('layout.edit-image', compact('act', 'media', 'url', 'alt', 'img'));
        } else if($act == 'section-4-2-image') {
            $media = Media::all();
            $section_4_2_image = SitePage::first()->section_4_2_image;

            if($section_4_2_image) {
                $alt = $this->checkALtMedia($section_4_2_image);
            } else {
                $alt = '';
            }

            $url = route('layout.site-update-image');
            $img = $request->get('img');

            return view('layout.edit-image', compact('act', 'media', 'url', 'alt', 'img'));
        } else if($act == 'section-4-3-image') {
            $media = Media::all();
            $section_4_3_image = SitePage::first()->section_4_3_image;

            if($section_4_3_image) {
                $alt = $this->checkALtMedia($section_4_3_image);
            } else {
                $alt = '';
            }

            $url = route('layout.site-update-image');
            $img = $request->get('img');

            return view('layout.edit-image', compact('act', 'media', 'url', 'alt', 'img'));
        } else if($act == 'section-4-4-image') {
            $media = Media::all();
            $section_4_4_image = SitePage::first()->section_4_4_image;

            if($section_4_4_image) {
                $alt = $this->checkALtMedia($section_4_4_image);
            } else {
                $alt = '';
            }

            $url = route('layout.site-update-image');
            $img = $request->get('img');

            return view('layout.edit-image', compact('act', 'media', 'url', 'alt', 'img'));
        } else if($act == 'section-4-5-image') {
            $media = Media::all();
            $section_4_5_image = SitePage::first()->section_4_5_image;

            if($section_4_5_image) {
                $alt = $this->checkALtMedia($section_4_5_image);
            } else {
                $alt = '';
            }

            $url = route('layout.site-update-image');
            $img = $request->get('img');

            return view('layout.edit-image', compact('act', 'media', 'url', 'alt', 'img'));
        } else if($act == 'section-4-6-image') {
            $media = Media::all();
            $section_4_6_image = SitePage::first()->section_4_6_image;

            if($section_4_6_image) {
                $alt = $this->checkALtMedia($section_4_6_image);
            } else {
                $alt = '';
            }

            $url = route('layout.site-update-image');
            $img = $request->get('img');

            return view('layout.edit-image', compact('act', 'media', 'url', 'alt', 'img'));
        } else if($act == 'section-10-image') {
            $media = Media::all();
            $section_10_image = SitePage::first()->section_10_image;

            if($section_10_image) {
                $alt = $this->checkALtMedia($section_10_image);
            } else {
                $alt = '';
            }

            $url = route('layout.site-update-image');
            $img = $request->get('img');

            return view('layout.edit-image', compact('act', 'media', 'url', 'alt', 'img'));
        } else if($act == 'section-3-image') {
            $media = Media::all();
            $section_11_image = SitePage::first()->section_11_image;

            if($section_11_image) {
                $alt = $this->checkALtMedia($section_11_image);
            } else {
                $alt = '';
            }

            $url = route('layout.apps-update-image');
            $img = $request->get('img');

            return view('layout.edit-image', compact('act', 'media', 'url', 'alt', 'img'));
        } else if($act == 'choose-testimonial') {
            return Testimonial::all();
        }
    }

    public function updateImage(Request $request) {
        $save = $request->get('save');
        $act = $request->get('act');
        $alt = $request->get('alt');

        $site_page = SitePage::first();
        $media = new Media();

        if($save == 'save-as') {
            if ($request->hasFile($act)) {
                $image = $request->file($act);
                // $ext = $image->getClientOriginalExtension();

                if ($request->file($act)->isValid()) {
                    // check if file exist

                    $check_media = Media::where('name', $image->getClientOriginalName())->count();

                    if($check_media > 0) {
                        $no = 2;
                        $image_name = '';

                        while (true) {
                            $image_name = str_replace('.'. $image->getClientOriginalExtension(), '', $image->getClientOriginalName()) . '-' .$no . '.' . $image->getClientOriginalExtension();
                            if(Media::where('name', $image_name)->count() < 1) {
                            break;
                            }

                            $no++;
                        }
                    } else {
                        $image_name = $image->getClientOriginalName();
                    }

                    $upload_path = 'media';
                    $request->file($act)->move($upload_path, $image_name);

                    if($act == 'section-1-image') {
                        $site_page->section_1_image =  $image_name;
                    } else if($act == 'section-3-image') {
                        $site_page->section_3_image =  $image_name;
                    } else if($act == 'section-5-image') {
                        $site_page->section_5_image = $image_name;
                    } else if($act == 'section-4-1-image') {
                        $site_page->section_4_1_image = $image_name;
                    } else if($act == 'section-4-2-image') {
                        $site_page->section_4_2_image = $image_name;
                    } else if($act == 'section-4-3-image') {
                        $site_page->section_4_3_image = $image_name;
                    } else if($act == 'section-10-image') {
                        $site_page->section_10_image =  $image_name;
                    } else if($act == 'section-11-image') {
                        $site_page->section_11_image =  $image_name;
                    }

                    $media->name = $image_name;
                    $media->alt = $alt;
                    $media->save();
                }
            }
        } else {
            if ($request->hasFile($act)) {
                $image = $request->file($act);
                $ext = $image->getClientOriginalExtension();

                if ($request->file($act)->isValid()) {
                    $check_media = Media::where('name', str_replace('.' . $image->getClientOriginalExtension(), '', $image->getClientOriginalName()) . '.webp')->count();

                    if($check_media > 0) {
                        $no = 2;
                        $image_name = '';

                        while (true) {
                            $image_name = str_replace('.'. $image->getClientOriginalExtension(), '', $image->getClientOriginalName()) . '-' .$no . '.' . $image->getClientOriginalExtension();
                            $image_webp = str_replace('.'. $image->getClientOriginalExtension(), '', $image->getClientOriginalName()) . '-' .$no . '.webp';
                            if(Media::where('name', $image_webp)->count() < 1) {
                            break;
                            }

                            $no++;
                        }
                    } else {
                        $image_name = $image->getClientOriginalName();
                    }
                    $upload_path = 'media';
                    $request->file($act)->move($upload_path, $image_name);

                    if($ext == 'png') {
                        $img_new_a = imagecreatefrompng(public_path('media/' . $image_name));
                    } else {
                        $img_new_a = imagecreatefromjpeg(public_path('media/' . $image_name));
                    }

                    imagepalettetotruecolor($img_new_a);
                    imagealphablending($img_new_a, true);
                    imagesavealpha($img_new_a, true);
                    imagewebp($img_new_a, public_path('media/' . str_replace('.'.$ext, '.webp',$image_name)), 80);
                    imagedestroy($img_new_a);
                    unlink(public_path('media/' . $image_name));

                    if($act == 'section-1-image') {
                        $site_page->section_1_image =  str_replace('.'.$ext, '.webp',$image_name);
                    } else if($act == 'section-3-image') {
                        $site_page->section_3_image =  str_replace('.'.$ext, '.webp',$image_name);
                    } else if($act == 'section-5-image') {
                        $site_page->section_5_image = str_replace('.'.$ext, '.webp',$image_name);
                    } else if($act == 'section-4-1-image') {
                        $site_page->section_4_1_image = str_replace('.'.$ext, '.webp',$image_name);
                    } else if($act == 'section-4-2-image') {
                        $site_page->section_4_2_image = str_replace('.'.$ext, '.webp',$image_name);
                    } else if($act == 'section-4-3-image') {
                        $site_page->section_4_3_image = str_replace('.'.$ext, '.webp',$image_name);
                    } else if($act == 'section-10-image') {
                        $site_page->section_10_image =  str_replace('.'.$ext, '.webp',$image_name);
                    } else if($act == 'section-11-image') {
                        $site_page->section_11_image =  str_replace('.'.$ext, '.webp',$image_name);
                    }

                    $media->name = str_replace('.'.$ext, '.webp',$image_name);
                    $media->alt = $alt;
                    $media->save();
                }
            }
        }

        $site_page->save();

        return redirect()->route('layout.site')->with('message', 'Image Successfully Updated');

    }

    public function update(Request $request) {
        $act = $request->get('act');
        $act_type = $request->get('act_type');

        if($act == 'section-1-image') {
            if($act_type == 'save-alt') {
                $alt = $request->get('alt');
                $img = $request->get('img');

                $media = Media::where('name', $img)->first();
                $media->alt = $alt;
                $media->save();
            } else if($act_type == 'from-media') {
                $img = $request->get('img');
                $site_page = SitePage::first();
                $site_page->section_1_image = $img;
                $site_page->save();
            } 
        } else if($act == 'section-1-right') {
            $big_title = $request->get('big_title');
            $small_title = $request->get('small_title');
            $placeholder = $request->get('placeholder');
            $button_text = $request->get('button_text');
            $site_page = SitePage::first();
            $site_page->section_1_big_title = $big_title;
            $site_page->section_1_small_title = $small_title;
            $site_page->section_1_placeholder = $placeholder;
            $site_page->section_1_button = $button_text;
            $site_page->save();
        } else if($act == 'section-2') {
            $big_title = $request->get('big_title');
            $small_title = $request->get('small_title');
            $btn_text =  $request->get('btn_text');
            $btn_link =  $request->get('btn_link');
            $site_page = SitePage::first();
            $site_page->section_2_big_title = $big_title;
            $site_page->section_2_small_title = $small_title;
            $site_page->section_2_btn = $btn_text;
            $site_page->section_2_link = $btn_link;
            $site_page->save();
        } else if($act == 'section-3-1') {
            $big_title = $request->get('big_title');
            $small_title = $request->get('small_title');
            $site_page = SitePage::first();
            $site_page->section_3_1_big_title = $big_title;
            $site_page->section_3_1_small_title = $small_title;
            $site_page->save();
        
        } else if($act == 'section-3-image') {
            if($act_type == 'save-alt') {
                $alt = $request->get('alt');
                $img = $request->get('img');

                $media = Media::where('name', $img)->first();
                $media->alt = $alt;
                $media->save();
            } else if($act_type == 'from-media') {
                $img = $request->get('img');
                $site_page = SitePage::first();
                $site_page->section_3_image = $img;
                $site_page->save();
            } 
        } else if($act == 'section-3-title') {
            $big_title = $request->get('big_title');
            $small_title = $request->get('small_title');
            $site_page = SitePage::first();
            $site_page->section_3_big_title = $big_title;
            $site_page->section_3_small_title = $small_title;
            $site_page->save();
        } else if($act == 'section-3-point') {
            $points = $request->get('points');

            if(!empty($points)) {
                $site_page = SitePage::first();
                $site_page->section_3_point = json_encode($points);
                $site_page->save();
            }
        } else if($act == 'section-4-title') {
            $big_title = $request->get('big_title');
            $small_title = $request->get('small_title');
            $site_page = SitePage::first();
            $site_page->section_4_big_title = $big_title;
            $site_page->section_4_small_title = $small_title;
            $site_page->save();
        } else if($act == 'section-4-card') {
            $title = $request->get('title');
            $desc = $request->get('desc');
            $position = $request->get('position');
            $site_page = SitePage::first();

            switch ($position) {
                case "1":
                    $site_page->section_4_1_title = $title;
                    $site_page->section_4_1_desc = $desc;
                    break;
                case "2":
                    $site_page->section_4_2_title = $title;
                    $site_page->section_4_2_desc = $desc;
                    break;
                case "3":
                    $site_page->section_4_3_title = $title;
                    $site_page->section_4_3_desc = $desc;
                    break;
                default:
                break;
            };

            $site_page->save();
        } else if($act == 'section-5-image') {
            if($act_type == 'save-alt') {
                $alt = $request->get('alt');
                $img = $request->get('img');

                $media = Media::where('name', $img)->first();
                $media->alt = $alt;
                $media->save();
            } else if($act_type == 'from-media') {
                $img = $request->get('img');
                $site_page = SitePage::first();
                $site_page->section_5_image = $img;
                $site_page->save();
            } 
        } else if($act == 'section-5-title') {
            $big_title = $request->get('big_title');
            $site_page = SitePage::first();
            $site_page->section_5_title = $big_title;
            $site_page->save();
        } else if($act == 'section-5-point') {
            $title = $request->get('title');
            $desc = $request->get('desc');
            $position = $request->get('position');
            $site_page = SitePage::first();

            switch ($position) {
                case "1":
                    $site_page->section_5_1_title = $title;
                    $site_page->section_5_1_desc = $desc;
                    break;
                case "2":
                    $site_page->section_5_2_title = $title;
                    $site_page->section_5_2_desc = $desc;
                    break;
                case "3":
                    $site_page->section_5_3_title = $title;
                    $site_page->section_5_3_desc = $desc;
                    break;
                default:
                break;
            }

            $site_page->save();
        } else if($act == 'section-6') {
            $big_title = $request->get('big_title');
            $desc = $request->get('desc');
            $site_page = SitePage::first();
            $site_page->section_6_big_title = $big_title;
            $site_page->section_6_desc = $desc;
            $site_page->save();
        } else if($act == 'section-7') {
            $title = $request->get('title');
            $site_page = SitePage::first();
            $site_page->section_7_title = $title;
            $site_page->save();
        } else if($act == 'section-8') {
            $num = $request->get('num');
            $title = $request->get('title');
            $position = $request->get('position');
            $site_page = SitePage::first();

            switch ($position) {
                case "1":
                    $site_page->section_8_1_title = $title;
                    $site_page->section_8_1_num = $num;
                    break;
                case "2":
                    $site_page->section_8_2_title = $title;
                    $site_page->section_8_2_num = $num;
                    break;
                case "3":
                    $site_page->section_8_3_title = $title;
                    $site_page->section_8_3_num = $num;
                    break;
                case "4":
                    $site_page->section_8_4_title = $title;
                    $site_page->section_8_4_num = $num;
                    break;
                default:
                break;
            };

            $site_page->save();
        } else if($act == 'section-9') {
            $big_title = $request->get('big_title');
            $small_title = $request->get('small_title');
            $site_page = SitePage::first();
            $site_page->section_9_big_title = $big_title;
            $site_page->section_9_small_title = $small_title;
            $site_page->save();
        } else if($act == 'section-4-1-image' || $act == 'section-4-2-image' || $act == 'section-4-3-image') {
            if($act_type == 'save-alt') {
                $alt = $request->get('alt');
                $img = $request->get('img');

                $media = Media::where('name', $img)->first();
                $media->alt = $alt;
                $media->save();
            } else if($act_type == 'from-media') {
                $img = $request->get('img');
                $site_page = SitePage::first();

                if($act == 'section-4-1-image') {
                    $site_page->section_4_1_image = $img;
                } else if($act == 'section-4-2-image') {
                    $site_page->section_4_2_image = $img;
                } else if($act == 'section-4-3-image') {
                    $site_page->section_4_3_image = $img;
                }
                
                $site_page->save();
            } 
        } else if($act == 'section-10-image') {
            if($act_type == 'save-alt') {
                $alt = $request->get('alt');
                $img = $request->get('img');

                $media = Media::where('name', $img)->first();
                $media->alt = $alt;
                $media->save();
            } else if($act_type == 'from-media') {
                $img = $request->get('img');
                $site_page = SitePage::first();
                $site_page->section_10_image = $img;
                $site_page->save();
            } 
        } else if($act == 'section-10-left') {
            $site_page = SitePage::first();
            $site_page->section_10_big_title = $request->get('big_title');
            $site_page->section_10_small_title = $request->get('small_title');
            $site_page->section_10_1_text = $request->get('text_1');
            $site_page->section_10_2_text = $request->get('text_2');
            $site_page->section_10_1_link = $request->get('link_1');
            $site_page->section_10_2_link = $request->get('link_2');
            $site_page->save();
        } else if($act == 'section-11-image') {
            if($act_type == 'save-alt') {
                $alt = $request->get('alt');
                $img = $request->get('img');

                $media = Media::where('name', $img)->first();
                $media->alt = $alt;
                $media->save();
            } else if($act_type == 'from-media') {
                $img = $request->get('img');
                $site_page = SitePage::first();
                $site_page->section_11_image = $img;
                $site_page->save();
            } 
        } else if($act == 'section-11-title') {
            $site_page = SitePage::first();
            $site_page->section_11_big_title = $request->get('big_title');
            $site_page->section_11_small_title = $request->get('small_title');
            $site_page->save();
        } else if($act == 'section-11-point') {
            $points = $request->get('points');

            if(!empty($points)) {
                $site_page = SitePage::first();
                $site_page->section_11_point = json_encode($points);
                $site_page->save();
            }
        }else if($act == 'add-testimonial') {
            $home_page = SitePage::first();
            $testi = json_decode($home_page->testimonial, true);
            $testi[] = $request->get('testimonial_id');
            $home_page->testimonial = json_encode($testi);
            $home_page->save();

            return Testimonial::findOrFail($request->get('testimonial_id'));
        } else if($act == 'delete-testimonial') {
            $testi = json_decode(SitePage::first()->testimonial, true);
            if($testi) {
                if (($key = array_search($request->get('testimonial_id'), $testi)) !== false) {
                    unset($testi[$key]);
                    $home = SitePage::first();
                    $home->testimonial = json_encode($testi);
                    $home->save();
                }
            }

        }

        else if($act == 'top-card') {
            $position = $request->get('position');
            $pricing = SitePage::first();

            if($position == 1) {
                $pricing->title_1 = $request->get('title');
                $pricing->sub_title_1 = $request->get('sub_title');
                $pricing->price_1 = $request->get('price');
            } else if($position == 2) {
                $pricing->title_2 = $request->get('title');
                $pricing->sub_title_2 = $request->get('sub_title');
                $pricing->price_2 = $request->get('price');
            } else if($position == 3) {
                $pricing->title_3 = $request->get('title');
                $pricing->sub_title_3 = $request->get('sub_title');
                $pricing->price_3 = $request->get('price');
            }

            $pricing->save();
        } else if($act == 'bottom-card') {
            $position = $request->get('position');
            $pricing = SitePage::first();

            if($position == 1) {
                $pricing->btn_text_1 = $request->get('text');
                $pricing->btn_link_1 = $request->get('link');
            } else if($position == 2) {
                $pricing->btn_text_2 = $request->get('text');
                $pricing->btn_link_2 = $request->get('link');
            } else if($position == 3) {
                $pricing->btn_text_3 = $request->get('text');
                $pricing->btn_link_3 = $request->get('link');
            }

            $pricing->save();
        } else if($act == 'middle-card') {
            $points = $request->get('points');
            $position = $request->get('position');

            if(!empty($points)) {
                $pricing = SitePage::first();
                
                if($position == 1) {
                    $pricing->point_1 = json_encode($points);
                } else if($position == 2) {
                    $pricing->point_2 = json_encode($points);
                } else if($position == 3) {
                    $pricing->point_3 = json_encode($points);
                }

                $pricing->save();
            }
        }

        return 'true';
    }

    public function template() {
        $templates = Template::orderBy('id', 'DESC')->get();
        return view('site.template', compact('templates'));
    }

    public function createTemplate() {
        $category = Template::distinct()->get(['category']);
        return view('site.create-template', compact('category'));
    }

    public function storeTemplate(Request $request) {
        $media = new Media();
        $save = $request->get('save');
        $template = new Template();
        $template->name = $request->get('name');
        $template->slug = Str::slug($request->get('name'), '-');
        $template->category = $request->get('category');
        $template->dashboard = $request->get('dashboard');
        $template->description = $request->get('description');
        $template->link_demo = $request->get('link_demo');

        if($save == 'save-as') {
            if ($request->hasFile('image')) {
                $image = $request->file('image');
                // $ext = $image->getClientOriginalExtension();
                if ($request->file('image')->isValid()) {
                    // check if file exist

                    $check_media = Media::where('name', $image->getClientOriginalName())->count();

                    if($check_media > 0) {
                        $no = 2;
                        $image_name = '';

                        while (true) {
                            $image_name = str_replace('.'. $image->getClientOriginalExtension(), '', $image->getClientOriginalName()) . '-' .$no . '.' . $image->getClientOriginalExtension();
                            if(Media::where('name', $image_name)->count() < 1) {
                            break;
                            }

                            $no++;
                        }
                    } else {
                        $image_name = $image->getClientOriginalName();
                    }

                    $upload_path = 'media';
                    $request->file('image')->move($upload_path, $image_name);
                    $template->image =  $image_name;
                    $media->name = $image_name;
                    $media->alt = $request->get('alt');
                    $media->save();
                }
            }
        } else {
            if ($request->hasFile('image')) {
                $image = $request->file('image');
                $ext = $image->getClientOriginalExtension();
                if ($request->file('image')->isValid()) {
                    $check_media = Media::where('name', str_replace('.' . $image->getClientOriginalExtension(), '', $image->getClientOriginalName()) . '.webp')->count();

                    if($check_media > 0) {
                        $no = 2;
                        $image_name = '';

                        while (true) {
                            $image_name = str_replace('.'. $image->getClientOriginalExtension(), '', $image->getClientOriginalName()) . '-' .$no . '.' . $image->getClientOriginalExtension();
                            $image_webp = str_replace('.'. $image->getClientOriginalExtension(), '', $image->getClientOriginalName()) . '-' .$no . '.webp';
                            if(Media::where('name', $image_webp)->count() < 1) {
                            break;
                            }

                            $no++;
                        }
                    } else {
                        $image_name = $image->getClientOriginalName();
                    }
                    $upload_path = 'media';
                    $request->file('image')->move($upload_path, $image_name);

                    if($ext == 'png') {
                        $img_new_a = imagecreatefrompng(public_path('media/' . $image_name));
                    } else {
                        $img_new_a = imagecreatefromjpeg(public_path('media/' . $image_name));
                    }

                    imagepalettetotruecolor($img_new_a);
                    imagealphablending($img_new_a, true);
                    imagesavealpha($img_new_a, true);
                    imagewebp($img_new_a, public_path('media/' . str_replace('.'.$ext, '.webp',$image_name)), 80);
                    imagedestroy($img_new_a);
                    unlink(public_path('media/' . $image_name));

                    
                    $template->image =  str_replace('.'.$ext, '.webp',$image_name);

                    $media->name = str_replace('.'.$ext, '.webp',$image_name);
                    $media->alt = $request->get('alt');
                    $media->save();
                }
            }
        }

        $template->save();
        return redirect()->route('site.template.index')->with('message', 'Data Successfully Added');

    }

    public function editTemplate($id_template) {
        $id = \Crypt::decrypt($id_template);
        $template = Template::findOrFail($id);
        $category = Template::distinct()->get(['category']);
        return view('site.edit-template', compact('template', 'category'));
    }

    public function updateTemplate(Request $request, $id) {
        $media = new Media();
        $save = $request->get('save');
        $template = Template::findOrFail($id);
        $template->name = $request->get('name');
        $template->slug = Str::slug($request->get('name'), '-');
        $template->category = $request->get('category');
        $template->dashboard = $request->get('dashboard');
        $template->description = $request->get('description');
        $template->link_demo = $request->get('link_demo');

        if($save == 'save-as') {
            if ($request->hasFile('image')) {
                $image = $request->file('image');
                // $ext = $image->getClientOriginalExtension();
                if ($request->file('image')->isValid()) {
                    // check if file exist

                    $check_media = Media::where('name', $image->getClientOriginalName())->count();

                    if($check_media > 0) {
                        $no = 2;
                        $image_name = '';

                        while (true) {
                            $image_name = str_replace('.'. $image->getClientOriginalExtension(), '', $image->getClientOriginalName()) . '-' .$no . '.' . $image->getClientOriginalExtension();
                            if(Media::where('name', $image_name)->count() < 1) {
                            break;
                            }

                            $no++;
                        }
                    } else {
                        $image_name = $image->getClientOriginalName();
                    }

                    $upload_path = 'media';
                    $request->file('image')->move($upload_path, $image_name);
                    $template->image =  $image_name;
                    $media->name = $image_name;
                    $media->alt = $request->get('alt');
                    $media->save();
                }
            } else {
                $old_media = Media::where('name', $template->image)->first();
                $old_media->alt = $request->get('alt');
                $old_media->save();
            }
        } else {
            if ($request->hasFile('image')) {
                $image = $request->file('image');
                $ext = $image->getClientOriginalExtension();
                if ($request->file('image')->isValid()) {
                    $check_media = Media::where('name', str_replace('.' . $image->getClientOriginalExtension(), '', $image->getClientOriginalName()) . '.webp')->count();

                    if($check_media > 0) {
                        $no = 2;
                        $image_name = '';

                        while (true) {
                            $image_name = str_replace('.'. $image->getClientOriginalExtension(), '', $image->getClientOriginalName()) . '-' .$no . '.' . $image->getClientOriginalExtension();
                            $image_webp = str_replace('.'. $image->getClientOriginalExtension(), '', $image->getClientOriginalName()) . '-' .$no . '.webp';
                            if(Media::where('name', $image_webp)->count() < 1) {
                            break;
                            }

                            $no++;
                        }
                    } else {
                        $image_name = $image->getClientOriginalName();
                    }
                    $upload_path = 'media';
                    $request->file('image')->move($upload_path, $image_name);

                    if($ext == 'png') {
                        $img_new_a = imagecreatefrompng(public_path('media/' . $image_name));
                    } else {
                        $img_new_a = imagecreatefromjpeg(public_path('media/' . $image_name));
                    }

                    imagepalettetotruecolor($img_new_a);
                    imagealphablending($img_new_a, true);
                    imagesavealpha($img_new_a, true);
                    imagewebp($img_new_a, public_path('media/' . str_replace('.'.$ext, '.webp',$image_name)), 80);
                    imagedestroy($img_new_a);
                    unlink(public_path('media/' . $image_name));

                    
                    $template->image =  str_replace('.'.$ext, '.webp',$image_name);

                    $media->name = str_replace('.'.$ext, '.webp',$image_name);
                    $media->alt = $request->get('alt');
                    $media->save();
                }
            } else {
                $old_media = Media::where('name', $template->image)->first();
                $old_media->alt = $request->get('alt');
                $old_media->save();
            }
        }

        $template->save();
        return redirect()->route('site.template.index')->with('message', 'Data Successfully Updated');
    }

    public function deleteTemplate(Request $request) {
        $template_id = $request->get('template_id');
        Template::destroy($template_id);
        return 'true';
    }

    private function checkAltMedia($image) {
        $media = Media::where('name', $image)->first();
        
        if($media) {
            return $media->alt;
        } else {
            return '';
        }
    }

    public static function checkAltMediaStatic($image) {
        $media = Media::where('name', $image)->first();
        
        if($media) {
            return $media->alt;
        } else {
            return '';
        }
    }

        public function updateseo(Request $request){

            $seo = SitePage::where('id', 1) -> update([
            'keyphrase' => $request -> focus_keyphrase,
            'seo_title' => $request -> seo_title,
            'meta_description' => $request -> meta_description,
        ]);
        return redirect()->route('layout.site')->with('message', 'SEO Successfully Updated');
    }

    

    
}