ALTER PROCEDURE dbo.rpt_INVENTORY_BYID
	@sp_BRANCH_ID varchar(20) = null, 
	@sp_BRANCH_LOGIN VARCHAR(20) = NULL,
	@sp_INVENT_ID VARCHAR(15) = NULL,	
  @SP_TYPE_ID VARCHAR(15) = NULL
AS
BEGIN

--thieuvq 19/7/2016 - DOC DU LIEU BO QUA COMMIT TRANSACTION  
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED 
--

--declare @tmp table(BRANCH_ID varchar(15))
--insert into @tmp  SELECT BRANCH_ID FROM [dbo].[CM_BRANCH_GETCHILDID](@p_BRANCH_ID)
--declare @tmp_login table(BRANCH_ID varchar(15))
--insert into @tmp_login  SELECT BRANCH_ID FROM [dbo].[CM_BRANCH_GETCHILDID](@p_BRANCH_LOGIN)
declare @l_NGAYSAOKE DATE/*datetime*/ = null,
@p_FromdateSK DATE--datetime

SET @l_NGAYSAOKE = (SELECT TOP 1 CONVERT(DATE,INVENTORY_DT) FROM ASS_INVENTORY_MASTER WHERE INVENT_ID = @sp_INVENT_ID)
SET @p_FromdateSK = @l_NGAYSAOKE


DECLARE @tmp TABLE(GROUP_ID VARCHAR(15), LEVEL_CODE NVARCHAR(MAX), ASSET_CODE NVARCHAR(MAX))

INSERT INTO @tmp
(
    GROUP_ID,
    LEVEL_CODE,
    ASSET_CODE
)
SELECT GROUP_ID, CASE WHEN TYPE_ID = 'CCLD' THEN [dbo].[FN_GET_GROUPCODE](GROUP_ID,'1') 
ELSE [dbo].[FN_GET_GROUPCODE](GROUP_ID,'2') END AS LEVEL_CODE,
CASE WHEN TYPE_ID = 'CCLD' THEN [dbo].[FN_GET_GROUPNAME](GROUP_ID,'1') ELSE
[dbo].[FN_GET_GROUPNAME](GROUP_ID,'2') END AS ASSET_CODE
FROM dbo.ASS_GROUP

IF EXISTS (SELECT 1 FROM ASS_INVENTORY_DT_RPT WHERE INVENT_ID = @sp_INVENT_ID)
BEGIN
SELECT * FROM
(
	SELECT 
	Row_number() over(PARTITION BY T.LEVEL_CODE order by B.ASSET_NAME) AS STT,
	CM.BRANCH_CODE +' - ' +CM.BRANCH_NAME AS DVSD, -- DON VI SU DUNG
	CE.DEP_CODE +' - '+CE.DEP_NAME AS PBSD, -- PHONG BAN SU DUNG
	LEVEL_CODE,
	T.LEVEL_CODE AS NHOM_TS4, -- MA LOAI TAI SAN
	B.ASSET_CODE AS MS_TS, -- MÃ SỐ TÀI SẢN
	B.ASSET_NAME AS TEN_TS, --TEN TAI SAN
	B.ASSET_SERIAL_NO AS SERIAL, -- SO SERIAL
	B.AMORT_START_DATE AS NGAY_BD_KH, -- NGAY BAT DAU KHAU HAO
	B.AMORT_MONTH AS SOTHANG_KHAUHAO, -- THOI GIAN KHAU HAO
	B.AMORTIZED_MONTH - ISNULL(AMT.ST_KH_PD_TAM,0) DA_KH, -- THOI GIAN DA KHAU HAO
	(B.AMORT_MONTH -(B.AMORTIZED_MONTH - ISNULL(AMT.ST_KH_PD_TAM,0))) TG_KH_CONLAI, -- THOI GIAN KHAU HAO CON LAI
	GTN.NGUYEN_GIA AS NGUYEN_GIA_TO, -- SO DU NGUYEN GIA CUOI KY
	CLN.KHAU_HAO AS KHAU_HAO_LK_TO, -- SO DU KHAU HAO CUOI KY
	(GTN.NGUYEN_GIA - CLN.KHAU_HAO) AS GIA_TRI_CL_TO, -- GIA TRI CON LAI
	B.ASSET_DESC AS THONG_TIN_MO_TA, -- THONG TIN MO TA
	D.STATUS_NAME AS TINHTRANGKIEMKE,
	A.INVENT_DESC AS HIEN_TRANG, --HIEN TRANG		
	A.NOTES AS GHI_CHU, -- GHI CHU
	(CASE  WHEN aidl.LOG_ID IS NULL THEN N'Chưa kiểm kê' ELSE N'Đã kiểm kê' END) AS TRANGTHAIKK
	FROM ASS_INVENTORY_DT_RPT A
	INNER JOIN ASS_MASTER B ON A.ASSET_ID = B.ASSET_ID
	LEFT JOIN ASS_INVENTORY_DT_LOG aidl ON (A.INVENTDT_ID=aidl.INVENTDT_ID)
	LEFT JOIN @tmp T ON B.GROUP_ID = T.GROUP_ID
	--LEFT JOIN CM_BRANCH CM ON B.BRANCH_ID = CM.BRANCH_ID
	LEFT JOIN CM_BRANCH CM ON A.BRANCH_USE = CM.BRANCH_ID
	LEFT JOIN CM_BRANCH CMP ON CM.FATHER_ID = CMP.BRANCH_ID
	LEFT JOIN ASS_STATUS D ON A.ASSET_STATUS = D.STATUS_ID
	LEFT JOIN CM_DEPARTMENT CE ON B.DEPT_ID = CE.DEP_ID	
	--LEFT JOIN CM_DEPARTMENT CE ON A.DEPT_USE = CE.DEP_ID	
	LEFT JOIN
	(
		--SELECT X.ASSET_ID,ISNULL(SUM(X.AMORT_AMT),0) AS TONG_KH_DAU
		SELECT X.ASSET_ID,ISNULL(SUM(CASE X.CRDR  WHEN 'C' THEN X.AMORT_AMT WHEN 'D' THEN -X.AMORT_AMT END),0) AS KHAU_HAO
		FROM ASS_AMORT_DT X
		--INNER JOIN ASS_AMORT Y ON X.AMORT_ID = Y.AMORT_ID
		--INNER JOIN ASS_MASTER Z ON X.ASSET_ID = Z.ASSET_ID
		WHERE 
		--(X.AMORT_DT >= CONVERT(DATE,Z.AMORT_START_DATE)) AND (CONVERT(DATE,Z.LIQUIDATION_DT) > CONVERT(DATE,@p_FromdateSK,103) OR Z.LIQUIDATION_DT IS NULL OR Z.LIQUIDATION_DT = '')
		--AND 
		(X.AMORT_DT <= @p_FromdateSK OR @p_FromdateSK IS NULL OR @p_FromdateSK = '')
		GROUP BY X.ASSET_ID
	) CLN ON A.ASSET_ID = CLN.ASSET_ID
	----NHUNG TAI SAN DESCRIPTION = 'UPLOAD TSCD/CCLD' CO TRN_DT <> CREATE
	LEFT JOIN
	(
		SELECT X.ASSET_ID,ISNULL(SUM(CASE X.CRDR  WHEN 'C' THEN X.ASSET_AMT WHEN 'D' THEN -X.ASSET_AMT END),0) AS NGUYEN_GIA 
		FROM ASS_VALUES X
		--INNER JOIN ASS_MASTER Y ON X.ASSET_ID = Y.ASSET_ID
		WHERE (X.TRN_DT <= @p_FromdateSK OR @p_FromdateSK IS NULL OR @p_FromdateSK = '') 
		--(X.CREATE_DT >= Y.CREATE_DT) 
		--AND (X.CREATE_DT <= CONVERT(DATETIME,@p_Fromdate,103) OR @p_Fromdate IS NULL OR @p_Fromdate = '')
		GROUP BY X.ASSET_ID
	) GTN ON A.ASSET_ID = GTN.ASSET_ID
	------END THIEUVQ 16062020-----
	-- TINH SO THANG DA KHAU HAO = AMORTED_MONTH - SỐ THÁNG ĐÃ KHẤU HAO : AMORT_DT > TO_DATE
	LEFT JOIN 
	(
		--SELECT AM_DT.ASSET_ID, ISNULL(SUM(ISNULL(AM_DT.AMORT_AMT,0)),0) AS ST_DA_PB FROM ASS_AMORT_DT AM_DT 
		SELECT AM_DT.ASSET_ID, ISNULL(COUNT (*),0) AS ST_KH_PD_TAM
		FROM ASS_AMORT_DT AM_DT 
		WHERE CONVERT(DATE,AM_DT.AMORT_DT) > CONVERT(DATE,@p_FromdateSK,103)
		AND AM_DT.CRDR='C'
		GROUP BY AM_DT.ASSET_ID
	) AMT ON AMT.ASSET_ID = A.ASSET_ID
	WHERE 
	 A.INVENT_ID = @sp_INVENT_ID
	 --THIEUVQ THEM DIEU KIEN KHONG XUAT RA BAO CAO DS TAI SAN THIEU SO VOI SAO KE - ANH TAN 02122016
	 AND A.ASSET_STATUS <> '6'--THUA SO VOI SAO KE
   AND B.TYPE_ID= @SP_TYPE_ID OR @SP_TYPE_ID IS NULL OR @SP_TYPE_ID =''
	 UNION ALL

	 SELECT 
	NULL STT,
  
	T.ASSET_CODE AS DVSD,
--	'' DVSD,
	'' PBSD,
  LEVEL_CODE,
  '' NHOM_TS4,
	'' MS_TS, --MA SO TAI SAN
	'' TEN_TS, --TEN TAI SAN
	'' SERIAL,
	NULL NGAY_BD_KH,
	NULL SOTHANG_KHAUHAO,
	NULL DA_KH,
	NULL TG_KH_CONLAI,
	SUM(GTN.NGUYEN_GIA) AS NGUYEN_GIA_TO,
	SUM(CLN.KHAU_HAO) AS KHAU_HAO_LK_TO,
	SUM((GTN.NGUYEN_GIA - CLN.KHAU_HAO)) AS GIA_TRI_CL_TO,
	'' AS THONG_TIN_MO_TA, -- THONG TIN MO TA
	'' AS TINHTRANGKIEMKE,
	'' AS HIEN_TRANG, --HIEN TRANG		
	'' AS GHI_CHU, -- GHI CHU
	'' AS TRANGTHAIKK
	FROM ASS_INVENTORY_DT_RPT A
	INNER JOIN ASS_MASTER B ON A.ASSET_ID = B.ASSET_ID
	LEFT JOIN @tmp T ON B.GROUP_ID = T.GROUP_ID
	LEFT JOIN
	(
		--SELECT X.ASSET_ID,ISNULL(SUM(X.AMORT_AMT),0) AS TONG_KH_DAU
		SELECT X.ASSET_ID,ISNULL(SUM(CASE X.CRDR  WHEN 'C' THEN X.AMORT_AMT WHEN 'D' THEN -X.AMORT_AMT END),0) AS KHAU_HAO
		FROM ASS_AMORT_DT X
		--INNER JOIN ASS_AMORT Y ON X.AMORT_ID = Y.AMORT_ID
		--INNER JOIN ASS_MASTER Z ON X.ASSET_ID = Z.ASSET_ID
		WHERE 
		--(X.AMORT_DT >= CONVERT(DATE,Z.AMORT_START_DATE)) AND (CONVERT(DATE,Z.LIQUIDATION_DT) > CONVERT(DATE,@p_FromdateSK,103) OR Z.LIQUIDATION_DT IS NULL OR Z.LIQUIDATION_DT = '')
		--AND 
		(X.AMORT_DT <= @p_FromdateSK OR @p_FromdateSK IS NULL OR @p_FromdateSK = '')
		GROUP BY X.ASSET_ID
	) CLN ON A.ASSET_ID = CLN.ASSET_ID
	LEFT JOIN
	(
		SELECT X.ASSET_ID,ISNULL(SUM(CASE X.CRDR  WHEN 'C' THEN X.ASSET_AMT WHEN 'D' THEN -X.ASSET_AMT END),0) AS NGUYEN_GIA 
		FROM ASS_VALUES X
		--INNER JOIN ASS_MASTER Y ON X.ASSET_ID = Y.ASSET_ID
		WHERE (X.TRN_DT <= @p_FromdateSK OR @p_FromdateSK IS NULL OR @p_FromdateSK = '') 
		--(X.CREATE_DT >= Y.CREATE_DT) 
		--AND (X.CREATE_DT <= CONVERT(DATETIME,@p_Fromdate,103) OR @p_Fromdate IS NULL OR @p_Fromdate = '')
		GROUP BY X.ASSET_ID
	) GTN ON A.ASSET_ID = GTN.ASSET_ID
	------END THIEUVQ 16062020-----
	WHERE 
	 A.INVENT_ID = @sp_INVENT_ID
	 --THIEUVQ THEM DIEU KIEN KHONG XUAT RA BAO CAO DS TAI SAN THIEU SO VOI SAO KE - ANH TAN 02122016
	 AND A.ASSET_STATUS <> '6'--THUA SO VOI SAO KE
   AND B.TYPE_ID= @SP_TYPE_ID OR @SP_TYPE_ID IS NULL OR @SP_TYPE_ID =''
	GROUP BY T.LEVEL_CODE ,
				T.ASSET_CODE
) TT
ORDER BY TT.LEVEL_CODE,TT.STT
-----------------------

SELECT 
	SUM(GTN.NGUYEN_GIA) AS NGUYEN_GIA_TO, -- SO DU NGUYEN GIA CUOI KY
	SUM(CLN.KHAU_HAO) AS KHAU_HAO_LK_TO, -- SO DU KHAU HAO CUOI KY
	SUM((GTN.NGUYEN_GIA - CLN.KHAU_HAO)) AS GIA_TRI_CL_TO -- GIA TRI CON LAI
	FROM ASS_INVENTORY_DT_RPT A
  LEFT JOIN ASS_MASTER am ON A.ASSET_ID=am.ASSET_ID
	LEFT JOIN
	(
		--SELECT X.ASSET_ID,ISNULL(SUM(X.AMORT_AMT),0) AS TONG_KH_DAU
		SELECT X.ASSET_ID,ISNULL(SUM(CASE X.CRDR  WHEN 'C' THEN X.AMORT_AMT WHEN 'D' THEN -X.AMORT_AMT END),0) AS KHAU_HAO
		FROM ASS_AMORT_DT X

		--INNER JOIN ASS_AMORT Y ON X.AMORT_ID = Y.AMORT_ID
		--INNER JOIN ASS_MASTER Z ON X.ASSET_ID = Z.ASSET_ID
		WHERE 
		--(X.AMORT_DT >= CONVERT(DATE,Z.AMORT_START_DATE)) AND (CONVERT(DATE,Z.LIQUIDATION_DT) > CONVERT(DATE,@p_FromdateSK,103) OR Z.LIQUIDATION_DT IS NULL OR Z.LIQUIDATION_DT = '')
		--AND 
		(X.AMORT_DT <= @p_FromdateSK OR @p_FromdateSK IS NULL OR @p_FromdateSK = '')
		GROUP BY X.ASSET_ID
	) CLN ON A.ASSET_ID = CLN.ASSET_ID
	----NHUNG TAI SAN DESCRIPTION = 'UPLOAD TSCD/CCLD' CO TRN_DT <> CREATE
	LEFT JOIN
	(
		SELECT X.ASSET_ID,ISNULL(SUM(CASE X.CRDR  WHEN 'C' THEN X.ASSET_AMT WHEN 'D' THEN -X.ASSET_AMT END),0) AS NGUYEN_GIA 
		FROM ASS_VALUES X
		--INNER JOIN ASS_MASTER Y ON X.ASSET_ID = Y.ASSET_ID
		WHERE (X.TRN_DT <= @p_FromdateSK OR @p_FromdateSK IS NULL OR @p_FromdateSK = '') 
		--(X.CREATE_DT >= Y.CREATE_DT) 
		--AND (X.CREATE_DT <= CONVERT(DATETIME,@p_Fromdate,103) OR @p_Fromdate IS NULL OR @p_Fromdate = '')
		GROUP BY X.ASSET_ID
	) GTN ON A.ASSET_ID = GTN.ASSET_ID
	------END THIEUVQ 16062020-----
	-- TINH SO THANG DA KHAU HAO = AMORTED_MONTH - SỐ THÁNG ĐÃ KHẤU HAO : AMORT_DT > TO_DATE
	LEFT JOIN 
	(
		--SELECT AM_DT.ASSET_ID, ISNULL(SUM(ISNULL(AM_DT.AMORT_AMT,0)),0) AS ST_DA_PB FROM ASS_AMORT_DT AM_DT 
		SELECT AM_DT.ASSET_ID, ISNULL(COUNT (*),0) AS ST_KH_PD_TAM
		FROM ASS_AMORT_DT AM_DT 
		WHERE CONVERT(DATE,AM_DT.AMORT_DT) > CONVERT(DATE,@p_FromdateSK,103)
		AND AM_DT.CRDR='C'
		GROUP BY AM_DT.ASSET_ID
	) AMT ON AMT.ASSET_ID = A.ASSET_ID
	WHERE 
	 A.INVENT_ID = @sp_INVENT_ID
	 --THIEUVQ THEM DIEU KIEN KHONG XUAT RA BAO CAO DS TAI SAN THIEU SO VOI SAO KE - ANH TAN 02122016
	 AND A.ASSET_STATUS <> '6'--THUA SO VOI SAO KE
   AND am.TYPE_ID= @SP_TYPE_ID OR @SP_TYPE_ID IS NULL OR @SP_TYPE_ID =''

END
ELSE
BEGIN
	SELECT * FROM
	(
		SELECT 
		Row_number() over(PARTITION BY T.LEVEL_CODE order by B.ASSET_NAME) AS STT,
		CM.BRANCH_CODE +' - ' +CM.BRANCH_NAME AS DVSD, -- DON VI SU DUNG
		CE.DEP_CODE +' - '+CE.DEP_NAME AS PBSD, -- PHONG BAN SU DUNG
    T.LEVEL_CODE,
		T.LEVEL_CODE AS NHOM_TS4, -- MA LOAI TAI SAN
		B.ASSET_CODE AS MS_TS, -- MÃ SỐ TÀI SẢN
		B.ASSET_NAME AS TEN_TS, --TEN TAI SAN
		B.ASSET_SERIAL_NO AS SERIAL, -- SO SERIAL
		B.AMORT_START_DATE AS NGAY_BD_KH, -- NGAY BAT DAU KHAU HAO
		B.AMORT_MONTH AS SOTHANG_KHAUHAO, -- THOI GIAN KHAU HAO
		B.AMORTIZED_MONTH - ISNULL(AMT.ST_KH_PD_TAM,0) DA_KH, -- THOI GIAN DA KHAU HAO
		(B.AMORT_MONTH -(B.AMORTIZED_MONTH - ISNULL(AMT.ST_KH_PD_TAM,0))) TG_KH_CONLAI, -- THOI GIAN KHAU HAO CON LAI
		GTN.NGUYEN_GIA AS NGUYEN_GIA_TO, -- SO DU NGUYEN GIA CUOI KY
		CLN.KHAU_HAO AS KHAU_HAO_LK_TO, -- SO DU KHAU HAO CUOI KY
		(GTN.NGUYEN_GIA - CLN.KHAU_HAO) AS GIA_TRI_CL_TO, -- GIA TRI CON LAI
		B.ASSET_DESC AS THONG_TIN_MO_TA, -- THONG TIN MO TA
		D.STATUS_NAME AS TINHTRANGKIEMKE,
		A.INVENT_DESC AS HIEN_TRANG, --HIEN TRANG		
		A.NOTES AS GHI_CHU, -- GHI CHU
	(CASE  WHEN aidl.LOG_ID IS NULL THEN N'Chưa kiểm kê' ELSE N'Đã kiểm kê' END) AS TRANGTHAIKK
		FROM ASS_INVENTORY_DT A
		INNER JOIN ASS_MASTER B ON A.ASSET_ID = B.ASSET_ID
		LEFT JOIN ASS_INVENTORY_DT_LOG aidl ON (A.INVENTDT_ID=aidl.INVENTDT_ID)
		LEFT JOIN @tmp T ON B.GROUP_ID = T.GROUP_ID
		--LEFT JOIN CM_BRANCH CM ON B.BRANCH_ID = CM.BRANCH_ID
		LEFT JOIN CM_BRANCH CM ON A.BRANCH_USE = CM.BRANCH_ID
		LEFT JOIN CM_BRANCH CMP ON CM.FATHER_ID = CMP.BRANCH_ID
		LEFT JOIN ASS_STATUS D ON A.ASSET_STATUS = D.STATUS_ID
		LEFT JOIN CM_DEPARTMENT CE ON B.DEPT_ID = CE.DEP_ID	
		--LEFT JOIN CM_DEPARTMENT CE ON A.DEPT_USE = CE.DEP_ID	
		LEFT JOIN
		(
			--SELECT X.ASSET_ID,ISNULL(SUM(X.AMORT_AMT),0) AS TONG_KH_DAU
			SELECT X.ASSET_ID,ISNULL(SUM(CASE X.CRDR  WHEN 'C' THEN X.AMORT_AMT WHEN 'D' THEN -X.AMORT_AMT END),0) AS KHAU_HAO
			FROM ASS_AMORT_DT X
			--INNER JOIN ASS_AMORT Y ON X.AMORT_ID = Y.AMORT_ID
			--INNER JOIN ASS_MASTER Z ON X.ASSET_ID = Z.ASSET_ID
			WHERE 
			--(X.AMORT_DT >= CONVERT(DATE,Z.AMORT_START_DATE)) AND (CONVERT(DATE,Z.LIQUIDATION_DT) > CONVERT(DATE,@p_FromdateSK,103) OR Z.LIQUIDATION_DT IS NULL OR Z.LIQUIDATION_DT = '')
			--AND 
			(X.AMORT_DT <= @p_FromdateSK OR @p_FromdateSK IS NULL OR @p_FromdateSK = '')
			GROUP BY X.ASSET_ID
		) CLN ON A.ASSET_ID = CLN.ASSET_ID	
		----NHUNG TAI SAN DESCRIPTION = 'UPLOAD TSCD/CCLD' CO TRN_DT <> CREATE
		LEFT JOIN
		(
			SELECT X.ASSET_ID,ISNULL(SUM(CASE X.CRDR  WHEN 'C' THEN X.ASSET_AMT WHEN 'D' THEN -X.ASSET_AMT END),0) AS NGUYEN_GIA 
			FROM ASS_VALUES X
			--INNER JOIN ASS_MASTER Y ON X.ASSET_ID = Y.ASSET_ID
			WHERE (X.TRN_DT <= @p_FromdateSK OR @p_FromdateSK IS NULL OR @p_FromdateSK = '') 
			--(X.CREATE_DT >= Y.CREATE_DT) 
			--AND (X.CREATE_DT <= CONVERT(DATETIME,@p_Fromdate,103) OR @p_Fromdate IS NULL OR @p_Fromdate = '')
			GROUP BY X.ASSET_ID
		) GTN ON A.ASSET_ID = GTN.ASSET_ID
		------END THIEUVQ 16062020-----
		LEFT JOIN 
		(
			--SELECT AM_DT.ASSET_ID, ISNULL(SUM(ISNULL(AM_DT.AMORT_AMT,0)),0) AS ST_DA_PB FROM ASS_AMORT_DT AM_DT 
			SELECT AM_DT.ASSET_ID, ISNULL(COUNT (*),0) AS ST_KH_PD_TAM
			FROM ASS_AMORT_DT AM_DT 
			WHERE CONVERT(DATE,AM_DT.AMORT_DT) > CONVERT(DATE,@p_FromdateSK,103)
			AND AM_DT.CRDR='C'
			GROUP BY AM_DT.ASSET_ID
		) AMT ON AMT.ASSET_ID = A.ASSET_ID
		WHERE 
		 A.INVENT_ID = @sp_INVENT_ID
		 --THIEUVQ THEM DIEU KIEN KHONG XUAT RA BAO CAO DS TAI SAN THIEU SO VOI SAO KE - ANH TAN 02122016
		 AND A.ASSET_STATUS <> '6'--THUA SO VOI SAO KE
     AND B.TYPE_ID= @SP_TYPE_ID OR @SP_TYPE_ID IS NULL OR @SP_TYPE_ID =''
		 UNION ALL

		 SELECT 
		NULL STT,
		'' DVSD,
		'' PBSD,
    T.LEVEL_CODE,
		T.ASSET_CODE AS NHOM_TS4,
		'' MS_TS, --MA SO TAI SAN
		'' TEN_TS, --TEN TAI SAN
		'' SERIAL,
		NULL NGAY_BD_KH,
		NULL SOTHANG_KHAUHAO,
		NULL DA_KH,
		NULL TG_KH_CONLAI,
		SUM(GTN.NGUYEN_GIA) AS NGUYEN_GIA_TO,
		SUM(CLN.KHAU_HAO) AS KHAU_HAO_LK_TO,
		SUM((GTN.NGUYEN_GIA - CLN.KHAU_HAO)) AS GIA_TRI_CL_TO,
		'' AS THONG_TIN_MO_TA, -- THONG TIN MO TA
		'' AS TINHTRANGKIEMKE,
		'' AS HIEN_TRANG, --HIEN TRANG		
		'' AS GHI_CHU,-- GHI CHU
    '' AS TRANGTHAIKK
		FROM ASS_INVENTORY_DT A
		INNER JOIN ASS_MASTER B ON A.ASSET_ID = B.ASSET_ID
		LEFT JOIN @tmp T ON B.GROUP_ID = T.GROUP_ID
		LEFT JOIN
		(
			--SELECT X.ASSET_ID,ISNULL(SUM(X.AMORT_AMT),0) AS TONG_KH_DAU
			SELECT X.ASSET_ID,ISNULL(SUM(CASE X.CRDR  WHEN 'C' THEN X.AMORT_AMT WHEN 'D' THEN -X.AMORT_AMT END),0) AS KHAU_HAO
			FROM ASS_AMORT_DT X
			--INNER JOIN ASS_AMORT Y ON X.AMORT_ID = Y.AMORT_ID
			--INNER JOIN ASS_MASTER Z ON X.ASSET_ID = Z.ASSET_ID
			WHERE 
			--(X.AMORT_DT >= CONVERT(DATE,Z.AMORT_START_DATE)) AND (CONVERT(DATE,Z.LIQUIDATION_DT) > CONVERT(DATE,@p_FromdateSK,103) OR Z.LIQUIDATION_DT IS NULL OR Z.LIQUIDATION_DT = '')
			--AND 
			(X.AMORT_DT <= @p_FromdateSK OR @p_FromdateSK IS NULL OR @p_FromdateSK = '')
			GROUP BY X.ASSET_ID
		) CLN ON A.ASSET_ID = CLN.ASSET_ID	
		LEFT JOIN
		(
			SELECT X.ASSET_ID,ISNULL(SUM(CASE X.CRDR  WHEN 'C' THEN X.ASSET_AMT WHEN 'D' THEN -X.ASSET_AMT END),0) AS NGUYEN_GIA 
			FROM ASS_VALUES X
			--INNER JOIN ASS_MASTER Y ON X.ASSET_ID = Y.ASSET_ID
			WHERE (X.TRN_DT <= @p_FromdateSK OR @p_FromdateSK IS NULL OR @p_FromdateSK = '') 
			--(X.CREATE_DT >= Y.CREATE_DT) 
			--AND (X.CREATE_DT <= CONVERT(DATETIME,@p_Fromdate,103) OR @p_Fromdate IS NULL OR @p_Fromdate = '')
			GROUP BY X.ASSET_ID
		) GTN ON A.ASSET_ID = GTN.ASSET_ID
		------END THIEUVQ 16062020-----
		WHERE 
		 A.INVENT_ID = @sp_INVENT_ID
		 --THIEUVQ THEM DIEU KIEN KHONG XUAT RA BAO CAO DS TAI SAN THIEU SO VOI SAO KE - ANH TAN 02122016
		 AND A.ASSET_STATUS <> '6'--THUA SO VOI SAO KE
     --PHONGNT 15/01/23 THEM DDK LOAI TAI SAN
     AND B.TYPE_ID= @SP_TYPE_ID
		GROUP BY T.LEVEL_CODE ,
					T.ASSET_CODE
	) TT
	ORDER BY TT.LEVEL_CODE,TT.STT

SELECT 

		SUM(GTN.NGUYEN_GIA) AS NGUYEN_GIA_TO, -- SO DU NGUYEN GIA CUOI KY
  	SUM(CLN.KHAU_HAO) AS KHAU_HAO_LK_TO, -- SO DU KHAU HAO CUOI KY
  	SUM((GTN.NGUYEN_GIA - CLN.KHAU_HAO)) AS GIA_TRI_CL_TO -- GIA TRI CON LAI
		FROM ASS_INVENTORY_DT A
    LEFT JOIN ASS_MASTER am ON A.ASSET_ID=am.ASSET_ID
		LEFT JOIN
		(
			--SELECT X.ASSET_ID,ISNULL(SUM(X.AMORT_AMT),0) AS TONG_KH_DAU
			SELECT X.ASSET_ID,ISNULL(SUM(CASE X.CRDR  WHEN 'C' THEN X.AMORT_AMT WHEN 'D' THEN -X.AMORT_AMT END),0) AS KHAU_HAO
			FROM ASS_AMORT_DT X
			--INNER JOIN ASS_AMORT Y ON X.AMORT_ID = Y.AMORT_ID
			--INNER JOIN ASS_MASTER Z ON X.ASSET_ID = Z.ASSET_ID
			WHERE 
			--(X.AMORT_DT >= CONVERT(DATE,Z.AMORT_START_DATE)) AND (CONVERT(DATE,Z.LIQUIDATION_DT) > CONVERT(DATE,@p_FromdateSK,103) OR Z.LIQUIDATION_DT IS NULL OR Z.LIQUIDATION_DT = '')
			--AND 
			(X.AMORT_DT <= @p_FromdateSK OR @p_FromdateSK IS NULL OR @p_FromdateSK = '')
			GROUP BY X.ASSET_ID
		) CLN ON A.ASSET_ID = CLN.ASSET_ID	
		----NHUNG TAI SAN DESCRIPTION = 'UPLOAD TSCD/CCLD' CO TRN_DT <> CREATE
		LEFT JOIN
		(
			SELECT X.ASSET_ID,ISNULL(SUM(CASE X.CRDR  WHEN 'C' THEN X.ASSET_AMT WHEN 'D' THEN -X.ASSET_AMT END),0) AS NGUYEN_GIA 
			FROM ASS_VALUES X
			--INNER JOIN ASS_MASTER Y ON X.ASSET_ID = Y.ASSET_ID
			WHERE (X.TRN_DT <= @p_FromdateSK OR @p_FromdateSK IS NULL OR @p_FromdateSK = '') 
			--(X.CREATE_DT >= Y.CREATE_DT) 
			--AND (X.CREATE_DT <= CONVERT(DATETIME,@p_Fromdate,103) OR @p_Fromdate IS NULL OR @p_Fromdate = '')
			GROUP BY X.ASSET_ID
		) GTN ON A.ASSET_ID = GTN.ASSET_ID
		------END THIEUVQ 16062020-----
		LEFT JOIN 
		(
			--SELECT AM_DT.ASSET_ID, ISNULL(SUM(ISNULL(AM_DT.AMORT_AMT,0)),0) AS ST_DA_PB FROM ASS_AMORT_DT AM_DT 
			SELECT AM_DT.ASSET_ID, ISNULL(COUNT (*),0) AS ST_KH_PD_TAM
			FROM ASS_AMORT_DT AM_DT 
			WHERE CONVERT(DATE,AM_DT.AMORT_DT) > CONVERT(DATE,@p_FromdateSK,103)
			AND AM_DT.CRDR='C'
			GROUP BY AM_DT.ASSET_ID
		) AMT ON AMT.ASSET_ID = A.ASSET_ID
    WHERE 
		 A.INVENT_ID = @sp_INVENT_ID
		 --THIEUVQ THEM DIEU KIEN KHONG XUAT RA BAO CAO DS TAI SAN THIEU SO VOI SAO KE - ANH TAN 02122016
		 AND A.ASSET_STATUS <> '6'--THUA SO VOI SAO KE
     --PHONGNT 15/01/23 THEM DDK LOAI TAI SAN
     AND am.TYPE_ID= @SP_TYPE_ID
END
END