ALTER PROCEDURE dbo.TR_BUDGET_CHECK_LIMIT_MONTH_HIST_Byid
@p_GD_ID	varchar(20)  = NULL,
@p_GD_CODE	varchar(20)  = NULL,
@p_BRANCH_ID varchar(20)  = NULL,
@p_DEP_ID	varchar(20)  = NULL,
@p_BUDGET_MONTH varchar(20) = NULL,
@p_BUDGET_YEAR varchar(20) = NULL,
@p_BRANCH_KIND varchar(20) = NULL,
@p_TOP INT = 100
AS
BEGIN -- PAGING
	SET @p_TOP = NULL

	IF(@p_TOP IS NULL OR @p_TOP=0)
	BEGIN  
-- PAGING BEGIN
        SELECT A.BUDGET_MONTH_LIMIT_DETAIL_ID, C.REQ_PAY_ID, C.REQ_PAY_CODE, CM.BRANCH_NAME, DP.DEP_NAME,
        trpb.AMT_EXE AS 'REQ_AMT',
        --C.REQ_AMT, 
        trpb.REASON AS 'REQ_REASON',
        --C.REQ_REASON,
        C.CREATE_DT AS PAYMENT_CREATE_DT, TL1.TLFullName AS GDV, TL2.TLFullName AS KSV, C.APPROVE_DT_KT
-- SELECT END
        FROM TR_REQ_BUDGET_MONTH_LIMIT_DETAIL A
		--LEFT JOIN TR_REQ_BUDGET_YEAR_LIMIT B ON A.BRANCH_ID = B.BRANCH_ID AND A.DEP_ID = B.DEP_ID AND A.GD_ID = B.GD_ID
		LEFT JOIN TR_REQ_PAYMENT C ON A.REQ_PAY_ID = C.REQ_PAY_ID
    LEFT JOIN TR_REQ_PAY_BUDGET trpb ON trpb.REQ_PAY_ID = C.REQ_PAY_ID AND trpb.BRANCH_KIND = @p_BRANCH_KIND
		LEFT JOIN TL_USER TL1 ON C.MAKER_ID_KT = TL1.TLNANME
		LEFT JOIN TL_USER TL2 ON C.CHECKER_ID_KT = TL2.TLNANME
		LEFT JOIN CM_BRANCH CM ON A.BRANCH_ID = CM.BRANCH_ID
		LEFT JOIN CM_DEPARTMENT DP ON A.DEP_ID = DP.DEP_ID
        WHERE 1=1
			AND A.GD_ID = @p_GD_ID 
			AND A.BRANCH_ID = @p_BRANCH_ID 
			AND (A.DEP_ID = @p_DEP_ID OR  A.BRANCH_ID <> 'DV0001')
			AND A.RECORD_STATUS = '1'
			AND A.BUDGET_YEAR = @p_BUDGET_YEAR
			AND (  ( M1 <> 0  AND @p_BUDGET_MONTH = 'M1' )
				OR ( M2 <> 0  AND @p_BUDGET_MONTH = 'M2' )
				OR ( M3 <> 0  AND @p_BUDGET_MONTH = 'M3' )
				OR ( M4 <> 0  AND @p_BUDGET_MONTH = 'M4' )
				OR ( M5 <> 0  AND @p_BUDGET_MONTH = 'M5' )
				OR ( M6 <> 0  AND @p_BUDGET_MONTH = 'M6' )
				OR ( M7 <> 0  AND @p_BUDGET_MONTH = 'M7' )
				OR ( M8 <> 0  AND @p_BUDGET_MONTH = 'M8' )
				OR ( M9 <> 0  AND @p_BUDGET_MONTH = 'M9' )
				OR ( M10 <> 0 AND @p_BUDGET_MONTH = 'M10')
				OR ( M11 <> 0 AND @p_BUDGET_MONTH = 'M11')
				OR ( M12 <> 0 AND @p_BUDGET_MONTH = 'M12')
			)
      AND A.BRANCH_KIND = @p_BRANCH_KIND
    GROUP BY A.BUDGET_MONTH_LIMIT_DETAIL_ID, C.REQ_PAY_ID, C.REQ_PAY_CODE, CM.BRANCH_NAME, DP.DEP_NAME,trpb.AMT_EXE,trpb.REASON,
    C.CREATE_DT, TL1.TLFullName, TL2.TLFullName, C.APPROVE_DT_KT,A.CREATE_DT
		ORDER BY A.CREATE_DT DESC
-- PAGING END
    END;
    ELSE 
	BEGIN
-- PAGING BEGIN
        SELECT TOP(CONVERT(INT, @p_TOP)) A.BUDGET_MONTH_LIMIT_DETAIL_ID, C.REQ_PAY_ID, C.REQ_PAY_CODE, CM.BRANCH_NAME, DP.DEP_NAME, 
        trpb.AMT_EXE AS 'REQ_AMT',
        --C.REQ_AMT, 
        trpb.REASON AS 'REQ_REASON',
        --C.REQ_REASON, 
        C.CREATE_DT AS PAYMENT_CREATE_DT, TL1.TLFullName AS GDV, TL2.TLFullName AS KSV, C.APPROVE_DT_KT
-- SELECT END
        FROM TR_REQ_BUDGET_MONTH_LIMIT_DETAIL A
		--LEFT JOIN TR_REQ_BUDGET_YEAR_LIMIT B ON A.BRANCH_ID = B.BRANCH_ID AND A.DEP_ID = B.DEP_ID AND A.GD_ID = B.GD_ID
		LEFT JOIN TR_REQ_PAYMENT C ON A.REQ_PAY_ID = C.REQ_PAY_ID
    LEFT JOIN TR_REQ_PAY_BUDGET trpb ON trpb.REQ_PAY_ID = C.REQ_PAY_ID AND trpb.BRANCH_KIND = @p_BRANCH_KIND
		LEFT JOIN TL_USER TL1 ON C.MAKER_ID_KT = TL1.TLNANME
		LEFT JOIN TL_USER TL2 ON C.CHECKER_ID_KT = TL2.TLNANME
		LEFT JOIN CM_BRANCH CM ON A.BRANCH_ID = CM.BRANCH_ID
		LEFT JOIN CM_DEPARTMENT DP ON A.DEP_ID = DP.DEP_ID
        WHERE 1=1
			AND A.GD_ID = @p_GD_ID 
			AND A.BRANCH_ID = @p_BRANCH_ID 
			AND (A.DEP_ID = @p_DEP_ID OR  A.BRANCH_ID <> 'DV0001')
			AND A.RECORD_STATUS = '1'
			AND A.BUDGET_YEAR = @p_BUDGET_YEAR
			AND (  ( M1 <> 0  AND @p_BUDGET_MONTH = 'M1' )
				OR ( M2 <> 0  AND @p_BUDGET_MONTH = 'M2' )
				OR ( M3 <> 0  AND @p_BUDGET_MONTH = 'M3' )
				OR ( M4 <> 0  AND @p_BUDGET_MONTH = 'M4' )
				OR ( M5 <> 0  AND @p_BUDGET_MONTH = 'M5' )
				OR ( M6 <> 0  AND @p_BUDGET_MONTH = 'M6' )
				OR ( M7 <> 0  AND @p_BUDGET_MONTH = 'M7' )
				OR ( M8 <> 0  AND @p_BUDGET_MONTH = 'M8' )
				OR ( M9 <> 0  AND @p_BUDGET_MONTH = 'M9' )
				OR ( M10 <> 0 AND @p_BUDGET_MONTH = 'M10')
				OR ( M11 <> 0 AND @p_BUDGET_MONTH = 'M11')
				OR ( M12 <> 0 AND @p_BUDGET_MONTH = 'M12')
			)
      AND A.BRANCH_KIND = @p_BRANCH_KIND
      GROUP BY A.BUDGET_MONTH_LIMIT_DETAIL_ID, C.REQ_PAY_ID, C.REQ_PAY_CODE, CM.BRANCH_NAME, DP.DEP_NAME,trpb.AMT_EXE,trpb.REASON,
        C.CREATE_DT, TL1.TLFullName, TL2.TLFullName, C.APPROVE_DT_KT,A.CREATE_DT
		ORDER BY A.CREATE_DT DESC
-- PAGING END
    END;
END -- PAGING