Project

General

Profile

Feature #1506

VẬN HÀNH DỰ ÁN SAU GOLIVE NGÀY 19.04.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:
04/19/2023
Due date:
% Done:

0%

Estimated time:
script_chia_se.txt (403 Bytes) script_chia_se.txt Luc Tran Van, 04/19/2023 11:55 AM
script_lui_ngay.txt (422 Bytes) script_lui_ngay.txt Luc Tran Van, 04/19/2023 01:39 PM
CM_REQUEST_TEMPLATE_Back_date.txt (724 Bytes) CM_REQUEST_TEMPLATE_Back_date.txt Luc Tran Van, 04/19/2023 01:54 PM
pay_auto_scan.txt (25.9 KB) pay_auto_scan.txt Luc Tran Van, 04/19/2023 02:37 PM

History

#1 Updated by Luc Tran Van about 2 years ago

UPDATE TR_REQUEST_DOC SET TOTAL_AMT=328543776 WHERE REQ_CODE ='PUR/2022/002952'
UPDATE TR_REQUEST_DOC_DT SET PRICE =328543776, TOTAL_AMT=328543776 WHERE REQ_DOC_ID =(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE='PUR/2022/002952')

#6 Updated by Luc Tran Van about 2 years ago

EXEC PL_REQ_PROCESS_CHILD_App 'PLRD00000206897','DVCM','sangnm1','sangnm1','',N'Phê duyệt','99980',0,NULL

#7 Updated by Luc Tran Van about 2 years ago

ALTER PROCEDURE dbo.TR_REQUEST_JOB_DETAIL_ById
@p_REQ_ID varchar(15) = NULL
AS
SELECT A.*,B.EMP_NAME as EMP_NAME,C.DEP_NAME
FROM TR_REQUEST_JOB_DETAIL A
LEFT JOIN CM_EMPLOYEE ce ON ce.EMP_ID=A.EMP_ID
LEFT JOIN CM_EMPLOYEE_LOG B ON B.USER_DOMAIN=A.TLNANME AND ce.EMP_CODE = B.EMP_CODE
LEFT JOIN CM_DEPARTMENT C ON C.DEP_ID=A.DEP_ID
WHERE A.REQ_ID = @p_REQ_ID

#8 Updated by Luc Tran Van about 2 years ago

SELECT * FROM CAR_DRIVE
DELETE CAR_DRIVE WHERE CAR_ID=(SELECT CAR_ID FROM CAR_MASTER cm WHERE cm.N_PLATE='51A96912') AND DR_ROUTE<>'Import data'

DELETE CAR_DRIVE WHERE CAR_ID=(SELECT CAR_ID FROM CAR_MASTER cm WHERE cm.N_PLATE='43A37152') AND DR_ROUTE<>'Import data'

DELETE CAR_DRIVE WHERE CAR_ID=(SELECT CAR_ID FROM CAR_MASTER cm WHERE cm.N_PLATE='51H13337') AND DR_ROUTE<>'Import data'

DELETE CAR_DRIVE WHERE CAR_ID=(SELECT CAR_ID FROM CAR_MASTER cm WHERE cm.N_PLATE='51H13159') AND DR_ROUTE<>'Import data'

Also available in: Atom PDF