OwnerController.php

<?php

namespace App\Http\Controllers;

use App\RequestFasilitas;
use App\RequestHomestay;
use Illuminate\Http\Request;
use App\User;
use App\Owner;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\DB;

class OwnerController extends Controller
{

    public function index()
    {
        return view('adminlte::layouts.owner.home');
    }

    public function create()
    {
        //
    }

    public function requestFasilitas(){
        //dd('Masuk Gan');
        return view('adminlte::layouts.owner.RequestFasilitas');
    }

    public function storeRequest(Request $request){



        /*$data = DB::table('pemilikhomestay')
            ->join('pengajuan_homestay','pemilikhomestay.id','=','pengajuan_homestay.idPemilikHomestay')
            ->select('pemilikhomestay.nama','pengajuan_homestay.*')
            ->get();
*/

        $idPemilik = DB::table('users')
                    ->join('pemilikhomestay','users.id','=','pemilikhomestay.id_Akun')
                    ->select('pemilikhomestay.id')
                    ->where('users.id', '=', Auth::user()->id)
                    ->get();

        //dd($request['id_kategoriFasiltas']);

        $data = new RequestFasilitas();

        $data->id_pemilik_homestay = $idPemilik[0]->id;
        $data->id_kategoriFasiltas = $request['id_kategoriFasiltas'];
        $data->namaRequestFasilitas = $request['namaRequestFasilitas'];
        $data->deskripsi = $request['deskripsi'];
        $data->jumlah = $request['jumlah'];

        $data->save();

        //dd("Berhasil Gan");
    }

    public function pengajuan(){
        return view('adminlte::layouts.owner.PengajuanHomestay');
    }

    public function storePengajuan(Request $request){

        $idPemilik = DB::table('users')
            ->join('pemilikhomestay','users.id','=','pemilikhomestay.id_Akun')
            ->select('pemilikhomestay.id')
            ->where('users.id', '=', Auth::user()->id)
            ->get();

        $data = new RequestHomestay();

        $data->idPemilikHomestay  = $idPemilik[0]->id;
        $data->namaHomestay = $request['namaHomestay'];
        $data->jumlahKamar = $request['jumlahKamar'];
        $data->status = 0;

        $data->save();

        dd($request['namaHomestay'],$request['jumlahKamar']);
    }

    public function listPengajuan(){

        $idPemilik = DB::table('users')
            ->join('pemilikhomestay','users.id','=','pemilikhomestay.id_Akun')
            ->select('pemilikhomestay.id')
            ->where('users.id', '=', Auth::user()->id)
            ->get();
        //dd($idPemilik);
        $data = DB::table('pengajuan_homestay')
                ->join('pemilikhomestay','pengajuan_homestay.idPemilikHomestay','=','pemilikhomestay.id')
                ->select('pemilikhomestay.nama','pengajuan_homestay.*')
                ->where('pengajuan_homestay.idPemilikHomestay','=',$idPemilik[0]->id)
                ->get();

        $count = $data->count();

        return view('adminlte::layouts.owner.ListPengajuanHomestay')->with('data',$data)->with('count',$count);
    }

    public function listPengajuanFasilitas(){
        $idPemilik = DB::table('users')
            ->join('pemilikhomestay','users.id','=','pemilikhomestay.id_Akun')
            ->select('pemilikhomestay.id')
            ->where('users.id', '=', Auth::user()->id)
            ->get();

        $data = DB::table('requestfasilitas')
            ->join('pemilikhomestay','requestfasilitas.id_pemilik_homestay','=','pemilikhomestay.id')
            ->select('pemilikhomestay.nama','requestfasilitas.*')
            ->where('requestfasilitas.id_pemilik_homestay','=',$idPemilik[0]->id)
            ->get();

        $count = $data->count();

        return view('adminlte::layouts.owner.ListPengajuanFasilitas')->with('data',$data)->with('count',$count);
    }

    public function store(Request $request)
    {
        //
    }

    public function show($id)
    {
        //
    }

    public function edit($id)
    {
        //
    }

    public function destroy($id)
    {
        //
    }
}