Project

General

Profile

Document #638

SCRIPT CẦN UPDATE KHI VẬN HÀNH

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

Status:
Closed
Priority:
Normal
Assignee:
Luc Tran Van
Start date:
11/18/2020
Due date:
% Done:

0%

Estimated time:
PAY_KT_APPR.txt (13.3 KB) PAY_KT_APPR.txt Luc Tran Van, 11/18/2020 09:11 AM
PAY_UPD.txt (47.6 KB) PAY_UPD.txt Luc Tran Van, 11/18/2020 09:11 AM
CM_DEP - CM_BRANCH.txt (441 KB) CM_DEP - CM_BRANCH.txt Luc Tran Van, 11/18/2020 09:48 AM
MW_OUT_KT_APPR.txt (7.92 KB) MW_OUT_KT_APPR.txt Luc Tran Van, 11/18/2020 11:38 AM
PDN THANH TOAN TIM KIEM - THEO ỦY QUYỀN KIÊM NHIỆM.txt (18.1 KB) PDN THANH TOAN TIM KIEM - THEO ỦY QUYỀN KIÊM NHIỆM.txt Luc Tran Van, 11/18/2020 03:26 PM
CM_EMPLOYEE_SYNC.txt (11.9 KB) CM_EMPLOYEE_SYNC.txt Luc Tran Van, 11/18/2020 03:55 PM
tim kiem tam ung.txt (24.6 KB) tim kiem tam ung.txt Luc Tran Van, 11/19/2020 04:02 PM
MW_LIQ_MASTER_DEL.txt (1.09 KB) MW_LIQ_MASTER_DEL.txt Luc Tran Van, 11/19/2020 04:42 PM
TR_PO_UPD.txt (19 KB) TR_PO_UPD.txt Luc Tran Van, 11/23/2020 11:32 AM
PO_UP_MASTER.txt (14.2 KB) PO_UP_MASTER.txt Luc Tran Van, 11/23/2020 11:36 AM
PO_UP_MASTER_V2.txt (14.2 KB) PO_UP_MASTER_V2.txt Luc Tran Van, 11/23/2020 11:38 AM
TR_REQ_PAYMENT_UPD.txt (48.4 KB) TR_REQ_PAYMENT_UPD.txt Luc Tran Van, 11/24/2020 10:37 AM
CM_ATTACH_FILE.txt (3.43 KB) CM_ATTACH_FILE.txt Luc Tran Van, 11/24/2020 11:07 AM
TR_REQ_PAYMENT_UPD.txt (48.4 KB) TR_REQ_PAYMENT_UPD.txt Luc Tran Van, 11/24/2020 11:07 AM
PAYMENT_SEARCH.txt (18 KB) PAYMENT_SEARCH.txt Luc Tran Van, 11/25/2020 03:07 PM
PAYMENT_APPR.txt (6.12 KB) PAYMENT_APPR.txt Luc Tran Van, 11/25/2020 05:01 PM
CM_ATTACH_FILE_SEARCH.txt (3.45 KB) CM_ATTACH_FILE_SEARCH.txt Luc Tran Van, 11/26/2020 11:21 AM
XOA PYCMS.txt (1.43 KB) XOA PYCMS.txt Luc Tran Van, 11/26/2020 05:15 PM
XOA TO TRINH CHU TRUONG.txt (1.78 KB) XOA TO TRINH CHU TRUONG.txt Luc Tran Van, 11/26/2020 05:15 PM
CM_EMPLOYEE_SYNC 27112020.txt (14.1 KB) CM_EMPLOYEE_SYNC 27112020.txt Luc Tran Van, 11/27/2020 09:13 AM
IN PYCMS.txt (6.46 KB) IN PYCMS.txt Luc Tran Van, 11/27/2020 03:14 PM
IN PYCMS VERSION 1.0.txt (7.34 KB) IN PYCMS VERSION 1.0.txt Luc Tran Van, 11/27/2020 03:41 PM
FILE 1.txt (14.5 KB) FILE 1.txt Luc Tran Van, 11/27/2020 03:52 PM
PAYMENT_UPD.txt (49.2 KB) PAYMENT_UPD.txt Luc Tran Van, 12/01/2020 09:16 AM
TIM KIEM TAM UNG 0212.txt (24.7 KB) TIM KIEM TAM UNG 0212.txt Luc Tran Van, 12/02/2020 05:47 PM
CAP NHAT UAT 172 29 5 51 2020.txt (115 KB) CAP NHAT UAT 172 29 5 51 2020.txt Luc Tran Van, 12/07/2020 10:42 AM
REQ_AD_PAY_APPR.txt (58.7 KB) REQ_AD_PAY_APPR.txt Luc Tran Van, 12/07/2020 01:28 PM
REQ_AD_PAY_UPD.txt (71.9 KB) REQ_AD_PAY_UPD.txt Luc Tran Van, 12/07/2020 01:28 PM
PL_REQ_DOC_SENDAPP.txt (14 KB) PL_REQ_DOC_SENDAPP.txt Luc Tran Van, 12/07/2020 04:45 PM
8H30 09122020 FILE 01. CAU HINH GỠ NGÂN SÁCH TRÌNH CHỦ TRƯƠNG 15 2020 TTR KHDN.txt (1.07 KB) 8H30 09122020 FILE 01. CAU HINH GỠ NGÂN SÁCH TRÌNH CHỦ TRƯƠNG 15 2020 TTR KHDN.txt Luc Tran Van, 12/09/2020 09:37 AM
TR_METHOD_SEARCH.txt (812 Bytes) TR_METHOD_SEARCH.txt Luc Tran Van, 12/09/2020 11:37 AM
PL_REQUEST_DOC_APPR.txt (45.4 KB) PL_REQUEST_DOC_APPR.txt Luc Tran Van, 12/09/2020 11:37 AM
TR_REQUEST_DOC_APPR.txt (11.6 KB) TR_REQUEST_DOC_APPR.txt Luc Tran Van, 12/09/2020 11:37 AM
IN PDN TAM UNG -UAT.txt (12.2 KB) IN PDN TAM UNG -UAT.txt Luc Tran Van, 12/09/2020 02:33 PM
PL_REQUEST_DOC_BYID.txt (14.5 KB) PL_REQUEST_DOC_BYID.txt Luc Tran Van, 12/11/2020 09:29 AM

History

#4 Updated by Luc Tran Van over 4 years ago

UPDATE TL_USER SET ROLENAME ='GDV_DVKD' WHERE TLNANME IN (SELECT USER_DOMAIN FROM CM_EMPLOYEE_LOG WHERE POS_NAME =N'Giao dịch viên' and branch_code <> '069') AND ROLENAME <> 'DISABLE'

UPDATE TL_USER SET ROLENAME ='GDDV' WHERE TLNANME IN (SELECT USER_DOMAIN FROM CM_EMPLOYEE_LOG WHERE POS_NAME =N'Giám đốc chi nhánh' and branch_code <> '069') AND ROLENAME <> 'DISABLE'

UPDATE TL_USER SET ROLENAME ='PGD' WHERE TLNANME IN (SELECT USER_DOMAIN FROM CM_EMPLOYEE_LOG WHERE POS_NAME =N'Phó giám đốc chi nhánh' and branch_code <> '069') AND ROLENAME <> 'DISABLE'

#5 Updated by Luc Tran Van over 4 years ago

--UPDATE TL_USER SET ROLENAME ='GDV_DVKD' WHERE TLNANME IN (SELECT USER_DOMAIN FROM CM_EMPLOYEE_LOG WHERE POS_NAME =N'Giao dịch viên' and branch_code <> '069') AND ROLENAME <> 'DISABLE'
--UPDATE TL_USER SET ROLENAME ='GDDV' WHERE TLNANME IN (SELECT USER_DOMAIN FROM CM_EMPLOYEE_LOG WHERE POS_NAME =N'Giám đốc chi nhánh' and branch_code <> '069') AND ROLENAME <> 'DISABLE'
--UPDATE TL_USER SET ROLENAME ='PGD' WHERE TLNANME IN (SELECT USER_DOMAIN FROM CM_EMPLOYEE_LOG WHERE POS_NAME =N'Phó giám đốc chi nhánh' and branch_code <> '069') AND ROLENAME <> 'DISABLE'
--UPDATE TL_USER SET ROLENAME ='TPGD' WHERE TLNANME IN (SELECT USER_DOMAIN FROM CM_EMPLOYEE_LOG WHERE POS_NAME =N'Trưởng phòng giao dịch' and branch_code <> '069') AND ROLENAME <> 'DISABLE'
--UPDATE TL_USER SET ROLENAME ='PPGD' WHERE TLNANME IN (SELECT USER_DOMAIN FROM CM_EMPLOYEE_LOG WHERE POS_NAME =N'Phó phòng giao dịch' and branch_code <> '069') AND ROLENAME <> 'DISABLE'

#8 Updated by Luc Tran Van over 4 years ago

UPDATE TL_USER SET ROLENAME ='NVMS'
WHERE ROLENAME ='GDDV'
and TLSUBBRID <> 'DV0001' AND TLNANME NOT IN (SELECT user_domain FROM CM_EMPLOYEE_LOG WHERE POS_NAME =N'Giám đốc Chi Nhánh')

#14 Updated by Luc Tran Van over 4 years ago

DECLARE @REQ_ID VARCHAR
SET @REQ_ID =(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0016/2020/TTr-0690605')

SELECT * FROM PL_REQUEST_DOC WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_DOC_DT WHERE REQ_ID =@REQ_ID

SELECT * FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID =@REQ_ID
SELECT * FROM PL_TRADEDETAIL WHERE TRADE_ID IN (SELECT TRADE_ID FROM PL_REQUEST_DOC_DT WHERE REQ_ID =@REQ_ID)
SELECT * FROM PL_TRADEDETAIL WHERE TRADE_ID IN (SELECT FR_TRADE_ID FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID =@REQ_ID)

#16 Updated by Luc Tran Van over 4 years ago

--UPDATE TL_USER SET ROLENAME ='GDV_DVKD' WHERE TLNANME IN (SELECT USER_DOMAIN FROM CM_EMPLOYEE_LOG WHERE POS_NAME =N'Giao dịch viên' and branch_code <> '069') AND ROLENAME <> 'DISABLE'
--UPDATE TL_USER SET ROLENAME ='GDDV' WHERE TLNANME IN (SELECT USER_DOMAIN FROM CM_EMPLOYEE_LOG WHERE POS_NAME =N'Giám đốc chi nhánh' and branch_code <> '069') AND ROLENAME <> 'DISABLE'
--UPDATE TL_USER SET ROLENAME ='PGD' WHERE TLNANME IN (SELECT USER_DOMAIN FROM CM_EMPLOYEE_LOG WHERE POS_NAME =N'Phó giám đốc chi nhánh' and branch_code <> '069') AND ROLENAME <> 'DISABLE'
--UPDATE TL_USER SET ROLENAME ='TPGD' WHERE TLNANME IN (SELECT USER_DOMAIN FROM CM_EMPLOYEE_LOG WHERE POS_NAME =N'Trưởng phòng giao dịch' and branch_code <> '069') AND ROLENAME <> 'DISABLE'
--UPDATE TL_USER SET ROLENAME ='PPGD' WHERE TLNANME IN (SELECT USER_DOMAIN FROM CM_EMPLOYEE_LOG WHERE POS_NAME =N'Phó phòng giao dịch' and branch_code <> '069') AND ROLENAME <> 'DISABLE'
UPDATE TL_USER SET ROLENAME ='NVMS'
WHERE ROLENAME ='GDDV'
and TLSUBBRID <> 'DV0001' AND TLNANME NOT IN (SELECT user_domain FROM CM_EMPLOYEE_LOG WHERE POS_NAME =N'Giám đốc Chi Nhánh')

#18 Updated by Luc Tran Van over 4 years ago

UPDATE TL_USER SET ROLENAME ='GDV_DVKD' WHERE TLNANME IN (SELECT USER_DOMAIN FROM CM_EMPLOYEE_LOG WHERE POS_NAME =N'Giao dịch viên' and branch_code <> '069') AND ROLENAME <> 'DISABLE'
UPDATE TL_USER SET ROLENAME ='KSV_DVKD' WHERE TLNANME IN (SELECT USER_DOMAIN FROM CM_EMPLOYEE_LOG WHERE POS_NAME =N'Kiểm soát viên' and branch_code <> '069') AND ROLENAME <> 'DISABLE'
UPDATE TL_USER SET ROLENAME ='GDDV' WHERE TLNANME IN (SELECT USER_DOMAIN FROM CM_EMPLOYEE_LOG WHERE POS_NAME =N'Giám đốc chi nhánh' and branch_code <> '069') AND ROLENAME <> 'DISABLE'
UPDATE TL_USER SET ROLENAME ='PGD' WHERE TLNANME IN (SELECT USER_DOMAIN FROM CM_EMPLOYEE_LOG WHERE POS_NAME =N'Phó giám đốc chi nhánh' and branch_code <> '069') AND ROLENAME <> 'DISABLE'
UPDATE TL_USER SET ROLENAME ='TPGD' WHERE TLNANME IN (SELECT USER_DOMAIN FROM CM_EMPLOYEE_LOG WHERE POS_NAME =N'Trưởng phòng giao dịch' and branch_code <> '069') AND ROLENAME <> 'DISABLE'
UPDATE TL_USER SET ROLENAME ='PPGD' WHERE TLNANME IN (SELECT USER_DOMAIN FROM CM_EMPLOYEE_LOG WHERE POS_NAME =N'Phó phòng giao dịch' and branch_code <> '069') AND ROLENAME <> 'DISABLE'

#26 Updated by Luc Tran Van over 4 years ago

#36 Updated by Luc Tran Van over 4 years ago

  • Status changed from New to Closed

Also available in: Atom PDF