ALTER PROCEDURE dbo.TR_ROLE_NOTIFI_ID
@PO_ID	varchar(500),
@TYPE VARCHAR(100),
@p_TLNAME VARCHAR(100)
AS
	DECLARE 
		@BRANCH_CREATE VARCHAR(15),
		@DEP_CREATE VARCHAR(15),
		@BRANCH_TYPE VARCHAR(15),
		@FATHER_ID VARCHAR(15),
		@FLAG VARCHAR(2), -- FLAG = 1: THANH TOÁN / TẠM ỨNG
		@AUTH_STATUS VARCHAR(10),
		@PROCESS VARCHAR(10),
		@MAKER_ID VARCHAR(100),
		@DEP_CODE VARCHAR(15),
		@NV_XL_MS VARCHAR(15),
		@BRANCH_QLTS VARCHAR(15) = 'DV0001',
		@DEP_KT VARCHAR(15) = 'DEP000000000068',--(SELECT TOP 1 sp.ParaValue FROM SYS_PARAMETERS sp WHERE sp.ParaKey = 'DEP_QLTS')
		@TLFullName_USER_CREATE NVARCHAR(500) = NULL,
		@Email_USER_CREATE VARCHAR(500) = NULL,
		@USER_CREATE_ID INT ,
		@BRANCH_LOGIN VARCHAR(15) = (SELECT TOP 1 TLSUBBRID FROM TL_USER WHERE TLNANME = @p_TLNAME), 
		@DEP_LOGIN VARCHAR(15) = (SELECT TOP 1 DEP_ID FROM TL_USER WHERE TLNANME = @p_TLNAME)
	DECLARE @ROLE_CURRENT VARCHAR(15), @USER_RECIVE_MAIL VARCHAR(15), @REQ_TYPE VARCHAR(15)
	DECLARE @SYS_PREFIX VARCHAR(15),@PAGE NVARCHAR(200)
	DECLARE @l_LST_REQ_ID TABLE (
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[REQ_PAY_ID] [VARCHAR](50) NULL)
	INSERT INTO @l_LST_REQ_ID SELECT VALUE FROM WSISPLIT(@PO_ID,',')
	DECLARE @LST_POID TABLE(ID VARCHAR(15))
	DECLARE @LST_USER_RECIVE TABLE (TLNAME VARCHAR(100))
	DECLARE @LST_USER_RECIVE_PYC TABLE (TLFullName NVARCHAR(500), Email VARCHAR(500), USER_ID INT)
	--- DECLARE TABLE NHAN DU LIEU LA USER NAME DANG O BUOC PHE DUYET HIEN TAI
	DECLARE @PL_PROCESS_CURRENT_SEARCH_TEMP TABLE
	(
	REQ_ID varchar(15),
	PROCESS_ID varchar(10),
	DVDM_NAME nvarchar(500),
	TLNAME nvarchar(255),
	TLFullName nvarchar(255),
	NOTES nvarchar(500)
	)
	-----BAODNQ 5/1/2021 : Thêm gửi mail cho GDDV, TP, PP----------
	DECLARE @p_MAKER_ID VARCHAR(100), @p_ROLE_ID VARCHAR(15), @p_ROLE_NAME VARCHAR(15) 
	DECLARE @LST_ROLE TABLE(ROLE_ID VARCHAR(15), ROLE_NAME VARCHAR(15))
	--------------------------
	IF @TYPE = 'PO'
	BEGIN
		INSERT INTO @LST_POID VALUES(@PO_ID)
		SET @FLAG = 0
	END ELSE
	IF @TYPE = 'USE'
	BEGIN
		INSERT INTO @LST_POID SELECT B.PO_ID 
		FROM ASS_MASTER_PO B WHERE B.ASSET_ID = (SELECT A.ASSET_ID FROM ASS_USE A WHERE A.USE_ID = @PO_ID)
		SET @FLAG = 0
	END ELSE
	IF @TYPE = 'USE_MUILT'
	BEGIN
	    SELECT @BRANCH_CREATE = BRANCH_ID FROM ASS_USE_MULTI_MASTER where USER_MASTER_ID = @PO_ID
		INSERT INTO @LST_USER_RECIVE SELECT TLNANME
		FROM TL_USER 
		WHERE 1=1
				AND TLSUBBRID = @BRANCH_CREATE
				AND EXISTS(SELECT * FROM [dbo].[TL_USER_GET_ROLES](TLNANME) WHERE ROLE_ID IN ('GDDV'))
		SET @FLAG = 9
	END ELSE
	IF @TYPE = 'USE_ADDNEW'
	BEGIN
		INSERT INTO @LST_POID SELECT B.PO_ID 
		FROM ASS_ADDNEW_PO B WHERE B.ADDNEW_ID = @PO_ID
		SET @FLAG = 0
	END 	
	-- Tạm ứng 
	ELSE IF (@TYPE = 'TR_REQ_ADVANCE_PAYMENT_SEND_APR')
	BEGIN
		SET @AUTH_STATUS =( SELECT TOP 1 AUTH_STATUS FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_ID =  @PO_ID)
		IF(EXISTS(SELECT * FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_ID =@PO_ID AND (TRASFER_USER_RECIVE IS NOT NULL AND TRASFER_USER_RECIVE <>'')))
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME) 
				(SELECT TRASFER_USER_RECIVE FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID = @PO_ID)
			END
			ELSE
			BEGIN
				SET @AUTH_STATUS =( SELECT TOP 1 AUTH_STATUS FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_ID =  @PO_ID)
				SET @BRANCH_CREATE = (SELECT BRANCH_CREATE FROM TR_REQ_ADVANCE_PAYMENT  WHERE REQ_PAY_ID =  @PO_ID)
				SET @DEP_CREATE = (SELECT DEP_ID FROM TR_REQ_ADVANCE_PAYMENT  WHERE REQ_PAY_ID =  @PO_ID)
				SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
				SET @FATHER_ID = (SELECT FATHER_ID FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
				IF(@BRANCH_TYPE = 'PGD' )
				BEGIN
					INSERT INTO @LST_USER_RECIVE (TLNAME) 
					SELECT TLNANME FROM TL_USER 
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND (RoleName IN ('TPGD','PP') OR RoleName IN (SELECT ROLE_OLD FROM TL_SYS_ROLE_MAPPING WHERE ROLE_NEW IN ('TPGD','PP')))
				
				END
				ELSE IF(@BRANCH_TYPE = 'CN' )
				BEGIN
					INSERT INTO @LST_USER_RECIVE (TLNAME) 
					SELECT TLNANME FROM TL_USER 
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE 
					AND (RoleName IN ('GDDV','PGD') OR RoleName IN (SELECT ROLE_OLD FROM TL_SYS_ROLE_MAPPING WHERE ROLE_NEW IN ('GDDV','PGD')))
				END
				ELSE IF(@BRANCH_TYPE = 'HS' )
				BEGIN
						INSERT INTO @LST_USER_RECIVE (TLNAME) 
						SELECT TLNANME FROM TL_USER
						WHERE 1=1
						AND TLSUBBRID = @BRANCH_CREATE
						AND SECUR_CODE = @DEP_CREATE
						AND (RoleName IN ('GDDV','PP') OR RoleName IN (SELECT ROLE_OLD FROM TL_SYS_ROLE_MAPPING WHERE ROLE_NEW IN ('GDDV','PP')))
				END
			END
	SET @FLAG = 1
	END 
	ELSE IF (@TYPE = 'TR_REQ_ADVANCE_PAYMENT_CONFIRM')
	BEGIN
		SET @AUTH_STATUS =( SELECT TOP 1 AUTH_STATUS FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_ID =  @PO_ID)
		SET @BRANCH_CREATE = (SELECT BRANCH_CREATE FROM TR_REQ_ADVANCE_PAYMENT  WHERE REQ_PAY_ID =  @PO_ID)
		SET @DEP_CREATE = (SELECT DEP_ID FROM TR_REQ_ADVANCE_PAYMENT  WHERE REQ_PAY_ID =  @PO_ID)
		SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
		SET @FATHER_ID = (SELECT FATHER_ID FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
		SET @REQ_TYPE =(SELECT TOP 1 REQ_TYPE FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_ID=@PO_ID)
		SET @DEP_CODE =(SELECT TOP 1 DEP_CODE FROM CM_DEPARTMENT WHERE DEP_ID =@DEP_CREATE)
		IF(@BRANCH_TYPE = 'PGD' )
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME) 
			SELECT TLNANME FROM TL_USER 
			WHERE 1=1
			AND TLSUBBRID = @FATHER_ID
			AND (RoleName IN ('TPGD','PP') OR RoleName IN (SELECT ROLE_OLD FROM TL_SYS_ROLE_MAPPING WHERE ROLE_NEW IN ('TPGD','PP')))
			
		END
		ELSE IF(@BRANCH_TYPE = 'CN' )
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME) 
			SELECT TLNANME FROM TL_USER 
			WHERE 1=1
			AND TLSUBBRID = @BRANCH_CREATE 
			AND (RoleName IN ('GDDV','PGD') OR RoleName IN (SELECT ROLE_OLD FROM TL_SYS_ROLE_MAPPING WHERE ROLE_NEW IN ('GDDV','PGD')))
		END
		ELSE IF(@BRANCH_TYPE = 'HS' )
		BEGIN
			IF(EXISTS(SELECT PROCESS FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_ID =@PO_ID AND (PROCESS ='' OR PROCESS IS NULL)))
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME) 
				SELECT TLNANME FROM TL_USER
				WHERE 1=1
				AND TLSUBBRID = @BRANCH_CREATE
				AND SECUR_CODE = @DEP_CREATE
				AND (RoleName IN ('GDDV','PP') OR RoleName IN (SELECT ROLE_OLD FROM TL_SYS_ROLE_MAPPING WHERE ROLE_NEW IN ('GDDV','PP')))
			END
			ELSE
			BEGIN
				
				IF(EXISTS(SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID=@PO_ID AND STATUS ='C' AND ROLE_USER ='GDK' AND @REQ_TYPE ='I'))
				BEGIN
					IF(@DEP_CREATE ='DEP000000000014' OR (@DEP_CODE LIKE'%06906%' AND @DEP_CODE <> '0690605'))
					BEGIN
						SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE RoleName ='GDK' AND TLNANME ='tunt')
						INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
					END
					ELSE IF((@DEP_CODE LIKE'%06909%'))
					BEGIN
						SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE RoleName ='GDK' AND TLNANME ='haipv')
						INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
					END
					ELSE IF((@DEP_CODE LIKE'%06921%'))
					BEGIN
						SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE RoleName ='GDK' AND TLNANME ='cuongpv2')
						INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
					END
					ELSE IF((@DEP_CODE LIKE'%06907%'))
					BEGIN
						SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE RoleName ='GDK' AND TLNANME ='linhvtk')
						INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
					END
					ELSE IF((@DEP_CODE LIKE'%06908%'))
					BEGIN
						SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE RoleName ='GDK' AND TLNANME ='nhalc')
						INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
					END
				END
				-- NEU CAP TIEP THEO LA PTGD
				ELSE IF(EXISTS(SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID=@PO_ID AND STATUS ='C' AND ROLE_USER ='PTGD' AND @REQ_TYPE ='I'))
				BEGIN
					IF(@DEP_CREATE ='DEP000000000014' OR (@DEP_CODE LIKE'%06906%' AND @DEP_CODE <> '0690605'))
					BEGIN
						SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE RoleName ='PTGD' AND TLNANME ='hantt')
						INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
					END
					ELSE IF(@DEP_CODE ='0690405')
					BEGIN
						SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE RoleName ='PTGD' AND TLNANME ='tupa')
						INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
					END
				END
			END
		END
		SET @FLAG = 1
	END 
	ELSE IF (@TYPE = 'TR_REQ_ADVANCE_PAYMENT_APR')
	BEGIN
		 SET @REQ_TYPE =(SELECT TOP 1 REQ_TYPE FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_ID=@PO_ID)
		--SET @AUTH_STATUS =( SELECT TOP 1 AUTH_STATUS FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_ID =  @PO_ID)
		 SET @BRANCH_CREATE = (SELECT TOP 1 BRANCH_CREATE FROM TR_REQ_ADVANCE_PAYMENT  WHERE REQ_PAY_ID =  @PO_ID)
		 SET @DEP_CREATE = (SELECT TOP 1 DEP_ID FROM TR_REQ_ADVANCE_PAYMENT  WHERE REQ_PAY_ID =  @PO_ID)
		 SET @DEP_CODE =(SELECT TOP 1 DEP_CODE FROM CM_DEPARTMENT WHERE DEP_ID =@DEP_CREATE)
		IF(EXISTS(SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID=@PO_ID AND STATUS ='C' AND ROLE_USER ='TKTGD' AND @REQ_TYPE ='I'))
		BEGIN
			INSERT INTO @LST_USER_RECIVE SELECT TLNANME FROM TL_USER WHERE RoleName ='TKTGD'
		END
		IF(EXISTS(SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID=@PO_ID AND STATUS ='C' AND ROLE_USER ='TKHDQT' AND @REQ_TYPE ='I'))
		BEGIN
			INSERT INTO @LST_USER_RECIVE SELECT TLNANME FROM TL_USER WHERE RoleName ='TKHDQT'
		END
		IF(EXISTS(SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID=@PO_ID AND STATUS ='C' AND ROLE_USER ='TGD' AND @REQ_TYPE ='I'))
		BEGIN
			--SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE RoleName ='TGD')
			--INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
			INSERT INTO @LST_USER_RECIVE SELECT TLNANME FROM TL_USER WHERE RoleName ='TGD'
		END
		IF(EXISTS(SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID=@PO_ID AND STATUS ='C' AND ROLE_USER ='HDQT' AND @REQ_TYPE ='I'))
		BEGIN
			--SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE RoleName ='TGD')
			--INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
			INSERT INTO @LST_USER_RECIVE SELECT TLNANME FROM TL_USER WHERE RoleName ='HDQT'
		END
		IF(EXISTS(SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID=@PO_ID AND STATUS ='C' AND ROLE_USER ='GDK' AND @REQ_TYPE ='I'))
		BEGIN
			IF(@DEP_CREATE ='DEP000000000014' OR (@DEP_CODE LIKE'%06906%' AND @DEP_CODE <> '0690605'))
			BEGIN
				SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE RoleName ='GDK' AND TLNANME ='tunt')
				INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
			END
			ELSE IF((@DEP_CODE LIKE'%06909%'))
			BEGIN
				SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE RoleName ='GDK' AND TLNANME ='haipv')
				INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
			END
			ELSE IF((@DEP_CODE LIKE'%06921%'))
			BEGIN
				SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE RoleName ='GDK' AND TLNANME ='cuongpv2')
				INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
			END
			ELSE IF((@DEP_CODE LIKE'%06907%'))
			BEGIN
				SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE RoleName ='GDK' AND TLNANME ='linhvtk')
				INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
			END
			ELSE IF(@DEP_CODE LIKE'%06908%')
			BEGIN
				SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE RoleName ='GDK' AND TLNANME ='nhalc')
				INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
			END
		END
		IF(EXISTS(SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID=@PO_ID AND STATUS ='C' AND ROLE_USER ='PTGD' AND @REQ_TYPE ='I'))
		BEGIN
			IF(@DEP_CREATE ='DEP000000000014' OR (@DEP_CODE LIKE'%06906%' AND @DEP_CODE <> '0690605'))
			BEGIN
				SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE RoleName ='PTGD' AND TLNANME ='hantt')
				INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
			END
			ELSE IF( @DEP_CODE ='0690405')
			BEGIN
				SET @USER_RECIVE_MAIL =(SELECT TOP 1 TLNANME FROM TL_USER WHERE RoleName ='PTGD' AND TLNANME ='tupa')
				INSERT INTO @LST_USER_RECIVE (TLNAME)  VALUES (@USER_RECIVE_MAIL)
			END
		END
		IF(EXISTS(SELECT * FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_ID =@PO_ID AND AUTH_STATUS ='A'))
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME) 
			SELECT TOP 1 MAKER_ID FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_ID = @PO_ID 
			--INSERT INTO @LST_USER_RECIVE (TLNAME) 
			--SELECT TOP 1 MAKER_ID_KT FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID = @PO_ID 
		END
		SET @FLAG = 1
	END
	-- Điều phối tạm ứng/ thanh toán PL_REQUEST_PROCESS_CHILD
	ELSE IF (@TYPE = 'TR_REQ_PAYMENT_TRANSFER')
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME) 
		SELECT TLNAME FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID IN (SELECT REQ_PAY_ID FROM @l_LST_REQ_ID) AND TYPE_JOB = 'XL' AND STATUS_JOB ='C'
		SET @FLAG = 1
	END
	-- 
	ELSE IF (@TYPE = 'TR_REQ_ADVANCE_PAYMENT_KT_SEND_APR')
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME) 
		SELECT TOP 1 TLNAME FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID = @PO_ID AND TYPE_JOB = 'KS'
		SET @FLAG = 1
	END
	ELSE IF (@TYPE = 'TR_REQ_ADVANCE_PAYMENT_KT_APPR')
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME) 
		SELECT TOP 1 MAKER_ID FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_ID = @PO_ID 
		INSERT INTO @LST_USER_RECIVE (TLNAME) 
		SELECT TOP 1 MAKER_ID_KT FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_ID = @PO_ID 
		SET @FLAG = 1
	END
	-- Thanh toán
	ELSE IF (@TYPE = 'TR_REQ_PAYMENT_SEND_APR')
	BEGIN
		SET @AUTH_STATUS =( SELECT TOP 1 AUTH_STATUS FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID =  @PO_ID)
			IF(EXISTS(SELECT * FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID =@PO_ID AND (TRASFER_USER_RECIVE IS NOT NULL AND TRASFER_USER_RECIVE <>'')))
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME) 
				(SELECT TRASFER_USER_RECIVE FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID = @PO_ID)
			END
			ELSE
			BEGIN
				SET @AUTH_STATUS =( SELECT TOP 1 AUTH_STATUS FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID =  @PO_ID)
				SET @BRANCH_CREATE = (SELECT BRANCH_CREATE FROM TR_REQ_PAYMENT  WHERE REQ_PAY_ID =  @PO_ID)
				SET @DEP_CREATE = (SELECT DEP_ID FROM TR_REQ_PAYMENT  WHERE REQ_PAY_ID =  @PO_ID)
				SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
				SET @FATHER_ID = (SELECT FATHER_ID FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
				IF(@BRANCH_TYPE = 'PGD' )
				BEGIN
					INSERT INTO @LST_USER_RECIVE (TLNAME) 
					SELECT TLNANME FROM TL_USER 
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND (RoleName IN ('TPGD','PP') OR RoleName IN (SELECT ROLE_OLD FROM TL_SYS_ROLE_MAPPING WHERE ROLE_NEW IN ('TPGD','PP')))
				END
				ELSE IF(@BRANCH_TYPE = 'CN' )
				BEGIN
					INSERT INTO @LST_USER_RECIVE (TLNAME) 
					SELECT TLNANME FROM TL_USER 
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE 
					AND (RoleName IN ('GDDV','PGD') OR RoleName IN (SELECT ROLE_OLD FROM TL_SYS_ROLE_MAPPING WHERE ROLE_NEW IN ('GDDV','PGD')))
				END
				ELSE IF(@BRANCH_TYPE = 'HS' )
				BEGIN
					INSERT INTO @LST_USER_RECIVE (TLNAME) 
					SELECT TLNANME FROM TL_USER
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND SECUR_CODE = @DEP_CREATE
					AND (RoleName IN ('GDDV','PP') OR RoleName IN (SELECT ROLE_OLD FROM TL_SYS_ROLE_MAPPING WHERE ROLE_NEW IN ('GDDV','PP')))
				END
			END
			SET @FLAG = 1
	END 
	ELSE IF(@TYPE = 'TR_REQ_PAYMENT_APR')
	BEGIN
		SET @AUTH_STATUS =( SELECT TOP 1 AUTH_STATUS FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID =  @PO_ID)
		IF(@AUTH_STATUS  = 'A')
		BEGIN
			SET @AUTH_STATUS =( SELECT TOP 1 AUTH_STATUS FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID =  @PO_ID)
			SET @BRANCH_CREATE = (SELECT BRANCH_CREATE FROM TR_REQ_PAYMENT  WHERE REQ_PAY_ID =  @PO_ID)
			SET @DEP_CREATE = (SELECT DEP_ID FROM TR_REQ_PAYMENT  WHERE REQ_PAY_ID =  @PO_ID)
			SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
			SET @FATHER_ID = (SELECT FATHER_ID FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
			INSERT INTO @LST_USER_RECIVE (TLNAME) 
			SELECT TLNANME FROM TL_USER 
			WHERE 1=1
			--AND TLSUBBRID = @BRANCH_CREATE 
			AND (RoleName = 'KSV' OR RoleName IN (SELECT ROLE_OLD FROM TL_SYS_ROLE_MAPPING WHERE ROLE_NEW = 'KSV'))
			AND TLSUBBRID = 'DV0001' AND SECUR_CODE ='DEP000000000022'
			SET @FLAG = 1
		END
	END
	ELSE IF(@TYPE = 'TR_REQ_PAYMENT_CONFIRM')
	BEGIN
		SET @AUTH_STATUS =( SELECT TOP 1 AUTH_STATUS FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID =  @PO_ID)
		SET @PROCESS = ( SELECT TOP 1 PROCESS FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID =  @PO_ID)
		IF(@AUTH_STATUS  = 'U' AND @PROCESS = '0')
		BEGIN
			SET @AUTH_STATUS =( SELECT TOP 1 AUTH_STATUS FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID =  @PO_ID)
			SET @BRANCH_CREATE = (SELECT BRANCH_CREATE FROM TR_REQ_PAYMENT  WHERE REQ_PAY_ID =  @PO_ID)
			SET @DEP_CREATE = (SELECT DEP_ID FROM TR_REQ_PAYMENT  WHERE REQ_PAY_ID =  @PO_ID)
			SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
			SET @FATHER_ID = (SELECT FATHER_ID FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
			IF(@BRANCH_TYPE = 'PGD' )
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME) 
				SELECT TLNANME FROM TL_USER 
				WHERE 1=1
				AND TLSUBBRID = @FATHER_ID
				AND (RoleName IN ('TPGD','PP') OR RoleName IN (SELECT ROLE_OLD FROM TL_SYS_ROLE_MAPPING WHERE ROLE_NEW IN ('TPGD','PP')))
				
			END
			ELSE IF(@BRANCH_TYPE = 'CN' )
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME) 
				SELECT TLNANME FROM TL_USER 
				WHERE 1=1
				AND TLSUBBRID = @BRANCH_CREATE 
				AND (RoleName IN ('GDDV','PGD') OR RoleName IN (SELECT ROLE_OLD FROM TL_SYS_ROLE_MAPPING WHERE ROLE_NEW IN ('GDDV','PGD')))
			END
			ELSE IF(@BRANCH_TYPE = 'HS' )
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME) 
				SELECT TLNANME FROM TL_USER
				WHERE 1=1
				AND TLSUBBRID = @BRANCH_CREATE
				AND SECUR_CODE = @DEP_CREATE
				AND (RoleName IN ('GDDV','PP') OR RoleName IN (SELECT ROLE_OLD FROM TL_SYS_ROLE_MAPPING WHERE ROLE_NEW IN ('GDDV','PP')))
			END
			SET @FLAG = 1
		END
	END
	ELSE IF(@TYPE = 'TR_REQ_PAYMENT_KT_SEND_APR')
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME) 
		SELECT TOP 1 TLNAME FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID = @PO_ID AND TYPE_JOB = 'KS'
		SET @FLAG = 1
	END
	ELSE IF(@TYPE = 'TR_REQ_PAYMENT_KT_APR')
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME) 
		SELECT TOP 1 MAKER_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID = @PO_ID 
		INSERT INTO @LST_USER_RECIVE (TLNAME) 
		SELECT TOP 1 MAKER_ID_KT FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID = @PO_ID 
		SET @FLAG = 1
	END
	-- Tờ trình chủ trương
	ELSE IF(@TYPE = 'PL_SEND_APP' OR @TYPE ='PL_REQUEST_DOC_App'  OR @TYPE ='REQ_PROCESS_CHILD_Upd' OR @TYPE='REQ_PROCESS_CHILD_App')
	BEGIN
		SET @MAKER_ID = (SELECT TOP 1 MAKER_ID FROM PL_REQUEST_DOC WHERE REQ_ID =@PO_ID)
		INSERT INTO @PL_PROCESS_CURRENT_SEARCH_TEMP
		EXEC [dbo].[PL_PROCESS_CURRENT_SEARCH] @PO_ID,@MAKER_ID,'TTCT-DVKD'
		SET @FLAG = 2
	END
	ELSE IF(@TYPE='PL_REQ_PROCESS_CHILD_Ins')
	BEGIN
		DECLARE @PLREQ_ID VARCHAR(15)
		WHILE((SELECT COUNT(*) FROM @l_LST_REQ_ID) >0)
		BEGIN
			SET @PLREQ_ID =(SELECT TOP 1 REQ_PAY_ID FROM @l_LST_REQ_ID)
			SET @MAKER_ID = (SELECT TOP 1 MAKER_ID FROM PL_REQUEST_DOC WHERE REQ_ID =@PO_ID)
			INSERT INTO @PL_PROCESS_CURRENT_SEARCH_TEMP
			EXEC [dbo].[PL_PROCESS_CURRENT_SEARCH] @PLREQ_ID,@MAKER_ID,'TTCT-DVKD'
			DELETE FROM @l_LST_REQ_ID WHERE REQ_PAY_ID =@PLREQ_ID
		END
		SET @FLAG = 2
	END
	ELSE IF(@TYPE='REQUEST_DOC_PROCESS_Approve')
	BEGIN
		IF(NOT EXISTS(SELECT * FROM PL_REQUEST_DOC WHERE REQ_ID =@PO_ID AND PROCESS_ID ='APPROVE'))
		BEGIN
			IF(NOT EXISTS(SELECT * FROM PL_REQUEST_DOC WHERE REQ_ID =@PO_ID AND PROCESS_ID ='TGD'))
			BEGIN
				SET @FLAG = 2
				--SET @MAKER_ID = (SELECT TOP 1 MAKER_ID FROM PL_REQUEST_DOC WHERE REQ_ID =@PO_ID)
				INSERT INTO @PL_PROCESS_CURRENT_SEARCH_TEMP
				EXEC [dbo].[PL_PROCESS_CURRENT_SEARCH] @PO_ID,@MAKER_ID,'TTCT-DVKD'
			END
			ELSE IF (EXISTS(SELECT * FROM PL_REQUEST_DOC WHERE REQ_ID =@PO_ID AND PROCESS_ID ='TGD'))
			BEGIN
				SET @FLAG = 2
				--SET @MAKER_ID = (SELECT TOP 1 MAKER_ID FROM PL_REQUEST_DOC WHERE REQ_ID =@PO_ID)
				INSERT INTO @PL_PROCESS_CURRENT_SEARCH_TEMP
				EXEC [dbo].[PL_PROCESS_CURRENT_SEARCH] @PO_ID,@MAKER_ID,'TTCT-DVKD'
				INSERT INTO @PL_PROCESS_CURRENT_SEARCH_TEMP (REQ_ID,TLNAME) SELECT @PO_ID, TLNANME FROM TL_USER WHERE RoleName ='TKTGD'
			END
			ELSE IF (EXISTS(SELECT * FROM PL_REQUEST_DOC WHERE REQ_ID =@PO_ID AND PROCESS_ID ='HDQT'))
			BEGIN
				SET @FLAG = 2
				--SET @MAKER_ID = (SELECT TOP 1 MAKER_ID FROM PL_REQUEST_DOC WHERE REQ_ID =@PO_ID)
				INSERT INTO @PL_PROCESS_CURRENT_SEARCH_TEMP
				EXEC [dbo].[PL_PROCESS_CURRENT_SEARCH] @PO_ID,@MAKER_ID,'TTCT-DVKD'
				--INSERT INTO @PL_PROCESS_CURRENT_SEARCH_TEMP (REQ_ID,TLNAME) SELECT @PO_ID, TLNANME FROM TL_USER WHERE RoleName ='TKTGD'
			END
		END
		ELSE
		BEGIN
			SET @FLAG = 3
			SET @MAKER_ID = (SELECT TOP 1 MAKER_ID FROM PL_REQUEST_DOC WHERE REQ_ID =@PO_ID)
			--INSERT INTO @PL_PROCESS_CURRENT_SEARCH_TEMP
			--EXEC [dbo].[PL_PROCESS_CURRENT_SEARCH] @REQ_ID,@MAKER_ID,'TTCT-DVKD'
		END
	END
	-------------------------------------------------------------------------------------------------------
	----- PHIẾU YÊU CẦU MUA SẮM --------------
	ELSE IF(@TYPE = 'TR_REQUEST_DOC_SendApp' OR @TYPE ='TR_REQUEST_DOC_App' OR @TYPE ='TR_REQ_PROCESS_CHILD_App' OR @TYPE ='TR_REQ_PROCESS_CHILD_Upd' OR @TYPE='REQ_PROCESS_CHILD_App')
	BEGIN
		SET @MAKER_ID = (SELECT TOP 1 MAKER_ID FROM TR_REQUEST_DOC WHERE REQ_ID =@PO_ID)
		INSERT INTO @PL_PROCESS_CURRENT_SEARCH_TEMP
		EXEC [dbo].[PL_PROCESS_CURRENT_SEARCH] @PO_ID,@MAKER_ID,'PYCMS-DVKD'
		SET @FLAG = 2
	END
	ELSE IF(@TYPE='TR_REQ_PROCESS_CHILD_Ins')
	BEGIN
		
		DECLARE @REQ_DOC_ID VARCHAR(15)
		WHILE((SELECT COUNT(*) FROM @l_LST_REQ_ID) >0)
		BEGIN
			SET @REQ_DOC_ID =(SELECT TOP 1 REQ_PAY_ID FROM @l_LST_REQ_ID)
			SET @MAKER_ID = (SELECT TOP 1 MAKER_ID FROM TR_REQUEST_DOC WHERE REQ_ID =@PO_ID)
			INSERT INTO @PL_PROCESS_CURRENT_SEARCH_TEMP
			EXEC [dbo].[PL_PROCESS_CURRENT_SEARCH] @REQ_DOC_ID,@MAKER_ID,'PYCMS-DVKD'
			DELETE FROM @l_LST_REQ_ID WHERE REQ_PAY_ID =@REQ_DOC_ID
		END
		SET @FLAG = 2
	END
	ELSE IF(@TYPE='TR_REQUEST_DOC_PROCESS_Approve')
	BEGIN
		IF(NOT EXISTS(SELECT * FROM TR_REQUEST_DOC WHERE REQ_ID =@PO_ID AND PROCESS_ID ='APPROVE'))
		BEGIN
			--SET @MAKER_ID = (SELECT TOP 1 MAKER_ID FROM TR_REQUEST_DOC WHERE REQ_ID =@PO_ID)
			INSERT INTO @PL_PROCESS_CURRENT_SEARCH_TEMP
			EXEC [dbo].[PL_PROCESS_CURRENT_SEARCH] @PO_ID,@MAKER_ID,'PYCMS-DVKD'
			SET @FLAG = 3
		END
		ELSE
		BEGIN
			SET @MAKER_ID = (SELECT TOP 1 MAKER_ID FROM TR_REQUEST_DOC WHERE REQ_ID =@PO_ID)
			SET @NV_XL_MS =(SELECT TOP 1 USER_DVMS FROM TR_REQUEST_DOC WHERE REQ_ID =@PO_ID)
			SET @FLAG = 4
		END
	END
	------BAODNQ 4/1/2022: --------------
	-----Khai báo DTSD nội bộ - gửi YC phê duyệt-------
	ELSE IF @TYPE='BUD_CONTRACT_MASTER_SEND_APPROVE'
	BEGIN
		-----Có cấp phê duyệt trung gian-------
		IF (EXISTS (SELECT*FROM BUD_CONTRACT_MASTER WHERE CONTRACT_ID = @PO_ID AND SIGN_USER IS NOT NULL))
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME) 
					(SELECT A.SIGN_USER FROM BUD_CONTRACT_MASTER A WHERE A.CONTRACT_ID = @PO_ID)
		END
		ELSE
		-----Ko có cấp phê duyệt trung gian-------
		BEGIN
			SET @BRANCH_CREATE = (SELECT BRANCH_ID FROM BUD_CONTRACT_MASTER WHERE CONTRACT_ID = @PO_ID)
			SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
			SET @p_MAKER_ID = (SELECT MAKER_ID FROM BUD_CONTRACT_MASTER WHERE CONTRACT_ID = @PO_ID)
			SET @DEP_CREATE =(SELECT DEP_ID FROM TL_USER WHERE TLNANME = @p_MAKER_ID)
			IF(@BRANCH_TYPE = 'PGD')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						--(SELECT TLNANME FROM TL_USER 
						--WHERE 1=1
						--AND TLSUBBRID = @BRANCH_CREATE
						--AND RoleName IN ('TPGD', 'PPGD'))
						SELECT TLNANME
						FROM TL_USER
						WHERE 1=1
						AND TLSUBBRID = @BRANCH_CREATE
						AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('TPGD', 'PPGD'))
			END
			ELSE IF(@BRANCH_TYPE = 'CN')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						--(SELECT TLNANME FROM TL_USER 
						--WHERE 1=1
						--AND TLSUBBRID = @BRANCH_CREATE
						--AND RoleName IN ('GDDV', 'PDG'))
						SELECT TLNANME
						FROM TL_USER
						WHERE 1=1
						AND TLSUBBRID = @BRANCH_CREATE
						AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'PGD'))
			END
			ELSE IF(@BRANCH_TYPE = 'HS')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						--(SELECT TLNANME FROM TL_USER 
						--WHERE 1=1
						--AND TLSUBBRID = @BRANCH_CREATE
						--AND DEP_ID = @DEP_CREATE
						--AND RoleName IN ('GDDV', 'PP'))
						SELECT TLNANME
						FROM TL_USER
						WHERE 1=1
						AND TLSUBBRID = @BRANCH_CREATE
						AND DEP_ID = @DEP_CREATE
						AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'TBP', 'TP', 'PP'))
			END
		END
		
		SET @FLAG = 5
	END
	
	-----Khai báo DTSD nội bộ - trung gian duyệt thành công-------
	ELSE IF @TYPE='BUD_CONTRACT_MASTER_CONFIRM'
	BEGIN
		SET @BRANCH_CREATE = (SELECT BRANCH_ID FROM BUD_CONTRACT_MASTER WHERE CONTRACT_ID = @PO_ID)
		SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
		SET @p_MAKER_ID = (SELECT MAKER_ID FROM BUD_CONTRACT_MASTER WHERE CONTRACT_ID = @PO_ID)
		SET @DEP_CREATE =(SELECT DEP_ID FROM TL_USER WHERE TLNANME = @p_MAKER_ID)
		IF(@BRANCH_TYPE = 'PGD')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
					--(SELECT TLNANME FROM TL_USER 
					--WHERE 1=1
					--AND TLSUBBRID = @BRANCH_CREATE
					--AND RoleName IN ('TPGD', 'PPGD'))
					SELECT TLNANME
					FROM TL_USER
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('TPGD', 'PPGD'))
		END
		ELSE IF(@BRANCH_TYPE = 'CN')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
					--(SELECT TLNANME FROM TL_USER 
					--WHERE 1=1
					--AND TLSUBBRID = @BRANCH_CREATE
					--AND RoleName IN ('GDDV', 'PDG'))
					SELECT TLNANME
					FROM TL_USER
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'PGD'))
		END
		ELSE IF(@BRANCH_TYPE = 'HS')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
					--(SELECT TLNANME FROM TL_USER 
					--WHERE 1=1
					--AND TLSUBBRID = @BRANCH_CREATE
					--AND DEP_ID = @DEP_CREATE
					--AND RoleName IN ('GDDV', 'PP'))
					SELECT TLNANME
					FROM TL_USER
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND DEP_ID = @DEP_CREATE
					AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'TBP', 'TP', 'PP'))
		END
		
		SET @FLAG = 5
	END
	-----Khai báo DTSD nội bộ - trưởng đơn vị đã duyệt, trả mail về cho ng tạo-------
	ELSE IF @TYPE='BUD_CONTRACT_MASTER_APPROVED'
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME) 
					(SELECT A.MAKER_ID FROM BUD_CONTRACT_MASTER A WHERE A.CONTRACT_ID = @PO_ID)
		
		SET @FLAG = 5
	END
	---Quản lý hợp đồng khách thuê - gửi YC phê duyệt-----
	ELSE IF @TYPE='BUD_CONTRACT_CUST_MASTER_SEND_APPROVE'
	BEGIN
		-----Có cấp phê duyệt trung gian-------
		IF (EXISTS (SELECT*FROM BUD_CONTRACT_CUST_MASTER WHERE CONTRACT_ID = @PO_ID AND SIGN_USER IS NOT NULL))
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME) 
					(SELECT A.SIGN_USER FROM BUD_CONTRACT_CUST_MASTER A WHERE A.CONTRACT_ID = @PO_ID) 
		END	
		ELSE
		-----Ko có cấp phê duyệt trung gian-------
		BEGIN
			SET @BRANCH_CREATE = (SELECT BRANCH_ID FROM BUD_CONTRACT_CUST_MASTER WHERE CONTRACT_ID = @PO_ID)
			SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
			SET @p_MAKER_ID = (SELECT MAKER_ID FROM BUD_CONTRACT_CUST_MASTER WHERE CONTRACT_ID = @PO_ID)
			SET @DEP_CREATE =(SELECT DEP_ID FROM TL_USER WHERE TLNANME = @p_MAKER_ID)
			IF(@BRANCH_TYPE = 'PGD')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						--SELECT TLNANME FROM TL_USER 
						--WHERE 1=1
						--AND TLSUBBRID = @BRANCH_CREATE
						--AND RoleName IN ('TPGD', 'PP')
						SELECT TLNANME
						FROM TL_USER
						WHERE 1=1
						AND TLSUBBRID = @BRANCH_CREATE
						AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('TPGD', 'PPGD'))
			END
			ELSE IF(@BRANCH_TYPE = 'CN')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						--SELECT TLNANME FROM TL_USER 
						--WHERE 1=1
						--AND TLSUBBRID = @BRANCH_CREATE
						--AND RoleName IN ('GDDV', 'PDG')
						SELECT TLNANME
						FROM TL_USER
						WHERE 1=1
						AND TLSUBBRID = @BRANCH_CREATE
						AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'PGD'))
			END
			ELSE IF(@BRANCH_TYPE = 'HS')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						--SELECT TLNANME FROM TL_USER 
						--WHERE 1=1
						--AND TLSUBBRID = @BRANCH_CREATE
						--AND DEP_ID = @DEP_CREATE
						--AND RoleName IN ('GDDV', 'PP')
						SELECT TLNANME
						FROM TL_USER
						WHERE 1=1
						AND TLSUBBRID = @BRANCH_CREATE
						AND DEP_ID = @DEP_CREATE
						AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'TBP', 'TP', 'PP'))
			END
		END
		SET @FLAG = 5
	END
	---Quản lý hợp đồng khách thuê - trung gian duyệt thành công-----
	ELSE IF @TYPE='BUD_CONTRACT_CUST_MASTER_CONFIRM'
	BEGIN
		SET @BRANCH_CREATE = (SELECT BRANCH_ID FROM BUD_CONTRACT_CUST_MASTER WHERE CONTRACT_ID = @PO_ID)
		SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
		SET @p_MAKER_ID = (SELECT MAKER_ID FROM BUD_CONTRACT_CUST_MASTER WHERE CONTRACT_ID = @PO_ID)
		SET @DEP_CREATE =(SELECT DEP_ID FROM TL_USER WHERE TLNANME = @p_MAKER_ID)
		IF(@BRANCH_TYPE = 'PGD')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
					--(SELECT TLNANME FROM TL_USER 
					--WHERE 1=1
					--AND TLSUBBRID = @BRANCH_CREATE
					--AND RoleName IN ('TPGD', 'PP'))
					SELECT TLNANME
					FROM TL_USER
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('TPGD', 'PPGD'))
		END
		ELSE IF(@BRANCH_TYPE = 'CN')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
					--(SELECT TLNANME FROM TL_USER 
					--WHERE 1=1
					--AND TLSUBBRID = @BRANCH_CREATE
					--AND RoleName IN ('GDDV', 'PDG'))
					SELECT TLNANME
					FROM TL_USER
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'PGD'))
		END
		ELSE IF(@BRANCH_TYPE = 'HS')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
					--(SELECT TLNANME FROM TL_USER 
					--WHERE 1=1
					--AND TLSUBBRID = @BRANCH_CREATE
					--AND DEP_ID = @DEP_CREATE
					--AND RoleName IN ('GDDV', 'PP'))
					SELECT TLNANME
					FROM TL_USER
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND DEP_ID = @DEP_CREATE
					AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'TBP', 'TP', 'PP'))
		END
		
		SET @FLAG = 5
	END
	---Quản lý hợp đồng khách thuê - trưởng đơn vị đã duyệt, trả mail về cho ng tạo-----
	ELSE IF @TYPE='BUD_CONTRACT_CUST_MASTER_APPROVED'
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME) 
					(SELECT A.MAKER_ID FROM BUD_CONTRACT_CUST_MASTER A WHERE A.CONTRACT_ID = @PO_ID)
		SET @FLAG = 5
	END
	------datmq 7/1/2022: --------------
	-----Quản lý trụ sở - gửi YC phê duyệt-------
	ELSE IF @TYPE='BUD_MASTER_SEND_APPROVE'
	BEGIN
		-----Có cấp phê duyệt trung gian-------
		IF (EXISTS (SELECT*FROM BUD_MASTER WHERE BUILDING_ID = @PO_ID AND SIGN_USER IS NOT NULL))
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME) 
					(SELECT A.SIGN_USER FROM BUD_MASTER A WHERE A.BUILDING_ID = @PO_ID)
		END
		ELSE
		-----Ko có cấp phê duyệt trung gian-------
		BEGIN
			SET @BRANCH_CREATE = (SELECT BRANCH_ID FROM BUD_MASTER WHERE BUILDING_ID = @PO_ID)
			SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
			SET @p_MAKER_ID = (SELECT MAKER_ID FROM BUD_MASTER WHERE BUILDING_ID = @PO_ID)
			SET @DEP_CREATE =(SELECT DEP_ID FROM TL_USER WHERE TLNANME = @p_MAKER_ID)
			IF(@BRANCH_TYPE = 'PGD')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						--SELECT TLNANME FROM TL_USER 
						--WHERE 1=1
						--AND TLSUBBRID = @BRANCH_CREATE
						--AND RoleName IN ('TPGD', 'PP')
						SELECT TLNANME
						FROM TL_USER
						WHERE 1=1
						AND TLSUBBRID = @BRANCH_CREATE
						AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('TPGD', 'PPGD'))
			END
			ELSE IF(@BRANCH_TYPE = 'CN')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						--SELECT TLNANME FROM TL_USER 
						--WHERE 1=1
						--AND TLSUBBRID = @BRANCH_CREATE
						--AND RoleName IN ('GDDV', 'PDG')
						SELECT TLNANME
						FROM TL_USER
						WHERE 1=1
						AND TLSUBBRID = @BRANCH_CREATE
						AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'PGD'))
			END
			ELSE IF(@BRANCH_TYPE = 'HS')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						--SELECT TLNANME FROM TL_USER 
						--WHERE 1=1
						--AND TLSUBBRID = @BRANCH_CREATE
						--AND DEP_ID = @DEP_CREATE
						--AND RoleName IN ('GDDV', 'PP')
						SELECT TLNANME
						FROM TL_USER
						WHERE 1=1
						AND TLSUBBRID = @BRANCH_CREATE
						AND DEP_ID = @DEP_CREATE
						AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'TBP', 'TP', 'PP'))
			END
		END
		SET @FLAG = 6
	END
	-----Quản lý trụ sở - trung gian duyệt thành công-------
	ELSE IF @TYPE='BUD_MASTER_CONFIRM'
	BEGIN
		SET @BRANCH_CREATE = (SELECT BRANCH_ID FROM BUD_MASTER WHERE BUILDING_ID = @PO_ID)
		SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
		SET @p_MAKER_ID = (SELECT MAKER_ID FROM BUD_MASTER WHERE BUILDING_ID = @PO_ID)
		SET @DEP_CREATE =(SELECT DEP_ID FROM TL_USER WHERE TLNANME = @p_MAKER_ID)
		IF(@BRANCH_TYPE = 'PGD')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
					--(SELECT TLNANME FROM TL_USER 
					--WHERE 1=1
					--AND TLSUBBRID = @BRANCH_CREATE
					--AND RoleName IN ('TPGD', 'PPGD'))
					SELECT TLNANME
					FROM TL_USER
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('TPGD', 'PPGD'))
		END
		ELSE IF(@BRANCH_TYPE = 'CN')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
					--(SELECT TLNANME FROM TL_USER 
					--WHERE 1=1
					--AND TLSUBBRID = @BRANCH_CREATE
					--AND RoleName IN ('GDDV', 'PDG'))
					SELECT TLNANME
					FROM TL_USER
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'PGD'))
		END
		ELSE IF(@BRANCH_TYPE = 'HS')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
					--(SELECT TLNANME FROM TL_USER 
					--WHERE 1=1
					--AND TLSUBBRID = @BRANCH_CREATE
					--AND DEP_ID = @DEP_CREATE
					--AND RoleName IN ('GDDV', 'PP'))
					SELECT TLNANME
					FROM TL_USER
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND DEP_ID = @DEP_CREATE
					AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'TBP', 'TP', 'PP'))
		END
		
		SET @FLAG = 6
	END
	---Quản lý trụ sở - trưởng đơn vị đã duyệt, trả mail về cho ng tạo-----
	ELSE IF @TYPE='BUD_MASTER_APPROVED'
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME) 
					(SELECT A.MAKER_ID FROM BUD_MASTER A WHERE A.BUILDING_ID = @PO_ID)
		SET @FLAG = 6
	END
	-----PhongNT 15/9/2022: Quản lý TSCĐ/CCLĐ--------
	-- Thêm mới tài sản HCQT
	
	--ELSE IF @TYPE = 'ASS_SEND_TDV'
	--BEGIN
	--	--cắt chuỗi lấy PREFIX để xác định Thêm mới, Xuất, Điều chuyển, Thu hồi, Thanh lý
	--	SET @SYS_PREFIX =(SELECT LEFT(Val,PATINDEX('%[^a-z]%', Val+'0')-1) from(
	--	  SELECT SUBSTRING(@PO_ID, PATINDEX('%[a-z]%', @PO_ID), LEN(@PO_ID)) Val
	--	)x)
	--	SELECT @PAGE = sp.ID
	--	FROM SYS_PREFIX sp WHERE sp.Prefix = @SYS_PREFIX
		
	-- --   SET @BRANCH_CREATE = (SELECT BRANCH_ID FROM ASS_USE_MULTI_MASTER WHERE USER_MASTER_ID = @PO_ID)
	--	--SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
	--	--SET @p_MAKER_ID = (SELECT MAKER_ID FROM ASS_USE_MULTI_MASTER WHERE USER_MASTER_ID = @PO_ID)
	--	--SET @DEP_CREATE =(SELECT DEP_ID FROM TL_USER WHERE TLNANME = @p_MAKER_ID)
	--	IF(@PAGE='ASS_ADDNEW')
	--		BEGIN
	--			SELECT @BRANCH_CREATE = B.TLSUBBRID, @BRANCH_TYPE = B.BRANCH_TYPE, @DEP_CREATE = B.DEP_ID
	--			FROM (SELECT MAKER_ID FROM ASS_ADDNEW WHERE ADDNEW_ID =@PO_ID) A
	--			LEFT JOIN TL_USER B ON  B.TLNANME = A.MAKER_ID
	--		END
	--	ELSE IF(@PAGE='ASS_COLLECT_MULTI_MASTER')
	--		BEGIN
	--			SELECT @BRANCH_CREATE=B.TLSUBBRID, @BRANCH_TYPE =B.BRANCH_TYPE, @DEP_CREATE = B.DEP_ID
	--			FROM (SELECT MAKER_ID FROM ASS_COLLECT_MULTI_MASTER WHERE COL_MULTI_MASTER_ID =@PO_ID) A
	--			LEFT JOIN TL_USER B ON  B.TLNANME = A.MAKER_ID
	--		END
	--	ELSE IF(@PAGE='ASS_TRANSFER_MULTI_MASTER')
	--		BEGIN
	--			SELECT @BRANCH_CREATE=B.TLSUBBRID, @BRANCH_TYPE =B.BRANCH_TYPE, @DEP_CREATE = B.DEP_ID
	--			FROM (SELECT MAKER_ID FROM ASS_TRANSFER_MULTI_MASTER WHERE TRANS_MULTI_MASTER_ID =@PO_ID) A
	--			LEFT JOIN TL_USER B ON  B.TLNANME = A.MAKER_ID
	--		END
	--	ELSE IF(@PAGE='ASS_USE_MULTI_MASTER')
	--		BEGIN
	--			SELECT @BRANCH_CREATE=B.TLSUBBRID, @BRANCH_TYPE =B.BRANCH_TYPE, @DEP_CREATE = B.DEP_ID
	--			FROM (SELECT MAKER_ID FROM ASS_USE_MULTI_MASTER WHERE USER_MASTER_ID =@PO_ID) A
	--			LEFT JOIN TL_USER B ON  B.TLNANME = A.MAKER_ID	
	--		END
	--	ELSE IF(@PAGE='ASS_LIQUIDATION')
	--		BEGIN
	--			SELECT @BRANCH_CREATE=B.TLSUBBRID, @BRANCH_TYPE =B.BRANCH_TYPE, @DEP_CREATE = B.DEP_ID
	--			FROM (SELECT MAKER_ID FROM ASS_LIQUIDATION WHERE LIQ_ID =@PO_ID) A
	--			LEFT JOIN TL_USER B ON  B.TLNANME = A.MAKER_ID	
	--		END
	--	IF (@BRANCH_TYPE = 'HS')
	--	BEGIN
	--		INSERT INTO @LST_USER_RECIVE (TLNAME)
	--			(SELECT TLNANME FROM TL_USER 
	--			WHERE 1=1
	--			AND TLSUBBRID = @BRANCH_CREATE
	--			AND SECUR_CODE = @DEP_CREATE
	--			AND EXISTS(SELECT * FROM [dbo].[TL_USER_GET_ROLES](TLNANME) WHERE ROLE_ID IN ('GDDV','TP'))
	--			UNION ALL
	--			SELECT TLNAME AS TLNANME FROM dbo.TL_SYS_ROLE_MAPPING
	--			WHERE 1=1
	--			AND BRANCH_ID = @BRANCH_CREATE
	--			AND DEP_ID = @DEP_CREATE
	--			AND ROLE_NEW IN ('GDDV','TP')
	--			AND (CONVERT(DATE,GETDATE(),103) >= CONVERT(DATE,EFF_DATE, 103) OR EFF_DATE IS NULL OR EFF_DATE ='')
	--			AND (CONVERT(DATE, GETDATE(),103) <=CONVERT(DATE,EXP_DATE, 103) OR EXP_DATE IS NULL OR EXP_DATE =''))
	--	END
	--	ELSE
	--	BEGIN
	--		INSERT INTO @LST_USER_RECIVE (TLNAME)
	--			(SELECT TLNANME FROM TL_USER 
	--			WHERE 1=1
	--			AND TLSUBBRID = @BRANCH_CREATE
	--			AND EXISTS(SELECT * FROM [dbo].[TL_USER_GET_ROLES](TLNANME) WHERE ROLE_ID IN ('GDDV','TPGD'))
	--			UNION ALL
	--			SELECT TLNAME AS TLNANME FROM dbo.TL_SYS_ROLE_MAPPING
	--			WHERE 1=1
	--			AND BRANCH_ID = @BRANCH_CREATE
	--			AND ROLE_NEW IN ('GDDV','TPGD')
	--			AND (CONVERT(DATE,GETDATE(),103) >= CONVERT(DATE,EFF_DATE, 103) OR EFF_DATE IS NULL OR EFF_DATE ='')
	--			AND (CONVERT(DATE, GETDATE(),103) <=CONVERT(DATE,EXP_DATE, 103) OR EXP_DATE IS NULL OR EXP_DATE =''))
	--	END
	--	SET @FLAG = 6
	--END
	--ELSE IF @TYPE = 'ASS_SEND_GDV'
	--	BEGIN
	--		INSERT INTO @LST_USER_RECIVE (TLNAME)
	--		 SELECT TLNANME
	--			FROM TL_USER 
	--			WHERE 1=1
	--			AND TLSUBBRID = 'DV0001'
	--			AND EXISTS(SELECT * FROM [dbo].[TL_USER_GET_ROLES](TLNANME) WHERE ROLE_ID IN ('GDV'))
	--		SET @FLAG = 6
	--	END
	ELSE IF @TYPE = 'ASS_REJECT_GDV'
		BEGIN
		--cắt chuỗi lấy PREFIX để xác định Thêm mới, Xuất, Điều chuyển, Thu hồi, Thanh lý
		SET @SYS_PREFIX =(SELECT LEFT(Val,PATINDEX('%[^a-z]%', Val+'0')-1) from(
		  SELECT SUBSTRING(@PO_ID, PATINDEX('%[a-z]%', @PO_ID), LEN(@PO_ID)) Val
		)x)
		SELECT @PAGE = sp.ID
		FROM SYS_PREFIX sp WHERE sp.Prefix = @SYS_PREFIX
			IF(@PAGE='ASS_ADDNEW')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
				(
				SELECT MAKER_ID_KT
				FROM ASS_ADDNEW 
				WHERE ADDNEW_ID = @PO_ID
				)
			END
		ELSE IF(@PAGE='ASS_COLLECT_MULTI_MASTER')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
				(
				SELECT MAKER_ID_KT
				FROM ASS_COLLECT_MULTI_MASTER 
				WHERE COL_MULTI_MASTER_ID = @PO_ID
				)
			END
		ELSE IF(@PAGE='ASS_TRANSFER_MULTI_MASTER')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
				(
				SELECT MAKER_ID_KT
				FROM ASS_TRANSFER_MULTI_MASTER WHERE TRANS_MULTI_MASTER_ID = @PO_ID
				)
			END
		ELSE IF(@PAGE='ASS_USE_MULTI_MASTER')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
				(
				SELECT MAKER_ID_KT
				FROM ASS_USE_MULTI_MASTER WHERE USER_MASTER_ID = @PO_ID
				)
			END
		ELSE IF(@PAGE='ASS_LIQUIDATION')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
				(
				SELECT MAKER_ID_KT
				FROM ASS_LIQUIDATION WHERE LIQ_ID = @PO_ID
				)
			END
		SET @FLAG = 6
	END
	--ELSE IF @TYPE = 'ASS_SEND_KSV'
	--	BEGIN
	--		INSERT INTO @LST_USER_RECIVE (TLNAME)
	--		 SELECT TLNANME
	--			FROM TL_USER 
	--			WHERE 1=1
	--			AND TLSUBBRID = 'DV0001'
	--			AND EXISTS(SELECT * FROM [dbo].[TL_USER_GET_ROLES](TLNANME) WHERE ROLE_ID IN ('KSV'))
	--		SET @FLAG = 6
	--	END
	ELSE IF @TYPE = 'ASS_APPROVED'
		BEGIN
			--cắt chuỗi lấy PREFIX để xác định Thêm mới, Xuất, Điều chuyển, Thu hồi, Thanh lý
			SET @SYS_PREFIX =(SELECT LEFT(Val,PATINDEX('%[^a-z]%', Val+'0')-1) from(
			  SELECT SUBSTRING(@PO_ID, PATINDEX('%[a-z]%', @PO_ID), LEN(@PO_ID)) Val
			)x)
			SELECT @PAGE = sp.ID
			FROM SYS_PREFIX sp WHERE sp.Prefix = @SYS_PREFIX
			
		IF(@PAGE='ASS_ADDNEW')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
				(SELECT MAKER_ID
				FROM ASS_ADDNEW 
				WHERE ADDNEW_ID = @PO_ID
				--UNION
				--SELECT MAKER_ID_KT
				--FROM ASS_ADDNEW 
				--WHERE ADDNEW_ID = @PO_ID
				)
			END
		ELSE IF(@PAGE='ASS_COLLECT_MULTI_MASTER')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
				(SELECT MAKER_ID
				FROM ASS_COLLECT_MULTI_MASTER 
				WHERE COL_MULTI_MASTER_ID = @PO_ID
				--UNION
				--SELECT MAKER_ID_KT
				--FROM ASS_COLLECT_MULTI_MASTER 
				--WHERE COL_MULTI_MASTER_ID = @PO_ID
				)
			END
		ELSE IF(@PAGE='ASS_TRANSFER_MULTI_MASTER')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
				(SELECT MAKER_ID
				FROM ASS_TRANSFER_MULTI_MASTER WHERE TRANS_MULTI_MASTER_ID = @PO_ID
				--UNION
				--SELECT MAKER_ID_KT
				--FROM ASS_TRANSFER_MULTI_MASTER WHERE TRANS_MULTI_MASTER_ID = @PO_ID
				)
			END
		ELSE IF(@PAGE='ASS_USE_MULTI_MASTER')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
				(SELECT MAKER_ID
				FROM ASS_USE_MULTI_MASTER WHERE USER_MASTER_ID = @PO_ID
				--UNION
				--SELECT MAKER_ID_KT
				--FROM ASS_USE_MULTI_MASTER WHERE USER_MASTER_ID = @PO_ID
				)
			END
		ELSE IF(@PAGE='ASS_LIQUIDATION')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
				(SELECT MAKER_ID
				FROM ASS_LIQUIDATION WHERE LIQ_ID = @PO_ID
				--UNION
				--SELECT MAKER_ID_KT
				--FROM ASS_LIQUIDATION WHERE LIQ_ID = @PO_ID
				)
			END
			SET @FLAG = 6
	END
	ELSE IF @TYPE = 'ASS_SEND_NT'
		BEGIN
			--cắt chuỗi lấy PREFIX để xác định Thêm mới, Xuất, Điều chuyển, Thu hồi, Thanh lý
			SET @SYS_PREFIX =(SELECT LEFT(Val,PATINDEX('%[^a-z]%', Val+'0')-1) from(
			  SELECT SUBSTRING(@PO_ID, PATINDEX('%[a-z]%', @PO_ID), LEN(@PO_ID)) Val
			)x)
			SELECT @PAGE = sp.ID
			FROM SYS_PREFIX sp WHERE sp.Prefix = @SYS_PREFIX
			
		IF(@PAGE='ASS_ADDNEW')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
				(SELECT MAKER_ID
				FROM ASS_ADDNEW 
				WHERE ADDNEW_ID = @PO_ID
				)
			END
		ELSE IF(@PAGE='ASS_COLLECT_MULTI_MASTER')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
				(SELECT MAKER_ID
				FROM ASS_COLLECT_MULTI_MASTER 
				WHERE COL_MULTI_MASTER_ID = @PO_ID
				)
			END
		ELSE IF(@PAGE='ASS_TRANSFER_MULTI_MASTER')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
				(SELECT MAKER_ID
				FROM ASS_TRANSFER_MULTI_MASTER WHERE TRANS_MULTI_MASTER_ID = @PO_ID
				)
			END
		ELSE IF(@PAGE='ASS_USE_MULTI_MASTER')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
				(SELECT MAKER_ID
				FROM ASS_USE_MULTI_MASTER WHERE USER_MASTER_ID = @PO_ID
				)
			END
		ELSE IF(@PAGE='ASS_LIQUIDATION')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
				(SELECT MAKER_ID
				FROM ASS_LIQUIDATION WHERE LIQ_ID = @PO_ID
				)
			END
		ELSE IF(@PAGE = 'ASS_PRIVATE_TRANSFER_MASTER')
			BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
				(SELECT MAKER_ID
				FROM ASS_PRIVATE_TRANSFER_MASTER WHERE TRANS_MULTI_MASTER_ID = @PO_ID
				)
			END
		ELSE IF(@PAGE = 'ASS_REPAIR_MULTI_MASTER')
			BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
				(SELECT MAKER_ID
				FROM ASS_REPAIR_MULTI_MASTER WHERE REPAIR_MUL_ID = @PO_ID
				)
			END
		ELSE IF(@PAGE = 'ASS_INVENTORY_MASTER')
		BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME)
			(SELECT MAKER_ID
			FROM ASS_INVENTORY_MASTER WHERE INVENT_ID = @PO_ID
			)
		END
		--TRẢ VỀ NGƯỜI TẠO. PYC DC,SC,TH,CPTS
		SET @REQ_TYPE = (SELECT TOP 1 REQ_TYPE FROM TR_REQUEST_SHOP_DOC WHERE REQ_ID = @PO_ID)
		IF(@REQ_TYPE IS NOT NULL AND @REQ_TYPE <> '')
		BEGIN
			INSERT INTO @LST_USER_RECIVE(TLNAME)
			SELECT MAKER_ID FROM TR_REQUEST_SHOP_DOC WHERE REQ_ID = @PO_ID
		END
		
		SET @FLAG = 6
	END
	ELSE IF @TYPE = 'ASS_SEND_CONFIRM'
		BEGIN
			--cắt chuỗi lấy PREFIX để xác định Thêm mới, Xuất, Điều chuyển, Thu hồi, Thanh lý
			SET @SYS_PREFIX =(SELECT LEFT(Val,PATINDEX('%[^a-z]%', Val+'0')-1) from(
				SELECT SUBSTRING(@PO_ID, PATINDEX('%[a-z]%', @PO_ID), LEN(@PO_ID)) Val
			)x)
			SELECT @PAGE = sp.ID
			FROM SYS_PREFIX sp WHERE sp.Prefix = @SYS_PREFIX
			DECLARE @BRANCH_ID VARCHAR(20),@DEP_ID VARCHAR(20)
		
		PRINT @PAGE
		IF(@PAGE='ASS_COLLECT_MULTI_MASTER')
			BEGIN
				SELECT TOP 1 @BRANCH_CREATE = BRANCH_ID_RECEIVE, @DEP_CREATE = DEPT_ID_RECEIVE,@BRANCH_TYPE =B.BRANCH_TYPE
				FROM  dbo.ASS_COLLECT_MULTI_DT A
				LEFT JOIN dbo.CM_BRANCH B ON A.BRANCH_ID_RECEIVE =B.BRANCH_ID
				WHERE COL_MULTI_MASTER_ID = @PO_ID
				ORDER BY COLLECT_MULTI_ID ASC
			END
		ELSE IF(@PAGE='ASS_USE_MULTI_MASTER')
			BEGIN
				--SELECT TOP 1 @BRANCH_CREATE = A.BRANCH_ID, @DEP_CREATE = DEPT_ID,@BRANCH_TYPE =B.BRANCH_TYPE
				--FROM  dbo.ASS_USE_MULTI_DT A
				--LEFT JOIN dbo.CM_BRANCH B ON A.BRANCH_ID =B.BRANCH_ID
				--WHERE USE_MULTI_ID = @PO_ID
				--ORDER BY USE_MULTI_ID ASC
				INSERT INTO @LST_USER_RECIVE (TLNAME)
				(SELECT MAKER_ID
				FROM ASS_USE_MULTI_MASTER WHERE USER_MASTER_ID = @PO_ID
				)
			END
		ELSE IF(@PAGE='ASS_ADDNEW')
			BEGIN
				SELECT TOP 1 @BRANCH_CREATE = A.BRANCH_ID, @DEP_CREATE = DEPT_ID,@BRANCH_TYPE =B.BRANCH_TYPE
				FROM  dbo.ASS_ADDNEW A
				LEFT JOIN dbo.CM_BRANCH B ON A.BRANCH_ID =B.BRANCH_ID
				WHERE ADDNEW_ID = @PO_ID
				ORDER BY ADDNEW_ID ASC
			END
			PRINT @BRANCH_CREATE
			PRINT @DEP_CREATE
		--IF (@BRANCH_TYPE = 'HS')
		--BEGIN
		--	INSERT INTO @LST_USER_RECIVE (TLNAME)
		--		(SELECT TLNANME FROM TL_USER 
		--		WHERE 1=1
		--		AND TLSUBBRID = @BRANCH_CREATE
		--		AND SECUR_CODE = @DEP_CREATE
		--		AND EXISTS(SELECT * FROM [dbo].[TL_USER_GET_ROLES](TLNANME) WHERE ROLE_ID IN ('GDDV','TP'))
		--		UNION ALL
		--		SELECT TLNAME AS TLNANME FROM dbo.TL_SYS_ROLE_MAPPING
		--		WHERE 1=1
		--		AND 
		--		((BRANCH_ID = @BRANCH_ID AND DEP_ID = @DEP_ID)
		--		OR
		--		(BRANCH_ID = @BRANCH_CREATE AND DEP_ID = @DEP_CREATE))
		--		AND ROLE_NEW IN ('GDDV','TP')
		--		AND (CONVERT(DATE,GETDATE(),103) >= CONVERT(DATE,EFF_DATE, 103) OR EFF_DATE IS NULL OR EFF_DATE ='')
		--		AND (CONVERT(DATE, GETDATE(),103) <=CONVERT(DATE,EXP_DATE, 103) OR EXP_DATE IS NULL OR EXP_DATE =''))
		--END
		--ELSE
		--BEGIN
		--	INSERT INTO @LST_USER_RECIVE (TLNAME)
		--		(SELECT TLNANME FROM TL_USER 
		--		WHERE 1=1
		--		AND TLSUBBRID = @BRANCH_CREATE
		--		AND EXISTS(SELECT * FROM [dbo].[TL_USER_GET_ROLES](TLNANME) WHERE ROLE_ID IN ('GDDV','TPGD'))
		--		UNION ALL
		--		SELECT TLNAME AS TLNANME FROM dbo.TL_SYS_ROLE_MAPPING
		--		WHERE 1=1
		--		AND 
		--		((BRANCH_ID = @BRANCH_ID)
		--		OR
		--		(BRANCH_ID = @BRANCH_CREATE))
		--		AND ROLE_NEW IN ('GDDV','TPGD')
		--		AND (CONVERT(DATE,GETDATE(),103) >= CONVERT(DATE,EFF_DATE, 103) OR EFF_DATE IS NULL OR EFF_DATE ='')
		--		AND (CONVERT(DATE, GETDATE(),103) <=CONVERT(DATE,EXP_DATE, 103) OR EXP_DATE IS NULL OR EXP_DATE =''))
		--END
		SET @FLAG =6
	END
	ELSE IF @TYPE ='ASS_TRANSFER_CONFIRM_HANDOVER'
	BEGIN
		SELECT TOP 1 @BRANCH_CREATE=A.BRANCH_ID_OLD,@DEP_CREATE =DEPT_ID_OLD,@BRANCH_TYPE =b.BRANCH_TYPE
		FROM  dbo.ASS_TRANSFER_MULTI_DT A
		LEFT  JOIN dbo.CM_BRANCH B ON B.BRANCH_ID = A.BRANCH_ID_OLD
		ORDER BY TRANSFER_MULTI_ID ASC
		IF (@BRANCH_TYPE = 'HS')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
				(SELECT TLNANME FROM TL_USER 
				WHERE 1=1
				AND TLSUBBRID = @BRANCH_CREATE
				AND SECUR_CODE = @DEP_CREATE
				AND EXISTS(SELECT * FROM [dbo].[TL_USER_GET_ROLES](TLNANME) WHERE ROLE_ID IN ('GDDV','TP'))
				UNION ALL
				SELECT TLNAME AS TLNANME FROM dbo.TL_SYS_ROLE_MAPPING
				WHERE 1=1
				AND 
				((BRANCH_ID = @BRANCH_ID AND DEP_ID = @DEP_ID)
				OR
				(BRANCH_ID = @BRANCH_CREATE AND DEP_ID = @DEP_CREATE))
				AND ROLE_NEW IN ('GDDV','TP')
				AND (CONVERT(DATE,GETDATE(),103) >= CONVERT(DATE,EFF_DATE, 103) OR EFF_DATE IS NULL OR EFF_DATE ='')
				AND (CONVERT(DATE, GETDATE(),103) <=CONVERT(DATE,EXP_DATE, 103) OR EXP_DATE IS NULL OR EXP_DATE =''))
		END
		ELSE
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
				(SELECT TLNANME FROM TL_USER 
				WHERE 1=1
				AND TLSUBBRID = @BRANCH_CREATE
				AND EXISTS(SELECT * FROM [dbo].[TL_USER_GET_ROLES](TLNANME) WHERE ROLE_ID IN ('GDDV','TPGD'))
				UNION ALL
				SELECT TLNAME AS TLNANME FROM dbo.TL_SYS_ROLE_MAPPING
				WHERE 1=1
				AND 
				((BRANCH_ID = @BRANCH_ID)
				OR
				(BRANCH_ID = @BRANCH_CREATE))
				AND ROLE_NEW IN ('GDDV','TPGD')
				AND (CONVERT(DATE,GETDATE(),103) >= CONVERT(DATE,EFF_DATE, 103) OR EFF_DATE IS NULL OR EFF_DATE ='')
				AND (CONVERT(DATE, GETDATE(),103) <=CONVERT(DATE,EXP_DATE, 103) OR EXP_DATE IS NULL OR EXP_DATE =''))
		END
	END
	ELSE IF @TYPE ='ASS_TRANSFER_CONFIRM_RECEIVER'
	BEGIN
		SELECT TOP 1 @BRANCH_CREATE=A.BRANCH_ID,@DEP_CREATE =DEPT_ID,@BRANCH_TYPE =b.BRANCH_TYPE
		FROM  dbo.ASS_TRANSFER_MULTI_DT A
		LEFT  JOIN dbo.CM_BRANCH B ON B.BRANCH_ID = A.BRANCH_ID
		ORDER BY TRANSFER_MULTI_ID ASC
		IF (@BRANCH_TYPE = 'HS')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
				(SELECT TLNANME FROM TL_USER 
				WHERE 1=1
				AND TLSUBBRID = @BRANCH_CREATE
				AND SECUR_CODE = @DEP_CREATE
				AND EXISTS(SELECT * FROM [dbo].[TL_USER_GET_ROLES](TLNANME) WHERE ROLE_ID IN ('GDDV','TP'))
				UNION ALL
				SELECT TLNAME AS TLNANME FROM dbo.TL_SYS_ROLE_MAPPING
				WHERE 1=1
				AND 
				((BRANCH_ID = @BRANCH_ID AND DEP_ID = @DEP_ID)
				OR
				(BRANCH_ID = @BRANCH_CREATE AND DEP_ID = @DEP_CREATE))
				AND ROLE_NEW IN ('GDDV','TP')
				AND (CONVERT(DATE,GETDATE(),103) >= CONVERT(DATE,EFF_DATE, 103) OR EFF_DATE IS NULL OR EFF_DATE ='')
				AND (CONVERT(DATE, GETDATE(),103) <=CONVERT(DATE,EXP_DATE, 103) OR EXP_DATE IS NULL OR EXP_DATE =''))
		END
		ELSE
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
				(SELECT TLNANME FROM TL_USER 
				WHERE 1=1
				AND TLSUBBRID = @BRANCH_CREATE
				AND EXISTS(SELECT * FROM [dbo].[TL_USER_GET_ROLES](TLNANME) WHERE ROLE_ID IN ('GDDV','TPGD'))
				UNION ALL
				SELECT TLNAME AS TLNANME FROM dbo.TL_SYS_ROLE_MAPPING
				WHERE 1=1
				AND 
				((BRANCH_ID = @BRANCH_ID)
				OR
				(BRANCH_ID = @BRANCH_CREATE))
				AND ROLE_NEW IN ('GDDV','TPGD')
				AND (CONVERT(DATE,GETDATE(),103) >= CONVERT(DATE,EFF_DATE, 103) OR EFF_DATE IS NULL OR EFF_DATE ='')
				AND (CONVERT(DATE, GETDATE(),103) <=CONVERT(DATE,EXP_DATE, 103) OR EXP_DATE IS NULL OR EXP_DATE =''))
		END
	END
	ELSE IF @TYPE ='ASS_INVENTORY_RECIVE_MAIL'
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME)
		(SELECT PARTY_NAME FROM dbo.ASS_INVENTORY_PARTY_DT WHERE IS_RECIVE_MAIL =1)
	END
	ELSE IF @TYPE ='ASS_INVENTORY_MAIN'
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME)
		(SELECT PARTY_NAME FROM dbo.ASS_INVENTORY_PARTY_DT WHERE IS_MAIN = 1)
	END
	----------BAODNQ :15/2/2022 --Xử lý gửi mail cho phân hệ Quản lý BDS---------
	---Quản lý BDS- gửi YC phê duyệt-----
	ELSE IF @TYPE='RET_MASTER_SEND_APPROVE'
	BEGIN
		-----Có cấp phê duyệt trung gian-------
		IF (EXISTS (SELECT * FROM RET_MASTER WHERE RET_ID = @PO_ID AND SIGN_USER IS NOT NULL))
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME) 
					(SELECT A.SIGN_USER FROM RET_MASTER A WHERE A.RET_ID = @PO_ID) 
		END	
		ELSE
		-----Ko có cấp phê duyệt trung gian-------
		BEGIN
			SET @BRANCH_CREATE = 
				(SELECT  B.BRANCH_ID
				FROM RET_MASTER A
				LEFT JOIN ASS_MASTER B ON A.ASSET_ID = B.ASSET_ID
				WHERE RET_ID = @PO_ID)
			SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
			SET @p_MAKER_ID = (SELECT MAKER_ID FROM RET_MASTER WHERE RET_ID = @PO_ID)
			SET @DEP_CREATE =(SELECT DEP_ID FROM TL_USER WHERE TLNANME = @p_MAKER_ID)
			IF(@BRANCH_TYPE = 'PGD')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						--SELECT TLNANME FROM TL_USER 
						--WHERE 1=1
						--AND TLSUBBRID = @BRANCH_CREATE
						--AND RoleName IN ('TPGD', 'PP')
						SELECT TLNANME
						FROM TL_USER
						WHERE 1=1
						AND TLSUBBRID = @BRANCH_CREATE
						AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('TPGD', 'PPGD'))
			END
			ELSE IF(@BRANCH_TYPE = 'CN')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						--SELECT TLNANME FROM TL_USER 
						--WHERE 1=1
						--AND TLSUBBRID = @BRANCH_CREATE
						--AND RoleName IN ('GDDV', 'PDG')
						SELECT TLNANME
						FROM TL_USER
						WHERE 1=1
						AND TLSUBBRID = @BRANCH_CREATE
						AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'PGD'))
			END
			ELSE IF(@BRANCH_TYPE = 'HS')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						--SELECT TLNANME FROM TL_USER 
						--WHERE 1=1
						--AND TLSUBBRID = @BRANCH_CREATE
						--AND DEP_ID = @DEP_CREATE
						--AND RoleName IN ('GDDV', 'PP')
						SELECT TLNANME
						FROM TL_USER
						WHERE 1=1
						AND TLSUBBRID = @BRANCH_CREATE
						AND DEP_ID = @DEP_CREATE
						AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'TBP', 'TP', 'PP'))
			END
		END
		SET @FLAG = 7
	END
	---Quản lý BDS - trung gian duyệt thành công-----
	ELSE IF @TYPE='RET_MASTER_CONFIRM'
	BEGIN
		SET @BRANCH_CREATE = 
				(SELECT  B.BRANCH_ID
				FROM RET_MASTER A
				LEFT JOIN ASS_MASTER B ON A.ASSET_ID = B.ASSET_ID
				WHERE RET_ID = @PO_ID)
		SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
		SET @p_MAKER_ID = (SELECT MAKER_ID FROM RET_MASTER WHERE RET_ID = @PO_ID)
		SET @DEP_CREATE =(SELECT DEP_ID FROM TL_USER WHERE TLNANME = @p_MAKER_ID)
		IF(@BRANCH_TYPE = 'PGD')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
					--(SELECT TLNANME FROM TL_USER 
					--WHERE 1=1
					--AND TLSUBBRID = @BRANCH_CREATE
					--AND RoleName IN ('TPGD', 'PP'))
					SELECT TLNANME
					FROM TL_USER
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'PGD'))
		END
		ELSE IF(@BRANCH_TYPE = 'CN')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
					--(SELECT TLNANME FROM TL_USER 
					--WHERE 1=1
					--AND TLSUBBRID = @BRANCH_CREATE
					--AND RoleName IN ('GDDV', 'PDG'))
					SELECT TLNANME
					FROM TL_USER
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'PGD'))
		END
		ELSE IF(@BRANCH_TYPE = 'HS')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
					--(SELECT TLNANME FROM TL_USER 
					--WHERE 1=1
					--AND TLSUBBRID = @BRANCH_CREATE
					--AND DEP_ID = @DEP_CREATE
					--AND RoleName IN ('GDDV', 'PP'))
					SELECT TLNANME
					FROM TL_USER
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND DEP_ID = @DEP_CREATE
					AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'TBP', 'TP', 'PP'))
		END
		
		SET @FLAG = 7
	END
	---Quản lý BDS - trưởng đơn vị đã duyệt, trả mail về cho ng tạo-----
	ELSE IF @TYPE='RET_MASTER_APPROVED'
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME) 
					(SELECT A.MAKER_ID FROM RET_MASTER A WHERE A.RET_ID = @PO_ID)
		SET @FLAG = 7
	END
	---Thông tin sửa chữa BDS- gửi YC phê duyệt-----
	ELSE IF @TYPE='RET_REPAIR_SEND_APPROVE'
	BEGIN
		-----Có cấp phê duyệt trung gian-------
		IF (EXISTS (SELECT*FROM RET_REPAIR WHERE RP_ID = @PO_ID AND SIGN_USER IS NOT NULL))
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME) 
					(SELECT A.SIGN_USER FROM RET_REPAIR A WHERE A.RP_ID = @PO_ID) 
		END	
		ELSE
		-----Ko có cấp phê duyệt trung gian-------
		BEGIN
			SET @BRANCH_CREATE = (SELECT OFFER_BRANCH FROM RET_REPAIR WHERE RP_ID = @PO_ID)
			SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
			SET @p_MAKER_ID = (SELECT MAKER_ID FROM RET_REPAIR WHERE RP_ID = @PO_ID)
			SET @DEP_CREATE =(SELECT DEP_ID FROM TL_USER WHERE TLNANME = @p_MAKER_ID)
			IF(@BRANCH_TYPE = 'PGD')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						--SELECT TLNANME FROM TL_USER 
						--WHERE 1=1
						--AND TLSUBBRID = @BRANCH_CREATE
						--AND RoleName IN ('TPGD', 'PP')
						SELECT TLNANME
						FROM TL_USER
						WHERE 1=1
						AND TLSUBBRID = @BRANCH_CREATE
						AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('TPGD', 'PPGD'))
			END
			ELSE IF(@BRANCH_TYPE = 'CN')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						--SELECT TLNANME FROM TL_USER 
						--WHERE 1=1
						--AND TLSUBBRID = @BRANCH_CREATE
						--AND RoleName IN ('GDDV', 'PDG')
						SELECT TLNANME
						FROM TL_USER
						WHERE 1=1
						AND TLSUBBRID = @BRANCH_CREATE
						AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'PGD'))
			END
			ELSE IF(@BRANCH_TYPE = 'HS')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						--SELECT TLNANME FROM TL_USER 
						--WHERE 1=1
						--AND TLSUBBRID = @BRANCH_CREATE
						--AND DEP_ID = @DEP_CREATE
						--AND RoleName IN ('GDDV', 'PP')
						SELECT TLNANME
						FROM TL_USER
						WHERE 1=1
						AND TLSUBBRID = @BRANCH_CREATE
						AND DEP_ID = @DEP_CREATE
						AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'TBP', 'TP', 'PP'))
			END
		END
		SET @FLAG = 7
	END
	---Thông tin sửa chữa BDS - trung gian duyệt thành công-----
	ELSE IF @TYPE='RET_REPAIR_CONFIRM'
	BEGIN
		SET @BRANCH_CREATE = (SELECT OFFER_BRANCH FROM RET_REPAIR WHERE RP_ID = @PO_ID)
		SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
		SET @p_MAKER_ID = (SELECT MAKER_ID FROM RET_REPAIR WHERE RP_ID = @PO_ID)
		SET @DEP_CREATE =(SELECT DEP_ID FROM TL_USER WHERE TLNANME = @p_MAKER_ID)
		IF(@BRANCH_TYPE = 'PGD')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
					--(SELECT TLNANME FROM TL_USER 
					--WHERE 1=1
					--AND TLSUBBRID = @BRANCH_CREATE
					--AND RoleName IN ('TPGD', 'PP'))
					SELECT TLNANME
					FROM TL_USER
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('TPGD', 'PPGD'))
		END
		ELSE IF(@BRANCH_TYPE = 'CN')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
					--(SELECT TLNANME FROM TL_USER 
					--WHERE 1=1
					--AND TLSUBBRID = @BRANCH_CREATE
					--AND RoleName IN ('GDDV', 'PDG'))
					SELECT TLNANME
					FROM TL_USER
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'PGD'))
		END
		ELSE IF(@BRANCH_TYPE = 'HS')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
					--(SELECT TLNANME FROM TL_USER 
					--WHERE 1=1
					--AND TLSUBBRID = @BRANCH_CREATE
					--AND DEP_ID = @DEP_CREATE
					--AND RoleName IN ('GDDV', 'PP'))
					SELECT TLNANME
					FROM TL_USER
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND DEP_ID = @DEP_CREATE
					AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'TBP', 'TP', 'PP'))
		END
		
		SET @FLAG = 7
	END
	---Thông tin sửa chữa BDS - trưởng đơn vị đã duyệt, trả mail về cho ng tạo-----
	ELSE IF @TYPE='RET_REPAIR_APPROVED'
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME) 
					(SELECT A.MAKER_ID FROM RET_REPAIR A WHERE A.RP_ID = @PO_ID)
		SET @FLAG = 7
	END
	---BDS thuê làm trụ sở CN/PGD - gửi YC phê duyệt-----
	ELSE IF @TYPE='REAL_ESTATE_R_H_SEND_APPROVE'
	BEGIN
		-----Có cấp phê duyệt trung gian-------
		IF (EXISTS (SELECT*FROM REAL_ESTATE_R_H WHERE RET_R_H_ID = @PO_ID AND SIGN_USER IS NOT NULL))
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME) 
					(SELECT A.SIGN_USER FROM REAL_ESTATE_R_H A WHERE A.RET_R_H_ID = @PO_ID) 
		END	
		ELSE
		-----Ko có cấp phê duyệt trung gian-------
		BEGIN
			SET @BRANCH_CREATE = (SELECT BRANCH_CREATE FROM REAL_ESTATE_R_H WHERE RET_R_H_ID = @PO_ID)
			SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
			SET @p_MAKER_ID = (SELECT MAKER_ID FROM REAL_ESTATE_R_H WHERE RET_R_H_ID = @PO_ID)
			SET @DEP_CREATE =(SELECT DEP_ID FROM TL_USER WHERE TLNANME = @p_MAKER_ID)
			IF(@BRANCH_TYPE = 'PGD')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						--SELECT TLNANME FROM TL_USER 
						--WHERE 1=1
						--AND TLSUBBRID = @BRANCH_CREATE
						--AND RoleName IN ('TPGD', 'PP')
						SELECT TLNANME
						FROM TL_USER
						WHERE 1=1
						AND TLSUBBRID = @BRANCH_CREATE
						AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('TPGD', 'PPGD'))
			END
			ELSE IF(@BRANCH_TYPE = 'CN')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						--SELECT TLNANME FROM TL_USER 
						--WHERE 1=1
						--AND TLSUBBRID = @BRANCH_CREATE
						--AND RoleName IN ('GDDV', 'PDG')
						SELECT TLNANME
						FROM TL_USER
						WHERE 1=1
						AND TLSUBBRID = @BRANCH_CREATE
						AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'PGD'))
			END
			ELSE IF(@BRANCH_TYPE = 'HS')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						--SELECT TLNANME FROM TL_USER 
						--WHERE 1=1
						--AND TLSUBBRID = @BRANCH_CREATE
						--AND DEP_ID = @DEP_CREATE
						--AND RoleName IN ('GDDV', 'PP')
						SELECT TLNANME
						FROM TL_USER
						WHERE 1=1
						AND TLSUBBRID = @BRANCH_CREATE
						AND DEP_ID = @DEP_CREATE
						AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'TBP', 'TP', 'PP'))
			END
		END
		SET @FLAG = 7
	END
	---BDS thuê làm trụ sở CN/PGD - trung gian duyệt thành công-----
	ELSE IF @TYPE='REAL_ESTATE_R_H_CONFIRM'
	BEGIN
		SET @BRANCH_CREATE = (SELECT BRANCH_CREATE FROM REAL_ESTATE_R_H WHERE RET_R_H_ID = @PO_ID)
		SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
		SET @p_MAKER_ID = (SELECT MAKER_ID FROM REAL_ESTATE_R_H WHERE RET_R_H_ID = @PO_ID)
		SET @DEP_CREATE =(SELECT DEP_ID FROM TL_USER WHERE TLNANME = @p_MAKER_ID)
		IF(@BRANCH_TYPE = 'PGD')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
					--(SELECT TLNANME FROM TL_USER 
					--WHERE 1=1
					--AND TLSUBBRID = @BRANCH_CREATE
					--AND RoleName IN ('TPGD', 'PP'))
					SELECT TLNANME
					FROM TL_USER
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('TPGD', 'PPGD'))
		END
		ELSE IF(@BRANCH_TYPE = 'CN')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
					--(SELECT TLNANME FROM TL_USER 
					--WHERE 1=1
					--AND TLSUBBRID = @BRANCH_CREATE
					--AND RoleName IN ('GDDV', 'PDG'))
					SELECT TLNANME
					FROM TL_USER
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'PGD'))
		END
		ELSE IF(@BRANCH_TYPE = 'HS')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
					--(SELECT TLNANME FROM TL_USER 
					--WHERE 1=1
					--AND TLSUBBRID = @BRANCH_CREATE
					--AND DEP_ID = @DEP_CREATE
					--AND RoleName IN ('GDDV', 'PP'))
					SELECT TLNANME
					FROM TL_USER
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND DEP_ID = @DEP_CREATE
					AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'TBP', 'TP', 'PP'))
		END
		
		SET @FLAG = 7
	END
	---BDS thuê làm trụ sở CN/PGD - trưởng đơn vị đã duyệt, trả mail về cho ng tạo-----
	ELSE IF @TYPE='REAL_ESTATE_R_H_APPROVED'
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME) 
					(SELECT A.MAKER_ID FROM REAL_ESTATE_R_H A WHERE A.RET_R_H_ID = @PO_ID)
		SET @FLAG = 7
	END
	---BDS đang hoàn thiện thủ tục pháp lý - gửi YC phê duyệt-----
	ELSE IF @TYPE='REAL_ESTATE_L_C_SEND_APPROVE'
	BEGIN
		-----Có cấp phê duyệt trung gian-------
		IF (EXISTS (SELECT*FROM REAL_ESTATE_L_C WHERE RET_L_C_ID = @PO_ID AND SIGN_USER IS NOT NULL))
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME) 
					(SELECT A.SIGN_USER FROM REAL_ESTATE_L_C A WHERE A.RET_L_C_ID = @PO_ID) 
		END	
		ELSE
		-----Ko có cấp phê duyệt trung gian-------
		BEGIN
			SET @BRANCH_CREATE = (SELECT BRANCH_CREATE FROM REAL_ESTATE_L_C WHERE RET_L_C_ID = @PO_ID)
			SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
			SET @p_MAKER_ID = (SELECT MAKER_ID FROM REAL_ESTATE_L_C WHERE RET_L_C_ID = @PO_ID)
			SET @DEP_CREATE =(SELECT DEP_ID FROM TL_USER WHERE TLNANME = @p_MAKER_ID)
			IF(@BRANCH_TYPE = 'PGD')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						--SELECT TLNANME FROM TL_USER 
						--WHERE 1=1
						--AND TLSUBBRID = @BRANCH_CREATE
						--AND RoleName IN ('TPGD', 'PP')
						SELECT TLNANME
						FROM TL_USER
						WHERE 1=1
						AND TLSUBBRID = @BRANCH_CREATE
						AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('TPGD', 'PPGD'))
			END
			ELSE IF(@BRANCH_TYPE = 'CN')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						--SELECT TLNANME FROM TL_USER 
						--WHERE 1=1
						--AND TLSUBBRID = @BRANCH_CREATE
						--AND RoleName IN ('GDDV', 'PDG')
						SELECT TLNANME
						FROM TL_USER
						WHERE 1=1
						AND TLSUBBRID = @BRANCH_CREATE
						AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'PGD'))
			END
			ELSE IF(@BRANCH_TYPE = 'HS')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						--SELECT TLNANME FROM TL_USER 
						--WHERE 1=1
						--AND TLSUBBRID = @BRANCH_CREATE
						--AND DEP_ID = @DEP_CREATE
						--AND RoleName IN ('GDDV', 'PP')
						SELECT TLNANME
						FROM TL_USER
						WHERE 1=1
						AND TLSUBBRID = @BRANCH_CREATE
						AND DEP_ID = @DEP_CREATE
						AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'TBP', 'TP', 'PP'))
			END
		END
		SET @FLAG = 7
	END
	---BDS đang hoàn thiện thủ tục pháp lý - trung gian duyệt thành công-----
	ELSE IF @TYPE='REAL_ESTATE_L_C_CONFIRM'
	BEGIN
		SET @BRANCH_CREATE = (SELECT BRANCH_CREATE FROM REAL_ESTATE_L_C WHERE RET_L_C_ID = @PO_ID)
		SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
		SET @p_MAKER_ID = (SELECT MAKER_ID FROM REAL_ESTATE_L_C WHERE RET_L_C_ID = @PO_ID)
		SET @DEP_CREATE =(SELECT DEP_ID FROM TL_USER WHERE TLNANME = @p_MAKER_ID)
		IF(@BRANCH_TYPE = 'PGD')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
					--(SELECT TLNANME FROM TL_USER 
					--WHERE 1=1
					--AND TLSUBBRID = @BRANCH_CREATE
					--AND RoleName IN ('TPGD', 'PP'))
					SELECT TLNANME
					FROM TL_USER
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('TPGD', 'PPGD'))
		END
		ELSE IF(@BRANCH_TYPE = 'CN')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
					--(SELECT TLNANME FROM TL_USER 
					--WHERE 1=1
					--AND TLSUBBRID = @BRANCH_CREATE
					--AND RoleName IN ('GDDV', 'PDG'))
					SELECT TLNANME
					FROM TL_USER
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'PGD'))
		END
		ELSE IF(@BRANCH_TYPE = 'HS')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
					--(SELECT TLNANME FROM TL_USER 
					--WHERE 1=1
					--AND TLSUBBRID = @BRANCH_CREATE
					--AND DEP_ID = @DEP_CREATE
					--AND RoleName IN ('GDDV', 'PP'))
					SELECT TLNANME
					FROM TL_USER
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND DEP_ID = @DEP_CREATE
					AND EXISTS(SELECT * FROM TL_USER_GET_ROLES (TLNANME) WHERE ROLE_ID IN ('GDDV', 'TBP', 'TP', 'PP'))
		END
		
		SET @FLAG = 7
	END
	---BDS đang hoàn thiện thủ tục pháp lý - trưởng đơn vị đã duyệt, trả mail về cho ng tạo-----
	ELSE IF @TYPE='REAL_ESTATE_L_C_APPROVED'
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME) 
					(SELECT A.MAKER_ID FROM REAL_ESTATE_L_C A WHERE A.RET_L_C_ID = @PO_ID)
		SET @FLAG = 7
	END
	--PHONGNT 24/2/2022 PHIẾU YÊU CẦU CÔNG TÁC--
	---PHIẾU YÊU CẦU CÔNG TÁC - gửi YC phê duyệt---
	ELSE IF @TYPE='TR_REQUEST_JOB_FORM_SEND_APPROVE'
	BEGIN
		-----Có cấp phê duyệt trung gian-------
		IF (EXISTS (SELECT*FROM TR_REQUEST_JOB_FORM WHERE REQ_ID = @PO_ID AND SIGN_USER IS NOT NULL))
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME) 
					(SELECT A.SIGN_USER FROM TR_REQUEST_JOB_FORM A WHERE A.REQ_ID = @PO_ID) 
		END	
		ELSE
		-----Ko có cấp phê duyệt trung gian-------
		BEGIN
			SET @BRANCH_CREATE = (SELECT BRANCH_CREATE FROM TR_REQUEST_JOB_FORM WHERE REQ_ID = @PO_ID)
			SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
			SET @p_MAKER_ID = (SELECT MAKER_ID FROM TR_REQUEST_JOB_FORM WHERE @PO_ID = @PO_ID)
			SET @DEP_CREATE =(SELECT DEP_ID FROM TL_USER WHERE TLNANME = @p_MAKER_ID)
			IF(@BRANCH_TYPE = 'PGD')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						SELECT TLNANME FROM TL_USER 
						WHERE 1=1
						AND TLSUBBRID = @BRANCH_CREATE
						AND RoleName IN ('TPGD', 'PP')
			END
			ELSE IF(@BRANCH_TYPE = 'CN')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						SELECT TLNANME FROM TL_USER 
						WHERE 1=1
						AND TLSUBBRID = @BRANCH_CREATE
						AND RoleName IN ('GDDV', 'PDG')
			END
			ELSE IF(@BRANCH_TYPE = 'HS')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						SELECT TLNANME FROM TL_USER 
						WHERE 1=1
						AND TLSUBBRID = @BRANCH_CREATE
						AND DEP_ID = @DEP_CREATE
						AND RoleName IN ('GDDV', 'PP')
			END
		END
		SET @FLAG = 7
	END
	---Phiếu yêu cầu công tác - trung gian duyệt thành công-----
	ELSE IF @TYPE='TR_REQUEST_JOB_FORM_CONFIRM'
	BEGIN
		SET @BRANCH_CREATE = (SELECT BRANCH_CREATE FROM TR_REQUEST_JOB_FORM WHERE REQ_ID = @PO_ID)
		SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
		SET @p_MAKER_ID = (SELECT MAKER_ID FROM TR_REQUEST_JOB_FORM WHERE REQ_ID = @PO_ID)
		SET @DEP_CREATE =(SELECT DEP_ID FROM TL_USER WHERE TLNANME = @p_MAKER_ID)
		IF(@BRANCH_TYPE = 'PGD')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
					(SELECT TLNANME FROM TL_USER 
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND RoleName IN ('TPGD', 'PP'))
		END
		ELSE IF(@BRANCH_TYPE = 'CN')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
					(SELECT TLNANME FROM TL_USER 
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND RoleName IN ('GDDV', 'PDG'))
		END
		ELSE IF(@BRANCH_TYPE = 'HS')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
					(SELECT TLNANME FROM TL_USER 
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND DEP_ID = @DEP_CREATE
					AND RoleName IN ('GDDV', 'PP'))
		END
		
		SET @FLAG = 7
	END
	---Phiếu yêu cầu công tác - trưởng đơn vị đã duyệt, trả mail về cho ng tạo-----
	ELSE IF @TYPE='TR_REQUEST_JOB_FORM_APPROVED'
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME) 
					(SELECT A.MAKER_ID FROM TR_REQUEST_JOB_FORM A WHERE A.REQ_ID = @PO_ID)
		SET @FLAG = 7
	END
	--PHONGNT 24/2/2022 PHIẾU YÊU CẦU XE--
	---PHIẾU YÊU CẦU XE - gửi YC phê duyệt---
	ELSE IF @TYPE='TR_REQUEST_CAR_SEND_TDV'
	BEGIN
			SET @BRANCH_CREATE = (SELECT BRANCH_CREATE FROM TR_REQUEST_CAR WHERE REQ_ID = @PO_ID)
			SET @BRANCH_TYPE = (SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE)
			SET @p_MAKER_ID = (SELECT MAKER_ID FROM TR_REQUEST_CAR WHERE REQ_ID = @PO_ID)
			SET @DEP_CREATE =(SELECT DEP_ID FROM TL_USER WHERE TLNANME = @p_MAKER_ID)
			IF(@BRANCH_TYPE = 'PGD')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						SELECT TLNANME FROM TL_USER A
						JOIN AbpUserRoles B ON B.UserId = A.ID
						JOIN AbpRoles C ON C.Id=B.RoleId
						WHERE 1=1
						AND A.TLSUBBRID = @BRANCH_CREATE
						AND C.DisplayName IN ('TPGD', 'PPGD')
			END
			ELSE IF(@BRANCH_TYPE = 'CN')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
						SELECT TLNANME FROM TL_USER A
						JOIN AbpUserRoles B ON B.UserId = A.ID
						JOIN AbpRoles C ON C.Id=B.RoleId
						WHERE 1=1
						AND A.TLSUBBRID = @BRANCH_CREATE
						AND RoleName IN ('GDDV', 'PDG')
			END
			ELSE IF(@BRANCH_TYPE = 'HS')
			BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
						SELECT TLNANME FROM TL_USER A
						JOIN AbpUserRoles B ON B.UserId = A.ID
						JOIN AbpRoles C ON C.Id=B.RoleId
						WHERE 1=1
						AND A.TLSUBBRID = @BRANCH_CREATE
						AND A.DEP_ID = @DEP_CREATE
						AND RoleName IN ('GDDV', 'TP','TBP','PP')
			END
		SET @FLAG = 7
	END
	---Phiếu yêu cầu xe - gửi mail cho người cập nhật phiếu-----
	ELSE IF @TYPE='TR_REQUEST_CAR_SEND_USERUPD'
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME) 
					(SELECT USER_UPDATE FROM TR_REQUEST_CAR  WHERE REQ_ID = @PO_ID) 
		SET @FLAG = 7
	END
	---Phiếu yêu cầu xe - gửi mail cho CVĐĐ Xe-----
	ELSE IF @TYPE='TR_REQUEST_CAR_SEND_CV'
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME) 
					(SELECT CDVAL FROM CM_ALLCODE  WHERE CDNAME = 'REQCAR') 
		SET @FLAG = 7
	END
	---Phiếu yêu cầu xe - gửi mail cho người tạo-----
	ELSE IF @TYPE='TR_REQUEST_CAR_COST_SEND_MAKER'
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME) 
					(SELECT MAKER_ID FROM TR_REQUEST_CAR  WHERE REQ_ID = @PO_ID) 
		SET @FLAG = 7
	END
	---Phiếu yêu cầu xe - CVĐĐ Xe đã duyệt, gửi mail cho Lãnh Đạo HC HO-----
	ELSE IF @TYPE='TR_REQUEST_CAR_COST_CV_App'
	BEGIN
		SET @BRANCH_CREATE = (SELECT BRANCH_CREATE FROM TR_REQUEST_CAR WHERE REQ_ID = @PO_ID)
		INSERT INTO @LST_USER_RECIVE (TLNAME)
					(SELECT TLNANME FROM TL_USER 
					WHERE 1=1
					AND TLSUBBRID = @BRANCH_CREATE
					AND RoleName IN ('GDDV', 'PP'))
		SET @FLAG = 7
	END
	---Phiếu yêu cầu xe - Gửi CV và người tạo-----
	ELSE IF @TYPE='TR_REQUEST_CAR_SEND_CV_USER'
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME) 
					(SELECT MAKER_ID FROM TR_REQUEST_CAR  WHERE REQ_ID = @PO_ID) 
		INSERT INTO @LST_USER_RECIVE (TLNAME) 
					(SELECT USER_UPDATE FROM TR_REQUEST_CAR  WHERE REQ_ID = @PO_ID) 
		SET @FLAG = 7
	END
	--DUYHD 18/07/2022 Phiếu đề nghị thanh toán - KT--
	---Phiếu đề nghị thanh toán- KT - gửi mail cho người tạo-----
	ELSE IF @TYPE='REQ_PAYMENT_KT_SEND_MAKER'
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME) 
					(SELECT MAKER_ID FROM TR_REQ_PAYMENT  WHERE REQ_PAY_ID = @PO_ID) 
		INSERT INTO @LST_USER_RECIVE (TLNAME) 
					(SELECT TLNANME FROM TL_USER WHERE RoleName = 'TGD') 
		SET @FLAG = 8
	END
	---Phiếu đề nghị tạm ứng- KT - gửi mail cho người tạo-----
	ELSE IF @TYPE='REQ_ADVANCE_PAYMENT_KT_SEND_MAKER'
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME) 
					(SELECT MAKER_ID FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_ID = @PO_ID) 
		SET @FLAG = 8
	END
	--START PHUCVH 06/01/22 GẮN MAIL: ---- PYC: DC,SC,TH,CP ---- SỬA CHỮA TÀI SẢN	---- THU HỒI TÀI SẢN ---- ĐIỀU CHUYỂN NỘI BỘ ---- ĐIỀU CHUYỂN ---- XUẤT SD	---- NHẬP MỚI  ----Thanh Lý
	--PHIẾU YÊU CẦU ĐIỀU CHUYỂN, SỬA CHỮA, THU HỒI
	
	---------------PHIẾU YÊU CẦU ---------------
	
	ELSE IF(@TYPE='PYC_VB_CONFIRM_APPROVE')
	BEGIN
		SET @PROCESS = (SELECT TOP 1 PROCESS_ID FROM PL_REQUEST_PROCESS WHERE REQ_ID = @PO_ID AND STATUS = 'C')
			
		IF(@PROCESS = 'APPROVE')
		BEGIN --PHIẾU DUYỆT HOÀN TẤT. GỬI MAIL BỘ PHẬN QLTS
			SELECT TOP 1 @TLFullName_USER_CREATE = B.TLFullName, @Email_USER_CREATE = B.EMAIL, @USER_CREATE_ID = B.ID
			FROM TR_REQUEST_SHOP_DOC A
			LEFT JOIN TL_USER B ON A.MAKER_ID = B.TLNANME
			WHERE REQ_ID = @PO_ID
			INSERT INTO @LST_USER_RECIVE_PYC(TLFullName,Email,USER_ID)
			VALUES('',(SELECT TOP 1 ParaValue FROM SYS_PARAMETERS WHERE ParaKey = 'EMAIL_QLTS_VB'),0),
			(@TLFullName_USER_CREATE,@Email_USER_CREATE,@USER_CREATE_ID)
			
			SET @FLAG = 10
		END
		ELSE IF(@PROCESS = 'CANCEL' OR @PROCESS = 'REJECT')
		BEGIN --PHIẾU BỊ HUỶ HOẶC TRẢ VỀ THÌ GỬI MAIL VỀ CHO NGƯỜI TẠO
			INSERT INTO @LST_USER_RECIVE (TLNAME)
			SELECT MAKER_ID FROM TR_REQUEST_SHOP_DOC WHERE REQ_ID = @PO_ID
			SET @FLAG = 6
		END
		ELSE
		BEGIN --PHIẾU ĐANG XỬ LÝ -> GỬI TDV, DVCM, GDDV DVCM, TBP, TDV QLTS, TTDVNB
			DECLARE @combinedString VARCHAR(MAX)
			IF(((SELECT STATUS FROM TR_REQUEST_SHOP_DOC WHERE REQ_ID = @PO_ID) <> 'DVCM') 
				OR ((SELECT STATUS FROM TR_REQUEST_SHOP_DOC WHERE REQ_ID = @PO_ID) = 'DVCM' AND NOT EXISTS(SELECT 1 FROM PL_REQUEST_PROCESS WHERE REQ_ID = @PO_ID AND STATUS = 'C' AND PROCESS_ID = 'DVCM_D')))
			BEGIN
				SELECT @combinedString = COALESCE(@combinedString + ',', '') +
										(CASE WHEN PL.PROCESS_ID = 'APPROVE' OR PL.PROCESS_ID = 'DONE' THEN NULL
                              				ELSE (SELECT  TOP 1 TLNANME = STUFF(
													(SELECT ',' + TLNANME FROM dbo.FN_GET_USER_BY_ROLE_VB(PL.ROLE_USER,PL.BRANCH_ID,PL.DEP_ID) GROUP BY TLNANME FOR XML PATH ('')), 1, 1, '') 
													FROM dbo.FN_GET_USER_BY_ROLE_VB(PL.ROLE_USER,PL.BRANCH_ID,PL.DEP_ID) A)
											END)
									FROM PL_REQUEST_PROCESS PL 
									WHERE PL.STATUS = 'C' AND PL.REQ_ID = @PO_ID
			END
			ELSE
			BEGIN
				SELECT @combinedString = COALESCE(@combinedString + ',', '') +
						(CASE WHEN PL.PROCESS_ID = 'APPROVE' OR PL.PROCESS_ID = 'DONE' THEN NULL
                            ELSE (SELECT  TOP 1 TLNANME = STUFF(
									(SELECT ',' + TLNANME FROM dbo.FN_GET_USER_BY_ROLE_VB(PL.ROLE_USER,PL.BRANCH_ID,PL.DEP_ID) GROUP BY TLNANME FOR XML PATH ('')), 1, 1, '') 
									FROM dbo.FN_GET_USER_BY_ROLE_VB(PL.ROLE_USER,PL.BRANCH_ID,PL.DEP_ID) A)
							END)
					FROM PL_REQUEST_PROCESS PL 
					WHERE PL.REQ_ID = @PO_ID
					--AND PL.CHECKER_ID = @p_TLNAME 
					AND PL.PROCESS_ID = 'DVCM_D'
					AND PL.DEP_ID IN (SELECT DEP_ID FROM TL_USER WHERE TLNANME = @p_TLNAME)
			END
			INSERT INTO @LST_USER_RECIVE (TLNAME)
			SELECT VALUE 
			FROM STRING_SPLIT(@combinedString,',')
			GROUP BY VALUE
			SET @FLAG = 6
		END
	END
	
	---------------ĐIỀU CHUYỂN TÀI SẢN NỘI BỘ ---------------
	
	--ĐIỀU CHUYỂN TÀI SẢN NỘI BỘ
	ELSE IF(@TYPE = 'ASS_PRIVATE_TRANSFER_MASTER_SendAppr')
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME)
		SELECT VALUE 
		FROM STRING_SPLIT((SELECT DISTINCT (SELECT  TOP 1 TLNANME = STUFF(
										(SELECT ',' + TLNANME FROM dbo.FN_GET_USER_BY_ROLE_VB('GDDV,GDDV_QLTS,KSV_QLTS,TBP_QLTS',PL.BRANCH_ID,PL.DEPT_CREATE) GROUP BY TLNANME FOR XML PATH ('')), 1, 1, '') 
									FROM dbo.FN_GET_USER_BY_ROLE_VB('GDDV,GDDV_QLTS,KSV_QLTS,TBP_QLTS',PL.BRANCH_ID,PL.DEPT_CREATE) A) AS TLNAME
							FROM ASS_PRIVATE_TRANSFER_MASTER PL
							WHERE PL.TRANS_MULTI_MASTER_ID = @PO_ID),',')
		GROUP BY VALUE
		SET @FLAG = 6
	END
	--ĐIỀU CHUYỂN TÀI SẢN NỘI BỘ - TDV DUYỆT HOÀN TẤT => GỬI CHO NGƯỜI TẠO
	ELSE IF(@TYPE = 'ASS_PRIVATE_TRANSFER_MASTER_App_SEND_USERCREATE')
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME)
		SELECT MAKER_ID FROM ASS_PRIVATE_TRANSFER_MASTER WHERE TRANS_MULTI_MASTER_ID = @PO_ID
		SET @FLAG = 6
	END
	
	---------------SỬA CHỮA NHIỀU TÀI SẢN ---------------
	
	--SỬA CHỮA NHIỀU TÀI SẢN
	ELSE IF(@TYPE = 'ASS_REPAIR_MULTI_MASTER_SendAppr')
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME)
		SELECT VALUE 
		FROM STRING_SPLIT((SELECT DISTINCT (SELECT  TOP 1 TLNANME = STUFF(
										(SELECT ',' + TLNANME FROM dbo.FN_GET_USER_BY_ROLE_VB('GDDV,GDDV_QLTS,KSV_QLTS,TBP_QLTS',B.TLSUBBRID,B.DEP_ID) GROUP BY TLNANME FOR XML PATH ('')), 1, 1, '') 
									FROM dbo.FN_GET_USER_BY_ROLE_VB('GDDV,GDDV_QLTS,KSV_QLTS,TBP_QLTS',B.TLSUBBRID,B.DEP_ID) A) AS TLNAME
							FROM ASS_REPAIR_MULTI_MASTER PL
							LEFT JOIN TL_USER B ON PL.MAKER_ID = B.TLNANME
							WHERE PL.REPAIR_MUL_ID = @PO_ID),',')
		GROUP BY VALUE
		SET @FLAG = 6
	END
	--SỬA CHỮA NHIỀU TÀI SẢN - TDV DUYỆT HOÀN TẤT PHIẾU => GỬI CHO NGƯỜI TẠO
	ELSE IF(@TYPE = 'ASS_REPAIR_MULTI_MASTER_App_SEND_USERCREATE')
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME)
		SELECT MAKER_ID FROM ASS_REPAIR_MULTI_MASTER WHERE REPAIR_MUL_ID = @PO_ID
		SET @FLAG = 6
	END
	
	---------------THU HỒI TÀI SẢN ---------------
	
	--THU HỒI TÀI SẢN - QLTS (GỬI MAIL CHO GDDV_QLTS DUYỆT)
	ELSE IF(@TYPE = 'ASS_COLLECT_MULTI_MASTER_SendAppr')
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME)
		SELECT VALUE 
		FROM STRING_SPLIT((SELECT DISTINCT (SELECT  TOP 1 TLNANME = STUFF(
										(SELECT ',' + TLNANME FROM dbo.FN_GET_USER_BY_ROLE_VB('TBP_QLTS,KSV_QLTS,GDDV_QLTS',B.TLSUBBRID,B.DEP_ID) GROUP BY TLNANME FOR XML PATH ('')), 1, 1, '') 
									FROM dbo.FN_GET_USER_BY_ROLE_VB('TBP_QLTS,KSV_QLTS,GDDV_QLTS',B.TLSUBBRID,B.DEP_ID) A) AS TLNAME
							FROM ASS_COLLECT_MULTI_MASTER PL
							LEFT JOIN TL_USER B ON PL.MAKER_ID = B.TLNANME
							WHERE PL.COL_MULTI_MASTER_ID = @PO_ID),',')
		GROUP BY VALUE
		SET @FLAG = 6
	END
	--THU HỒI TÀI SẢN - XÁC NHẬN BÀN GIAO TÀI SẢN THU HỒI (GỬI MAIL CHO GDDV_QLTS CỦA TÀI SẢN CẦN THU HỒI) VÀ GỬI MAIL CHO NGƯỜI TẠO
	ELSE IF(@TYPE = 'ASS_COLLECT_MULTI_MASTER_App')
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME)
		SELECT VALUE 
		FROM STRING_SPLIT((SELECT DISTINCT (SELECT  TOP 1 TLNANME = STUFF(
										(SELECT ',' + TLNANME FROM dbo.FN_GET_USER_BY_ROLE_VB('GDDV,GDDV_QLTS,KSV_QLTS,TBP_QLTS',PL.BRANCH_ID,PL.DEPT_ID_USE) GROUP BY TLNANME FOR XML PATH ('')), 1, 1, '') 
									FROM dbo.FN_GET_USER_BY_ROLE_VB('GDDV,GDDV_QLTS,KSV_QLTS,TBP_QLTS',PL.BRANCH_ID,PL.DEPT_ID_USE) A) AS TLNAME
							FROM ASS_COLLECT_MULTI_DT PL
							WHERE PL.COL_MULTI_MASTER_ID = @PO_ID),',')
		GROUP BY VALUE
		--GỬI CHO NGƯỜI TẠO
		INSERT INTO @LST_USER_RECIVE
		VALUES((SELECT TOP 1 MAKER_ID FROM ASS_COLLECT_MULTI_MASTER WHERE COL_MULTI_MASTER_ID = @PO_ID))
		SET @FLAG = 6
	END
	--THU HỒI TÀI SẢN - KẾ TOÁN NHẬP (CẬP NHẬT HẠCH TOÁN)
	ELSE IF(@TYPE = 'ASS_COLLECT_CONFIRM_MASTER_Ins')
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME)
		SELECT TLNANME FROM dbo.FN_GET_USER_BY_ROLE_VB('GDV',@BRANCH_QLTS,@DEP_KT) GROUP BY TLNANME
		--SELECT TLNANME FROM dbo.FN_GET_USER_BY_ROLE_VB('GDV','','') GROUP BY TLNANME
		SET @FLAG = 6
	END
	--THU HỒI TÀI SẢN - TDV XÁC NHẬN => GỬI MAIL NGƯỜI TẠO
	--ELSE IF(@TYPE = 'ASS_COLLECT_CONFIRM_MASTER_Ins_SEND_USERCREATE')
	--BEGIN
	--	INSERT INTO @LST_USER_RECIVE (TLNAME)
	--	SELECT MAKER_ID FROM ASS_COLLECT_MULTI_MASTER WHERE COL_MULTI_MASTER_ID = @PO_ID
	--	SET @FLAG = 6
	--END
	--THU HỒI TÀI SẢN - KT (DUYỆT) (GDV GỬI KSV PHÊ DUYỆT)
	ELSE IF(@TYPE = 'ASS_COLLECT_MULTI_KT_SendAppr_KT')
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME)
		SELECT TLNANME FROM dbo.FN_GET_USER_BY_ROLE_VB('KSV',@BRANCH_QLTS,@DEP_KT) GROUP BY TLNANME
		--SELECT TLNANME FROM dbo.FN_GET_USER_BY_ROLE_VB('KSV','','') GROUP BY TLNANME
		SET @FLAG = 6
	END
	
	---------------XUẤT SỬ DỤNG TÀI SẢN ---------------
	
	--XUẤT SỬ DỤNG TÀI SẢN - QLTS (QLTS GỬI GDDV_QLTS PHÊ DUYỆT)
	ELSE IF(@TYPE = 'ASS_USE_MUILTI_MASTER_SendAppr')
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME)
		SELECT VALUE 
		FROM STRING_SPLIT((SELECT DISTINCT (SELECT  TOP 1 TLNANME = STUFF(
										(SELECT ',' + TLNANME FROM dbo.FN_GET_USER_BY_ROLE_VB('TBP_QLTS,KSV_QLTS,GDDV_QLTS,GDDV',PL.BRANCH_CREATE,PL.DEPT_CREATE) GROUP BY TLNANME FOR XML PATH ('')), 1, 1, '') 
									FROM dbo.FN_GET_USER_BY_ROLE_VB('TBP_QLTS,KSV_QLTS,GDDV_QLTS,GDDV',PL.BRANCH_CREATE,PL.DEPT_CREATE) A) AS TLNAME
							FROM ASS_USE_MULTI_MASTER PL
							WHERE PL.USER_MASTER_ID = @PO_ID),',')
		GROUP BY VALUE
		SET @FLAG = 6
	END
	--XUẤT SỬ DỤNG TÀI SẢN - XÁC NHẬN XUẤT SỬ DỤNG TÀI SẢN (GỬI MAIL CHO GDDV NHẬN TÀI SẢN) VÀ GỬI CHO NGƯỜI TẠO
	ELSE IF(@TYPE = 'ASS_USE_MULTI_BVB_MASTER_App')
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME)
		SELECT VALUE 
		FROM STRING_SPLIT((SELECT DISTINCT (SELECT  TOP 1 TLNANME = STUFF(
										(SELECT ',' + TLNANME FROM dbo.FN_GET_USER_BY_ROLE_VB('GDDV,GDDV_QLTS,KSV_QLTS,TBP_QLTS',PL.BRANCH_ID,PL.DEP_ID) GROUP BY TLNANME FOR XML PATH ('')), 1, 1, '') 
									FROM dbo.FN_GET_USER_BY_ROLE_VB('GDDV,GDDV_QLTS,KSV_QLTS,TBP_QLTS',PL.BRANCH_ID,PL.DEP_ID) A) AS TLNAME
							FROM ASS_USE_MULTI_MASTER PL
							WHERE PL.USER_MASTER_ID = @PO_ID),',')
		GROUP BY VALUE
		--GỬI CHO NGƯỜI TẠO
		INSERT INTO @LST_USER_RECIVE (TLNAME)
		VALUES ((SELECT TOP 1 MAKER_ID FROM ASS_USE_MULTI_MASTER WHERE USER_MASTER_ID = @PO_ID))
		SET @FLAG = 6
	END
	--XUẤT SỬ DỤNG TÀI SẢN - TDV XÁC NHẬN => GỬI MAIL CHO NGƯỜI TẠO
	--ELSE IF(@TYPE = 'ASS_USE_CONFIRM_MASTER_Ins_SEND_USERCREATE')
	--BEGIN
	--		INSERT INTO @LST_USER_RECIVE (TLNAME)
	--		SELECT MAKER_ID FROM ASS_USE_MULTI_MASTER WHERE USER_MASTER_ID = @PO_ID
	--		SET @FLAG = 6
	--END
	--XUẤT SỬ DỤNG TÀI SẢN - KT DUYỆT HOÀN TẤT => GỬI MAIL CHO NGƯỜI TẠO
	ELSE IF(@TYPE = 'ASS_USE_MULTI_BVB_KT_App')
	BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
			SELECT MAKER_ID FROM ASS_USE_MULTI_MASTER WHERE USER_MASTER_ID = @PO_ID
			SET @FLAG = 6
	END
	--XUẤT SỬ DỤNG TÀI SẢN - KẾ TOÁN NHẬP (CẬP NHẬT HẠCH TOÁN)
	ELSE IF(@TYPE = 'ASS_USE_CONFIRM_MASTER_Ins')
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME)
		SELECT TLNANME FROM dbo.FN_GET_USER_BY_ROLE_VB('GDV',@BRANCH_QLTS,@DEP_KT) GROUP BY TLNANME
		--SELECT TLNANME FROM dbo.FN_GET_USER_BY_ROLE_VB('GDV','','') GROUP BY TLNANME
		SET @FLAG = 6
	END
	--XUẤT SỬ DỤNG TÀI SẢN - KT(DUYỆT) (GDV GỬI KSV PHÊ DUYỆT)
	ELSE IF(@TYPE = 'ASS_USE_MUILTI_MASTER_SendAppr_KT')
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME)
		SELECT TLNANME FROM dbo.FN_GET_USER_BY_ROLE_VB('KSV',@BRANCH_QLTS,@DEP_KT) GROUP BY TLNANME
		--SELECT TLNANME FROM dbo.FN_GET_USER_BY_ROLE_VB('KSV','','') GROUP BY TLNANME
		SET @FLAG = 6
	END
	
	---------------NHẬP MỚI TÀI SẢN ---------------
	--NHẬP MỚI TÀI SẢN - QLTS (QLTS GỬI GDDV_QLTS PHÊ DUYỆT)
	ELSE IF(@TYPE = 'ASS_ADDNEW_BVB_SendAppr')
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME)
		SELECT VALUE 
		FROM STRING_SPLIT((SELECT DISTINCT (SELECT  TOP 1 TLNANME = STUFF(
										(SELECT ',' + TLNANME FROM dbo.FN_GET_USER_BY_ROLE_VB('TBP_QLTS,KSV_QLTS,GDDV_QLTS,GDDV',PL.BRANCH_CREATE,PL.DEPT_CREATE) GROUP BY TLNANME FOR XML PATH ('')), 1, 1, '') 
									FROM dbo.FN_GET_USER_BY_ROLE_VB('TBP_QLTS,KSV_QLTS,GDDV_QLTS,GDDV',PL.BRANCH_CREATE,PL.DEPT_CREATE) A) AS TLNAME
							FROM ASS_ADDNEW PL
							WHERE PL.ADDNEW_ID = @PO_ID),',')
		GROUP BY VALUE
		SET @FLAG = 6
	END
	--NHẬP MỚI TÀI SẢN - KẾ TOÁN NHẬP (CẬP NHẬT HẠCH TOÁN)
	ELSE IF(@TYPE = 'ASS_ADDNEW_QLTS_Appr')
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME)
		SELECT TLNANME FROM dbo.FN_GET_USER_BY_ROLE_VB('GDV',@BRANCH_QLTS,@DEP_KT) GROUP BY TLNANME
		--SELECT TLNANME FROM dbo.FN_GET_USER_BY_ROLE_VB('GDV','','') GROUP BY TLNANME
		SET @FLAG = 6
	END
	--NHẬP MỚI TÀI SẢN - KT(DUYỆT) (GDV GỬI KSV PHÊ DUYỆT)
	ELSE IF(@TYPE = 'ASS_ADDNEW_KT_BVB_SendAppr')
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME)
		SELECT TLNANME FROM dbo.FN_GET_USER_BY_ROLE_VB('KSV',@BRANCH_QLTS,@DEP_KT) GROUP BY TLNANME
		--SELECT TLNANME FROM dbo.FN_GET_USER_BY_ROLE_VB('KSV','','') GROUP BY TLNANME
		SET @FLAG = 6
	END
	
	---------------ĐIỀU CHUYỂN TÀI SẢN ---------------
	
	--ĐIỀU CHUYỂN TÀI SẢN - QLTS (QLTS GỬI GDDV_QLTS PHÊ DUYỆT)
	ELSE IF(@TYPE = 'ASS_TRANSFER_MULTI_Master_SendAppr_S_TDV')
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME)
		SELECT VALUE 
		FROM string_split((SELECT B.TLNANME
				FROM (SELECT DISTINCT (CASE WHEN PL.PROCESS_ID = 'APPROVE' OR PL.PROCESS_ID = 'DONE' THEN NULL
                              						ELSE (SELECT  TOP 1 TLNANME = STUFF(
															(SELECT ',' + TLNANME FROM dbo.FN_GET_USER_BY_ROLE_VB(PL.ROLE_USER,PL.BRANCH_ID,PL.DEP_ID) GROUP BY TLNANME FOR XML PATH ('')), 1, 1, '') 
															FROM dbo.FN_GET_USER_BY_ROLE_VB(PL.ROLE_USER,PL.BRANCH_ID,PL.DEP_ID) A)
													END) AS TLNANME
											FROM PL_REQUEST_PROCESS PL
											WHERE PL.STATUS = 'C' AND PL.REQ_ID = @PO_ID) B
					GROUP BY B.TLNANME),',')
		SET @FLAG = 6
	END
	--ĐIỀU CHUYỂN TÀI SẢN - TDV GIAO NHẬN XÁC NHẬN => GỬI MAIL CHO NGƯỜI TẠO
	--ELSE IF(@TYPE = 'ASS_TRANSFER_MULTI_MASTER_SendAppr_SEND_USERCREATE')
	--BEGIN
	--	IF(EXISTS(SELECT TOP 1 '1'
	--				FROM ASS_TRANSFER_MULTI_MASTER A
	--				LEFT JOIN PL_REQUEST_PROCESS B ON A.TRANS_MULTI_MASTER_ID = B.REQ_ID
	--				WHERE B.PROCESS_ID = 'APPROVE' AND B.STATUS = 'C' AND A.AUTH_STATUS_KT = 'E' AND A.TRANS_MULTI_MASTER_ID = @PO_ID))
	--	BEGIN
	--		INSERT INTO @LST_USER_RECIVE (TLNAME)
	--		SELECT MAKER_ID FROM ASS_TRANSFER_MULTI_MASTER WHERE TRANS_MULTI_MASTER_ID = @PO_ID
	--	END
	--	SET @FLAG = 6
	--END
	--ĐIỀU CHUYỂN TÀI SẢN - KT DUYỆT HOÀN TẤT PHIẾU => GỬI MAIL CHO NGƯỜI TẠO
	ELSE IF(@TYPE = 'ASS_TRANSFER_MULTI_MASTER_KT_App_SEND_USERCREATE')
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME)
		SELECT MAKER_ID FROM ASS_TRANSFER_MULTI_MASTER WHERE TRANS_MULTI_MASTER_ID = @PO_ID
		SET @FLAG = 6
	END
	--ĐIỀU CHUYỂN TÀI SẢN - XÁC NHẬN CỦA BÊN GIAO/NHẬN OR TTDVNB DUYỆT VÀ NGƯỜI TẠO
	ELSE IF(@TYPE = 'ASS_TRANSFER_MULTI_MASTER_APP')
	BEGIN		
		SELECT @combinedString = COALESCE(@combinedString + ',', '') +
											(CASE WHEN PL.PROCESS_ID = 'APPROVE' OR PL.PROCESS_ID = 'DONE' THEN NULL
                              							ELSE (SELECT  TOP 1 TLNANME = STUFF(
																(SELECT ',' + TLNANME FROM dbo.FN_GET_USER_BY_ROLE_VB(PL.ROLE_USER,PL.BRANCH_ID,PL.DEP_ID) GROUP BY TLNANME FOR XML PATH ('')), 1, 1, '') 
																FROM dbo.FN_GET_USER_BY_ROLE_VB(PL.ROLE_USER,PL.BRANCH_ID,PL.DEP_ID) A)
														END)
												FROM PL_REQUEST_PROCESS PL
												WHERE PL.STATUS = 'C' AND PL.REQ_ID = @PO_ID
		INSERT INTO @LST_USER_RECIVE (TLNAME)
		SELECT VALUE 
		FROM string_split(@combinedString,',')
		INSERT INTO @LST_USER_RECIVE (TLNAME)
		VALUES((SELECT TOP 1 MAKER_ID FROM ASS_TRANSFER_MULTI_MASTER WHERE TRANS_MULTI_MASTER_ID = @PO_ID))
		SET @FLAG = 6
	END
	--ĐIỀU CHUYỂN TÀI SẢN - GỬI CHO KẾ TOÁN NHẬP (CẬP NHẬT HẠCH TOÁN) 
	ELSE IF(@TYPE = 'ASS_TRANSFER_MULTI_Master_SendAppr_CONFIRM')
	BEGIN  
		  IF(NOT EXISTS(SELECT 1 FROM PL_REQUEST_PROCESS prp WHERE prp.REQ_ID = @PO_ID AND prp.PROCESS_ID = 'XNGN' AND prp.STATUS = 'C'))
		  BEGIN
				--CODE ĐÃ THÊM VÀO FLOW (TẤT CẢ CÁC TDV XÁC NHẬN GIAO NHẬN INSERT VÀO PL_REQUEST_PROCESS ĐẾN BƯỚC GDV)
				INSERT INTO @LST_USER_RECIVE (TLNAME)
				SELECT TLNANME FROM dbo.FN_GET_USER_BY_ROLE_VB('GDV',@BRANCH_QLTS,@DEP_KT) GROUP BY TLNANME
				--SELECT TLNANME FROM dbo.FN_GET_USER_BY_ROLE_VB('GDV','','') GROUP BY TLNANME
				SET @FLAG = 6
		  END
	END
	--ĐIỀU CHUYỂN TÀI SẢN - KT(DUYỆT) (GDV GỬI KSV DUYỆT) 
	ELSE IF(@TYPE = 'ASS_TRANSFER_MULTI_Master_SendAppr_KT')
	BEGIN		
		INSERT INTO @LST_USER_RECIVE (TLNAME)
		SELECT TLNANME FROM dbo.FN_GET_USER_BY_ROLE_VB('KSV',@BRANCH_QLTS,@DEP_KT) GROUP BY TLNANME
		--SELECT TLNANME FROM dbo.FN_GET_USER_BY_ROLE_VB('KSV','','') GROUP BY TLNANME
		SET @FLAG = 6
	END
	---------------THANH LÝ TÀI SẢN ---------------
	--THANH LÝ TÀI SẢN - QLTS (GỬI MAIL CHO GDDV_QLTS DUYỆT)
	ELSE IF(@TYPE = 'ASS_LIQUIDATION_BVB_SendAppr')
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME)
		SELECT VALUE 
		FROM STRING_SPLIT((SELECT DISTINCT (SELECT  TOP 1 TLNANME = STUFF(
										(SELECT ',' + TLNANME FROM dbo.FN_GET_USER_BY_ROLE_VB('TBP_QLTS,KSV_QLTS,GDDV_QLTS,GDDV',B.TLSUBBRID,B.DEP_ID) GROUP BY TLNANME FOR XML PATH ('')), 1, 1, '') 
									FROM dbo.FN_GET_USER_BY_ROLE_VB('TBP_QLTS,KSV_QLTS,GDDV_QLTS,GDDV',B.TLSUBBRID,B.DEP_ID) A) AS TLNAME
							FROM ASS_LIQUIDATION PL
							LEFT JOIN TL_USER B ON PL.MAKER_ID = B.TLNANME
							WHERE PL.LIQ_ID = @PO_ID),',')
		GROUP BY VALUE
		SET @FLAG = 6
	END
	--THANH LÝ TÀI SẢN - KẾ TOÁN NHẬP (CẬP NHẬT HẠCH TOÁN)
	ELSE IF(@TYPE = 'ASS_LIQUIDATION_BVB_App')
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME)
		SELECT TLNANME FROM dbo.FN_GET_USER_BY_ROLE_VB('GDV',@BRANCH_QLTS,@DEP_KT) GROUP BY TLNANME
		--SELECT TLNANME FROM dbo.FN_GET_USER_BY_ROLE_VB('GDV','','') GROUP BY TLNANME
		SET @FLAG = 6
	END
	--THANH LÝ TÀI SẢN - KT (DUYỆT) (GDV GỬI KSV PHÊ DUYỆT)
	ELSE IF(@TYPE = 'ASS_LIQUIDATION_BVB_KT_SendAppr')
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME)
		SELECT TLNANME FROM dbo.FN_GET_USER_BY_ROLE_VB('KSV',@BRANCH_QLTS,@DEP_KT) GROUP BY TLNANME
		--SELECT TLNANME FROM dbo.FN_GET_USER_BY_ROLE_VB('KSV','','') GROUP BY TLNANME
		SET @FLAG = 6
	END
	--THANH LÝ TÀI SẢN - KT DUYỆT HOÀN TẤT PHIẾU => GỬI CHO NGƯỜI TẠO
	ELSE IF(@TYPE = 'ASS_LIQUIDATION_BVB_KT_App_SEND_USERCREATE')
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME)
		SELECT MAKER_ID FROM ASS_LIQUIDATION WHERE LIQ_ID = @PO_ID
		SET @FLAG = 6
	END
	--KIỂM KÊ TÀI SẢN - GỬI DUYỆT
	ELSE IF(@TYPE = 'ASS_INVENTORY_SendApp')
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME)
		SELECT ROLE_USER FROM PL_REQUEST_PROCESS WHERE REQ_ID = @PO_ID AND STATUS = 'C'
		SET @FLAG = 6
	END
	--KIỂM KÊ TÀI SẢN - GỬI XÁC NHẬN
	ELSE IF(@TYPE = 'ASS_INVENTORY_MASTER_DVKD_APP')
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME)
		SELECT ROLE_USER FROM PL_REQUEST_PROCESS WHERE REQ_ID = @PO_ID AND STATUS = 'C'
		SET @FLAG = 6
	END
	--KIỂM KÊ TÀI SẢN - THÀNH PHẦN KIỂM KÊ XÁC NHẬN
	ELSE IF(@TYPE = 'ASS_INVENTORY_MASTER_APPROVE_CONFIRM')
	BEGIN
		IF(EXISTS(SELECT 1 FROM PL_REQUEST_PROCESS WHERE REQ_ID = @PO_ID AND PROCESS_ID = 'TBKK' AND STATUS = 'C'))
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
			SELECT ROLE_USER FROM PL_REQUEST_PROCESS WHERE REQ_ID = @PO_ID AND STATUS = 'C'
			SET @FLAG = 6
		END
	END
	--KIỂM KÊ TÀI SẢN - TRƯỞNG BAN KIỂM KÊ DUYỆT
	ELSE IF(@TYPE = 'ASS_INVENTORY_App')
	BEGIN
		INSERT INTO @LST_USER_RECIVE (TLNAME)
		SELECT MAKER_ID FROM ASS_INVENTORY_MASTER WHERE INVENT_ID = @PO_ID
		SET @FLAG = 6
	END
	--ĐỀ XUẤT THANH LÝ TÀI SẢN
	ELSE IF(@TYPE = 'ASS_LIQ_REQUEST_App')
	BEGIN
		DECLARE @combinedString1 VARCHAR(MAX),@TL_NAME VARCHAR(5000)
		SELECT @TL_NAME = CASE 
					WHEN A.AUTH_STATUS = 'A' THEN A.MAKER_ID -- TRẢ VỀ NGƯỜI TẠO
					WHEN EXISTS(SELECT 1 FROM CM_REQUEST_PROCESS E WHERE A.LIQ_REQ_ID = E.REQ_ID AND E.STATUS = 'G' AND E.DONE = 0 AND A.AUTH_STATUS = 'E') THEN --GDDV-DVCM TRẢ VỀ NHÂN VIÊN DVCM
													(SELECT TOP 1 E.CHECKER_ID FROM CM_REQUEST_PROCESS E WHERE E.REQ_ID = A.LIQ_REQ_ID AND E.STATUS = 'F' AND E.DONE = 1 AND E.BRANCH_ID = @BRANCH_LOGIN AND E.DEPT_ID = @DEP_LOGIN)
					WHEN EXISTS(SELECT 1 FROM CM_REQUEST_PROCESS E WHERE A.LIQ_REQ_ID = E.REQ_ID AND E.STATUS IN ('H','K','L') AND E.DONE = 0 AND A.AUTH_STATUS = 'E') THEN 'DVCM' --CÁC BƯỚC TRÊN TRẢ VỀ DVCM													
					WHEN EXISTS(SELECT 1 FROM CM_REQUEST_PROCESS E WHERE A.LIQ_REQ_ID = E.REQ_ID AND E.STATUS IN ('G','H','K','L') AND E.DONE = 0 AND A.AUTH_STATUS = 'C') THEN 
													(SELECT TOP 1 E.CHECKER_ID FROM CM_REQUEST_PROCESS E WHERE E.REQ_ID = A.LIQ_REQ_ID AND E.STATUS = 'E' AND E.DONE = 1)
					WHEN A.AUTH_STATUS = 'B' THEN (SELECT  TOP 1 TLNANME = STUFF(
														(SELECT ',' + TLNANME FROM dbo.FN_GET_USER_BY_ROLE_VB('GDDV',A.BRANCH_ID,A.DEP_ID) GROUP BY TLNANME FOR XML PATH ('')), 1, 1, '') 
													FROM dbo.FN_GET_USER_BY_ROLE_VB('GDDV',A.BRANCH_ID,A.DEP_ID) B)  
					WHEN A.AUTH_STATUS = 'C' THEN (SELECT  TOP 1 TLNANME = STUFF(
														(SELECT ',' + TLNANME FROM dbo.FN_GET_USER_BY_ROLE_VB('QLTS','DV0001','DEP000000000048') GROUP BY TLNANME FOR XML PATH ('')), 1, 1, '') 
													FROM dbo.FN_GET_USER_BY_ROLE_VB('QLTS','DV0001','DEP000000000048') B)  
					WHEN A.AUTH_STATUS = 'E' AND EXISTS(SELECT TOP 1 1 FROM TR_REQUEST_SHOP_COSTCENTER WHERE REQ_ID = @PO_ID) THEN N'DVCM' 
					WHEN A.AUTH_STATUS = 'E' AND NOT EXISTS(SELECT TOP 1 1 FROM TR_REQUEST_SHOP_COSTCENTER WHERE REQ_ID = @PO_ID) THEN (SELECT  TOP 1 TLNANME = STUFF(
														(SELECT ',' + TLNANME FROM dbo.FN_GET_USER_BY_ROLE_VB('QLTS','DV0001','DEP000000000048') GROUP BY TLNANME FOR XML PATH ('')), 1, 1, '') 
													FROM dbo.FN_GET_USER_BY_ROLE_VB('QLTS','DV0001','DEP000000000048') B)  
					WHEN A.AUTH_STATUS = 'F' THEN N'GDDV_DVCM'  
					WHEN A.AUTH_STATUS = 'G' THEN (SELECT  TOP 1 TLNANME = STUFF(
														(SELECT ',' + TLNANME FROM dbo.FN_GET_USER_BY_ROLE_VB('QLTS','DV0001','DEP000000000048') GROUP BY TLNANME FOR XML PATH ('')), 1, 1, '') 
													FROM dbo.FN_GET_USER_BY_ROLE_VB('QLTS','DV0001','DEP000000000048') B) 
					WHEN A.AUTH_STATUS = 'H' THEN (SELECT  TOP 1 TLNANME = STUFF(
														(SELECT ',' + TLNANME FROM dbo.FN_GET_USER_BY_ROLE_VB('TBP_QLTS','DV0001','DEP000000000048') GROUP BY TLNANME FOR XML PATH ('')), 1, 1, '') 
													FROM dbo.FN_GET_USER_BY_ROLE_VB('TBP_QLTS','DV0001','DEP000000000048') B)     
					WHEN A.AUTH_STATUS = 'K' THEN (SELECT  TOP 1 TLNANME = STUFF(
														(SELECT ',' + TLNANME FROM dbo.FN_GET_USER_BY_ROLE_VB('GDDV','DV0001','DEP000000000048') GROUP BY TLNANME FOR XML PATH ('')), 1, 1, '') 
													FROM dbo.FN_GET_USER_BY_ROLE_VB('GDDV','DV0001','DEP000000000048') B) 
					WHEN A.AUTH_STATUS = 'L' THEN A.MAKER_ID
					ELSE '' END
		FROM ASS_LIQ_REQUEST A    
		WHERE A.LIQ_REQ_ID = @PO_ID
		IF(@TL_NAME = 'DVCM')
		BEGIN
			SELECT @combinedString1 = COALESCE(@combinedString1 + ',', '') +
  					(SELECT  TOP 1 TLNANME = STUFF(
  								(SELECT ',' + TLNANME FROM dbo.FN_GET_USER_BY_ROLE_VB('DVCM','DV0001',PL.COST_ID) GROUP BY TLNANME FOR XML PATH ('')), 1, 1, '') 
    								FROM dbo.FN_GET_USER_BY_ROLE_VB('DVCM','DV0001',PL.COST_ID) A)
  				FROM TR_REQUEST_SHOP_COSTCENTER PL 
  				WHERE PL.REQ_ID = @PO_ID
			INSERT INTO @LST_USER_RECIVE (TLNAME)
			SELECT VALUE FROM string_split(@combinedString1,',')
		END
		ELSE IF(@TL_NAME = 'GDDV_DVCM')
		BEGIN
			SELECT @combinedString1 = COALESCE(@combinedString1 + ',', '') +
  					(SELECT  TOP 1 TLNANME = STUFF(
  								(SELECT ',' + TLNANME FROM dbo.FN_GET_USER_BY_ROLE_VB('GDDV','DV0001',PL.COST_ID) GROUP BY TLNANME FOR XML PATH ('')), 1, 1, '') 
    								FROM dbo.FN_GET_USER_BY_ROLE_VB('GDDV','DV0001',PL.COST_ID) A)
  				FROM TR_REQUEST_SHOP_COSTCENTER PL 
  				WHERE PL.REQ_ID = @PO_ID AND PL.COST_ID IN (SELECT tu.DEP_ID FROM TL_USER tu WHERE tu.TLNANME = @p_TLNAME)
			INSERT INTO @LST_USER_RECIVE (TLNAME)
			SELECT VALUE FROM string_split(@combinedString1,',')
		END		
		ELSE IF(@TL_NAME IS NOT NULL AND @TL_NAME <> '')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
			SELECT VALUE FROM string_split(@TL_NAME,',')
		END
		SET @FLAG = 6
	END
	
	ELSE IF(@TYPE = 'CHECK_WARRANTY_DT')
	BEGIN
		--INSERT INTO @LST_USER_RECIVE_PYC(TLFullName,Email,USER_ID)
		--VALUES('',(SELECT TOP 1 ParaValue FROM SYS_PARAMETERS WHERE ParaKey = 'EMAIL_QLTS_VB'),0)
			
		SET @FLAG = 10
	END
	IF(@TYPE LIKE N'%CHECK_TRANS_NOT_APPROVE|%')
	BEGIN
--		IF(@TYPE LIKE N'%|GDV|%')
--		BEGIN
--			INSERT INTO @LST_USER_RECIVE (TLNAME)
--			SELECT TLNANME FROM dbo.FN_GET_USER_BY_ROLE_VB('GDV,GDV_QLTS',@BRANCH_QLTS,@DEP_KT) GROUP BY TLNANME
--			--SELECT TLNANME FROM dbo.FN_GET_USER_BY_ROLE_VB('GDV,GDV_QLTS','','') GROUP BY TLNANME
--		END
--		ELSE IF(@TYPE LIKE N'%|KSV|%')
--		BEGIN
--			INSERT INTO @LST_USER_RECIVE (TLNAME)
--			SELECT TLNANME FROM dbo.FN_GET_USER_BY_ROLE_VB('KSV,KSV_QLTS',@BRANCH_QLTS,@DEP_KT) GROUP BY TLNANME
--			--SELECT TLNANME FROM dbo.FN_GET_USER_BY_ROLE_VB('GDV,GDV_QLTS','','') GROUP BY TLNANME
--		END
--
--		SET @FLAG = 6
		--INSERT INTO @LST_USER_RECIVE_PYC(TLFullName,Email,USER_ID)
		--VALUES('',(SELECT TOP 1 ParaValue FROM SYS_PARAMETERS WHERE ParaKey = 'EMAIL_QLTS_VB'),0)
			
		SET @FLAG = 10
	END
	--END PHUCVH 06/01/22 GẮN MAIL: ---- PYC: DC,SC,TH,CP ---- SỬA CHỮA TÀI SẢN	---- THU HỒI TÀI SẢN ---- ĐIỀU CHUYỂN NỘI BỘ ---- ĐIỀU CHUYỂN ---- XUẤT SD	---- NHẬP MỚI  ----Thanh lý
	---Phiếu đề nghị tạm ứng- KT - gửi mail cho tổng giám đốc-----
	--ELSE IF @TYPE='REQ_ADVANCE_PAYMENT_KT_SEND_TGD'
	--BEGIN
	--	INSERT INTO @LST_USER_RECIVE (TLNAME) 
	--				(SELECT TLNANME FROM TL_USER WHERE RoleName = 'TGD') 
	--	SET @FLAG = 8
	--END
	----- END PYC MUA SẮM --------------------
	IF(@FLAG = 0)
	BEGIN 
		SELECT A.*,B.TLFullName,B.EMAIL 
		FROM TL_ROLE_NOTIFICATION A
		LEFT JOIN TL_USER B ON A.TL_NAME=B.TLNANME
		WHERE EXISTS(SELECT * FROM @LST_POID WHERE ID = A.PO_ID)
		
	END
	ELSE IF(@FLAG = 1)
	BEGIN 
		SELECT B.*,A.TLFullName,A.EMAIL 
		FROM TL_USER  A
		LEFT JOIN TL_ROLE_NOTIFICATION B ON B.TL_NAME=A.TLNANME AND 1 >2
		WHERE (A.TLNANME IN (SELECT * FROM @LST_USER_RECIVE))
		AND A.TLNANME NOT IN  ('trungnq1','taila')
	END
	-- NEU LA TO TRINH CHU TRUONG, PYC MS THÌ TRA VE FLAG =2
	ELSE IF(@FLAG = 2)
	BEGIN 
		SELECT B.*,A.TLFullName,A.EMAIL 
		FROM TL_USER  A
		LEFT JOIN TL_ROLE_NOTIFICATION B ON B.TL_NAME=A.TLNANME AND 1>2
		WHERE (A.TLNANME IN (SELECT TLNAME FROM @PL_PROCESS_CURRENT_SEARCH_TEMP))
		AND A.TLNANME NOT IN  ('trungnq1','taila')
		
	END
	-- SAU KHI TT CHU TRUONG DUOC PHE DUYET THI THONG BAO CHO NGUOI TAO TO TRINH
	ELSE IF(@FLAG = 3)
	BEGIN 
		SELECT B.*,A.TLFullName,A.EMAIL 
		FROM TL_USER  A
		LEFT JOIN TL_ROLE_NOTIFICATION B ON B.TL_NAME=A.TLNANME AND 1>2
		WHERE (A.TLNANME  =@MAKER_ID OR A.TLNANME IN (SELECT TLNAME FROM @PL_PROCESS_CURRENT_SEARCH_TEMP))
		--AND A.TLNANME NOT IN  ('trungnq1','taila')
	END
	-- SAU KHI PYCMS  DUOC PHE DUYET THI THONG BAO CHO NGUOI TAO VA NGUOI XU LY
	ELSE IF(@FLAG = 4)
	BEGIN 
		SELECT B.*,A.TLFullName,A.EMAIL 
		FROM TL_USER  A
		LEFT JOIN TL_ROLE_NOTIFICATION B ON B.TL_NAME=A.TLNANME AND 1>2
		WHERE (A.TLNANME  =@MAKER_ID OR A.TLNANME =@NV_XL_MS)
		AND A.TLNANME NOT IN  ('trungnq1','taila')
	END
	-----------Quản lý cho thuê----------------
	ELSE IF(@FLAG = 5)
	BEGIN
		SELECT TLFullName, EMAIL AS Email, ID as [USER_ID]
		FROM TL_USER  
		WHERE (TLNANME IN (SELECT TLNAME FROM @LST_USER_RECIVE))
	END
	ELSE IF(@FLAG = 6)
	BEGIN
		SELECT TLFullName, EMAIL AS Email, ID as [USER_ID]
		FROM TL_USER  
		WHERE (TLNANME IN (SELECT TLNAME FROM @LST_USER_RECIVE))
	END
	--------------BAODNQ 15/2/2022: Quản lý BDS--------------------
	ELSE IF(@FLAG = 7)
	BEGIN
		SELECT TLFullName, EMAIL AS Email, ID as [USER_ID]
		FROM TL_USER  
		WHERE (TLNANME IN (SELECT TLNAME FROM @LST_USER_RECIVE))
	END
	--------------QUẢN LÝ THANH TOÁN TẠM ỨNG------------------
	ELSE IF(@FLAG = 8)
	BEGIN
		SELECT TLFullName, EMAIL AS Email, ID as [USER_ID]
		FROM TL_USER  
		WHERE (TLNANME IN (SELECT TLNAME FROM @LST_USER_RECIVE))
	END
	ELSE IF(@FLAG = 9)
	BEGIN
		SELECT TLFullName, EMAIL AS Email, ID as [USER_ID]
		FROM TL_USER  
		WHERE (TLNANME IN (SELECT TLNAME FROM @LST_USER_RECIVE))
	END
	ELSE IF(@FLAG = 10)
	BEGIN --PHÊ DUYỆT HOÀN TẤT PHIẾU YÊU CẦU
		SELECT TLFullName,Email,USER_ID FROM @LST_USER_RECIVE_PYC	
	END