PT BIA

??USE [MinovaES_BIA_BaseServerCloud]

GO

/****** Object:  StoredProcedure [dbo].[CRPTLPPOMESSPAYSLIP]    Script Date: 07/10/2025 15.44.08 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

--USE [MinovaES_BIA_Prod]

--GO

--/****** Object:  StoredProcedure [dbo].[CRPTLPPOMESSPAYSLIP]    Script Date: 04/02/2025 12.04.51 ******/

--SET ANSI_NULLS ON

--GO

--SET QUOTED_IDENTIFIER ON

--GO

ALTER PROCEDURE [dbo].[CRPTLPPOMESSPAYSLIP]

    (

      @PayPeriod VARCHAR(6) ,

      @EmpID VARCHAR(20) ,

      @Running VARCHAR(2) ,

      @PayType VARCHAR(2) 

    )

AS

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

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

    --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)

    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

            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

            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

    IF ( @Running = '1' )

        BEGIN   

            SELECT DISTINCT @PaySlipSigned PaySlipSigned ,

                    @CompanyName CompanyName ,

                    @CompanyLogo logo ,

                    c308.ReportID ,

                    c308.GroupBy ,

                    c308P.PayslipDescription ParentDescription ,

                    c308.Sequence ,

                    c308.PayslipDescription ,

                    c308.PayrollType ,

                    c308.WageType ,

                    c308.IsDisplayWageType ,

                    c308.IsDisplayNumber ,

                    c308.IsDisplayRate ,

                    c308.IsDisplayAmount ,

                    CASE WHEN mdjoin15.HiringDate != '' THEN mdjoin15.HiringDate ELSE mdjoin.StartDate END AS StartDate,			----mdjoin.StartDate ,

					CASE WHEN mdjoin15.HiringDate != '' THEN dbo.fn_formatdatetime_indonesia(mdjoin15.HiringDate, 'DD MMMM YYYY') ELSE dbo.fn_formatdatetime_indonesia(mdjoin.StartDate, 'DD MMMM YYYY')  END AS StartDateDesc,

					--dbo.fn_formatdatetime_indonesia(mdjoin.StartDate, 'DD MMMM YYYY') as StartDateDesc,

                    c308.EndDate ,

                    c308.IsActive ,

                    c308.ChangeBy ,