CLIENT SUPPORT » ROHTO BUGS

=> penambahan CekLvDate di field OnInitExtensions di 'field[name=StartDate]': {
change: function (field) {
selectDate(field);
fillEndDate(field);
CekLvDate(); // penambahan
}
},

'field[name=AbsenceType]': {
select: function (field) {
selectAbsenceType(field);
fillEndDate(field);
CutiThn(); // penambahan
}
},

// penambahan field[name=TotalRemainingQuota]
'field[name=TotalRemainingQuota]': {
change: function () {
CekLvMin();
}
},

=> penambahan function di field OnMethodExtensions:

function CekLvDate() {
debugger;
var body = MinovaUtil.WORKFLOW.getViewBodyWorkflow();
var emp = MinovaUtil.WORKFLOW.getEmpId();
var StartDate = body.down('field[name=StartDate]').getValue();
var Lv = '';
var lv2 = '';
MinovaUtil.ExecuteParamQuery({
ID: 'LVCKDATE',
StartDate: StartDate,
EmpID: emp
}, function (s) {
d
var result = Ext.decode(s.responseText);
var dt = Ext.decode(Ext.decode(result.data));
if (dt.length == 0) {
Lv = '';
} else {
var val = dt⁰.Tglrovr;
var val2 = dt⁰.Tglrun;
Lv = val;
lv2 = val2;
}
});
if (Lv == '1') {
MinovaMessageError("ERROR", "CEK19LV", "", "");
body.down('field[name=StartDate]').setValue('');
body.down('field[name=EndDate]').setValue('');
} else if (lv2 == '1') {
MinovaMessageError("ERROR", "CEKRUNLV", "", "");
body.down('field[name=StartDate]').setValue('');
body.down('field[name=EndDate]').setValue('');
}
}
function CekLvMin() {
var Body = MinovaUtil.WORKFLOW.getViewBodyWorkflow();
var ttlquo = Body.down('[name=TotalRemainingQuota]').getValue();
if (ttlquo < 0) {
MinovaMessageError("ERROR", "CEKLVQUO", "", "");
Body.down('field[name=EndDate]').setValue('');
}
}
function CutiThn() {
var body = MinovaUtil.WORKFLOW.getViewBodyWorkflow();
var abs = body.down('[name=AbsenceType]').getValue();
var StartDate = body.down('[name=StartDate]');
var StartD = body.down('[name=StartDate]').getValue();
var EndDate = body.down('[name=EndDate]');
var ss = '19000101';
var ee = '99991231';
var now = MinovaUtil.GetNowDate();
var abss = body.down('[name=TotalAbsenceTaken]');
var res = '';
MinovaUtil.ExecuteParamQuery({
ID: 'CEKTWOWEEKLEAVE'
}, function (s) {
var result = Ext.decode(s.responseText);
var dt = Ext.decode(Ext.decode(result.data));
var val = dt⁰.res;
res = val;
});
if (abs == '1000') {
StartDate.setMinValue(res.substring(6, 8) + '/' + res.substring(4, 6) + '/' + res.substring(0, 4));
StartDate.setMaxValue(ee.substring(6, 8) + '/' + ee.substring(4, 6) + '/' + ee.substring(0, 4));
EndDate.setMinValue(StartD.substring(6, 8) + '/' + StartD.substring(4, 6) + '/' + StartD.substring(0, 4));
EndDate.setMaxValue(ee.substring(6, 8) + '/' + ee.substring(4, 6) + '/' + ee.substring(0, 4));
} else {
StartDate.setMinValue(ss.substring(6, 8) + '/' + ss.substring(4, 6) + '/' + ss.substring(0, 4));
EndDate.setMaxValue(ee.substring(6, 8) + '/' + ee.substring(4, 6) + '/' + ee.substring(0, 4));
}
}

=> tambah Data di table [dbo].[PCMWFCUSTPARAM] :
1)
ID : LVCKDATE

Value :
DECLARE @Regidtbl TABLE) INSERT INTO @Regidtbl SELECT RegID FROM dbo.PCMWFRUNMAIN WHERE BizflowID ='MD_Leave_AJTM' AND EmpIDAs=@EmpID DECLARE @TglRun TABLE) INSERT INTO @TglRun SELECT DISTINCT CASE WHEN NOT EXISTS (SELECT DISTINCT Value FROM PCMWFRUNBIZDATA DATA INNER JOIN @Regidtbl reg ON reg.RegID = data.RegID WHERE FieldID ='StartDate' AND Value =@StartDate ) THEN '0' ELSE '1' END DECLARE @TglOvr TABLE) INSERT INTO @TglOvr SELECT DISTINCT CASE WHEN NOT EXISTS (SELECT DISTINCT StartDate FROM PHRPA0019 WHERE EmployeeID = @EmpID AND StartDate =@StartDate) THEN '0' ELSE '1' END SELECT * FROM @TglOvr, @TglRun

CommandType : sqlstring

2)
ID : CEKTWOWEEKLEAVE

Value :
DECLARE @Days VARCHAR = (SELECT Value1 FROM dbo.PCMEPGENPARAM WHERE Parameter='MINIMALHARIPENGAJUANCUTITAHUNAN') DECLARE @Now VARCHAR = (SELECT FORMAT (getdate(), 'yyyymmdd') ) DECLARE @Two DATETIME = (SELECT DATEADD , GETDATE)) SELECT FORMAT (@Two,'yyyyMMdd') AS res

CommandType : sqlstring