ikuti step nya
setelah semua selesai pastikan meminta update API MOBILE beda juga client beda API
features hide and show origin and remaining value dinamis by setup table
features limit attachment include popup and button remaining dinamis by setup table
STEP 1
ALTER TABLE SMENUMOBILE ADD MaxAttachmentKb varchar(100) DEFAULT '0'
STEP 2
UPDATE SMENUMOBILE SET MaxAttachmentKb ='500'
-satuan ukuran dalam KB = 500 KB
-formay file yang didukung jpg/pdf
STEP 3
ALTER TABLE PHRTMABSTYP ADD OriginalQuotaVisible varchar(2) DEFAULT '1',RemainQuotaVisible varchar(2) DEFAULT '1'
STEP 4
UPDATE PHRTMABSTYP SET OriginalQuotaVisible ='1' ,RemainQuotaVisible='1'
Nilai 1 = visible
Nilai 0 = Hide
STEP 5
CREATE PROCEDURE [api].[GetDataGetAbsenType] --@Email VARCHAR
@EmployeeID VARCHAR='',
@StartDeduction VARCHAR='',
@EndDeduction VARCHAR='',
@MenuId VARCHAR=''
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
SELECT tabsence.AbsenceType ,
tabsence.AbsenceTypeDesc ,
tquota.AbsenceQuotaType ,
tabsence.QuotaDeduction ,
tabsence.OriginalQuotaVisible ,
tabsence.RemainQuotaVisible
INTO #final
FROM dbo.PHRTMABSTYP AS tabsence
LEFT JOIN dbo.PHRTMQUOTYP AS tquota ON tquota.AbsenceQuotaType = tabsence.AbsenceQuotaType
WHERE tabsence.QuotaDeduction = 'N'
UNION
SELECT tabsence.AbsenceType ,
tabsence.AbsenceTypeDesc ,
tquota.AbsenceQuotaType ,
tabsence.QuotaDeduction ,
tabsence.OriginalQuotaVisible ,
tabsence.RemainQuotaVisible
FROM dbo.PHRTMABSTYP AS tabsence
LEFT JOIN dbo.PHRTMQUOTYP AS tquota ON tquota.AbsenceQuotaType = tabsence.AbsenceQuotaType
RIGHT JOIN dbo.PHRPA0017 AS md17 ON md17.AbsenceQuotaType = tabsence.AbsenceQuotaType
AND md17.EmployeeID = @EmployeeID
AND md17.StartDeduction <= @StartDeduction
AND md17.EndDeduction >= @EndDeduction
WHERE tabsence.QuotaDeduction = 'Y'
UNION
SELECT AbsenceType ,
AbsenceTypeDesc ,
AbsenceQuotaType ,
QuotaDeduction ,
OriginalQuotaVisible ,
RemainQuotaVisible
FROM dbo.PHRTMABSTYP
WHERE AbsenceType IN ( SELECT Value1
FROM dbo.PCMEPGENPARAM
WHERE Parameter = 'ESSABSTYP' )
SELECT *,CONVERT AS MaxAttachmentKb INTO #beginer FROM #final
IF @MenuId = ''
BEGIN
UPDATE #beginer SET MaxAttachmentKb =a.MaxAttachmentKb from(
SELECT TOP (1) MaxAttachmentKb FROM SMENUMOBILE )a
end
IF @MenuId <> ''
begin
UPDATE #beginer SET MaxAttachmentKb =a.MaxAttachmentKb from(
SELECT MaxAttachmentKb FROM SMENUMOBILE WHERE MenuId='LEAVE')a
end
SELECT * FROM #beginer
DROP TABLE #beginer
DROP TABLE #final
END;