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

ALTER PROCEDURE [dbo].[TR_CONTRACT_ById]

@P_CONTRACT_ID varchar(15),

@P_CONTRACT_CODE varchar(15) = NULL

AS

--------------BAODNQ 22/2/2022: select thêm cột------------------

SELECT A.*,

	B.REQ_CODE AS SO_PYC,

	C.REQ_NAME AS TEN_PYC,

	C.REQ_CODE AS SO_TT_CT,

	C.REQ_DT AS NGAY_NHAN_TT,

	C.APPROVE_DT AS NGAY_DUYET_TT,

	D.BID_CODE,

	E.SUP_CODE,

	E.SUP_NAME,

	E.TEL AS SUP_TEL,

	E.ADDR,

	E.CONTACT_PERSON AS SUP_CONTACT_PERSON,

	F.BRANCH_NAME,

	H.CUSTOMER_NAME AS CUST_NAME

FROM TR_CONTRACT A

LEFT JOIN TR_REQUEST_DOC B ON A.REQ_DOC_ID = B.REQ_ID

LEFT JOIN PL_REQUEST_DOC C ON B.PL_REQ_ID = C.REQ_ID

LEFT JOIN BID_MASTER D ON A.BID_ID = D.BID_ID

LEFT JOIN CM_SUPPLIER E ON A.SUP_ID = E.SUP_ID

LEFT JOIN CM_BRANCH F ON A.BRANCH_ID = F.BRANCH_ID

LEFT JOIN LS_CUSTOMER H ON A.CUST_ID = H.CUSTOMER_ID

WHERE  A.CONTRACT_ID = @P_CONTRACT_ID 

OR A.CONTRACT_CODE=@P_CONTRACT_CODE