stateProcess.js

import("system.result");
import("Sql_lib");
import("system.vars");
import("system.neon");

var sorting = parseInt(vars.get("$field.SORTING"));
var campaignId = vars.get("$field.CAMPAIGN_ID");
var campaignStepId = vars.get("$field.CAMPAIGNSTEPID");

var validNextStep = newSelect("CAMPAIGNSTEP.CAMPAIGNSTEPID")
                        .from("CAMPAIGNSTEP")
                        .where("CAMPAIGNSTEP.CAMPAIGN_ID",campaignId)
                        .and("CAMPAIGNSTEP.SORTING",sorting+1)
                        .and(newWhere("CAMPAIGNSTEP.PREDECESSORSTEP_ID",campaignStepId,SqlBuilder.NOT_EQUAL())
                            .or("CAMPAIGNSTEP.PREDECESSORSTEP_ID is null"))
                        .cell();


if (validNextStep)
{
    result.string(neon.COMPONENTSTATE_EDITABLE);
}
else
{
    result.string(neon.COMPONENTSTATE_DISABLED);
}