<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use App\Models\Product;
use App\Models\Category;
use App\Models\Admin_user;
use App\Models\Main_category;
use App\Models\Blog;
use File;

class BlogController extends Controller
{
    
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index(Request $request)
    {
        $data['mainMenu'] = 'blogManagement';
        $data['subMenu'] = 'blogList';
        
        $admin_id = $request->session()->get('loggedIn')['id']; 
        if( isset($_GET['query']) && strlen($_GET['query']) > 1){

            $search_text = $_GET['query'];
            // dd($search_text);
            $data['blogs'] = DB::table('blogs')->where('blog_title','LIKE','%'.$search_text.'%')->paginate(10);         
           
            
        }else{
            $data['blogs'] = DB::table('blogs')->paginate(10);          
        }
        
        return view('admin.blog.blog-list',$data);

        
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create(Request $request)
    {
        $admin_id = $request->session()->get('loggedIn')['id']; 
        $data['mainMenu'] = 'blogManagement';
        $data['subMenu'] = 'blogList';
       
        $data['categories'] = Main_category::where(['admin_id'=>$admin_id,'parent_id'=>0])->get();
        $data['teachers'] = Admin_user::where(['role_id'=>7])->get();
        return view('admin.blog.add-blog',$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([
            'selectCatId'=>'required',
            'blog_title'=>'required',
            'short_desc'=>'required',
            'description'=>'required',          
            'teacher_id'=>'required',
            'image'=>'required|image|mimes:jpeg,png,jpg,gif,svg',
        ]);

        
        $imageName = time().rand().'.'.$request->image->extension();  
     
        $request->image->move(public_path('uploads/blog'), $imageName);

        // dd($imageName);

        $slug =  str_replace(' ', '-', strtolower($request->blog_title));
        $_sortOrder = Blog::get()->last();
        if(empty($_sortOrder))
        {
            $sort_order = 1;
        }else{
           $sort_order =  $_sortOrder->sort_order +1;
        }
        
        // dd($request->selectCatId);

        $data = array(

            
            'cat_id'=>$request->selectCatId,
            'blog_title'=>$request->blog_title,           
            'short_desc'=>$request->short_desc,
            'description'=>$request->description,         
            'author'=>$request->teacher_id,
            'image'=>$imageName,
            'slug'=>$slug,
            'sort_order'=>$sort_order,
            'status'=>"1",
            
        );

        // dd($data);


        $res = Blog::create($data);
        if($res)
        {
            return back()
            ->with('success', $request->blog_title.' 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'] = 'blogManagement';
        $data['subMenu'] = 'blogList';

        $data['blog'] = Blog::where(['id'=>$id])->first();
        return view('admin.blog.view-blog',$data);
    }

    /**
     * Show the form for editing the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function edit($id)
    {
        $admin_id = 2;
        $data['mainMenu'] = 'blogManagement';
        $data['subMenu'] = 'blogList';

        $data['blog'] = Blog::where(['id'=>$id])->first();
        $data['teachers'] = Admin_user::where(['role_id'=>7])->get();
        $data['categories'] = Main_category::where(['admin_id'=>$admin_id,'parent_id'=>0])->get();
        return view('admin.blog.edit-blog',$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)
    {
        // dd($request->input());
        $admin_id = $request->session()->get('loggedIn')['id']; 
       
        $blog = Blog::where(['id'=>$id])->first();

        // dd($request->image);
        if(!empty($request->image))
        {
            $request->validate([
                'category'=>'required',
                'blog_title'=>'required',
                'short_desc'=>'required',
                'description'=>'required',          
                'teacher_id'=>'required',
                'sort_order'=>'required',
                'image'=>'required|image|mimes:jpeg,png,jpg,gif,svg',
            ]);

            if(File::exists(public_path('uploads/blog/'.$blog->image))){

                File::delete(public_path('uploads/blog/'.$blog->image));
    
            }


            $imageName = time().rand().'.'.$request->image->extension();    
            $request->image->move(public_path('uploads/blog'), $imageName);

            $data = array(

                'cat_id'=>$request->category,
                'blog_title'=>$request->blog_title,           
                'short_desc'=>$request->short_desc,
                'description'=>$request->description,         
                'author'=>$request->teacher_id,
                'sort_order'=>$request->sort_order,
                'image'=>$imageName,
               
                'status'=>"1",
                
            );
    
            $res = Blog::where(['id'=>$id])->update($data);
            if($res)
            {
                return back()
                ->with('success', $request->blog_title.' Has Been Added!.');
                
                
                
            }else{
                return back()
                ->with('error','Something Went Wrong!');
            }

        }

        if(empty($request->image))
        {
            // dd($request->input());
            $request->validate([
                'category'=>'required',
                'blog_title'=>'required',
                'short_desc'=>'required',
                'description'=>'required',          
                'teacher_id'=>'required',
                'sort_order'=>'required',
              
                
            ]);


            $data = array(

                'cat_id'=>$request->category,
                'blog_title'=>$request->blog_title,           
                'short_desc'=>$request->short_desc,
                'description'=>$request->description,         
                'author'=>$request->teacher_id,
                'sort_order'=>$request->sort_order,
                'status'=>"1",
                
            );

            // dd($data);
    
            $res = Blog::where(['id'=>$id])->update($data);
            if($res)
            {
                return back()
                ->with('success', $request->blog_title.' 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)
    {
        $delete = Blog::where(['id'=>$id])->first();
        
        if(File::exists(public_path('uploads/blog/'.$delete->image))){

            File::delete(public_path('uploads/blog/'.$delete->image));

        }
        Blog::where(['id'=>$id])->delete();
         return back()->with('success','Blog deleted successfully');
    }
}