DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN - NH BẢN VIỆT - GD3

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