Project

General

Profile

Feature #1535

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

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

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

0%

Estimated time:
New Text Document.txt (365 Bytes) New Text Document.txt Luc Tran Van, 05/23/2023 09:48 AM
upd_pay_230523.txt (201 KB) upd_pay_230523.txt Luc Tran Van, 05/23/2023 10:01 AM
DATA_#1.xlsx (10.3 KB) DATA_#1.xlsx Luc Tran Van, 05/23/2023 10:08 AM
New Text Document.txt (283 Bytes) New Text Document.txt Luc Tran Van, 05/23/2023 10:20 AM
DATA_#3.xlsx (9.01 KB) DATA_#3.xlsx Luc Tran Van, 05/23/2023 10:29 AM
rpt_ReportPriceOver500M_7.doc (132 KB) rpt_ReportPriceOver500M_7.doc Luc Tran Van, 05/23/2023 02:39 PM
rpt_ReportPriceOver500M.doc (130 KB) rpt_ReportPriceOver500M.doc Luc Tran Van, 05/23/2023 02:39 PM
rpt_ReportPriceOver500M_4.doc (133 KB) rpt_ReportPriceOver500M_4.doc Luc Tran Van, 05/23/2023 02:39 PM
rpt_ReportPriceOver500M_5.doc (135 KB) rpt_ReportPriceOver500M_5.doc Luc Tran Van, 05/23/2023 02:39 PM
rpt_ReportPriceOver500M_6.doc (132 KB) rpt_ReportPriceOver500M_6.doc Luc Tran Van, 05/23/2023 02:39 PM
job_dt_byid.txt (2.25 KB) job_dt_byid.txt Luc Tran Van, 05/23/2023 03:13 PM
DATA_#8.xlsx (65.1 KB) DATA_#8.xlsx Luc Tran Van, 05/23/2023 04:01 PM
ASS_ADDNEW_BVB_Search.txt (24.1 KB) ASS_ADDNEW_BVB_Search.txt Luc Tran Van, 05/23/2023 04:11 PM

History

#7 Updated by Luc Tran Van about 2 years ago

UPDATE CAR_DRIVE SET NEW_INDEX_NUMBER=16000, NEW_FUEL_NUMBER=35 WHERE CAR_ID=(SELECT CAR_ID FROM CAR_MASTER WHERE N_PLATE='70A-348.14') AND CHECKER_ID='admin'
UPDATE CAR_DRIVE SET NEW_INDEX_NUMBER=181126, NEW_FUEL_NUMBER=10 WHERE CAR_ID=(SELECT CAR_ID FROM CAR_MASTER WHERE N_PLATE='70C-136.82') AND CHECKER_ID='admin'
--19052023_secretkey

#8 Updated by Luc Tran Van about 2 years ago

SELECT * FROM ASS_ADDNEW aa WHERE aa.AUTH_STATUS='A' AND (aa.MAKER_ID_KT IS NULL OR aa.MAKER_ID_KT ='')

#10 Updated by Luc Tran Van about 2 years ago

UPDATE ASS_ADDNEW SET AUTH_STATUS_KT='E' WHERE AUTH_STATUS='A' AND (MAKER_ID_KT IS NULL OR MAKER_ID_KT ='') AND AUTH_STATUS_KT='U'
--23052023_secretkey

#12 Updated by Luc Tran Van about 2 years ago

DELETE CAR_DRIVE WHERE CAR_ID=(SELECT CAR_ID FROM CAR_MASTER cm WHERE cm.N_PLATE='51E 056.40') AND DR_ROUTE<>'Import data'
--23052023_secretkey

#13 Updated by Luc Tran Van about 2 years ago

UPDATE CAR_DRIVE SET ISLEAF='Y' WHERE CAR_ID=(SELECT CAR_ID FROM CAR_MASTER cm WHERE cm.N_PLATE='51E 056.40')
--23052023_secretkey

Also available in: Atom PDF