Project

General

Profile

Feature #1460

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

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

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

0%

Estimated time:
SYS_PREFIX.txt (101 Bytes) SYS_PREFIX.txt Luc Tran Van, 03/14/2023 09:18 AM
rpt_tr_req_jobDT.xlsx (24.7 KB) rpt_tr_req_jobDT.xlsx Luc Tran Van, 03/14/2023 09:46 AM
AFT000000000241.txt (6.05 KB) AFT000000000241.txt Luc Tran Van, 03/14/2023 09:49 AM
form_search.txt (15.9 KB) form_search.txt Luc Tran Van, 03/14/2023 10:45 AM
rpt_tr_req_jobDT.xlsx (24.2 KB) rpt_tr_req_jobDT.xlsx Luc Tran Van, 03/14/2023 10:58 AM
rpt_TR_REQUEST_JOB_FORM.txt (2.58 KB) rpt_TR_REQUEST_JOB_FORM.txt Luc Tran Van, 03/14/2023 11:14 AM
rpt_TR_REQ_PAY_Job_DT_ById.txt (1.44 KB) rpt_TR_REQ_PAY_Job_DT_ById.txt Luc Tran Van, 03/14/2023 11:19 AM
rpt_tr_req_jobDT.xlsx (24.4 KB) rpt_tr_req_jobDT.xlsx Luc Tran Van, 03/14/2023 11:19 AM
job_search_2.txt (15.9 KB) job_search_2.txt Luc Tran Van, 03/14/2023 11:25 AM
TR_REQ_PAYMENT_Ins.txt (80.9 KB) TR_REQ_PAYMENT_Ins.txt Luc Tran Van, 03/14/2023 11:30 AM
TR_REQ_PAYMENT_Upd.txt (115 KB) TR_REQ_PAYMENT_Upd.txt Luc Tran Van, 03/14/2023 11:30 AM
lay_data.txt (405 Bytes) lay_data.txt Luc Tran Van, 03/14/2023 11:43 AM
DB_STATUS_ASSET_QUANTITY_BAR.txt (11.6 KB) DB_STATUS_ASSET_QUANTITY_BAR.txt Luc Tran Van, 03/14/2023 11:52 AM
DB_STATUS_ASSET_QUANTITY_PIE.txt (1.45 KB) DB_STATUS_ASSET_QUANTITY_PIE.txt Luc Tran Van, 03/14/2023 11:52 AM
DB_STATUS_ASSET_VALUE_BAR.txt (10.6 KB) DB_STATUS_ASSET_VALUE_BAR.txt Luc Tran Van, 03/14/2023 11:52 AM
lay_data.txt (404 Bytes) lay_data.txt Luc Tran Van, 03/14/2023 11:56 AM
DATA_#12.xlsx (13.7 KB) DATA_#12.xlsx Luc Tran Van, 03/14/2023 01:59 PM
ASS_INVENTORY_DETAIL_Ins.txt (7.58 KB) ASS_INVENTORY_DETAIL_Ins.txt Luc Tran Van, 03/14/2023 02:05 PM
ASS_INVENT.txt (125 KB) ASS_INVENT.txt Luc Tran Van, 03/14/2023 02:06 PM
rpt_TR_REQ_PAY_Job_DT_ById.txt (1.96 KB) rpt_TR_REQ_PAY_Job_DT_ById.txt Luc Tran Van, 03/14/2023 02:49 PM
rpt_tr_req_jobDT.xlsx (24.1 KB) rpt_tr_req_jobDT.xlsx Luc Tran Van, 03/14/2023 02:49 PM
rpt_tr_req_jobDT.xlsx (24.1 KB) rpt_tr_req_jobDT.xlsx Luc Tran Van, 03/14/2023 02:56 PM
rpt_TR_REQ_PAY_Job_DT_ById.txt (1.96 KB) rpt_TR_REQ_PAY_Job_DT_ById.txt Luc Tran Van, 03/14/2023 02:56 PM
rpt_TR_REQ_PAY_Job_DT_ById.txt (2.03 KB) rpt_TR_REQ_PAY_Job_DT_ById.txt Luc Tran Van, 03/14/2023 03:01 PM
rpt_tr_req_jobDT.xlsx (24.1 KB) rpt_tr_req_jobDT.xlsx Luc Tran Van, 03/14/2023 03:01 PM

History

#13 Updated by Luc Tran Van over 2 years ago

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

#19 Updated by Luc Tran Van over 2 years ago

069TS13030003220001,069TS15990004220001,069TS15010306220001,069TS24010007220001,069TS13040007220001,069TS15020207220001,069TS15019908220001,069TS13040008220001,069TS14010208220001,069TS24010009220001,069TS24010010220001,069CC15020107220020,069CC15020109220020,069TS13030003220001

Also available in: Atom PDF