SELECT P.REQ_CODE AS SO_TO_TRINH, P.REQ_CONTENT AS NOI_DUNG_TO_TRINH, P.TOTAL_AMT AS GIA_TRI_TO_TRINH,
CONVERT(VARCHAR,DAY(TF.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,MONTH(TF.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(TF.APPROVE_DT),2)  AS NGAY_NHAN_PHIEU,
L1.CHECKER_ID AS GDV,
CONVERT(VARCHAR,DAY(L1.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,MONTH(L1.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(L1.APPROVE_DT),2)  AS NGAY_GDV_GUI_DUYET,
KS.CHECKER_ID AS KSV,
CONVERT(VARCHAR,DAY(KS.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,MONTH(KS.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(KS.APPROVE_DT),2)  AS NGAY_KSV_PHE_DUYET
FROM PL_REQUEST_DOC P
LEFT JOIN 

(
SELECT L1.REQ_ID, L1.CHECKER_ID, L1.APPROVE_DT
FROM 
PL_PROCESS L1 WHERE L1.PROCESS_ID ='KT' AND L1.NOTES =N'Điều phối Xử lý phiếu' 
AND L1.CHECKER_ID IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
AND L1.REQ_ID IN (SELECT REQ_ID FROM PL_REQUEST_DOC)
) TF ON P.REQ_ID = TF.REQ_ID

LEFT JOIN 

(
SELECT L1.REQ_ID, L1.CHECKER_ID, L1.APPROVE_DT
FROM 
PL_PROCESS L1 WHERE L1.PROCESS_ID ='SEND' AND L1.NOTES =N'Nhân viên xử lý gửi phê duyệt' 
AND L1.CHECKER_ID IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
AND L1.REQ_ID IN (SELECT REQ_ID FROM PL_REQUEST_DOC)
) L1 ON P.REQ_ID = L1.REQ_ID

LEFT JOIN 

(
SELECT L1.REQ_ID, L1.CHECKER_ID, L1.APPROVE_DT
FROM 
PL_PROCESS L1 WHERE L1.PROCESS_ID ='KT' AND L1.NOTES =N'Trưởng đơn vị đã phê duyệt' 
AND L1.CHECKER_ID IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
AND L1.REQ_ID IN (SELECT REQ_ID FROM PL_REQUEST_DOC)
) KS ON P.REQ_ID = KS.REQ_ID
WHERE 1 =1 
AND ((L1.APPROVE_DT >='2022-12-1' AND L1.APPROVE_DT <='2022-12-30') OR
(TF.APPROVE_DT >='2022-12-1' AND TF.APPROVE_DT <='2022-12-30') 
OR (KS.APPROVE_DT >='2022-12-1' AND KS.APPROVE_DT <='2022-12-30'))
ORDER BY P.REQ_CODE

---- IN DS TO TRINH PHONG KE TOAN 20221221