BEGIN
    -- Mendeklarasikan variabel untuk menampung nilai yang dipilih
    SET @judul = '';
    SET @subjudul = '';
    SET @body = '';

    -- Nilai pengganti default
    SET @company_name = '{COMPANY_NAME}'; -- Menggunakan placeholder default
    SET @start_date = '{START_DATE}';     -- Menggunakan placeholder default
    SET @end_date = '{END_DATE}';         -- Menggunakan placeholder default
    SET @total_participants = '{TOTAL_PARTICIPANTS}'; -- Menggunakan placeholder default
    SET @percentage_participants = '{PERCENTAGE_PARTICIPANTS}'; -- Menggunakan placeholder default
    SET @fit_percentage = '{FIT_PERCENTAGE}'; -- Menggunakan placeholder default
    SET @fit_note_percentage = '{FIT_NOTE_PERCENTAGE}'; -- Menggunakan placeholder default
    SET @evaluation_percentage = '{EVALUATION_PERCENTAGE}'; -- Menggunakan placeholder default
    SET @followup_percentage = '{FOLLOWUP_PERCENTAGE}'; -- Menggunakan placeholder default
    SET @gangguan_metabolisme_percentage = '{GANGGUAN_METABOLISME_PERCENTAGE}'; -- Menggunakan placeholder default
    SET @hipertensi_percentage = '{HIPERTENSI_PERCENTAGE}'; -- Menggunakan placeholder default
    SET @refraksi_percentage = '{REFRAKSI_PERCENTAGE}'; -- Menggunakan placeholder default

    -- Mengambil data dari tabel yang relevan
    SELECT 
        M_CompanyName AS company_name,
        Mgm_McuStartDate AS start_date,
        Mgm_McuEndDate AS end_date
    INTO 
        @company_name,
        @start_date,
        @end_date
    FROM one_etl.mgm_mcu
    JOIN one.m_company ON Mgm_McuM_CompanyID = M_CompanyID
    WHERE Mgm_McuIsActive = 'Y'
    AND Mgm_McuID = MMID;

    -- Memilih nilai dari tabel exe_sum_tpl berdasarkan kondisi tertentu
    SELECT exeSumTplTitle, exeSumTplSubTitleTitle, exeSumTplSubBody 
    INTO @judul, @subjudul, @body
    FROM exe_sum_tpl
    WHERE exeSumTplCode = CODE 
    AND exeSumTplMgm_McuID = MMID
    AND exeSumTplIsActive = 'Y'
    LIMIT 1;

    -- Mengecek apakah data berhasil diambil
    IF (@company_name <> '{COMPANY_NAME}' AND @start_date <> '{START_DATE}' AND @end_date <> '{END_DATE}') THEN
        -- Jika data ada, lakukan penggantian placeholder
        SET @body = REPLACE(@body, '{COMPANY_NAME}', @company_name);
        SET @body = REPLACE(@body, '{START_DATE}', @start_date);
        SET @body = REPLACE(@body, '{END_DATE}', @end_date);
        SET @body = REPLACE(@body, '{TOTAL_PARTICIPANTS}', @total_participants);
        SET @body = REPLACE(@body, '{PERCENTAGE_PARTICIPANTS}', @percentage_participants);
        SET @body = REPLACE(@body, '{FIT_PERCENTAGE}', @fit_percentage);
        SET @body = REPLACE(@body, '{FIT_NOTE_PERCENTAGE}', @fit_note_percentage);
        SET @body = REPLACE(@body, '{EVALUATION_PERCENTAGE}', @evaluation_percentage);
        SET @body = REPLACE(@body, '{FOLLOWUP_PERCENTAGE}', @followup_percentage);
        SET @body = REPLACE(@body, '{GANGGUAN_METABOLISME_PERCENTAGE}', @gangguan_metabolisme_percentage);
        SET @body = REPLACE(@body, '{HIPERTENSI_PERCENTAGE}', @hipertensi_percentage);
        SET @body = REPLACE(@body, '{REFRAKSI_PERCENTAGE}', @refraksi_percentage);

        -- Mengganti placeholder di judul dan subjudul
        SET @judul = REPLACE(@judul, '{COMPANY_NAME}', @company_name);
        SET @subjudul = REPLACE(@subjudul, '{COMPANY_NAME}', @company_name);
    END IF;

    -- Menampilkan hasil
    SELECT @judul AS judul, @subjudul AS subjudul, @body AS body;

END