Basic counter when a given variable change
String previous = _doJava.get("_str1",-1); //Reset to 0
int previous_result = Str.ToIntOrZero(_doJava.get("_str2",-1)); //The java itself
if (_str1.equals(previous))
return previous_result + 1;
return 1 ;
if you want to stop the counter at 25 for example :
String previous = _doJava.get("_str1",-1); //Reset to 1
double counter = Str.ToDouble(_doJava.get("_str2",-1)) + 1.0;
if (!_str1.equals(previous))
return "1";
if (_str1.equals(previous))
{
if (!_str1.equals(_doJava.get("_str1",-25)))
return counter;
if (_str1.equals(_doJava.get("_str1",-25)))
return "";
}
<p></p>
return "";
Counter in days - Clothing Age (habillage)
Equipment lifetime
> // _str1 date
// _str2 reset to 0
// _str3 the java itself
JDate jDate1=_doJava.getNewJDate();
if (!jDate1.set(_str1))
return "";
String prev_date=_doJava.get("_str1",-1);
double prev_age=Str.ToDouble(_doJava.get("_str3",-1));
JDate jDate2=_doJava.getNewJDate();
if (!jDate2.set(prev_date))
return "";
double timediff=(jDate1.getTimeInMillis()-jDate2.getTimeInMillis())/(24*60*60*1000.0);
if (!_str2.equals(""))
return "0.0";
if (_doJava.get("_str3",-1).equals(""))
return "";
return prev_age+timediff;
Counter - calculate the accumulation for each month
Reset to 0 at the begining of the month
(with first day of month start at 6:00 am)
//_str1 = date_time and _str2 = data to accumulate
JDate jDate1=_doJava.getNewJDate();
JDate jDate2=_doJava.getNewJDate();
if (!jDate1.set(_str1)) return "";
if (!jDate2.set(_doJava.get("_str1",-1))) return "";
jDate1.setHour(jDate1.getHour() - 6);//Prise en compte que la journée commence à 6h00
jDate2.setHour(jDate2.getHour() - 6);
int month = jDate1.getMonth();
int prevmonth = jDate2.getMonth();
if (month!=prevmonth)
return _str2;
return Str.ToDouble(_str2) + Str.ToDouble(_doJava.get("_str3",-1));//_str3 = the java itself