aonestar.public

Parameters

Name	Type	Mode
batch_id	integer	IN
only_active	boolean	IN (DEFAULT false)

Definition

DECLARE
    json_result jsonb;
    report_interfaces jsonb;
    report_group text;
    sql_text text;
BEGIN
    sql_text := format($SQL$
        SELECT public.sp_get_batch_report_details_js(%L, %L)::jsonb,
               COALESCE(
                   (
                       SELECT jsonb_object_agg(r.id::text, to_jsonb(r)->'interface_codes')
                       FROM public.reports r
                       WHERE to_jsonb(r)->>'interface_codes' IS NOT NULL
                   ),
                   '{}'::jsonb
               )
    $SQL$, batch_id, only_active);

SELECT result_data, interface_map
    INTO json_result, report_interfaces
    FROM dblink(fn_conn_authen(), sql_text)
         AS params(result_data jsonb, interface_map jsonb);

IF json_result IS NULL THEN
        RETURN NULL;
    END IF;

FOREACH report_group IN ARRAY ARRAY[
        'financial_reports',
        'reservation_reports',
        'registration_reports',
        'marketing_reports'
    ]
    LOOP
        json_result := jsonb_set(
            json_result,
            ARRAY[report_group],
            public.fn_filter_reports_by_enabled_interfaces(
                json_result->report_group,
                report_interfaces
            )
        );
    END LOOP;

RETURN json_result::json;
END;