aonestar.public

Parameters

Name	Type	Mode
i_prefix_url_pms_file	text	IN (DEFAULT NULL)

Definition

declare
	strcurrent_propcode text;
	json_result json;
	sql_text text;
	--user_id int;
begin
	/**
	 * Create by KenG (2020/08/31)
	 * This stored procedure will get and return json to PMS service(NodeJS)
	 * Select report list from Authen DB base on propcode
	 * Stored procedure: sp_get_reports_list_js(propcode citext) from authen DB
	 * - Will get list report name base on prop_code
	 * - If want to edit logic that edit sp_get_reports_list_js(propcode citext) from authen DB
	 * -----
	 * Update (2021/05/25)
	 * i_prefix_url_pms_file for develop pass value from NodeJS
	 */

	strcurrent_propcode = fn_current_propcode();
	--raise notice 'i_prefix_url_pms_file1: %', i_prefix_url_pms_file;
	sql_text = format('SELECT * FROM sp_get_reports_list_js(%L, %L, %L)', strcurrent_propcode, i_prefix_url_pms_file, fn_current_user());

	--PERFORM sp_sys_log('sp_get_reports_list_js', format('user_id = %L, user_name = %L', fn_get_session('user_id', 'NULL'), fn_get_session('user_name', 'NULL')));
	--raise notice 'i_prefix_url_pms_file2: %', sql_text;

	select obj_params
	from dblink(fn_conn_authen(), sql_text)
	as params(obj_params json)
	into json_result;

	return json_result;

END;