Project

General

Profile

Feature #1394

VẬN HÀNH SAU GOLIVE NGÀY 04-11-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:
11/03/2022
Due date:
% Done:

0%

Estimated time:
2.2 PL REQUEST DOC APPR.txt (51.2 KB) 2.2 PL REQUEST DOC APPR.txt Luc Tran Van, 11/03/2022 08:47 PM
hotfix2.zip (3.14 MB) hotfix2.zip Luc Tran Van, 11/04/2022 07:40 AM
hotfix1.zip (2.42 MB) hotfix1.zip Luc Tran Van, 11/04/2022 07:40 AM
WebSiteLogs (13).zip (662 KB) WebSiteLogs (13).zip Luc Tran Van, 11/04/2022 08:55 AM
INHACHTOAN_ADVANCE_PAY_BanViet.docx (105 KB) INHACHTOAN_ADVANCE_PAY_BanViet.docx Luc Tran Van, 11/04/2022 08:55 AM
import_invoice.txt (1.21 KB) import_invoice.txt Luc Tran Van, 11/04/2022 08:58 AM
REQ_INVOICE_BYID_BanViet_DV.xlsx (10.7 KB) REQ_INVOICE_BYID_BanViet_DV.xlsx Luc Tran Van, 11/04/2022 09:29 AM
CM_EMPLOYEE_Search.txt (5.67 KB) CM_EMPLOYEE_Search.txt Luc Tran Van, 11/04/2022 10:27 AM
mw_entry_post.txt (4.31 KB) mw_entry_post.txt Luc Tran Van, 11/07/2022 09:12 AM
req_entry_trans_rec.txt (922 Bytes) req_entry_trans_rec.txt Luc Tran Van, 11/07/2022 10:00 AM
IN_PDN_TT.zip (102 KB) IN_PDN_TT.zip Luc Tran Van, 11/07/2022 12:31 PM

History

#8 Updated by Luc Tran Van over 2 years ago

UPDATE D SET D.KHOI_ID = C.DVDM_ID
FROM dbo.PL_COSTCENTER_DT P
LEFT JOIN dbo.CM_DEPARTMENT D ON D.DEP_ID=P.DEP_ID AND D.BRANCH_ID = P.BRANCH_ID
LEFT JOIN dbo.PL_COSTCENTER C ON C.COST_ID =P.COST_ID

#12 Updated by Luc Tran Van over 2 years ago

SELECT tu.RoleName FROM TL_USER tu WHERE tu.TLNANME ='lanht'
SELECT * FROM AbpUserRoles aur WHERE aur.UserId =(SELECT ID FROM TL_USER tu WHERE tu.TLNANME ='lanht')

Also available in: Atom PDF