CLIENT SUPPORT » IMFI Bugs

dear masbin , udah bisa di test ya , untuk issue ini menggunakan trigger after update pada movement type di phrpa0002 berikut ini triggernya

USE MinovaHR_Indomobil_Dev;
GO

CREATE TRIGGER [dbo].UpdateValidtrought
ON [dbo].[hr_md_emp_md0002]
AFTER UPDATE
AS
BEGIN
-- Cek jika kolom test1 diperbarui ke '01'
IF UPDATE
BEGIN
-- Perbarui kolom start_date di TabelB berdasarkan start_date di TabelA
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;

makasih

update:
masih belum fix ya azid....

update :
berikut query trigger nya

USE [MinovaHR_Indomobil_Dev]
GO
/****** Object: Trigger [dbo].[UpdateValidThrougtInsert] Script Date: 23/05/2023 10:51:02 **/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER TRIGGER [dbo].[UpdateValidThrougtInsert]
ON [dbo].[hr_md_emp_md0002]
AFTER INSERT
AS
BEGIN
IF EXISTS (SELECT 1 FROM inserted WHERE movement_type ='80')
BEGIN
UPDATE base_sys_user
SET valid_through = a.[start_date]
FROM base_sys_user b
INNER JOIN inserted a ON b.emp_id = a.emp_id
WHERE a.movement_type = '80';
END
END;

sudah di deploy ke client imfi.
tinggal di tes contoh employee lain oleh user nya.