|
1
|
SELECT P.REQ_CODE AS SO_TO_TRINH, P.REQ_CONTENT AS NOI_DUNG_TO_TRINH, P.TOTAL_AMT AS GIA_TRI_TO_TRINH,
|
|
2
|
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,
|
|
3
|
L1.CHECKER_ID AS GDV,
|
|
4
|
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,
|
|
5
|
KS.CHECKER_ID AS KSV,
|
|
6
|
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
|
|
7
|
FROM PL_REQUEST_DOC P
|
|
8
|
LEFT JOIN
|
|
9
|
(
|
|
10
|
SELECT L1.REQ_ID, L1.CHECKER_ID, L1.APPROVE_DT
|
|
11
|
FROM
|
|
12
|
PL_PROCESS L1 WHERE L1.PROCESS_ID ='KT' AND L1.NOTES =N'Điều phối Xử lý phiếu'
|
|
13
|
AND L1.CHECKER_ID IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
|
|
14
|
AND L1.REQ_ID IN (SELECT REQ_ID FROM PL_REQUEST_DOC)
|
|
15
|
) TF ON P.REQ_ID = TF.REQ_ID
|
|
16
|
LEFT JOIN
|
|
17
|
(
|
|
18
|
SELECT L1.REQ_ID, L1.CHECKER_ID, L1.APPROVE_DT
|
|
19
|
FROM
|
|
20
|
PL_PROCESS L1 WHERE L1.PROCESS_ID ='SEND' AND L1.NOTES =N'Nhân viên xử lý gửi phê duyệt'
|
|
21
|
AND L1.CHECKER_ID IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
|
|
22
|
AND L1.REQ_ID IN (SELECT REQ_ID FROM PL_REQUEST_DOC)
|
|
23
|
) L1 ON P.REQ_ID = L1.REQ_ID
|
|
24
|
LEFT JOIN
|
|
25
|
(
|
|
26
|
SELECT L1.REQ_ID, L1.CHECKER_ID, L1.APPROVE_DT
|
|
27
|
FROM
|
|
28
|
PL_PROCESS L1 WHERE L1.PROCESS_ID ='KT' AND L1.NOTES =N'Trưởng đơn vị đã phê duyệt'
|
|
29
|
AND L1.CHECKER_ID IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
|
|
30
|
AND L1.REQ_ID IN (SELECT REQ_ID FROM PL_REQUEST_DOC)
|
|
31
|
) KS ON P.REQ_ID = KS.REQ_ID
|
|
32
|
WHERE 1 =1
|
|
33
|
AND ((L1.APPROVE_DT >='2023-3-1' AND L1.APPROVE_DT <='2023-3-31') OR
|
|
34
|
(TF.APPROVE_DT >='2023-3-1' AND TF.APPROVE_DT <='2023-3-31')
|
|
35
|
OR (KS.APPROVE_DT >='2023-3-1' AND KS.APPROVE_DT <='2023-3-31'))
|
|
36
|
ORDER BY P.REQ_CODE
|
|
37
|
---- IN DS TO TRINH PHONG KE TOAN 2022921
|