MINOVAES - PRODUCT

Tutorial Deployment Alert Khusus Klien Yang Sewa

1. Buka Table PCMEPGENPARAM, kemudian tambahkan row baru untuk parameter JATUHTEMPO.
StartDate = Masa Berlaku Sewa
EndDate = Waktu habis jatuh tempo
Parameter= 'JATUHTEMPO'
Value1= 'Y'
Valur2 = Isi message jatuh tempo disini

2. Table PCMWFCUSTPARAM

ID = GetJatuhTempo

Value=
DECLARE @Datetime DATETIME = DATEADD)
DECLARE @Date VARCHAR=(SELECT REPLACE, @Datetime, 102), '.', ''))
select
StartDate
,' '+dbo.fn_formatdatetime(EndDate, 'DD/mm/yyyy') as EndDate
--,@Date as [1bulansetelahskrg]
,Value1 as Sewa
,Value2 as Message
,CASE WHEN EndDate<=@Date then '1' else '0' end as Alert
from PCMEPGENPARAM where Parameter='JATUHTEMPO'

CommandType= sqlstring

3. Di Aplikasi, Ambil File Index ( Dari KJL Prod ) terbaru: Views/Home/Index