Project

General

Profile

Support #21

Script

Added by Truong Nguyen Vu about 5 years ago. Updated over 4 years ago.

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

0%

Estimated time:

Description

SELECT * FROM PL_REQUEST_DOC WHERE REQ_CODE=''
select * FROM PL_REQUEST_PROCESS WHERE REQ_ID='id tờ trình'

PLDOCSEARCH.txt (29.7 KB) PLDOCSEARCH.txt Truong Nguyen Vu, 05/12/2020 11:45 AM
PLREQUESTAPP.txt (50 KB) PLREQUESTAPP.txt Truong Nguyen Vu, 05/12/2020 12:01 PM
Script Update PL Truongnv 12052020.txt (49.2 KB) Script Update PL Truongnv 12052020.txt Luc Tran Van, 05/12/2020 12:54 PM
Data 1.PNG (38.7 KB) Data 1.PNG Luc Tran Van, 05/12/2020 02:43 PM
Data 2.PNG (22.4 KB) Data 2.PNG Luc Tran Van, 05/12/2020 02:43 PM
Loi to trinh chi Thuy.PNG (116 KB) Loi to trinh chi Thuy.PNG Luc Tran Van, 05/12/2020 03:08 PM
Loi to trinh chi Thuy 02.PNG (33.1 KB) Loi to trinh chi Thuy 02.PNG Luc Tran Van, 05/12/2020 03:10 PM
To trinh cua Chi Thuy.PNG (36.6 KB) To trinh cua Chi Thuy.PNG Luc Tran Van, 05/12/2020 03:33 PM
Loi double khi dieu phoi PYCMS.PNG (46.5 KB) Loi double khi dieu phoi PYCMS.PNG Luc Tran Van, 05/12/2020 04:46 PM
Loi 10.PNG (83.5 KB) Loi 10.PNG Luc Tran Van, 05/13/2020 09:38 AM
Loi 11.PNG (60.4 KB) Loi 11.PNG Luc Tran Van, 05/13/2020 09:38 AM
Loi 12.PNG (55 KB) Loi 12.PNG Luc Tran Van, 05/13/2020 09:46 AM
Data giao dich bi trung.PNG (76.3 KB) Data giao dich bi trung.PNG Luc Tran Van, 05/13/2020 09:50 AM
Data doble 2.PNG (38.5 KB) Data doble 2.PNG Luc Tran Van, 05/13/2020 10:08 AM
Data doble 3.PNG (23 KB) Data doble 3.PNG Luc Tran Van, 05/13/2020 10:10 AM
TRREQUESTSEARCH.txt (39.9 KB) TRREQUESTSEARCH.txt Truong Nguyen Vu, 05/13/2020 10:21 AM
Loi cap phe duyet.PNG (81.1 KB) Loi cap phe duyet.PNG Quân Võ Thị Ánh, 05/13/2020 10:42 AM
Data phieu 25 trieu.PNG (109 KB) Data phieu 25 trieu.PNG Quân Võ Thị Ánh, 05/13/2020 10:45 AM
Data master 25 trieu_.PNG (16.1 KB) Data master 25 trieu_.PNG Quân Võ Thị Ánh, 05/13/2020 10:47 AM
Chi Chi khong thay nut duyet.PNG (162 KB) Chi Chi khong thay nut duyet.PNG Quân Võ Thị Ánh, 05/13/2020 11:15 AM
Data Full.PNG (156 KB) Data Full.PNG Luc Tran Van, 05/13/2020 11:46 AM
Data Chitn.PNG (151 KB) Data Chitn.PNG Luc Tran Van, 05/13/2020 01:46 PM
Buoc tiep theo PYCMS.PNG (78.6 KB) Buoc tiep theo PYCMS.PNG Luc Tran Van, 05/13/2020 03:48 PM
Data PYCMS 25 trieu.PNG (112 KB) Data PYCMS 25 trieu.PNG Luc Tran Van, 05/13/2020 03:52 PM
Fulldata 25 trieu.PNG (35.3 KB) Fulldata 25 trieu.PNG Luc Tran Van, 05/13/2020 04:11 PM
UPDATE APP REQ 1.txt (35.7 KB) UPDATE APP REQ 1.txt Truong Nguyen Vu, 05/15/2020 09:59 AM
UPDATE APP REQ 2.txt (15.6 KB) UPDATE APP REQ 2.txt Truong Nguyen Vu, 05/15/2020 09:59 AM
UPDATE INSERT PO.txt (7.59 KB) UPDATE INSERT PO.txt Truong Nguyen Vu, 05/15/2020 09:59 AM
Loi 20.PNG (77.9 KB) Loi 20.PNG Luc Tran Van, 05/15/2020 11:45 AM
UPDATE APP REQ 3.txt (21 KB) UPDATE APP REQ 3.txt Truong Nguyen Vu, 05/15/2020 11:49 AM
Loi 22.PNG (90.3 KB) Loi 22.PNG Luc Tran Van, 05/15/2020 02:05 PM
Data PGD Phu Tan.PNG (171 KB) Data PGD Phu Tan.PNG Luc Tran Van, 05/15/2020 02:30 PM
UPDATE SEARCH REQ 4.txt (29.7 KB) UPDATE SEARCH REQ 4.txt Truong Nguyen Vu, 05/15/2020 02:38 PM
Chi Chi khong thay nut duyet.PNG (162 KB) Chi Chi khong thay nut duyet.PNG Luc Tran Van, 05/15/2020 03:50 PM
Data 4h03.PNG (79.4 KB) Data 4h03.PNG Luc Tran Van, 05/15/2020 04:02 PM
Cap duyet tiep theo.PNG (112 KB) Cap duyet tiep theo.PNG Luc Tran Van, 05/15/2020 04:18 PM
cHILD.PNG (26.1 KB) cHILD.PNG Luc Tran Van, 05/15/2020 04:23 PM
Data 4h08.PNG (40.4 KB) Data 4h08.PNG Luc Tran Van, 05/15/2020 04:28 PM
Anhh cuong ko cap nhat duoc phieu.PNG (129 KB) Anhh cuong ko cap nhat duoc phieu.PNG Luc Tran Van, 05/15/2020 05:32 PM

History

#2 Updated by Thủy Nguyễn Thị Xuân about 5 years ago

ID

REQ_ID

PROCESS_ID

STATUS

ROLE_USER

BRANCH_ID

CHECKER_ID

APPROVE_DT

PARENT_PROCESS_ID

IS_LEAF

COST_ID

DVDM_ID

NOTES

IS_HAS_CHILD

DEP_ID

1577 PLRD00000016121 APPNEW P GDDV DV0001 tp_spmk 5/12/2020 11:36:38 AM N Trưởng đơn vị phê duyệt DEP000000000051
1578 PLRD00000016121 DVCM P GDDV tp_thuonghieu 5/12/2020 11:45:39 AM APPNEW N DM0000000000004 Đơn vị chuyên môn đã phê duyệt
1579 PLRD00000016121 DVCM P GDDV phuongtln 5/12/2020 11:43:43 AM APPNEW N DM0000000000003 Đơn vị chuyên môn đã phê duyệt
1580 PLRD00000016121 DVDM_DC C GDDV DVCM N Chờ đơn vị đầu mối xác nhận
1581 PLRD00000016121 TC U TC DVDM_DC N Chờ đơn vị Tài chính xác nhận
1582 PLRD00000016121 GDK_DC U GDK 5/12/2020 11:36:38 AM TC N Chờ giám đốc khối xác nhận
1583 PLRD00000016121 APPROVE U GDK_DC Y Hoàn tất

#3 Updated by Truong Nguyen Vu about 5 years ago

DELETE FROM dbo.PL_REQUEST_PROCESS WHERE ID='1580'

UPDATE dbo.PL_REQUEST_PROCESS SET PARENT_PROCESS_ID='DVCM' WHERE ID='1581'

#6 Updated by Truong Nguyen Vu about 5 years ago

SELECT * FROM dbo.PL_REQUEST_DOC WHERE REQ_CODE=''
SELECT * FROM dbo.PL_REQUEST_TRANSFER WHERE REQ_DOC_ID=''
SELECT * FROM dbo.PL_REQUEST_PROCESS WHERE REQ_ID=''

#7 Updated by Luc Tran Van about 5 years ago

Tờ trình này đang chờ trưởng đơn vị chuyên môn phê duyệt nhung truong dv chuyen mon vao thi ko thay nut duyet

REQ_ID

REQ_CODE

REQ_NAME

REQ_DT

REQ_TYPE

REQ_CONTENT

REQ_REASON

BRANCH_ID

TOTAL_AMT

NOTES

RECORD_STATUS

MAKER_ID

CREATE_DT

AUTH_STATUS

CHECKER_ID

APPROVE_DT

PROCESS_ID

DVDM_APP_ID

REQ_PARENT_ID

BRANCH_FEE

EFFEC_DT

IS_BACKDAY

DEP_ID

DEP_FEE

BRANCH_CREATE

DEP_CREATE

REQ_LINE

TC_NOTES

PLRD00000016125 0014/2020/TT-PPTSP Quảng cáo Pano ngoài trời 5/12/2020 12:00:00 AM 1 Quảng cáo Pano ngoài trời Quảng cáo Pano ngoài trời DV0001 2000000000 1 pspmk01 5/12/2020 12:00:00 AM A tp_spmk 5/12/2020 2:06:17 PM DVCM DV0001 DEP000000000051 DEP000000000051 DV0001 DEP000000000051

ID

REQ_ID

PROCESS_ID

STATUS

ROLE_USER

BRANCH_ID

CHECKER_ID

APPROVE_DT

PARENT_PROCESS_ID

IS_LEAF

COST_ID

DVDM_ID

NOTES

IS_HAS_CHILD

DEP_ID

1587 PLRD00000016125 APPNEW P GDDV DV0001 tp_spmk 5/12/2020 2:07:05 PM N Trưởng đơn vị phê duyệt DEP000000000051
1588 PLRD00000016125 DVCM C GDDV APPNEW N DM0000000000008 Chờ đơn vị chuyên môn xác nhận
1589 PLRD00000016125 GDK_TT U GDK DVCM N DM0000000000015 Chờ giám đốc khối xác nhận
1590 PLRD00000016125 PTGDK_TT U PTGD GDK_TT N DM0000000000015 Chờ phó tổng giám đốc khối xác nhận
1591 PLRD00000016125 TGD U TGD PTGDK_TT N Chờ tổng giám đốc xác nhận
1592 PLRD00000016125 APPROVE U TGD Y Hoàn

#8 Updated by Luc Tran Van about 5 years ago

2- Tờ trình trưởng đơn vị duyệt nhưng báo lỗi chưa chọn hạng mục ngân sách

REQ_ID

REQ_CODE

REQ_NAME

REQ_DT

REQ_TYPE

REQ_CONTENT

REQ_REASON

BRANCH_ID

TOTAL_AMT

NOTES

RECORD_STATUS

MAKER_ID

CREATE_DT

AUTH_STATUS

CHECKER_ID

APPROVE_DT

PROCESS_ID

DVDM_APP_ID

REQ_PARENT_ID

BRANCH_FEE

EFFEC_DT

IS_BACKDAY

DEP_ID

DEP_FEE

BRANCH_CREATE

DEP_CREATE

REQ_LINE

TC_NOTES

PLRD00000016117 0007/2020/TT-PTH&Q Mascot Vie 5/11/2020 12:00:00 AM 1 Mascot Vie Mascot Vie DV0001 300000000 1 thuonghieu_0 5/11/2020 12:00:00 AM U APPNEW DV0001 DEP000000000015 DEP000000000015 DV0001 DEP000000000015

REQ_TRANSFER_ID

REQ_DOC_ID

FR_PLAN_ID

FR_TRADE_ID

FR_GOOD_ID

FR_BRN_ID

TO_BRN_ID

TO_PLAN_ID

TO_TRADE_ID

TO_GOOD_ID

QTY

TOTAL_AMT

NOTES

AUTH_STATUS

MAKER_ID

CREATE_DT

CHECKER_ID

APPROVE_DT

TO_DVDM_ID

FR_DEP_ID

TO_DEP_ID

TO_KHOI_ID

FR_DVDM_ID

FR_KHOI_ID

PLRT00000012090 PLRD00000016117 GOO000000001498 DV0001 DV0001 GOO000000345010 0 330000000.00 E thuonghieu_0 5/11/2020 12:00:00 AM DM0000000000004 DEP000000000015 DEP000000000015 DM0000000000015 DM0000000000004 DM0000000000015

ID

REQ_ID

PROCESS_ID

STATUS

ROLE_USER

BRANCH_ID

CHECKER_ID

APPROVE_DT

PARENT_PROCESS_ID

IS_LEAF

COST_ID

DVDM_ID

NOTES

IS_HAS_CHILD

DEP_ID

1585 PLRD00000016117 APPNEW C GDDV DV0001 N Chờ trưởng đơn vị phê duyệt DEP00000000001

#9 Updated by Luc Tran Van about 5 years ago

#12 Updated by Truong Nguyen Vu about 5 years ago

UPDATE dbo.PL_REQUEST_PROCESS SET PARENT_PROCESS_ID='DVCM',STATUS='C' WHERE ID='1581'

#13 Updated by Luc Tran Van about 5 years ago

Tờ trình của Chị Thủy, Phòng tài chính đã xác nhận xong, nhưng sao lại thông báo khối hỗ trợ xác nhận

#16 Updated by Luc Tran Van about 5 years ago

Loi 12: Bi dup khi tim kiem dieu phoi PYCMS

#17 Updated by Truong Nguyen Vu about 5 years ago

UPDATE dbo.PL_REQUEST_PROCESS SET STATUS='C', PARENT_PROCESS_ID='TGD' WHERE ID='1620'

UPDATE dbo.PL_REQUEST_DOC SET PROCESS_ID='APPROVE' WHERE REQ_ID='PLRD00000016114'

#19 Updated by Truong Nguyen Vu about 5 years ago

EXEC dbo.PL_REQ_DOC_UPDATE_AFTER_APPROVE @p_REQ_ID = 'PLRD00000016114'
EXEC dbo.PL_REQ_DOC_Ins_To_TR_REQ_DOC @p_PL_REQ_ID = 'PLRD00000016114'

#20 Updated by Truong Nguyen Vu about 5 years ago

SELECT * FROM dbo.PL_REQUEST_PROCESS_CHILD WHERE REQ_ID=''

#24 Updated by Quân Võ Thị Ánh about 5 years ago

#25 Updated by Quân Võ Thị Ánh about 5 years ago

#26 Updated by Quân Võ Thị Ánh about 5 years ago

#27 Updated by Truong Nguyen Vu about 5 years ago

DELETE FROM dbo.PL_REQUEST_PROCESS WHERE ID=571

#30 Updated by Truong Nguyen Vu about 5 years ago

DELETE FROM dbo.PL_REQUEST_PROCESS WHERE ID='1638'

UPDATE dbo.PL_REQUEST_PROCESS SET STATUS='C' ,PARENT_PROCESS_ID='DMMS' WHERE ID=1610
UPDATE dbo.PL_REQUEST_PROCESS SET STATUS='C' ,PARENT_PROCESS_ID='DMMS' WHERE ID=1611
UPDATE dbo.PL_REQUEST_PROCESS SET PARENT_PROCESS_ID='PDYC_1' WHERE ID=1613

#32 Updated by Truong Nguyen Vu about 5 years ago

UPDATE dbo.TR_REQUEST_DOC SET PROCESS_ID='DVCM' WHERE REQ_ID='' copy cái ID vào.

#37 Updated by Luc Tran Van about 5 years ago

Phe duyet to trinh chu truong bi sai

#43 Updated by Truong Nguyen Vu about 5 years ago

UPDATE dbo.TR_REQUEST_DOC SET PROCESS_ID='DMMS' WHERE REQ_ID='TRRD00000023067'
DELETE FROM dbo.PL_REQUEST_PROCESS WHERE ID=1696
DELETE FROM dbo.PL_REQUEST_PROCESS WHERE ID=1697
UPDATE dbo.PL_REQUEST_PROCESS SET STATUS='C', PARENT_PROCESS_ID='APPNEW' WHERE ID=1688

#45 Updated by Luc Tran Van about 5 years ago

#47 Updated by Truong Nguyen Vu about 5 years ago

UPDATE dbo.PL_REQUEST_PROCESS SET STATUS='C', PARENT_PROCESS_ID='APPNEW' WHERE ID=1689
UPDATE dbo.PL_REQUEST_PROCESS SET STATUS='P' WHERE ID=1688

#49 Updated by Luc Tran Van over 4 years ago

  • Status changed from New to Closed

Also available in: Atom PDF