Routines

Routines

Name Type Language Deterministic Return Type Security Restriction Comments
fn_process_avail_sync_result FUNCTION PLPGSQL false SETOF jsonb INVOKER
fn_gen_services_token FUNCTION PLPGSQL false text INVOKER
sp_login1 FUNCTION PLPGSQL false jsonb INVOKER
fn_get_user_info FUNCTION PLPGSQL false record INVOKER
sp_get_property_by_prop_group_id FUNCTION PLPGSQL false json INVOKER
fn_logout FUNCTION PLPGSQL false record INVOKER

User logout
sp_gen_jasper_report_url FUNCTION PLPGSQL false text INVOKER
fn_http_post_status FUNCTION SQL true integer INVOKER
fn_change_password FUNCTION PLPGSQL false record INVOKER

Change user’s password using old and new password To reset or inititalize password, set old_password to null
fn_role_effective_perm_ids FUNCTION SQL false SETOF bigint INVOKER
fn_process_restrictions_sync_result FUNCTION PLPGSQL false SETOF jsonb INVOKER
fn_check_permission FUNCTION SQL false boolean INVOKER
fn_get_user_permissions FUNCTION SQL false SETOF record INVOKER
sp_tr_configs_init FUNCTION PLPGSQL false trigger INVOKER
sp_gen_report_url2 FUNCTION PLPGSQL false text INVOKER
sp_get_batch_reports_js FUNCTION SQL false json INVOKER
fn_period FUNCTION PLPGSQL true record INVOKER
fn_prop_connection FUNCTION SQL false text INVOKER
fn_group_type_rank FUNCTION SQL true integer INVOKER
sp_commit_restrictions_state FUNCTION PLPGSQL false integer INVOKER
fn_get_role_permissions FUNCTION SQL false SETOF record INVOKER
sp_system_notify FUNCTION SQL false boolean INVOKER
sp_reset_user_permissions FUNCTION PLPGSQL false integer INVOKER
sp_get_report_list FUNCTION SQL false SETOF record INVOKER
fn_system_alerts FUNCTION PLPGSQL false jsonb INVOKER
sp_get_run_batch_report_by_index FUNCTION PLPGSQL false json INVOKER
sp_prop_exec FUNCTION PLPGSQL false text INVOKER
sp_reset_system_admin_permissions FUNCTION PLPGSQL false SETOF record INVOKER
fn_connection FUNCTION SQL false text INVOKER

Create connection string
fn_login FUNCTION PLPGSQL false record INVOKER
fn_get_permission_codes FUNCTION SQL false SETOF record INVOKER
fn_user_email FUNCTION SQL false text INVOKER
fn_get_user_permissionXXX FUNCTION SQL false jsonb INVOKER
sp_get_password_policy FUNCTION PLPGSQL false record INVOKER
fn_parse_param_values FUNCTION PLPGSQL true jsonb INVOKER
fn_get_users FUNCTION SQL false SETOF record INVOKER
sp_get_user_s_by_prop_id_json FUNCTION SQL false jsonb INVOKER
fn_role_set_permissions FUNCTION PLPGSQL false void INVOKER
fn_role_grant_permissions FUNCTION PLPGSQL false void INVOKER
sp_raise_error_if FUNCTION PLPGSQL false void INVOKER
sp_get_user_p_by_prop_id_json FUNCTION SQL false jsonb INVOKER
sp_tr_reports_update_permission FUNCTION PLPGSQL false trigger INVOKER
fn_prop_params FUNCTION SQL false SETOF record INVOKER

Get system parameters from property database
sp_logout_all FUNCTION PLPGSQL false integer INVOKER
sp_set_session FUNCTION PLPGSQL false void INVOKER
fn_resolve_user_by_name FUNCTION SQL false SETOF record INVOKER
fn_gen_password_reset_token FUNCTION PLPGSQL false text INVOKER
sp_gen_report_url FUNCTION PLPGSQL false text INVOKER
sp_set_user_roles FUNCTION PLPGSQL false void INVOKER
fn_get_user_permission FUNCTION SQL false jsonb INVOKER
sp_update_reports FUNCTION PLPGSQL false record INVOKER
fn_process_sync_result FUNCTION PLPGSQL false SETOF jsonb INVOKER
fn_group_permissions_by_category FUNCTION SQL true json INVOKER

จัดกลุ่ม flat permission json (code,name,category,is_granted) เป็น nested array category -> itemssubcategory -> permissionscode,name,is_granted โดย split permission.category ด้วย “/” (Category/Subcategory)
fn_role_revoke_permissions FUNCTION PLPGSQL false void INVOKER
fn_get_user_group_ids FUNCTION SQL false ARRAY INVOKER
sp_change_work_shift FUNCTION SQL false void INVOKER
sp_gen_report_file FUNCTION PLPGSQL false record INVOKER
fn_add_user FUNCTION PLPGSQL false record INVOKER
fn_assign_user_property2 FUNCTION PLPGSQL false record INVOKER
fn_system_config_js FUNCTION PLPGSQL false jsonb INVOKER
sp_assign_user_property FUNCTION PLPGSQL false record INVOKER
fn_prop_query FUNCTION SQL false SETOF record INVOKER

Run sql query and return data from specified property
fn_get_login_token FUNCTION SQL false text INVOKER
sp_get_run_batch_report FUNCTION PLPGSQL false json INVOKER
fn_role_assign_violation FUNCTION PLPGSQL false text INVOKER
fn_resolve_app_prop FUNCTION PLPGSQL false integer INVOKER

resolve prop_id ที่ใช้จริงต่อ app: require_property=true คืน metadata prop; false คืน metadata prop หรือ apps.anchor_prop_id
fn_gen_access_token FUNCTION SQL false text INVOKER
sp_login FUNCTION PLPGSQL false jsonb INVOKER
fn_get_config FUNCTION PLPGSQL false text INVOKER
fn_period_start FUNCTION SQL true date INVOKER
fn_user_primary_group FUNCTION SQL false integer INVOKER
sp_daily_clear_all_intf_state PROCEDURE PLPGSQL false INVOKER
sp_save_batch_report FUNCTION PLPGSQL false json INVOKER
fn_set_config FUNCTION PLPGSQL false integer INVOKER
sp_user_permissions FUNCTION SQL false SETOF record INVOKER
fn_role_reset_permissions FUNCTION PLPGSQL false void INVOKER
fn_gen_activate_url FUNCTION PLPGSQL false text INVOKER
sp_get_reports_js FUNCTION PLPGSQL false json INVOKER
sp_commit_avail_state FUNCTION PLPGSQL false integer INVOKER
fn_handle_error FUNCTION PLPGSQL false json INVOKER
sp_reset_password FUNCTION PLPGSQL false record INVOKER
sp_get_connection_string FUNCTION SQL false text INVOKER
sp_tr_permission_init FUNCTION PLPGSQL false trigger INVOKER
fn_result_success FUNCTION SQL false json INVOKER
fn_decode_precheckin_url FUNCTION PLPGSQL false jsonb INVOKER
fn_get_session FUNCTION PLPGSQL false text INVOKER
sp_tr_users_check_image_size FUNCTION PLPGSQL false trigger INVOKER
fn_verify_token FUNCTION PLPGSQL false record INVOKER
fn_get_user_permission_json FUNCTION SQL false jsonb INVOKER
fn_prop_params_js FUNCTION PLPGSQL false json INVOKER
sp_db_kill_connections FUNCTION SQL false boolean INVOKER
sp_get_user_g_by_prop_id_json FUNCTION SQL false jsonb INVOKER
sp_migrate_backup_report_paths FUNCTION PLPGSQL false integer INVOKER
fn_period_end FUNCTION SQL true date INVOKER
sp_enqueue_realtime FUNCTION PLPGSQL false boolean INVOKER
sp_db_search FUNCTION SQL false SETOF record INVOKER
sp_sync_restrictions_interface FUNCTION PLPGSQL false SETOF jsonb INVOKER
sp_sync_rate_interface FUNCTION PLPGSQL false SETOF jsonb INVOKER
sp_clear_intf_rate_state PROCEDURE PLPGSQL false INVOKER
fn_parse_date FUNCTION SQL true date INVOKER
fn_revoke_permissions FUNCTION PLPGSQL false record INVOKER
sp_get_reports_option_js FUNCTION PLPGSQL false json INVOKER
sp_commit_rate_state FUNCTION PLPGSQL false integer INVOKER
fn_work_shift FUNCTION SQL false character varying INVOKER
sp_tr_user_property_init FUNCTION PLPGSQL false trigger INVOKER
sp_get_reports_list_js FUNCTION PLPGSQL false json INVOKER
fn_encrypt_password FUNCTION PLPGSQL false trigger INVOKER
sp_get_batch_report_js FUNCTION SQL false json INVOKER
fn_prop_exec FUNCTION SQL false text INVOKER

Execute sql command on property database
sp_run_batch_report FUNCTION PLPGSQL false integer INVOKER
sp_get_batch_report_details_js FUNCTION SQL false json INVOKER
fn_system_date FUNCTION SQL false date INVOKER

Get system date from property’s database
sp_create_payment_link FUNCTION PLPGSQL false text INVOKER
fn_set_group_permissions FUNCTION PLPGSQL false record INVOKER
sp_get_user_du_by_prop_id_json FUNCTION SQL false jsonb INVOKER
sp_tr_property_init FUNCTION PLPGSQL false trigger INVOKER
sp_sync_room_avail_interface FUNCTION PLPGSQL false SETOF jsonb INVOKER
sp_notify_channel_response FUNCTION PLPGSQL false void INVOKER
sp_clear_my_lock_record FUNCTION PLPGSQL false boolean INVOKER
fn_result FUNCTION SQL false json INVOKER
fn_grant_permissions FUNCTION PLPGSQL false record INVOKER

Grant permissions to specified user and property
sp_get_report_for_print_js FUNCTION PLPGSQL false json INVOKER
sp_verify_token FUNCTION PLPGSQL false record INVOKER
sp_gen_jasper_report_file FUNCTION PLPGSQL false record INVOKER
fn_get_password_json FUNCTION SQL false json INVOKER
fn_dashboard_url FUNCTION PLPGSQL false text INVOKER
fn_result_error FUNCTION SQL false json INVOKER
sp_check_permission FUNCTION PLPGSQL false boolean INVOKER
fn_set_user_permissions FUNCTION PLPGSQL false record INVOKER
fn_get_user_permission_jsonXXX FUNCTION SQL false jsonb INVOKER
sp_tr_users_init FUNCTION PLPGSQL false trigger INVOKER
fn_format_date_path FUNCTION SQL true text INVOKER
fn_authorized_property_connections FUNCTION SQL false SETOF record INVOKER

Checks user_property and returns authorized property DB connection strings for requested property codes.
fn_json_bytes_to_bytea FUNCTION SQL true bytea INVOKER
sp_get_printform_list_js FUNCTION PLPGSQL false json INVOKER
sp_notify_realtime_event FUNCTION PLPGSQL false boolean INVOKER
sp_clear_my_lock_record_by_id FUNCTION PLPGSQL false boolean INVOKER
sp_telegram_send_msg FUNCTION SQL false boolean INVOKER
fn_report_service_settings FUNCTION SQL false json INVOKER
sp_register_property FUNCTION SQL false record INVOKER
sp_run_batch_report1 FUNCTION PLPGSQL false integer INVOKER
sp_tr_service_token_init FUNCTION PLPGSQL false trigger INVOKER
sp_request_password_reset FUNCTION PLPGSQL false record INVOKER