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

BẢO: POPUP Tìm kiếm tờ trình chủ trương để tạo PYCMS đang bị sai khi Anh Bảo ở Phòng Hỗ Trợ thấy Tờ trình của P. Hành Chính (mặc dù tờ này không phải tờ trình toàn hàng)

select REQ_PAY_REASON from TR_REQ_PAY_METHOD where REQ_PAY_ID = 'TRPY00000242311'

select * from TR_REQ_PAYMENT where REQ_PAY_ID = 'TRPY00000242311'

select * from PL_REQUEST_PROCESS_CHILD where REQ_ID = 'TRPY00000242311'

select REASON from TR_REQ_PAY_PERIOD where REQ_PAY_ID = 'TRPY00000242311'

update TR_REQ_PAYMENT
set REQ_REASON='',AUTH_STATUS_KT='P'
where REQ_PAY_ID='TRPY00000242311'

EXEC TR_ROLE_NOTIFI_ID @PO_ID='ASA001',@TYPE='ASS_SEND_GDV'

SELECT P.REQ_ID, P.REQ_CODE, P.AUTH_STATUS, P.PROCESS_ID FROM PL_REQUEST_DOC P
INNER JOIN PL_REQUEST_PROCESS R ON P.REQ_ID =R.REQ_ID AND R.PROCESS_ID ='PTGDK_TT' AND R.STATUS IN ('C','U')
WHERE P.PROCESS_ID <> 'APPROVE' AND YEAR=2022 AND P.PROCESS_ID<> 'REJECT' AND R.DVDM_ID ='DM0000000000015'

SELECT * FROM PL_REQUEST_DOC WHERE REQ_ID ='PLRD00000205578'
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID ='PLRD00000205578'

ID:PLRD00000205578
TypeMail, Type nội dung: REQUEST_DOC_PROCESS_Approve

INSERT INTO PL_REQUEST_PROCESS VALUES ('PLRD00000205578','TKHDQT','U','TKHDQT','','',NULL,'TGD','N','','',N'Chờ Thư Ký HĐQT xác nhận','1','','')
UPDATE PL_REQUEST_PROCESS SET PARENT_PROCESS_ID ='TKHDQT' WHERE REQ_ID ='PLRD00000205578' AND PROCESS_ID ='HDQT'

SELECT * FROM PL_REQUEST_PROCESS prp WHERE prp.REQ_ID = 'PLRD00000205572'
SELECT * FROM PL_REQUEST_PROCESS_CHILD prpc WHERE prpc.REQ_ID = 'PLRD00000205572'

SELECT * FROM PL_REQUEST_COSTCENTER WHERE REQ_ID = 'PLRD00000205572'

UPDATE PL_REQUEST_PROCESS SET STATUS = 'U' WHERE ID = 75594
DELETE PL_REQUEST_PROCESS_CHILD WHERE PROCESS_ID = '75594'
UPDATE PL_REQUEST_PROCESS_CHILD SET MAKER_ID = NULL, TRANFER_DT = NULL WHERE PROCESS_ID = '75592'

EXEC PL_REQUEST_COSTCENTER_ByID @P_REQ_ID = 'PLRD00000205572'
,@p_TYPE = 'DVKD'
,@p_TLNAME = 'vinhnd3'

UPDATE PL_REQUEST_DOC SET PROCESS_ID = 'DVCM' WHERE REQ_ID = 'PLRD00000205572'

SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID ='PLRD00000205578'

UPDATE PL_REQUEST_PROCESS SET DVDM_ID='DM0000000000014' WHERE ID='74473'
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID ='PLRD00000205434'

EXEC ASS_LIQUIDATION_BVB_App @P_LIQ_ID='',@P_AUTH_STATUS='A',@P_CHECKER_ID='admin',@P_APPROVE_DT=N'25/10/2022 23:52:04'

INSERT INTO dbo.PL_PROCESS
(
REQ_ID,
PROCESS_ID,
CHECKER_ID,
APPROVE_DT,
PROCESS_DESC,
NOTES
)
VALUES
( @P_LIQ_ID,
'APPROVE',
@p_CHECKER_ID,
GETDATE,
N'Trưởng đơn vị phê duyệt thành công' ,
N'Trưởng đơn vị phê duyệt'
)

INSERT INTO ASS_TRANSACTIONS(ASSET_ID, TRN_ID, TRN_TYPE, TRN_DATE, RECORD_STATUS, AUTH_STATUS,
[MAKER_ID], [CREATE_DT], [CHECKER_ID], [APPROVE_DT]
)
SELECT ald.ASSET_ID,ald.LIQDT_ID,'ASS_LIQ',GETDATE,'1','A', ald.MAKER_ID,GETDATE,'admin'
FROM ASS_LIQUIDATION_DT ald WHERE ald.LIQ_ID =''

SELECT COUNT
FROM ASS_AMORT_DT aad
WHERE
aad.AMORT_DT ='2022-10-26' OR aad.AMORT_DT ='2022-10-25'