ALTER   PROCEDURE [dbo].[TR_ROLE_NOTIFI_ID]
@PO_ID	varchar(500),
@TYPE VARCHAR(100)
AS
	PRINT @TYPE

	DECLARE 
		@BRANCH_CREATE VARCHAR(15),
		@DEP_CREATE VARCHAR(15),
		@BRANCH_TYPE VARCHAR(15),
		@FATHER_ID VARCHAR(15),
		@FLAG VARCHAR(1), -- FLAG = 1: THANH TOÁN / TẠM ỨNG
		@AUTH_STATUS VARCHAR(10),
		@PROCESS VARCHAR(10),
		@MAKER_ID VARCHAR(15),
		@DEP_CODE VARCHAR(15),
		@NV_XL_MS VARCHAR(15)
	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(10))
	--- 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(15), @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
		INSERT INTO @LST_POID SELECT B.PO_ID 
		FROM ASS_MASTER_PO B WHERE B.ASSET_ID IN (SELECT A.ASSET_ID FROM ASS_USE_MULTI_DT A WHERE A.USER_MASTER_ID = @PO_ID)
		GROUP BY B.PO_ID
		SET @FLAG = 0
	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
				-- 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
				-- NEU CAP TIEP THEO LA TKTGD
				ELSE 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
				-- NEU CAP TIEP THEO LA TKHDQT
				ELSE 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
				-- NEU CAP TIEP THEO LA TGD
				ELSE IF(EXISTS(SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID=@PO_ID AND STATUS ='C' AND ROLE_USER ='TGD' AND @REQ_TYPE ='I'))
				BEGIN
					INSERT INTO @LST_USER_RECIVE SELECT TLNANME FROM TL_USER WHERE RoleName ='TGD'
				END
				-- NEU CAP TIEP THEO LA HDQT
				ELSE IF(EXISTS(SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID=@PO_ID AND STATUS ='C' AND ROLE_USER ='HDQT' AND @REQ_TYPE ='I'))
				BEGIN
					INSERT INTO @LST_USER_RECIVE SELECT TLNANME FROM TL_USER WHERE RoleName ='HDQT'
				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_SEND_SUG')
	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_SEND_SUG')
	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
		-------------------Nếu PYCMS chưa hoàn tất-------------------
		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 = 2
		END
		-------------------Nếu PYCMS hoàn tất-------------------
		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
	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
		ELSE IF(@PAGE='ASS_INVENTORY_MASTER')
			BEGIN
				IF((SELECT SIGN_USER FROM ASS_INVENTORY_MASTER WHERE INVENT_ID = @PO_ID) IS NOT NULL)
					BEGIN
						INSERT INTO @LST_USER_RECIVE (TLNAME)
						(SELECT SIGN_USER FROM ASS_INVENTORY_MASTER WHERE INVENT_ID = @PO_ID)
					END
				ELSE
					BEGIN
						SELECT @BRANCH_CREATE=B.TLSUBBRID, @BRANCH_TYPE =B.BRANCH_TYPE, @DEP_CREATE = B.DEP_ID
						FROM (SELECT MAKER_ID FROM ASS_INVENTORY_MASTER WHERE INVENT_ID =@PO_ID) A
						LEFT JOIN TL_USER B ON  B.TLNANME = A.MAKER_ID
					END
			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 IF(@BRANCH_TYPE IS NOT NULL)
		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 dbo.FN_GET_USER_BY_ROLE('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 dbo.FN_GET_USER_BY_ROLE('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
		ELSE IF(@PAGE='ASS_UPDATE')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
			(SELECT MAKER_ID
			FROM ASS_UPDATE au WHERE au.UPDATE_ID = @PO_ID
			)

		END
		ELSE IF(@PAGE='ASS_INVENTORY_MASTER')
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME)
			(SELECT MAKER_ID
			FROM ASS_INVENTORY_MASTER au WHERE au.INVENT_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
      
      SELECT  sp.ID
			FROM SYS_PREFIX sp WHERE sp.Prefix = 'ACAC'
			
		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_UPDATE')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
				(SELECT MAKER_ID
				FROM ASS_UPDATE au WHERE UPDATE_ID = @PO_ID
				)
			END
   ELSE IF(@PAGE='ASS_COST_ALLOCATION')
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
				(SELECT MAKER_ID
				FROM ASS_COST_ALLOCATION au WHERE au.COS_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)
		
		IF(@PAGE='ASS_COLLECT_MULTI_MASTER')
			BEGIN
				SELECT TOP 1 @BRANCH_CREATE = A.BRANCH_ID,@DEP_CREATE = A.DEPT_ID_USE,@BRANCH_TYPE = B.BRANCH_TYPE
				FROM  dbo.ASS_COLLECT_MULTI_DT A
				LEFT JOIN dbo.CM_BRANCH B ON A.BRANCH_ID =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 A.USER_MASTER_ID = @PO_ID
				ORDER BY USE_MULTI_ID ASC
			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_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
		WHERE A.TRANS_MULTI_MASTER_ID = @PO_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
		SET @FLAG =6
	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
		WHERE A.TRANS_MULTI_MASTER_ID = @PO_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
		SET @FLAG =6
	END
	ELSE IF @TYPE ='ASS_INVENTORY_RECIVE_MAIL'
	BEGIN
		IF(EXISTS(SELECT 1 FROM ASS_INVENTORY_MASTER WHERE SIGN_USER IS NOT NULL AND CHECKER_ID_DVKD IS NULL AND INVENT_ID=@PO_ID))
			BEGIN
				SELECT @BRANCH_CREATE =BRANCH_ID,@DEP_ID = DEPT_ID FROM dbo.ASS_INVENTORY_MASTER WHERE INVENT_ID=@PO_ID
				INSERT INTO @LST_USER_RECIVE (TLNAME)
				(SELECT TLNANME FROM dbo.FN_GET_USER_BY_ROLE('GDDV',@BRANCH_CREATE,@DEP_ID))
			END
		ELSE
			BEGIN
				INSERT INTO @LST_USER_RECIVE (TLNAME)
				(SELECT PARTY_NAME FROM dbo.ASS_INVENTORY_PARTY_DT WHERE IS_RECIVE_MAIL =1 AND INVENT_ID =@PO_ID)
			END
		
		SET @FLAG =6
	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 AND INVENT_ID =@PO_ID)
		SET @FLAG =6
	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
	-- Kho vật liệu
	ELSE IF (@TYPE = 'MW_IN_KT_APPR')
	BEGIN
		IF(EXISTS(SELECT * FROM MW_IN_MASTER WHERE IN_ID = @PO_ID AND AUTH_STATUS = 'A' AND AUTH_STATUS_KT = 'A'))
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME) 
			(SELECT MAKER_ID FROM MW_IN_MASTER WHERE IN_ID = @PO_ID)
		END
		SET @FLAG = 8
	END
	ELSE IF (@TYPE = 'MW_OUT_KT_APPR')
	BEGIN
		IF(EXISTS(SELECT * FROM MW_OUT WHERE OUT_ID = @PO_ID AND AUTH_STATUS = 'A' AND KT_AUTH_STATUS = 'A'))
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME) 
			(SELECT MAKER_ID FROM MW_OUT WHERE OUT_ID = @PO_ID)
		END
		SET @FLAG = 8
	END
	ELSE IF (@TYPE = 'MW_TRANSFER_KT_APPR')
	BEGIN
		IF(EXISTS(SELECT * FROM MW_TRANSFER WHERE TRANSFER_ID = @PO_ID AND AUTH_STATUS = 'A' AND KT_AUTH_STATUS = 'A'))
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME) 
			(SELECT MAKER_ID FROM MW_TRANSFER WHERE TRANSFER_ID = @PO_ID)
		END
		SET @FLAG = 8
	END
	ELSE IF (@TYPE = 'MW_LIQUID_KT_APPR')
	BEGIN
		IF(EXISTS(SELECT * FROM MW_LIQ_MASTER WHERE LIQ_ID = @PO_ID AND AUTH_STATUS = 'A' AND KT_AUTH_STATUS = 'A'))
		BEGIN
			INSERT INTO @LST_USER_RECIVE (TLNAME) 
			(SELECT MAKER_ID FROM MW_LIQ_MASTER WHERE LIQ_ID = @PO_ID)
		END
		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