DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN - NH BẢN VIỆT - GD3

ALTER   PROC [dbo].[rpt_TR_REQ_PAY_Drive_DT_ById]

@p_REQ_PAY_ID varchar(15) = NULL,

@p_BRANCH_ID varchar(15) = NULL,

@p_DEP_ID varchar(15) = NULL,

@p_CHECKR_ID varchar(15) = NULL,

@p_CHECKR_ID_KT varchar(15) = NULL,

@p_APPROVE_DT_KT varchar(15) = NULL

AS

BEGIN

	SELECT TR.CREATE_DT, A.*, N'Nhiên liệu' AS PAY_TYPE_NAME, TR.REQ_PAY_CODE, BR.BRANCH_NAME, DP.DEP_NAME, GDV.TLFullName AS GDV, KSV.TLFullName AS KSV

	FROM TR_REQ_PAY_DRIVE_DT A 

	LEFT JOIN TR_REQ_PAYMENT TR ON A.REQ_PAY_ID = TR.REQ_PAY_ID

	LEFT JOIN CM_BRANCH BR ON BR.BRANCH_ID = @p_BRANCH_ID

	LEFT JOIN CM_DEPARTMENT DP ON DP.DEP_ID = @p_DEP_ID

	LEFT JOIN TL_USER KSV ON KSV.TLNANME = @p_CHECKR_ID

	LEFT JOIN TL_USER GDV ON GDV.TLNANME = @p_CHECKR_ID_KT

	WHERE A.REQ_PAY_ID =@p_REQ_PAY_ID

	SELECT TOP 1 A.PAY_PHASE

	FROM TR_REQ_PAY_DRIVE_DT A 

	WHERE A.REQ_PAY_ID =@p_REQ_PAY_ID

END