update file
...\Views\Home\Index.aspx
seting db PCMWFCUSTPARAM tambahkan :
GETDASHBOARDDATA NULL NULL NULL NULL NULL NULL DECLARE @tabledata AS TABLE ( empactive VARCHAR , emphiring VARCHAR , empterminate VARCHAR , turnover VARCHAR, Completed VARCHAR, NotCompleted VARCHAR, ManagerCompleted VARCHAR, ManagerNotCompleted VARCHAR, PartnerCompleted VARCHAR, PartnerNotCompleted VARCHAR ) INSERT INTO @tabledata SELECT CONVERT , CONVERT , CONVERT , CONVERT, CONVERT, CONVERT, CONVERT, CONVERT, CONVERT, CONVERT UPDATE @tabledata SET empactive = a.empactive FROM ( SELECT DISTINCT COUNT AS empactive FROM dbo.PHRPA0002 PAO2 WHERE EmployeeStatus = '01' AND PAO2.EndDate >= CONVERT, 112) AND PAO2.StartDate <= CONVERT, 112) ) a UPDATE @tabledata SET emphiring = a.emphiring FROM ( SELECT COUNT AS emphiring FROM dbo.PHRPA0002 WHERE MovementType = '01' AND ( StartDate BETWEEN CONVERT, YEAR)) + '0101' AND CONVERT, 112) ) ) a UPDATE @tabledata SET empterminate = a.empterminate FROM ( SELECT COUNT AS empterminate FROM dbo.PHRPA0002 WHERE EmployeeStatus = '03' AND ( StartDate BETWEEN CONVERT, YEAR)) + '0101' AND CONVERT, 112) ) ) a DECLARE @empterminate DECIMAL SET @empterminate = ( SELECT COUNT AS empterminate FROM dbo.PHRPA0002 WHERE EmployeeStatus = '03' AND ( StartDate BETWEEN CONVERT, YEAR)) + '0101' AND CONVERT, 112) ) ) DECLARE @empactive DECIMAL SET @empactive = ( SELECT COUNT AS empactive FROM dbo.PHRPA0002 WHERE EmployeeStatus = '01' AND EndDate >= CONVERT, 112) AND StartDate <= CONVERT, 112) ) UPDATE @tabledata SET turnover = a.turnover FROM ( SELECT CONVERT, ( @empterminate / @empactive ) * 100) AS turnover ) a UPDATE @tabledata set Completed = a.Completed FROMAS Completed FROM dbo.PCMWFRUNTASK WHERE BizflowID='MD_PMS_REVIEW' AND TaskID IN ('create') AND TaskStatus='C')a UPDATE @tabledata SET NotCompleted = a.NotCompleted FROMAS NotCompleted FROM dbo.PCMWFRUNTASK WHERE BizflowID='MD_PMS_REVIEW' AND TaskID IN ('create') AND TaskStatus='W')a UPDATE @tabledata set ManagerCompleted = a.Completed FROMAS Completed FROM dbo.PCMWFRUNTASK WHERE BizflowID='MD_PMS_REVIEW' AND TaskID IN ('create_by_manager') AND TaskStatus='C')a UPDATE @tabledata SET ManagerNotCompleted = a.NotCompleted FROMAS NotCompleted FROM dbo.PCMWFRUNTASK WHERE BizflowID='MD_PMS_REVIEW' AND TaskID IN ('create_by_manager') AND TaskStatus='W')a UPDATE @tabledata set PartnerCompleted = a.Completed FROMAS Completed FROM dbo.PCMWFRUNTASK WHERE BizflowID='MD_PMS_REVIEW' AND TaskID IN ('apv_partner','apv_partner2')AND TaskStatus='C')a UPDATE @tabledata SET PartnerNotCompleted = a.NotCompleted FROMAS NotCompleted FROM dbo.PCMWFRUNTASK WHERE BizflowID='MD_PMS_REVIEW' AND TaskID IN ('apv_partner','apv_partner2')AND TaskStatus='W')a SELECT * from @tabledata sqlstring NULL
