DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN NGÂN HÀNG BẢN VIỆT

ALTER PROCEDURE [dbo].[rpt_InventoryTRReport]

@p_REQ_CODE	varchar(50)	= NULL,

@p_REQ_NAME	nvarchar(500)	= NULL,

@p_FromDate VARCHAR(20) = NULL,

@p_ToDate VARCHAR(20) = NULL,

@p_DEP_ID VARCHAR(20) = NULL,

@p_BRANCH_ID	varchar(20)	= NULL,

@p_BRANCH_LOGIN VARCHAR(20)= NULL,

@p_USER_LOGIN VARCHAR(15)= NULL

AS

BEGIN 

	SELECT 

	ROW_NUMBER() OVER (ORDER BY TR.REQ_CODE DESC) AS STT,Pl.REQ_CODE AS PL_REQ_CODE,TR.REQ_CODE,TR.REQ_REASON,TR.REQ_CONTENT,TR.TOTAL_AMT,CB.BRANCH_ID,CB.BRANCH_CODE,CB.BRANCH_NAME,CD.DEP_CODE,CD.DEP_NAME,TU.TLNANME,

	dbo.PL_PROCESS_CURRENT_NGUOIXULY(TR.REQ_ID,NULL,'PYC-DVKD',0) AS NGUOI_XU_LY,RPN.NOTES AS PROCESS_DES

	FROM dbo.TR_REQUEST_DOC TR

	LEFT JOIN dbo.PL_REQUEST_DOC PL ON PL.REQ_ID=TR.PL_REQ_ID

	LEFT JOIN dbo.CM_BRANCH CB ON CB.BRANCH_ID=TR.BRANCH_CREATE

	LEFT JOIN dbo.CM_DEPARTMENT CD ON CD.DEP_ID=TR.DEP_CREATE

	LEFT JOIN dbo.TL_USER TU ON TU.TLNANME=TR.MAKER_ID

	LEFT JOIN 

		(

			SELECT REQ_ID,PROCESS_ID,PARENT_PROCESS_ID,STATUS,NOTES FROM

			dbo.PL_REQUEST_PROCESS

			GROUP BY REQ_ID,PROCESS_ID,PARENT_PROCESS_ID,STATUS,NOTES

		) RPN ON RPN.REQ_ID=TR.REQ_ID AND TR.PROCESS_ID=RPN.PROCESS_ID

	WHERE 1=1 

	AND (PL.REQ_CODE LIKE '%' +@p_REQ_CODE+'%' OR @p_REQ_CODE ='' OR @p_REQ_CODE IS NULL)

	AND (PL.REQ_NAME LIKE '%' +@p_REQ_NAME+'%' OR @p_REQ_NAME ='' OR @p_REQ_NAME IS NULL)

	AND (TR.DEP_CREATE = @p_DEP_ID OR @p_DEP_ID IS NULL OR @p_DEP_ID ='')

	AND (TR.BRANCH_CREATE = @p_BRANCH_ID OR @p_BRANCH_ID IS NULL OR @p_BRANCH_ID ='')

	AND (CONVERT(DATE, TR.CREATE_DT, 103) >= CONVERT(DATE, @p_FromDate, 103) OR @p_FromDate IS NULL OR @p_FromDate ='')

	AND (CONVERT(DATE, TR.CREATE_DT, 103) <= CONVERT(DATE, @p_ToDate, 103) OR @p_ToDate IS NULL OR @p_ToDate ='')

	--ORDER BY A.CREATE_DT DESC

END