33 lines
863 B
Plaintext
33 lines
863 B
Plaintext
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 ;
|