ALTER PROCEDURE dbo.ASS_ADDNEW_BVB_Search
	@p_ADDNEW_ID		varchar(15)  = NULL,
	@p_FR_BUY_DATE		VARCHAR(10) = NULL, --Tu ngay nhap
	@p_TO_BUY_DATE		VARCHAR(10) = NULL, --Den ngay nhap
	@p_TYPE_ID			varchar(15)  = NULL,
	@p_GROUP_ID			varchar(15)  = NULL,
	@p_ASSET_NAME		nvarchar(1000)  = NULL,
	@p_ASSET_SERIAL_NO	nvarchar(MAX)  = NULL,
	@p_ASSET_DESC		nvarchar(max) = NULL,
	@p_BRANCH_ID		varchar(15)  = NULL,
	@p_DEPT_ID			varchar(15)  = NULL,---------Them ma phong ban
	@p_EMP_ID			varchar(15)  = NULL,-----------Them Nguoi su dung
	@p_DIVISION_ID		varchar(15)  = NULL,----------Them co so
	@p_BUY_PRICE		decimal(18)  = NULL,
	@p_AMORT_AMT		decimal(18)  = NULL,
	@p_AMORT_MONTH		decimal(18,2) = NULL,
	@p_AMORT_RATE		decimal(18,2)  = NULL,
	@p_IS_MULTIPLE		varchar(1)  = NULL,
	@p_QTY				int = NULL,
	@p_PO_ID			varchar(15)  = NULL,
	@p_TRADE_ID			varchar(15)  = NULL, --Them de luu chi tiet PO
	@p_TYPE				varchar(10) = 'ADD_NEW',  --'ADD_NEW' dung cho nhap moi TS, 'ADD_REF': nhap moi dieu chinh
	@p_REF_ASSET_ID		varchar(15)  = NULL,
	@p_REF_AMORTIZED_AMT	decimal(18)  = NULL,
	@p_WARRANTY_MONTHS	int = NULL,
	@p_NOTES			nvarchar(1000)  = NULL,
	@p_RECORD_STATUS	varchar(1)  = NULL,
	@p_AUTH_STATUS		varchar(1)  = NULL,
	@p_MAKER_ID			varchar(15)  = NULL,
	@p_CREATE_DT		VARCHAR(20) = NULL,
	@p_CHECKER_ID		varchar(15)  = NULL,
	@p_APPROVE_DT		VARCHAR(20) = NULL,
	@P_TOP				INT		= NULL,
	@p_CONSTRUCT_ID		VARCHAR(15) = NULL,
	@p_POSTED_STATUS	VARCHAR(1) = NULL,
	@p_BRANCH_CREATE	VARCHAR(15) = NULL,
	@P_LEVEL			VARCHAR(10) = NULL,
	@p_AUTH_STATUS_KT	VARCHAR(1) = NULL,
	@p_KT_IS_DO			VARCHAR(1) = NULL,
	@p_PRICE_TO			decimal(18) = NULL,
	@p_PRICE_FROM			decimal(18) = NULL,
	@p_USER_LOGIN   VARCHAR(15),-- 26022020 LUCTV TRUYEN XUONG USER LOGIN DE DO TIM MA PHONG BAN
	@p_TYPE_SEARCH VARCHAR(10)= NULL -- 26022020 LUCTV TRUYEN XUONG DAU HIEU DE PHAN BIET TIM KIEM O MAN HINH KE TOAN HAY MAN HINH HCQT
AS
BEGIN -- PAGING
	SET @p_RECORD_STATUS = '1'
	declare @tmp table(BRANCH_ID varchar(15))

	insert into @tmp  SELECT BRANCH_ID  FROM [dbo].[CM_BRANCH_GETCHILDID](@p_BRANCH_CREATE)
	DECLARE @l_GROUP_CODE VARCHAR(100) 
	IF(@p_TYPE_ID='ALL')
	BEGIN
		SET @l_GROUP_CODE = (SELECT GROUP_CODE FROM ASS_GROUP WHERE GROUP_ID = @p_GROUP_ID)
		SET @p_TYPE_ID=''
	END

	IF @P_TOP IS NULL OR @P_TOP  = ''
-- PAGING BEGIN
		SELECT 
				A.ADDNEW_ID,
				A.BUY_DATE,
				A.[TYPE_ID],
				C.[TYPE_NAME],
				A.GROUP_ID,
				D.GROUP_CODE,
				D.GROUP_NAME,
				A.ASSET_NAME,
				A.ASSET_SERIAL_NO,
				A.ASSET_DESC,
				A.BRANCH_ID,
				A.AMORT_START_DATE,
				A.DEPT_ID,
				H.DEP_CODE,
				H.DEP_NAME,
				A.EMP_ID,
				G.EMP_CODE,
				G.EMP_NAME,
				A.DIVISION_ID,
				ISNULL(A.BUY_PRICE,0) AS BUY_PRICE,
				ISNULL(A.AMORT_AMT,0) AS AMORT_AMT,
				A.AMORT_MONTH,
				A.AMORT_RATE,
				A.IS_MULTIPLE,
				A.QTY,
				A.PO_ID,
				PO.PO_CODE,
				A.PD_ID,
				A.REF_ASSET_ID,
				I.ASSET_CODE AS REF_ASS_CODE,
				I.ASSET_NAME AS REF_ASS_NAME,
				A.REF_AMORTIZED_AMT,
				A.WARRANTY_MONTHS,
				A.NOTES,
				A.CORE_NOTE ,
				A.RECORD_STATUS,
				A.AUTH_STATUS,
				B.CONTENT AS AUTH_STATUS_NAME,AKT.CONTENT AS AUTH_STATUS_NAME_KT,
				A.MAKER_ID,
				UM.TLFullName MAKER_NAME,
				A.CREATE_DT,--CONVERT(VARCHAR(10), A.CREATE_DT, 103) AS S_CREATE_DT
				A.CHECKER_ID,
				A.APPROVE_DT, A.ENTRY_BOOKED, A.CONSTRUCT_ID,A.POSTED_STATUS, A.BRANCH_CREATE,A.MAKER_ID_KT, A.CREATE_DT_KT,A.CHECKER_ID_KT,A.APPROVE_DT_KT,A.AUTH_STATUS_KT,
				E.BRANCH_CODE, F.DIV_CODE, E.BRANCH_NAME, (ISNULL(E.BRANCH_NAME,'') + ' '+ ISNULL(H.DEP_NAME,'')) AS RECEIVE_BRANCH ,
				CREBRN.BRANCH_CODE AS R_BRANCH_CODE, CREBRN.BRANCH_NAME AS R_BRANCH_NAME, A.AMORT_END_DATE, A.ACCOUNT_GL, A.VAT, A.PRICE_VAT,(ISNULL(A.QTY,0) * ISNULL(A.BUY_PRICE,0)) AS TOTAL_AMT
				--, G.SUP_CODE, G.SUP_NAME
				,AP.ASSPO_ID AS ASS_PO_ID, AP.ADDNEW_ID AS ASS_PO_ADDNEWID, AP.PO_CODE AS ASS_PO_CODE, AP.INVOICE_NO AS AS_INVOICE_NO, AP.INVOICE_DATE AS ASS_INVOICE_DT,
				CREBRN.BRANCH_CODE+' - '+ CREBRN.BRANCH_NAME AS FULL_BRANCH_NAME, D.GROUP_CODE +' - '+ D.GROUP_NAME GROUP_NAME_FULL,
				UM2.TLFullName AS CREATE_USER_NAME, UM3.TLFullName AS APPROVE_NAME_KT, UM4.TLFullName AS CREATE_USER_NAME_KT,
				@p_USER_LOGIN AS USER_LOGIN,@p_TYPE_SEARCH AS TYPE_SEARCH --- TRA VE THAM SO GAN VO CURRENT SEARCH TRANH GAY LOI O CAC MAN HINH
-- SELECT END
		FROM ASS_ADDNEW A
  	--LEFT JOIN CM_AUTH_STATUS B ON A.AUTH_STATUS = B.AUTH_STATUS
  	LEFT JOIN dbo.CM_ALLCODE B ON B.CDVAL = A.AUTH_STATUS AND B.CDNAME = 'ASS_ADD_AUTH' AND B.CDTYPE = 'ASS_ADDNEW'
  	LEFT JOIN ASS_TYPE C ON A.[TYPE_ID] = C.[TYPE_ID]
  	LEFT JOIN ASS_GROUP D ON A.GROUP_ID = D.GROUP_ID
  	LEFT JOIN TL_USER UM ON UM.TLNANME = A.CHECKER_ID
  	LEFT JOIN TL_USER UM2 ON UM2.TLNANME = A.MAKER_ID
  	LEFT JOIN TL_USER UM3 ON UM2.TLNANME = A.CHECKER_ID_KT
  	LEFT JOIN TL_USER UM4 ON UM4.TLNANME = A.MAKER_ID_KT
  	LEFT JOIN TR_PO_MASTER PO ON PO.PO_ID = A.PO_ID
  	LEFT JOIN CM_BRANCH E ON E.BRANCH_ID = A.BRANCH_ID
  	LEFT JOIN CM_DIVISION F ON F.DIV_ID = A.DIVISION_ID
  	LEFT JOIN CM_EMPLOYEE G ON G.EMP_ID = A.EMP_ID
  	LEFT JOIN CM_DEPARTMENT H ON H.DEP_ID = A.DEPT_ID
  	LEFT JOIN ASS_MASTER I ON I.ASSET_ID = A.REF_ASSET_ID
  	--LEFT JOIN CM_AUTH_STATUS AKT ON AKT.AUTH_STATUS = A.AUTH_STATUS_KT
  	LEFT JOIN dbo.CM_ALLCODE AKT ON AKT.CDVAL = A.AUTH_STATUS_KT AND AKT.CDNAME = 'ASS_ADD_AUTH' AND AKT.CDTYPE = 'ASS_ADDNEW'
  	LEFT JOIN CM_BRANCH CREBRN ON CREBRN.BRANCH_ID = A.BRANCH_CREATE
  	LEFT JOIN ASS_PO AP ON A.ADDNEW_ID = AP.ADDNEW_ID
		WHERE	(A.ADDNEW_ID = @p_ADDNEW_ID OR @p_ADDNEW_ID IS NULL OR @p_ADDNEW_ID = '')

		-- TIM KIEM TU NGAY DEN NGAY O HC
		AND	((@p_TYPE_SEARCH = 'HC' AND (CONVERT(DATE,A.BUY_DATE,103) >= CONVERT(DATE, @p_FR_BUY_DATE, 103) OR @p_FR_BUY_DATE is NULL OR @p_FR_BUY_DATE = ''))
      OR @p_TYPE_SEARCH = 'KT' OR @p_TYPE_SEARCH IS NULL OR @p_TYPE_SEARCH = '')
    AND	((@p_TYPE_SEARCH = 'HC' AND (CONVERT(DATE,A.BUY_DATE,103) <= CONVERT(DATE, @p_TO_BUY_DATE, 103) OR @p_TO_BUY_DATE is NULL OR @p_TO_BUY_DATE = ''))
      OR @p_TYPE_SEARCH = 'KT' OR @p_TYPE_SEARCH IS NULL OR @p_TYPE_SEARCH = '')
			
    -- TIM KIEM TU NGAY O KT
    AND ((@p_TYPE_SEARCH = 'KT' AND (((A.MAKER_ID_KT IS NULL OR A.MAKER_ID_KT = '')
      AND (CONVERT(DATE,A.APPROVE_DT,103) >= CONVERT(DATE, @p_FR_BUY_DATE, 103) OR @p_FR_BUY_DATE is NULL OR @p_FR_BUY_DATE = ''))
      OR ((A.MAKER_ID_KT IS NOT NULL OR A.MAKER_ID_KT <> '')
          AND ((@p_AUTH_STATUS_KT = 'A' AND (CONVERT(DATE,A.APPROVE_DT_KT,103) >= CONVERT(DATE, @p_FR_BUY_DATE, 103) OR @p_FR_BUY_DATE is NULL OR @p_FR_BUY_DATE = ''))
            OR (@p_AUTH_STATUS_KT = 'U' AND (CONVERT(DATE,A.CREATE_DT_KT,103) >= CONVERT(DATE, @p_FR_BUY_DATE, 103) OR @p_FR_BUY_DATE is NULL OR @p_FR_BUY_DATE = ''))
            OR (@p_AUTH_STATUS_KT = 'R' AND (CONVERT(DATE,A.CREATE_DT_KT,103) >= CONVERT(DATE, @p_FR_BUY_DATE, 103) OR @p_FR_BUY_DATE is NULL OR @p_FR_BUY_DATE = ''))
            OR ((@p_AUTH_STATUS_KT = '' OR @p_AUTH_STATUS_KT IS NULL) AND (CONVERT(DATE,A.CREATE_DT_KT,103) >= CONVERT(DATE, @p_FR_BUY_DATE, 103) OR @p_FR_BUY_DATE is NULL OR @p_FR_BUY_DATE = ''))))))
    OR @p_TYPE_SEARCH = 'HC' OR @p_TYPE_SEARCH IS NULL OR @p_TYPE_SEARCH = '')
    -- TIM KIEM DEN NGAY O KT
    AND ((@p_TYPE_SEARCH = 'KT' AND (((A.MAKER_ID_KT IS NULL OR A.MAKER_ID_KT = '')
      AND (CONVERT(DATE,A.APPROVE_DT,103) <= CONVERT(DATE, @p_TO_BUY_DATE, 103) OR @p_TO_BUY_DATE is NULL OR @p_TO_BUY_DATE = ''))
      OR ((A.MAKER_ID_KT IS NOT NULL AND A.MAKER_ID_KT <> '')
          AND ((@p_AUTH_STATUS_KT = 'A' AND (CONVERT(DATE,A.APPROVE_DT_KT,103) <= CONVERT(DATE, @p_TO_BUY_DATE, 103) OR @p_TO_BUY_DATE is NULL OR @p_TO_BUY_DATE = ''))
            OR (@p_AUTH_STATUS_KT = 'U' AND (CONVERT(DATE,A.CREATE_DT_KT,103) <= CONVERT(DATE, @p_TO_BUY_DATE, 103) OR @p_TO_BUY_DATE is NULL OR @p_TO_BUY_DATE = ''))
            OR (@p_AUTH_STATUS_KT = 'R' AND (CONVERT(DATE,A.CREATE_DT_KT,103) <= CONVERT(DATE, @p_TO_BUY_DATE, 103) OR @p_TO_BUY_DATE is NULL OR @p_TO_BUY_DATE = ''))
            OR ((@p_AUTH_STATUS_KT = '' OR @p_AUTH_STATUS_KT IS NULL) AND (CONVERT(DATE,A.CREATE_DT_KT,103) <= CONVERT(DATE, @p_TO_BUY_DATE, 103) OR @p_TO_BUY_DATE is NULL OR @p_TO_BUY_DATE = ''))))))
    OR @p_TYPE_SEARCH = 'HC' OR @p_TYPE_SEARCH IS NULL OR @p_TYPE_SEARCH = '')

  	AND		(A.[TYPE_ID] = @p_TYPE_ID OR @p_TYPE_ID IS NULL OR @p_TYPE_ID = '')
  	AND		(A.GROUP_ID = @p_GROUP_ID OR @p_GROUP_ID IS NULL OR @p_GROUP_ID = '')
  	AND		(D.GROUP_CODE = @l_GROUP_CODE OR @l_GROUP_CODE IS NULL OR @l_GROUP_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.BRANCH_ID = @p_BRANCH_ID OR @p_BRANCH_ID IS NULL OR @p_BRANCH_ID = '')
  	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		(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.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		(A.IS_MULTIPLE = @p_IS_MULTIPLE OR @p_IS_MULTIPLE IS NULL OR @p_IS_MULTIPLE = '')
  	AND		(A.QTY = @p_QTY OR @p_QTY IS NULL OR @p_QTY = 0)
  	AND		(A.PO_ID = @p_PO_ID OR @p_PO_ID IS NULL OR @p_PO_ID = '')
  	AND		((@p_TYPE = 'ADD_NEW' AND (A.REF_ASSET_ID IS NULL OR A.REF_ASSET_ID = '')) OR (@p_TYPE = 'ADD_REF' AND A.REF_ASSET_ID IS NOT NULL AND A.REF_ASSET_ID <> ''))
  	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.WARRANTY_MONTHS = @p_WARRANTY_MONTHS OR @p_WARRANTY_MONTHS IS NULL OR @p_WARRANTY_MONTHS = 0)		
  	AND		(A.NOTES like N'%' + @p_NOTES + '%' OR @p_NOTES IS NULL OR @p_NOTES = '')
  	AND		(A.RECORD_STATUS = @p_RECORD_STATUS OR @p_RECORD_STATUS IS NULL OR @p_RECORD_STATUS = '')
  	AND		(A.AUTH_STATUS = @p_AUTH_STATUS OR @p_AUTH_STATUS IS NULL OR @p_AUTH_STATUS = '')
  	AND		(A.POSTED_STATUS = @p_POSTED_STATUS OR @p_POSTED_STATUS IS NULL OR @p_POSTED_STATUS = '')
  	--AND		(A.BRANCH_CREATE = @p_BRANCH_CREATE OR @p_BRANCH_CREATE IS NULL OR @p_BRANCH_CREATE = '')	
  	AND		(A.AUTH_STATUS_KT = @p_AUTH_STATUS_KT OR @p_AUTH_STATUS_KT IS NULL OR @p_AUTH_STATUS_KT = '')	
  	AND		((A.MAKER_ID_KT IS NOT NULL AND @p_KT_IS_DO = 'Y') --Lay danh sach chua duoc phong KT cap nhat va duoc cap nhat
  			OR ((A.MAKER_ID_KT IS NULL AND @p_KT_IS_DO = 'N')) 
  			OR @p_KT_IS_DO IS NULL OR @p_KT_IS_DO = '')
  	AND ((ISNULL(A.QTY,0) * ISNULL(A.BUY_PRICE,0)) >= @p_PRICE_FROM OR @p_PRICE_FROM = 0 OR @p_PRICE_FROM IS NULL)
  	AND ((ISNULL(A.QTY,0) * ISNULL(A.BUY_PRICE,0)) <= @p_PRICE_TO OR @p_PRICE_TO = 0 OR @p_PRICE_TO IS NULL)
  	-- 26-02-2020 LUCTV BO SUNG DIEU KIEN TIM KIEM PHIEU NHAP KHO THEO NGUOI TAO PHIEU : THEO YEU CAU BO SUNG CHINH SUA CUA VCCB
  	AND	(A.MAKER_ID = @p_MAKER_ID OR @p_MAKER_ID IS NULL OR @p_MAKER_ID = '')
  
      -- NEW TRANG THAI PHIEU XUAT LA LUU NHAP HOAC TU CHOI THI CHI NGUOI TAO CO THE TIM THAY
     AND ((A.AUTH_STATUS IN ('E','R')  AND A.MAKER_ID = @p_USER_LOGIN) OR A.AUTH_STATUS NOT IN ('E','R') OR @p_USER_LOGIN IS NULL OR @p_USER_LOGIN = '')
  
  	-- 11-03-2022 HUYHT BO SUNG DIEU KIEN TIM KIEM PHIEU NHAP THEO QUYEN KIEM NHIEM
      AND ((@p_TYPE_SEARCH='HC'
        AND (EXISTS(SELECT * FROM dbo.FN_GET_USER_BY_ROLE('GDDV',A.BRANCH_CREATE,A.DEPT_CREATE) US
          WHERE US.TLNANME = @p_USER_LOGIN))
        OR A.MAKER_ID = @p_USER_LOGIN)
      OR (@p_TYPE_SEARCH='KT' AND @P_LEVEL = 'ALL' AND A.BRANCH_CREATE IN (SELECT BRANCH_ID from @tmp))
  	OR (@p_TYPE_SEARCH='KT' AND @P_LEVEL = 'UNIT' AND A.BRANCH_CREATE = @p_BRANCH_CREATE)
    OR @p_TYPE_SEARCH IS NULL OR @p_TYPE_SEARCH ='')

		ORDER BY A.CREATE_DT DESC
-- PAGING END
	ELSE
-- PAGING BEGIN
		SELECT TOP (CONVERT(INT, @P_TOP))
				A.ADDNEW_ID,
				A.BUY_DATE,
				A.[TYPE_ID],
				C.[TYPE_NAME],
				A.GROUP_ID,
				D.GROUP_CODE,
				D.GROUP_NAME,
				A.ASSET_NAME,
				A.ASSET_SERIAL_NO,
				A.ASSET_DESC,
				A.BRANCH_ID,
				A.AMORT_START_DATE,
				A.DEPT_ID,
				H.DEP_CODE,
				H.DEP_NAME,
				A.EMP_ID,
				G.EMP_CODE,
				G.EMP_NAME,
				A.DIVISION_ID,
				ISNULL(A.BUY_PRICE,0) AS BUY_PRICE,
				ISNULL(A.AMORT_AMT,0) AS AMORT_AMT,
				A.AMORT_MONTH,
				A.AMORT_RATE,
				A.IS_MULTIPLE,
				A.QTY,
				A.PO_ID,
				PO.PO_CODE,
				A.REF_ASSET_ID,
				I.ASSET_CODE AS REF_ASS_CODE,
				I.ASSET_NAME AS REF_ASS_NAME,
				A.REF_AMORTIZED_AMT,
				A.WARRANTY_MONTHS,
				A.NOTES,
				A.CORE_NOTE,
				A.RECORD_STATUS,
				A.AUTH_STATUS,
				B.CONTENT AS AUTH_STATUS_NAME,AKT.CONTENT AS AUTH_STATUS_NAME_KT,
				A.MAKER_ID,
				UM.TLFullName MAKER_NAME,
				A.CREATE_DT,--CONVERT(VARCHAR(10), A.CREATE_DT, 103) AS S_CREATE_DT
				A.CHECKER_ID,
				A.APPROVE_DT, A.ENTRY_BOOKED,A.CONSTRUCT_ID,A.POSTED_STATUS, A.BRANCH_CREATE,A.MAKER_ID_KT, A.CREATE_DT_KT,A.CHECKER_ID_KT,A.APPROVE_DT_KT,A.AUTH_STATUS_KT,
				E.BRANCH_CODE, F.DIV_CODE, E.BRANCH_NAME, (ISNULL(E.BRANCH_NAME,'') + ' '+ ISNULL(H.DEP_NAME,'')) AS RECEIVE_BRANCH ,
				CREBRN.BRANCH_CODE AS R_BRANCH_CODE, CREBRN.BRANCH_NAME AS R_BRANCH_NAME, A.AMORT_END_DATE, A.ACCOUNT_GL, A.VAT, A.PRICE_VAT, (ISNULL(A.QTY,0) * ISNULL(A.BUY_PRICE,0)) AS TOTAL_AMT
				--, G.SUP_CODE, G.SUP_NAME
				,AP.ASSPO_ID AS ASS_PO_ID, AP.ADDNEW_ID AS ASS_PO_ADDNEWID, AP.PO_CODE AS ASS_PO_CODE, AP.INVOICE_NO AS AS_INVOICE_NO, AP.INVOICE_DATE AS ASS_INVOICE_DT,CREBRN.BRANCH_CODE+' - '+ CREBRN.BRANCH_NAME AS FULL_BRANCH_NAME
				,D.GROUP_CODE +' - '+ D.GROUP_NAME GROUP_NAME_FULL,
				UM2.TLFullName AS CREATE_USER_NAME, UM3.TLFullName AS APPROVE_NAME_KT, UM4.TLFullName AS CREATE_USER_NAME_KT,
				@p_USER_LOGIN AS USER_LOGIN,@p_TYPE_SEARCH AS TYPE_SEARCH --- TRA VE THAM SO GAN VO CURRENT SEARCH TRANH GAY LOI O CAC MAN HINH
-- SELECT END
		FROM ASS_ADDNEW A
		--LEFT JOIN CM_AUTH_STATUS B ON A.AUTH_STATUS = B.AUTH_STATUS
		LEFT JOIN dbo.CM_ALLCODE B ON B.CDVAL = A.AUTH_STATUS AND B.CDNAME = 'ASS_ADD_AUTH' AND B.CDTYPE = 'ASS_ADDNEW'
		LEFT JOIN ASS_TYPE C ON A.[TYPE_ID] = C.[TYPE_ID]
		LEFT JOIN ASS_GROUP D ON A.GROUP_ID = D.GROUP_ID
		LEFT JOIN TL_USER UM ON UM.TLNANME = A.CHECKER_ID
		LEFT JOIN TL_USER UM2 ON UM2.TLNANME = A.MAKER_ID
		LEFT JOIN TL_USER UM3 ON UM2.TLNANME = A.CHECKER_ID_KT
		LEFT JOIN TL_USER UM4 ON UM4.TLNANME = A.MAKER_ID_KT
		LEFT JOIN TR_PO_MASTER PO ON PO.PO_ID = A.PO_ID
		LEFT JOIN CM_BRANCH E ON E.BRANCH_ID = A.BRANCH_ID
		LEFT JOIN CM_DIVISION F ON F.DIV_ID = A.DIVISION_ID
		LEFT JOIN CM_EMPLOYEE G ON G.EMP_ID = A.EMP_ID
		LEFT JOIN CM_DEPARTMENT H ON H.DEP_ID = A.DEPT_ID
		LEFT JOIN ASS_MASTER I ON I.ASSET_ID = A.REF_ASSET_ID
		--LEFT JOIN CM_AUTH_STATUS AKT ON AKT.AUTH_STATUS = A.AUTH_STATUS_KT
		LEFT JOIN dbo.CM_ALLCODE AKT ON AKT.CDVAL = A.AUTH_STATUS_KT AND AKT.CDNAME = 'ASS_ADD_AUTH' AND AKT.CDTYPE = 'ASS_ADDNEW'
		LEFT JOIN CM_BRANCH CREBRN ON CREBRN.BRANCH_ID = A.BRANCH_CREATE
		LEFT JOIN ASS_PO AP ON A.ADDNEW_ID = AP.ADDNEW_ID
		WHERE	(A.ADDNEW_ID = @p_ADDNEW_ID OR @p_ADDNEW_ID IS NULL OR @p_ADDNEW_ID = '')

    -- TIM KIEM TU NGAY DEN NGAY O HC
		AND	((@p_TYPE_SEARCH = 'HC' AND (CONVERT(DATE,A.BUY_DATE,103) >= CONVERT(DATE, @p_FR_BUY_DATE, 103) OR @p_FR_BUY_DATE is NULL OR @p_FR_BUY_DATE = ''))
      OR @p_TYPE_SEARCH = 'KT' OR @p_TYPE_SEARCH IS NULL OR @p_TYPE_SEARCH = '')
    AND	((@p_TYPE_SEARCH = 'HC' AND (CONVERT(DATE,A.BUY_DATE,103) <= CONVERT(DATE, @p_TO_BUY_DATE, 103) OR @p_TO_BUY_DATE is NULL OR @p_TO_BUY_DATE = ''))
      OR @p_TYPE_SEARCH = 'KT' OR @p_TYPE_SEARCH IS NULL OR @p_TYPE_SEARCH = '')
		
    -- TIM KIEM TU NGAY O KT
    AND ((@p_TYPE_SEARCH = 'KT' AND (((A.MAKER_ID_KT IS NULL OR A.MAKER_ID_KT = '')
      AND (CONVERT(DATE,A.APPROVE_DT,103) >= CONVERT(DATE, @p_FR_BUY_DATE, 103) OR @p_FR_BUY_DATE is NULL OR @p_FR_BUY_DATE = ''))
      OR ((A.MAKER_ID_KT IS NOT NULL OR A.MAKER_ID_KT <> '')
          AND ((@p_AUTH_STATUS_KT = 'A' AND (CONVERT(DATE,A.APPROVE_DT_KT,103) >= CONVERT(DATE, @p_FR_BUY_DATE, 103) OR @p_FR_BUY_DATE is NULL OR @p_FR_BUY_DATE = ''))
            OR (@p_AUTH_STATUS_KT = 'U' AND (CONVERT(DATE,A.CREATE_DT_KT,103) >= CONVERT(DATE, @p_FR_BUY_DATE, 103) OR @p_FR_BUY_DATE is NULL OR @p_FR_BUY_DATE = ''))
            OR (@p_AUTH_STATUS_KT = 'R' AND (CONVERT(DATE,A.CREATE_DT_KT,103) >= CONVERT(DATE, @p_FR_BUY_DATE, 103) OR @p_FR_BUY_DATE is NULL OR @p_FR_BUY_DATE = ''))
            OR ((@p_AUTH_STATUS_KT = '' OR @p_AUTH_STATUS_KT IS NULL) AND (CONVERT(DATE,A.CREATE_DT_KT,103) >= CONVERT(DATE, @p_FR_BUY_DATE, 103) OR @p_FR_BUY_DATE is NULL OR @p_FR_BUY_DATE = ''))))))
    OR @p_TYPE_SEARCH = 'HC' OR @p_TYPE_SEARCH IS NULL OR @p_TYPE_SEARCH = '')
    -- TIM KIEM DEN NGAY O KT
    AND ((@p_TYPE_SEARCH = 'KT' AND (((A.MAKER_ID_KT IS NULL OR A.MAKER_ID_KT = '')
      AND (CONVERT(DATE,A.APPROVE_DT,103) <= CONVERT(DATE, @p_TO_BUY_DATE, 103) OR @p_TO_BUY_DATE is NULL OR @p_TO_BUY_DATE = ''))
      OR ((A.MAKER_ID_KT IS NOT NULL AND A.MAKER_ID_KT <> '')
          AND ((@p_AUTH_STATUS_KT = 'A' AND (CONVERT(DATE,A.APPROVE_DT_KT,103) <= CONVERT(DATE, @p_TO_BUY_DATE, 103) OR @p_TO_BUY_DATE is NULL OR @p_TO_BUY_DATE = ''))
            OR (@p_AUTH_STATUS_KT = 'U' AND (CONVERT(DATE,A.CREATE_DT_KT,103) <= CONVERT(DATE, @p_TO_BUY_DATE, 103) OR @p_TO_BUY_DATE is NULL OR @p_TO_BUY_DATE = ''))
            OR (@p_AUTH_STATUS_KT = 'U' AND (CONVERT(DATE,A.CREATE_DT_KT,103) <= CONVERT(DATE, @p_TO_BUY_DATE, 103) OR @p_TO_BUY_DATE is NULL OR @p_TO_BUY_DATE = ''))
            OR ((@p_AUTH_STATUS_KT = '' OR @p_AUTH_STATUS_KT IS NULL) AND (CONVERT(DATE,A.CREATE_DT_KT,103) <= CONVERT(DATE, @p_TO_BUY_DATE, 103) OR @p_TO_BUY_DATE is NULL OR @p_TO_BUY_DATE = ''))))))
    OR @p_TYPE_SEARCH = 'HC' OR @p_TYPE_SEARCH IS NULL OR @p_TYPE_SEARCH = '')
		
		AND		(A.[TYPE_ID] = @p_TYPE_ID OR @p_TYPE_ID IS NULL OR @p_TYPE_ID = '')
		AND		(A.GROUP_ID = @p_GROUP_ID OR @p_GROUP_ID IS NULL OR @p_GROUP_ID = '')
		AND		(D.GROUP_CODE = @l_GROUP_CODE OR @l_GROUP_CODE IS NULL OR @l_GROUP_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.BRANCH_ID = @p_BRANCH_ID OR @p_BRANCH_ID IS NULL OR @p_BRANCH_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.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		(A.IS_MULTIPLE = @p_IS_MULTIPLE OR @p_IS_MULTIPLE IS NULL OR @p_IS_MULTIPLE = '')
		AND		(A.QTY = @p_QTY OR @p_QTY IS NULL OR @p_QTY = 0)
		AND		(A.PO_ID = @p_PO_ID OR @p_PO_ID IS NULL OR @p_PO_ID = '')
		AND		((@p_TYPE = 'ADD_NEW' AND (A.REF_ASSET_ID IS NULL OR A.REF_ASSET_ID = '')) OR (@p_TYPE = 'ADD_REF' AND A.REF_ASSET_ID IS NOT NULL AND A.REF_ASSET_ID <> ''))
		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.WARRANTY_MONTHS = @p_WARRANTY_MONTHS OR @p_WARRANTY_MONTHS IS NULL OR @p_WARRANTY_MONTHS = 0)		
		AND		(A.NOTES like N'%' + @p_NOTES + '%' OR @p_NOTES IS NULL OR @p_NOTES = '')
		AND		(A.RECORD_STATUS = @p_RECORD_STATUS OR @p_RECORD_STATUS IS NULL OR @p_RECORD_STATUS = '')
		AND		(A.AUTH_STATUS = @p_AUTH_STATUS OR @p_AUTH_STATUS IS NULL OR @p_AUTH_STATUS = '')
		AND		(A.POSTED_STATUS = @p_POSTED_STATUS OR @p_POSTED_STATUS IS NULL OR @p_POSTED_STATUS = '')
		--AND		(A.BRANCH_CREATE = @p_BRANCH_CREATE OR @p_BRANCH_CREATE IS NULL OR @p_BRANCH_CREATE = '')
		AND		(A.AUTH_STATUS_KT = @p_AUTH_STATUS_KT OR @p_AUTH_STATUS_KT IS NULL OR @p_AUTH_STATUS_KT = '')
		AND		((A.MAKER_ID_KT IS NOT NULL AND @p_KT_IS_DO = 'Y') --Lay danh sach chua duoc phong KT cap nhat va duoc cap nhat
				OR ((A.MAKER_ID_KT IS NULL AND @p_KT_IS_DO = 'N')) 
				OR @p_KT_IS_DO IS NULL OR @p_KT_IS_DO = '')

		AND ((ISNULL(A.QTY,0) * ISNULL(A.BUY_PRICE,0)) >= @p_PRICE_FROM OR @p_PRICE_FROM = 0 OR @p_PRICE_FROM IS NULL)
		AND ((ISNULL(A.QTY,0) * ISNULL(A.BUY_PRICE,0)) <= @p_PRICE_TO OR @p_PRICE_TO = 0 OR @p_PRICE_TO IS NULL)
		-- 26-02-2020 LUCTV BO SUNG DIEU KIEN TIM KIEM PHIEU NHAP KHO THEO NGUOI TAO PHIEU : THEO YEU CAU BO SUNG CHINH SUA CUA VCCB
		AND	(A.MAKER_ID = @p_MAKER_ID OR @p_MAKER_ID IS NULL OR @p_MAKER_ID = '')

    -- NEW TRANG THAI PHIEU XUAT LA LUU NHAP HOAC TU CHOI THI CHI NGUOI TAO CO THE TIM THAY
	  AND ((A.AUTH_STATUS IN ('E','R')  AND A.MAKER_ID = @p_USER_LOGIN) OR A.AUTH_STATUS NOT IN ('E','R') OR @p_USER_LOGIN IS NULL OR @p_USER_LOGIN = '')
		
		-- 11-03-2022 HUYHT BO SUNG DIEU KIEN TIM KIEM PHIEU NHAP THEO QUYEN KIEM NHIEM
    AND ((@p_TYPE_SEARCH='HC'
        AND (EXISTS(SELECT * FROM dbo.FN_GET_USER_BY_ROLE('GDDV',A.BRANCH_CREATE,A.DEPT_CREATE) US
          WHERE US.TLNANME = @p_USER_LOGIN))
        OR A.MAKER_ID = @p_USER_LOGIN)
    OR (@p_TYPE_SEARCH='KT' AND @P_LEVEL = 'ALL' AND A.BRANCH_CREATE IN (SELECT BRANCH_ID from @tmp))
  	OR (@p_TYPE_SEARCH='KT' AND @P_LEVEL = 'UNIT' AND A.BRANCH_CREATE = @p_BRANCH_CREATE)
    OR @p_TYPE_SEARCH IS NULL OR @p_TYPE_SEARCH ='')

		ORDER BY A.CREATE_DT DESC
-- PAGING END
END -- PAGING

GO