aonestar.public

Parameters

Name	Type	Mode
rateplan_id	integer	IN
roomtype_id	integer	IN
arrival	date	IN
departure	date	IN
group_same_rates	boolean	IN (DEFAULT false)
result_code	text	OUT
result_msg	text	OUT
msg_code	text	OUT
rate_id	integer	OUT
rate_schedule	jsonb	OUT

Definition

DECLARE _rate_id int;
BEGIN
    /* RESULT CODE
       0, 10100 : Available 
       4, 10101 : All rooms were full 
       2, 10102 : Specified room type is not sellable (confirm user to make booking)
       4, 10103 : Specified room type not enough, overbook not allow
       2, 10104 : Specified room type not enough (confirm user to make booking)
       4, 10105 : Rate not found */
    
    result_code = '0'; result_msg = 'Success'; msg_code = '00';
   
    _rate_id = (SELECT rd.rate_id FROM rate_details rd WHERE rd.rateplan_id = $1 AND rd.roomtype_id = $2);

    WITH rates AS (
        SELECT start_date AS "date", rate_amount AS amount, stop_sell, cta, ctd, min_stay, max_stay, restricted  
        FROM sp_get_rate_schedule(_rate_id, $3, $4, $5)  
    )
    SELECT json_agg(rates) FROM rates
    INTO rate_schedule;
   
    rate_id = _rate_id;

    IF rate_schedule IS NULL THEN 
    	rate_id = null;
        rate_schedule = '[]';
        result_code = '4';
        msg_code = '10105';
        result_msg = sys_msg(msg_code, 'No available rates during this period');
    END IF;
END

sp_get_rate_schedule_js

Parameters

Definition