DECLARE @BRANCH_CODE_IMP NVARCHAR(MAX) = '1800,1400,1400,0719,0731,2200,2200,0900,0900,0900,1902,0717,2600,2600,2600,2500,2500,0903,0902,0901,0703,0700,2300,2300,3000,0726,0726,1801,0500,2000'
DECLARE @DEP_CODE_IMP NVARCHAR(MAX) = 'NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,05P24,NULL'
DECLARE @ASSET_ID_IMP NVARCHAR(MAX) = 'ASS000001371117,ASS000001371118,ASS000001371119,ASS000001371120,ASS000001371121,ASS000001371122,ASS000001371123,ASS000001371124,ASS000001371125,ASS000001371126,ASS000001371127,ASS000001371128,ASS000001371129,ASS000001371130,ASS000001371131,ASS000001371132,ASS000001371133,ASS000001371134,ASS000001371135,ASS000001371136,ASS000001371137,ASS000001371138,ASS000001371139,ASS000001371140,ASS000001371141,ASS000001371142,ASS000001371143,ASS000001371144,ASS000001371145,ASS000001371146'

DECLARE @TABLE_DATA TABLE (ASSET_ID VARCHAR(20),BRANCH_CODE VARCHAR(20), DEP_CODE VARCHAR(20))
INSERT INTO @TABLE_DATA
SELECT A.ASSET_ID,B.BRANCH_CODE,C.DEP_CODE
FROM ( 
SELECT VALUE AS ASSET_ID ,ROW_NUMBER() OVER (ORDER BY (SELECT 1)) AS ID
FROM STRING_SPLIT(@ASSET_ID_IMP,','))A
LEFT JOIN (SELECT VALUE AS BRANCH_CODE ,ROW_NUMBER() OVER (ORDER BY (SELECT 1)) AS ID
FROM STRING_SPLIT(@BRANCH_CODE_IMP,','))B ON A.ID = B.ID
LEFT JOIN (SELECT VALUE AS DEP_CODE ,ROW_NUMBER() OVER (ORDER BY (SELECT 1)) AS ID
FROM STRING_SPLIT(@DEP_CODE_IMP,','))C ON A.ID = C.ID

DECLARE 
		@ASSET_ID	varchar(15),
		@p_BRANCH_ID	varchar(15),
		@p_DEP_ID	varchar(15),
		@EMP_ID	varchar(15) = NULL

    DECLARE @BRANCH_NAME NVARCHAR(100)


BEGIN TRANSACTION

DECLARE cur CURSOR FAST_FORWARD READ_ONLY LOCAL FOR
        	SELECT A.ASSET_ID,B.BRANCH_ID,C.DEP_ID
        	FROM @TABLE_DATA A
          LEFT JOIN CM_BRANCH B ON A.BRANCH_CODE = B.BRANCH_CODE
          LEFT JOIN CM_DEPARTMENT C ON A.DEP_CODE = C.DEP_CODE

        
        OPEN cur
        
        FETCH NEXT FROM cur INTO @ASSET_ID,@p_BRANCH_ID,@p_DEP_ID
        
        WHILE @@FETCH_STATUS = 0 BEGIN

SET @BRANCH_NAME = (SELECT CB.BRANCH_NAME FROM CM_BRANCH CB where CB.BRANCH_ID = @p_BRANCH_ID)
        
     DECLARE @l_USER_MASTER_ID VARCHAR(15)
		EXEC SYS_CodeMasters_Gen 'ASS_USE_MULTI_MASTER', @l_USER_MASTER_ID out
		--IF @l_USER_MASTER_ID='' OR @l_USER_MASTER_ID IS NULL GOTO ABORT


		INSERT INTO ASS_USE_MULTI_MASTER([USER_MASTER_ID],[BRANCH_ID],[USE_EXPORT_DT],[USER_EXPORT],[NOTES],[RECORD_STATUS],[AUTH_STATUS],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[AUTH_STATUS_KT],[CREATE_DT_KT],[APPROVE_DT_KT],[MAKER_ID_KT],[CHECKER_ID_KT],[REPORT_STATUS],[CORE_NOTE],[DEPT_CREATE],DEP_ID,BRANCH_CREATE,CONTENT)
		VALUES(@l_USER_MASTER_ID,@p_BRANCH_ID ,GETDATE() ,N'Nguyễn Hoàng Nghĩa' ,N'Ngày 31/03/2023 Xuất cho ' +@BRANCH_NAME  ,'1' ,'E' ,'nghianh' ,GETDATE() ,NULL ,NULL ,'E' ,NULL ,NULL ,NULL ,NULL ,NULL,'','DEP000000000048',@p_DEP_ID,'DV0001', N'Xuất cho ' + @BRANCH_NAME)

			DECLARE @l_USE_MULTI_ID VARCHAR(15)
			EXEC SYS_CodeMasters_Gen 'ASS_USE_MULTI_DT', @l_USE_MULTI_ID out
			--IF @l_USE_MULTI_ID='' OR @l_USE_MULTI_ID IS NULL GOTO ABORT
      --SELECT @l_USE_MULTI_ID

			INSERT INTO ASS_USE_MULTI_DT([USE_MULTI_ID],[USER_MASTER_ID],[ASSET_ID],[BRANCH_ID],[DEPT_ID],[EMP_ID],[RECORD_STATUS],[AUTH_STATUS],[MAKER_ID],[CREATE_DT],[BRANCH_CREATE],[AUTH_STATUS_KT],[REPORT_STATUS])
			VALUES(@l_USE_MULTI_ID ,@l_USER_MASTER_ID,@ASSET_ID,@p_BRANCH_ID ,@p_DEP_ID ,@EMP_ID ,'1','E','nghianh',GETDATE(),'DV0001','E','N')


		INSERT INTO dbo.PL_PROCESS
					(
						REQ_ID,
						PROCESS_ID,
						CHECKER_ID,
						APPROVE_DT,
						PROCESS_DESC,NOTES
					)
					VALUES
					(   @l_USER_MASTER_ID,        -- REQ_ID - varchar(15)
						'INSERT',        -- PROCESS_ID - varchar(10)
						'nghianh',        -- CHECKER_ID - varchar(15)
						GETDATE(), -- APPROVE_DT - datetime
					   N'Thêm mới phiếu xuất sử dụng' ,
					   N'Thêm mới phiếu xuất sử dụng thành công'      -- PROCESS_DESC - nvarchar(1000)
					)
        
        EXEC ASS_USE_MUILTI_MASTER_SendAppr @p_USER_MASTER_ID =@l_USER_MASTER_ID
                                   ,@p_USER_LOGIN = 'nghianh'

EXEC ASS_USE_MULTI_BVB_MASTER_App @p_USER_MASTER_ID = @l_USER_MASTER_ID
                                 ,@p_AUTH_STATUS = 'A'
                                 ,@p_CHECKER_ID = 'bichnn'
                                 ,@p_APPROVE_DT = '31-03-2023'
        	FETCH NEXT FROM cur INTO @ASSET_ID,@p_BRANCH_ID,@p_DEP_ID
        
        END


        
        CLOSE cur
        DEALLOCATE cur

   

COMMIT TRANSACTION