SAO KE PHIEU YEU CAU MUA SAM - chi van.txt - DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN NGÂN HÀNG BẢN VIỆT - Redmine

SAO KE PHIEU YEU CAU MUA SAM - chi van.txt

Luc Tran Van, 12/29/2020 10:13 AM

       ??SELECT  A.REQ_CODE AS N'S? phi?u y?u c?u', A.REQ_REASON AS N'N?i dung',X.SUM_MS_TOTRINH AS N'Ch? tr??ng', X.SUM_MS_THUCTE AS N'Th?c t?', A.USER_DVMS AS N'Ng??i th?c hi?n mua s?m', BR.BRANCH_NAME AS N'?n v? y?u c?u',
        DP.DEP_NAME AS N'Ph?ng ban y?u c?u', CASE WHEN A.PROCESS_ID ='APPROVE' THEN N'Ho?n t?t' ELSE N'ang th?c hi?n' END AS N'T?nh tr?ng th?c hi?n'
        FROM  TR_REQUEST_DOC A
       INNER JOIN
+      (
       SELECT  REQ_DOC_ID,SUM(TOTAL_AMT) AS SUM_MS_THUCTE, SUM(TOTAL_AMT_ETM) AS SUM_MS_TOTRINH FROM TR_REQUEST_DOC_DT
       GROUP BY REQ_DOC_ID
       ) X ON A.REQ_ID = X.REQ_DOC_ID
       INNER JOIN CM_BRANCH BR ON A.BRANCH_CREATE = BR.BRANCH_ID
       LEFT JOIN CM_DEPARTMENT DP ON A.DEP_CREATE = DP.DEP_ID
       INNER JOIN PL_REQUEST_PROCESS_CHILD P ON A.REQ_ID =P.REQ_ID
       WHERE CONVERT(DATE, P.TRANFER_DT, 103) >='2020-01-11' AND CONVERT(DATE, P.TRANFER_DT, 103) <='2020-12-31'
       AND P.TLNAME IN ('vanpt2','tanvt') AND TYPE_JOB ='KS'
       ORDER BY BR.BRANCH_NAME