Project

General

Profile

Feature #1430

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

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

Status:
New
Priority:
Normal
Assignee:
-
Start date:
12/28/2022
Due date:
% Done:

0%

Estimated time:
DATA_TTCT_0019_2002_TTr_0690903.xlsx (24 KB) DATA_TTCT_0019_2002_TTr_0690903.xlsx Luc Tran Van, 12/28/2022 03:57 PM
DATA_#2.xlsx (11.8 KB) DATA_#2.xlsx Luc Tran Van, 12/28/2022 04:30 PM
alter_table.txt (2.01 MB) alter_table.txt Luc Tran Van, 12/28/2022 04:59 PM
TSCD_BC08_2_BanViet-928005af-f87d-427d-9a7f-a58ee2251e42.xlsx (261 KB) TSCD_BC08_2_BanViet-928005af-f87d-427d-9a7f-a58ee2251e42.xlsx Luc Tran Van, 12/28/2022 05:03 PM
TSCD_BC08_2_BanViet-5841013b-cb79-4e7d-9492-734eb68ad9d6.xlsx (261 KB) TSCD_BC08_2_BanViet-5841013b-cb79-4e7d-9492-734eb68ad9d6.xlsx Luc Tran Van, 12/28/2022 05:19 PM
ALTER_DB_291222.txt (1.06 KB) ALTER_DB_291222.txt Luc Tran Van, 12/29/2022 02:08 PM
ALTER_PROC.txt (397 KB) ALTER_PROC.txt Luc Tran Van, 12/29/2022 02:09 PM
DATA_#13_291222.txt (1.1 KB) DATA_#13_291222.txt Luc Tran Van, 12/29/2022 04:30 PM
DATA_#15_291222.txt (3.1 KB) DATA_#15_291222.txt Luc Tran Van, 12/29/2022 04:42 PM
upd_kpi.txt (14.8 KB) upd_kpi.txt Luc Tran Van, 12/29/2022 04:55 PM
REQ_KPI-8c860fe2-29f1-4e85-8c6b-a00a4cb8a38e.xlsx (13.2 KB) REQ_KPI-8c860fe2-29f1-4e85-8c6b-a00a4cb8a38e.xlsx Luc Tran Van, 12/29/2022 05:05 PM
[ASS_ADDNEW_BVB_Search].txt (21.6 KB) [ASS_ADDNEW_BVB_Search].txt Luc Tran Van, 12/29/2022 05:14 PM
DATA_TTCT_0001.xlsx (22.1 KB) DATA_TTCT_0001.xlsx Luc Tran Van, 12/29/2022 05:22 PM
Upd_CASA.txt (43.5 KB) Upd_CASA.txt Luc Tran Van, 12/30/2022 10:43 AM
DATA_ASS_ADDNEW.txt (1.32 KB) DATA_ASS_ADDNEW.txt Luc Tran Van, 12/30/2022 11:02 AM
CAR_MASTER.txt (497 KB) CAR_MASTER.txt Luc Tran Van, 12/31/2022 01:48 PM

History

#2 Updated by Luc Tran Van over 2 years ago

SELECT * FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/003134'
SELECT * FROM TR_REQUEST_DOC_PL_DT WHERE REQ_DOC_ID = (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/003134')
SELECT * FROM TR_REQUEST_DOC_DT WHERE REQ_DOC_ID = (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/003134')
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID = (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/003134')
SELECT * FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID = (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/003134')
SELECT * FROM TR_REQUEST_COSTCENTER WHERE REQ_ID = (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/003134')
SELECT * FROM PL_PROCESS WHERE REQ_ID = (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/003134')

#4 Updated by Luc Tran Van over 2 years ago

-------------UPDATE TR_REQUEST_DOC_DT
UPDATE TR_REQUEST_DOC_DT SET
PRICE = 176418000,
TOTAL_AMT = 176418000 * QUANTITY
WHERE REQDT_ID = 'TRRDD0000279223'

-------UPDATE TR_REQUEST_DOC MASTER--------
UPDATE TR_REQUEST_DOC SET
TOTAL_AMT = 134784000 + 176418000
WHERE REQ_ID = 'TRRD00000257776'

INSERT INTO PL_PROCESS (REQ_ID,PROCESS_ID,NOTES,PROCESS_DESC,CHECKER_ID,APPROVE_DT)
VALUES ('TRRD00000257776','IT',N'Yêu cầu cập nhật đơn giá',N'Hỗ trợ cập nhật đơn giá thực tế PYCMS hạng mục Chi tiết mua sắm - Quảng cáo Youtube theo yêu cầu','nguyennhk',GETDATE)

#5 Updated by Luc Tran Van over 2 years ago

SELECT * FROM dbo.ASS_AMORT_DT WHERE AMORT_ID='ASM000000251057'

#9 Updated by Luc Tran Van over 2 years ago

UPDATE ASS_MASTER SET AMORTIZED_MONTH=10.0,AMORTIZED_AMT=18983330.0,AMORT_STATUS='DKH' WHERE ASSET_ID='ASS000000278836'

#12 Updated by Luc Tran Van over 2 years ago

0371/2022/TTr-0690604
23/06/2022

#13 Updated by Luc Tran Van over 2 years ago

EXEC dbo.sp_generate_inserts @table_name = 'ASS_ADDNEW', -- varchar(776)
@from = "FROM ASS_ADDNEW where ADDNEW_ID='ASA000000257743'" -- varchar(800)

#15 Updated by Luc Tran Van over 2 years ago

EXEC dbo.sp_generate_inserts @table_name = 'ASS_ADDNEW', -- varchar(776)
@from = "FROM ASS_ADDNEW where ADDNEW_ID IN ('ASA000000257747','ASA000000257748','ASA000000257749')" -- varchar(800)

Also available in: Atom PDF