DELIMITER //

CREATE OR REPLACE PROCEDURE get_Schedule(
  IN p_userid VARCHAR(100),
  IN p_yearmonth VARCHAR(6)
)
/*
  Function   : 配合 amis 的 行事曆(簡易版), 取得 Schedule 資料
               目前的寫法有問題, 沒有加入任何過濾條件, 且元件本身還在修改中, 先簡單展示用
  Description: 
  Build Date : 2022/1/1
  
  Modify History
    Item Who        Date       Modify Docs
    ==== ========== ========== ================================================
    1    Michael    2022/1/1
    2    Michael    2022/10/10 改為 eip_core_calendar
	3    Michael    2025/07/20 改寫為 MariaDB 並最佳化(ChatGPT+DeepSeek)
*/
BEGIN
  -- 设置默认返回值
  SELECT 0 AS code, 'ok' AS msg;
  
  -- 查询日程数据
  SELECT 
    DATE_FORMAT(start_time, '%Y-%m-%d %H:%i:%s') AS startTime,
    DATE_FORMAT(end_time, '%Y-%m-%d %H:%i:%s') AS endTime,
    title AS content 
  FROM eip_core_calendar
  WHERE personid = p_userid
    AND DATE_FORMAT(start_time, '%Y%m') = p_yearmonth;
END //

DELIMITER ;