ALTER PROCEDURE [dbo].[TR_REQUEST_DOC_MOVE_DVCM]
	-- Add the parameters for the stored procedure here
	@p_REQ_ID VARCHAR(20), 
	@p_DMMS_ID_NEW VARCHAR(20),
	@p_MAKER_ID VARCHAR(20)
AS
BEGIN
	IF(@p_REQ_ID IS NOT NULL AND @p_DMMS_ID_NEW IS NOT NULL)
	BEGIN
		DECLARE @PR_ID INT
		SET @PR_ID=(SELECT ID FROM dbo.PL_REQUEST_PROCESS WHERE PROCESS_ID='DMMS' AND REQ_ID=@p_REQ_ID AND STATUS='C')
		IF(EXISTS(SELECT ID FROM dbo.PL_REQUEST_PROCESS_CHILD WHERE PROCESS_ID=@PR_ID AND REQ_ID=@p_REQ_ID))
		BEGIN
			SELECT '-1' as Result, N'Phiếu yêu cầu đã được điều phối cho nhân viên, Nên không thể chuyển cho DVCM' ErrorDesc
		RETURN '-1'
		END
		UPDATE TR_REQUEST_DOC SET DMMS_ID = @p_DMMS_ID_NEW WHERE REQ_ID = @p_REQ_ID
		INSERT dbo.PL_PROCESS
		(
		    REQ_ID,
		    PROCESS_ID,
		    CHECKER_ID,
		    APPROVE_DT,
		    PROCESS_DESC,
		    NOTES
		)
		VALUES
		(   @p_REQ_ID,        -- REQ_ID - varchar(15)
		    'DMMS',        -- PROCESS_ID - varchar(10)
		    @p_MAKER_ID,        -- CHECKER_ID - varchar(15)
		    GETDATE(), -- APPROVE_DT - datetime
		    N'',       -- PROCESS_DESC - nvarchar(1000)
		    N'Chuyển phiếu về DVCM'        -- NOTES - nvarchar(1000)
		)
		
		SELECT '0' as Result, '' ErrorDesc
		RETURN '0'
	END
	ELSE
	BEGIN
		SELECT '-1' as Result, '' ErrorDesc
		RETURN '-1'
	END
END