Project

General

Profile

Feature #1417

VẬN HÀNH SAU GOLIVE NGÀY 08-12-2022

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

Status:
New
Priority:
Normal
Assignee:
Luc Tran Van
Start date:
12/07/2022
Due date:
% Done:

0%

Estimated time:
Hotfix1.zip (2.43 MB) Hotfix1.zip Luc Tran Van, 12/08/2022 09:32 AM
Hotfix2.zip (3.17 MB) Hotfix2.zip Luc Tran Van, 12/08/2022 09:32 AM
1.0 NF MESSAGE GETCONTENT.txt (141 KB) 1.0 NF MESSAGE GETCONTENT.txt Luc Tran Van, 12/08/2022 09:34 AM
Hotfix_1.zip (2.33 MB) Hotfix_1.zip Luc Tran Van, 12/08/2022 10:22 AM
Hotfix_2.zip (3 MB) Hotfix_2.zip Luc Tran Van, 12/08/2022 10:22 AM
DATA_#5_081222.xlsx (11.5 KB) DATA_#5_081222.xlsx Luc Tran Van, 12/08/2022 10:32 AM
PUR_2022_002937.txt (384 Bytes) PUR_2022_002937.txt Luc Tran Van, 12/08/2022 10:43 AM
PL_IMPORT_DT_ById.txt (290 Bytes) PL_IMPORT_DT_ById.txt Luc Tran Van, 12/08/2022 11:07 AM
DATA_#9_081222.xlsx (10.1 KB) DATA_#9_081222.xlsx Luc Tran Van, 12/08/2022 11:14 AM
tr_role_noti.txt (105 KB) tr_role_noti.txt Luc Tran Van, 12/08/2022 11:20 AM
CM_SUPPLIER_Ins.txt (2.71 KB) CM_SUPPLIER_Ins.txt Luc Tran Van, 12/08/2022 11:46 AM
[CM_SUPPLIER_Upd].txt (2.56 KB) [CM_SUPPLIER_Upd].txt Luc Tran Van, 12/08/2022 11:46 AM
DATA_TTDC_008_081222.xlsx (22.4 KB) DATA_TTDC_008_081222.xlsx Luc Tran Van, 12/08/2022 11:54 AM
DATA_081222.txt (2.08 MB) DATA_081222.txt Luc Tran Van, 12/08/2022 01:44 PM
Script_UPD_MW_081222.txt (681 Bytes) Script_UPD_MW_081222.txt Luc Tran Van, 12/08/2022 01:51 PM
[CM_SUPPLIER].txt (3.04 KB) [CM_SUPPLIER].txt Luc Tran Van, 12/08/2022 02:42 PM
DATA_TTDC_0004.xlsx (21.4 KB) DATA_TTDC_0004.xlsx Luc Tran Van, 12/08/2022 02:58 PM
tr_req_upd.txt (76.5 KB) tr_req_upd.txt Luc Tran Van, 12/08/2022 03:10 PM
tr_req_upd.txt (111 KB) tr_req_upd.txt Luc Tran Van, 12/08/2022 03:15 PM
DATA_#22.xlsx (12.7 KB) DATA_#22.xlsx Luc Tran Van, 12/08/2022 03:48 PM
Hotfix_1.zip (2.33 MB) Hotfix_1.zip Luc Tran Van, 12/08/2022 04:33 PM
Hotfix_2.zip (3 MB) Hotfix_2.zip Luc Tran Van, 12/08/2022 04:33 PM

History

#1 Updated by Luc Tran Van over 2 years ago

Language Text
Customer -> Quản lý khách hàng
NumberSheets -> Số tờ trình
NameSheets -> Tên tờ trình

#5 Updated by Luc Tran Van over 2 years ago

SELECT * FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/002937'
SELECT * FROM TR_REQUEST_DOC_DT WHERE REQ_DOC_ID = (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/002937')
SELECT * FROM PL_PROCESS WHERE REQ_ID = (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/002937')

#9 Updated by Luc Tran Van over 2 years ago

EXEC PL_REQUEST_DOC_ById @p_REQ_ID = 'PLRD00000205924'
,@p_USER_LOGIN = 'hoattm'

#14 Updated by Luc Tran Van over 2 years ago

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

#17 Updated by Luc Tran Van over 2 years ago

SELECT prd.REQ_ID FROM PL_REQUEST_DOC prd WHERE prd.REQ_CODE = '0004/2022/TTDC-0230005'
EXEC TR_CHECK_ROLE_APPROVE @TYPE = 'TTCT'
,@p_REQ_ID = ''
,@p_USER_LOGIN = 'namnh7'

#22 Updated by Luc Tran Van over 2 years ago

SELECT * FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/002542'
SELECT * FROM TR_REQUEST_DOC_DT WHERE REQ_DOC_ID = (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/002542')
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID = (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/002542')
SELECT * FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID = (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/002542')
SELECT * FROM TR_REQUEST_COSTCENTER WHERE REQ_ID = (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/002542')
SELECT * FROM PL_PROCESS WHERE REQ_ID = (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/002542') ORDER BY APPROVE_DT ASC

#24 Updated by Luc Tran Van over 2 years ago

UPDATE [CM_SUPPLIER] SET BANK_NAME=N'NH TMCP BẢN VIỆT - CN HÀ NỘI' WHERE SUP_ID= 'CMS000000252179'

Also available in: Atom PDF