DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN - NH BẢN VIỆT - GD3

UPDATE TR_REQ_PAYMENT SET EDITOR_ID = 'dungltm', MAKER_ID ='thynql' WHERE MAKER_ID ='dungltm' AND AUTH_STATUS <>'A'

EXEC dbo.sp_generate_inserts @table_name = 'TL_SYS_ROLE_MAPPING',
@from = 'FROM TL_SYS_ROLE_MAPPING'
EXEC dbo.sp_generate_inserts @table_name = 'PL_COSTCENTER',
@from = 'FROM PL_COSTCENTER'
EXEC dbo.sp_generate_inserts @table_name = 'PL_COSTCENTER_DT',
@from = 'FROM PL_COSTCENTER_DT'
EXEC dbo.sp_generate_inserts @table_name = 'CM_DVDM',
@from = 'FROM CM_DVDM'

SELECT * FROM CAR_MASTER WHERE N_PLATE ='14A23208'
SELECT * FROM CAR_DRIVE WHERE CAR_ID IN (SELECT CAR_ID FROM CAR_MASTER WHERE N_PLATE ='14A23208')

DECLARE @REQ_ID VARCHAR
SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2023/001094')
UPDATE PL_REQUEST_PROCESS SET STATUS='C' WHERE REQ_ID =@REQ_ID AND PROCESS_ID ='DMMS'
UPDATE PL_REQUEST_PROCESS SET STATUS='U' WHERE REQ_ID =@REQ_ID AND PROCESS_ID ='APPROVE'
UPDATE PL_REQUEST_PROCESS_CHILD SET STATUS_JOB='C' WHERE REQ_ID =@REQ_ID AND TLNAME ='nguyennkh' AND TYPE_JOB ='XL' ----21062023_SECCRETKEY

---1.0 LẤY THÔNG TIN VẬN HÀNH XE
SELECT * FROM CAR_DRIVE cd WHERE cd.CAR_ID IN (SELECT cm.CAR_ID FROM CAR_MASTER cm WHERE cm.N_PLATE IN ('62A15274','62C-16569'))
---2.0 LẤY THÔNG TIN XE
SELECT * FROM CAR_MASTER cm WHERE cm.CAR_ID IN (SELECT cm.CAR_ID FROM CAR_MASTER cm WHERE cm.N_PLATE IN ('62A15274','62C-16569'))

DECLARE @REQ_ID VARCHAR
SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2023/001094')
UPDATE PL_REQUEST_PROCESS SET STATUS='C' WHERE REQ_ID =@REQ_ID AND PROCESS_ID ='DMMS'
UPDATE PL_REQUEST_PROCESS SET STATUS='U' WHERE REQ_ID =@REQ_ID AND PROCESS_ID ='APPROVE'
UPDATE PL_REQUEST_PROCESS_CHILD SET STATUS_JOB='C' WHERE REQ_ID =@REQ_ID AND TLNAME ='nguyennhk' AND TYPE_JOB ='XL' ----21062023_SECCRETKEY

DECLARE @REQ_ID VARCHAR
SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2023/001094')
UPDATE PL_REQUEST_PROCESS SET STATUS='P' WHERE REQ_ID =@REQ_ID AND PROCESS_ID ='DMMS'
UPDATE PL_REQUEST_PROCESS SET STATUS='C' WHERE REQ_ID =@REQ_ID AND PROCESS_ID ='APPROVE'
UPDATE PL_REQUEST_PROCESS_CHILD SET STATUS_JOB='P' WHERE REQ_ID =@REQ_ID AND TLNAME ='nguyennhk' AND TYPE_JOB ='XL' ----21062023_SECCRETKEY
UPDATE CAR_MASTER SET ORIGINAL_FUEL_NUMBER =54.4, ORIGINAL_INDEX_NUMBER =211041 WHERE N_PLATE ='14A23208'

DECLARE @REQ_ID VARCHAR
SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2023/001094')
UPDATE PL_REQUEST_PROCESS SET STATUS='C' WHERE REQ_ID =@REQ_ID AND PROCESS_ID ='DMMS'
UPDATE PL_REQUEST_PROCESS SET STATUS='U' WHERE REQ_ID =@REQ_ID AND PROCESS_ID ='APPROVE'
UPDATE PL_REQUEST_PROCESS_CHILD SET STATUS_JOB='C' WHERE REQ_ID =@REQ_ID AND TLNAME ='nguyennhk' AND TYPE_JOB ='XL' ----21062023_SECCRETKEY

SELECT * FROM CM_SUPPLIER cs WHERE cs.SUP_ID = 'CMS000000252081'

SELECT * FROM CM_SUPPLIER WHERE SUP_NAME =N'Công ty TNHH Powerful'

SELECT * FROM CM_SUPPLIER WHERE SUP_NAME =N'Công ty TNHH Powerful' AND SUP_NAME IS NOT NULL AND SUP_NAME <>'' AND ISNULL <> 'A'

SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID =(SELECT REQ_ID FROM TR_REQUEST_CAR WHERE REQ_CODE='PYC-XE/2023/002056')
SELECT * FROM TR_REQUEST_CAR WHERE REQ_CODE IN ('PYC-XE/2023/002056','PYC-XE/2023/001979','PYC-XE/2023/001977','PYC-XE/2023/002056')----21062023_SECRETKEY

UPDATE TL_SYS_ROLE_MAPPING SET EFF_DATE ='2022-1-1', EXP_DATE ='2300-1-1' WHERE TLNAME ='toailc' AND EXP_DATE IS NULL ----21062023_SECRETKEY

DECLARE @tlname varchar(50) = ''

SELECT @tlname = prpc.TLNAME FROM PL_REQUEST_PROCESS_CHILD prpc WHERE prpc.PROCESS_ID IN
(SELECT prp.ID FROM PL_REQUEST_PROCESS prp WHERE prp.REQ_ID IN (SELECT trd.REQ_ID FROM TR_REQUEST_DOC trd WHERE trd.REQ_CODE = 'PUR/2023/001217')) AND prpc.STATUS_JOB = 'C'

SELECT * FROM TL_USER tu WHERE tu.TLNANME = @tlname

SELECT * FROM TL_SYS_ROLE_MAPPING tsrm WHERE tsrm.TLNAME = @tlname

UPDATE TR_REQUEST_CAR SET AUTH_STATUS ='E' WHERE REQ_CODE IN ('PYC-XE/2023/002056','PYC-XE/2023/001979','PYC-XE/2023/001977','PYC-XE/2023/002056')----21062023_SECRETKEY

UPDATE TR_REQUEST_CAR SET AUTH_STATUS ='E' WHERE REQ_CODE IN ('PYC-XE/2023/000608')----21062023_SECRETKEY

UPDATE TR_REQUEST_CAR SET AUTH_STATUS ='E' WHERE REQ_CODE IN ('PYC-XE/2023/001059','PYC-XE/2023/001419')----21062023_SECRETKEY

ALTER TABLE TR_REQ_PAY_AUTO_RECURRING_LOG
DROP CONSTRAINT PK__TR_REQ_P__D0E9A3D7AE4D0326;

SELECT name
FROM sys.key_constraints
WHERE type = 'PK' AND OBJECT_NAME(parent_object_id) = N'TR_REQ_PAY_AUTO_RECURRING_LOG';

SELECT COUNT (*) FROM ASS_ENTRIES_POST WHERE TRN_ID ='' AND ISNULL <> ''