INSERT INTO [PL_REQUEST_PROCESS] ([REQ_ID],[PROCESS_ID],[STATUS],[ROLE_USER],[BRANCH_ID],[CHECKER_ID],[APPROVE_DT],[PARENT_PROCESS_ID],[IS_LEAF],[COST_ID],[DVDM_ID],[NOTES],[IS_HAS_CHILD],[DEP_ID])VALUES(N'PLRD00000200616',N'GDK_TT',N'U',N'GDK',N'',NULL,NULL,'TC',N'N',N'','DM0000000000015',N'Chờ Giám đốc khối xác nhận',NULL,NULL) INSERT INTO [PL_REQUEST_PROCESS] ([REQ_ID],[PROCESS_ID],[STATUS],[ROLE_USER],[BRANCH_ID],[CHECKER_ID],[APPROVE_DT],[PARENT_PROCESS_ID],[IS_LEAF],[COST_ID],[DVDM_ID],[NOTES],[IS_HAS_CHILD],[DEP_ID])VALUES(N'PLRD00000200616',N'GDK_TT',N'U',N'GDK',N'',NULL,NULL,'TC',N'N',N'','DM0000000000018',N'Chờ Giám đốc khối xác nhận',NULL,NULL) INSERT INTO [PL_REQUEST_PROCESS] ([REQ_ID],[PROCESS_ID],[STATUS],[ROLE_USER],[BRANCH_ID],[CHECKER_ID],[APPROVE_DT],[PARENT_PROCESS_ID],[IS_LEAF],[COST_ID],[DVDM_ID],[NOTES],[IS_HAS_CHILD],[DEP_ID])VALUES(N'PLRD00000200616',N'PTGD_TT',N'U',N'PTGD',N'',NULL,NULL,'GDK_TT',N'N',N'','DM0000000000015',N'Chờ phó tổng giám đốc khối xác nhận',NULL,NULL) INSERT INTO [PL_REQUEST_PROCESS] ([REQ_ID],[PROCESS_ID],[STATUS],[ROLE_USER],[BRANCH_ID],[CHECKER_ID],[APPROVE_DT],[PARENT_PROCESS_ID],[IS_LEAF],[COST_ID],[DVDM_ID],[NOTES],[IS_HAS_CHILD],[DEP_ID])VALUES(N'PLRD00000200616',N'TGD',N'U',N'TGD',N'',NULL,NULL,'PTGD_TT',N'N',N'','',N'Chờ Tổng giám đốc xác nhận',NULL,NULL) UPDATE dbo.PL_REQUEST_DOC SET PROCESS_ID='GDK_TT' WHERE REQ_ID='PLRD00000200616' UPDATE dbo.PL_REQUEST_PROCESS SET STATUS='C' WHERE REQ_ID='PLRD00000200616' AND PROCESS_ID='GDK_TT' UPDATE dbo.PL_REQUEST_PROCESS SET STATUS='U',PARENT_PROCESS_ID='TGD' WHERE REQ_ID='PLRD00000200616' AND PROCESS_ID='APPROVE'