<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Models\Product;
use App\Models\Gallery;
use App\Models\Attr;
use DB;
use File;
use App\Models\Url;
use Session;
use Illuminate\Support\Facades\Redirect; 

class AttrController extends Controller
{
    public function add_attr($product_id){

    $pro_id=$product_id;  
    $product=Product::where('product_id',$product_id)->orderby('product_id','DESC')->get();  
    $all_attr=Attr::where('product_id',$product_id)->with('product')->get();
    return view ('admin.attr.add_attr')->with(compact('pro_id','all_attr','product'));

   } 

   public function save_attr(Request $Request,$pro_id){

        $data=$Request->all();
        
       
        $attr=new Attr();
        $attr->product_id=$pro_id;
        $attr->product_sku=$data['product_sku']; 
        $attr->product_size=$data['product_size'];
        $attr->product_name_attr=$data['product_name_attr'];
        // $attr->product_age=$data['product_age'];
        $attr->product_color=$data['product_color'];
        // $attr->product_alco=$data['product_alco'];
        $attr->product_price=$data['product_price'];
        $attr->product_quantity=$data['product_quantity'];
        
        $get_image=$Request->file('product_image');
        $path='public/uploads/product/';
        $path_gallery='public/uploads/gallery/';
        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/product',$new_image);
        file::copy($path.$new_image,$path_gallery.$new_image);

         $attr->product_image =$new_image;

        $attr->save(); 
        $data = Attr::latest()->first();
        $pro1_id=$data->product_id;


             $gallery=new Gallery();
             $gallery->gallery_image=$new_image;
             $gallery->gallery_name=$new_image;
             $gallery->product_id=$pro1_id;
             $gallery->timestamps=false;
             $gallery->save();

        Session::put('message', 'Thêm danh mục sản phẩm thành công');
        return Redirect('/add-attr/'.$pro_id);
       
     }

        
     }


     public function selete_size_product(Request $request)

    {
      $data=$request->all();

    $all_attr=Attr::where('attr_id',$data['attr_id'])->get();
    $output='';
    $output1='';
    foreach ($all_attr as $key => $attr ){

    $output.='<input type="hidden"  value="'.$attr->product_price.'" class="cart_product_price_'.$attr->product_id.'">';
    $output.='<input type="hidden"  value="'.$attr->product_sku.'" class="cart_product_sku_'.$attr->product_id.'">';  
    $output.='<input type="hidden"  value="'.$attr->product_image.'" class="cart_product_image_'.$attr->product_id.'">';

    $output1.= ' <img id="img_zoom" data-zoom-image="http://localhost:8080/shopruou/public/uploads/product/'.$attr->product_image.'" src="http://localhost:8080/shopruou/public/uploads/product/'.$attr->product_image.'" alt="">';
    
       // echo number_format($attr->product_price).' '.'VNĐ',  $attr->product_quantity ;
      // 
      $returnattr = [number_format($attr->product_price).' '.'VNĐ' ,$attr->product_sku, $attr->product_quantity,$output,$output1];
      echo json_encode($returnattr);
     // echo $output;

        }
    }

    // public function delete_attr($attr_id) {
    //     Attr::where('attr_id',$attr_id)->delete();

    // // DB::table('tbl_product_attr')->where('attr_id',$attr_id)->delete();
    //     Session::put('message', 'xóa thành thành công');
    //     return Redirect::to('/add-attr/{}');
    //  } 
    //  
    public function delete_attr(Request $request){

      $attr_id=$request->attr_id;
      $attr=Attr::find($attr_id); 
        unlink('public/uploads/product/'.$attr->product_image);  
      $attr->delete();
   }

    public function update_attr_name (Request $request){


   $attr_id =$request->attr_id;
   $attr_text=$request->attr_text;
   $attr = Attr::find($attr_id);
   $attr->product_size = $attr_text;
   $attr->timestamps= false;
   $attr->save();
      
   //  }
   
    }
  

      public function edit_attr($attr_id){
      
     $edit_attr= Attr::where('attr_id',$attr_id)->get();             

    return view('admin.attr.edit_attr')->with(compact('edit_attr'));


    } 


    public function update_attr(Request $Request, $attr_id){
        $data=$Request->all();


        $attr=Attr::find($attr_id);
        $attr->product_sku=$data['product_sku']; 
        $attr->product_size=$data['product_size'];
        $attr->product_name_attr=$data['product_name_attr'];
        // $attr->product_age=$data['product_age'];
        $attr->product_color=$data['product_color'];
        // $attr->product_alco=$data['product_alco'];
        $attr->product_price=$data['product_price'];
        $attr->product_quantity=$data['product_quantity'];
        
        $get_image=$Request->file('product_image');
        $path='public/uploads/product/';
        $path_gallery='public/uploads/gallery/';
        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/product',$new_image);
        file::copy($path.$new_image,$path_gallery.$new_image);

        $attr->product_image =$new_image;
        $attr->save(); 
         $data = Attr::latest()->first();
        $pro1_id=$data->product_id;


             $gallery=Gallery::where('product_id',$pro1_id)->first();

             $gallery->gallery_image=$new_image;
             $gallery->gallery_name=$new_image;
             // $gallery->product_id=$pro1_id;
             $gallery->timestamps=false;
             $gallery->save();
        Session::put('message', 'cập nhật phẩm thành công');
        return Redirect('/add-attr/'.$pro1_id);
        }

        else{


        $image=Attr::where('attr_id',$attr_id)->get();

          foreach ($image as $key =>$image1){

        $attr->product_image =$image1->product_image;
        $pro_id = $image1->product_id;

                }

        
        $attr->save(); 
        Session::put('message', 'cập nhật phẩm thành công');
       return Redirect('/add-attr/'.$pro_id);
        }
        
        } 
      
     



}