One Hat Cyber Team

Your IP: 216.73.216.1
Server IP: 185.238.29.86
Server: Linux server2 6.8.12-6-pve #1 SMP PREEMPT_DYNAMIC PMX 6.8.12-6 (2024-12-19T19:05Z) x86_64
Server Software: nginx/1.18.0
PHP Version: 8.1.31
Buat File | Buat Folder

Dir : ~/var/www/muhasebe/modules/Hotel/Models/

View File Name : HotelRoomBooking.php

<?php

namespace Modules\Hotel\Models;

use App\BaseModel;
use Modules\Booking\Models\Booking;

class HotelRoomBooking extends BaseModel
{
    protected $table = 'bravo_hotel_room_bookings';

    public function scopeInRange($query,$start,$end){
        $query->where('bravo_hotel_room_bookings.start_date','<=',$end)->where('bravo_hotel_room_bookings.end_date','>',$start);
    }

    public function scopeActive($query)
    {
        return $query->join('bravo_bookings', function ($join) {
            $join->on('bravo_bookings.id', '=', $this->table . '.booking_id');
        })->whereNotIn('bravo_bookings.status', Booking::$notAcceptedStatus)->where('bravo_bookings.deleted_at', null);
    }

    public function room(){
        return $this->hasOne(HotelRoom::class,'id','room_id')->withDefault();
    }
    public function booking(){
    	return $this->belongsTo(Booking::class,'booking_id');
    }

    public static function getByBookingId($id){
        return parent::query()->where([
            'booking_id'=>$id
        ])->get();
    }
}