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');
    }

    //{id}/{tm}/{lm}/{ts}/{jt}/{jk}

    public function homestay($id,$tm,$lm,$ts,$jt,$jk){

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

        //dd($data);

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


        return view('adminlte::layouts.pages.detilSHomestay')->with('data',$data[0])->with('tm',$tm)->with('lm',$lm)->with('ts',$ts)->with('jt',$jt)->with('jk',$jk)->with('dataKamar',$dataKamar);
    }

    public function cari(Request $request){

        $data =  Homestay::all();

        $dataBook = ListBook::all();

        $tanggal_mulai = $request['tanggal_mulai'];
        $jumlah_hari = $request['jumlah_hari'];
        $tanggal_selesai = $request['tanggal_selesai'];
        $jumlah_Tamu = $request['jumlah_Tamu'];
        $jumlah_kamar =  $request['jumlah_kamar'];
        //$book_start[] = null;
        $dataHomestay[] =  null;
        $i = 0;


        //Melakukan Looping pengecekan Homestay yang avilable
        foreach ($data as $a){

            $tm = explode('-',$request['tanggal_mulai']);
            $ts = explode('-',$request['tanggal_selesai']);
            $counter = 0;
            $j=0;
            //Mencocokkan data pesanan untuk mendapat current room avilable
            foreach ($dataBook as $db){

                $ldbm = explode('-',$db->tanggal_mulai);
                $ldbs = explode('-',$db->tanggal_berakhir);

                if($tm[1]==$ts[1]){
                    if($tm[1] == $ldbm[1] && $ts[1] == $ldbs[1]){
                        if(($tm[2] >= $ldbm[2]  && $tm[2] <= $ldbs[2] ) && ($ts[2] >= $ldbm[2] && $ts[2]<= $ldbs[2]) ){
                            //dd('beriirisan total');
                            $dataCurrent[$j] = $db->id;
                            $counter +=1;
                            $j++;
                            echo 'beririsan';
                        }
                        else if(($tm[2] < $ldbm[2]  && $tm[2] <= $ldbs[2] ) && ($ts[2] >= $ldbm[2] && $ts[2]<= $ldbs[2])){
                            $dataCurrent[$j] = $db->id;
                            $counter +=1;
                            $j++;
                            echo 'beririsan sebagian batas atas';
                            //dd('beririsan sebagian batas atas');
                        }else if(($tm[2] >= $ldbm[2]  && $tm[2] <= $ldbs[2] ) && ($ts[2] >= $ldbm[2] && $ts[2] > $ldbs[2])){
                            $dataCurrent[$j] = $db->id;
                            $counter +=1;
                            $j++;
                            echo 'beririsan sebagian batas bawah';
                            //dd('beririsan sebagian batas bawah');
                        }
                    }
                }else if($tm[1] < $ts[1]){
                    dd('jangan dulu');
                }

            }

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

                $currentKamar = null;

                //$dataKamarHomestay = ListBook::find(14);
                //dd($dataKamarHomestay);
                //dd($dataCurrent);

                for ($l = 0; $l<$counter;$l++){
                   // echo $dataCurrent[$l];
                    $dataKamarHomestay[$l] = DB::table('daftar_book')
                                            ->where('daftar_book.id','=',$dataCurrent[$l])
                                            //->where('daftar_book.homestay','=',$a->id)
                                            ->get();

                    if ($dataKamarHomestay[$l][0]->homestay == $a->id){
                        $currentKamar = ($a->jumlah_kamar - $dataKamarHomestay[$l][0]->jumlah_kamar) - $currentKamar;
                    }else{
                        $currentKamar = $a->jumlah_kamar;
                    }
                }
                //dd($dataKamarHomestay[1][0]->homestay);


                //dd($dataKamarHomestay);
               // echo $currentKamar;
                //dd('asd');
                if($request['jumlah_kamar'] <= $currentKamar){
                    if($request['jumlah_Tamu'] <= ($request['jumlah_kamar']*2)*2){
                        $dataHomestay[$i] = DB::table('homestay')
                            ->where('homestay.id','=',$a->id)
                            ->get();
                    }
                }
            }
            $i++;
        }

        //dd($dataHomestay);

        if($dataHomestay == null){
            dd('salah');
            return redirect('')->with('message','Jumlah Kamar yang Avilable tidak mencukupi');
        }
        if($dataHomestay[0] == null){
            return redirect('')->with('message','Jumlah Kamar yang Avilable tidak mencukupi');
            dd('salah');
        }

        //dd('benar');

        return view('searchhomestay')->with('data',$dataHomestay)
                                     ->with('tm',$tanggal_mulai)
                                     ->with('lm',$jumlah_hari)
                                     ->with('ts',$tanggal_selesai)
                                     ->with('jt',$jumlah_Tamu)
                                     ->with('jk',$jumlah_kamar);
        //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);
    }
}