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

4- Toàn bộ Slide đối tên ở Trang 1 > PM Quản Lý Tài Sản GD 3 > eOffice

5- Bổ sung HDSD phần Đóng phiếu PYCMS sau khi PYCMS đã được duyệt hoàn tất.

UPDATE PL_REQUEST_PROCESS SET DVDM_ID ='DM0000000000019' WHERE ID ='95016'
EXEC PL_REQ_PROCESS_CHILD_App 'PLRD00000206692','DVDM_DC','sontv1','ngochm','',N'Phê duyệt','95016',0,NULL

INSERT CAR_DRIVE(CAR_DR_ID, CAR_ID, ASSET_ID, ASSET_NAME, OLD_INDEX_NUMBER, NEW_INDEX_NUMBER, INDEX_NUMBER, POWER_RATE, POWER_RATE_INDEX, CURR_POWER_RATE, INPUT_DT, ISLEAF, PARENT_ID, NOTES, RECORD_STATUS, MAKER_ID, CREATE_DT, AUTH_STATUS, CHECKER_ID, APPROVE_DT, CAR_AMT, INVOICE_NO, DR_ROUTE, REQ_PAY_ID, DIFF_FUEL_CONSUM, REQ_CAR_ID, OLD_FUEL_NUMBER, NEW_FUEL_NUMBER) VALUES
(N'CARD00000000009', (SELECT cm.CAR_ID FROM CAR_MASTER cm WHERE cm.N_PLATE='68A-197.55'), NULL, NULL, 12933, 12933, 12933, NULL, NULL, 0.00, '2023-03-17 00:00:00.000', 'Y', NULL, NULL, '1', 'admin', '2023-03-17 00:00:00.000', 'A', NULL, NULL, NULL, NULL, N'Import data', NULL, NULL, '', 0.00, 0)

UPDATE PL_REQUEST_PROCESS SET ROLE_USER='GDDV', DVDM_ID='',BRANCH_ID='DV0001',DEP_ID='DEP000000252201',NOTES=N'Chờ trưởng phòng phê duyệt' WHERE REQ_ID=(SELECT trjf.REQ_ID FROM TR_REQUEST_JOB_FORM trjf WHERE trjf.REQ_CODE='AFT-23-000318') AND PROCESS_ID='APPNEW'

select * from PL_REQUEST_PROCESS where REQ_ID = 'TRRD00000258349'
select * from PL_REQUEST_PROCESS_CHILD where PROCESS_ID in (select id from PL_REQUEST_PROCESS where REQ_ID = 'TRRD00000258349')

https://ams.vietcapitalbank.com.vn/app/admin/template-request-doc-view;id=CRTEM0000000115

DECLARE @REQ_ID VARCHAR
SET @REQ_ID=(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0041/2022/TTr-0692105')
SELECT * FROM PL_REQUEST_DOC WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID =@REQ_ID
SELECT * FROM PL_PROCESS WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_DOC_DT WHERE REQ_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)
SELECT * FROM CM_GOODS WHERE GD_ID IN (SELECT GOODS_ID FROM PL_REQUEST_DOC_DT WHERE REQ_ID =@REQ_ID)
SELECT * FROM CM_GOODS WHERE GD_ID IN (SELECT FR_GOOD_ID FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID =@REQ_ID)
SELECT * FROM CM_GOODSTYPE
SELECT * FROM PL_TRADEDETAIL_HIST WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_COSTCENTER WHERE REQ_ID =@REQ_ID
SET @REQ_ID=(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0030/2022/TTr-06921045')
SELECT * FROM PL_REQUEST_DOC WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID =@REQ_ID
SELECT * FROM PL_PROCESS WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_DOC_DT WHERE REQ_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)
SELECT * FROM CM_GOODS WHERE GD_ID IN (SELECT GOODS_ID FROM PL_REQUEST_DOC_DT WHERE REQ_ID =@REQ_ID)
SELECT * FROM CM_GOODS WHERE GD_ID IN (SELECT FR_GOOD_ID FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID =@REQ_ID)
SELECT * FROM CM_GOODSTYPE
SELECT * FROM PL_TRADEDETAIL_HIST WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_COSTCENTER WHERE REQ_ID =@REQ_ID

SELECT * FROM [dbo].[TL_USER_GET_ROLES] (
'quynhnn2')