authen.public

Parameters

Name	Type	Mode
prop_code	text	IN
report_id	integer	IN
params	json	IN
export_format	text	IN (DEFAULT 'pdf')
access_token	text	IN (DEFAULT NULL)
content_type	text	OUT
file_content	bytea	OUT

Definition

DECLARE 
    v_params json;
    v_headers json;
    v_prop_id int;
    v_prop_name text;
    v_status int;
    v_message text;
    v_report_name text;
    v_report_filename text;
    --v_file_content bytea;
    --v_content_type text;
    error_obj jsonb;
    response jsonb;
    JASPER_REPORT_URL text; -- = fn_get_config(0, 'REPORT_GEN_URL');
BEGIN
/*    
    http://localhost:8100/report/renderFile/?report_id=report_id
        &access_token=access_token ของ user 
        &parameters=object ในรูปแบบ string
        &output_type=file(default), bynary, email(ยังไม่มี)
        &output_format=pdf(default)-ยังมีเฉพาะตัวนี้, (html, rtf, csv, docx, pptx, xlsx, odt)-ตัวเก่ามีมาให้ แต่ยังไม่ได้ทำ ส่วน jpg, png ต้องไปหาวิธีทำอีกที
====
 const URL = `NULL/generate-report?report_id=NULL&parameters=NULL&output_format=NULL`
        const setHeaders = {
            headers: {
                'Authorization': `Bearer NULL`
            }
        }
====
const URL = `NULL/generate_pdf?name=NULL&parameters=NULL&static_value=NULL`
        const setHeaders = {
            headers: {
                'Authorization': `Bearer NULL`
            }
        }
if(!isUndefined(strStaticValue)) {
                strParameters.S_PROPERTY_NAME = strStaticValue.prop_name
                strParameters.S_USER_NAME = mid.jwt_username
                strParameters.S_SYSTEM_DATE = strStaticValue.system_date
                strParameters.S_REPORT_TITLE = strStaticValue.report_name
            }
*/
    SELECT id, name from property p where upper(p.code) = upper(prop_code)
    INTO v_prop_id, v_prop_name;

    SELECT r.report_name, r.report_filename from reports r where r.id = $2 
    INTO v_report_name, v_report_filename; 
    
    access_token := coalesce(access_token, fn_get_config(v_prop_id, 'REPORT_GEN_TOKEN'));

--    JASPER_REPORT_URL := 'http://172.17.0.1:8200/generate-report';
--    v_params := json_build_object(
--                  'report_id', report_id,
--                  'parameters', params::text, 
--                  'output_format', export_format 
--              ); 

    JASPER_REPORT_URL := 'http://172.17.0.1:8200/generate_pdf'; 
    --JASPER_REPORT_URL := 'http://host.docker.internal:8200/generate_pdf'; 
    v_params := json_build_object(
                  'name', v_report_filename,
                  'parameters', params::text, 
                  'static_value', json_build_object(
                                    'prop_name', v_prop_name,
                                    'system_date', fn_system_date(v_prop_id),
                                    'report_name', v_report_name
                                  )::text 
              ); 
    
    v_headers := json_build_object('Authorization', 'Bearer '||access_token);

    

    raise notice 'URL: %', JASPER_REPORT_URL; 
    raise notice 'Params: %', v_params;          

    SELECT f.status, f.message, f.content_type, f.file_content 
    FROM http_get_file(JASPER_REPORT_URL, query_params := v_params, headers := v_headers) AS f
    INTO v_status, v_message, content_type, file_content;
    
    raise notice 'content_type: %', content_type;

    IF (content_type like 'application/json%') THEN
        response := convert_from(file_content,'UTF8')::jsonb;
        if (response->>'status' = '200' and response->'data'->>'type' = 'Buffer') then
           file_content := fn_json_bytes_to_bytea(response->'data'->'data');
           content_type := 'application/pdf'; 
        else
           v_message := response->>'message';
        end if;
    ELSE
        PERFORM sys.log_error('sp_gen_jasper_report_file', 'Create report failed ('||v_status||'), '||v_message);    
        PERFORM sp_raise_error_if(true, 'Create report failed ('||v_status||'), '||v_message);
--    ELSIF  AND (file_content IS NOT NULL) THEN 
--        error_obj := convert_from(file_content,'UTF8')::jsonb;
--        IF error_obj ? 'message' THEN 
--            v_message := error_obj->>'message';
--        END IF;
    END IF;

    if v_status <> 200 then
        PERFORM sys.log_error('sp_gen_jasper_report_file', v_report_name||E'\nCreate report failed, '||v_message);  
        PERFORM sp_raise_error_if(true, 'Create report failed, '||v_message);   
    end if;
END