SELECT A.REQ_PAY_CODE, A.MAKER_ID AS NGUOI_TAO, B.BRANCH_CODE AS MA_DV_TAO, B.BRANCH_NAME AS TEN_DV_TAO,A.REQ_AMT AS SO_TIEN,
CASE WHEN A.REQ_TYPE ='I' THEN N'Thanh toán hoàn tạm ứng' WHEN A.REQ_TYPE ='P' THEN N'Thanh toán nhà cung cấp'
ELSE N'Thanh toán khác' END AS N'LOẠI_THANH_TOÁN',
A.MAKER_ID_KT AS GDV, A.CHECKER_ID_KT AS KSV, A.CONFIRM_NOTE AS N'Ý KIẾN KT', 'TT' AS LOẠI_PHIẾU FROM TR_REQ_PAYMENT A
LEFT JOIN CM_BRANCH B ON A.BRANCH_CREATE = B.BRANCH_ID
WHERE A.AUTH_STATUS_KT ='A' AND CONVERT(DATE, A.APPROVE_DT_KT, 103) >= '2021-07-01'
AND CONVERT(DATE, A.APPROVE_DT_KT, 103) <= '2021-10-01' AND A.CONFIRM_NOTE IS NOT NULL AND A.CONFIRM_NOTE <> ''
UNION
SELECT A.REQ_PAY_CODE, A.MAKER_ID AS NGUOI_TAO, B.BRANCH_CODE AS MA_DV_TAO, B.BRANCH_NAME AS TEN_DV_TAO,A.REQ_AMT AS SO_TIEN,
CASE WHEN A.REQ_TYPE ='I' THEN N'Thanh toán hoàn tạm ứng' WHEN A.REQ_TYPE ='P' THEN N'Thanh toán nhà cung cấp'
ELSE N'Thanh toán khác' END AS N'LOẠI_THANH_TOÁN',
A.MAKER_ID_KT AS GDV, A.CHECKER_ID_KT AS KSV, A.CONFIRM_NOTES AS N'Ý KIẾN KT', 'TU' AS LOẠI_PHIẾU FROM TR_REQ_ADVANCE_PAYMENT A
LEFT JOIN CM_BRANCH B ON A.BRANCH_CREATE = B.BRANCH_ID
WHERE A.AUTH_STATUS_KT ='A' AND CONVERT(DATE, A.APPROVE_DT_KT, 103) >= '2021-07-01'
AND CONVERT(DATE, A.APPROVE_DT_KT, 103) <= '2021-10-01' AND A.CONFIRM_NOTES IS NOT NULL AND A.CONFIRM_NOTES <> ''

UPDATE TR_REQ_ADVANCE_PAYMENT SET AUTH_STATUS ='A', AUTH_STATUS_KT ='A', CREATE_DT_KT ='2016-11-25', APPROVE_DT ='2016-11-25', CREATE_DT ='2016-11-25',
APPROVE_DT_KT ='2016-11-25', MAKER_ID_KT ='admin', CHECKER_ID_KT ='admin', CHECKER_ID ='admin' WHERE REQ_PAY_CODE ='NCC.2021.000801'

---2021101