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

https://drive.google.com/file/d/1tFgG4Ylhl_BZOmUCZ0UDUFoZ4LtG3x_7/view?usp=drive_link

DECLARE @REQ_ID VARCHAR
SELECT @REQ_ID = REQ_ID FROM TR_REQUEST_JOB_FORM trjf WHERE REQ_CODE = 'ATF-24-002659'
UPDATE TR_REQUEST_JOB_FORM SET PROCESS_ID = 'APPNEW',AUTH_STATUS = 'U',CHECKER_ID = NULL,APPROVE_DT = NULL WHERE REQ_ID = @REQ_ID
UPDATE PL_REQUEST_PROCESS SET STATUS = 'C', ROLE_USER = 'GDDV',BRANCH_ID = 'DV0001',DEP_ID = 'DEP000000000014',NOTES = N'Chờ Trưởng đơn vị phê duyệt' WHERE REQ_ID = @REQ_ID AND PROCESS_ID = 'APPNEW'
DELETE PL_REQUEST_PROCESS WHERE REQ_ID = @REQ_ID AND PROCESS_ID = 'APPROVE'
DELETE PL_PROCESS WHERE REQ_ID = @REQ_ID AND CHECKER_ID = 'yntn2'
SELECT @REQ_ID = crt.REQUEST_TEMPLATE_ID FROM CM_REQUEST_TEMPLATE crt WHERE crt.REPORT_NO = '011630/2024/TTr-79900001'
SELECT * FROM CM_TEMPLATE_LOG ctl WHERE ctl.REQ_ID = @REQ_ID
--24062024_SECRETKEY

CREATE INDEX [INXJOB01]
ON [dbo].[TR_REQUEST_JOB_FORM] ([REQ_ID])
ON [PRIMARY]
GO
IF @ERROR<>0 OR @TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO

--
-- Create index [INXJOB02] on table [dbo].[TR_REQUEST_JOB_FORM]
--
CREATE INDEX [INXJOB02]
ON [dbo].[TR_REQUEST_JOB_FORM] ([REQ_ID])
ON [PRIMARY]
GO
IF @ERROR<>0 OR @TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO

DECLARE @REQ_ID VARCHAR = NULL
SET @REQ_ID = (SELECT REQ_ID FROM TR_REQUEST_DOC trd WHERE REQ_CODE = 'PUR/2024/000208')
UPDATE TR_REQUEST_DOC SET PROCESS_ID = 'APPROVE' WHERE REQ_ID = @REQ_ID
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 TYPE_JOB = 'XL' AND REQ_ID = @REQ_ID

exec TR_BUDGET_CHECK_LIMIT_MONTH_GET_INFO_LIMIT @p_GD_ID=N'GOO000001061875',@p_BRANCH_ID=N'BRN000000000387',@p_DEP_ID=N'',@p_MONTH=N'M10',@p_YEAR=N'2024',@p_BRANCH_KIND=N'A',@p_TLNAME=N'',@p_KHOI_ID=N'',@p_ROLENAME=N'',@p_GD_CODE=NULL
go