EKNO YUAG

??ALTER PROCEDURE [dbo].[CRPTLPPOMESSPAYSLIP]

    (

      @PayPeriod VARCHAR(6) ,

      @EmpID VARCHAR(20) ,

      @Running VARCHAR(2) ,

      @PayType VARCHAR(2) 

    )

AS

    --DECLARE @PayPeriod VARCHAR(6) = '202501'

    --DECLARE @EmpID VARCHAR(8) = '00000002'

    --DECLARE @Running VARCHAR(2) = '1'

    --DECLARE @PayType VARCHAR(2) = ''

    DECLARE @CompanyCode AS VARCHAR(50) 

    DECLARE @CompanyName AS VARCHAR(250) 

    DECLARE @CompanyLogo AS VARBINARY(MAX)

    DECLARE @PayMonth AS NVARCHAR(2)

    DECLARE @PayYear AS NVARCHAR(4)

    DECLARE @Begda AS NVARCHAR(8)

    DECLARE @Endda AS NVARCHAR(8)

	DECLARE @PayGroup AS VARCHAR(50) 

	DECLARE @BegdaWS AS NVARCHAR(8)

    DECLARE @EnddaWS AS NVARCHAR(8)

    SET @PayMonth = RIGHT(@PayPeriod, 2)

    SET @PayYear = LEFT(@PayPeriod, 4)

    SET @Begda = @PayPeriod + '01'

    SET @Endda = CONVERT(NVARCHAR(8), DATEADD(d, -1, DATEADD(m, 1, @Begda)), 112)

    DECLARE @PaySlipSigned AS NVARCHAR(50)

    SELECT TOP ( 1 )

            @PaySlipSigned = Value

    FROM    dbo.PHRPYCU0307

    WHERE   ( PayrollParameter = 'PAYSLIPSIGNED' )

            AND ( StartDate <= @Endda

                  AND EndDate >= @Endda

                )

    IF ( @Running = '1' )

        BEGIN

            SELECT TOP ( 1 )

                    @CompanyCode = CompanyID

					,@PayGroup = PayrollGroup

            FROM    dbo.PHRPYTR0300 

             WHERE   ( EmployeeID = @EmpID )

                    AND ( PayPeriodMonth = @PayMonth )

                    AND ( PayPeriodYear = @PayYear )

                    AND ( RunPeriodMonth = @PayMonth )

                    AND ( RunPeriodYear = @PayYear )

        END

    ELSE

        BEGIN

            SELECT TOP ( 1 )

                    @CompanyCode = CompanyID

					,@PayGroup = PayrollGroup

            FROM    dbo.PHRPYTR0300SIM

            WHERE   ( EmployeeID = @EmpID )

                    AND ( PayPeriodMonth = @PayMonth )

                    AND ( PayPeriodMonth = @PayYear )

                    AND ( RunPeriodMonth = @PayMonth )

                    AND ( RunPeriodYear = @PayYear )

        END

    SELECT  @CompanyName = COM.CompanyDescription ,

            @CompanyLogo = CAT.FileData

    FROM    dbo.PCMEPCOMPID AS COM

	LEFT JOIN dbo.SFILECATALOG CAT ON COM.Logo = CAT.FileName

    WHERE   ( CompanyID = @CompanyCode )

            AND StartDate <= @Endda

            AND EndDate >= @Endda

	DECLARE @Disclaimer VARCHAR(250)

	SELECT @Disclaimer = Value1 FROM dbo.PCMEPGENPARAM WHERE Parameter = 'DISCLAIMEREPAYSLIP'

	IF @CompanyCode = '3000'

	BEGIN 

	SELECT @Disclaimer = Value1 FROM dbo.PCMEPGENPARAM WHERE Parameter = 'DISCLAIMEREPAYSLIPIHATEC'

	END

	----//---- get hari kerja start

	DECLARE @PeriodPayGroup VARCHAR(20)

	SELECT @PeriodPayGroup = PayrollPeriod FROM dbo.PHRPYPGRUP WHERE PayrollGroup = @PayGroup

	SELECT @BegdaWS = StartDate, @EnddaWS = EndDate FROM dbo.PHRPYTRPAYPERIOD WHERE PayrollPeriod = @PeriodPayGroup AND StartDate <= @Begda AND EndDate >= @Begda

	DECLARE @TotHK DECIMAL(18,0)

	SELECT @TotHK = COUNT(pa125.StartDate)

	FROM PHRPA0025 AS pa25

	LEFT JOIN PHRPA0125 AS pa125

		ON pa25.EmployeeID = pa125.EmployeeID

	WHERE pa25.EmployeeID = @EmpID

		AND pa25.StartDate <= @EnddaWS AND pa25.EndDate >= @EnddaWS

		AND pa125.StartDate >= @BegdaWS AND pa125.StartDate <= @EnddaWS

		AND pa125.DayType IN (SELECT DayType FROM dbo.PHRTMDAYTYP WHERE Flag = 'WORK')

	----//---- get hari kerja end

	----//---- get attendance start

	DECLARE @TotAtt DECIMAL(18,2)

	SELECT @TotAtt = COUNT(StartDate)

	FROM dbo.PHRPA0019

	WHERE EmployeeID = @EmpID

		AND StartDate >= @BegdaWS AND StartDate <= @EnddaWS

		AND AttendanceType = '1000'

	----//---- get hari kerja end

    IF ( @Running = '1' )

        BEGIN   

            SELECT  @PaySlipSigned PaySlipSigned ,

                    @CompanyName CompanyName ,

                    @CompanyLogo logo ,

                    c308.ReportID ,

                    c308.GroupBy ,

                    c308P.PayslipDescription ParentDescription ,