CLIENT SUPPORT » PT AMARTHA MICRO FINTEK BUGS

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;

sudah diupdate dan sudah tampil indikator cuti nya