BookingSeatSchedulesRepository.php - dathalongbay/notes GitHub Wiki

<?php
namespace App\Repositories\Eloquents;

use Illuminate\Support\Facades\DB;

class BookingSeatSchedulesRepository extends BaseEloquentRepository
{
    public function __construct()
    {
        parent::__construct();
    }

    public function model(){
        return 'App\Models\BookingSeatSchedules';
    }


    public function getBookingSeatSchedulesBySource($restaurantCode, $source, $nextTime = true){
        $query = DB::table('booking_seat_schedules')
            ->where('restaurant_code', '=', $restaurantCode)
            ->where('source', '=', $source);

        if ($nextTime) {
            $query->where('end_time', '>', date("Y-m-d H:i:s"));
        }

        $data = $query->get();

        return $data;
    }


    public static function findBookingSchedules($restaurantCode, $source) {

        $query = DB::table('booking_seat_schedules')
            ->where('restaurant_code', '=', $restaurantCode)
            ->where('source', '=', $source);

        $now = date("Y-m-d H:i:s");
        $query->where('start_time', '<=', $now);
        $query->where('end_time', '>=', $now);

        $data = $query->first();

        return $data;
    }
}