ALTER PROCEDURE dbo.TR_REQUEST_CAR_Ins
@p_REQ_CODE varchar(150) = NULL,
@p_REQ_DT varchar(150) = NULL,
@p_EMP_ID varchar(15) = NULL,
@p_EMP_PHONE varchar(15) = NULL,
@p_BRANCH_ID varchar(15) = NULL,
@p_BRANCH_CREATE varchar(15) = NULL,
@p_DEP_ID varchar(15) = NULL,
@p_DEP_CREATE varchar(15) = NULL,
@p_ORIGN nvarchar(100) = NULL,
@p_DESTINATION nvarchar(100) = NULL,
@p_IS_SEND_APPR varchar(15) = NULL,
@p_SEND_APPR_DT varchar(20) = NULL,
@p_SIGN_USER varchar(15) = NULL,
@p_SIGN_DT varchar(20) = NULL,
@p_FROM_DATE VARCHAR(20) = NULL,
@p_TO_DATE VARCHAR(20) = NULL,
@p_NOTES nvarchar(MAX) = NULL,
@p_CAR_ID varchar(15) = NULL,
@p_DRIVER_ID varchar(15) = NULL,
@p_QUANTITY_TRIP int = NULL,
@p_NOTES_TRIP nvarchar(MAX) = NULL,
@p_UNIT_TRIP varchar(5) = NULL,
@p_TO_TRIP nvarchar(100) = NULL,
@p_FROM_TRIP nvarchar(100) = NULL,
@p_MILRAGE_TRIP int = NULL,
@p_START_TIME_TRIP VARCHAR(20) = NULL,
@p_QUANTITY_RETURN_TRIP int = NULL,
@p_NOTES_RETURN_TRIP nvarchar(MAX) = NULL,
@p_UNIT_RETURN_TRIP varchar(5) = NULL,
@p_TO_RETURN_TRIP nvarchar(MAX) = NULL,
@p_FROM_RETURN_TRIP nvarchar(MAX) = NULL,
@p_MILRAGE_RETURN_TRIP int = NULL,
@p_START_TIME_RETURN_TRIP VARCHAR(20) = NULL,
@p_AUTH_STATUS varchar(1) = NULL,
@p_APPROVE_DT varchar(20) = NULL,
@p_CREATE_DT varchar(20) = NULL,
@p_MAKER_ID varchar(20) = NULL,
@p_MAKER_PHONE varchar(20) = NULL,
@p_IS_CONFIRM_COST varchar(1) = NULL,
@p_IS_CONTRACT_CAR varchar(1) = NULL,
@p_ListCarDT xml
AS
 BEGIN TRANSACTION
  
	exec [TR_CODE_GenKey] 'TR_REQUEST_CAR', '','PYC-XE', @p_REQ_CODE OUT
    
	--IF EXISTS(SELECT * FROM TR_REQUEST_DOC WHERE [REQ_CODE] = @p_REQ_CODE)
	--BEGIN
	--	ROLLBACK TRANSACTION
	--	SELECT '-1' Result, '' REQ_ID, N'Số phiếu yêu cầu đã tồn tại' ErrorDesc
	--	RETURN '-1'
	--END

	--IF(@p_REQ_CODE IS NULL OR @p_REQ_CODE ='')
	--BEGIN
	--	ROLLBACK TRANSACTION
	--	SELECT '-1' Result, '' REQ_ID, N'Mã phiếu yêu cầu bắt buộc nhập' ErrorDesc 
	--	RETURN '-1'
	--END
		--insert master				
		DECLARE @l_REQ_ID VARCHAR(15)
		EXEC SYS_CodeMasters_Gen 'TR_REQUEST_CAR', @l_REQ_ID out
		IF @l_REQ_ID='' OR @l_REQ_ID IS NULL GOTO ABORT

		INSERT INTO dbo.TR_REQUEST_CAR
		(
		    REQ_ID,REQ_CODE,CREATE_DT,MAKER_ID,EMP_ID,MAKER_PHONE,BRANCH_ID,BRANCH_CREATE,DEP_ID,DEP_CREATE,ORIGN,DESTINATION,REQ_DT,IS_SEND_APPR,FROM_DATE,TO_DATE,NOTES,IS_CONFIRM_COST,IS_CONTRACT_CAR,PROCESS_ID,UNIT_TRIP,TO_TRIP,FROM_TRIP,START_TIME_TRIP,NOTES_TRIP,QUANTITY_TRIP,UNIT_RETURN_TRIP,QUANTITY_RETURN_TRIP,START_TIME_RETURN_TRIP,FROM_RETURN_TRIP,TO_RETURN_TRIP,AUTH_STATUS
		)
		VALUES
		(   
			@l_REQ_ID,@p_REQ_CODE,CONVERT(DATETIME, @p_CREATE_DT, 103),@p_MAKER_ID,@p_MAKER_ID,@p_MAKER_PHONE,@p_BRANCH_ID,@p_BRANCH_CREATE,@p_DEP_ID,@p_DEP_CREATE,@p_ORIGN,@p_DESTINATION,CONVERT(DATETIME,@p_REQ_DT,103),@p_IS_SEND_APPR,CONVERT(DATETIME,@p_FROM_DATE,103),CONVERT(DATETIME,@p_TO_DATE,103),@p_NOTES,@p_IS_CONFIRM_COST,@p_IS_CONTRACT_CAR,'INSERT',@p_UNIT_TRIP,@p_DESTINATION,@p_ORIGN,CONVERT(DATETIME,@p_FROM_DATE,103),@p_NOTES_TRIP,@p_QUANTITY_TRIP,@p_UNIT_RETURN_TRIP,@p_QUANTITY_TRIP,CONVERT(DATETIME,@p_TO_DATE,103),@p_DESTINATION,@p_ORIGN,'E'
		)
		IF @@Error <> 0 GOTO ABORT
		--INSERT INTO dbo.PL_PROCESS
		--			(
		--			    REQ_ID,
		--			    PROCESS_ID,
		--			    CHECKER_ID,
		--			    APPROVE_DT,
		--			    PROCESS_DESC,
		--			    NOTES
		--			)
		--			VALUES
		--			(   @l_REQ_ID,       
		--				'INSERT',
		--			    @p_MAKER_ID,        
		--			    GETDATE(), 
		--			    N'Thêm mới PYC xe thành công' ,      
		--			    N'Thêm mới PYC xe'       
		--			 )
COMMIT TRANSACTION
SELECT '0' as Result, @l_REQ_ID  REQ_ID,@p_REQ_CODE REQ_CODE, N'Thêm mới PYC xe thành công' ErrorDesc
RETURN '0'
ABORT:
BEGIN
		ROLLBACK TRANSACTION
		SELECT '-1' AS RESULT
		RETURN '-1'
End