Project

General

Profile

Feature #1468

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

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

Status:
New
Priority:
Normal
Assignee:
-
Start date:
03/23/2023
Due date:
% Done:

0%

Estimated time:
PYC_MUA_HANG.xlsx (24.1 KB) PYC_MUA_HANG.xlsx Luc Tran Van, 03/23/2023 09:25 AM
TR_REQUEST_JOB_FORM_PROCESS_Upd.txt (41.7 KB) TR_REQUEST_JOB_FORM_PROCESS_Upd.txt Luc Tran Van, 03/23/2023 09:26 AM
TR_REQUEST_CAR_SendApp.txt (11.6 KB) TR_REQUEST_CAR_SendApp.txt Luc Tran Van, 03/23/2023 09:43 AM
upd_trans_auto.txt (35.5 KB) upd_trans_auto.txt Luc Tran Van, 03/23/2023 10:05 AM
CM_BRANCH_Upd.txt (3.3 KB) CM_BRANCH_Upd.txt Luc Tran Van, 03/23/2023 10:21 AM
BIÊN BẢN HỌP-ngang.pdf (877 KB) BIÊN BẢN HỌP-ngang.pdf Luc Tran Van, 03/23/2023 10:42 AM
BIÊN BẢN HỌP-doc.pdf (796 KB) BIÊN BẢN HỌP-doc.pdf Luc Tran Van, 03/23/2023 10:42 AM
upd_CM_WORKFLOW_APPROVE_DATA.txt (6.42 KB) upd_CM_WORKFLOW_APPROVE_DATA.txt Luc Tran Van, 03/23/2023 10:56 AM
BIÊN BẢN HỌP-doc.pdf (799 KB) BIÊN BẢN HỌP-doc.pdf Luc Tran Van, 03/23/2023 11:04 AM
BIÊN BẢN HỌP-ngang.pdf (878 KB) BIÊN BẢN HỌP-ngang.pdf Luc Tran Van, 03/23/2023 11:04 AM
CM_BRANCH_Upd.txt (3.32 KB) CM_BRANCH_Upd.txt Luc Tran Van, 03/23/2023 11:14 AM
DANH SÁCH TỜ TRÌNH PHÊ DUYỆT.xlsx (10.3 KB) DANH SÁCH TỜ TRÌNH PHÊ DUYỆT.xlsx Luc Tran Van, 03/23/2023 11:15 AM
rpt_DRIVE_DT.txt (873 Bytes) rpt_DRIVE_DT.txt Luc Tran Van, 03/23/2023 11:23 AM
rpt_tr_req_driveDT.xlsx (13.1 KB) rpt_tr_req_driveDT.xlsx Luc Tran Van, 03/23/2023 11:24 AM
DATA_TTCT_0109.xlsx (23.9 KB) DATA_TTCT_0109.xlsx Luc Tran Van, 03/23/2023 11:36 AM
CON_REQUEST_DOC_BC01.xlsx (12.5 KB) CON_REQUEST_DOC_BC01.xlsx Luc Tran Van, 03/23/2023 02:38 PM
[rpt_CON_REQUEST_DOC_BC01].txt (6.85 KB) [rpt_CON_REQUEST_DOC_BC01].txt Luc Tran Van, 03/23/2023 02:40 PM
lay_data.txt (440 Bytes) lay_data.txt Luc Tran Van, 03/23/2023 03:45 PM
DATA_#17.txt (5.13 KB) DATA_#17.txt Luc Tran Van, 03/23/2023 03:49 PM
2.0 GET DATA FFILE DINH KEM.txt (326 Bytes) 2.0 GET DATA FFILE DINH KEM.txt Luc Tran Van, 03/23/2023 04:31 PM

History

#1 Updated by Luc Tran Van about 2 years ago

.net core\src\GSOFTcore.gAMSPro.Web.Host\wwwroot\Reports\TRADE

#11 Updated by Luc Tran Van about 2 years ago

INSERT INTO CM_ALLCODE (CDNAME, CDVAL, CONTENT, CDTYPE, LSTODR)
VALUES ('CT_GDK', 'tannv1', N'tannv1', 'REQ', 0);
INSERT INTO CM_ALLCODE (CDNAME, CDVAL, CONTENT, CDTYPE, LSTODR)
VALUES ('CT_GDK', 'chuongnv', N'chuongnv', 'REQ', 0);
INSERT INTO CM_ALLCODE (CDNAME, CDVAL, CONTENT, CDTYPE, LSTODR)
VALUES ('CT_GDK', 'thinhnh', N'thinhnh', 'REQ', 0);

#15 Updated by Luc Tran Van about 2 years ago

EXEC PL_REQ_PROCESS_CHILD_App 'PLRD00000206841','TKTGD','phuongnht','tannh1','',N'Phê duyệt','94358',0,NULL
EXEC dbo.PL_REQUEST_PROCESS_App @p_REQ_ID = 'PLRD00000206841', -- varchar(15)
@p_AUTH_STATUS = 'A', -- varchar(1)
@p_CHECKER_ID = 'trungnq1', -- varchar(15)
@p_APPROVE_DT = '23/03/2023', -- datetime
@p_ROLE_LOGIN = 'TGD', -- varchar(50)
@p_BRANCH_LOGIN = 'DV0001', -- varchar(15)
@p_PROCESS_DESC = N'Phê duyệt', -- nvarchar(max)
@p_IS_AUTHORITY =0

#20 Updated by Luc Tran Van about 2 years ago

SELECT * FROM TR_REQUEST_DOC_FILE WHERE REQ_ID =@REQ_ID

#21 Updated by Luc Tran Van about 2 years ago

DECLARE @REQ_ID VARCHAR
SET @REQ_ID=(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0120/2023/TTr-0690604')
SELECT * FROM CM_ATTACH_FILE WHERE REF_ID =@REQ_ID OR TRAN_ID=@REQ_ID
SELECT * FROM CM_ATTACH_FILE_HIST WHERE REF_ID =@REQ_ID
SELECT * FROM CM_ATTACH_FILE_LOG_V2 WHERE REF_ID =@REQ_ID OR REF_MASTER=@REQ_ID
SELECT * FROM PL_REQUEST_DOC_FILE WHERE REQ_ID =@REQ_ID

#22 Updated by Luc Tran Van about 2 years ago

DECLARE @REQ_ID VARCHAR
SET @REQ_ID=(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0120/2023/TTr-0690604')
SELECT * FROM CM_ATTACH_FILE caf WHERE caf.REF_ID IN (SELECT XZ.PL_REQUEST_DOC_FILE_ID FROM PL_REQUEST_DOC_FILE XZ WHERE XZ.REQ_ID = @REQ_ID) OR caf.REF_MASTER IN (SELECT XZ.PL_REQUEST_DOC_FILE_ID FROM PL_REQUEST_DOC_FILE XZ WHERE XZ.REQ_ID = @REQ_ID)

#23 Updated by Luc Tran Van about 2 years ago

UPDATE CM_DEPARTMENT
SET DEP_CODE = DEP_CODE + '-OLD'
WHERE RIGHT='0001' AND DEP_NAME=N'Ban giám đốc'
AND BRANCH_ID <> 'DV0001'

Also available in: Atom PDF