SELECT A.REQ_PAY_CODE SO_PHIEU_HOAN_UNG, B.BRANCH_CODE MA_DON_VI, B.BRANCH_NAME TEN_DON_VI, A.CREATE_DT NGAY_TAO, A.APPROVE_DT_KT NGAY_DUYET_KT, A.MAKER_ID + ' - ' + F.TLFullName NGUOI_TAM_UNG, 
E.CUSTOMER_NAME TEN_KHACH_HANG, E.CMND, A.REQ_REASON NOI_DUNG, A.REQ_AMT SO_TIEN, A.PAY_AMT SO_TIEN_DA_HOAN_UNG, 
CASE 
	WHEN ISNULL(A.REQ_AMT, 0) = ISNULL(A.PAY_AMT, 0) THEN N'Đã hoàn ứng'
	ELSE N'Chưa hoàn ứng xong'
END TRANG_THAI_HOAN_UNG,
[dbo].[FN_GET_PAYMENT_OF_ADVANCE_PAYMENT](A.REQ_PAY_ID) SO_PHIEU_HOAN_UNG
FROM TR_REQ_ADVANCE_PAYMENT A
LEFT JOIN CM_BRANCH B ON A.BRANCH_ID = B.BRANCH_ID
LEFT JOIN  CM_DEPARTMENT C ON A.DEP_ID = C.DEP_ID
LEFT JOIN TR_REQ_ADVANCE_CUS D ON A.REQ_PAY_ID = D.REQ_PAY_ID
LEFT JOIN LS_CUSTOMER E ON D.CUST_ID = E.CUSTOMER_ID
LEFT JOIN TL_USER F ON A.MAKER_ID = F.TLNANME
WHERE 1=1 
AND A.REQ_TYPE = 'D' AND A.AUTH_STATUS_KT = 'A'
ORDER BY TRANG_THAI_HOAN_UNG DESC, NGAY_DUYET_KT DESC

GO

--23062023_secretkey