Project

General

Profile

Feature #1362

Support 04-03-2022

Added by Luc Tran Van over 3 years ago. Updated about 3 years ago.

Status:
New
Priority:
Normal
Assignee:
Luc Tran Van
Start date:
03/04/2022
Due date:
% Done:

0%

Estimated time:
CM_HH_UPD.txt (3.57 KB) CM_HH_UPD.txt Luc Tran Van, 03/04/2022 04:10 PM
SUPPORT 1 TO TRINH.txt (77.6 KB) SUPPORT 1 TO TRINH.txt Luc Tran Van, 03/21/2022 08:54 AM
FILE 2- DATA.txt (171 Bytes) FILE 2- DATA.txt Luc Tran Van, 03/21/2022 08:54 AM
TAM UNG NB 133.txt (1.81 KB) TAM UNG NB 133.txt Luc Tran Van, 03/21/2022 09:42 AM
TR_REQ__AD_PAYMENT_SEARCH.txt (30.5 KB) TR_REQ__AD_PAYMENT_SEARCH.txt Luc Tran Van, 03/21/2022 10:06 AM
TR_REQ__AD_PAYMENT_SEARCH_v2.txt (30.6 KB) TR_REQ__AD_PAYMENT_SEARCH_v2.txt Luc Tran Van, 03/21/2022 10:17 AM
PAY MENT.txt (1.17 MB) PAY MENT.txt Luc Tran Van, 03/21/2022 05:12 PM
PAYMENT 2022.txt (3.6 MB) PAYMENT 2022.txt Luc Tran Van, 03/21/2022 05:29 PM
PAYMENT 2022.txt (3.6 MB) PAYMENT 2022.txt Luc Tran Van, 03/21/2022 09:48 PM
TR_REQ_PAYMENT_DT.txt (56.8 KB) TR_REQ_PAYMENT_DT.txt Luc Tran Van, 03/22/2022 11:07 AM
TR_ADVANCE_PAYMENT.txt (445 KB) TR_ADVANCE_PAYMENT.txt Luc Tran Van, 03/22/2022 11:09 AM

History

#1 Updated by Luc Tran Van over 3 years ago

DECLARE @REQ_ID VARCHAR, @DATE DATETIME, @USER_REQUEST VARCHAR
SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2022/000193')
SET @DATE='2022-01-05 12:00:00 AM'
UPDATE TR_REQUEST_DOC SET APPROVE_DT =@DATE, REQ_DT =@DATE WHERE REQ_ID =@REQ_ID
UPDATE PL_PROCESS SET APPROVE_DT =@DATE WHERE REQ_ID =@REQ_ID
INSERT INTO PL_PROCESS (REQ_ID,PROCESS_ID,NOTES,PROCESS_DESC,CHECKER_ID,APPROVE_DT)
VALUES (@REQ_ID,'IT',N'Yêu cầu lùi ngày',N'Hỗ trợ lùi ngày PYCMS theo yêu cầu','diemttt1',GETDATE)

#3 Updated by Luc Tran Van over 3 years ago

EXEC dbo.sp_generate_inserts @table_name = 'PL_REQUEST_DOC', -- varchar(776)
@from = 'FROM PL_REQUEST_DOC' -- varchar(800)

#5 Updated by Luc Tran Van about 3 years ago

INSERT INTO [TR_REQ_ADVANCE_PAYMENT] ([REQ_PAY_ID],[REQ_PAY_CODE],[BRANCH_ID],[DEP_ID],[REQ_REASON],[REQ_TYPE],[REQ_ENTRIES],[REQ_DESCRIPTION],[REF_ID],[PAY_PHASE],[RECEIVER_DEBIT],[RECEIVER_PO],[REQ_PAY_TYPE],[REQ_TYPE_CURRENCY],[REQ_AMT],[REQ_TEMP_AMT],[MAKER_ID],[CREATE_DT],[EDITOR_ID],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[CREATE_DT_KT],[MAKER_ID_KT],[AUTH_STATUS_KT],[CHECKER_ID_KT],[APPROVE_DT_KT],[CONFIRM_NOTES],[BRANCH_CREATE],[NOTES],[RECORD_STATUS],[TRANSFER_MAKER],[TRANSFER_DT],[TRASFER_USER_RECIVE],[PROCESS],[REQ_DT],[PAY_AMT],[DVDM_ID],[RATE],[RECIVER_MONEY],[IS_PERIOD])VALUES

Column1
INSERT INTO [PL_REQUEST_PROCESS] ([ID],[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
INSERT INTO [PL_REQUEST_PROCESS] ([ID],[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

#9 Updated by Luc Tran Van about 3 years ago

DMMS00000000013

#10 Updated by Luc Tran Van about 3 years ago

DMMS00000000160

#16 Updated by Luc Tran Van about 3 years ago

SELECT * FROM CM_HANGHOA
SELECT * FROM CM_HANGHOA_DVCM
SELECT * FROM SYS_HH_GROUP_LIMIT
SELECT * FROM SYS_GROUP_LIMIT
SELECT * FROM SYS_GROUP_LIMIT_DT

Also available in: Atom PDF