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

exec ASS_AMORT_DO @p_EXECUTE_DATE=N'25/10/2022 23:52:04',@p_ASSET_TYPE=N'CCLD',@p_MAKER_ID=N'vanpt2',@p_CHECKER_ID=N'vanpt2',@p_BRANCH_ID_LST=NULL

ReturnToGDDVDMMS : Chuyển về lại trưởng đơn vị ĐMMS

UPDATE ASS_AMORT SET ASSET_TYPE ='', TOTAL_AMT =5327258666 + 5327258666, IS_LEAF='Y' WHERE AMORT_ID ='ASM000000251051'
UPDATE ASS_AMORT_DT SET AMORT_ID='ASM000000251051' WHERE AMORT_ID ='ASM000000251052'
DELETE FROM ASS_AMORT WHERE AMORT_ID ='ASM000000251052'

UPDATE ASS_AMORT SET ASSET_TYPE ='', TOTAL_AMT =5327258666 + 172247378, IS_LEAF='Y' WHERE AMORT_ID ='ASM000000251051'

SELECT * FROM ASS_AMORT_DT aad where AMORT_DT='2022-09-23'
AND aad.ASSET_ID NOT IN (SELECT aad.ASSET_ID FROM ASS_AMORT_DT aad where AMORT_DT='2022-10-26' OR AMORT_DT='2022-10-25')

DELETE FROM PL_REQUEST_PROCESS WHERE ID='74473'
UPDATE PL_REQUEST_PROCESS SET PARENT_PROCESS_ID ='GDK_TT' WHERE ID='74474'
DELETE FROM PL_PROCESS WHERE CHECKER_ID ='tupa' AND REQ_ID ='PLRD00000205434'

UPDATE PL_REQUEST_PROCESS SET IS_HAS_CHILD='1' WHERE PROCESS_ID ='DVDM_DC'

SELECT COUNT AS SL FROM ASS_AMORT_DT WHERE AMORT_ID='ASM000000251051'

SELECT COUNT AS SL_HT FROM ASS_ENTRIES_POST WHERE TRN_ID='ASM000000251051'

UPDATE R
SET AMORTIZED_MONTH = AMORTIZED_MONTH-1, AMORTIZED_AMT = AMORTIZED_AMT- P.AMORT_AMT
FROM dbo.ASS_MASTER AS R
INNER JOIN dbo.ASS_AMORT_DT AS P
ON R.ASSET_ID =P.ASSET_ID
WHERE P.AMORT_ID ='ASM000000251051'

SELECT * FROM ASS_MASTER WHERE AND AMORT_STATUS NOT IN ('CKH','DKH','DTL','KKH','VNM')

declare @p_EXECUTE_DATE varchar(20)=N'25/10/2022 23:52:04',@p_ASSET_TYPE varchar(15)=N'ALL',@p_MAKER_ID varchar(15) =N'vanpt2',@p_CHECKER_ID VARCHAR =N'vanpt2',@p_BRANCH_ID_LST XML=NULL
declare @l_AMORT_ID varchar(15), @l_AMORTDT_ID varchar(15)
declare @l_LAST_AMORT_ID varchar(15) = NULL
declare @l_AMORT_TERM nvarchar(50) = ''

declare @l_ASSET_ID varchar(15)
    declare @l_AMORTIZED_AMT decimal(18,0)
    declare @l_AMORTIZED_MONTH int
    declare @l_AMORT_AMT decimal(18,0)
    declare @l_AMORT_MONTH decimal(18,2)
    declare @l_AMORT_END_DATE datetime, @l_AMORT_START_DATE datetime
    declare @l_FIRST_AMORT_AMT decimal(18,0), @l_MONTHLY_AMORT_AMT decimal(18,0)
    declare @l_BRANCH_ID varchar(15)
    declare @l_DEP_ID varchar(15)    
    declare @l_BRANCH_ID_DO varchar(15) = NULL, @l_BRANCH_TYPE_DO VARCHAR(15)
    declare @l_CURR_AMORT_AMT decimal(18,0)
    declare @l_TOTAL_AMT decimal(18,0)
    declare @l_CURR_AMORT_STATUS nvarchar(100)
    declare @l_DESC nvarchar(1000)
    DECLARE @ERRORSYS NVARCHAR(15) = '' 
    DECLARE @LST_BRANCH TABLE ( BRANCHID VARCHAR(15), BRANCHCODE VARCHAR(15))

DECLARE @ErrCode nvarchar(10) --Phong added
    declare @l_AmortIdDefault varchar(100) = '',@l_AMORTTERMDefault varchar(100) = '',
    @l_TOTALAMTDefault decimal (18,2) = 0,@l_PROCESSSTATUSDefault varchar(100) = '',
    @l_ExecDateDefault datetime = null, @l_StatusNameDef varchar(100) = '', @l_NotesDef varchar(100) = ''
    --

declare @sExecDT datetime = convert(datetime, @p_EXECUTE_DATE, 103)

select @l_LAST_AMORT_ID = AMORT_ID
    FROM ASS_AMORT
    WHERE IS_LEAF = 'Y'

SET @l_AMORT_TERM = convert(varchar(2), datepart(month, @sExecDT)) + '/' + convert(varchar(4), datepart(year, @sExecDT))

SELECT A.ASSET_ID, A.AMORTIZED_AMT, A.AMORTIZED_MONTH,
                A.AMORT_AMT,  A.AMORT_MONTH, A.AMORT_END_DATE, A.AMORT_START_DATE,
                A.FIRST_AMORT_AMT, A.MONTHLY_AMORT_AMT, A.BRANCH_ID, A.DEPT_ID
         FROM ASS_MASTER A
         WHERE A.AMORT_STATUS IN ('CKH','DKH')
            AND convert(date, A.AMORT_START_DATE) <= convert(date, @sExecDT)
            AND A.AMORTIZED_AMT < A.AMORT_AMT
            AND A.RECORD_STATUS = '1'
            AND A.AUTH_STATUS = 'A'
            AND (A.TYPE_ID = @p_ASSET_TYPE OR @p_ASSET_TYPE = 'ALL') --Phong

DELETE FROM ASS_AMORT_DT WHERE AMORT_ID='ASM000000251051'
DELETE FROM ASS_AMORT WHERE AMORT_ID='ASM000000251051'
DELETE FROM ASS_ENTRIES_POST WHERE TRN_ID ='ASM000000251051'

UPDATE ASS_AMORT SET IS_LEAF ='Y' WHERE AMORT_ID ='ASM000000251050'

EXEC [ASS_AMORT_Do] '25/10/2022','admin','admin','ALL',NULL

SELECT * FROM PAY_ENTRIES_POST WHERE CONVERT ='2022-10-26'

ASM000000251053

DELETE FROM TL_USER WHERE TLNANME ='admin'

EXEC ASS_AMORT_Start @p_AMORT_ID ='ASM000000251053'

EXEC [ASS_ENTRIES_POST_CoreByRef] 'ASM000000251053','AMORT'