ALTER PROC [dbo].[TR_REQ_KPI_Search]
@p_TYPE_REPORT VARCHAR(250) = NULL,
@p_ROLE VARCHAR(20) = NULL,
@p_MAKER_ID VARCHAR(20) = NULL,
@p_USER_LOGIN VARCHAR(50) = NULL,
@p_FRM_DATE VARCHAR(20) = NULL,
@p_TO_DATE VARCHAR(20) = NULL,
@p_AUTH_STATUS_KT VARCHAR(20) = NULL,
@p_TOP INT = NULL
AS
BEGIN -- PAGING
	DECLARE @p_FROM_DT DATE, @p_TO_DT DATE
	SET @p_FROM_DT =CONVERT(DATE,@p_FRM_DATE,103)
	SET @p_TO_DT =CONVERT(DATE,@p_TO_DATE,103)

	IF (@p_TYPE_REPORT='ASS')
	BEGIN
	-- PAGING BEGIN
		SELECT H.*
	-- SELECT END
		FROM
		(
			SELECT ADDNEW_ID AS MA_SO_PHIEU, A.CORE_NOTE AS NOI_DUNG,
			CONVERT(VARCHAR,MONTH(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.APPROVE_DT),2) AS NGAY_NHAN_PHIEU, 
			MAKER_ID_KT AS GDV,
			CONVERT(VARCHAR,MONTH(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(CREATE_DT_KT),2) AS NGAY_GDV_GUI_DUYET, 
			CHECKER_ID_KT AS KSV,
			CONVERT(VARCHAR,MONTH(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT_KT),2) AS NGAY_KSV_DUYET
			FROM ASS_ADDNEW A
			WHERE 1=1
			AND (CREATE_DT_KT >=@p_FROM_DT OR APPROVE_DT_KT  >=@p_FROM_DT OR @p_FRM_DATE IS NULL OR @p_FRM_DATE ='') 
			AND (CREATE_DT_KT <=@p_TO_DT OR APPROVE_DT_KT  <=@p_TO_DT OR @p_TO_DATE IS NULL OR @p_TO_DATE ='')
			AND MAKER_ID_KT IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
			UNION
			SELECT USER_MASTER_ID AS MA_SO_PHIEU, A.CORE_NOTE AS NOI_DUNG, 
			CONVERT(VARCHAR,MONTH(APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT),2) AS NGAY_NHAN_PHIEU, 
			MAKER_ID_KT AS GDV,
			CONVERT(VARCHAR,MONTH(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(CREATE_DT_KT),2) AS NGAY_GDV_GUI_DUYET, 
			CHECKER_ID_KT AS KSV,
			CONVERT(VARCHAR,MONTH(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT_KT),2) AS NGAY_KSV_DUYET
			FROM dbo.ASS_USE_MULTI_MASTER A
			WHERE 1=1
			AND (CREATE_DT_KT >=@p_FROM_DT OR APPROVE_DT_KT  >=@p_FROM_DT OR @p_FRM_DATE IS NULL OR @p_FRM_DATE ='') 
			AND (CREATE_DT_KT <=@p_TO_DT OR APPROVE_DT_KT  <=@p_TO_DT OR @p_TO_DATE IS NULL OR @p_TO_DATE ='')
			AND MAKER_ID_KT IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
			UNION
			SELECT TRANS_MULTI_MASTER_ID AS MA_SO_PHIEU, A.CORE_NOTE AS NOI_DUNG, 
			CONVERT(VARCHAR,MONTH(APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT),2) AS NGAY_NHAN_PHIEU, 
			MAKER_ID_KT AS GDV,
			CONVERT(VARCHAR,MONTH(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(CREATE_DT_KT),2) AS NGAY_GDV_GUI_DUYET, 
			CHECKER_ID_KT AS KSV,
			CONVERT(VARCHAR,MONTH(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT_KT),2) AS NGAY_KSV_DUYET
			FROM dbo.ASS_TRANSFER_MULTI_MASTER A
			WHERE 1=1
			AND (CREATE_DT_KT >=@p_FROM_DT OR APPROVE_DT_KT  >=@p_FROM_DT OR @p_FRM_DATE IS NULL OR @p_FRM_DATE ='') 
			AND (CREATE_DT_KT <=@p_TO_DT OR APPROVE_DT_KT  <=@p_TO_DT OR @p_TO_DATE IS NULL OR @p_TO_DATE ='')
			AND MAKER_ID_KT IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
			UNION
			SELECT COL_MULTI_MASTER_ID AS MA_SO_PHIEU, A.CORE_NOTE AS NOI_DUNG,
			CONVERT(VARCHAR,MONTH(APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT),2) AS NGAY_NHAN_PHIEU, 
			MAKER_ID_KT AS GDV,
			CONVERT(VARCHAR,MONTH(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(CREATE_DT_KT),2) AS NGAY_GDV_GUI_DUYET, 
			CHECKER_ID_KT AS KSV,
			CONVERT(VARCHAR,MONTH(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT_KT),2) AS NGAY_KSV_DUYET
			FROM dbo.ASS_COLLECT_MULTI_MASTER A
			WHERE 1=1
			AND (CREATE_DT_KT >=@p_FROM_DT OR APPROVE_DT_KT  >=@p_FROM_DT OR @p_FRM_DATE IS NULL OR @p_FRM_DATE ='') 
			AND (CREATE_DT_KT <=@p_TO_DT OR APPROVE_DT_KT  <=@p_TO_DT OR @p_TO_DATE IS NULL OR @p_TO_DATE ='')
			AND MAKER_ID_KT IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
			UNION
			SELECT LIQ_ID AS MA_SO_PHIEU, A.CORE_NOTE AS NOI_DUNG,
			CONVERT(VARCHAR,MONTH(APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT),2) AS NGAY_NHAN_PHIEU, 
			MAKER_ID_KT AS GDV,
			CONVERT(VARCHAR,MONTH(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(CREATE_DT_KT),2) AS NGAY_GDV_GUI_DUYET, 
			CHECKER_ID_KT AS KSV,
			CONVERT(VARCHAR,MONTH(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT_KT),2) AS NGAY_KSV_DUYET
			FROM dbo.ASS_LIQUIDATION A
			WHERE 1=1 
			AND (CREATE_DT_KT >=@p_FROM_DT OR APPROVE_DT_KT  >=@p_FROM_DT OR @p_FRM_DATE IS NULL OR @p_FRM_DATE ='') 
			AND (CREATE_DT_KT <=@p_TO_DT OR APPROVE_DT_KT  <=@p_TO_DT OR @p_TO_DATE IS NULL OR @p_TO_DATE ='')
			AND MAKER_ID_KT IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
		) H
	-- PAGING END
	END
	ELSE IF (@p_TYPE_REPORT='MW')
	BEGIN
	-- PAGING BEGIN
		SELECT H.*
	-- SELECT END
		FROM
		(
			SELECT A.IN_CODE AS MA_SO_PHIEU, A.CORE_NOTE AS NOI_DUNG,
			CONVERT(VARCHAR,MONTH(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.APPROVE_DT),2) AS NGAY_NHAN_PHIEU, 
			A.MAKER_ID_KT AS GDV, 
			CONVERT(VARCHAR,MONTH(A.CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(A.CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(A.CREATE_DT_KT),2) AS NGAY_GDV_GUI_DUYET, 
			CHECKER_ID_KT AS KSV,
			CONVERT(VARCHAR,MONTH(A.APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(A.APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(A.APPROVE_DT_KT),2) AS NGAY_KSV_DUYET
			FROM MW_IN_MASTER A
			WHERE 1=1
			AND A.AUTH_STATUS ='A'
			AND (	((ISNULL(@p_FROM_DT, '') = '' OR A.CREATE_DT_KT >=@p_FROM_DT ) AND A.CREATE_DT_KT <=@p_TO_DT)
					OR (( ISNULL(@p_FROM_DT, '') = '' OR A.APPROVE_DT_KT >=@p_FROM_DT) AND A.APPROVE_DT_KT <=@p_TO_DT)
				)
			--AND (ISNULL(A.CREATE_DT_KT,'') <> '' AND A.CREATE_DT_KT >= CONVERT(DATE, @p_FRM_DATE, 103)) OR (ISNULL(A.APPROVE_DT_KT,'') <> '' AND A.APPROVE_DT_KT >= CONVERT(DATE, @p_FRM_DATE, 103))
			--AND (ISNULL(A.CREATE_DT_KT,'') <> '' AND A.CREATE_DT_KT <= CONVERT(DATE, @p_TO_DATE, 103)) OR (ISNULL(A.APPROVE_DT_KT,'') <> '' AND A.APPROVE_DT_KT <= CONVERT(DATE, @p_TO_DATE, 103))
			AND A.MAKER_ID_KT IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
			AND (ISNULL(A.MAKER_ID_KT, '') = @p_MAKER_ID OR @p_MAKER_ID = '' OR @p_MAKER_ID IS NULL)
			AND (	(@p_ROLE = 'GDV' AND A.AUTH_STATUS_KT IN('A', 'U') AND ISNULL(A.CREATE_DT_KT, '') <> '') 
					OR (@p_ROLE = 'KSV' AND A.AUTH_STATUS_KT IN ('A')) 
					OR (ISNULL(@p_ROLE, '') = '' AND A.AUTH_STATUS_KT IN('A', 'U') AND ISNULL(A.CREATE_DT_KT, '') <> '') 
				)
			UNION
			SELECT OUT_CODE AS MA_SO_PHIEU, A.CORE_NOTE AS NOI_DUNG,
			CONVERT(VARCHAR,MONTH(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.APPROVE_DT),2) AS NGAY_NHAN_PHIEU, 
			A.KT_MAKER_ID AS GDV, 
			CONVERT(VARCHAR,MONTH(A.KT_CREATE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.KT_CREATE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.KT_CREATE_DT),2) AS NGAY_GDV_GUI_DUYET, 
			KT_CHECKER_ID AS KSV, 
			CONVERT(VARCHAR,MONTH(A.KT_APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.KT_APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.KT_APPROVE_DT),2) AS NGAY_KSV_DUYET 
			FROM MW_OUT A
			WHERE 1=1 
			AND A.AUTH_STATUS ='A'
			AND (	((ISNULL(@p_FROM_DT, '') = '' OR A.KT_CREATE_DT >=@p_FROM_DT) AND A.KT_CREATE_DT <=@p_TO_DT)
					OR ((ISNULL(@p_FROM_DT, '') = '' OR A.KT_APPROVE_DT >=@p_FROM_DT) AND A.KT_APPROVE_DT <=@p_TO_DT)
				)
			--AND (ISNULL(A.KT_CREATE_DT,'') <> '' AND A.KT_CREATE_DT >= CONVERT(DATE, @p_FRM_DATE, 103)) OR (ISNULL(A.KT_APPROVE_DT,'') <> '' AND A.KT_APPROVE_DT >= CONVERT(DATE, @p_FRM_DATE, 103))
			--AND (ISNULL(A.KT_CREATE_DT,'') <> '' AND A.KT_CREATE_DT <= CONVERT(DATE, @p_TO_DATE, 103)) OR (ISNULL(A.KT_APPROVE_DT,'') <> '' AND A.KT_APPROVE_DT <= CONVERT(DATE, @p_TO_DATE, 103))
			AND A.KT_MAKER_ID IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
			AND (ISNULL(A.KT_MAKER_ID, '') = @p_MAKER_ID OR @p_MAKER_ID = '' OR @p_MAKER_ID IS NULL)
			AND (	(@p_ROLE = 'GDV' AND A.KT_AUTH_STATUS IN('A', 'U') AND ISNULL(A.KT_CREATE_DT, '') <> '') 
					OR (@p_ROLE = 'KSV' AND A.KT_AUTH_STATUS IN ('A')) 
					OR (ISNULL(@p_ROLE, '') = '' AND A.KT_AUTH_STATUS IN('A', 'U') AND ISNULL(A.KT_CREATE_DT, '') <> '') 
				)
			UNION
			SELECT A.TRANSFER_CODE AS MA_SO_PHIEU, A.CORE_NOTE AS NOI_DUNG, 
			CONVERT(VARCHAR,MONTH(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.APPROVE_DT),2) AS NGAY_NHAN_PHIEU, 
			A.KT_MAKER_ID AS GDV, 
			CONVERT(VARCHAR,MONTH(A.KT_CREATE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.KT_CREATE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.KT_CREATE_DT),2) AS NGAY_GDV_GUI_DUYET, 
			A.KT_CHECKER_ID AS KSV, 
			CONVERT(VARCHAR,MONTH(A.KT_APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.KT_APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.KT_APPROVE_DT),2) AS NGAY_KSV_DUYET 
			FROM MW_TRANSFER A
			WHERE 1=1 
			AND A.AUTH_STATUS ='A'
			AND (	((A.KT_CREATE_DT >=@p_FROM_DT OR ISNULL(@p_FROM_DT, '') = '') AND A.KT_CREATE_DT <=@p_TO_DT)
					OR ((A.KT_APPROVE_DT >=@p_FROM_DT OR ISNULL(@p_FROM_DT, '') = '') AND A.KT_APPROVE_DT <=@p_TO_DT)
				)
			--AND (ISNULL(A.KT_CREATE_DT,'') <> '' AND A.KT_CREATE_DT >= CONVERT(DATE, @p_FRM_DATE, 103)) OR (ISNULL(A.KT_APPROVE_DT,'') <> '' AND A.KT_APPROVE_DT >= CONVERT(DATE, @p_FRM_DATE, 103))
			--AND (ISNULL(A.KT_CREATE_DT,'') <> '' AND A.KT_CREATE_DT <= CONVERT(DATE, @p_TO_DATE, 103)) OR (ISNULL(A.KT_APPROVE_DT,'') <> '' AND A.KT_APPROVE_DT <= CONVERT(DATE, @p_TO_DATE, 103))
			AND A.KT_MAKER_ID IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
			AND (ISNULL(A.KT_MAKER_ID, '') = @p_MAKER_ID OR @p_MAKER_ID = '' OR @p_MAKER_ID IS NULL)
			AND (	(@p_ROLE = 'GDV' AND A.KT_AUTH_STATUS IN('A', 'U') AND ISNULL(A.KT_CREATE_DT, '') <> '') 
					OR (@p_ROLE = 'KSV' AND A.KT_AUTH_STATUS IN ('A')) 
					OR (ISNULL(@p_ROLE, '') = '' AND A.KT_AUTH_STATUS IN('A', 'U') AND ISNULL(A.KT_CREATE_DT, '') <> '') 
				)
			UNION
			SELECT A.LIQ_CODE AS MA_SO_PHIEU, A.CORE_NOTE AS NOI_DUNG, 
			CONVERT(VARCHAR,MONTH(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.APPROVE_DT),2) AS NGAY_NHAN_PHIEU, 
			A.KT_MAKER_ID AS GDV, 
			CONVERT(VARCHAR,MONTH(A.KT_CREATE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.KT_CREATE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.KT_CREATE_DT),2) AS NGAY_GDV_GUI_DUYET, 
			A.KT_CHECKER_ID AS KSV, 
			CONVERT(VARCHAR,MONTH(A.KT_APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.KT_APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.KT_APPROVE_DT),2) AS NGAY_KSV_DUYET 
			FROM MW_LIQ_MASTER A
			WHERE 1=1 
			AND A.AUTH_STATUS ='A'
			AND (	((A.KT_CREATE_DT >=@p_FROM_DT OR ISNULL(@p_FROM_DT, '') = '')  AND A.KT_CREATE_DT <=@p_TO_DT)
					OR ((A.KT_APPROVE_DT >=@p_FROM_DT OR ISNULL(@p_FROM_DT, '') = '') AND A.KT_APPROVE_DT <=@p_TO_DT)
				)
			--AND (ISNULL(A.KT_CREATE_DT,'') <> '' AND A.KT_CREATE_DT >= CONVERT(DATE, @p_FRM_DATE, 103)) OR (ISNULL(A.KT_APPROVE_DT,'') <> '' AND A.KT_APPROVE_DT >= CONVERT(DATE, @p_FRM_DATE, 103))
			--AND (ISNULL(A.KT_CREATE_DT,'') <> '' AND A.KT_CREATE_DT <= CONVERT(DATE, @p_TO_DATE, 103)) OR (ISNULL(A.KT_APPROVE_DT,'') <> '' AND A.KT_APPROVE_DT <= CONVERT(DATE, @p_TO_DATE, 103))
			AND A.KT_MAKER_ID IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
			AND (ISNULL(A.KT_MAKER_ID, '') = @p_MAKER_ID OR @p_MAKER_ID = '' OR @p_MAKER_ID IS NULL)
			AND (	(@p_ROLE = 'GDV' AND A.KT_AUTH_STATUS IN('A', 'U') AND ISNULL(A.KT_CREATE_DT, '') <> '') 
					OR (@p_ROLE = 'KSV' AND A.KT_AUTH_STATUS IN ('A')) 
					OR (ISNULL(@p_ROLE, '') = '' AND A.KT_AUTH_STATUS IN('A', 'U') AND ISNULL(A.KT_CREATE_DT, '') <> '') 
				)
		) H
	-- PAGING END	
	END
	ELSE IF (@p_TYPE_REPORT='PAY')
	BEGIN
	-- PAGING BEGIN
		SELECT H.*
	-- SELECT END
		FROM	
		(
			SELECT A.REQ_PAY_CODE AS MA_SO_PHIEU,
			A.REQ_REASON AS NOI_DUNG, 
			A.REQ_AMT AS SO_TIEN_THANH_TOAN_TAM_UNG,
			A.TRANSFER_DT  AS NGAY_NHAN_PHIEU,
			C.TLNAME AS GDV,
			A.CREATE_DT_KT AS NGAY_GDV_GUI_DUYET,
			D.TLNAME AS KSV, 
			A.APPROVE_DT_KT AS NGAY_KSV_DUYET, 
			A.AUTH_STATUS_KT, 
			CASE	WHEN A.AUTH_STATUS_KT = 'U' THEN N'KSV điều phối'
					WHEN A.AUTH_STATUS_KT = 'P' THEN N'GDV gửi duyệt'
					WHEN A.AUTH_STATUS_KT = 'S' THEN N'GDV đề xuất từ chối phiếu'
					WHEN A.AUTH_STATUS_KT = 'R' THEN N'KSV từ chối phiếu'
					WHEN A.AUTH_STATUS_KT = 'A' THEN N'KSV duyệt phiếu'
			END AS AUTH_STATUS_KT_NAME
			FROM TR_REQ_PAYMENT A
			INNER JOIN PL_REQUEST_PROCESS_CHILD C ON A.REQ_PAY_ID = C.REQ_ID AND C.TYPE_JOB = 'XL'
			INNER JOIN PL_REQUEST_PROCESS_CHILD D ON A.REQ_PAY_ID = D.REQ_ID AND D.TYPE_JOB = 'KS'
			WHERE 1=1
			AND A.AUTH_STATUS ='A'
			-- Ngày tính KPI
			AND(CONVERT(DATE, A.TRANSFER_DT) >= CONVERT(DATE, @p_FRM_DATE, 103) OR ISNULL(@p_FRM_DATE, '') = '')
			AND(CONVERT(DATE, A.TRANSFER_DT) <= CONVERT(DATE, @p_TO_DATE, 103) OR ISNULL(@p_TO_DATE, '') = '')
			-- Người xử lý
			AND (A.MAKER_ID_KT = @p_MAKER_ID OR @p_MAKER_ID = '' OR @p_MAKER_ID IS NULL)
			-- Trạng thái duyệt
			AND (A.AUTH_STATUS_KT = @p_AUTH_STATUS_KT OR @p_AUTH_STATUS_KT = '' OR @p_AUTH_STATUS_KT IS NULL)

			UNION

			SELECT A.REQ_PAY_CODE AS MA_SO_PHIEU,
			A.REQ_REASON AS NOI_DUNG, 
			A.REQ_AMT AS SO_TIEN_THANH_TOAN_TAM_UNG, 
			A.TRANSFER_DT  AS NGAY_NHAN_PHIEU,
			C.TLNAME AS GDV,
			A.CREATE_DT_KT AS NGAY_GDV_GUI_DUYET,
			D.TLNAME AS KSV, 
			A.APPROVE_DT_KT AS NGAY_KSV_DUYET, 
			A.AUTH_STATUS_KT, 
			CASE	WHEN A.AUTH_STATUS_KT = 'U' THEN N'KSV điều phối'
					WHEN A.AUTH_STATUS_KT = 'P' THEN N'GDV gửi duyệt'
					WHEN A.AUTH_STATUS_KT = 'S' THEN N'GDV đề xuất từ chối phiếu'
					WHEN A.AUTH_STATUS_KT = 'R' THEN N'KSV từ chối phiếu'
					WHEN A.AUTH_STATUS_KT = 'A' THEN N'KSV duyệt phiếu'
			END AS AUTH_STATUS_KT_NAME
			FROM TR_REQ_ADVANCE_PAYMENT A
			INNER JOIN PL_REQUEST_PROCESS_CHILD C ON A.REQ_PAY_ID = C.REQ_ID AND C.TYPE_JOB = 'XL'
			INNER JOIN PL_REQUEST_PROCESS_CHILD D ON A.REQ_PAY_ID = D.REQ_ID AND D.TYPE_JOB = 'KS'
			WHERE 1=1
			AND A.AUTH_STATUS ='A'
			-- Ngày tính KPI
			AND(CONVERT(DATE, A.TRANSFER_DT) >= CONVERT(DATE, @p_FRM_DATE, 103) OR ISNULL(@p_FRM_DATE, '') = '')
			AND(CONVERT(DATE, A.TRANSFER_DT) <= CONVERT(DATE, @p_TO_DATE, 103) OR ISNULL(@p_TO_DATE, '') = '')
			-- Người xử lý
			AND (A.MAKER_ID_KT = @p_MAKER_ID OR @p_MAKER_ID = '' OR @p_MAKER_ID IS NULL)
			-- Trạng thái duyệt
			AND (A.AUTH_STATUS_KT = @p_AUTH_STATUS_KT OR @p_AUTH_STATUS_KT = '' OR @p_AUTH_STATUS_KT IS NULL)
		) H
	-- PAGING END
	END
END -- PAGING

GO

ALTER PROC [dbo].[rpt_TR_REQ_PAY_KPI_Report]
@p_TYPE_REPORT VARCHAR(250) = NULL,
@p_ROLE VARCHAR(20) = NULL,
@p_MAKER_ID VARCHAR(20) = NULL,
@p_USER_LOGIN VARCHAR(50) = NULL,
@p_FRM_DATE VARCHAR(20) = NULL,
@p_TO_DATE VARCHAR(20) = NULL
AS
BEGIN

	-- Get Role
	DECLARE @tbl_GDV TABLE(TLNAME VARCHAR(15))
	DECLARE @tbl_KSV TABLE(TLNAME VARCHAR(15))
	DECLARE @tbl_ALL TABLE(TLNAME VARCHAR(15))
	insert into @tbl_GDV  SELECT TLNANME  FROM TL_USER WHERE RoleName = 'GDV'
	insert into @tbl_KSV  SELECT TLNANME  FROM TL_USER WHERE RoleName = 'KSV'
	insert into @tbl_ALL  SELECT TLNANME  FROM TL_USER WHERE RoleName = 'GDV' OR RoleName = 'KSV'

	DECLARE @p_FROM_DT DATE, @p_TO_DT DATE
	SET @p_FROM_DT =ISNULL(CONVERT(DATE,@p_FRM_DATE,103),'')
	SET @p_TO_DT =CONVERT(DATE,@p_TO_DATE,103)
	print '@p_FROM_DT: ' + CONVERT(VARCHAR(50),@p_FROM_DT)
	print '@p_TO_DT: ' + CONVERT(VARCHAR(50),@p_TO_DT)

	IF(@p_ROLE = 'GDV')
	BEGIN
		IF (@p_TYPE_REPORT='ASS')
		BEGIN
			SELECT ADDNEW_ID AS MA_SO_PHIEU, A.CORE_NOTE AS NOI_DUNG,
			CONVERT(VARCHAR,MONTH(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.APPROVE_DT),2) AS NGAY_NHAN_PHIEU, 
			MAKER_ID_KT AS GDV,
			CONVERT(VARCHAR,MONTH(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(CREATE_DT_KT),2) AS NGAY_GDV_GUI_DUYET, 
			CHECKER_ID_KT AS KSV,
			CONVERT(VARCHAR,MONTH(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT_KT),2) AS NGAY_KSV_DUYET
			FROM ASS_ADDNEW A
			WHERE 1=1
			AND (CREATE_DT_KT >=@p_FROM_DT OR APPROVE_DT_KT  >=@p_FROM_DT OR @p_FRM_DATE IS NULL OR @p_FRM_DATE ='') 
			AND (CREATE_DT_KT <=@p_TO_DT OR APPROVE_DT_KT  <=@p_TO_DT OR @p_TO_DATE IS NULL OR @p_TO_DATE ='')
			AND MAKER_ID_KT IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
			UNION
			SELECT USER_MASTER_ID AS MA_SO_PHIEU, A.CORE_NOTE AS NOI_DUNG, 
			CONVERT(VARCHAR,MONTH(APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT),2) AS NGAY_NHAN_PHIEU, 
			MAKER_ID_KT AS GDV,
			CONVERT(VARCHAR,MONTH(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(CREATE_DT_KT),2) AS NGAY_GDV_GUI_DUYET, 
			CHECKER_ID_KT AS KSV,
			CONVERT(VARCHAR,MONTH(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT_KT),2) AS NGAY_KSV_DUYET
			FROM dbo.ASS_USE_MULTI_MASTER A
			WHERE 1=1
			AND (CREATE_DT_KT >=@p_FROM_DT OR APPROVE_DT_KT  >=@p_FROM_DT OR @p_FRM_DATE IS NULL OR @p_FRM_DATE ='') 
			AND (CREATE_DT_KT <=@p_TO_DT OR APPROVE_DT_KT  <=@p_TO_DT OR @p_TO_DATE IS NULL OR @p_TO_DATE ='')
			AND MAKER_ID_KT IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
			UNION
			SELECT TRANS_MULTI_MASTER_ID AS MA_SO_PHIEU, A.CORE_NOTE AS NOI_DUNG, 
			CONVERT(VARCHAR,MONTH(APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT),2) AS NGAY_NHAN_PHIEU, 
			MAKER_ID_KT AS GDV,
			CONVERT(VARCHAR,MONTH(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(CREATE_DT_KT),2) AS NGAY_GDV_GUI_DUYET, 
			CHECKER_ID_KT AS KSV,
			CONVERT(VARCHAR,MONTH(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT_KT),2) AS NGAY_KSV_DUYET
			FROM dbo.ASS_TRANSFER_MULTI_MASTER A
			WHERE 1=1
			AND (CREATE_DT_KT >=@p_FROM_DT OR APPROVE_DT_KT  >=@p_FROM_DT OR @p_FRM_DATE IS NULL OR @p_FRM_DATE ='') 
			AND (CREATE_DT_KT <=@p_TO_DT OR APPROVE_DT_KT  <=@p_TO_DT OR @p_TO_DATE IS NULL OR @p_TO_DATE ='')
			AND MAKER_ID_KT IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
			UNION
			SELECT COL_MULTI_MASTER_ID AS MA_SO_PHIEU, A.CORE_NOTE AS NOI_DUNG,
			CONVERT(VARCHAR,MONTH(APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT),2) AS NGAY_NHAN_PHIEU, 
			MAKER_ID_KT AS GDV,
			CONVERT(VARCHAR,MONTH(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(CREATE_DT_KT),2) AS NGAY_GDV_GUI_DUYET, 
			CHECKER_ID_KT AS KSV,
			CONVERT(VARCHAR,MONTH(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT_KT),2) AS NGAY_KSV_DUYET
			FROM dbo.ASS_COLLECT_MULTI_MASTER A
			WHERE 1=1
			AND (CREATE_DT_KT >=@p_FROM_DT OR APPROVE_DT_KT  >=@p_FROM_DT OR @p_FRM_DATE IS NULL OR @p_FRM_DATE ='') 
			AND (CREATE_DT_KT <=@p_TO_DT OR APPROVE_DT_KT  <=@p_TO_DT OR @p_TO_DATE IS NULL OR @p_TO_DATE ='')
			AND MAKER_ID_KT IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
			UNION
			SELECT LIQ_ID AS MA_SO_PHIEU, A.CORE_NOTE AS NOI_DUNG,
			CONVERT(VARCHAR,MONTH(APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT),2) AS NGAY_NHAN_PHIEU, 
			MAKER_ID_KT AS GDV,
			CONVERT(VARCHAR,MONTH(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(CREATE_DT_KT),2) AS NGAY_GDV_GUI_DUYET, 
			CHECKER_ID_KT AS KSV,
			CONVERT(VARCHAR,MONTH(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT_KT),2) AS NGAY_KSV_DUYET
			FROM dbo.ASS_LIQUIDATION A
			WHERE 1=1 
			AND (CREATE_DT_KT >=@p_FROM_DT OR APPROVE_DT_KT  >=@p_FROM_DT OR @p_FRM_DATE IS NULL OR @p_FRM_DATE ='') 
			AND (CREATE_DT_KT <=@p_TO_DT OR APPROVE_DT_KT  <=@p_TO_DT OR @p_TO_DATE IS NULL OR @p_TO_DATE ='')
			AND MAKER_ID_KT IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
		END
		ELSE IF (@p_TYPE_REPORT='MW')
		BEGIN
			SELECT A.IN_CODE AS MA_SO_PHIEU, A.CORE_NOTE AS NOI_DUNG,
			CONVERT(VARCHAR,MONTH(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.APPROVE_DT),2) AS NGAY_NHAN_PHIEU, 
			A.MAKER_ID_KT AS GDV, 
			CONVERT(VARCHAR,MONTH(A.CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(A.CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(A.CREATE_DT_KT),2) AS NGAY_GDV_GUI_DUYET, 
			CHECKER_ID_KT AS KSV,
			CONVERT(VARCHAR,MONTH(A.APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(A.APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(A.APPROVE_DT_KT),2) AS NGAY_KSV_DUYET
			FROM MW_IN_MASTER A
			WHERE 1=1
			AND A.AUTH_STATUS ='A'
			AND (	((ISNULL(@p_FROM_DT, '') = '' OR A.CREATE_DT_KT >=@p_FROM_DT ) AND A.CREATE_DT_KT <=@p_TO_DT)
					OR (( ISNULL(@p_FROM_DT, '') = '' OR A.APPROVE_DT_KT >=@p_FROM_DT) AND A.APPROVE_DT_KT <=@p_TO_DT)
				)
			--AND (ISNULL(A.CREATE_DT_KT,'') <> '' AND A.CREATE_DT_KT >= CONVERT(DATE, @p_FRM_DATE, 103)) OR (ISNULL(A.APPROVE_DT_KT,'') <> '' AND A.APPROVE_DT_KT >= CONVERT(DATE, @p_FRM_DATE, 103))
			--AND (ISNULL(A.CREATE_DT_KT,'') <> '' AND A.CREATE_DT_KT <= CONVERT(DATE, @p_TO_DATE, 103)) OR (ISNULL(A.APPROVE_DT_KT,'') <> '' AND A.APPROVE_DT_KT <= CONVERT(DATE, @p_TO_DATE, 103))
			AND A.MAKER_ID_KT IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
			AND (ISNULL(A.MAKER_ID_KT, '') = @p_MAKER_ID OR @p_MAKER_ID = '' OR @p_MAKER_ID IS NULL)
			AND (	(@p_ROLE = 'GDV' AND A.AUTH_STATUS_KT IN('A', 'U') AND ISNULL(A.CREATE_DT_KT, '') <> '') 
					OR (@p_ROLE = 'KSV' AND A.AUTH_STATUS_KT IN ('A')) 
					OR (ISNULL(@p_ROLE, '') = '' AND A.AUTH_STATUS_KT IN('A', 'U') AND ISNULL(A.CREATE_DT_KT, '') <> '') 
				)
			UNION
			SELECT OUT_CODE AS MA_SO_PHIEU, A.CORE_NOTE AS NOI_DUNG,
			CONVERT(VARCHAR,MONTH(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.APPROVE_DT),2) AS NGAY_NHAN_PHIEU, 
			A.KT_MAKER_ID AS GDV, 
			CONVERT(VARCHAR,MONTH(A.KT_CREATE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.KT_CREATE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.KT_CREATE_DT),2) AS NGAY_GDV_GUI_DUYET, 
			KT_CHECKER_ID AS KSV, 
			CONVERT(VARCHAR,MONTH(A.KT_APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.KT_APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.KT_APPROVE_DT),2) AS NGAY_KSV_DUYET 
			FROM MW_OUT A
			WHERE 1=1 
			AND A.AUTH_STATUS ='A'
			AND (	((ISNULL(@p_FROM_DT, '') = '' OR A.KT_CREATE_DT >=@p_FROM_DT) AND A.KT_CREATE_DT <=@p_TO_DT)
					OR ((ISNULL(@p_FROM_DT, '') = '' OR A.KT_APPROVE_DT >=@p_FROM_DT) AND A.KT_APPROVE_DT <=@p_TO_DT)
				)
			--AND (ISNULL(A.KT_CREATE_DT,'') <> '' AND A.KT_CREATE_DT >= CONVERT(DATE, @p_FRM_DATE, 103)) OR (ISNULL(A.KT_APPROVE_DT,'') <> '' AND A.KT_APPROVE_DT >= CONVERT(DATE, @p_FRM_DATE, 103))
			--AND (ISNULL(A.KT_CREATE_DT,'') <> '' AND A.KT_CREATE_DT <= CONVERT(DATE, @p_TO_DATE, 103)) OR (ISNULL(A.KT_APPROVE_DT,'') <> '' AND A.KT_APPROVE_DT <= CONVERT(DATE, @p_TO_DATE, 103))
			AND A.KT_MAKER_ID IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
			AND (ISNULL(A.KT_MAKER_ID, '') = @p_MAKER_ID OR @p_MAKER_ID = '' OR @p_MAKER_ID IS NULL)
			AND (	(@p_ROLE = 'GDV' AND A.KT_AUTH_STATUS IN('A', 'U') AND ISNULL(A.KT_CREATE_DT, '') <> '') 
					OR (@p_ROLE = 'KSV' AND A.KT_AUTH_STATUS IN ('A')) 
					OR (ISNULL(@p_ROLE, '') = '' AND A.KT_AUTH_STATUS IN('A', 'U') AND ISNULL(A.KT_CREATE_DT, '') <> '') 
				)
			UNION
			SELECT A.TRANSFER_CODE AS MA_SO_PHIEU, A.CORE_NOTE AS NOI_DUNG, 
			CONVERT(VARCHAR,MONTH(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.APPROVE_DT),2) AS NGAY_NHAN_PHIEU, 
			A.KT_MAKER_ID AS GDV, 
			CONVERT(VARCHAR,MONTH(A.KT_CREATE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.KT_CREATE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.KT_CREATE_DT),2) AS NGAY_GDV_GUI_DUYET, 
			A.KT_CHECKER_ID AS KSV, 
			CONVERT(VARCHAR,MONTH(A.KT_APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.KT_APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.KT_APPROVE_DT),2) AS NGAY_KSV_DUYET 
			FROM MW_TRANSFER A
			WHERE 1=1 
			AND A.AUTH_STATUS ='A'
			AND (	((A.KT_CREATE_DT >=@p_FROM_DT OR ISNULL(@p_FROM_DT, '') = '') AND A.KT_CREATE_DT <=@p_TO_DT)
					OR ((A.KT_APPROVE_DT >=@p_FROM_DT OR ISNULL(@p_FROM_DT, '') = '') AND A.KT_APPROVE_DT <=@p_TO_DT)
				)
			--AND (ISNULL(A.KT_CREATE_DT,'') <> '' AND A.KT_CREATE_DT >= CONVERT(DATE, @p_FRM_DATE, 103)) OR (ISNULL(A.KT_APPROVE_DT,'') <> '' AND A.KT_APPROVE_DT >= CONVERT(DATE, @p_FRM_DATE, 103))
			--AND (ISNULL(A.KT_CREATE_DT,'') <> '' AND A.KT_CREATE_DT <= CONVERT(DATE, @p_TO_DATE, 103)) OR (ISNULL(A.KT_APPROVE_DT,'') <> '' AND A.KT_APPROVE_DT <= CONVERT(DATE, @p_TO_DATE, 103))
			AND A.KT_MAKER_ID IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
			AND (ISNULL(A.KT_MAKER_ID, '') = @p_MAKER_ID OR @p_MAKER_ID = '' OR @p_MAKER_ID IS NULL)
			AND (	(@p_ROLE = 'GDV' AND A.KT_AUTH_STATUS IN('A', 'U') AND ISNULL(A.KT_CREATE_DT, '') <> '') 
					OR (@p_ROLE = 'KSV' AND A.KT_AUTH_STATUS IN ('A')) 
					OR (ISNULL(@p_ROLE, '') = '' AND A.KT_AUTH_STATUS IN('A', 'U') AND ISNULL(A.KT_CREATE_DT, '') <> '') 
				)
			UNION
			SELECT A.LIQ_CODE AS MA_SO_PHIEU, A.CORE_NOTE AS NOI_DUNG, 
			CONVERT(VARCHAR,MONTH(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.APPROVE_DT),2) AS NGAY_NHAN_PHIEU, 
			A.KT_MAKER_ID AS GDV, 
			CONVERT(VARCHAR,MONTH(A.KT_CREATE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.KT_CREATE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.KT_CREATE_DT),2) AS NGAY_GDV_GUI_DUYET, 
			A.KT_CHECKER_ID AS KSV, 
			CONVERT(VARCHAR,MONTH(A.KT_APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.KT_APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.KT_APPROVE_DT),2) AS NGAY_KSV_DUYET 
			FROM MW_LIQ_MASTER A
			WHERE 1=1 
			AND A.AUTH_STATUS ='A'
			AND (	((A.KT_CREATE_DT >=@p_FROM_DT OR ISNULL(@p_FROM_DT, '') = '')  AND A.KT_CREATE_DT <=@p_TO_DT)
					OR ((A.KT_APPROVE_DT >=@p_FROM_DT OR ISNULL(@p_FROM_DT, '') = '') AND A.KT_APPROVE_DT <=@p_TO_DT)
				)
			--AND (ISNULL(A.KT_CREATE_DT,'') <> '' AND A.KT_CREATE_DT >= CONVERT(DATE, @p_FRM_DATE, 103)) OR (ISNULL(A.KT_APPROVE_DT,'') <> '' AND A.KT_APPROVE_DT >= CONVERT(DATE, @p_FRM_DATE, 103))
			--AND (ISNULL(A.KT_CREATE_DT,'') <> '' AND A.KT_CREATE_DT <= CONVERT(DATE, @p_TO_DATE, 103)) OR (ISNULL(A.KT_APPROVE_DT,'') <> '' AND A.KT_APPROVE_DT <= CONVERT(DATE, @p_TO_DATE, 103))
			AND A.KT_MAKER_ID IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
			AND (ISNULL(A.KT_MAKER_ID, '') = @p_MAKER_ID OR @p_MAKER_ID = '' OR @p_MAKER_ID IS NULL)
			AND (	(@p_ROLE = 'GDV' AND A.KT_AUTH_STATUS IN('A', 'U') AND ISNULL(A.KT_CREATE_DT, '') <> '') 
					OR (@p_ROLE = 'KSV' AND A.KT_AUTH_STATUS IN ('A')) 
					OR (ISNULL(@p_ROLE, '') = '' AND A.KT_AUTH_STATUS IN('A', 'U') AND ISNULL(A.KT_CREATE_DT, '') <> '') 
				)
		END
		ELSE IF (@p_TYPE_REPORT='PAY')
		BEGIN
			SELECT H.* FROM 
			(
				SELECT A.REQ_PAY_CODE AS MA_SO_PHIEU,A.REQ_REASON AS NOI_DUNG, A.REQ_AMT AS SO_TIEN_THANH_TOAN_TAM_UNG,
				CONVERT(VARCHAR,MONTH(A.TRANSFER_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.TRANSFER_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.TRANSFER_DT),2)  AS NGAY_NHAN_PHIEU,
				A.MAKER_ID_KT AS GDV,
				CONVERT(VARCHAR,MONTH(A.CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(A.CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(A.CREATE_DT_KT),2) AS NGAY_GDV_GUI_DUYET,
				A.CHECKER_ID_KT AS KSV, 
				CONVERT(VARCHAR,MONTH(A.APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(A.APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(A.APPROVE_DT_KT),2) AS NGAY_KSV_DUYET, A.AUTH_STATUS_KT,
				PR.ID
				FROM TR_REQ_PAYMENT A
				LEFT JOIN PL_PROCESS PR ON A.REQ_PAY_ID = PR.REQ_ID AND (PR.PROCESS_ID = 'SUG' OR PR.PROCESS_ID = 'SEND') AND PR.CHECKER_ID IN (SELECT TLNAME FROM @tbl_GDV)
				WHERE 1=1
				AND	(PR.APPROVE_DT >= @p_FROM_DT AND PR.APPROVE_DT <=@p_TO_DT)
				AND (PR.CHECKER_ID = @p_MAKER_ID OR @p_MAKER_ID = '' OR @p_MAKER_ID IS NULL)

				UNION

				SELECT A.REQ_PAY_CODE AS MA_SO_PHIEU,A.REQ_REASON AS NOI_DUNG, A.REQ_AMT AS SO_TIEN_THANH_TOAN_TAM_UNG, 
				CONVERT(VARCHAR,MONTH(A.TRANSFER_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.TRANSFER_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.TRANSFER_DT),2)  AS NGAY_NHAN_PHIEU,
				A.MAKER_ID_KT AS GDV,
				CONVERT(VARCHAR,MONTH(A.CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(A.CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(A.CREATE_DT_KT),2) AS NGAY_GDV_GUI_DUYET,
				A.CHECKER_ID_KT AS KSV, 
				CONVERT(VARCHAR,MONTH(A.APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(A.APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(A.APPROVE_DT_KT),2) AS NGAY_KSV_DUYET, A.AUTH_STATUS_KT ,
				PR.ID
				FROM TR_REQ_ADVANCE_PAYMENT A
				LEFT JOIN PL_PROCESS PR ON A.REQ_PAY_ID = PR.REQ_ID AND (PR.PROCESS_ID = 'SUG' OR PR.PROCESS_ID = 'SEND') AND PR.CHECKER_ID IN (SELECT TLNAME FROM @tbl_GDV)
				WHERE 1=1
				AND	(PR.APPROVE_DT >= @p_FROM_DT AND PR.APPROVE_DT <=@p_TO_DT)
				AND (PR.CHECKER_ID = @p_MAKER_ID OR @p_MAKER_ID = '' OR @p_MAKER_ID IS NULL)
			) H
			ORDER BY H.MA_SO_PHIEU
		END
	END
	ELSE IF(@p_ROLE = 'KSV')
	BEGIN
		IF (@p_TYPE_REPORT='ASS')
		BEGIN
			SELECT ADDNEW_ID AS MA_SO_PHIEU, A.CORE_NOTE AS NOI_DUNG,
			CONVERT(VARCHAR,MONTH(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.APPROVE_DT),2) AS NGAY_NHAN_PHIEU, 
			MAKER_ID_KT AS GDV,
			CONVERT(VARCHAR,MONTH(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(CREATE_DT_KT),2) AS NGAY_GDV_GUI_DUYET, 
			CHECKER_ID_KT AS KSV,
			CONVERT(VARCHAR,MONTH(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT_KT),2) AS NGAY_KSV_DUYET
			FROM ASS_ADDNEW A
			WHERE 1=1
			AND (CREATE_DT_KT >=@p_FROM_DT OR APPROVE_DT_KT  >=@p_FROM_DT OR @p_FRM_DATE IS NULL OR @p_FRM_DATE ='') 
			AND (CREATE_DT_KT <=@p_TO_DT OR APPROVE_DT_KT  <=@p_TO_DT OR @p_TO_DATE IS NULL OR @p_TO_DATE ='')
			AND MAKER_ID_KT IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
			UNION
			SELECT USER_MASTER_ID AS MA_SO_PHIEU, A.CORE_NOTE AS NOI_DUNG, 
			CONVERT(VARCHAR,MONTH(APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT),2) AS NGAY_NHAN_PHIEU, 
			MAKER_ID_KT AS GDV,
			CONVERT(VARCHAR,MONTH(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(CREATE_DT_KT),2) AS NGAY_GDV_GUI_DUYET, 
			CHECKER_ID_KT AS KSV,
			CONVERT(VARCHAR,MONTH(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT_KT),2) AS NGAY_KSV_DUYET
			FROM dbo.ASS_USE_MULTI_MASTER A
			WHERE 1=1
			AND (CREATE_DT_KT >=@p_FROM_DT OR APPROVE_DT_KT  >=@p_FROM_DT OR @p_FRM_DATE IS NULL OR @p_FRM_DATE ='') 
			AND (CREATE_DT_KT <=@p_TO_DT OR APPROVE_DT_KT  <=@p_TO_DT OR @p_TO_DATE IS NULL OR @p_TO_DATE ='')
			AND MAKER_ID_KT IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
			UNION
			SELECT TRANS_MULTI_MASTER_ID AS MA_SO_PHIEU, A.CORE_NOTE AS NOI_DUNG, 
			CONVERT(VARCHAR,MONTH(APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT),2) AS NGAY_NHAN_PHIEU, 
			MAKER_ID_KT AS GDV,
			CONVERT(VARCHAR,MONTH(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(CREATE_DT_KT),2) AS NGAY_GDV_GUI_DUYET, 
			CHECKER_ID_KT AS KSV,
			CONVERT(VARCHAR,MONTH(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT_KT),2) AS NGAY_KSV_DUYET
			FROM dbo.ASS_TRANSFER_MULTI_MASTER A
			WHERE 1=1
			AND (CREATE_DT_KT >=@p_FROM_DT OR APPROVE_DT_KT  >=@p_FROM_DT OR @p_FRM_DATE IS NULL OR @p_FRM_DATE ='') 
			AND (CREATE_DT_KT <=@p_TO_DT OR APPROVE_DT_KT  <=@p_TO_DT OR @p_TO_DATE IS NULL OR @p_TO_DATE ='')
			AND MAKER_ID_KT IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
			UNION
			SELECT COL_MULTI_MASTER_ID AS MA_SO_PHIEU, A.CORE_NOTE AS NOI_DUNG,
			CONVERT(VARCHAR,MONTH(APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT),2) AS NGAY_NHAN_PHIEU, 
			MAKER_ID_KT AS GDV,
			CONVERT(VARCHAR,MONTH(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(CREATE_DT_KT),2) AS NGAY_GDV_GUI_DUYET, 
			CHECKER_ID_KT AS KSV,
			CONVERT(VARCHAR,MONTH(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT_KT),2) AS NGAY_KSV_DUYET
			FROM dbo.ASS_COLLECT_MULTI_MASTER A
			WHERE 1=1
			AND (CREATE_DT_KT >=@p_FROM_DT OR APPROVE_DT_KT  >=@p_FROM_DT OR @p_FRM_DATE IS NULL OR @p_FRM_DATE ='') 
			AND (CREATE_DT_KT <=@p_TO_DT OR APPROVE_DT_KT  <=@p_TO_DT OR @p_TO_DATE IS NULL OR @p_TO_DATE ='')
			AND MAKER_ID_KT IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
			UNION
			SELECT LIQ_ID AS MA_SO_PHIEU, A.CORE_NOTE AS NOI_DUNG,
			CONVERT(VARCHAR,MONTH(APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT),2) AS NGAY_NHAN_PHIEU, 
			MAKER_ID_KT AS GDV,
			CONVERT(VARCHAR,MONTH(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(CREATE_DT_KT),2) AS NGAY_GDV_GUI_DUYET, 
			CHECKER_ID_KT AS KSV,
			CONVERT(VARCHAR,MONTH(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT_KT),2) AS NGAY_KSV_DUYET
			FROM dbo.ASS_LIQUIDATION A
			WHERE 1=1 
			AND (CREATE_DT_KT >=@p_FROM_DT OR APPROVE_DT_KT  >=@p_FROM_DT OR @p_FRM_DATE IS NULL OR @p_FRM_DATE ='') 
			AND (CREATE_DT_KT <=@p_TO_DT OR APPROVE_DT_KT  <=@p_TO_DT OR @p_TO_DATE IS NULL OR @p_TO_DATE ='')
			AND MAKER_ID_KT IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
		END
		ELSE IF (@p_TYPE_REPORT='MW')
		BEGIN
			SELECT A.IN_CODE AS MA_SO_PHIEU, A.CORE_NOTE AS NOI_DUNG,
			CONVERT(VARCHAR,MONTH(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.APPROVE_DT),2) AS NGAY_NHAN_PHIEU, 
			A.MAKER_ID_KT AS GDV, 
			CONVERT(VARCHAR,MONTH(A.CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(A.CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(A.CREATE_DT_KT),2) AS NGAY_GDV_GUI_DUYET, 
			CHECKER_ID_KT AS KSV,
			CONVERT(VARCHAR,MONTH(A.APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(A.APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(A.APPROVE_DT_KT),2) AS NGAY_KSV_DUYET
			FROM MW_IN_MASTER A
			WHERE 1=1
			AND A.AUTH_STATUS ='A'
			AND (	((ISNULL(@p_FROM_DT, '') = '' OR A.CREATE_DT_KT >=@p_FROM_DT ) AND A.CREATE_DT_KT <=@p_TO_DT)
					OR (( ISNULL(@p_FROM_DT, '') = '' OR A.APPROVE_DT_KT >=@p_FROM_DT) AND A.APPROVE_DT_KT <=@p_TO_DT)
				)
			--AND (ISNULL(A.CREATE_DT_KT,'') <> '' AND A.CREATE_DT_KT >= CONVERT(DATE, @p_FRM_DATE, 103)) OR (ISNULL(A.APPROVE_DT_KT,'') <> '' AND A.APPROVE_DT_KT >= CONVERT(DATE, @p_FRM_DATE, 103))
			--AND (ISNULL(A.CREATE_DT_KT,'') <> '' AND A.CREATE_DT_KT <= CONVERT(DATE, @p_TO_DATE, 103)) OR (ISNULL(A.APPROVE_DT_KT,'') <> '' AND A.APPROVE_DT_KT <= CONVERT(DATE, @p_TO_DATE, 103))
			AND A.MAKER_ID_KT IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
			AND (ISNULL(A.MAKER_ID_KT, '') = @p_MAKER_ID OR @p_MAKER_ID = '' OR @p_MAKER_ID IS NULL)
			AND (	(@p_ROLE = 'GDV' AND A.AUTH_STATUS_KT IN('A', 'U') AND ISNULL(A.CREATE_DT_KT, '') <> '') 
					OR (@p_ROLE = 'KSV' AND A.AUTH_STATUS_KT IN ('A')) 
					OR (ISNULL(@p_ROLE, '') = '' AND A.AUTH_STATUS_KT IN('A', 'U') AND ISNULL(A.CREATE_DT_KT, '') <> '') 
				)
			UNION
			SELECT OUT_CODE AS MA_SO_PHIEU, A.CORE_NOTE AS NOI_DUNG,
			CONVERT(VARCHAR,MONTH(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.APPROVE_DT),2) AS NGAY_NHAN_PHIEU, 
			A.KT_MAKER_ID AS GDV, 
			CONVERT(VARCHAR,MONTH(A.KT_CREATE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.KT_CREATE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.KT_CREATE_DT),2) AS NGAY_GDV_GUI_DUYET, 
			KT_CHECKER_ID AS KSV, 
			CONVERT(VARCHAR,MONTH(A.KT_APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.KT_APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.KT_APPROVE_DT),2) AS NGAY_KSV_DUYET 
			FROM MW_OUT A
			WHERE 1=1 
			AND A.AUTH_STATUS ='A'
			AND (	((ISNULL(@p_FROM_DT, '') = '' OR A.KT_CREATE_DT >=@p_FROM_DT) AND A.KT_CREATE_DT <=@p_TO_DT)
					OR ((ISNULL(@p_FROM_DT, '') = '' OR A.KT_APPROVE_DT >=@p_FROM_DT) AND A.KT_APPROVE_DT <=@p_TO_DT)
				)
			--AND (ISNULL(A.KT_CREATE_DT,'') <> '' AND A.KT_CREATE_DT >= CONVERT(DATE, @p_FRM_DATE, 103)) OR (ISNULL(A.KT_APPROVE_DT,'') <> '' AND A.KT_APPROVE_DT >= CONVERT(DATE, @p_FRM_DATE, 103))
			--AND (ISNULL(A.KT_CREATE_DT,'') <> '' AND A.KT_CREATE_DT <= CONVERT(DATE, @p_TO_DATE, 103)) OR (ISNULL(A.KT_APPROVE_DT,'') <> '' AND A.KT_APPROVE_DT <= CONVERT(DATE, @p_TO_DATE, 103))
			AND A.KT_MAKER_ID IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
			AND (ISNULL(A.KT_MAKER_ID, '') = @p_MAKER_ID OR @p_MAKER_ID = '' OR @p_MAKER_ID IS NULL)
			AND (	(@p_ROLE = 'GDV' AND A.KT_AUTH_STATUS IN('A', 'U') AND ISNULL(A.KT_CREATE_DT, '') <> '') 
					OR (@p_ROLE = 'KSV' AND A.KT_AUTH_STATUS IN ('A')) 
					OR (ISNULL(@p_ROLE, '') = '' AND A.KT_AUTH_STATUS IN('A', 'U') AND ISNULL(A.KT_CREATE_DT, '') <> '') 
				)
			UNION
			SELECT A.TRANSFER_CODE AS MA_SO_PHIEU, A.CORE_NOTE AS NOI_DUNG, 
			CONVERT(VARCHAR,MONTH(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.APPROVE_DT),2) AS NGAY_NHAN_PHIEU, 
			A.KT_MAKER_ID AS GDV, 
			CONVERT(VARCHAR,MONTH(A.KT_CREATE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.KT_CREATE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.KT_CREATE_DT),2) AS NGAY_GDV_GUI_DUYET, 
			A.KT_CHECKER_ID AS KSV, 
			CONVERT(VARCHAR,MONTH(A.KT_APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.KT_APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.KT_APPROVE_DT),2) AS NGAY_KSV_DUYET 
			FROM MW_TRANSFER A
			WHERE 1=1 
			AND A.AUTH_STATUS ='A'
			AND (	((A.KT_CREATE_DT >=@p_FROM_DT OR ISNULL(@p_FROM_DT, '') = '') AND A.KT_CREATE_DT <=@p_TO_DT)
					OR ((A.KT_APPROVE_DT >=@p_FROM_DT OR ISNULL(@p_FROM_DT, '') = '') AND A.KT_APPROVE_DT <=@p_TO_DT)
				)
			--AND (ISNULL(A.KT_CREATE_DT,'') <> '' AND A.KT_CREATE_DT >= CONVERT(DATE, @p_FRM_DATE, 103)) OR (ISNULL(A.KT_APPROVE_DT,'') <> '' AND A.KT_APPROVE_DT >= CONVERT(DATE, @p_FRM_DATE, 103))
			--AND (ISNULL(A.KT_CREATE_DT,'') <> '' AND A.KT_CREATE_DT <= CONVERT(DATE, @p_TO_DATE, 103)) OR (ISNULL(A.KT_APPROVE_DT,'') <> '' AND A.KT_APPROVE_DT <= CONVERT(DATE, @p_TO_DATE, 103))
			AND A.KT_MAKER_ID IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
			AND (ISNULL(A.KT_MAKER_ID, '') = @p_MAKER_ID OR @p_MAKER_ID = '' OR @p_MAKER_ID IS NULL)
			AND (	(@p_ROLE = 'GDV' AND A.KT_AUTH_STATUS IN('A', 'U') AND ISNULL(A.KT_CREATE_DT, '') <> '') 
					OR (@p_ROLE = 'KSV' AND A.KT_AUTH_STATUS IN ('A')) 
					OR (ISNULL(@p_ROLE, '') = '' AND A.KT_AUTH_STATUS IN('A', 'U') AND ISNULL(A.KT_CREATE_DT, '') <> '') 
				)
			UNION
			SELECT A.LIQ_CODE AS MA_SO_PHIEU, A.CORE_NOTE AS NOI_DUNG, 
			CONVERT(VARCHAR,MONTH(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.APPROVE_DT),2) AS NGAY_NHAN_PHIEU, 
			A.KT_MAKER_ID AS GDV, 
			CONVERT(VARCHAR,MONTH(A.KT_CREATE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.KT_CREATE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.KT_CREATE_DT),2) AS NGAY_GDV_GUI_DUYET, 
			A.KT_CHECKER_ID AS KSV, 
			CONVERT(VARCHAR,MONTH(A.KT_APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.KT_APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.KT_APPROVE_DT),2) AS NGAY_KSV_DUYET 
			FROM MW_LIQ_MASTER A
			WHERE 1=1 
			AND A.AUTH_STATUS ='A'
			AND (	((A.KT_CREATE_DT >=@p_FROM_DT OR ISNULL(@p_FROM_DT, '') = '')  AND A.KT_CREATE_DT <=@p_TO_DT)
					OR ((A.KT_APPROVE_DT >=@p_FROM_DT OR ISNULL(@p_FROM_DT, '') = '') AND A.KT_APPROVE_DT <=@p_TO_DT)
				)
			--AND (ISNULL(A.KT_CREATE_DT,'') <> '' AND A.KT_CREATE_DT >= CONVERT(DATE, @p_FRM_DATE, 103)) OR (ISNULL(A.KT_APPROVE_DT,'') <> '' AND A.KT_APPROVE_DT >= CONVERT(DATE, @p_FRM_DATE, 103))
			--AND (ISNULL(A.KT_CREATE_DT,'') <> '' AND A.KT_CREATE_DT <= CONVERT(DATE, @p_TO_DATE, 103)) OR (ISNULL(A.KT_APPROVE_DT,'') <> '' AND A.KT_APPROVE_DT <= CONVERT(DATE, @p_TO_DATE, 103))
			AND A.KT_MAKER_ID IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
			AND (ISNULL(A.KT_MAKER_ID, '') = @p_MAKER_ID OR @p_MAKER_ID = '' OR @p_MAKER_ID IS NULL)
			AND (	(@p_ROLE = 'GDV' AND A.KT_AUTH_STATUS IN('A', 'U') AND ISNULL(A.KT_CREATE_DT, '') <> '') 
					OR (@p_ROLE = 'KSV' AND A.KT_AUTH_STATUS IN ('A')) 
					OR (ISNULL(@p_ROLE, '') = '' AND A.KT_AUTH_STATUS IN('A', 'U') AND ISNULL(A.KT_CREATE_DT, '') <> '') 
				)
		END
		ELSE IF (@p_TYPE_REPORT='PAY')
		BEGIN
			SELECT H.* FROM 
			(
				SELECT A.REQ_PAY_CODE AS MA_SO_PHIEU,A.REQ_REASON AS NOI_DUNG, A.REQ_AMT AS SO_TIEN_THANH_TOAN_TAM_UNG,
				CONVERT(VARCHAR,MONTH(A.TRANSFER_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.TRANSFER_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.TRANSFER_DT),2)  AS NGAY_NHAN_PHIEU,
				A.MAKER_ID_KT AS GDV,
				CONVERT(VARCHAR,MONTH(A.CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(A.CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(A.CREATE_DT_KT),2) AS NGAY_GDV_GUI_DUYET,
				A.CHECKER_ID_KT AS KSV, 
				CONVERT(VARCHAR,MONTH(A.APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(A.APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(A.APPROVE_DT_KT),2) AS NGAY_KSV_DUYET, A.AUTH_STATUS_KT,
				PR.ID
				FROM TR_REQ_PAYMENT A
				LEFT JOIN PL_PROCESS PR ON A.REQ_PAY_ID = PR.REQ_ID AND (PR.NOTES =N'Trả về cho người tạo phiếu' OR PR.NOTES =N'Trả về' OR PR.PROCESS_ID = 'APP') AND PR.CHECKER_ID IN (SELECT TLNAME FROM @tbl_KSV)
				WHERE 1=1
				AND	(PR.APPROVE_DT >= @p_FROM_DT AND PR.APPROVE_DT <=@p_TO_DT)
				AND (PR.CHECKER_ID = @p_MAKER_ID OR @p_MAKER_ID = '' OR @p_MAKER_ID IS NULL)

				UNION

				SELECT A.REQ_PAY_CODE AS MA_SO_PHIEU,A.REQ_REASON AS NOI_DUNG, A.REQ_AMT AS SO_TIEN_THANH_TOAN_TAM_UNG, 
				CONVERT(VARCHAR,MONTH(A.TRANSFER_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.TRANSFER_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.TRANSFER_DT),2)  AS NGAY_NHAN_PHIEU,
				A.MAKER_ID_KT AS GDV,
				CONVERT(VARCHAR,MONTH(A.CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(A.CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(A.CREATE_DT_KT),2) AS NGAY_GDV_GUI_DUYET,
				A.CHECKER_ID_KT AS KSV, 
				CONVERT(VARCHAR,MONTH(A.APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(A.APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(A.APPROVE_DT_KT),2) AS NGAY_KSV_DUYET, A.AUTH_STATUS_KT ,
				PR.ID
				FROM TR_REQ_ADVANCE_PAYMENT A
				LEFT JOIN PL_PROCESS PR ON A.REQ_PAY_ID = PR.REQ_ID AND (PR.NOTES =N'Trả về cho người tạo phiếu' OR PR.NOTES =N'Trả về' OR PR.PROCESS_ID = 'APP') AND PR.CHECKER_ID IN (SELECT TLNAME FROM @tbl_KSV)
				WHERE 1=1
				AND	(PR.APPROVE_DT >= @p_FROM_DT AND PR.APPROVE_DT <=@p_TO_DT)
				AND (PR.CHECKER_ID = @p_MAKER_ID OR @p_MAKER_ID = '' OR @p_MAKER_ID IS NULL)
			) H
			ORDER BY H.MA_SO_PHIEU
		END
	END
	ELSE
	BEGIN
		IF (@p_TYPE_REPORT='ASS')
		BEGIN
			SELECT ADDNEW_ID AS MA_SO_PHIEU, A.CORE_NOTE AS NOI_DUNG,
			CONVERT(VARCHAR,MONTH(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.APPROVE_DT),2) AS NGAY_NHAN_PHIEU, 
			MAKER_ID_KT AS GDV,
			CONVERT(VARCHAR,MONTH(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(CREATE_DT_KT),2) AS NGAY_GDV_GUI_DUYET, 
			CHECKER_ID_KT AS KSV,
			CONVERT(VARCHAR,MONTH(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT_KT),2) AS NGAY_KSV_DUYET
			FROM ASS_ADDNEW A
			WHERE 1=1
			AND (CREATE_DT_KT >=@p_FROM_DT OR APPROVE_DT_KT  >=@p_FROM_DT OR @p_FRM_DATE IS NULL OR @p_FRM_DATE ='') 
			AND (CREATE_DT_KT <=@p_TO_DT OR APPROVE_DT_KT  <=@p_TO_DT OR @p_TO_DATE IS NULL OR @p_TO_DATE ='')
			AND MAKER_ID_KT IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
			UNION
			SELECT USER_MASTER_ID AS MA_SO_PHIEU, A.CORE_NOTE AS NOI_DUNG, 
			CONVERT(VARCHAR,MONTH(APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT),2) AS NGAY_NHAN_PHIEU, 
			MAKER_ID_KT AS GDV,
			CONVERT(VARCHAR,MONTH(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(CREATE_DT_KT),2) AS NGAY_GDV_GUI_DUYET, 
			CHECKER_ID_KT AS KSV,
			CONVERT(VARCHAR,MONTH(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT_KT),2) AS NGAY_KSV_DUYET
			FROM dbo.ASS_USE_MULTI_MASTER A
			WHERE 1=1
			AND (CREATE_DT_KT >=@p_FROM_DT OR APPROVE_DT_KT  >=@p_FROM_DT OR @p_FRM_DATE IS NULL OR @p_FRM_DATE ='') 
			AND (CREATE_DT_KT <=@p_TO_DT OR APPROVE_DT_KT  <=@p_TO_DT OR @p_TO_DATE IS NULL OR @p_TO_DATE ='')
			AND MAKER_ID_KT IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
			UNION
			SELECT TRANS_MULTI_MASTER_ID AS MA_SO_PHIEU, A.CORE_NOTE AS NOI_DUNG, 
			CONVERT(VARCHAR,MONTH(APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT),2) AS NGAY_NHAN_PHIEU, 
			MAKER_ID_KT AS GDV,
			CONVERT(VARCHAR,MONTH(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(CREATE_DT_KT),2) AS NGAY_GDV_GUI_DUYET, 
			CHECKER_ID_KT AS KSV,
			CONVERT(VARCHAR,MONTH(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT_KT),2) AS NGAY_KSV_DUYET
			FROM dbo.ASS_TRANSFER_MULTI_MASTER A
			WHERE 1=1
			AND (CREATE_DT_KT >=@p_FROM_DT OR APPROVE_DT_KT  >=@p_FROM_DT OR @p_FRM_DATE IS NULL OR @p_FRM_DATE ='') 
			AND (CREATE_DT_KT <=@p_TO_DT OR APPROVE_DT_KT  <=@p_TO_DT OR @p_TO_DATE IS NULL OR @p_TO_DATE ='')
			AND MAKER_ID_KT IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
			UNION
			SELECT COL_MULTI_MASTER_ID AS MA_SO_PHIEU, A.CORE_NOTE AS NOI_DUNG,
			CONVERT(VARCHAR,MONTH(APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT),2) AS NGAY_NHAN_PHIEU, 
			MAKER_ID_KT AS GDV,
			CONVERT(VARCHAR,MONTH(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(CREATE_DT_KT),2) AS NGAY_GDV_GUI_DUYET, 
			CHECKER_ID_KT AS KSV,
			CONVERT(VARCHAR,MONTH(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT_KT),2) AS NGAY_KSV_DUYET
			FROM dbo.ASS_COLLECT_MULTI_MASTER A
			WHERE 1=1
			AND (CREATE_DT_KT >=@p_FROM_DT OR APPROVE_DT_KT  >=@p_FROM_DT OR @p_FRM_DATE IS NULL OR @p_FRM_DATE ='') 
			AND (CREATE_DT_KT <=@p_TO_DT OR APPROVE_DT_KT  <=@p_TO_DT OR @p_TO_DATE IS NULL OR @p_TO_DATE ='')
			AND MAKER_ID_KT IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
			UNION
			SELECT LIQ_ID AS MA_SO_PHIEU, A.CORE_NOTE AS NOI_DUNG,
			CONVERT(VARCHAR,MONTH(APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT),2) AS NGAY_NHAN_PHIEU, 
			MAKER_ID_KT AS GDV,
			CONVERT(VARCHAR,MONTH(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(CREATE_DT_KT),2) AS NGAY_GDV_GUI_DUYET, 
			CHECKER_ID_KT AS KSV,
			CONVERT(VARCHAR,MONTH(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT_KT),2) AS NGAY_KSV_DUYET
			FROM dbo.ASS_LIQUIDATION A
			WHERE 1=1 
			AND (CREATE_DT_KT >=@p_FROM_DT OR APPROVE_DT_KT  >=@p_FROM_DT OR @p_FRM_DATE IS NULL OR @p_FRM_DATE ='') 
			AND (CREATE_DT_KT <=@p_TO_DT OR APPROVE_DT_KT  <=@p_TO_DT OR @p_TO_DATE IS NULL OR @p_TO_DATE ='')
			AND MAKER_ID_KT IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
		END
		ELSE IF (@p_TYPE_REPORT='MW')
		BEGIN
			SELECT A.IN_CODE AS MA_SO_PHIEU, A.CORE_NOTE AS NOI_DUNG,
			CONVERT(VARCHAR,MONTH(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.APPROVE_DT),2) AS NGAY_NHAN_PHIEU, 
			A.MAKER_ID_KT AS GDV, 
			CONVERT(VARCHAR,MONTH(A.CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(A.CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(A.CREATE_DT_KT),2) AS NGAY_GDV_GUI_DUYET, 
			CHECKER_ID_KT AS KSV,
			CONVERT(VARCHAR,MONTH(A.APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(A.APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(A.APPROVE_DT_KT),2) AS NGAY_KSV_DUYET
			FROM MW_IN_MASTER A
			WHERE 1=1
			AND A.AUTH_STATUS ='A'
			AND (	((ISNULL(@p_FROM_DT, '') = '' OR A.CREATE_DT_KT >=@p_FROM_DT ) AND A.CREATE_DT_KT <=@p_TO_DT)
					OR (( ISNULL(@p_FROM_DT, '') = '' OR A.APPROVE_DT_KT >=@p_FROM_DT) AND A.APPROVE_DT_KT <=@p_TO_DT)
				)
			--AND (ISNULL(A.CREATE_DT_KT,'') <> '' AND A.CREATE_DT_KT >= CONVERT(DATE, @p_FRM_DATE, 103)) OR (ISNULL(A.APPROVE_DT_KT,'') <> '' AND A.APPROVE_DT_KT >= CONVERT(DATE, @p_FRM_DATE, 103))
			--AND (ISNULL(A.CREATE_DT_KT,'') <> '' AND A.CREATE_DT_KT <= CONVERT(DATE, @p_TO_DATE, 103)) OR (ISNULL(A.APPROVE_DT_KT,'') <> '' AND A.APPROVE_DT_KT <= CONVERT(DATE, @p_TO_DATE, 103))
			AND A.MAKER_ID_KT IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
			AND (ISNULL(A.MAKER_ID_KT, '') = @p_MAKER_ID OR @p_MAKER_ID = '' OR @p_MAKER_ID IS NULL)
			AND (	(@p_ROLE = 'GDV' AND A.AUTH_STATUS_KT IN('A', 'U') AND ISNULL(A.CREATE_DT_KT, '') <> '') 
					OR (@p_ROLE = 'KSV' AND A.AUTH_STATUS_KT IN ('A')) 
					OR (ISNULL(@p_ROLE, '') = '' AND A.AUTH_STATUS_KT IN('A', 'U') AND ISNULL(A.CREATE_DT_KT, '') <> '') 
				)
			UNION
			SELECT OUT_CODE AS MA_SO_PHIEU, A.CORE_NOTE AS NOI_DUNG,
			CONVERT(VARCHAR,MONTH(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.APPROVE_DT),2) AS NGAY_NHAN_PHIEU, 
			A.KT_MAKER_ID AS GDV, 
			CONVERT(VARCHAR,MONTH(A.KT_CREATE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.KT_CREATE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.KT_CREATE_DT),2) AS NGAY_GDV_GUI_DUYET, 
			KT_CHECKER_ID AS KSV, 
			CONVERT(VARCHAR,MONTH(A.KT_APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.KT_APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.KT_APPROVE_DT),2) AS NGAY_KSV_DUYET 
			FROM MW_OUT A
			WHERE 1=1 
			AND A.AUTH_STATUS ='A'
			AND (	((ISNULL(@p_FROM_DT, '') = '' OR A.KT_CREATE_DT >=@p_FROM_DT) AND A.KT_CREATE_DT <=@p_TO_DT)
					OR ((ISNULL(@p_FROM_DT, '') = '' OR A.KT_APPROVE_DT >=@p_FROM_DT) AND A.KT_APPROVE_DT <=@p_TO_DT)
				)
			--AND (ISNULL(A.KT_CREATE_DT,'') <> '' AND A.KT_CREATE_DT >= CONVERT(DATE, @p_FRM_DATE, 103)) OR (ISNULL(A.KT_APPROVE_DT,'') <> '' AND A.KT_APPROVE_DT >= CONVERT(DATE, @p_FRM_DATE, 103))
			--AND (ISNULL(A.KT_CREATE_DT,'') <> '' AND A.KT_CREATE_DT <= CONVERT(DATE, @p_TO_DATE, 103)) OR (ISNULL(A.KT_APPROVE_DT,'') <> '' AND A.KT_APPROVE_DT <= CONVERT(DATE, @p_TO_DATE, 103))
			AND A.KT_MAKER_ID IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
			AND (ISNULL(A.KT_MAKER_ID, '') = @p_MAKER_ID OR @p_MAKER_ID = '' OR @p_MAKER_ID IS NULL)
			AND (	(@p_ROLE = 'GDV' AND A.KT_AUTH_STATUS IN('A', 'U') AND ISNULL(A.KT_CREATE_DT, '') <> '') 
					OR (@p_ROLE = 'KSV' AND A.KT_AUTH_STATUS IN ('A')) 
					OR (ISNULL(@p_ROLE, '') = '' AND A.KT_AUTH_STATUS IN('A', 'U') AND ISNULL(A.KT_CREATE_DT, '') <> '') 
				)
			UNION
			SELECT A.TRANSFER_CODE AS MA_SO_PHIEU, A.CORE_NOTE AS NOI_DUNG, 
			CONVERT(VARCHAR,MONTH(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.APPROVE_DT),2) AS NGAY_NHAN_PHIEU, 
			A.KT_MAKER_ID AS GDV, 
			CONVERT(VARCHAR,MONTH(A.KT_CREATE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.KT_CREATE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.KT_CREATE_DT),2) AS NGAY_GDV_GUI_DUYET, 
			A.KT_CHECKER_ID AS KSV, 
			CONVERT(VARCHAR,MONTH(A.KT_APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.KT_APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.KT_APPROVE_DT),2) AS NGAY_KSV_DUYET 
			FROM MW_TRANSFER A
			WHERE 1=1 
			AND A.AUTH_STATUS ='A'
			AND (	((A.KT_CREATE_DT >=@p_FROM_DT OR ISNULL(@p_FROM_DT, '') = '') AND A.KT_CREATE_DT <=@p_TO_DT)
					OR ((A.KT_APPROVE_DT >=@p_FROM_DT OR ISNULL(@p_FROM_DT, '') = '') AND A.KT_APPROVE_DT <=@p_TO_DT)
				)
			--AND (ISNULL(A.KT_CREATE_DT,'') <> '' AND A.KT_CREATE_DT >= CONVERT(DATE, @p_FRM_DATE, 103)) OR (ISNULL(A.KT_APPROVE_DT,'') <> '' AND A.KT_APPROVE_DT >= CONVERT(DATE, @p_FRM_DATE, 103))
			--AND (ISNULL(A.KT_CREATE_DT,'') <> '' AND A.KT_CREATE_DT <= CONVERT(DATE, @p_TO_DATE, 103)) OR (ISNULL(A.KT_APPROVE_DT,'') <> '' AND A.KT_APPROVE_DT <= CONVERT(DATE, @p_TO_DATE, 103))
			AND A.KT_MAKER_ID IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
			AND (ISNULL(A.KT_MAKER_ID, '') = @p_MAKER_ID OR @p_MAKER_ID = '' OR @p_MAKER_ID IS NULL)
			AND (	(@p_ROLE = 'GDV' AND A.KT_AUTH_STATUS IN('A', 'U') AND ISNULL(A.KT_CREATE_DT, '') <> '') 
					OR (@p_ROLE = 'KSV' AND A.KT_AUTH_STATUS IN ('A')) 
					OR (ISNULL(@p_ROLE, '') = '' AND A.KT_AUTH_STATUS IN('A', 'U') AND ISNULL(A.KT_CREATE_DT, '') <> '') 
				)
			UNION
			SELECT A.LIQ_CODE AS MA_SO_PHIEU, A.CORE_NOTE AS NOI_DUNG, 
			CONVERT(VARCHAR,MONTH(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.APPROVE_DT),2) AS NGAY_NHAN_PHIEU, 
			A.KT_MAKER_ID AS GDV, 
			CONVERT(VARCHAR,MONTH(A.KT_CREATE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.KT_CREATE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.KT_CREATE_DT),2) AS NGAY_GDV_GUI_DUYET, 
			A.KT_CHECKER_ID AS KSV, 
			CONVERT(VARCHAR,MONTH(A.KT_APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.KT_APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.KT_APPROVE_DT),2) AS NGAY_KSV_DUYET 
			FROM MW_LIQ_MASTER A
			WHERE 1=1 
			AND A.AUTH_STATUS ='A'
			AND (	((A.KT_CREATE_DT >=@p_FROM_DT OR ISNULL(@p_FROM_DT, '') = '')  AND A.KT_CREATE_DT <=@p_TO_DT)
					OR ((A.KT_APPROVE_DT >=@p_FROM_DT OR ISNULL(@p_FROM_DT, '') = '') AND A.KT_APPROVE_DT <=@p_TO_DT)
				)
			--AND (ISNULL(A.KT_CREATE_DT,'') <> '' AND A.KT_CREATE_DT >= CONVERT(DATE, @p_FRM_DATE, 103)) OR (ISNULL(A.KT_APPROVE_DT,'') <> '' AND A.KT_APPROVE_DT >= CONVERT(DATE, @p_FRM_DATE, 103))
			--AND (ISNULL(A.KT_CREATE_DT,'') <> '' AND A.KT_CREATE_DT <= CONVERT(DATE, @p_TO_DATE, 103)) OR (ISNULL(A.KT_APPROVE_DT,'') <> '' AND A.KT_APPROVE_DT <= CONVERT(DATE, @p_TO_DATE, 103))
			AND A.KT_MAKER_ID IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
			AND (ISNULL(A.KT_MAKER_ID, '') = @p_MAKER_ID OR @p_MAKER_ID = '' OR @p_MAKER_ID IS NULL)
			AND (	(@p_ROLE = 'GDV' AND A.KT_AUTH_STATUS IN('A', 'U') AND ISNULL(A.KT_CREATE_DT, '') <> '') 
					OR (@p_ROLE = 'KSV' AND A.KT_AUTH_STATUS IN ('A')) 
					OR (ISNULL(@p_ROLE, '') = '' AND A.KT_AUTH_STATUS IN('A', 'U') AND ISNULL(A.KT_CREATE_DT, '') <> '') 
				)
		END
		ELSE IF (@p_TYPE_REPORT='PAY')
		BEGIN
			SELECT H.* 
			FROM 
			(
				SELECT B.REQ_PAY_CODE AS MA_SO_PHIEU,A.REQ_REASON AS NOI_DUNG, B.REQ_AMT AS SO_TIEN_THANH_TOAN_TAM_UNG,
				CONVERT(VARCHAR,MONTH(A.TRANSFER_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.TRANSFER_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.TRANSFER_DT),2)  AS NGAY_NHAN_PHIEU,
				A.MAKER_ID_KT AS GDV,
				CONVERT(VARCHAR,MONTH(A.CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(A.CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(A.CREATE_DT_KT),2) AS NGAY_GDV_GUI_DUYET,
				A.CHECKER_ID_KT AS KSV, 
				CONVERT(VARCHAR,MONTH(A.APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(A.APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(A.APPROVE_DT_KT),2) AS NGAY_KSV_DUYET, 
				A.AUTH_STATUS_KT,
				CASE	WHEN A.AUTH_STATUS_KT = 'U' THEN N'KSV điều phối'
						WHEN A.AUTH_STATUS_KT = 'P' THEN N'GDV gửi duyệt'
						WHEN A.AUTH_STATUS_KT = 'S' THEN N'GDV đề xuất từ chối phiếu'
						WHEN A.AUTH_STATUS_KT = 'R' THEN N'KSV từ chối phiếu'
						WHEN A.AUTH_STATUS_KT = 'A' THEN N'KSV duyệt phiếu'
				END AS TRANG_THAI_PHIEU,
				A.ID
				FROM TR_REQ_KPI A
				JOIN TR_REQ_PAYMENT B ON A.REQ_ID = B.REQ_PAY_ID
				WHERE 1=1
				-- Ngày tính KPI
				AND(CONVERT(DATE, A.TRANSFER_DT) >= CONVERT(DATE, @p_FRM_DATE, 103) OR ISNULL(@p_FRM_DATE, '') = '')
				AND(CONVERT(DATE, A.TRANSFER_DT) <= CONVERT(DATE, @p_TO_DATE, 103) OR ISNULL(@p_TO_DATE, '') = '')
				-- Người xử lý
				AND (A.MAKER_ID_KT = @p_MAKER_ID OR @p_MAKER_ID = '' OR @p_MAKER_ID IS NULL)

				UNION

				SELECT B.REQ_PAY_CODE AS MA_SO_PHIEU,A.REQ_REASON AS NOI_DUNG, B.REQ_AMT AS SO_TIEN_THANH_TOAN_TAM_UNG, 
				CONVERT(VARCHAR,MONTH(A.TRANSFER_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.TRANSFER_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.TRANSFER_DT),2)  AS NGAY_NHAN_PHIEU,
				A.MAKER_ID_KT AS GDV,
				CONVERT(VARCHAR,MONTH(A.CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(A.CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(A.CREATE_DT_KT),2) AS NGAY_GDV_GUI_DUYET,
				A.CHECKER_ID_KT AS KSV, 
				CONVERT(VARCHAR,MONTH(A.APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(A.APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(A.APPROVE_DT_KT),2) AS NGAY_KSV_DUYET, 
				A.AUTH_STATUS_KT ,
				CASE	WHEN A.AUTH_STATUS_KT = 'U' THEN N'KSV điều phối'
						WHEN A.AUTH_STATUS_KT = 'P' THEN N'GDV gửi duyệt'
						WHEN A.AUTH_STATUS_KT = 'S' THEN N'GDV đề xuất từ chối phiếu'
						WHEN A.AUTH_STATUS_KT = 'R' THEN N'KSV từ chối phiếu'
						WHEN A.AUTH_STATUS_KT = 'A' THEN N'KSV duyệt phiếu'
				END AS TRANG_THAI_PHIEU,
				A.ID
				FROM TR_REQ_KPI A
				JOIN TR_REQ_ADVANCE_PAYMENT B ON A.REQ_ID = B.REQ_PAY_ID
				WHERE 1=1
				-- Ngày tính KPI
				AND(CONVERT(DATE, A.TRANSFER_DT) >= CONVERT(DATE, @p_FRM_DATE, 103) OR ISNULL(@p_FRM_DATE, '') = '')
				AND(CONVERT(DATE, A.TRANSFER_DT) <= CONVERT(DATE, @p_TO_DATE, 103) OR ISNULL(@p_TO_DATE, '') = '')
				-- Người xử lý
				AND (A.MAKER_ID_KT = @p_MAKER_ID OR @p_MAKER_ID = '' OR @p_MAKER_ID IS NULL)
			) H
			ORDER BY H.MA_SO_PHIEU
		END
	END
	
END

GO
--25072023_secretkey