DELIMITER //

CREATE OR REPLACE PROCEDURE get_parameter(
  IN p_sys_id VARCHAR(10)
)
/*
  Function   : 讀取 sys_parameter 所有的參數值, logon 後存到 localStorage
  Description: 
  Build Date : 2022/05/04
  
  Modify History
    Item Who        Date       Modify Docs
    ==== ========== ========== ================================================
    1    Michael    2022/05/04
	2    Michael    2023/07/08 新增 @sys_id 參數(* 表示全部)
    3    Michael    2025/07/20 改寫為 MariaDB 並最佳化(ChatGPT+DeepSeek)
*/
BEGIN
  -- 设置默认返回值
  SELECT 0 AS code, 'ok' AS msg;
  
  -- 查询参数数据
  IF p_sys_id = '*' OR p_sys_id IS NULL OR p_sys_id = '' THEN
    SELECT * FROM sys_parameter;
  ELSE
    SELECT * FROM sys_parameter WHERE systemid = p_sys_id;
  END IF;
END //

DELIMITER ;