authen.public

Parameters

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

Definition

declare 
    v_file_name text;
    v_file_path text;
    v_file_content bytea;
    v_content_type text;
begin
    v_file_name  := gen_random_uuid()||COALESCE('.'||export_format,'');
    v_file_path := format('%s/%s/%s', lower(prop_code), trim('/' from file_path), v_file_name);

    SELECT content_type, file_content 
    FROM sp_gen_jasper_report_file(prop_code, report_id, params, export_format, access_token) 
    --FROM sp_gen_report_file(prop_code, report_id, params, export_format, access_token) 
    INTO v_content_type, v_file_content;

    raise notice 'content type: %, size: %', v_content_type, octet_length(v_file_content);
       
    IF v_content_type = 'application/pdf' THEN
        -- Maximum expire duration for DigitalOcean Space's URL is 7 days
        expire_secs := least(expire_secs, 7*24*60*60); 
        RETURN doc.s3_upload_file(v_file_path, v_file_content, v_content_type, url_expire_secs=>expire_secs);
    ELSE
        PERFORM sys.log_error('sp_gen_jasper_report_url', 'Invalid content type ('||v_content_type||')');
        --IF (v_content_type = 'application/json') or (v_content_type like 'text/%') THEN
            raise notice 'Content: %', convert_from(v_file_content, 'UTF8');
        --END IF;
        RETURN NULL;    
    END IF;
end