penambahan pada table pcmwfcustparam
dengan id INSERTPHRPA0125
DECLARE @now VARCHAR DECLARE @GeneratePWS INT=0 SET @now = dbo.fn_formatdatetime(GETDATE, 'yyyymmdd') SET @GeneratePWS =(SELECT GeneratePWS FROM PHRTMWSTYP WHERE WorkScheduleType = @WorkScheduleType AND StartDate <= @now AND EndDate >=@now) IF @GeneratePWS = 1 IF @Year <> 0 BEGIN INSERT INTO PHRPA0125 SELECT DISTINCT WSCA.DateSpecified,WSCA.DateSpecified,PA25.EmployeeID,WSCA.DayType,WSCA.PublicHoliday,'','BY SYSTEM',dbo.fn_formatdatetime(@now,'YYYYmmddHHmmss'),'BY SYSTEM',dbo.fn_formatdatetime(@now,'YYYYmmddHHmmss') FROM PHRPA0025 PA25 LEFT OUTER JOIN PHRTMWSCAL WSCA ON WSCA.WorkScheduleType = @WorkScheduleType WHERE ( PA25.StartDate <= @now AND PA25.EndDate >=@now)AND PA25.WorkScheduleType= @WorkScheduleType AND WSCA.Year = @Year select * from PHRPA0125 PA25 where PA25.StartDate <= @now AND PA25.EndDate >=@now END IF @Year = 0 BEGIN DECLARE @Counter INT DECLARE @Coun INT SET @Counter=0 SET @Coun=(SELECT DATEDIFF AS DateDiff) WHILE ( @Counter <= @Coun) BEGIN INSERT INTO PHRPA0125 SELECT WSCA.DateSpecified,WSCA.DateSpecified,PA25.EmployeeID,WSCA.DayType,WSCA.PublicHoliday,'','BY SYSTEM',dbo.fn_formatdatetime(@now,'YYYYmmddHHmmss'),'BY SYSTEM',dbo.fn_formatdatetime(@now,'YYYYmmddHHmmss') FROM PHRPA0025 PA25 LEFT OUTER JOIN PHRTMWSCAL WSCA ON WSCA.WorkScheduleType = @WorkScheduleType WHERE ( PA25.StartDate <= @now AND PA25.EndDate >=@now)AND PA25.WorkScheduleType= @WorkScheduleType AND ( WSCA.DateSpecified =dbo.fn_formatdatetime(DATEADD,'YYYYMMDD')) SET @Counter = @Counter + 1 END select * from PHRPA0125 PA25 where PA25.StartDate <= @now AND PA25.EndDate >=@now END
perbaikan pada file
...\app\controller\masterdata\tm\CtrlGenerateWorkSchedule.js
//SASWANTO 26APRIL2022