<?php

namespace App\Http\Controllers;


use Illuminate\Http\Request;
use DB;
use App\Models\Slider;

// use CategoryProductModel;
use App\Models\Category;
use Session;
use Auth;
use App\Models\CatePost;
use App\Models\CatePost2;
use App\Models\Post;
use App\Http\Requests;
use Illuminate\Support\Facades\Redirect;

class CategoryPost extends Controller
{
	 public function AuthLogin() {
        $admin_id=session::get('admin_id');
        if($admin_id){
            return Redirect::to('dashboard');
        }
        else{
        return Redirect::to('admin')->send();
        }
    }

    public function add_category_post(){
        $this->AuthLogin();
    	return view('admin.category_post.add_category');
    }
	public function save_category_post(Request $request){
        $this->AuthLogin();
    	$data = $request->all();
    	$category_post = new CatePost();
    	$category_post->cate_post_name = $data['cate_post_name'];
    	$category_post->cate_post_slug = $data['cate_post_slug'];
    	$category_post->cate_post_desc = $data['cate_post_desc'];
    	$category_post->cate_post_status = $data['cate_post_status'];
    	$category_post->save();
    	Session::put('message','Thêm danh mục bài viết thành công');
    	return redirect()->back();
    }
    
    public function all_category_post(){
        $this->AuthLogin();

        $category_post = CatePost::orderBy('cate_post_id','DESC')->paginate(5);

    	return view('admin/category_post/list_category')->with(compact('category_post'));

    }
  
    public function edit_category_post($category_post_id){
        $this->AuthLogin();

      	$category_post = CatePost::find($category_post_id);

        return view('admin.category_post.edit_category')->with(compact('category_post'));
    }
    public function update_category_post(Request $request, $cate_id){
        $this->AuthLogin();
    	$data = $request->all();
    	$category_post = CatePost::find($cate_id);
    	$category_post->cate_post_name = $data['cate_post_name'];
    	$category_post->cate_post_slug = $data['cate_post_slug'];
    	$category_post->cate_post_desc = $data['cate_post_desc'];
    	$category_post->cate_post_status = $data['cate_post_status'];
    	$category_post->save();
    	Session::put('message','Cập nhật danh mục bài viết thành công');
    	return redirect('/all-category-post');
    }

   	public function delete_category_post($cate_id){
   		$category_post = CatePost::find($cate_id);
   		$category_post->delete();
    	Session::put('message','Xóa danh mục bài viết thành công');
    	return redirect()->back();

   	}
  
//them loại danh mục bật 2 
        public function add_categorypost(){

        
        $categorypost=CatePost2::orderby('categorypost_id','DESC')->get();

        $catepost=CatePost::orderby('cate_post_id','DESC')->get(); 

        return view('admin.category_post.add_category_post')->with(compact('categorypost','catepost'));


    // hien thi toan bo danh muc 
    }
        public function all_categorypost(){
            $this->AuthLogin();
         $cate_all_post=CatePost2::with('catepost')->orderBy('cate_post_id')->get();
         $catepost1=CatePost::orderby('cate_post_id','DESC')->get();    
         $all_category_post=CatePost2::orderby('categorypost_id','DESC')->get();    
         return view('admin.category_post.all_category_post')->with(compact('all_category_post','catepost1','cate_all_post'));
        //$all_category_product= DB::table('tbl_category_product')->orderby('category_id','desc')->get();
        // $manager_category_product = view('admin.all_category_product')->with('all_category_product',$all_category_product);

        
    }
        public function save_categorypost(Request $Request){
            $this->AuthLogin();

        $data=$Request->all();
        $Categorypost=new CatePost2();
        $Categorypost->categorypost_name=$data['categorypost_name']; 
        $Categorypost->categorypost_slug=$data['categorypost_slug'];
        $Categorypost->categorypost_desc=$data['categorypost_desc'];
        $Categorypost->categorypost_status=$data['categorypost_status'];
        $Categorypost->cate_post_id=$data['cate_post'];
        $Categorypost->meta_keywords=$data['categorypost_keywords'];
        $get_image=$Request->file('categorypost_image');
        if ($get_image){
        $get_name_image = $get_image->getClientOriginalName(); //lay ten của hình ảnh
        $name_image = current(explode('.',$get_name_image));
        $new_image =  $name_image.rand(0,99).'.'.$get_image->getClientOriginalExtension();
        $get_image->move('public/uploads/post',$new_image);
        $Categorypost->categorypost_image =$new_image;
        $Categorypost->save(); 
        // $data=array();
        // $data['category_name']=$Request->category_product_name;
        // $data['category_desc']=$Request->category_product_desc;
        // $data['slug_category_product']=$Request->slug_category_product;
        // $data['meta_keywords']=$Request->category_product_keywords;
        // $data['category_status']=$Request->category_product_status;
       // DB::table('tbl_category_product')->insert($data);
        Session::put('message', 'Thêm danh mục sản phẩm thành công');
        return Redirect::to('/all-categorypost');

    }

 

    


}


//chinh sua danh muc 
      public function edit_categorypost($categorypost_id){
        $this->AuthLogin();
        $catepost=CatePost::orderby('cate_post_id')->get();  
        $categorypost=Catepost2::find($categorypost_id);  
        $edit_categorypost=Catepost2::find($categorypost_id);
        return view('admin.category_post.edit_category_post')->with(compact('edit_categorypost','categorypost','catepost'));
        // $edit_category_product= DB::table('tbl_category_product')->where('category_id',$category_product_id)->get();
        //$manager_category_product = view('admin.edit_category_product')->with('edit_category_product',$edit_category_product);
         //return view('admin_layout')->with('admin.edit_category_product', $manager_category_product);
         //
         
    } 

     //kich hoat trang thai 
       
      public function unactive_categorypost($categorypost_id){
            $this->AuthLogin();
DB::table('tbl_categorypost')->where('categorypost_id',$categorypost_id)->update(['categorypost_status'=>1]);
Session::put('message', 'Không kích hoạt thành công trạng thái');
        return Redirect::to('/all-categorypost');
    }
         //kich hoat trang thai 
         public function active_categorypost($categorypost_id){
            $this->AuthLogin();

    DB::table('tbl_categorypost')->where('categorypost_id',$categorypost_id)->update(['categorypost_status'=>0]);
Session::put('message', 'Không kích hoạt thành công trạng thái');
        return Redirect::to('/all-categorypost');
    }
    

     



    //cap nhat danh muc 
    public function update_categorypost(Request $Request,$categorypost_id){
        $this->AuthLogin();
        $data=$Request->all();
        $Categorypost=CatePost2::find($categorypost_id);
        $Categorypost->categorypost_name=$data['categorypost_name']; 
        $Categorypost->categorypost_desc=$data['categorypost_desc'];
        $Categorypost->categorypost_slug=$data['categorypost_slug'];
        $Categorypost->cate_post_id=$data['cate_post_id'];
        $Categorypost->meta_keywords=$data['categorypost_keywords'];
        $get_image=$Request->file('categorypost_image');

        if($get_image){
            //xoa anh cu
            $post_image_old = $Categorypost->categorypost_image;
            $path ='public/uploads/post/'.$post_image_old;
            unlink($path);
            //cap nhat anh moi
            $get_name_image = $get_image->getClientOriginalName(); //lay ten của hình ảnh
            $name_image = current(explode('.',$get_name_image));
            $new_image =  $name_image.rand(0,99).'.'.$get_image->getClientOriginalExtension();
            $get_image->move('public/uploads/post',$new_image);
            $Categorypost->categorypost_image = $new_image; 
        }

        $Categorypost->save();

        // $data=array();
        // $data['category_name']=$Request->category_product_name;
        // $data['category_desc']=$Request->category_product_desc;
        // $data['slug_category_product']=$Request->slug_category_product;
        // $data['meta_keywords']=$Request->category_product_keywords;
        
        // DB::table('tbl_category_product')->where('category_id',$category_product_id)->update($data);
        Session::put('message', 'cập nhật thành công');
        return redirect('/all-categorypost');
    }  

    //xoa danh muc  
     public function delete_categorypost($categorypost_id) {
        $this->AuthLogin();
        $categorypost=CatePost2::find($categorypost_id);
        unlink('public/uploads/post/'.$categorypost->categorypost_image);
        $categorypost->delete();

    // DB::table('tbl_category_product')->where('category_id',$category_product_id)->delete();
        Session::put('message', 'xóa thành thành công');
        return Redirect::to('/all-categorypost');
     }  

}