GuestController.php

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Illuminate\Notifications\Messages\NexmoMessage;
use SimpleSoftwareIO\SMS\Drivers\NexmoSMS;
use Nexmo;
use App\Feedback;
use App\Homestay;
use App\ListBook;
use App\Room;
use App\Transaksi;
use Illuminate\Support\Facades\Auth;
use App\User;
use App\Customer;
use Illuminate\Support\Facades\DB;
use Illuminate\Contracts\Auth\Guard;
use DateTime;
use PhpParser\Node\Stmt\Const_;
use Psy\Command\ListCommand\ConstantEnumerator;
use Validator;


class GuestController extends Controller
{
    public function route(){

        Nexmo::message()->send([
            'to' => '6282272194654',
            'from' => 'ASDASD',
            'text' => 'Hi ini hanya sebuah test no more'
        ]);

        return view('welcome');
    }


    public function cari(Request $request){

        $data =  Homestay::all();
        //$a = null;

        //$book_start[] = null;

        $i = 0;
        foreach ($data as $a){

            $book_start = DB::table('daftar_book')
                ->select('daftar_book.*')
                ->where('daftar_book.tanggal_mulai','=',$request['tanggal_mulai'])
                ->get();

            $book_finish = DB::table('daftar_book')
                ->select('daftar_book.*')
                ->where('daftar_book.tanggal_berakhir','=',$request['tanggal_selesai'])
                ->get();

            if($book_start->count() > 0){
                dd($book_start);
                //dd($book_start[0]->jumlah_kamar);
            }else{
                if($book_finish->count() > 0){

                }else{
                    if($request['jumlah_Tamu'] > $request['jumlah_kamar'] * 2){
                        dd('ngak bisa');
                    }else{
                        $dataHomestay[$i] = DB::table('homestay')
                                            ->where('homestay.id','=',$a->id)
                                            ->get();
                    }
                }
            }
            $i++;
        }
//        $j=0;

//        //dd($dataHomestay[1][0]->nama_homestay);//,$dataHomestay[1]->nama_homestay,$dataHomestay[2]->nama_homestay);
//        foreach ($dataHomestay as $b){
//            echo $b[0]->nama_homestay;
//            //echo $j;
////            if($j==1){
////                dd($b[0]);
////            }
//            echo '<br>';
//            $j++;
//        }

        return view('searchhomestay')->with('data',$dataHomestay);
        //dd($i,$book_start[0],$book_start[1],$book_start[2],$book_finish[0],$book_finish[1],$book_finish[2]);
        //dd($request['tanggal_mulai'],$request['jumlah_hari'],$request['tanggal_selesai'],$request['jumlah_Tamu'],$request['jumlah_kamar']);
    }

    //Menyimpan data Pelanggan disaat melakukan Pendaftaran
    public function registerStore(Request $data){

      $validator = Validator::make($data->all(), [
          'name' => 'required',
          'username' => 'required',
          'email' => 'required|email',
          'password' => 'required',
      ], [
          'name.required' => 'Silahkan Masukkan Nama Lengkap!',
          'username.required' => 'Silahkan Masukkan Username!',
          'email.required' => 'Silahkan Masukkan Email!',
          'password.required' => 'Silahkan Masukkan Password!'
      ]);

      if ($validator->fails()) {
          return redirect('/daftar')->withErrors($validator->errors());
}else{
        $user = new User();
        $user->name  = $data['name'];
        $user->username = $data['username'];
        $user->email = $data['email'];
        $user->password = bcrypt($data['password']);
        $user->role = "Customer";
        $user->foto = "gravatar.png";

        $user->save();
        $dataPel = DB::table('users')
            ->select('users.id')
            ->where('users.username','=',$data['username'])
            ->get();

        $cus = new Customer();
        $cus->id_akun = $dataPel[0]->id;
        $cus->nama = $data['name'] ;
        $cus->alamat = "---";
        $cus->no_telepon = "---";
        $cus->pekerjaan = "---";

        $cus->save();

        return redirect('login');
      }
    }

    public function register(){
        return view('adminlte::auth.register');
    }

    public function detailhomestay($id){
        $data = DB::table('homestay')
            ->join('pemilikhomestay','homestay.id_pemilik','=','pemilikhomestay.id')
            ->select('pemilikhomestay.*','homestay.*')
            ->where('homestay.id','=',$id)
            ->get();

        $daftarBook = DB::table('daftar_book')
            ->select('daftar_book.*')
            ->where('daftar_book.homestay','=',$id)
            ->where('daftar_book.status','=',1)
            ->get();

        $now = new DateTime();
        $nowCurrent = $now->format('Y-m-d');

        $dataJumlahKamar = ListBook::all()->where('tanggal_mulai',$nowCurrent);

        $avilableRoom = 0;

        if($dataJumlahKamar->count() == null){
            $avilableRoom = $data[0]->jumlah_kamar;
        }else{
            $avilableRoom = $dataJumlahKamar[0]->jumlah_kamar;
        }

        $dataKamar = DB::table('kamar')
            ->select('kamar.*')
            ->where('kamar.id_homestay','=',$id)
            ->get();

        return view('adminlte::layouts.pages.Homestay')->with('data',$data[0])->with('daftarBook',$daftarBook)->with('dataKamar',$dataKamar)->with('avilable',$avilableRoom);
    }
}