<?php

namespace App\Http\Controllers;
use Illuminate\Support\Facades\DB;
use Illuminate\Http\Request;
use App\M_buku;
use App\m_rak;
use App\M_penulis;
use App\J_buku;
use File;

class C_buku extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Ressponse
     */
    public function index(request $request)
    {

        $mainlink = "/anggota";
        $namelink = 'Anggota';
        $isiutama = "Detail Anggota";
        $raks=m_rak::all();
        $penulis=M_penulis::all();
        $jbuku=J_buku::all();
        $bukuu=DB::table('buku')
        ->join('rak_buku','rak_buku.id_rak','=','buku.id_rak')
        ->join('penulis','penulis.id_penulis','=','buku.id_penulis')
        ->select('buku.*','rak_buku.lokasi','penulis.nama_penulis');

        $bukuu->appends($request->only('cari'));
        return view ('master.buku.buku',compact('bukuu','raks','penulis','jbuku','mainlink','namelink','isiutama'));

        //$bukuu=M_buku::all();
        //return view('master.buku.buku',compact('bukuu'));
        //$bukuu=DB::table('buku')
        //->join('rak_buku','rak_buku.id_rak','=','buku.id_rak')
        //->join('penulis','penulis.id_penulis','=','buku.id_penulis')
        //->select('buku.*','rak_buku.lokasi','penulis.nama_penulis')
        //->paginate(10);
        //return view('master.buku.buku',compact('bukuu','raks','penulis','jbuku'));
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        //
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {
       $this->validate($request,[
            'frm_jdl'=>'required',
            'frm_pnrb'=>'required',
            'frm_tht'=>'required',
            'frm_jb'=>'required',
            'frm_idr'=>'required',
            'frm_idp'=>'required',
            'frm_img'=> 'required'
        ]);
        $image = $request->file('frm_img');
        //Mengubah nama File menjadi random
        $new_name = rand() . '.' . $image->getclientoriginalextension();
        //Memindahkan file ke folder image dengan nama yang tadi sudah diacak
        $image->move(public_path('images'), $new_name);

        M_buku::create([
            'judul_buku' => request('frm_jdl'),
            'penerbit' => request('frm_pnrb'),
            'tahun_terbit' => request('frm_tht'),
            'jenis_buku' => request('frm_jb'),
            'id_rak' => request('frm_idr'),
            'id_penulis' => request('frm_idp'),
            'gambar'=> $new_name
        ]);
        return redirect('/buku')->with('success','Data Berhasil Ditambahkan');
    }
    public function __construct()
    {
        $this->middleware('auth');
    }


    /**
     * Display the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function show($id)
    {
        //$detail = DB::table('buku')->where('id_buku', $id)->first();
         //$detail=M_penulis::find($id);
        // return view('master.rak.detailrak')->with('detail',$detail);
        $detail=DB::table('buku')
        ->join('rak_buku','rak_buku.id_rak','=','buku.id_rak')
        ->join('penulis','penulis.id_penulis','=','buku.id_penulis')
        ->select('buku.*','rak_buku.lokasi','penulis.nama_penulis')
        ->where('id_buku',$id)->first();
        return view('master.buku.detailbuku',['detail' => $detail]);
    }

    /**
     * Show the form for editing the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function edit($id)
    {
        $raks=m_rak::all();
        $penulis=M_penulis::all();
        $jbuku=J_buku::all();
        $edits = DB::table('buku')
        ->join('rak_buku','rak_buku.id_rak','=','buku.id_rak')
        ->join('penulis','penulis.id_penulis','=','buku.id_penulis')
        ->select('buku.*','rak_buku.lokasi','penulis.nama_penulis')
        ->where('id_buku',$id)->first();
        return view ('master.buku.editbuku',compact('edits','raks','penulis','jbuku'));
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, $id)
    {
        $this->validate($request,[
            'frm_jdl'=>'required',
            'frm_pnrb'=>'required',
            'frm_tht'=>'required',
            'frm_jb'=>'required',
            'frm_idr'=>'required',
            'frm_idp'=>'required',
            ''
        ]);
            if ($request->has('frm_img')){
                #Hapus File Gambar dari folder images
            $gambar = M_buku::where('id_buku',$id)->first();
            file::delete('images/'.$gambar->gambar);
            #tambahkan foto yang baru
            $image = $request->file('frm_img');
            //Mengubah nama File menjadi random
            $new_name = rand() . '.' . $image->getClientOriginalExtension();
            //Memindahkan file ke folder image dengan nama yang tadi sudah diacak
            $image->move(public_path('images'), $new_name);
            M_buku::where('id_buku',$id)->update([
                'judul_buku' => request('frm_jdl'),
                'penerbit' => request('frm_pnrb'),
                'tahun_terbit' => request('frm_tht'),
                'jenis_buku' => request('frm_jb'),
                'id_rak' => request('frm_idr'),
                'id_penulis' => request('frm_idp'),
                'gambar'=> $new_name
            ]);
            }else{
                M_buku::where('id_buku',$id)->update([
                    'judul_buku' => request('frm_jdl'),
                    'penerbit' => request('frm_pnrb'),
                    'tahun_terbit' => request('frm_tht'),
                    'jenis_buku' => request('frm_jb'),
                    'id_rak' => request('frm_idr'),
                    'id_penulis' => request('frm_idp')
                    ]);
            }
        // if (empty($request->frm_image)){

        // M_buku::where('id_buku',$id)->update([
        //     'judul_buku' => request('frm_jdl'),
        //     'penerbit' => request('frm_pnrb'),
        //     'tahun_terbit' => request('frm_tht'),
        //     'jenis_buku' => request('frm_jb'),
        //     'id_rak' => request('frm_idr'),
        //     'id_penulis' => request('frm_idp')
        // ]);
        // }else{
        //     #Hapus File Gambar dari folder images
        //     $gambar = M_buku::where('id_buku',$id)->first();
        //     file::delete('images/'.$gambar->gambar);
        //     #tambahkan foto yang baru
        //     $image = $request->file('frm_img');
        //     //Mengubah nama File menjadi random
        //     $new_name = rand() . '.' . $image->getclientoriginalextension();
        //     //Memindahkan file ke folder image dengan nama yang tadi sudah diacak
        //     $image->move(public_path('images'), $new_name);
        //     M_buku::create([
        //         'judul_buku' => request('frm_jdl'),
        //         'penerbit' => request('frm_pnrb'),
        //         'tahun_terbit' => request('frm_tht'),
        //         'jenis_buku' => request('frm_jb'),
        //         'id_rak' => request('frm_idr'),
        //         'id_penulis' => request('frm_idp'),
        //         'gambar'=> $new_name
        //     ]);
        // }

        return redirect('/buku')->with('success','Data Berhasil Diubah');
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function destroy($id)
    {

        //Hapus Gambar di file
        $gambar = M_buku::where('id_buku',$id)->first();
        file::delete('images/'.$gambar->gambar);
        #$gambar->delete(public_path('images/'.$gambar->gambar));
        //hapus data di database
        M_buku::where('id_buku',$id)->delete();
        return redirect('/buku')->with('success','Data Berhasil Dihapus');
    }
}