authen
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_get_report_for_print_js
Parameters
Name
Type
Mode
report_id
integer
IN
prop_id
integer
IN
Definition
declare json_report_table json; json_params json; txt_prop_name text; begin /** * Create by KenG (2022/03/17) * For get info about report for send this data to report before print */ select jsonb_build_object( 'id', id, 'report_name', report_name, 'category', category, 'report_type', report_type, 'report_filename', report_filename ) from reports where id = report_id into json_report_table; select * from fn_prop_params_js(prop_id) into json_params; select name from property where id = prop_id into txt_prop_name; return jsonb_build_object( 'report', json_report_table, 'system_date', json_params->'SYSTEM'->'SYSTEM_DATE', 'prop_name', txt_prop_name ); END;