Project

General

Profile

Feature #1384

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

0%

Estimated time:
TR_REQUEST_DOC_MOVE_DVCM.txt (2.83 KB) TR_REQUEST_DOC_MOVE_DVCM.txt Luc Tran Van, 10/21/2022 08:48 AM
NF_MESSAGE_GetContent.txt (128 KB) NF_MESSAGE_GetContent.txt Luc Tran Van, 10/21/2022 08:48 AM
TR_ROLE_NOTIFI_ID.txt (81.2 KB) TR_ROLE_NOTIFI_ID.txt Luc Tran Van, 10/21/2022 08:48 AM
1.0 GET DATA TO TRINH CHU TRUONG.txt (1.02 KB) 1.0 GET DATA TO TRINH CHU TRUONG.txt Luc Tran Van, 10/21/2022 09:36 AM
GenData.xlsx (19.6 KB) GenData.xlsx Luc Tran Van, 10/21/2022 09:56 AM
FN_CHECK_VALIDATE_APP.txt (22.2 KB) FN_CHECK_VALIDATE_APP.txt Luc Tran Van, 10/21/2022 11:07 AM
PL_REQUEST_TRANSFER_DT_ByID.txt (15.5 KB) PL_REQUEST_TRANSFER_DT_ByID.txt Luc Tran Van, 10/21/2022 11:07 AM
PL_REQUEST_DOC_DT_ById.txt (17.7 KB) PL_REQUEST_DOC_DT_ById.txt Luc Tran Van, 10/21/2022 11:07 AM
PL_REQUEST_TRANSFER_App.txt (44.4 KB) PL_REQUEST_TRANSFER_App.txt Luc Tran Van, 10/21/2022 11:07 AM
PL_REQUEST_DOC_PROCESS_Upd.txt (13.3 KB) PL_REQUEST_DOC_PROCESS_Upd.txt Luc Tran Van, 10/21/2022 11:07 AM
PL_REQUEST_DOC_ById_Report.txt (20.7 KB) PL_REQUEST_DOC_ById_Report.txt Luc Tran Van, 10/21/2022 11:07 AM
PL_REQUEST_DOC_App.txt (50.5 KB) PL_REQUEST_DOC_App.txt Luc Tran Van, 10/21/2022 11:07 AM
rpt_PL_REQUEST_DOC_DT_ById.txt (25 KB) rpt_PL_REQUEST_DOC_DT_ById.txt Luc Tran Van, 10/21/2022 11:07 AM
PL_REQ_GOOD_Search.txt (23 KB) PL_REQ_GOOD_Search.txt Luc Tran Van, 10/21/2022 11:07 AM
PL_TRADEDETAIL_ById_new_V2.txt (4.22 KB) PL_TRADEDETAIL_ById_new_V2.txt Luc Tran Van, 10/21/2022 11:07 AM
PL_MASTER_Search_New_V2.txt (9.42 KB) PL_MASTER_Search_New_V2.txt Luc Tran Van, 10/21/2022 11:10 AM
Downloads.zip (39.6 KB) Downloads.zip Luc Tran Van, 10/21/2022 01:29 PM
2.0 check kt.txt (1.19 KB) 2.0 check kt.txt Luc Tran Van, 10/21/2022 02:58 PM
PL_COSTCENTER_DT.txt (30.5 KB) PL_COSTCENTER_DT.txt Luc Tran Van, 10/21/2022 03:31 PM
PL_COSTCENTER.txt (51.2 KB) PL_COSTCENTER.txt Luc Tran Van, 10/21/2022 03:31 PM
PL_COSTCENTER_Search.txt (3.66 KB) PL_COSTCENTER_Search.txt Luc Tran Van, 10/21/2022 04:00 PM

History

#1 Updated by Luc Tran Van over 2 years ago

SELECT * FROM TL_SYS_ROLE_MAPPING WHERE TLNAME IN ('namdt','haipv') AND DEP_ID ='DEP000000000058' AND BRANCH_ID ='DV0001'

#5 Updated by Luc Tran Van over 2 years ago

UPDATE PL_REQUEST_PROCESS SET STATUS='C', CHECKER_ID='', APPROVE_DT='', NOTES =N'Chờ giám đốc khối phê duyệt chỉ định thầu' WHERE ID='76110'
UPDATE PL_REQUEST_PROCESS SET STATUS='U', PARENT_PROCESS_ID='' WHERE ID='76111'
UPDATE PL_REQUEST_DOC SET PROCESS_ID='GDK_TT' WHERE REQ_ID='PLRD00000205307'
UPDATE PL_REQUEST_PROCESS SET STATUS='U', PARENT_PROCESS_ID='GDK_TT' WHERE ID='76112'
DELETE PL_PROCESS WHERE REQ_ID ='394197'

#9 Updated by Luc Tran Van over 2 years ago

SELECT distinct PL.REQ_ID,PL.PROCESS_ID,
CASE WHEN CD.DVDM_NAME IS NOT NULL AND CD.DVDM_NAME <> '' THEN CD.DVDM_NAME ELSE BR.BRANCH_NAME END AS DVDM_NAME,
TempU.TLNANME AS TLNAME,
TempU.TLFullName,
PL.NOTES
FROM dbo.PL_REQUEST_PROCESS PL
LEFT JOIN dbo.CM_DVDM CD ON CD.DVDM_ID=PL.DVDM_ID
LEFT JOIN
(
SELECT TU.TLNANME,TU.TLFullName,TU.RoleName,Temp.DVDM_ID,TU.SECUR_CODE,TU.TLSUBBRID FROM dbo.TL_USER TU
LEFT JOIN(
SELECT PC.DVDM_ID,PD.DEP_ID,PD.BRANCH_ID FROM dbo.PL_COSTCENTER PC
LEFT JOIN dbo.PL_COSTCENTER_DT PD ON PC.COST_ID=PD.COST_ID) Temp ON Temp.DEP_ID=TU.SECUR_CODE AND Temp.BRANCH_ID=TU.TLSUBBRID

) TempU ON (TempU.RoleName=PL.ROLE_USER)
        AND (TempU.TLSUBBRID=PL.BRANCH_ID OR PL.BRANCH_ID IS NULL OR PL.BRANCH_ID='') 
        AND (((SELECT TOP 1 BRANCH_TYPE FROM dbo.CM_BRANCH WHERE BRANCH_ID = PL.BRANCH_ID) = 'HS' AND TempU.SECUR_CODE=PL.DEP_ID OR PL.DEP_ID IS NULL OR PL.DEP_ID='')
        OR (SELECT TOP 1 BRANCH_TYPE FROM dbo.CM_BRANCH WHERE BRANCH_ID = PL.BRANCH_ID) <> 'HS') 
        AND (TempU.DVDM_ID=PL.DVDM_ID OR PL.DVDM_ID IS NULL OR PL.DVDM_ID ='')
        LEFT JOIN CM_BRANCH BR ON PL.BRANCH_ID = BR.BRANCH_ID
        WHERE PL.REQ_ID = 'PLRD00000205680' AND STATUS='C'

#11 Updated by Luc Tran Van over 2 years ago

SELECT * FROM PL_COSTCENTER_DT WHERE DEP_ID ='DEP000000000022'
SELECT * FROM PL_COSTCENTER WHERE COST_ID ='PLCC00000001062'

#12 Updated by Luc Tran Van over 2 years ago

INSERT INTO [PL_COSTCENTER_DT] ([COSTDT_ID],[COST_ID],[BRANCH_ID],[DEP_ID],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT])VALUES

INSERT INTO [PL_COSTCENTER] ([COST_ID],[COST_CODE],[PLAN_TYPE_ID],[COST_NAME],[NOTES],[RECORD_STATUS],[AUTH_STATUS],[MAKER_ID],[CREATE_DT],[EDITER_ID],[EDIT_DT],[CHECKER_ID],[APPROVE_DT],[DVDM_ID])VALUES

Also available in: Atom PDF