COUNTER DATE - MX

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

Was this article helpful?

Powered by Zendesk