aonestar.public

Parameters

Name	Type	Mode
mealtype_id	integer	IN
included_adult	smallint	IN
included_child	smallint	IN
extra_adult	smallint	IN
extra_child	smallint	IN
inc_abf	money	OUT
inc_lunch	money	OUT
inc_dinner	money	OUT
ext_adult_abf	money	OUT
ext_adult_lunch	money	OUT
ext_adult_dinner	money	OUT
ext_child_abf	money	OUT
ext_child_lunch	money	OUT
ext_child_dinner	money	OUT
ext_abf	money	OUT
ext_lunch	money	OUT
ext_dinner	money	OUT
mealtype_id	integer	IN
included_adult	integer	IN
included_child	integer	IN
extra_adult	integer	IN
extra_child	integer	IN
inc_abf	money	OUT
inc_lunch	money	OUT
inc_dinner	money	OUT
ext_adult_abf	money	OUT
ext_adult_lunch	money	OUT
ext_adult_dinner	money	OUT
ext_child_abf	money	OUT
ext_child_lunch	money	OUT
ext_child_dinner	money	OUT
ext_abf	money	OUT
ext_lunch	money	OUT
ext_dinner	money	OUT

Definition

BEGIN
    RETURN QUERY
    SELECT 
        (COALESCE($2 * m.abf, 0) + COALESCE($3 * m.abf_child, 0))::money AS inc_abf,
        (COALESCE($2 * m.lunch, 0) + COALESCE($3 * m.lunch_child, 0))::money AS inc_lunch,
        (COALESCE($2 * m.dinner, 0) + COALESCE($3 * m.dinner_child, 0))::money AS inc_dinner,
        (COALESCE($4 * m.abf_extra_adult, 0))::money AS ext_adult_abf,
        (COALESCE($4 * m.lunch_extra_adult, 0))::money AS ext_adult_lunch,
        (COALESCE($4 * m.dinner_extra_adult, 0))::money AS ext_adult_dinner,
        (COALESCE($5 * m.abf_extra_child, 0))::money AS ext_child_abf,
        (COALESCE($5 * m.lunch_extra_child, 0))::money AS ext_child_lunch,
        (COALESCE($5 * m.dinner_extra_child, 0))::money AS ext_child_dinner,
        (COALESCE($4 * m.abf_extra_adult, 0) + COALESCE($5 * m.abf_extra_child, 0))::money AS ext_abf,
        (COALESCE($4 * m.lunch_extra_adult, 0) + COALESCE($5 * m.lunch_extra_child, 0))::money AS ext_lunch,
        (COALESCE($4 * m.dinner_extra_adult, 0) + COALESCE($5 * m.dinner_extra_child, 0))::money AS ext_dinner
    FROM meal_type m
    WHERE m.id = $1;
END;

sp_calc_meal_prices

Parameters

Definition