Project

General

Profile

Bug #412

Tờ trình chủ trương số 0053/2020/TTr-0690604 thông báo không gửi phê duyệt được

Added by Luc Tran Van over 4 years ago. Updated over 4 years ago.

Status:
Feedback
Priority:
Normal
Assignee:
Truong Nguyen Vu
Start date:
10/12/2020
Due date:
% Done:

0%

Estimated time:
DATA 0053 2020 TTr-0690604.xlsx (25.2 KB) DATA 0053 2020 TTr-0690604.xlsx Luc Tran Van, 10/12/2020 09:29 AM
DATA 0053 2020 TTR 0690604.xlsx (24.7 KB) DATA 0053 2020 TTR 0690604.xlsx Luc Tran Van, 10/12/2020 11:48 AM
DATA 0053 2020 TTR 0690604 - Lan 02.xlsx (24.7 KB) DATA 0053 2020 TTR 0690604 - Lan 02.xlsx Luc Tran Van, 10/12/2020 11:52 AM
DATA TTCT 0053 2020 TTr-0690604 MỚI NHẤT.xlsx (24.9 KB) DATA TTCT 0053 2020 TTr-0690604 MỚI NHẤT.xlsx Luc Tran Van, 10/13/2020 03:01 PM
FILE 2.txt (508 Bytes) FILE 2.txt Truong Nguyen Vu, 10/13/2020 03:33 PM
FILE 3.txt (14.3 KB) FILE 3.txt Truong Nguyen Vu, 10/13/2020 03:42 PM

History

#1 Updated by Luc Tran Van over 4 years ago

  • Status changed from New to Accept

#2 Updated by Truong Nguyen Vu over 4 years ago

UPDATE dbo.PL_REQUEST_DOC_DT SET TRADE_ID='',PLAN_ID='',GOODS_ID='GOO000001063100' WHERE REQ_ID='PLRD00000200324'
UPDATE dbo.PL_REQUEST_TRANSFER SET TO_GOOD_ID='GOO000001063100',TO_BRN_ID='DV0001',TO_DEP_ID='DEP000000000011',TO_PLAN_ID='',TO_TRADE_ID='' WHERE REQ_DOC_ID='PLRD00000200324'

Do chọn hạng mục ngân sách hiện tại, ko cho chọn ngoài kế hoạch

#3 Updated by Truong Nguyen Vu over 4 years ago

Đã sửa code, phải cập nhật live

#4 Updated by Luc Tran Van over 4 years ago

ĐÃ CHẠY SCRIPT!

#5 Updated by Luc Tran Van over 4 years ago

SELECT * FROM PL_REQUEST_DOC WHERE REQ_CODE ='0053/2020/TTr-0690604'
SELECT * FROM PL_REQUEST_DOC_DT WHERE REQ_ID =(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0053/2020/TTr-0690604')
SELECT * FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID =(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0053/2020/TTr-0690604')
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID =(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0053/2020/TTr-0690604')

#10 Updated by Luc Tran Van over 4 years ago

  • Status changed from Accept to In Progress

#11 Updated by Luc Tran Van over 4 years ago

GOODS_ID TOTAL_AMT_EXE TOTAL_AMT_REMAIN TOTAL_TF
GOO000001063100 120000000.00 0.00 40000000.00

#13 Updated by Luc Tran Van over 4 years ago

  • Status changed from In Progress to Feedback

Anh Hùng - Phòng Hành Chính xác nhận OK.

Also available in: Atom PDF