AMS - VB

ALTER PROCEDURE dbo.ASS_USE_MULTI_BVB_MASTER_App

	--@p_USE_ID		varchar(15) = NULL,

	@p_USER_MASTER_ID		varchar(15) = NULL,

	@p_AUTH_STATUS varchar(1)  = NULL,

	@p_CHECKER_ID	varchar(100)  = NULL,

	@p_APPROVE_DT	VARCHAR(20) = NULL		

AS	

BEGIN TRY

--DECLARE @l_BRANCH_ID VARCHAR(15)

--	DECLARE @l_DEPT_ID VARCHAR(15)

--	DECLARE @l_EMP_ID VARCHAR(15)

--	DECLARE @l_DIVISION_ID	VARCHAR(15)

--	DECLARE @l_VALUE_ID	VARCHAR(15)

--	

--	--DECLARE @l_LOCATION nvarchar(500)

--	DECLARE @l_LOCHIST_ID	VARCHAR(15)

--

--	DECLARE @l_ASSET_ID VARCHAR(15)

--	DECLARE @l_WAHDT_ID VARCHAR(15)

--	DECLARE @l_WAH_ID VARCHAR(15)

--	DECLARE @l_MAKER_ID			varchar(15)

--		

--	DECLARE @l_AMORT_MONTH decimal(18,2)

--	DECLARE @l_AMORT_START_DATE datetime, @l_AMORT_END_DATE datetime

--	DECLARE @l_FIRST_AMORT_AMT	numeric(18,0)

--	DECLARE @l_MONTHLY_AMT 	numeric(18,0)

--	DECLARE @l_ASS_AMORT_AMT numeric(18,0)

--	DECLARE @sToday varchar(10) = convert(varchar(10), getdate(), 103)

--	DECLARE @l_ENTRY_BOOKED varchar(1)

--	DECLARE @l_HO_BRN_ID varchar(15)	

--	DECLARE @l_AMORT_AMT decimal(18)  = NULL	

--	DECLARE @l_BUY_PRICE decimal(18)  = NULL	

--	DECLARE @l_ET_ID varchar(15)

--	DEClare @p_ADDNEW_ID varchar(15)

--	

--	DECLARE @l_SUPPEND_GL varchar(50)

--	DECLARE @l_ASSET_GL  varchar(50)

--	declare @l_ASSET_VALUE decimal(18,0)	

--	DECLARE @l_GROUP_ID varchar(15)	

--	DECLARE @l_CORE_NOTE NVARCHAR(500)

--	DECLARE @l_TYPE_ID	varchar(15)  = NULL

--	declare @l_TRN_REF_NO varchar(20)

--	declare @l_DO_BRANCH_ID varchar(15)

--	DECLARE @l_AMORT_STATUS VARCHAR(15) = 'CKH'

--	DECLARE @l_AMORT_MONTH_ASS_USE DECIMAL(18,2) = NULL

--	declare @l_AUTH_STATUS varchar(15) = ''

--  declare @l_ASSHIST_ID varchar(15)

--	--Lay thong tin kho mac dinh

--	SELECT @l_WAH_ID = P.ParaValue FROM SYS_PARAMETERS P WHERE P.ParaKey='ASSET_WAREHOUSE'

--

--	--BRN_ID HOI SO

--	SELECT @l_HO_BRN_ID = BRANCH_ID FROM CM_BRANCH A WHERE A.BRANCH_TYPE = 'HS'

--

--	--Lay branch_id cua user duyet

--	select @l_DO_BRANCH_ID = a.TLSUBBRID from TL_USER a where a.TLNANME = @p_CHECKER_ID	

--	

--	--Lay suppend GL

--	SELECT @l_SUPPEND_GL = A.ParaValue FROM SYS_PARAMETERS A WHERE A.ParaKey='ASSET_SUPPEND_GL'

--	

--	--ASSET_GL

--	SELECT @l_ASSET_GL = ASSET_ACCTNO FROM ASS_GROUP A WHERE A.GROUP_ID = @l_GROUP_ID

	IF (SELECT AUTH_STATUS_KT FROM ASS_USE_MULTI_MASTER WHERE [USER_MASTER_ID] = @p_USER_MASTER_ID) = 'A'

	BEGIN

		SELECT '-1' as Result, (SELECT ErrorDesc from SYS_ERROR WHERE ErrorCode = 'ASS-99998') ErrorDesc

		RETURN '-1'

	END

	BEGIN TRANSACTION

		--LUCTV: 26-20-2018 KIEM TRA NEU TINH TRANG DANG LA 'R' THI KHONG CHO PHEP DUYET

		IF(EXISTS(SELECT * FROM ASS_USE_MULTI_MASTER WHERE AUTH_STATUS ='R' AND USER_MASTER_ID =@p_USER_MASTER_ID))

		BEGIN

					ROLLBACK TRANSACTION

					SELECT '-1' as Result, N'Thông tin xuất sử dụng tài sản đang bị trả về. Vui lòng cập nhật lại thông tin trước khi duyệt' ErrorDesc

					RETURN '-1'

		END

		--APPROVE MASTER

        UPDATE [dbo].[ASS_USE_MULTI_MASTER]

		SET AUTH_STATUS = 'A',

			CHECKER_ID = @p_CHECKER_ID,AUTH_STATUS_KT='E',MAKER_ID_KT= NULL, APPROVE_DT_KT = NULL, CHECKER_ID_KT = NULL,CREATE_DT_KT= NULL,

			APPROVE_DT = CONVERT(datetime, @p_APPROVE_DT, 103)

		WHERE [USER_MASTER_ID] = @p_USER_MASTER_ID

		--Update trang thai cho giao dich xuat su dung

		UPDATE [dbo].[ASS_USE_MULTI_DT]

		SET AUTH_STATUS = 'A',

			CHECKER_ID = @p_CHECKER_ID,

			APPROVE_DT = CONVERT(DATETIME, @p_APPROVE_DT, 103) 

		WHERE  USER_MASTER_ID = @p_USER_MASTER_ID

--		DECLARE @USE_MULTI_ID varchar(15)

--		DECLARE @ASSET_ID varchar(15)

--		DECLARE DataCusor SCROLL CURSOR 

--		FOR  

--		SELECT A.USE_MULTI_ID,A.ASSET_ID

--		FROM [dbo].[ASS_USE_MULTI_DT] A

--		WHERE A.USER_MASTER_ID=@p_USER_MASTER_ID		

--		OPEN DataCusor  

--      

--FETCH NEXT FROM DataCusor INTO  @USE_MULTI_ID,@ASSET_ID

--WHILE @@FETCH_STATUS = 0

--BEGIN		

--			

--	--Lay thong tin giao dich

--	SELECT	@l_ASSET_ID = ASSET_ID, @l_BRANCH_ID = BRANCH_ID, @l_DEPT_ID = DEPT_ID, 

--			@l_EMP_ID = EMP_ID, @l_DIVISION_ID = DIVISION_ID, @l_CORE_NOTE = CORE_NOTE, @l_AUTH_STATUS = AUTH_STATUS,

--			@l_AMORT_START_DATE = AMORT_START_DATE, @l_MAKER_ID = MAKER_ID, @l_AMORT_MONTH_ASS_USE = AMORT_MONTH,

--			@l_AMORT_END_DATE = AMORT_END_DATE

--	FROM [dbo].[ASS_USE_MULTI_DT]

--	WHERE [USE_MULTI_ID] = @USE_MULTI_ID

--

--	--Lay thong tin so thang khau hao

--	SELECT @l_AMORT_MONTH = A.AMORT_MONTH, @l_ASS_AMORT_AMT = AMORT_AMT, @l_ENTRY_BOOKED = ENTRY_BOOKED,

--			@l_AMORT_AMT = A.AMORT_AMT, @l_BUY_PRICE = BUY_PRICE, @l_GROUP_ID = GROUP_ID,@l_TYPE_ID = A.[TYPE_ID]

--	FROM ASS_MASTER A 

--	WHERE A.ASSET_ID = @l_ASSET_ID

--		

--	--TINH SO THANG THEO THUC TE KHI XUAT SU DUNG

--	SET @l_AMORT_MONTH = @l_AMORT_MONTH_ASS_USE

--

--	--IF @l_AMORT_MONTH_ASS_USE IS NULL--TRUONG HOP CCLD DO PHCQT XUAT

--	--BEGIN

--	--	SET @l_AMORT_END_DATE = NULL;		

--	--	SET @l_MONTHLY_AMT = 0;

--	--	SET @l_FIRST_AMORT_AMT = 0;

--	--	SET @l_AMORT_STATUS = 'VNM'

--	--END

--	--ELSE

--	--IF @l_AMORT_MONTH = 0

--	--BEGIN

--	--	SET @l_AMORT_END_DATE = NULL;		

--	--	SET @l_MONTHLY_AMT = 0;

--	--	SET @l_FIRST_AMORT_AMT = 0;

--	--	SET @l_AMORT_STATUS = 'KKH'

--	--END

--	--ELSE

--	--BEGIN

--	--	--Tinh ngay ket thuc khau hao

--	--	IF @l_TYPE_ID = 'TSCD'

--	--	BEGIN

--	--		IF @l_AMORT_END_DATE IS NULL OR @l_AMORT_END_DATE = ''

--	--			SET @l_AMORT_END_DATE = DATEADD(MONTH, @l_AMORT_MONTH, @l_AMORT_START_DATE) - 1

--	--		--CAP NHAT TRANG THAI KHAU HAO

--	--		SET @l_AMORT_STATUS = 'CKH'

--	--	END

--	--	ELSE

--	--	BEGIN			

--	--		DECLARE @l_ENDDATE_TEMP DATETIME = (CONVERT(VARCHAR(10),(YEAR(@l_AMORT_START_DATE))) + '-' + CONVERT(VARCHAR(10),MONTH(@l_AMORT_START_DATE))+'-' + '1')

--	--		SET @l_AMORT_END_DATE = DATEADD(MONTH, @l_AMORT_MONTH, @l_ENDDATE_TEMP ) - 1		

--

--	--		--CAP NHAT TRANG THAI KHAU HAO

--	--		SET @l_AMORT_STATUS = 'VNM'

--	--	END

--	

--	--	--Tinh so tien khau hao thang dau tien va so tien khau hao hang thang

--	--	SET @l_MONTHLY_AMT = ROUND(@l_ASS_AMORT_AMT / @l_AMORT_MONTH, -3)

--	--	SET @l_FIRST_AMORT_AMT = ROUND(@l_MONTHLY_AMT/dbo.[FN_GetDaysInMonth](@l_AMORT_START_DATE) * (DATEDIFF(day,@l_AMORT_START_DATE, dbo.FN_GetLastDayOfMonth(@l_AMORT_START_DATE)) + 1), -3)

--	--	----CAP NHAT TRANG THAI KHAU HAO

--	--	--SET @l_AMORT_STATUS = 'CKH'

--	--END

--	

--		--COMMIT TRANSACTION

--

--		--BEGIN TRANSACTION

--

--

--		IF @@Error <> 0 GOTO ABORT

--

--		

--		

--		DECLARE @l_AMORT_RATE DECIMAL(18,2)

--		IF @l_AMORT_MONTH > 0 AND @l_AMORT_MONTH IS NOT NULL

--			SET @l_AMORT_RATE = ROUND((100 /@l_AMORT_MONTH) * 12, 2)

--		ELSE 

--		BEGIN

--			SET @l_AMORT_RATE = 0

--			IF(@l_TYPE_ID = 'CCLD')

--				SET @l_AMORT_MONTH = 1

--		END

--

--		--Update tai san da xuat su dung

--		UPDATE ASS_MASTER

--		SET	BRANCH_ID = @l_BRANCH_ID,

--			DEPT_ID = @l_DEPT_ID,

--			EMP_ID = @l_EMP_ID,

--			DIVISION_ID = @l_DIVISION_ID,

--		--	AMORT_START_DATE = @l_AMORT_START_DATE,

--		--	AMORT_END_DATE = @l_AMORT_END_DATE,

--		--	FIRST_AMORT_AMT = @l_FIRST_AMORT_AMT,

--		--	AMORT_MONTH = @l_AMORT_MONTH,

--		--	MONTHLY_AMORT_AMT = @l_MONTHLY_AMT,

--		--	AMORTIZED_AMT = ISNULL(AMORTIZED_AMT,0),

--		--	AMORTIZED_MONTH = 0,

--		--	AMORT_STATUS = @l_AMORT_STATUS,--'CKH', --Update trang thai cho khau hao

--			USE_DATE = CONVERT(DATETIME, @sToday, 103)

--		--	ENTRY_BOOKED = @l_ENTRY_BOOKED,

--		--	AMORT_RATE = @l_AMORT_RATE

--		WHERE ASSET_ID = @l_ASSET_ID

--

----		UPDATE ASS_MASTER

----		SET	USE_DATE = CONVERT(DATETIME, @sToday, 103),

----			ENTRY_BOOKED = @l_ENTRY_BOOKED,

----			AMORT_RATE = @l_AMORT_RATE

----		WHERE ASSET_ID = @l_ASSET_ID

--		IF @@Error <> 0 GOTO ABORT

--

--

--	--Phat sinh Asset_ID

--	EXEC SYS_CodeMasters_Gen 'ASS_MASTER_HIST', @l_ASSHIST_ID out

--	IF @l_ASSHIST_ID='' OR @l_ASSHIST_ID IS NULL GOTO ABORT		

--		

--	  INSERT INTO ASS_MASTER_HIST

--		SELECT @l_ASSHIST_ID, a.*

--		FROM ASS_MASTER a

--		where a.ASSET_ID = @l_ASSET_ID

--

--	IF @@Error <> 0 GOTO ABORT

--

--

--		/***THIEUVQ - 10/09/2014 CAP NHAT LAI DON VI KHI XUAT SU DUNG NEU TS LA XE***/

--		--UPDATE CAR_MASTER SET BRANCH_ID = @l_BRANCH_ID WHERE ASSET_ID = @l_ASSET_ID

--				

--		--Insert phan xuat kho

--		SELECT @l_WAHDT_ID = WAHDT_ID FROM ASS_WAREHOUSE_DT A WHERE A.ASSET_ID = @l_ASSET_ID AND A.STATUS='I'

--								

--		UPDATE ASS_WAREHOUSE_DT

--		SET OUT_DATE = GETDATE(),

--			STATUS = 'O'

--		WHERE WAHDT_ID = @l_WAHDT_ID

--		IF @@Error <> 0 GOTO ABORT

--		

--		----Insert bang ASS_LOCATION_HIST

--		EXEC SYS_CodeMasters_Gen 'ASS_LOCATION_HIST', @l_LOCHIST_ID out

--		IF @l_LOCHIST_ID='' OR @l_LOCHIST_ID IS NULL GOTO ABORT

--		

--		INSERT INTO ASS_LOCATION_HIST

--		(

--			LOCHIST_ID, ASSET_ID, USE_START_DT, USE_END_DT, BRANCH_ID, DEPT_ID, 

--			EMP_ID, LOCATION, ISLEAF, PARENT_ID

--		)

--		VALUES

--		(

--			@l_LOCHIST_ID, @l_ASSET_ID, GETDATE(), NULL, @l_BRANCH_ID, @l_DEPT_ID,

--			@l_EMP_ID, '', 'Y', NULL

--		)

--		IF @@Error <> 0 GOTO ABORT

--		

--		--INSERT VAO BANG ASS_TRANSACTIONS

--		INSERT INTO ASS_TRANSACTIONS(ASSET_ID, TRN_ID, TRN_TYPE, TRN_DATE, RECORD_STATUS, AUTH_STATUS, 	

--				[MAKER_ID], [CREATE_DT], [CHECKER_ID], [APPROVE_DT],ASSHIST_ID, LOCHIST_ID

--		)VALUES

--		(

--			@l_ASSET_ID, @USE_MULTI_ID, 'ADD_USE', CONVERT(DATETIME, @sToday, 103), '1', 'A', 

--			@l_MAKER_ID, CONVERT(DATETIME, @sToday, 103), @p_CHECKER_ID, 	CONVERT(DATETIME, @p_APPROVE_DT, 103) ,@l_ASSHIST_ID,@l_LOCHIST_ID

--		)

--		IF @@Error <> 0 GOTO ABORT	

--		FETCH NEXT FROM DataCusor INTO  @USE_MULTI_ID,@ASSET_ID

--		END

--		CLOSE DataCusor

--		DEALLOCATE DataCusor	

--		

--    --START PHUCVH 07/10/22 UPDATE ALLOCATED PHIẾU YÊU CẦU DT

--    DECLARE @TBL_CHECK_UPD TABLE (REQDT_ID VARCHAR(15), REQ_DOC_ID VARCHAR(15), ASS_GROUP_ID VARCHAR(15), ASS_ID VARCHAR(15), REQ_DT_TYPE VARCHAR(20), TYPE_XL VARCHAR(20))

--    

--    INSERT INTO @TBL_CHECK_UPD

--    SELECT DISTINCT A.REQDT_ID, A.REQ_DOC_ID, A.ASS_GROUP_ID, A.ASS_ID, A.REQ_DT_TYPE, A.TYPE_XL

--    FROM ASS_USE_MULTI_DT B

--    LEFT JOIN TR_REQUEST_SHOP_DOC_DT A ON B.REQ_ID = A.REQ_DOC_ID 

--    WHERE B.USER_MASTER_ID = @p_USER_MASTER_ID AND B.REQ_ID IS NOT NULL AND B.REQ_ID <> ''

--          AND(A.REQ_DT_TYPE = 'BUYNEW' 

--            OR (A.REQ_DT_TYPE = 'XKSD' AND A.TYPE_XL = 'CPTK')) 

--

--    DECLARE @C_REQDT_ID VARCHAR(15), @C_REQ_DOC_ID VARCHAR(15), @C_ASS_GROUP_ID VARCHAR(15), @C_ASS_ID VARCHAR(15), @C_REQ_DT_TYPE VARCHAR(15), @C_TYPE_XL VARCHAR(20)

--

--    DECLARE DATA_CURSOR_CHECK_UPD CURSOR FOR

--    SELECT * FROM @TBL_CHECK_UPD

--

--    OPEN DATA_CURSOR_CHECK_UPD

--

--    FETCH NEXT FROM DATA_CURSOR_CHECK_UPD INTO

--    @C_REQDT_ID,@C_REQ_DOC_ID,@C_ASS_GROUP_ID,@C_ASS_ID,@C_REQ_DT_TYPE,@C_TYPE_XL

--

--    DECLARE @ALLOCATED INT

--    WHILE @@FETCH_STATUS = 0

--    BEGIN

--        SET @ALLOCATED = (SELECT COUNT(*) 

--                          FROM ASS_USE_MULTI_DT A

--                          LEFT JOIN ASS_MASTER C ON A.ASSET_ID = C.ASSET_ID

--                          GROUP BY A.REQ_ID, C.GROUP_ID, C.REQ_ID

--                          HAVING A.REQ_ID = @C_REQ_DOC_ID

--                            AND C.GROUP_ID = @C_ASS_GROUP_ID

--                            AND ((@C_REQ_DT_TYPE = 'BUYNEW' AND C.REQ_ID = @C_REQ_DOC_ID)

--                                  OR (@C_TYPE_XL = 'CPTK' AND (C.REQ_ID IS NULL OR C.REQ_ID = ''))))

--                          

--        UPDATE TR_REQUEST_SHOP_DOC_DT 

--        SET ALLOCATED = @ALLOCATED

--        WHERE REQDT_ID = @C_REQDT_ID

--

--        FETCH NEXT FROM DATA_CURSOR_CHECK_UPD INTO

--        @C_REQDT_ID,@C_REQ_DOC_ID,@C_ASS_GROUP_ID,@C_ASS_ID,@C_REQ_DT_TYPE,@C_TYPE_XL

--    END

--    CLOSE DATA_CURSOR_CHECK_UPD

--    DEALLOCATE DATA_CURSOR_CHECK_UPD

--    --END PHUCVH 07/10/22 UPDATE ALLOCATED PHIẾU YÊU CẦU DT

		-- GIANT 21/09/2021

		INSERT INTO dbo.PL_PROCESS

					(

						REQ_ID,

						PROCESS_ID,

						CHECKER_ID,

						APPROVE_DT,

						PROCESS_DESC,NOTES

					)

					VALUES

					(   @p_USER_MASTER_ID,        -- REQ_ID - varchar(15)

						'APPROVE',        -- PROCESS_ID - varchar(10)

						@p_CHECKER_ID,        -- CHECKER_ID - varchar(15)

						GETDATE(), -- APPROVE_DT - datetime

					   N'Trưởng đơn vị phê duyệt ' ,

					   N'Trưởng đơn vị phê duyệt thành công'      -- PROCESS_DESC - nvarchar(1000)

					)

COMMIT TRANSACTION

SELECT '0' as Result, '' ErrorDesc

RETURN '0'

END TRY

BEGIN CATCH

	ROLLBACK TRANSACTION

	CLOSE DataCusor

	DEALLOCATE DataCusor			

	SELECT '-1' as Result, ERROR_MESSAGE() ErrorDesc

	RETURN '-1'

END CATCH

ABORT:

BEGIN

		ROLLBACK TRANSACTION

		CLOSE DataCusor

		DEALLOCATE DataCusor			

		SELECT '-1' as Result, ERROR_MESSAGE() ErrorDesc

		RETURN '-1'

End

GO

ALTER PROCEDURE dbo.ASS_COLLECT_MULTI_MASTER_App

@p_COL_MULTI_MASTER_ID varchar(15),

@p_AUTH_STATUS varchar(1)  = NULL,

@p_CHECKER_ID	varchar(100)  = NULL,

@p_APPROVE_DT	VARCHAR(20) = NULL		

AS

BEGIN TRANSACTION

		--LUCTV: 26/12/2018 BO SUNG KIEM TRA NEU DANG TRA VE THI KHONG CHO HANH CHINH DUYET NUA.

		IF(EXISTS(SELECT * FROM ASS_COLLECT_MULTI_MASTER WHERE AUTH_STATUS ='R' AND COL_MULTI_MASTER_ID =@p_COL_MULTI_MASTER_ID))

		BEGIN

			ROLLBACK TRANSACTION

			SELECT '-1' as Result, '' COL_MULTI_MASTER_ID, N'Thông tin thu hồi tài sản đang bị trả về. Vui lòng cập nhật lại thông tin trước khi duyệt' ErrorDesc

			RETURN '-1'

		END

		UPDATE ASS_COLLECT_MULTI_MASTER SET AUTH_STATUS = 'A', CHECKER_ID = @p_CHECKER_ID, APPROVE_DT = CONVERT(DATETIME,@p_APPROVE_DT,103),AUTH_STATUS_KT='E',MAKER_ID_KT =NULL,APPROVE_DT_KT=NULL, CHECKER_ID_KT = NULL

		WHERE COL_MULTI_MASTER_ID = @p_COL_MULTI_MASTER_ID

--DECLARE @COLLECT_MULTI_ID varchar(15)

--		DECLARE @ASSET_ID varchar(15)

--		DECLARE DataCusor SCROLL CURSOR 

--		FOR  

--		SELECT A.COLLECT_MULTI_ID,A.ASSET_ID

--		FROM [dbo].[ASS_COLLECT_MULTI_DT] A

--	WHERE [COL_MULTI_MASTER_ID] = @p_COL_MULTI_MASTER_ID

--		OPEN DataCusor   

--	UPDATE ASS_COLLECT_MULTI_MASTER SET AUTH_STATUS = 'A', CHECKER_ID = @p_CHECKER_ID, APPROVE_DT = CONVERT(DATETIME,@p_APPROVE_DT,103)

--	WHERE COL_MULTI_MASTER_ID = @p_COL_MULTI_MASTER_ID

--FETCH NEXT FROM DataCusor INTO  @COLLECT_MULTI_ID,@ASSET_ID

--WHILE @@FETCH_STATUS = 0

--BEGIN

--	--THIEUVQ 15062015

--	DECLARE @p_BRANCH_ID_RECEIVE VARCHAR(15) = NULL, @p_DEPT_ID_RECEIVE	VARCHAR(15) = NULL, @l_ASSET_ID VARCHAR(15)

--	DECLARE @l_LOCHIST_ID VARCHAR(15), @l_OLD_LOCHIST_ID VARCHAR(15), @l_ASSHIST_ID varchar(15)

--	SELECT @p_BRANCH_ID_RECEIVE = BRANCH_ID_RECEIVE , @p_DEPT_ID_RECEIVE = DEPT_ID_RECEIVE , @l_ASSET_ID = ASSET_ID

--	FROM ASS_COLLECT_MULTI_DT 

--	WHERE COLLECT_MULTI_ID = @COLLECT_MULTI_ID

--	 UPDATE ASS_COLLECT_MULTI_DT SET AUTH_STATUS = 'A', CHECKER_ID = @p_CHECKER_ID, APPROVE_DT = CONVERT(DATETIME,@p_APPROVE_DT,103)

--	WHERE COLLECT_MULTI_ID = @COLLECT_MULTI_ID

--	IF @@Error <> 0 

--	BEGIN

--		GOTO ABORT		

--		SELECT '0' as Result, '' ErrorDesc

--	END	

--	--Move to history	

--	--Phat sinh Asset_ID

--	EXEC SYS_CodeMasters_Gen 'ASS_MASTER_HIST', @l_ASSHIST_ID out

--	IF @l_ASSHIST_ID='' OR @l_ASSHIST_ID IS NULL GOTO ABORT		

--	INSERT INTO ASS_MASTER_HIST		

--	SELECT @l_ASSHIST_ID, a.*

--	FROM ASS_MASTER a

--	where a.ASSET_ID = @l_ASSET_ID

--	IF @@Error <> 0 GOTO ABORT

--	UPDATE ASS_MASTER SET BRANCH_ID = @p_BRANCH_ID_RECEIVE, DEPT_ID = @p_DEPT_ID_RECEIVE 

--	WHERE ASSET_ID = @l_ASSET_ID

--	IF @@Error <> 0 GOTO ABORT

--	--Lay LOCHIST_ID

--	SELECT @l_OLD_LOCHIST_ID = LOCHIST_ID FROM ASS_LOCATION_HIST WHERE  ASSET_ID = @l_ASSET_ID AND ISLEAF='Y'

--	--Uptdae isleaf='N' and END_DATE = ngay hien tai cho record hien tai

--	UPDATE ASS_LOCATION_HIST

--	SET USE_END_DT = CONVERT(DATETIME,@p_APPROVE_DT,103),

--		ISLEAF='N'

--	WHERE  ASSET_ID = @l_ASSET_ID AND ISLEAF='Y'

--	IF @@Error <> 0 GOTO ABORT

--	--Insert bang ASS_LOCATION_HIST	

--	EXEC SYS_CodeMasters_Gen 'ASS_LOCATION_HIST', @l_LOCHIST_ID out

--	IF @l_LOCHIST_ID='' OR @l_LOCHIST_ID IS NULL GOTO ABORT

--	INSERT INTO ASS_LOCATION_HIST

--	(

--		LOCHIST_ID, ASSET_ID, USE_START_DT, USE_END_DT, BRANCH_ID, DEPT_ID, 

--		EMP_ID, LOCATION, ISLEAF, PARENT_ID

--	)

--	VALUES

--	(

--		@l_LOCHIST_ID, @l_ASSET_ID, GETDATE(), NULL, @p_BRANCH_ID_RECEIVE, @p_DEPT_ID_RECEIVE,

--		NULL, '', 'Y', NULL

--	)

--	IF @@Error <> 0 GOTO ABORT

--	FETCH NEXT FROM DataCusor INTO  @COLLECT_MULTI_ID,@ASSET_ID

--END

--CLOSE DataCusor

--DEALLOCATE DataCusor

		-- GIANT Insert to table PL_PROCESS

		INSERT INTO dbo.PL_PROCESS

					(

					    REQ_ID,

					    PROCESS_ID,

					    CHECKER_ID,

					    APPROVE_DT,

					    PROCESS_DESC,

					    NOTES

					)

					VALUES

					(   @p_COL_MULTI_MASTER_ID,       

						'APPROVE',

					    @p_CHECKER_ID,        

					    GETDATE(), 

					    N'Trưởng đơn vị phê duyệt ' ,      

					    N'Trưởng đơn vị phê duyệt thành công'       

					 )

COMMIT TRANSACTION

SELECT '0' as Result, @p_COL_MULTI_MASTER_ID  COL_MULTI_MASTER_ID, '' ErrorDesc

RETURN '0'

ABORT:

BEGIN

		CLOSE DataCusor

		DEALLOCATE DataCusor

		ROLLBACK TRANSACTION

		SELECT '-1' as Result, '' COL_MULTI_MASTER_ID, '' ErrorDesc

		RETURN '-1'

End