CLIENT SUPPORT » IMFI Bugs

USE MinovaHR_Indomobil_Dev;

GO

CREATE TRIGGER [dbo].UpdateValidtrought

ON [dbo].[hr_md_emp_md0002]

AFTER UPDATE

AS

BEGIN

    -- Cek jika kolom movement_type diperbarui ke '80'

    IF UPDATE(movement_type)

    BEGIN

        -- Perbarui kolom valid_through di base_sys_user berdasarkan start_date di [hr_md_emp_md0002]

        UPDATE B

        SET B.valid_through = A.[start_date]

        FROM base_sys_user AS B

        INNER JOIN [hr_md_emp_md0002] AS A ON B.emp_id = A.emp_id

        INNER JOIN inserted AS I ON A.emp_id = I.emp_id

        INNER JOIN deleted AS D ON A.emp_id = D.emp_id

        WHERE I.movement_type = '80' AND (D.movement_type <> '80' OR D.movement_type IS NULL);

    END;

END;