cgillis-aras

public string EvaluateDateCalculation(string dateValue)
{
    string dateFormula = @"(?:([0-9]+)[\s]*([+-])[\s]*)?(TODAY\(\))(?:[\s]*([+-])[\s]*([0-9]+))?";
    System.Text.RegularExpressions.Regex dateRegex = new System.Text.RegularExpressions.Regex(dateFormula);

    System.Text.RegularExpressions.Match dateMatch = dateRegex.Match(dateValue);
    if (dateMatch.Success)
    {
        System.Text.RegularExpressions.GroupCollection calcGroups = dateMatch.Groups;

cgillis-aras

string itemTypeName = this.getType();

Item dateProps = inn.newItem("Property", "get");
dateProps.setProperty("data_type", "date");
dateProps.setAttribute("select", "name");
Item sourceIT = dateProps.createPropertyItem("source_id", "ItemType", "get");
sourceIT.setProperty("keyed_name", itemTypeName);
sourceIT.setAttribute("select", "id");
dateProps = dateProps.apply();

cgillis-aras

string actionName = this.getAction();
string thisMethodName = "labs_CalculateDynamicDate"; // Set this to the name you are using for your method
if (actionName == thisMethodName)
{
  // If we get here, this is being used as a custom action, so switch to a get and return the results of that.
  this.setAction("get");
  return this.apply();
}

// If we get here, we are running in a server event, so just return this as normal

cgillis-aras

var applyWithSpinner = async function(itm) {
	aras.browserHelper.toggleSpinner(document, true);
	var res = await itm.applyAsync();
	aras.browserHelper.toggleSpinner(document, false);
	return res;
}

// Create a query we know will take a while like querying for all Methods in the system
var longQueryItem = aras.IomInnovator.newItem("Method", "get");
var res = await applyWithSpinner(longQueryItem);

cgillis-aras

Innovator inn = this.getInnovator();

// Check to see if this item is claimed at all
if (this.isLocked() == 0)
{
    return inn.newResult("No one");
}

// Query to make sure that we have the locked_by_id property
string selectedType = this.getType();

cgillis-aras

Innovator inn = this.getInnovator();

// Check to see if this item is claimed at all
if (this.isLocked() == 0)
{
    return inn.newResult("No one");
}

// Query to make sure that we have the locked_by_id property
Item part = inn.newItem("Part", "get");

cgillis-aras

Innovator inn = this.getInnovator();
Item part = inn.newItem("Part", "get");

// Add a Part BOM relationship to this query
Item partBom = inn.newItem("Part BOM", "get");
part.addRelationship(partBom);
// Shorthand equivalent
Item partBom = part.createRelationship("Part BOM", "get");

// Add an Item property to this query

cgillis-aras

Innovator inn = this.getInnovator();

Item newPart = inn.newItem("Part", "get");
newPart.setAttribute("returnMode", "countOnly");
newPart.setAttribute("page", "1");
newPart.setAttribute("pagesize", "10");
newPart = newPart.apply();

// The results when using returnMode="countOnly" look different than a normal item,
// so we need to retrieve them in a different way.

cgillis-aras

Innovator inn = this.getInnovator();

Item newPart = inn.newItem("Part", "add");
newPart.setProperty("item_number", "New Part 1");
newPart.setAttribute("doGetItem", "0");
newPart = newPart.apply();

// You can still validate the response when using doGetItem
if (newPart.isError())
{

cgillis-aras

var eventState = {};
var topWindow = aras.getMostTopWindowWithAras(window);
var item = topWindow.item;
var itemType = topWindow.itemType;
if (item) {
	var itemTypeName = topWindow.itemTypeName;
	var isTemp = aras.isTempEx(item);
	var isDirty = aras.isDirtyEx(item);
	var isNew = aras.isNew(item);
	var lockedBy = aras.getItemProperty(item, 'locked_by_id', '');