Changes between Version 5 and Version 6 of DatabaseProgramming

Timestamp:

06/08/26 22:36:11 (10 days ago)

Author:

231116

Comment:

--

DatabaseProgramming

@@ -143 +143 @@
     $$ language plpgsql;
 }}}
-== Check if a room is available
-{{{
-create or replace function fn_is_room_available(p_room_id bigint,p_check_in_date date, p_check_out_date date)
-returns boolean
-language plpgsql
-as $$
-    begin
-        if p_check_in_date >= p_check_out_date then
-            return false;
-        end if;
-
-        if not exists(
-            select 1
-            from rooms r
-            where r.room_id = p_room_id
-            and r.status = 'ACTIVE'
-        )then
-            return false;
-        end if;
-
-        if exists(
-            select 1
-            from bookings b
-            where b.room_id = p_room_id
-            and b.booking_status in ('PENDING','CONFIRMED')
-            and daterange(b.check_in_date,b.check_out_date,'[)')
-            && daterange(p_check_in_date,p_check_out_date,'[)')
-        )then
-            return false;
-        end if;
-        return true;
-    end;
-    $$;
-}}}
+
 == Create timestamp
 {{{
@@ -284 +251 @@
             raise exception 'Check out must be after check in';
         end if;
-        v_nights := p_check_in_date - p_check_out_date;
+        v_nights := p_check_out_date - p_check_in_date;
         if p_guest_count > v_capacity + v_extra_capacity then
             raise exception 'Guest count exceeds';