Project

General

Profile

Feature #1533

VẬN HÀNH DỰ ÁN SAU GOLIVE NGÀY 17.05.2023

Added by Luc Tran Van about 2 years ago. Updated about 2 years ago.

Status:
New
Priority:
Normal
Assignee:
Luc Tran Van
Start date:
05/17/2023
Due date:
% Done:

0%

Estimated time:
rpt_TR_REQUEST_CAR.txt (5.66 KB) rpt_TR_REQUEST_CAR.txt Luc Tran Van, 05/17/2023 09:09 AM
error_register_payment_auto.txt (652 Bytes) error_register_payment_auto.txt Luc Tran Van, 05/17/2023 09:30 AM
lấy data tờ trình.txt (226 Bytes) lấy data tờ trình.txt Luc Tran Van, 05/17/2023 09:40 AM
data_#3.txt (77.5 KB) data_#3.txt Luc Tran Van, 05/17/2023 09:48 AM
GET DATA TRONG NGÀY 17.txt (72 Bytes) GET DATA TRONG NGÀY 17.txt Luc Tran Van, 05/17/2023 09:53 AM
DATA_#5_17052023.xlsx (28.8 KB) DATA_#5_17052023.xlsx Luc Tran Van, 05/17/2023 09:59 AM
HUY PHIEU.txt (719 Bytes) HUY PHIEU.txt Luc Tran Van, 05/17/2023 01:41 PM
TR_REQUEST_JOB_FORM_PROCESS_Upd_1705.txt (42 KB) TR_REQUEST_JOB_FORM_PROCESS_Upd_1705.txt Luc Tran Van, 05/17/2023 01:43 PM
payment_kt_app_170523.txt (21.2 KB) payment_kt_app_170523.txt Luc Tran Van, 05/17/2023 02:06 PM
DATA_TTCT_0014.xlsx (23.5 KB) DATA_TTCT_0014.xlsx Luc Tran Van, 05/17/2023 03:13 PM
DATA_TTCT_0073.xlsx (23.8 KB) DATA_TTCT_0073.xlsx Luc Tran Van, 05/17/2023 03:29 PM
check_block.txt (825 Bytes) check_block.txt Luc Tran Van, 05/17/2023 04:05 PM
New Text Document.txt (107 Bytes) New Text Document.txt Luc Tran Van, 05/17/2023 04:24 PM
TL_USER_DATA.zip (372 KB) TL_USER_DATA.zip Luc Tran Van, 05/17/2023 04:55 PM
res_holiday.txt (716 Bytes) res_holiday.txt Luc Tran Van, 05/17/2023 05:02 PM
advance_payment_kt_app_17052023.txt (7.1 KB) advance_payment_kt_app_17052023.txt Luc Tran Van, 05/17/2023 05:10 PM
New Text Document.txt (105 Bytes) New Text Document.txt Luc Tran Van, 05/17/2023 05:13 PM

History

#7 Updated by Luc Tran Van about 2 years ago

SELECT CONTENT FROM CM_REQUEST_TEMPLATE WHERE REQUEST_TEMPLATE_CODE='000018/2023/TTr-P.HC-BP.MH' ---17052023_SECRETKEY

#13 Updated by Luc Tran Van about 2 years ago

UPDATE PL_REQUEST_PROCESS SET ROLE_USER='TBP' WHERE ID ='109857'---17052023_SECRETKEY

#15 Updated by Luc Tran Van about 2 years ago

SELECT A.REQ_ID, A.SIGN_USER, B.RoleName, C.ROLE_USER AS 'ROLE_FLOW' FROM PL_REQUEST_DOC A
INNER JOIN TL_USER B ON A.SIGN_USER = B.TLNANME
INNER JOIN PL_REQUEST_PROCESS C ON A.REQ_ID = C.REQ_ID AND C.PROCESS_ID ='SIGN' AND C.STATUS ='C'
WHERE YEAR=2023 ----18052023_SECRETKEY

#17 Updated by Luc Tran Van about 2 years ago

EXEC dbo.sp_generate_inserts @table_name = 'TL_USER', -- varchar(776)
@from = 'FROM TL_USER' -- varchar(800) 18052023_SECRETKEY

Also available in: Atom PDF