ALTER PROCEDURE [dbo].[BUD_CONTRACT_MASTER_GetInternalArea]
@p_BUIDING_AREA_ID	varchar(15) = NULL
AS
BEGIN -- PAGING

--SELECT B.CONTRACT_ID,G.BUILDING_NAME ,C.FLOOR_NO, ISNULL(A.DIEN_TICH_CAN_SD,0) AS DIEN_TICH_SD_NOI_BO,
--	B.INPUT_DT,
--	D.BRANCH_NAME, E.DEP_NAME,
--	A.REASON, 
--	ISNULL(A.TOTAL_AMT,0) AS THANH_TIEN, 
--	B.CREATE_DT, B.MAKER_ID, B.APPROVE_DT, B.CHECKER_ID, F.AUTH_STATUS_NAME
---- SELECT END
--FROM BUD_CONTRACT_DT A
--	LEFT JOIN BUD_CONTRACT_MASTER B ON A.CONTRACT_ID = B.CONTRACT_ID
--	LEFT JOIN BUD_AREA_DT C ON A.BUILDING_AREA_ID = C.BUILDING_AREA_ID
--	LEFT JOIN CM_BRANCH D ON A.BRANCH_ID = D.BRANCH_ID
--	LEFT JOIN CM_DEPARTMENT E ON A.DEP_ID = E.DEP_ID
--	LEFT JOIN CM_AUTH_STATUS F ON B.AUTH_STATUS = F.AUTH_STATUS
--	LEFT JOIN BUD_MASTER G ON A.BUILD_ID = G.BUILDING_ID
--WHERE 1 = 1 
--	AND C.BUILDING_AREA_ID = @p_BUIDING_AREA_ID 
--	AND B.AUTH_STATUS = 'A'

-- PAGING BEGIN
	SELECT
	A.CONTRACT_ID, C.BUILDING_NAME, D.FLOOR_NO, 
	ISNULL(A.INTERNAL_AREA, 0) AS DIEN_TICH_SD_NOI_BO,
	B.INPUT_DT,
	E.BRANCH_NAME, F.DEP_NAME,
	G.REASON,
	A.TOTAL_AMT AS THANH_TIEN,
	A.CREATE_DT, A.MAKER_ID, A.CHECKER_ID, A.APPROVE_DT, H.AUTH_STATUS_NAME
-- SELECT END
	FROM BUD_CONTRACT_LOG A
	LEFT JOIN BUD_CONTRACT_MASTER B ON A.CONTRACT_ID = B.CONTRACT_ID
	LEFT JOIN BUD_MASTER C ON B.BUILDING_ID = C.BUILDING_ID
	LEFT JOIN BUD_AREA_DT D ON A.BUILDING_AREA_ID = D.BUILDING_AREA_ID
	LEFT JOIN CM_BRANCH E ON A.BRANCH_RENT_ID = E.BRANCH_ID
	LEFT JOIN CM_DEPARTMENT F ON A.DEP_RENT_ID = F.DEP_ID
	LEFT JOIN BUD_CONTRACT_DT G ON B.CONTRACT_ID = G.CONTRACT_ID AND G.BUILDING_AREA_ID = A.BUILDING_AREA_ID
	LEFT JOIN CM_AUTH_STATUS H ON A.AUTH_STATUS = H.AUTH_STATUS
	
	WHERE 1 = 1
	AND D.BUILDING_AREA_ID = @p_BUIDING_AREA_ID
	AND B.AUTH_STATUS = 'A'
-- PAGING END
END -- PAGING