ALTER PROCEDURE [dbo].[ASS_MASTER_Search]
	@p_ASSET_ID			varchar(15) = NULL,
	@p_TYPE_ID			varchar(15) = NULL,
	@p_GROUP_ID			varchar(15) = NULL,
	@p_ASSET_CODE		nvarchar(MAX) = NULL,
	@p_ASSET_NAME		nvarchar(1000) = NULL,
	@p_ASSET_SERIAL_NO	nvarchar(MAX) = NULL,
	@p_ASSET_DESC		nvarchar(MAX) = NULL,
	@p_SUP_ID			varchar(15) = NULL,
	@p_BUY_PRICE		decimal(18,2) = NULL,
	@p_AMORT_AMT		decimal(18,2) = NULL,
	@p_ASS_TYPE			varchar(1) = NULL,
	@p_ASS_CAT			varchar(10) = NULL,
	@p_BRANCH_ID		varchar(15) = NULL,
	@p_BRANCH_LOGIN		varchar(15) = NULL,
	@p_DEPT_ID			varchar(15) = NULL,
	@p_EMP_ID			varchar(15) = NULL,
	@p_DIVISION_ID		varchar(15) = NULL,
	@p_BUY_DATE			varchar(10) = NULL,
	@p_USE_DATE			varchar(10) = NULL,
	@p_SPECIAL_ASS		varchar(1) = NULL,
	@p_AMORT_MONTH		decimal(18,2) = NULL,
	@p_AMORT_RATE		decimal(18,2) = NULL,
	@p_AMORT_START_DATE	varchar(10) = NULL,
	@p_AMORT_END_DATE	varchar(10) = NULL,
	@p_FIRST_AMORT_AMT	decimal(18,2) = NULL,
	@p_AMORTIZED_MONTH	decimal(18,2)= NULL,
	@p_REMAIN_MONTH		decimal(18,2) = NULL, --so thang khau hao con lai
	@p_AMORTIZED_AMT	decimal(18,2) = NULL,
	@p_PO_ID			varchar(15) = NULL,
	@p_WAREHOUSE_ID		varchar(15) = NULL,
	@p_LOCATION			nvarchar(500) = NULL,
	@p_REF_ASSET_ID		varchar(15) = NULL,
	@p_REF_AMORTIZED_AMT decimal(18,2) = NULL,
	@p_WARRANTY_MONTHS	INT = NULL,
	@p_NOTES			nvarchar(1000) = NULL,
	@p_AMORT_STATUS		nvarchar(50) = NULL, --Neu muon list nhieu trang thai thi trueyn vao nhieu status cach dau bang dau , vidu: 'VNM,CKH'
	@p_ASS_STATUS		nvarchar(20) = NULL,	
	@p_ASS_STATUS_DESC	nvarchar(1000) = NULL,
	@p_TOP				INT = NULL,
	@p_ORDER_BY			varchar(500) = 1,
	@p_LEVEL			varchar(10) = NULL,
	@p_USE_STATUS			varchar(15) = NULL,
	--- LUCTV 22-03-2019 BO SUNG 1 SO FIELD HO TRO TIM KIEM
	@p_EMP_CODE NVARCHAR(500) = NULL,
	@p_EMP_NAME NVARCHAR(500) = NULL,
	@p_ADDNEWID VARCHAR(20) = NULL,
	@p_ADDNEW_NOTES NVARCHAR(1000) = NULL,
	@p_USE_MASTER_ID VARCHAR(50) = NULL,
	@P_YEAR VARCHAR(5) = NULL,
	@P_USER_LOGIN VARCHAR(100) = NULL,
	@P_MENU_CALL VARCHAR(100) = NULL
AS
--thieuvq 19/7/2016 - DOC DU LIEU BO QUA COMMIT TRANSACTION 
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED 
--
--gan tam sau khi golive thi xoa thieuvq 05082015
--IF @p_ASSET_NAME = 'khoinm15479' OR @p_ASSET_NAME = 'nghiann17858'
--BEGIN
--	SET @p_ASSET_NAME = ''
--	SET @p_LEVEL = 'ALL'
--END
DECLARE @l_LSTASSETCODE TABLE (
		[ID] [int] IDENTITY(1,1) NOT NULL,
		[VALUE] [VARCHAR](MAX) NULL)
		INSERT INTO @l_LSTASSETCODE SELECT VALUE FROM WSISPLIT(@p_ASSET_CODE,',')
--DIEU CHINH CHO PHEP SEARCH TOAN HANG - CHI THAO - 5/9/2016
--IF @p_ASS_CAT = 'CAR' BEGIN SET @p_LEVEL = 'ALL' END

BEGIN -- PAGING
	IF(@P_MENU_CALL = 'AssUseMultiBVBMaster')
	BEGIN
		SET @p_LEVEL = 'ALL'
	END
	declare @tmp1 table(BRANCH_ID varchar(15))
	insert into @tmp1  SELECT BRANCH_ID  FROM [dbo].[CM_BRANCH_GETCHILDID](@P_BRANCH_ID)
	declare @tmp2 table(BRANCH_ID varchar(15))

	DECLARE @MENU_PERMISSION NVARCHAR(500) = 'Pages.Administration.AssMaster' --permission của chức năng

	IF(EXISTS(SELECT TLNAME 
				FROM SYS_PERMISSIONS_PAGE_FOR_USER 
				WHERE TLNAME = @p_USER_LOGIN
				AND (DATEDIFF(DAY, CONVERT(DATE, EffectiveDate, 103) , CONVERT(DATE, GETDATE(), 103)) >= 0 OR EffectiveDate IS NULL OR EffectiveDate = '')
				AND (DATEDIFF(DAY, CONVERT(DATE, ExpirationDate, 103) , CONVERT(DATE, GETDATE(), 103)) <= 0 OR ExpirationDate IS NULL OR ExpirationDate = '')
				AND AUTH_STATUS = 'A' AND RECORD_STATUS = '1'))
	BEGIN
		INSERT INTO @tmp2 SELECT BRANCH_ID FROM [dbo].[FN_GET_BRANCH_USER_BY_TLNAME_ROLE_USER]('', @p_USER_LOGIN, @MENU_PERMISSION)
	END
	ELSE
	BEGIN
		insert into @tmp2  SELECT BRANCH_ID  FROM [dbo].[CM_BRANCH_GETCHILDID](@P_BRANCH_LOGIN)
	END
	--IF @p_TOP = '' SET @p_TOP = 1000000
	DECLARE @P_TARGET_BRANCH_ID VARCHAR(15)
	IF @P_TOP IS NULL OR @P_TOP  = ''
	BEGIN  
	-- PAGING BEGIN
		SELECT
				-- LUCTV 28062023_SECRETKEY TÊN PHÒNG BAN ĐIỀU CHỈNH HIỂN THỊ THEO MÃ CODE PHÒNG BAN
				MK.TLSUBBRID,A.MONTHLY_AMORT_AMT,
				A.ASSET_ID, A.[TYPE_ID],C.[TYPE_CODE],  C.[TYPE_NAME], A.GROUP_ID,B.GROUP_CODE, B.GROUP_NAME, B.ASS_CAT, A.ASSET_CODE, A.ASSET_NAME, A.ASSET_SERIAL_NO, A.ASSET_DESC,
				A.SUP_ID, A.BUY_PRICE, A.AMORT_AMT, A.ASS_TYPE, A.BRANCH_ID,BR.BRANCH_CODE,BR.BRANCH_NAME,A.DEPT_ID,DP.DEP_CODE,(DP.DEP_CODE +' - '+ DP.DEP_NAME) AS DEP_NAME, A.EMP_ID,EM.EMP_CODE AS EMP_CODE,EM.EMP_NAME AS EMP_NAME, A.DIVISION_ID,
				A.BUY_DATE, A.USE_DATE, A.SPECIAL_ASS, A.AMORT_MONTH, A.AMORT_RATE, A.AMORT_START_DATE, A.AMORT_END_DATE,
				A.FIRST_AMORT_AMT, 
				A.AMORTIZED_MONTH, 
				(A.AMORT_MONTH - A.AMORTIZED_MONTH) AS REMAIN_MONTH,
				A.AMORTIZED_AMT, 
				ISNULL((A.AMORT_AMT - A.AMORTIZED_AMT), A.AMORT_AMT) AS REMAIN_AMORTIZED_AMT,  --So tien khau hao con lai
				A.PO_ID,A.PD_ID, A.WAREHOUSE_ID, A.LOCATION, A.REF_ASSET_ID,
				A.REF_AMORTIZED_AMT,
				A.WARRANTY_MONTHS, 
				A.NOTES, 
				A.AMORT_STATUS, 
				D.STATUS_NAME AMORT_STATUS_NAME, 
				A.ASS_STATUS, 
				E.STATUS_NAME ASS_STATUS_NAME, --Tinh trang tai san
				A.ASS_STATUS_DESC,
				A.RECORD_STATUS, 
				A.AUTH_STATUS, 
				ZZ.AUTH_STATUS_NAME,
				A.MAKER_ID, 
				A.CREATE_DT, 
				A.CHECKER_ID, 
				A.USE_STATUS,--THIEUVQ 23062015
				A.APPROVE_DT,
				A.ACCOUNT_GL,
				A.VAT,
				A.PRICE_VAT,
				dbo.FN_GET_CHINHANH(A.BRANCH_ID,'KV') KHU_VUC,
						 dbo.FN_GET_CHINHANH(A.BRANCH_ID,'CN') CHI_NHANH, 
						 (BBB.BRANCH_CODE +' - '+  BBB.BRANCH_NAME) AS PGD,
						 B.AMORT_MONTH AS GROUP_AMORT_MONTH,
						 BRCR.BRANCH_NAME AS BRANCH_RECIVE,
						 BRCR.BRANCH_NAME AS BRANCH_CREATE_NAME,
						 BRCR.BRANCH_ID AS BRANCH_CREATE_ID,
						 BRCR.BRANCH_CODE AS BRANCH_CREATE_CODE,
						 --LUCTV : 26-12-2018 BO SUNG AMORT MIN - MAX CUA TAI SAN THEO NHOM DE HIEN THI BEN MAN HINH CHINH SUA THONG TIN TAI SAN
						 B.AMORT_MONTH_MAX,
						 B.AMORT_MONTH_MIN,
						 --LUCTV : 22 -03 -19 BO SUNG LEFT JOIN ASS_TRANSACTIONS
						 AN.ADDNEW_ID, AN.NOTES AS ADDNEW_NOTES,AU.TRN_ID AS USE_MASTER_ID
		-- SELECT END
		FROM ASS_MASTER A
		LEFT JOIN ASS_GROUP B ON A.GROUP_ID = B.GROUP_ID
		LEFT JOIN ASS_TYPE C ON A.[TYPE_ID] = C.[TYPE_ID]
		LEFT JOIN ASS_AMORT_STATUS D ON A.AMORT_STATUS = D.STATUS_CODE
		LEFT JOIN ASS_STATUS E ON A.ASS_STATUS = E.STATUS_ID
		LEFT JOIN CM_AUTH_STATUS ZZ ON ZZ.AUTH_STATUS = A.AUTH_STATUS
		LEFT JOIN CM_BRANCH BR ON BR.BRANCH_ID=A.BRANCH_ID
		LEFT JOIN CM_EMPLOYEE EM ON EM.EMP_ID = A.EMP_ID
		LEFT JOIN TL_USER MK ON MK.TLNANME = A.MAKER_ID
		LEFT JOIN CM_BRANCH BBB ON BBB.BRANCH_ID = A.BRANCH_ID
		LEFT JOIN CM_DEPARTMENT DP ON DP.DEP_ID = A.DEPT_ID
		LEFT JOIN CM_BRANCH BRCR ON BRCR.BRANCH_ID = A.BRANCH_CREATE
		--LUCTV : 22 -03 -19 BO SUNG LEFT JOIN ASS_TRANSACTIONS
		LEFT JOIN ASS_TRANSACTIONS AT ON AT.ASSET_ID = A.ASSET_ID AND AT.TRN_TYPE = 'ADD_NEW'
		LEFT JOIN ASS_ADDNEW AN ON AT.TRN_ID = AN.ADDNEW_ID AND AT.TRN_TYPE = 'ADD_NEW'
			--LUCTV: 26-08-2019 BO SUNG THEM DIEU KIEN KHI NAO NHAP MA PHIEU XUAT THI MOI LEFT JOIN
		LEFT JOIN ASS_TRANSACTIONS AU ON AU.ASSET_ID = A.ASSET_ID AND AU.TRN_TYPE ='ADD_USE'
		--SELECT * FROM TL_USER
		WHERE 1 = 1
			AND (A.ASSET_ID = @p_ASSET_ID OR @p_ASSET_ID IS NULL OR @p_ASSET_ID = '')
			AND (A.[TYPE_ID] = @p_TYPE_ID OR @p_TYPE_ID IS NULL OR @p_TYPE_ID = '')
			--AND (B.[ASS_CAT] = @p_ASS_CAT OR @p_ASS_CAT IS NULL OR @p_ASS_CAT = '')
			AND (A.GROUP_ID = @p_GROUP_ID OR @p_GROUP_ID IS NULL OR @p_GROUP_ID = '')
			AND (A.ASSET_CODE like '%' + @p_ASSET_CODE + '%' OR @p_ASSET_CODE IS NULL OR @p_ASSET_CODE = '')
			AND (A.ASSET_NAME like N'%' + @p_ASSET_NAME + '%' OR @p_ASSET_NAME IS NULL OR @p_ASSET_NAME = '')
			AND (A.ASSET_SERIAL_NO like N'%' + @p_ASSET_SERIAL_NO + '%' OR @p_ASSET_SERIAL_NO IS NULL OR @p_ASSET_SERIAL_NO = '')
			AND (A.ASSET_DESC like N'%' + @p_ASSET_DESC + '%' OR @p_ASSET_DESC IS NULL OR @p_ASSET_DESC = '')
			AND (A.SUP_ID = @p_SUP_ID OR @p_SUP_ID IS NULL OR @p_SUP_ID = '')
			AND (A.BUY_PRICE = @p_BUY_PRICE OR @p_BUY_PRICE IS NULL)
			AND (A.AMORT_AMT = @p_AMORT_AMT OR @p_AMORT_AMT IS NULL)
			AND (A.ASS_TYPE = @p_ASS_TYPE OR @p_ASS_TYPE IS NULL OR @p_ASS_TYPE = '')
			AND (((A.AMORT_STATUS <> 'VNM'
					AND ((@P_LEVEL = 'ALL' AND A.BRANCH_ID IN (SELECT BRANCH_ID from @tmp1))
					OR (@P_LEVEL = 'UNIT' AND A.BRANCH_ID = @p_BRANCH_ID)))
				OR ((A.AMORT_STATUS = 'VNM' OR (A.AMORT_STATUS = 'DTL' AND (A.BRANCH_ID IS NULL OR A.BRANCH_ID = '')))
					AND ((@P_LEVEL = 'ALL' AND A.BRANCH_CREATE IN (SELECT BRANCH_ID from @tmp1))
					OR (@P_LEVEL = 'UNIT' AND ((A.BRANCH_ID IS NOT NULL AND A.BRANCH_ID <>'' AND A.BRANCH_ID =@p_BRANCH_ID) OR A.BRANCH_CREATE = @p_BRANCH_ID)))))
			OR @P_BRANCH_ID IS NULL OR @P_BRANCH_ID = ''
			)			
			AND (((A.AMORT_STATUS <> 'VNM'
					AND ((@P_LEVEL = 'ALL' AND A.BRANCH_ID IN (SELECT BRANCH_ID from @tmp2))
					OR (@P_LEVEL = 'UNIT' AND ((A.BRANCH_ID IS NOT NULL AND A.BRANCH_ID <>'' AND A.BRANCH_ID = @P_BRANCH_LOGIN))))) 
				OR ((A.AMORT_STATUS = 'VNM' OR (A.AMORT_STATUS = 'DTL' AND (A.BRANCH_ID IS NULL OR A.BRANCH_ID = '')))
					AND ((@P_LEVEL = 'ALL' AND A.BRANCH_CREATE IN (SELECT BRANCH_ID from @tmp2))
					OR (@P_LEVEL = 'UNIT' AND ((A.BRANCH_ID IS NOT NULL AND A.BRANCH_ID <>'' AND A.BRANCH_ID =@P_BRANCH_LOGIN) OR (@p_USER_LOGIN = 'baotq') OR A.BRANCH_CREATE = @P_BRANCH_LOGIN))))) 
			OR @P_BRANCH_LOGIN IS NULL OR @P_BRANCH_LOGIN = ''
			)
			AND (A.DEPT_ID = @p_DEPT_ID OR @p_DEPT_ID IS NULL OR @p_DEPT_ID = '')
			AND (A.EMP_ID = @p_EMP_ID OR @p_EMP_ID IS NULL OR @p_EMP_ID = '')
			AND (A.DIVISION_ID = @p_DIVISION_ID OR @p_DIVISION_ID IS NULL OR @p_DIVISION_ID = '')
			--AND (DATEDIFF(DAYOFYEAR,A.BUY_DATE,CONVERT(datetime, @p_BUY_DATE,103)) = 0 OR @p_BUY_DATE IS NULL OR  @p_BUY_DATE = '')
			-- DuyTN bổ sung điều kiện search theo năm
			AND (YEAR(A.BUY_DATE) = @P_YEAR OR @P_YEAR = '' OR @P_YEAR IS NULL)
			AND (DATEDIFF(DAYOFYEAR,A.USE_DATE,CONVERT(datetime, @p_USE_DATE,103)) = 0 OR @p_USE_DATE IS NULL OR  @p_USE_DATE = '')
			AND (A.SPECIAL_ASS = @p_SPECIAL_ASS OR @p_SPECIAL_ASS IS NULL OR @p_SPECIAL_ASS = '')
			AND (A.AMORT_MONTH = @p_AMORT_MONTH OR @p_AMORT_MONTH IS NULL)
			AND (A.AMORT_RATE = @p_AMORT_RATE OR @p_AMORT_RATE IS NULL)
			AND (DATEDIFF(DAYOFYEAR,A.AMORT_START_DATE,CONVERT(datetime, @p_AMORT_START_DATE,103)) = 0 OR @p_AMORT_START_DATE IS NULL OR  @p_AMORT_START_DATE = '')
			AND (DATEDIFF(DAYOFYEAR,A.AMORT_END_DATE,CONVERT(datetime, @p_AMORT_END_DATE,103)) = 0 OR @p_AMORT_END_DATE IS NULL OR  @p_AMORT_END_DATE = '')
			AND (A.AMORTIZED_MONTH = @p_AMORTIZED_MONTH OR @p_AMORTIZED_MONTH IS NULL)
			AND ((A.AMORT_MONTH - A.AMORTIZED_MONTH) = @p_REMAIN_MONTH OR @p_REMAIN_MONTH IS NULL)
			AND (A.PO_ID = @p_PO_ID OR @p_PO_ID IS NULL OR @p_PO_ID = '')
			AND (A.WAREHOUSE_ID = @p_WAREHOUSE_ID OR @p_WAREHOUSE_ID IS NULL OR @p_WAREHOUSE_ID = '')
			AND (A.LOCATION like N'%' + @p_LOCATION + '' OR @p_LOCATION IS NULL OR @p_LOCATION = '')
			AND (A.REF_ASSET_ID = @p_REF_ASSET_ID OR @p_REF_ASSET_ID IS NULL OR @p_REF_ASSET_ID = '')
			AND (A.REF_AMORTIZED_AMT = @p_REF_AMORTIZED_AMT OR @p_REF_AMORTIZED_AMT IS NULL)
			--AND (A.AMORT_STATUS = @p_AMORT_STATUS OR @p_AMORT_STATUS IS NULL OR @p_AMORT_STATUS = '')
			AND (A.ASS_STATUS = @p_ASS_STATUS OR @p_ASS_STATUS IS NULL OR @p_ASS_STATUS = '')
			AND  (CHARINDEX(A.AMORT_STATUS, @p_AMORT_STATUS) <> 0 OR @p_AMORT_STATUS = '' OR @p_AMORT_STATUS IS NULL )
			AND (A.ASS_STATUS_DESC like N'%' + @p_ASS_STATUS_DESC + '' OR @p_ASS_STATUS_DESC IS NULL OR @p_ASS_STATUS_DESC = '')
			AND (A.WARRANTY_MONTHS = @p_WARRANTY_MONTHS OR @p_WARRANTY_MONTHS IS NULL)
			AND (A.NOTES like N'%' + @p_NOTES + '' OR @p_NOTES IS NULL OR @p_NOTES = '')
			AND A.RECORD_STATUS = '1'
			AND (A.USE_STATUS = @p_USE_STATUS OR @p_USE_STATUS IS NULL OR @p_USE_STATUS = '')
			AND ((@p_LOCATION =N'IS_LIQUID' AND A.ASSET_ID NOT IN (SELECT ASSET_ID FROM ASS_COLLECT_MULTI_DT WHERE AUTH_STATUS='A' AND IS_LIQ ='1')) 
				OR (@p_LOCATION =N'IS_COL' AND A.ASSET_ID NOT IN (SELECT ASSET_ID FROM ASS_COLLECT_MULTI_DT WHERE AUTH_STATUS='A')) 
				OR (@p_LOCATION =N'LIQ' AND A.ASSET_ID  IN (SELECT ASSET_ID FROM ASS_COLLECT_MULTI_DT WHERE AUTH_STATUS='A' AND IS_LIQ ='1'))  
				-- 26-02-2020 BO SUNG THEM NEU LOCATION TRUYEN XUONG LA PRINT TEMP THI LUC NAY CHI LAY NHUNG TAI SAN <> 'VNM' VA CHI LAY DON VI DOC LAP, KHONG LAY TOAN HANG
				-- VI HIEN TAI DANG MAC DINH LAY TOAN HANG, TRONG KHI IN NHAN DANG MAC DINH IN THEO DON VI DOC LAP
				OR (@p_LOCATION =N'PRINT_TEMP' AND A.AMORT_STATUS <>'VNM' AND A.BRANCH_ID =@p_BRANCH_ID)
				OR @p_LOCATION IS NULL OR @p_LOCATION='')
			--LUCTV : 22 -03 -19 BO SUNG LEFT JOIN ASS_TRANSACTIONS
			AND (AN.ADDNEW_ID  LIKE N'%'+ @p_ADDNEWID +'%' OR @p_ADDNEWID ='' OR @p_ADDNEWID IS NULL) 
			AND (AN.NOTES LIKE N'%' + @p_ADDNEW_NOTES + '%' OR @p_ADDNEW_NOTES ='' OR @p_ADDNEW_NOTES IS NULL) 
			AND (EM.EMP_NAME LIKE N'%'+ @p_EMP_NAME +'%' OR @p_EMP_NAME ='' OR @p_EMP_NAME IS NULL)
			AND (EM.EMP_CODE LIKE N'%'+ @p_EMP_CODE +'%' OR @p_EMP_CODE ='' OR @p_EMP_CODE IS NULL)
			AND (AU.TRN_ID LIKE N'%'+ @p_USE_MASTER_ID +'%' OR @p_USE_MASTER_ID IS NULL OR @p_USE_MASTER_ID ='')
		ORDER BY A.CREATE_DT DESC
	-- PAGING END
	END
	ELSE
	BEGIN	
	-- PAGING BEGIN
		SELECT TOP (@P_TOP)
		MK.TLSUBBRID,A.MONTHLY_AMORT_AMT,
				A.ASSET_ID, A.[TYPE_ID],C.[TYPE_CODE],  C.[TYPE_NAME], A.GROUP_ID,B.GROUP_CODE, B.GROUP_NAME, B.ASS_CAT, A.ASSET_CODE, A.ASSET_NAME, A.ASSET_SERIAL_NO, A.ASSET_DESC,
				A.SUP_ID, A.BUY_PRICE, A.AMORT_AMT, A.ASS_TYPE, A.BRANCH_ID,BR.BRANCH_CODE,BR.BRANCH_NAME,A.DEPT_ID,DP.DEP_CODE,(DP.DEP_CODE +' - '+ DP.DEP_NAME) AS DEP_NAME, A.EMP_ID,EM.EMP_CODE AS EMP_CODE,EM.EMP_NAME AS EMP_NAME, A.DIVISION_ID,
				A.BUY_DATE, A.USE_DATE, A.SPECIAL_ASS, A.AMORT_MONTH, A.AMORT_RATE, A.AMORT_START_DATE, A.AMORT_END_DATE,
				A.FIRST_AMORT_AMT, 
				A.AMORTIZED_MONTH, 
				(A.AMORT_MONTH - A.AMORTIZED_MONTH) AS REMAIN_MONTH,
				A.AMORTIZED_AMT, 
				ISNULL((A.AMORT_AMT - A.AMORTIZED_AMT), ISNULL(A.AMORT_AMT,0)) AS REMAIN_AMORTIZED_AMT,  --So tien khau hao con lai
				A.PO_ID,A.PD_ID, A.WAREHOUSE_ID, A.LOCATION, A.REF_ASSET_ID,
				A.REF_AMORTIZED_AMT,
				A.WARRANTY_MONTHS, 
				A.NOTES, 
				A.AMORT_STATUS, 
				D.STATUS_NAME AMORT_STATUS_NAME, 
				A.ASS_STATUS, 
				E.STATUS_NAME ASS_STATUS_NAME, --Tinh trang tai san
				A.ASS_STATUS_DESC,
				A.RECORD_STATUS, 
				A.AUTH_STATUS, 
				ZZ.AUTH_STATUS_NAME,
				A.MAKER_ID, 
				A.CREATE_DT, 
				A.CHECKER_ID, 
				A.USE_STATUS,--THIEUVQ 23062015
				A.APPROVE_DT,
				A.ACCOUNT_GL,
				A.VAT,
				A.PRICE_VAT,
				dbo.FN_GET_CHINHANH(A.BRANCH_ID,'KV') KHU_VUC,
						 dbo.FN_GET_CHINHANH(A.BRANCH_ID,'CN') CHI_NHANH, 
						 (BBB.BRANCH_CODE +' - '+  BBB.BRANCH_NAME) AS PGD,
						 B.AMORT_MONTH AS GROUP_AMORT_MONTH,
						 BRCR.BRANCH_NAME AS BRANCH_RECIVE,
						 BRCR.BRANCH_NAME AS BRANCH_CREATE_NAME,
						 BRCR.BRANCH_ID AS BRANCH_CREATE_ID,
						 BRCR.BRANCH_CODE AS BRANCH_CREATE_CODE,
						 --LUCTV : 26-12-2018 BO SUNG AMORT MIN - MAX CUA TAI SAN THEO NHOM DE HIEN THI BEN MAN HINH CHINH SUA THONG TIN TAI SAN
						 B.AMORT_MONTH_MAX,
						 B.AMORT_MONTH_MIN,
						--LUCTV : 22 -03 -19 BO SUNG LEFT JOIN ASS_TRANSACTIONS
						AN.ADDNEW_ID, AN.NOTES AS ADDNEW_NOTES,AU.TRN_ID AS USE_MASTER_ID
		-- SELECT END				
		FROM ASS_MASTER A
		LEFT JOIN ASS_GROUP B ON A.GROUP_ID = B.GROUP_ID
		LEFT JOIN ASS_TYPE C ON A.[TYPE_ID] = C.[TYPE_ID]
		LEFT JOIN ASS_AMORT_STATUS D ON A.AMORT_STATUS = D.STATUS_CODE
		LEFT JOIN ASS_STATUS E ON A.ASS_STATUS = E.STATUS_ID
		LEFT JOIN CM_AUTH_STATUS ZZ ON ZZ.AUTH_STATUS = A.AUTH_STATUS
		LEFT JOIN CM_BRANCH BR ON BR.BRANCH_ID=A.BRANCH_ID
		LEFT JOIN CM_EMPLOYEE EM ON EM.EMP_ID=A.EMP_ID
		LEFT JOIN TL_USER MK ON MK.TLNANME = A.MAKER_ID
		LEFT JOIN CM_BRANCH BBB ON BBB.BRANCH_ID = A.BRANCH_ID
		LEFT JOIN CM_DEPARTMENT DP ON DP.DEP_ID = A.DEPT_ID
		LEFT JOIN CM_BRANCH BRCR ON BRCR.BRANCH_ID = A.BRANCH_CREATE
		--LUCTV : 22 -03 -19 BO SUNG LEFT JOIN ASS_TRANSACTIONS
		LEFT JOIN ASS_TRANSACTIONS AT ON AT.ASSET_ID = A.ASSET_ID AND AT.TRN_TYPE = 'ADD_NEW'
		LEFT JOIN ASS_ADDNEW AN ON AT.TRN_ID = AN.ADDNEW_ID AND AT.TRN_TYPE = 'ADD_NEW'
		--LUCTV: 26-08-2019 BO SUNG THEM DIEU KIEN KHI NAO NHAP MA PHIEU XUAT THI MOI LEFT JOIN
		LEFT JOIN ASS_TRANSACTIONS AU ON AU.ASSET_ID = A.ASSET_ID AND AU.TRN_TYPE ='ADD_USE'
		WHERE 1 = 1
			AND (A.ASSET_ID = @p_ASSET_ID OR @p_ASSET_ID IS NULL OR @p_ASSET_ID = '')
			AND (A.[TYPE_ID] = @p_TYPE_ID OR @p_TYPE_ID IS NULL OR @p_TYPE_ID = '')
			--AND (B.[ASS_CAT] = @p_ASS_CAT OR @p_ASS_CAT IS NULL OR @p_ASS_CAT = '')
			AND (A.GROUP_ID = @p_GROUP_ID OR @p_GROUP_ID IS NULL OR @p_GROUP_ID = '')
			--AND (A.ASSET_CODE like '%' + @p_ASSET_CODE + '%' OR @p_ASSET_CODE IS NULL OR @p_ASSET_CODE = '')
			AND (A.ASSET_CODE IN (SELECT [VALUE] FROM @l_LSTASSETCODE) OR @p_ASSET_CODE IS NULL OR @p_ASSET_CODE = '' OR ((SELECT COUNT(*) FROM @l_LSTASSETCODE) =1 AND A.ASSET_CODE like '%' + @p_ASSET_CODE + '%' ))
			AND (A.ASSET_NAME like N'%' + @p_ASSET_NAME + '%' OR @p_ASSET_NAME IS NULL OR @p_ASSET_NAME = '')
			AND (A.ASSET_SERIAL_NO like N'%' + @p_ASSET_SERIAL_NO + '%' OR @p_ASSET_SERIAL_NO IS NULL OR @p_ASSET_SERIAL_NO = '')
			AND (A.ASSET_DESC like N'%' + @p_ASSET_DESC + '%' OR @p_ASSET_DESC IS NULL OR @p_ASSET_DESC = '')
			AND (A.SUP_ID = @p_SUP_ID OR @p_SUP_ID IS NULL OR @p_SUP_ID = '')
			AND (A.BUY_PRICE = @p_BUY_PRICE OR @p_BUY_PRICE IS NULL)
			AND (A.AMORT_AMT = @p_AMORT_AMT OR @p_AMORT_AMT IS NULL)
			AND (A.ASS_TYPE = @p_ASS_TYPE OR @p_ASS_TYPE IS NULL OR @p_ASS_TYPE = '')			
			AND (((A.AMORT_STATUS <> 'VNM'
					AND ((@P_LEVEL = 'ALL' AND A.BRANCH_ID IN (SELECT BRANCH_ID from @tmp1))
					OR (@P_LEVEL = 'UNIT' AND A.BRANCH_ID = @p_BRANCH_ID)))
				OR ((A.AMORT_STATUS = 'VNM' OR (A.AMORT_STATUS = 'DTL' AND (A.BRANCH_ID IS NULL OR A.BRANCH_ID = '')))
					AND ((@P_LEVEL = 'ALL' AND A.BRANCH_CREATE IN (SELECT BRANCH_ID from @tmp1))
					OR (@P_LEVEL = 'UNIT' AND ((A.BRANCH_ID IS NOT NULL AND A.BRANCH_ID <>'' AND A.BRANCH_ID =@p_BRANCH_ID) OR A.BRANCH_CREATE = @p_BRANCH_ID)))))
			OR @P_BRANCH_ID IS NULL OR @P_BRANCH_ID = ''
			)			
			AND (((A.AMORT_STATUS <> 'VNM'
					AND ((@P_LEVEL = 'ALL' AND A.BRANCH_ID IN (SELECT BRANCH_ID from @tmp2))
					OR (@P_LEVEL = 'UNIT' AND ((A.BRANCH_ID IS NOT NULL AND A.BRANCH_ID <>'' AND A.BRANCH_ID = @P_BRANCH_LOGIN))))) 
				OR ((A.AMORT_STATUS = 'VNM' OR (A.AMORT_STATUS = 'DTL' AND (A.BRANCH_ID IS NULL OR A.BRANCH_ID = '')))
					AND ((@P_LEVEL = 'ALL' AND A.BRANCH_CREATE IN (SELECT BRANCH_ID from @tmp2))
					OR (@P_LEVEL = 'UNIT' AND ((A.BRANCH_ID IS NOT NULL AND A.BRANCH_ID <>'' AND A.BRANCH_ID =@P_BRANCH_LOGIN) OR (@p_USER_LOGIN = 'baotq') OR A.BRANCH_CREATE = @P_BRANCH_LOGIN))))) 
			OR @P_BRANCH_LOGIN IS NULL OR @P_BRANCH_LOGIN = ''
			)
			AND (A.DEPT_ID = @p_DEPT_ID OR @p_DEPT_ID IS NULL OR @p_DEPT_ID = '')
			AND (A.EMP_ID = @p_EMP_ID OR @p_EMP_ID IS NULL OR @p_EMP_ID = '')
			AND (A.DIVISION_ID = @p_DIVISION_ID OR @p_DIVISION_ID IS NULL OR @p_DIVISION_ID = '')
			--AND (DATEDIFF(DAYOFYEAR,A.BUY_DATE,CONVERT(datetime, @p_BUY_DATE,103)) = 0 OR @p_BUY_DATE IS NULL OR  @p_BUY_DATE = '')
			-- DuyTN bổ sung điều kiện search theo năm
			AND (YEAR(A.BUY_DATE) = @P_YEAR OR @P_YEAR = '' OR @P_YEAR IS NULL)
			AND (DATEDIFF(DAYOFYEAR,A.USE_DATE,CONVERT(datetime, @p_USE_DATE,103)) = 0 OR @p_USE_DATE IS NULL OR  @p_USE_DATE = '')
			AND (A.SPECIAL_ASS = @p_SPECIAL_ASS OR @p_SPECIAL_ASS IS NULL OR @p_SPECIAL_ASS = '')
			AND (A.AMORT_MONTH = @p_AMORT_MONTH OR @p_AMORT_MONTH IS NULL)
			AND (A.AMORT_RATE = @p_AMORT_RATE OR @p_AMORT_RATE IS NULL)
			AND (DATEDIFF(DAYOFYEAR,A.AMORT_START_DATE,CONVERT(datetime, @p_AMORT_START_DATE,103)) = 0 OR @p_AMORT_START_DATE IS NULL OR  @p_AMORT_START_DATE = '')
			AND (DATEDIFF(DAYOFYEAR,A.AMORT_END_DATE,CONVERT(datetime, @p_AMORT_END_DATE,103)) = 0 OR @p_AMORT_END_DATE IS NULL OR  @p_AMORT_END_DATE = '')
			AND (A.AMORTIZED_MONTH = @p_AMORTIZED_MONTH OR @p_AMORTIZED_MONTH IS NULL)
			AND ((A.AMORT_MONTH - A.AMORTIZED_MONTH) = @p_REMAIN_MONTH OR @p_REMAIN_MONTH IS NULL)
			AND (A.PO_ID = @p_PO_ID OR @p_PO_ID IS NULL OR @p_PO_ID = '')
			AND (A.WAREHOUSE_ID = @p_WAREHOUSE_ID OR @p_WAREHOUSE_ID IS NULL OR @p_WAREHOUSE_ID = '')
			--AND (A.LOCATION like N'%' + @p_LOCATION + '' OR @p_LOCATION IS NULL OR @p_LOCATION = '')
			AND (A.REF_ASSET_ID = @p_REF_ASSET_ID OR @p_REF_ASSET_ID IS NULL OR @p_REF_ASSET_ID = '')
			AND (A.REF_AMORTIZED_AMT = @p_REF_AMORTIZED_AMT OR @p_REF_AMORTIZED_AMT IS NULL)
			--AND (A.AMORT_STATUS = @p_AMORT_STATUS OR @p_AMORT_STATUS IS NULL OR @p_AMORT_STATUS = '')
			AND (A.ASS_STATUS = @p_ASS_STATUS OR @p_ASS_STATUS IS NULL OR @p_ASS_STATUS = '')
			AND  (CHARINDEX(A.AMORT_STATUS, @p_AMORT_STATUS) <> 0 OR @p_AMORT_STATUS = '' OR @p_AMORT_STATUS IS NULL )
			AND (A.ASS_STATUS_DESC like N'%' + @p_ASS_STATUS_DESC + '' OR @p_ASS_STATUS_DESC IS NULL OR @p_ASS_STATUS_DESC = '')
			AND (A.WARRANTY_MONTHS = @p_WARRANTY_MONTHS OR @p_WARRANTY_MONTHS IS NULL)
			AND (A.NOTES like N'%' + @p_NOTES + '%' OR @p_NOTES IS NULL OR @p_NOTES = '')
			AND A.RECORD_STATUS = '1'
			AND (A.USE_STATUS = @p_USE_STATUS OR @p_USE_STATUS IS NULL OR @p_USE_STATUS = '')
			AND ((@p_LOCATION =N'IS_LIQUID' AND A.ASSET_ID NOT IN (SELECT ASSET_ID FROM ASS_COLLECT_MULTI_DT WHERE AUTH_STATUS='A' AND IS_LIQ ='1')) 
				OR (@p_LOCATION =N'IS_COL' AND A.ASSET_ID NOT IN (SELECT ASSET_ID FROM ASS_COLLECT_MULTI_DT WHERE AUTH_STATUS='A')) 
				OR (@p_LOCATION =N'LIQ' AND A.ASSET_ID  IN (SELECT ASSET_ID FROM ASS_COLLECT_MULTI_DT WHERE AUTH_STATUS='A' AND IS_LIQ ='1'))
				-- 26-02-2020 BO SUNG THEM NEU LOCATION TRUYEN XUONG LA PRINT TEMP THI LUC NAY CHI LAY NHUNG TAI SAN <> 'VNM' VA CHI LAY DON VI DOC LAP, KHONG LAY TOAN HANG
				-- VI HIEN TAI DANG MAC DINH LAY TOAN HANG, TRONG KHI IN NHAN DANG MAC DINH IN THEO DON VI DOC LAP
				OR (@p_LOCATION =N'PRINT_TEMP' AND A.AMORT_STATUS  <>'VNM' AND A.BRANCH_ID =@p_BRANCH_ID)
				OR @p_LOCATION IS NULL OR @p_LOCATION='')
			--LUCTV : 22 -03 -19 BO SUNG LEFT JOIN ASS_TRANSACTIONS
			--LUCTV : 22 -03 -19 BO SUNG LEFT JOIN ASS_TRANSACTIONS
			AND (AN.ADDNEW_ID LIKE N'%'+ @p_ADDNEWID +'%' OR @p_ADDNEWID ='' OR @p_ADDNEWID IS NULL) 
			AND (AN.NOTES LIKE N'%' + @p_ADDNEW_NOTES + '%' OR @p_ADDNEW_NOTES ='' OR @p_ADDNEW_NOTES IS NULL) 
			AND (EM.EMP_NAME LIKE N'%'+ @p_EMP_NAME +'%' OR @p_EMP_NAME ='' OR @p_EMP_NAME IS NULL)
			AND (EM.EMP_CODE LIKE N'%'+ @p_EMP_CODE +'%' OR @p_EMP_CODE ='' OR @p_EMP_CODE IS NULL)
			AND (AU.TRN_ID LIKE N'%'+ @p_USE_MASTER_ID +'%' OR @p_USE_MASTER_ID IS NULL OR @p_USE_MASTER_ID ='')
		ORDER BY A.CREATE_DT DESC
		-- PAGING END
	END
END -- PAGING