authen.public

Parameters

Name	Type	Mode
prop_code	text	IN
report_id	integer	IN
params	json	IN
file_path	text	IN
file_name	text	IN (DEFAULT NULL)
export_format	text	IN (DEFAULT 'pdf')
expire_secs	bigint	IN (DEFAULT (((7 * 24) * 60) * 60))
template_type	text	IN (DEFAULT NULL)
access_token	text	IN (DEFAULT NULL)

Definition

DECLARE 
    _content_type TEXT;
    _file_content bytea; 
    _file_path TEXT;
    _status int;
    _content text;
    gen_params jsonb;
    service_url text;
--'https://api.fromas.cloud/v2/pms/report/generate';
    result_json jsonb;
begin
    file_name  := coalesce(file_name, gen_random_uuid()||COALESCE('.'||export_format,''));
    _file_path := format('%s/%s/%s', lower(prop_code), trim('/' from file_path), file_name);
    access_token := coalesce(access_token, fn_get_config(prop_code, 'REPORT_GEN_TOKEN'));

    if (template_type is null) then
        select IIF(r.report_filename ilike '%.frx', 'frx', 'jrxml')
        from reports r
        where r.id = report_id
        into template_type;
    end if;

    if (template_type = 'frx') then
        gen_params := json_build_object(
              'report_id', report_id,
              'export_type', 'url',  
              'export_format', export_format,  
              's3_path', _file_path,  
              'url_expire', expire_secs, -- 7 days (maximum)  
              'params', params 
        ); 

        service_url := coalesce(fn_get_config(prop_code, 'API_URL', null), 'https://api.fromas.cloud')||'/v2/pms/report/generate';

        PERFORM http_set_curlopt('CURLOPT_CONNECTTIMEOUT', '20');
        PERFORM http_set_curlopt('CURLOPT_TIMEOUT', '30');

        raise notice 'Service URL: %', service_url;
        raise notice 'Token: %', sys.jwt_verify(access_token);
    
        Select resp.status, resp.content 
        from http(('POST', 
                   service_url, 
                   ARRAY[http_header('Authorization','Bearer '||access_token)], 
                   'application/json', 
                   gen_params::text)) as resp
        INTO _status, _content;
    
       -- PERFORM sp_raise_error_if(_status <> 200, 'Create report failed, '||_content);    
    
       -- raise notice '[%] %', _status, _content::json;
    
        if _status = 200 then
            result_json := _content::jsonb;
            if result_json->>'status' <> '200' then
                raise exception '%', result_json->>'message';
            else
                return result_json->>'data'; 
            end if;
           -- PERFORM sp_raise_error_if(result_json->>'status' <> '200', 'Create report failed, '||result_json->>'message');         
        else
            raise exception 'Create report failed, %', _content;
        end if;

    else /* Jasper Report */
        RETURN sp_gen_jasper_report_url(
                    prop_code, 
                    report_id, 
                    params, 
                    _file_path, 
                    expire_secs := least(expire_secs, 7*24*60*60), 
                    access_token := access_token
                );
    end if;
END

sp_gen_report_url

Parameters

Definition