DELIMITER //

CREATE OR REPLACE PROCEDURE set_bbs_readed(
  IN p_token VARCHAR(100),
  IN p_id INT
)
/*
  Function   : 更新 eipbbs_d 的已讀紀錄(在 eipbbs_m 中 button call)
  Description: eipm11 PBI 回報進度及狀態
  Build Date : 2022/07/02
  
  Modify History
    Item Who        Date       Modify Docs
    ==== ========== ========== ================================================
    1    Michael    2022/07/02 Init
    2    Michael    2025/07/20 改寫為 MariaDB 並最佳化(ChatGPT+DeepSeek)
*/
BEGIN
  DECLARE v_userid VARCHAR(100);
  
  -- 根據傳入的 token 取得 userid
  SELECT userid INTO v_userid FROM sys_users WHERE token = p_token LIMIT 1;
  
  -- update eipbbs_d
  UPDATE eipbbs_d SET is_read = 'Y' 
  WHERE uniqueno = p_id AND idno = v_userid;
  
  -- 返回成功 result
  SELECT 0 AS code, 'ok' AS msg;
END //

DELIMITER ;