Filter Context Dialog Grid Itemtype FileRevision Menu | C# Online Compiler

Filter Context Dialog Grid Itemtype FileRevision Menu by Bond, James Bond

function GMComapnyFilterSuppliers() {
    // _________________Cut below this line to paste into Innovator________________________
var companies = this.newItem(inArgs.itemTypeName, "get");
companies = companies.apply();
var totalComapnyCount = companies.getItemCount();
var innovator = new top.Innovator();
var idsToExclude = new Array();

// Get the suppliers that already exist
var ecr = innovator.getItemById("gm_work order", inArgs.itemSelectedID);

if(ecr){
ecr.fetchRelationships("gm_Work Order gm_Company");
var existingSuppliers = ecr.getRelationships("gm_Work Order gm_Company");
var supplierCount = existingSuppliers.getItemCount();


    for (var i = 0; i < supplierCount; i++) {
        var relatedItemRelationship = existingSuppliers.getItemByIndex(i);
        var company = relatedItemRelationship.getRelatedItem();
        idsToExclude.push(company.getID());
    }
}

var idArray = new Array();
var j = 0;

for (var i = 0; i < totalComapnyCount; i++) {
    var company = companies.getItemByIndex(i);

    var companyName = company.getProperty("_company_name");
    var companyId = company.getID();

    if (!companyName.toLowerCase().startsWith("gm") && idsToExclude.indexOf(companyId) == -1) {
        idArray[j++] = companyId;
    } 
}

// If there are no supliers to show, just add a random Id to display empty dialog without search option
// If left empty, the search option appers and displays all the companies by-passing this filter
// Just a simple hack found through testing 
// settting ecrid.. so will never find a company with that id
if (idArray.length === 0) {
    idArray.push(inArgs.itemSelectedID);
}

var idlist=idArray.join(",");

//***SET THE idlist ATTRIBUTE ON THE QRYITEM TO THE LIST
inArgs.QryItem.item.setAttribute("idlist", idlist);

// __________Cut Above this line and paste into Innovator Method editor __________
}

/// <reference path="../../../Utilities/gm_ARAS Grid Utilities.js" />
/// <reference path="../../../Utilities/gm_ARAS Tab Utilities.js" />
/// <reference path="../../../Utilities/gm_UI Utilities.js" />
function gm_Query_PPAT_onSearchClick() {
    // _________________Cut below this line to paste into Innovator________________________

    /* *****************************************************************************
    Method Name:			gm_Query_PPAT_onSearchClick
    Client Name:			General Motors
    Created By/Company:		Pitamber Tiwari/GM  
    Description:
        Search the BOM and/or Component view with the specified search criteria.

        Runs when the "Search" button is clicked.
        Calls a server method to get the results. Removes the existing rows and add the new rows, if any.
    ***************************************************************************** */
    debugger;
    var constants = {
        PPATResultItemType: "gm_Query PPAT Result",
        SearchMethodName: "gm_Query PPAT onSearch",
        Type: "type",
        Method: "Method",
        WorkOrder: "gm_Work Order",
        WorkOrderId: "_work_order",
        EcrNumber: "item_number",
        AddButton: "buttonAdd"
    };

    var topWnd = window.TopWindowHelper.getMostTopWindowWithAras();
    var innovator = aras.newIOMInnovator();

    // Removes all the relationships from the item
    var removeAllRelationship = function (item, relationshipName) {

        var allRels = item.getRelationships(relationshipName);
        var relCount = allRels.getItemCount();

        for (var i = 0; i < relCount; i++) {
            item.removeRelationship(allRels.getItemByIndex(i));
        }
    };

    // Adds all the supplied relationship to the item.
    var addRelationships = function (item, relationships) {
        var relCount = relationships.getItemCount();
        for (var i = 0; i < relCount; i++) {
            item.addRelationship(relationships.getItemByIndex(i));
        }
    };

    // Returns the ECR the current query is associated with
    var getEcr = function () {
        var workOrderId = document.thisItem.getProperty(constants.WorkOrderId, "");
        var workOrderWindow = aras.uiFindWindowEx(workOrderId);
        if (workOrderWindow.thisItem) {
            return workOrderWindow.thisItem;
        }
        return innovator.getItemById(constants.WorkOrder, workOrderId);
    };

    var onSearch = function (queryItem, tWnd, spinnerAsync) {
        // Display a spinner
        if (!spinnerAsync) {
            aras.browserHelper.toggleSpinner(tWnd.document, true);
            return setTimeout(function () {
                onSearch(queryItem, tWnd, true);
            }, 100);
        }

        try {
            // Call the server side method. Doing apply on the itemtype called the server method on save as well (closing the window). So, cloned and called to avoid unnecessary calls to server
            var methodItem = queryItem.clone();
            methodItem.setAttribute(constants.Type, constants.Method);
            methodItem.setAction(constants.SearchMethodName);

            var result = methodItem.apply();
            var ecrNumber = "";

            if (result.isError()) {
                removeAllRelationship(queryItem, constants.PPATResultItemType);
                ecrNumber = getEcr().getProperty(constants.EcrNumber, "");
                throw "Query for ECR " + ecrNumber + ": " + result.getErrorString();
            }

            if (result.getRelationships(constants.PPATResultItemType).getItemCount() === 0) {
                removeAllRelationship(queryItem, constants.PPATResultItemType);
                ecrNumber = getEcr().getProperty(constants.EcrNumber, "");
                return top.aras.AlertWarning("Query for ECR " + ecrNumber + ": No results to display.");
            }

            removeAllRelationship(queryItem, constants.PPATResultItemType);
            addRelationships(queryItem, result.getRelationships(constants.PPATResultItemType));

        } catch (ex) {
            return top.aras.AlertError(ex);
        } finally {
            // Hide the spinner
            aras.browserHelper.toggleSpinner(topWnd.document, false);
            // Refresh the tab
            parent.onRefresh();
        }
    };

    onSearch(document.thisItem, topWnd, false);


    // __________Cut Above this line and paste into Innovator Method editor __________
}


function gm_PPAT_Dialog_onSearchDialog() {
    // _________________Cut below this line to paste into Innovator________________________


    var workOrderId = inArgs.itemSelectedID;

    // When the part number if clicked, the selected Id is blank
    if (!workOrderId) {
        workOrderId = parent.thisItem.getID();
    }

    //create new Object
    var Filter = new Object();

    //Assign Filter
    Filter["_work_order_id"] = { filterValue: workOrderId, isFilterFixed: true };
    return Filter;


    // __________Cut Above this line and paste into Innovator Method editor __________
}



/// <reference path="../GMECR/PPAT/gm_PPAT on FNA Edit.js" />
/// <reference path="gm_ARAS Grid Utilities.js" />c:\code\gmdllcode\gmpd2\arasmethods\methods - client\utilities\gm_aras context utilities.js
function gm_ARAS_Context_Utilities() {
    // _________________Cut below this line to paste into Innovator________________________


    /* *****************************************************************************
    Method Name:			gm_ARAS_Context_Utilities
    Client Name:			General Motors
    Created By/Company:		Pitamber Tiwari/GM  
    Description:
      Utility method to update the grid/form properties. Use this method to get the right context (window) for the updates so that it uses the proper values for parent, document.thisItem etc.

      The Parent form (E.g.: ECR) must have the grid utility loaded
    ***************************************************************************** */
    // Using the guid to make it unique to the given ECR so that IE does not fail with freed script error.
    top[document.thisItem.getID() + 'gmArasContextUtilityNS'] = gmArasContextUtilityNS;
}

var gmArasContextUtilityNS = gmArasContextUtilityNS || function () {
    "use strict";

    var constants = {
        PropertyNames: {
            State: "state"
        },

        Actions: {
            Add: "add",
            Get: "get",
        },

        Attributes: {
            Where: "where",
            Select: "select",
            IdList: "idlist",
            KeyedName: "keyed_name"
        }
    };

    // Returns the context for the given window id. Window Id is the item id. For example: the window id for ECR form is the current ECR id
    var getContextForId = function (windowId) {
        // get the current context
        var currentWindow = aras.uiFindWindowEx(windowId);

        if (!currentWindow) {
            return null;
        }

        var currentContext = currentWindow.instance;

        // In IE, the contentWindow is undefined, but in Chrome current context is contentWindow
        if (currentContext.contentWindow) {
            currentContext = currentContext.contentWindow;
        }

        return currentContext;
    };

    // Returns the Parent Context.
    // For example: If you are working on PAT grid/form, will return the current ECR context so you have access to the methods defined in the current ECR
    var getParentContext = function (isGrid, parent) {

        var windowId = null;

        if (isGrid) {
            windowId = parent.thisItem.getID();
        } else {
            windowId = parent.thisItem.getProperty("source_id");
        }

        if (!windowId) {
            return null;
        }
        return getContextForId(windowId);
    };

    // Update property on the given grid
    var updateGridProperty = function (currentContext, gridApplet, relationshipID, propertyName, value, isItem) {
        if (isItem) {
            currentContext.gmARASGridUtilitiesNS.setCellItemValue(gridApplet, relationshipID, propertyName, value);
        } else {
            currentContext.gmARASGridUtilitiesNS.setCellValue(gridApplet, relationshipID, propertyName, value);
        }
    }

    // Update the Property value both on the Form and Grid. Avaoid parent form refresh
    var updateProperty = function (parentContext, gridApplet, itemIdToUpdate, propertyName, value, isItem, tabName) {
        // Update form
        if (!gridApplet) {
            var currentFormContext = getContextForId(itemIdToUpdate);

            if (isItem && value) {
                currentFormContext.handleItemChange(propertyName, value.getID());

                // Update the grid here so that we don't have to refresh the page
                var currentGrid = parentContext.gmARASGridUtilitiesNS.getGridForTabName(tabName);
                parentContext.gmARASGridUtilitiesNS.setCellItemValue(currentGrid, itemIdToUpdate, propertyName, value);
            } else {
                currentFormContext.handleItemChange(propertyName, value || "");
            }
        } else {
            updateGridProperty(parentContext, gridApplet, itemIdToUpdate, propertyName, value, isItem);
        }
    };

    // Returns true if the lifecycle state of the item is Edit (editable); false otherwise
    var itemInEditableState = function (currentRow, relationshipID) {
        var action = currentRow.getAction();

        // Can edit the one just added
        if (action.toLowerCase() === constants.Actions.Add) {
            return true;
        }

        // If not add, must only be able to edit in Edit State
        var state = currentRow.getProperty(constants.PropertyNames.State, "");

        // If not defined in the cache, get it from database
        if (!state) {
            var item = aras.newIOMInnovator().newItem(currentRow.getType(), constants.Actions.Get);
            item.setID(relationshipID);
            item.setAttribute(constants.Attributes.Select, constants.PropertyNames.State);
            item = item.apply();

            state = item.getProperty(constants.PropertyNames.State, "");
        }

        if (state.toLowerCase() !== "edit") {
            // Item cannot be edited
            return false;
        }

        return true;
    };

    // Returns true if the current user has update access on the given itemtype for the work order id (EcrId); false otherwise
    var currentUserHasUpdateAccess = function (workOrderId, itemType) {
        // Check if the curent user has permission to update
        var hasUpdateAccess = aras.newIOMInnovator().applyMethod("gm_ValidateUserRoleForFinishDate", "<work_order_id>" + workOrderId + "</work_order_id>"
            + "<rel_name>" + itemType + "</rel_name>").getResult();

        return hasUpdateAccess === "true";
    };

    // Returns true if the relationship is in Editable Lifecycle state; false otherwise
    var isEditableLifecycleState = function (parentContext, relationshipID) {
        // If the parent is locked, it should not be editable
        if (!parentContext.document.isEditMode) {
            return false;
        }

        // For the child form, the form must be in edit mode as well
        if (document.isEditMode !== undefined && !document.isEditMode) {
            return false;
        }
        var parentItem = parentContext.parent.thisItem;
        var currentRow = parentItem.getItemsByXPath("//Relationships/Item[@id='" + relationshipID + "']");
        currentRow = currentRow.getItemByIndex(0);

        if (!itemInEditableState(currentRow, relationshipID)) {
            return false;
        }

        // Check if the curent user has permission to update
        if (parentItem.getType().toLowerCase() === "gm_work order") {
            return currentUserHasUpdateAccess(parentContext.parent.thisItem.getId(), currentRow.getType());
        }

        return true;
    }

    // Returns keyed name for the given property from the parent item
    var getPropertyKeyedName = function (item, propertyName) {
        var propertyItem = item.getPropertyItem(propertyName);
        var keyedName = "";
        if (propertyItem) {
            keyedName = propertyItem.getAttribute(constants.Attributes.KeyedName, "");

            if (!keyedName) {
                keyedName = propertyItem.getProperty(constants.Attributes.KeyedName, "");
            }
            // Check the Attribute on id
            if (!keyedName) {
                keyedName = propertyItem.getPropertyAttribute("id", constants.Attributes.KeyedName, "");
            }
        }

        // If the keyedname is not found in the item, check to see if it is set as an attribute in the property
        if (!keyedName) {
            keyedName = item.getPropertyAttribute(propertyName, constants.Attributes.KeyedName, "");
        }

        return keyedName.trim();
    };


    return {
        getContextForId: getContextForId,
        getParentContext: getParentContext,
        updateGridProperty: updateGridProperty,
        updateProperty: updateProperty,
        isEditableLifecycleState: isEditableLifecycleState,
        getPropertyKeyedName: getPropertyKeyedName
    };


    //// Returns the Parent Context.
    //// For example: If you are working on PAT grid/form, will return the current ECR context so you have access to the methods defined in the current ECR
    //var getParentContext = function (isGrid, parent) {

    //    var windowId = null;

    //    if (isGrid) {
    //        windowId = parent.thisItem.getID();
    //    } else {
    //        windowId = parent.thisItem.getProperty("source_id");
    //    }

    //    if (!windowId) {
    //        return null;
    //    }
    //    return getContextForId(windowId);
    //};

    //// Update property on the given grid and form
    //var updateGridProperty = function (currentContext, gridApplet, relationshipID, propertyName, value, isItem, tabName) {
    //    // Updating the form updates the grid, so just update the form here, if any
    //    // Doing so syncs both grid and form. OOTB behavior does not update the form when the grid is updated
    //    var relationshipContext = getContextForId(relationshipID);
    //    if (relationshipContext) {
    //        updateFormControl(relationshipContext, relationshipID, propertyName, value, isItem, tabName);
    //    } else {
    //        if (isItem) {
    //            var keyedName = gmARASGridUtilitiesNS.getCellValueForRowId(gridApplet, relationshipID, propertyName);

    //            currentContext.gmARASGridUtilitiesNS.setCellItemValue(gridApplet, relationshipID, propertyName, value);
    //        } else {
    //            currentContext.gmARASGridUtilitiesNS.setCellValue(gridApplet, relationshipID, propertyName, value);
    //        }
    //    }
    //}

    //// Updates the property on both grid and form
    //var updateFormControl = function (parentContext, itemIdToUpdate, propertyName, value, isItem, tabName) {
    //    var currentFormContext = getContextForId(itemIdToUpdate);

    //    if (isItem && value) {
    //        currentFormContext.handleItemChange(propertyName, value.getID());

    //        // Update the grid here so that we don't have to refresh the page
    //        var currentGrid = parentContext.gmARASGridUtilitiesNS.getGridForTabName(tabName);
    //        if (currentGrid) {
    //            parentContext.gmARASGridUtilitiesNS.setCellItemValue(currentGrid, itemIdToUpdate, propertyName, value);
    //        }
    //    } else {
    //        currentFormContext.handleItemChange(propertyName, value || "");
    //    }
    //}

    //// Update the Property value both on the Form and Grid. Avoid parent form refresh
    //var updateProperty = function (parentContext, gridApplet, itemIdToUpdate, propertyName, value, isItem, tabName) {
    //    if (gridApplet) {
    //        updateGridProperty(parentContext, gridApplet, itemIdToUpdate, propertyName, value, isItem, tabName);
    //    } else {
    //        updateFormControl(parentContext, itemIdToUpdate, propertyName, value, isItem, tabName);
    //    }
    //};

}();



function end_of_method() {


    // __________Cut Above this line and paste into Innovator Method editor __________
}



function gm_ARAS_Dialog_Utilities() {

    // _________________Cut below this line to paste into Innovator________________________
    /* *****************************************************************************
    Method Name:			gm_ARAS Dialog Utilities
    Client Name:			General Motors
    Created By/Company:		Pitamber Tiwari/GM 
    Creation Date:			2017-08-17
    Description:
        Javascript utility methods to be used with ARAS Dialog Modal popups. 
        Update this file if you have a helper/utility method that is independent of item type and can be used without conflicts.
    
    Usage:
       For example; include the method in the parent form and bind it to onLoad event. This file must come before other functions that use the utility functions defined here.
       Can be used with other controls on UI with a different event too.

      Example of call from Grid Cell Event:
         top.arasModalDialogForFormNS.{function name}
        
    Hooks:
        Type:	ARAS Dialog Model 
        Event:	Any
        
        
    Revisions:
        Rev Date		    Modified By			    Description
        2017-08-17		    Pitamber Tiwari			Initial creation
    ***************************************************************************** */
    // debugger;

    // Adding the funtion to the top so that we can access from the grid
    top.arasModalDialogForFormNS = arasModalDialogForFormNS;
}

// ARAS Dialog Utility Class
var arasModalDialogForFormNS = arasModalDialogForFormNS || function () {

    const CONSTANTS = {
        ItemTypeNames: {
            Form: "form"
        },
        PropertyNames: {
            Name: "name",
            Height: "height",
            Width: "width"
        },
        Attributes: {
            Select: "select",
            Get: "get"
        },
        DefaultPopup: "DefaultPopup",
        DialogHtmlName: "ShowFormAsADialog.html",
    };

    // Returns the form for a given name
    var getForm = function (formName) {
        var form = top.Innovator().newItem(CONSTANTS.ItemTypeNames.Form, CONSTANTS.Attributes.Get);
        form.setAttribute(CONSTANTS.Attributes.Select, "id,width,height");
        form.setProperty(CONSTANTS.PropertyNames.Name, formName); // name of Form
        return form.apply();
    };

    // Returns an option to be used with the Dialog for provided form
    var createOptionsForForm = function (form) {
        // get height and width
        var height = form.getProperty(CONSTANTS.PropertyNames.Height, "600");
        var width = form.getProperty(CONSTANTS.PropertyNames.Width, "800");

        var options = {
            dialogWidth: width,
            dialogHeight: height
        };

        return options;
    };

    // Returns the param object for the given form with the given title and parameter item
    var createParameters = function (form, dialogTitle, item) {
        var param = new Object();
        param.title = dialogTitle;
        param.formId = form.getItemByIndex(0).getID();
        param.aras = top.aras;
        param.isEditMode = true;
        param.item = item;
        return param;
    };

    // Shows the Dialog modal
    var show = function (param, options) {
        var wnd = aras.getMainWindow();
        wnd = wnd === top ? wnd.main : top;
        aras.modalDialogHelper.show(CONSTANTS.DefaultPopup, wnd, param, options, CONSTANTS.DialogHtmlName);
    };

    // Hides the dialog model
    var hideDialog = function () {
        window.parent.close();
    };

    // Creates Param, Options, and shows the dialog with the given title and param item for the specified form
    var showDialog = function (formName, dialogTitle, paramItem) {
        var form = getForm(formName);

        if (form.IsError()) {
            return top.aras.AlertError(form.getErrorString());
        }

        var options = createOptionsForForm(form);
        var param = createParameters(form, dialogTitle, paramItem);
        show(param, options);
    };

    return {
        showDialog: showDialog,
        hideDialog: hideDialog
    };
}();


function end_of_method() {

   
// __________Cut Above this line and paste into Innovator Method editor __________
}





function gm_ARAS_Itemtype_Utilities() {

    // _________________Cut below this line to paste into Innovator________________________

    /* *****************************************************************************
    Method Name:			gm_ARAS Event Utilities
    Client Name:			General Motors
    Created By/Company:		Pitamber Tiwari/GM 
    Creation Date:			2017-06-12
    Description:
        Javascript utility methods to be used with form/grid events. 
        Update this file if you have a helper/utility method that is independent of item type and can be used without conflicts.

    Usage:
       For example; include the method in the form and bind it to onLoad event. This file must come before other functions that use the utility functions defined here.
        
    Hooks:
        Type:	Javascript Utility functions 
        Event:	Any
        
        
    Revisions:
        Rev Date		Modified By			    Description
        2017-06-12		Pitamber Tiwari			Initial creation
    ***************************************************************************** */
    // debugger;

    top.gmARASEventUtilitiesNS = gmARASEventUtilitiesNS;
}

// ARAS Itemtype utility class
var gmARASEventUtilitiesNS = gmARASEventUtilitiesNS || function () {
    var currentContext = null;
    var innovator = aras.newIOMInnovator();

    // Returns the item for the given keyedname
    var getItemUsingKeyedName = function (propertyName, keyedName, itemType) {
        // Get node from the context item
        var propertyItem = currentContext.getPropertyItem(propertyName);
       
        // If the item does not exist in the context, fetch it from database
        // This happens when the user manually types in the item number
        if (!propertyItem || propertyItem.getProperty("keyed_name") !== keyedName) {
            propertyItem = aras.newIOMInnovator().newItem(itemType, "get");
            propertyItem.setProperty("keyed_name", keyedName);
            propertyItem = propertyItem.apply();

            if (propertyItem.isError()) {
                // If the error was thrown becuase the keyed name does not exist, return an empty item as ARAS shows error message
                if (propertyItem.getErrorCode() === "0") {
                    return aras.newIOMInnovator().newItem(itemType, "get");
                } else {
                    throw propertyItem.getErrorDetail();
                }
            }

            if (propertyItem.getItemCount() > 1) {
                propertyItem = propertyItem.getItemByIndex(0);
            }
            // Update cache with item
            currentContext.setPropertyItem(propertyName, propertyItem);
        }

        return propertyItem;
    }

    // Returns the appropriate property value either from the event or from the cache. ARAS sometimes updates the cache after event but sometimes does not update the cache
    // Trying to get the right value no matter the event
    var getPropertyAfterEvent = function (context, propertyName, event, propertyItemType) {
        currentContext = context;
        // For grid, the value is updated in the cache. For form, if the event is fired by other item, cache has the value for this item
        if (!event || event.srcElement.name !== propertyName) {
            return currentContext.getProperty(propertyName);
        }
        else {
            // For item types, the cache is updated if the item is selected. If you clear without selection, the cache is not update
            if (propertyItemType) {
                if (event.srcElement.value) {
                    // srcElement value is the keyed name of the item type. So need to get the id from the property item
                    // This is also required if users manually types the keyed name in the item tpe text box. The underlying cache does not have the id yet
                    return getItemUsingKeyedName(propertyName, event.srcElement.value, propertyItemType).getProperty("id");
                }

                // Cleared the item type manually, so get it from srcElement. Cache still has the old value.
                return event.srcElement.value;
            }
                // non item types (dropdown for change action) will not have the cache updated yet. So, get the value from srcElement
            else {
                return event.srcElement.value;
            }
        }
    };

    return {
        getPropertyAfterEvent: getPropertyAfterEvent
    };
}();

function end_of_method() {

    // __________Cut Above this line and paste into Innovator Method editor __________

}



function gm_UI_Utilities() {

    // _________________Cut below this line to paste into Innovator________________________
    /* *****************************************************************************
    Method Name:			gm_ARAS Grid Utilities
    Client Name:			General Motors
    Created By/Company:		Pitamber Tiwari/GM 
    Creation Date:			2017-06-07
    Description:
        Javascript utility methods to be used with ARAS Relationship grids. 
        Update this file if you have a helper/utility method that is independent of item type and can be used without conflicts.
    
    Usage:
       For example; include the method in the parent form and bind it to onLoad event. This file must come before other functions that use the utility functions defined here.
       Can be used with other controls on UI with a different event too.

      Example of call from Grid Cell Event:
         top.gmARASGridUtilitiesNS.{function name}
        
    Hooks:
        Type:	ARAS Grid 
        Event:	Any
        
        
      Revisions:
        Rev Date		  Modified By			    Description
        2017-06-07		Pitamber Tiwari     Initial creation
        2017-06-19		Pitamber Tiwari		Add a method to return the grid control for the given control name
        2017-08-14		Pitamber Tiwari		Add utility methods to return list of property values (including for specific action) and set cell item property
        2017-08-31      Pitamber Tiwari     Add method to set the parent context so that context conflicts are removed
        2017-09-27      Pitamber Tiwari     Add method to get grid from a window for a given window id and tab name. Also add a method to set cell value without updating the cache
    ***************************************************************************** */

    // Adding the funtion to the top so that we can access from the grid
    top.gmARASGridUtilitiesNS = gmARASGridUtilitiesNS;
}

// ARAS Grid Utility Class
var gmARASGridUtilitiesNS = gmARASGridUtilitiesNS || function () {
    'use strict';
    var parentContext = parent;
    var innovator = aras.newIOMInnovator();

    // Returns the current index (column number) for the specified property in the given grid, even after column re-arragements
    var getColumnIndex = function (grid, propertyName) {
        return grid.grid_Experimental.order.indexOf(grid.GetColumnIndex(propertyName + "_D"));
    };


    // Sets the parent context to be used for the tabber
    var setParentContext = function (currentParentContext) {
        if (currentParentContext) {
            parentContext = currentParentContext;
        }
    };

    // Updates grid cell value as well as the underlying Cache
    var setCellValue = function (grid, relationshipID, propertyName, value) {

        // parent context must be set
        if (!parentContext) {
            return;
        }

        // Grid cannot update undefined or null and throws an error. Treat undefined/null as empty to not get error
        if (value === undefined || value === null) {
            value = "";
        }

        grid.cells(relationshipID, getColumnIndex(grid, propertyName)).setValue(value);
        var currentItem = parentContext.thisItem.getItemsByXPath("//Item[@id='" + relationshipID + "']");

        // don't know why but sometimes there are two items of same type returned in currentItem.
        if (currentItem.nodeList && currentItem.nodeList.length > 1) {
            currentItem = currentItem.getItemByIndex(0);
        }

        currentItem.setProperty(propertyName, value);

        // remove the keyedname and type,for itemtype so that empty ones return null for getPropertyItem function 
        currentItem.RemovePropertyAttribute(propertyName, "keyed_name");
        currentItem.RemovePropertyAttribute(propertyName, "type");

        // If the action is not set, set it to update
        if (!currentItem.getAction()) {
            currentItem.setAction("update");
        }

        // Mark it as dirty
        if (currentItem.getAttribute("isDirty") !== "1") {
            currentItem.setAttribute("isDirty", "1");
        }
    };

    // Updates grid cell value without updating the underlying cache (does not mark the item dirty)
    var setCellValueButNotCache = function (grid, relationshipID, propertyName, value) {

        // Grid cannot update undefined or null and throws an error. Treat undefined/null as empty to not get error
        if (value === undefined || value === null) {
            value = "";
        }

        grid.cells(relationshipID, getColumnIndex(grid, propertyName)).setValue(value);
    };

    // Updates grid cell property as well as the underlying Cache with the specified item (item must have keyed name as property or attribute)
    var setCellItemValue = function (grid, relationshipID, propertyName, item) {
        // parent context must be set
        if (!parentContext) {
            return;
        }

        // Grid cannot update undefined or null and throws an error. Treat undefined/null as empty to not get error
        if (item === undefined || item === null || item === "") {
            item = "";
            setCellValue(grid, relationshipID, propertyName, item);
            return;
        }

        var keyedName = item.getProperty("keyed_name", "");

        // Keyed name might be in the attribute, get it from there
        if (!keyedName) {
            keyedName = item.getAttribute("keyed_name");
        }

        // if the keyed name is still blank, get it from the database
        if (!keyedName) {
            var dbItem = innovator.getItemById(item.getType(), item.getID());
            keyedName = dbItem.getProperty("keyed_name", "");

            if (!keyedName) {
                keyedName = relationshipID;
            }
        }

        grid.cells(relationshipID, getColumnIndex(grid, propertyName)).setValue(keyedName);
        var currentItem = parentContext.thisItem.getItemsByXPath("//Item[@id='" + relationshipID + "']");

        // don't know why but sometimes there are two items of same type returned in currentItem.
        if (currentItem.nodeList && currentItem.nodeList.length > 1) {
            currentItem = currentItem.getItemByIndex(0);
        }

        // The action is set to skip by the item selector. This all is done to make sure the value is carried over to the form from grid that is not saved
        item.setAction("skip");
        item.setAttribute("keyed_name", keyedName);
        item.setPropertyAttribute(propertyName, "keyed_name", keyedName);

        // IE does not support innerHTML
        if (item.node.innerHTML) {
            item.node.innerHTML = ''; // no need to have the whole data
        }

        // Setting the property first because isNull was not removed by setPropertyItem
        currentItem.setProperty(propertyName, item.getID());
        currentItem.setPropertyItem(propertyName, item);
        currentItem.setPropertyAttribute(propertyName, "keyed_name", keyedName);

        // If the action is not set, set it to update
        if (!currentItem.getAction()) {
            currentItem.setAction("update");
        }

        // Mark it as dirty
        if (currentItem.getAttribute("isDirty") !== "1") {
            currentItem.setAttribute("isDirty", "1");
        }
    };
    
    // Returns a grid control for the given tab. Uses the parentContext scope for "parentContext" if supplied; otherwise uses the default "parentContext" scope
    var getGridForTabName = function (tabName, parentScope) {
        if (!tabName) {
            return;
        }

        // Take the parent scope if supplied, else use the default parent
        parentScope = parentScope || parentContext;

        // Parent scope was not defined, for some reason
        if (!parentScope) {
            return;
        }

        if (!parentScope.relationships ||
            !parentScope.relationships.relTabbarReady ||
            parentScope.relationships.relTabbar.GetTabOrder("|") === "") {
            setTimeout(function () {
                getGridForTabName(tabName, parentScope);
            }, 30);
            return;
        }
        var tabbar = parentScope.relationships.relTabbar;
        var tabID = tabbar.GetTabId(tabName);
        if (tabID) {
            var tabIFrame = parentScope.relationships.iframesCollection[tabID];

            if (tabIFrame && tabIFrame.contentWindow) {
                return tabIFrame.contentWindow.grid;
            }
            return null;
        }
        return null;
    };

    // Returns a grid control for the specified tab name on the given window if found; otherwise returns null. Use when you need to get a grid from already open parent window. For example; when you need to update PAT row from PAT form
    var getGridForTabNameAndWindowId = function (windowId, tabName) {

        // Window Id and tab name must be specified.
        if (!windowId || !tabName) {
            return null;
        }

        var itemWindow = aras.uiFindWindowEx(windowId);
        if (itemWindow) {
            var itemRelTabId = itemWindow.relationships.relTabbar.GetTabId(tabName);
            var itemRelTab = itemWindow.relationships.iframesCollection[itemRelTabId];
            if (itemRelTab && itemRelTab.contentWindow) {
                return itemRelTab.contentWindow.grid;
            }
        }

        return null;
    };

    // Returns the cell value for the property at a given row index
    var getCellValueForRowIndex = function (grid, rowIndex, propertyName) {

        if (!grid || rowIndex === undefined || rowIndex === null || !propertyName) {
            return null;
        }

        // Get the row id
        var rowId = grid.getRowId(rowIndex);

        // Get the column index
        var columnIndex = getColumnIndex(grid, propertyName);
        if (columnIndex < 0)
            return null;

        return grid.GetCellValue(rowId, columnIndex);
    };

    // Returns the cell value for the property of a specific rowid
    var getCellValueForRowId = function (grid, rowId, propertyName) {

        if (!grid || !rowId || !propertyName) {
            return;
        }

        // Get the column index
        var columnIndex = getColumnIndex(grid, propertyName);
        if (columnIndex < 0)
            return null;

        return grid.GetCellValue(rowId, columnIndex);
    };

    // Returns an array of all the (column) values for a given property. Returns distinct values if distinct set to true
    var getValueListForPropertyName = function (grid, propertyName, distinct) {

        if (!grid || !propertyName) {
            return;
        }

        var allValues = [];
        var rowCount = grid.GetRowCount();

        for (var i = 0; i < rowCount; i++) {
            var value = getCellValueForRowIndex(grid, i, propertyName);

            // if the cell is empty, do not add
            if (value) {
                // trim the value
                value = value.trim();

                // If distinct set to true; only add if not already in the array
                if (!distinct || allValues.indexOf(value) === -1) {
                    allValues.push(value);
                }
            }
        }

        return allValues;
    };

    // Returns a list of values that contains the provided substring for the given property in a grid. Returns distinct values if distinct set to true.
    // Does a case insensitive substring match. So, if there are NPN and npn, will return the first occurance
    var getValuesForPropertyNameContainingSubstring = function (grid, propertyName, substring, distinct) {

        if (!grid || !substring || !propertyName) {
            return;
        }

        var allValues = [];
        var upperCaseValues = []; // Used for case insensitive matching
        var rowCount = grid.GetRowCount();

        for (var i = 0; i < rowCount; i++) {
            var value = getCellValueForRowIndex(grid, i, propertyName);

            // if there is a value in the cell and contains the substring (case insensitive)
            if (value && value.toUpperCase().indexOf(substring.toUpperCase()) !== -1) {
                // trim the value
                value = value.trim();

                // If distinct set to true; only add if not already in the array. Using upper case array for case insensitive matching
                if (!distinct || upperCaseValues.indexOf(value.toUpperCase()) === -1) {
                    allValues.push(value);
                    upperCaseValues.push(value.toUpperCase());
                }
            }
        }

        return allValues;
    };

    // Returns an array of all the values for a given property from the grid rows that have the action specified. Returns distinct values if distinct is set to true
    // Can be used to get a property value from all the rows currently marked as deleted or all the rows that are being updated
    var getPropertyValuesForGivenAction = function (grid, propertyName, action, distinct) {
        if (!grid || !propertyName || !action) {
            return;
        }

        var allValues = [];
        var rowCount = grid.GetRowCount();

        for (var i = 0; i < rowCount; i++) {
            // Get the row id (row id is same as the item type id)
            var rowId = grid.getRowId(i);

            // Get the current row
            var currentItem = parentContext.thisItem.getItemsByXPath("//Item[@id='" + rowId + "']");

            var currentRowAction = currentItem.getAction();

            // Consider current row only if the current row has the same action specified by the user
            if (currentRowAction && currentRowAction.toUpperCase() === action.toUpperCase()) {
                // If the requested property is ID, the grid may not have it. So, use the rowID, which is same as id
                var value = propertyName.toUpperCase() === "ID" ? rowId : getCellValueForRowIndex(grid, i, propertyName);

                // if the cell is empty, do not add
                if (value) {
                    // trim the value
                    value = value.trim();

                    // If distinct set to true; only add if not already in the array
                    if (!distinct || allValues.indexOf(value) === -1) {
                        allValues.push(value);
                    }
                }
            }
        }

        return allValues;
    };

    // sets the dropdown list for the given property in a grid
    var setListValueInCell = function (grid, rowId, propertyName, labels, values) {
        //set cost impact area
        var columnIndex = getColumnIndex(grid, propertyName);
        var cell = grid.cells(rowId, columnIndex);
        //var labels = "Engineering Impact^Validation Impact";
        //var values = "Engineering Impact^Validation Impact";
        cell.setCombo_Experimental(labels, values, "^");
    };

    // Returns the content window for the given tabName and the parentscope if found; otherwise returns null
    var getRelationshipContentWindow = function (tabName, parentScope) {

        if (!tabName) {
            return;
        }

        // Take the parent scope if supplied, else use the default parent
        parentScope = parentScope || parentContext;

        // Parent scope was not defined, for some reason
        if (!parentScope) {
            return;
        }

        if (!parentScope.relationships ||
            !parentScope.relationships.relTabbarReady ||
            parentScope.relationships.relTabbar.GetTabOrder("|") === "") {
            setTimeout(function () {
                getRelationshipContentWindow(tabName, parentScope);
            }, 30);
            return;
        }
        var tabbar = parentScope.relationships.relTabbar;
        var tabID = tabbar.GetTabId(tabName);
        if (tabID) {
            var tabIFrame = parentScope.relationships.iframesCollection[tabID];

            if (tabIFrame && tabIFrame.contentWindow) {
                return tabIFrame.contentWindow;
            }
            return null;
        }
        return null;
    };

    // Fires the specified cell event for the given tabname, rowid, propertyname,eventname
    // tabName: Name of the tab that contains the grid cell
    // parentScope: parent object of the iframe that contains the tab. For example; parent of the PAT tab (ecrcontext)
    // rowId: Id of the row that has the cell 
    // propertyName: Name of the Property that is the cell
    // eventName: client event to fire. For example: oneditstart, oneditfinish etc
    var fireCellEvent = function (tabName, parentScope, rowId, propertyName, eventName) {
        var contentWindow = getRelationshipContentWindow(tabName, parentScope);

        if (contentWindow) {
            var grid = contentWindow.grid;
            var columnIndex = getColumnIndex(grid, propertyName);

            contentWindow.handleCellEvent(eventName, rowId, getColumnIndex(grid, propertyName));
        }
    };

    // Hides/Shows a grid property for the given property name
    var setColumnVisibility = function (grid, propertyName, isVisible, columnWidth) {
        var propertyIndex = getColumnIndex(grid, propertyName);
        if (propertyIndex) {
            grid.SetColumnVisible(propertyIndex, isVisible, columnWidth);
        }
    };

    // Updates grid column width to the given new value
    var updateColumnWidth = function (grid, propertyName, columnWidth) {
        var propertyIndex = getColumnIndex(grid, propertyName);
        if (propertyIndex) {
            // Hide and show the grid column to reset the column width. Just updating the width won't work. 
            // Check back and update the code if ARAS updates it's grid container script to update column width. This is just a trick I found
            grid.SetColumnVisible(propertyIndex, false, columnWidth);
            grid.SetColumnVisible(propertyIndex, true, columnWidth);
        }
    };

    return {
        setParentContext: setParentContext,
        setCellValue: setCellValue,
        setCellItemValue: setCellItemValue,
        setCellValueButNotCache: setCellValueButNotCache,
        getColumnIndex: getColumnIndex,
        getGridForTabName: getGridForTabName,
        getGridForTabNameAndWindowId: getGridForTabNameAndWindowId,
        getCellValueForRowIndex: getCellValueForRowIndex,
        getCellValueForRowId: getCellValueForRowId,
        getValueListForPropertyName: getValueListForPropertyName,
        getValuesForPropertyNameContainingSubstring: getValuesForPropertyNameContainingSubstring,
        getNPNSequencesForPropertyName: getNPNSequencesForPropertyName,
        getPropertyValuesForGivenAction: getPropertyValuesForGivenAction,
        getRelationshipContentWindow: getRelationshipContentWindow,
        fireCellEvent: fireCellEvent,
        setColumnVisibility: setColumnVisibility,
        updateColumnWidth: updateColumnWidth
    };
}();

function end_of_method() {



    // __________Cut Above this line and paste into Innovator Method editor __________

}


function gm_File_Revision_Hide_Controls() {
    // _________________Cut below this line to paste into Innovator________________________

    /* *****************************************************************************
    Method Name:			gm_ARAS Menu Utilities
    Client Name:			General Motors
    Created By/Company:		Pitamber Tiwari/GM  
    Creation Date:			02/05/2018
    Description:
        Utilities to Hide and Show toolbar menu icons from the relationship grid
        
    Hooks:
        Type:	Form
        Event:	OnLoad
        
    NOTES:
    All the available button ids
    "actions_menu", "emptyId_1", "related_option", "new", "emptyId_2", "pick_replace", "delete", "emptyId_3", "export2Excel", "export2Word", "emptyId_4", 
    "lock", "unlock", "emptyId_5", "promote", "search", "newsearch", "stop_search", "emptyId_6", "search_mode", "saved_search", "emptyId_7", "add_criteria", 
    "select_all", "page_size", "prev_page", "next_page", "emptyId_8", "show_item", "show_relationship", "emptyId_9", "copy2clipboard", "paste", "redline"

    All Mapped Labels
    "Actions", undefined, undefined, "New relationship", undefined, "Pick/Replace Related Item", "Delete relationship", undefined, "Export To Excel", "Export To Word", undefined,
    "Lock related item", "Unlock related item", undefined, "Promote Item", "Run Search", "Clear Search Criteria", "Stop Search", undefined, undefined, undefined, undefined, "Add Criteria", 
    "Select All", undefined, "Previous Page", "Next Page", undefined, "View item", "View relationship", undefined, "Copy Relationship to Clipboard", "Paste last copied relationships", "Enable Redline Mode"
    
    Popup Menu Controls: CONTROLS_STATE_ARRAY
    copy2clipboard: true
    delete: true
    lock: false
    new: true
    next_page: false
    paste: false
    paste_special: false
    pick_replace: false
    prev_page: false
    promote: false
    redline: false
    related_option: false
    select_all: true
    show_item: false
    show_relationship: false
    unlock: false


    Revisions:
        Rev Date		Modified By			    Description
        02/05/2018		Pitamber Tiwari			Initial creation
    ***************************************************************************** */

    debugger;
}

// ARAS Menu Utility Namespace
var gmARASMenuUtilitiesNS = gmARASMenuUtilitiesNS || function () {
    'use strict';

    // Default number of iterations for the SetTimout functio
    var maxSetTimeRepeat = 100;
    var contentWindow = null;

    // Hides the list of buttons for the specified ids from the given tab Id
    var hideButtonsForIds = function (buttonsIdsToHide) {

        // Can hide directly without checking for valid button id. It seems to handle that without exception.
        for (var i = 0; i < buttonsIdsToHide.length; i++) {
            contentWindow.toolbar.hideItem(buttonsIdsToHide[i]);
        }
    };

    // Hides the list of buttons for the specified names from the given tab Id
    var hideButtonsForNames = function (buttonsNamesToHide) {
        for (var i = 0; i < buttonsNamesToHide.length; i++) {
            var buttonId = contentWindow.toolbar.GetButtonId(buttonsNamesToHide[i]);
            if (buttonId != undefined) {
                contentWindow.toolbar.hideItem(buttonId);
            }
        }
    };

    // Shows the list of buttons for the specified ids from the given tab Id
    var showButtonsForIds = function (buttonsIdsToHide) {

        // Can hide directly without checking for valid button id. It seems to handle that without exception.
        for (var i = 0; i < buttonsIdsToHide.length; i++) {
            contentWindow.toolbar.showItem(buttonsIdsToHide[i]);
        }
    };

    // Shows the list of buttons for the specified names from the given tab Id
    var showButtonsForNames = function (buttonsNamesToHide) {
        for (var i = 0; i < buttonsNamesToHide.length; i++) {
            var buttonId = contentWindow.GetButtonId(buttonsNamesToHide[i]);
            if (buttonId != undefined) {
                contentWindow.showItem(buttonId);
            }
        }
    };

    // Shows/Hides the menu buttons
    // context: current context the method is going to use. Usually, it's "parent"
    // tabName: Name of the tab from which the buttons are to be hidden/shown
    // buttonsArray: List of ids or names of the buttons to hide/show
    // currentIteration: Current repeatatoin number
    // isIds: boolean to indicate whether the buttonsArrays is a list of ids or names. true if ids.
    var showHideMenuButtons = function (context, tabName, buttonIdsArray, currentIteration, isIds, hide) {
        if (!currentIteration) {
            currentIteration = 0;
        }

        currentIteration++;
        if (!context || !tabName || !buttonIdsArray || buttonIdsArray.length === 0 || currentIteration > maxSetTimeRepeat) {
            return;
        }

        // Make sure the relationship grid is loaded
        if (!context.relationships || !context.relationships.relTabbarReady || context.relationships.relTabbar.GetTabOrder("|") === "") {

            setTimeout(function () {
                showHideMenuButtons(context, tabName, buttonIdsArray, currentIteration, isIds, hide);
            }, 1000);
            return;
        }

        var tabbar = context.relationships.relTabbar;
        var tabID = tabbar.GetTabId(tabName);

        // If the tab is hidden or not there, just return
        if (!tabID) {
            return;
        }

        // Make sure the toolbar for the given id is loaded properly
        if (!context.relationships.iframesCollection[tabID].contentWindow.toolbar.hideItem) {
            setTimeout(function () {
                showHideMenuButtons(context, tabName, buttonIdsArray, currentIteration, isIds, hide);
            }, 1000);
            return;
        }

        // Set the content window
        contentWindow = context.relationships.iframesCollection[tabID].contentWindow;

        // Hide the buttons
        if (hide) {
            if (isIds) {
                hideButtonsForIds(buttonIdsArray);
            } else {
                hideButtonsForNames(buttonIdsArray);
            }
        }
        else {
            if (isIds) {
                showButtonsForIds(buttonIdsArray);
            } else {
                showButtonsForNames(buttonIdsArray);
            }
        }
    };

    var showMenuButtons = function (context, tabName, buttonIdsArray, currentIteration, isIds) {
        showHideMenuButtons(context, tabName, buttonIdsArray, currentIteration, isIds, false);
    };

    var hideMenuButtons = function (context, tabName, buttonIdsArray, currentIteration, isIds) {
        showHideMenuButtons(context, tabName, buttonIdsArray, currentIteration, isIds, true);
    };

    // Sets the maximum iteration number. The detault value is 100
    var setMaxIteration = function (maxIteration) {
        maxSetTimeRepeat = maxIteration;
    };

    return {
        setMaxIterationNumber: setMaxIteration,
        hideMenuButtons: hideMenuButtons,
        showMenuButtons: showMenuButtons
    };
}();

function end_of_method() {

    // __________Cut Above this line and paste into Innovator Method editor __________
}

​x
 
function GMComapnyFilterSuppliers() {
    // _________________Cut below this line to paste into Innovator________________________
var companies = this.newItem(inArgs.itemTypeName, "get");
companies = companies.apply();
var totalComapnyCount = companies.getItemCount();
var innovator = new top.Innovator();
var idsToExclude = new Array();
​
// Get the suppliers that already exist
var ecr = innovator.getItemById("gm_work order", inArgs.itemSelectedID);
​
if(ecr){
ecr.fetchRelationships("gm_Work Order gm_Company");
var existingSuppliers = ecr.getRelationships("gm_Work Order gm_Company");
var supplierCount = existingSuppliers.getItemCount();
​
​
    for (var i = 0; i < supplierCount; i++) {
        var relatedItemRelationship = existingSuppliers.getItemByIndex(i);
        var company = relatedItemRelationship.getRelatedItem();
        idsToExclude.push(company.getID());
    }
}
​
var idArray = new Array();
var j = 0;
​
for (var i = 0; i < totalComapnyCount; i++) {
    var company = companies.getItemByIndex(i);
​
    var companyName = company.getProperty("_company_name");
    var companyId = company.getID();
​
    if (!companyName.toLowerCase().startsWith("gm") && idsToExclude.indexOf(companyId) == -1) {
        idArray[j++] = companyId;
    } 
}
​
// If there are no supliers to show, just add a random Id to display empty dialog without search option
// If left empty, the search option appers and displays all the companies by-passing this filter
// Just a simple hack found through testing 
// settting ecrid.. so will never find a company with that id
if (idArray.length === 0) {
    idArray.push(inArgs.itemSelectedID);
}
​
var idlist=idArray.join(",");
​
//***SET THE idlist ATTRIBUTE ON THE QRYITEM TO THE LIST
inArgs.QryItem.item.setAttribute("idlist", idlist);
​
// __________Cut Above this line and paste into Innovator Method editor __________
}
​
/// <reference path="../../../Utilities/gm_ARAS Grid Utilities.js" />
/// <reference path="../../../Utilities/gm_ARAS Tab Utilities.js" />
/// <reference path="../../../Utilities/gm_UI Utilities.js" />
function gm_Query_PPAT_onSearchClick() {
    // _________________Cut below this line to paste into Innovator________________________
​
    /* *****************************************************************************
    Method Name:            gm_Query_PPAT_onSearchClick
    Client Name:            General Motors
    Created By/Company:     Pitamber Tiwari/GM  
    Description:
        Search the BOM and/or Component view with the specified search criteria.
​
        Runs when the "Search" button is clicked.
        Calls a server method to get the results. Removes the existing rows and add the new rows, if any.
    ***************************************************************************** */
    debugger;
    var constants = {
        PPATResultItemType: "gm_Query PPAT Result",
        SearchMethodName: "gm_Query PPAT onSearch",
        Type: "type",
        Method: "Method",
        WorkOrder: "gm_Work Order",
        WorkOrderId: "_work_order",
        EcrNumber: "item_number",
        AddButton: "buttonAdd"
    };
​
    var topWnd = window.TopWindowHelper.getMostTopWindowWithAras();
    var innovator = aras.newIOMInnovator();
​
    // Removes all the relationships from the item
    var removeAllRelationship = function (item, relationshipName) {
​
        var allRels = item.getRelationships(relationshipName);
        var relCount = allRels.getItemCount();
​
        for (var i = 0; i < relCount; i++) {
            item.removeRelationship(allRels.getItemByIndex(i));
        }
    };
​
    // Adds all the supplied relationship to the item.
    var addRelationships = function (item, relationships) {
        var relCount = relationships.getItemCount();
        for (var i = 0; i < relCount; i++) {
            item.addRelationship(relationships.getItemByIndex(i));
        }
    };
​
    // Returns the ECR the current query is associated with
    var getEcr = function () {
        var workOrderId = document.thisItem.getProperty(constants.WorkOrderId, "");
        var workOrderWindow = aras.uiFindWindowEx(workOrderId);
        if (workOrderWindow.thisItem) {
            return workOrderWindow.thisItem;
        }
        return innovator.getItemById(constants.WorkOrder, workOrderId);
    };
​
    var onSearch = function (queryItem, tWnd, spinnerAsync) {
        // Display a spinner
        if (!spinnerAsync) {
            aras.browserHelper.toggleSpinner(tWnd.document, true);
            return setTimeout(function () {
                onSearch(queryItem, tWnd, true);
            }, 100);
        }
​
        try {
            // Call the server side method. Doing apply on the itemtype called the server method on save as well (closing the window). So, cloned and called to avoid unnecessary calls to server
            var methodItem = queryItem.clone();
            methodItem.setAttribute(constants.Type, constants.Method);
            methodItem.setAction(constants.SearchMethodName);
​
            var result = methodItem.apply();
            var ecrNumber = "";
​
            if (result.isError()) {
                removeAllRelationship(queryItem, constants.PPATResultItemType);
                ecrNumber = getEcr().getProperty(constants.EcrNumber, "");
                throw "Query for ECR " + ecrNumber + ": " + result.getErrorString();
            }
​
            if (result.getRelationships(constants.PPATResultItemType).getItemCount() === 0) {
                removeAllRelationship(queryItem, constants.PPATResultItemType);
                ecrNumber = getEcr().getProperty(constants.EcrNumber, "");
                return top.aras.AlertWarning("Query for ECR " + ecrNumber + ": No results to display.");
            }
​
            removeAllRelationship(queryItem, constants.PPATResultItemType);
            addRelationships(queryItem, result.getRelationships(constants.PPATResultItemType));
​
        } catch (ex) {
            return top.aras.AlertError(ex);
        } finally {
            // Hide the spinner
            aras.browserHelper.toggleSpinner(topWnd.document, false);
            // Refresh the tab
            parent.onRefresh();
        }
    };
​
    onSearch(document.thisItem, topWnd, false);
​
​
    // __________Cut Above this line and paste into Innovator Method editor __________
}
​
​
function gm_PPAT_Dialog_onSearchDialog() {
    // _________________Cut below this line to paste into Innovator________________________
​
​
    var workOrderId = inArgs.itemSelectedID;
​
    // When the part number if clicked, the selected Id is blank
    if (!workOrderId) {
        workOrderId = parent.thisItem.getID();
    }
​
    //create new Object
    var Filter = new Object();
​
    //Assign Filter
    Filter["_work_order_id"] = { filterValue: workOrderId, isFilterFixed: true };
    return Filter;
​
​
    // __________Cut Above this line and paste into Innovator Method editor __________
}
​
​
​
/// <reference path="../GMECR/PPAT/gm_PPAT on FNA Edit.js" />
/// <reference path="gm_ARAS Grid Utilities.js" />c:\code\gmdllcode\gmpd2\arasmethods\methods - client\utilities\gm_aras context utilities.js
function gm_ARAS_Context_Utilities() {
    // _________________Cut below this line to paste into Innovator________________________
​
​
    /* *****************************************************************************
    Method Name:            gm_ARAS_Context_Utilities
    Client Name:            General Motors
    Created By/Company:     Pitamber Tiwari/GM  
    Description:
      Utility method to update the grid/form properties. Use this method to get the right context (window) for the updates so that it uses the proper values for parent, document.thisItem etc.
​
      The Parent form (E.g.: ECR) must have the grid utility loaded
    ***************************************************************************** */
    // Using the guid to make it unique to the given ECR so that IE does not fail with freed script error.
    top[document.thisItem.getID() + 'gmArasContextUtilityNS'] = gmArasContextUtilityNS;
}
​
var gmArasContextUtilityNS = gmArasContextUtilityNS || function () {
    "use strict";
​
    var constants = {
        PropertyNames: {
            State: "state"
        },
​
        Actions: {
            Add: "add",
            Get: "get",
        },
​
        Attributes: {
            Where: "where",
            Select: "select",
            IdList: "idlist",
            KeyedName: "keyed_name"
        }
    };
​
    // Returns the context for the given window id. Window Id is the item id. For example: the window id for ECR form is the current ECR id
    var getContextForId = function (windowId) {
        // get the current context
        var currentWindow = aras.uiFindWindowEx(windowId);
​
        if (!currentWindow) {
            return null;
        }
​
        var currentContext = currentWindow.instance;
​
        // In IE, the contentWindow is undefined, but in Chrome current context is contentWindow
        if (currentContext.contentWindow) {
            currentContext = currentContext.contentWindow;
        }
​
        return currentContext;
    };
​
    // Returns the Parent Context.
    // For example: If you are working on PAT grid/form, will return the current ECR context so you have access to the methods defined in the current ECR
    var getParentContext = function (isGrid, parent) {
​
        var windowId = null;
​
        if (isGrid) {
            windowId = parent.thisItem.getID();
        } else {
            windowId = parent.thisItem.getProperty("source_id");
        }
​
        if (!windowId) {
            return null;
        }
        return getContextForId(windowId);
    };
​
    // Update property on the given grid
    var updateGridProperty = function (currentContext, gridApplet, relationshipID, propertyName, value, isItem) {
        if (isItem) {
            currentContext.gmARASGridUtilitiesNS.setCellItemValue(gridApplet, relationshipID, propertyName, value);
        } else {
            currentContext.gmARASGridUtilitiesNS.setCellValue(gridApplet, relationshipID, propertyName, value);
        }
    }
​
    // Update the Property value both on the Form and Grid. Avaoid parent form refresh
    var updateProperty = function (parentContext, gridApplet, itemIdToUpdate, propertyName, value, isItem, tabName) {
        // Update form
        if (!gridApplet) {
            var currentFormContext = getContextForId(itemIdToUpdate);
​
            if (isItem && value) {
                currentFormContext.handleItemChange(propertyName, value.getID());
​
                // Update the grid here so that we don't have to refresh the page
                var currentGrid = parentContext.gmARASGridUtilitiesNS.getGridForTabName(tabName);
                parentContext.gmARASGridUtilitiesNS.setCellItemValue(currentGrid, itemIdToUpdate, propertyName, value);
            } else {
                currentFormContext.handleItemChange(propertyName, value || "");
            }
        } else {
            updateGridProperty(parentContext, gridApplet, itemIdToUpdate, propertyName, value, isItem);
        }
    };
​
    // Returns true if the lifecycle state of the item is Edit (editable); false otherwise
    var itemInEditableState = function (currentRow, relationshipID) {
        var action = currentRow.getAction();
​
        // Can edit the one just added
        if (action.toLowerCase() === constants.Actions.Add) {
            return true;
        }
​
        // If not add, must only be able to edit in Edit State
        var state = currentRow.getProperty(constants.PropertyNames.State, "");
​
        // If not defined in the cache, get it from database
        if (!state) {
            var item = aras.newIOMInnovator().newItem(currentRow.getType(), constants.Actions.Get);
            item.setID(relationshipID);
            item.setAttribute(constants.Attributes.Select, constants.PropertyNames.State);
            item = item.apply();
​
            state = item.getProperty(constants.PropertyNames.State, "");
        }
​
        if (state.toLowerCase() !== "edit") {
            // Item cannot be edited
            return false;
        }
​
        return true;
    };
​
    // Returns true if the current user has update access on the given itemtype for the work order id (EcrId); false otherwise
    var currentUserHasUpdateAccess = function (workOrderId, itemType) {
        // Check if the curent user has permission to update
        var hasUpdateAccess = aras.newIOMInnovator().applyMethod("gm_ValidateUserRoleForFinishDate", "<work_order_id>" + workOrderId + "</work_order_id>"
            + "<rel_name>" + itemType + "</rel_name>").getResult();
​
        return hasUpdateAccess === "true";
    };
​
    // Returns true if the relationship is in Editable Lifecycle state; false otherwise
    var isEditableLifecycleState = function (parentContext, relationshipID) {
        // If the parent is locked, it should not be editable
        if (!parentContext.document.isEditMode) {
            return false;
        }
​
        // For the child form, the form must be in edit mode as well
        if (document.isEditMode !== undefined && !document.isEditMode) {
            return false;
        }
        var parentItem = parentContext.parent.thisItem;
        var currentRow = parentItem.getItemsByXPath("//Relationships/Item[@id='" + relationshipID + "']");
        currentRow = currentRow.getItemByIndex(0);
​
        if (!itemInEditableState(currentRow, relationshipID)) {
            return false;
        }
​
        // Check if the curent user has permission to update
        if (parentItem.getType().toLowerCase() === "gm_work order") {
            return currentUserHasUpdateAccess(parentContext.parent.thisItem.getId(), currentRow.getType());
        }
​
        return true;
    }
​
    // Returns keyed name for the given property from the parent item
    var getPropertyKeyedName = function (item, propertyName) {
        var propertyItem = item.getPropertyItem(propertyName);
        var keyedName = "";
        if (propertyItem) {
            keyedName = propertyItem.getAttribute(constants.Attributes.KeyedName, "");
​
            if (!keyedName) {
                keyedName = propertyItem.getProperty(constants.Attributes.KeyedName, "");
            }
            // Check the Attribute on id
            if (!keyedName) {
                keyedName = propertyItem.getPropertyAttribute("id", constants.Attributes.KeyedName, "");
            }
        }
​
        // If the keyedname is not found in the item, check to see if it is set as an attribute in the property
        if (!keyedName) {
            keyedName = item.getPropertyAttribute(propertyName, constants.Attributes.KeyedName, "");
        }
​
        return keyedName.trim();
    };
​
​
    return {
        getContextForId: getContextForId,
        getParentContext: getParentContext,
        updateGridProperty: updateGridProperty,
        updateProperty: updateProperty,
        isEditableLifecycleState: isEditableLifecycleState,
        getPropertyKeyedName: getPropertyKeyedName
    };
​
​
    //// Returns the Parent Context.
    //// For example: If you are working on PAT grid/form, will return the current ECR context so you have access to the methods defined in the current ECR
    //var getParentContext = function (isGrid, parent) {
​
    //    var windowId = null;
​
    //    if (isGrid) {
    //        windowId = parent.thisItem.getID();
    //    } else {
    //        windowId = parent.thisItem.getProperty("source_id");
    //    }
​
    //    if (!windowId) {
    //        return null;
    //    }
    //    return getContextForId(windowId);
    //};
​
    //// Update property on the given grid and form
    //var updateGridProperty = function (currentContext, gridApplet, relationshipID, propertyName, value, isItem, tabName) {
    //    // Updating the form updates the grid, so just update the form here, if any
    //    // Doing so syncs both grid and form. OOTB behavior does not update the form when the grid is updated
    //    var relationshipContext = getContextForId(relationshipID);
    //    if (relationshipContext) {
    //        updateFormControl(relationshipContext, relationshipID, propertyName, value, isItem, tabName);
    //    } else {
    //        if (isItem) {
    //            var keyedName = gmARASGridUtilitiesNS.getCellValueForRowId(gridApplet, relationshipID, propertyName);
​
    //            currentContext.gmARASGridUtilitiesNS.setCellItemValue(gridApplet, relationshipID, propertyName, value);
    //        } else {
    //            currentContext.gmARASGridUtilitiesNS.setCellValue(gridApplet, relationshipID, propertyName, value);
    //        }
    //    }
    //}
​
    //// Updates the property on both grid and form
    //var updateFormControl = function (parentContext, itemIdToUpdate, propertyName, value, isItem, tabName) {
    //    var currentFormContext = getContextForId(itemIdToUpdate);
​
    //    if (isItem && value) {
    //        currentFormContext.handleItemChange(propertyName, value.getID());
​
    //        // Update the grid here so that we don't have to refresh the page
    //        var currentGrid = parentContext.gmARASGridUtilitiesNS.getGridForTabName(tabName);
    //        if (currentGrid) {
    //            parentContext.gmARASGridUtilitiesNS.setCellItemValue(currentGrid, itemIdToUpdate, propertyName, value);
    //        }
    //    } else {
    //        currentFormContext.handleItemChange(propertyName, value || "");
    //    }
    //}
​
    //// Update the Property value both on the Form and Grid. Avoid parent form refresh
    //var updateProperty = function (parentContext, gridApplet, itemIdToUpdate, propertyName, value, isItem, tabName) {
    //    if (gridApplet) {
    //        updateGridProperty(parentContext, gridApplet, itemIdToUpdate, propertyName, value, isItem, tabName);
    //    } else {
    //        updateFormControl(parentContext, itemIdToUpdate, propertyName, value, isItem, tabName);
    //    }
    //};
​
}();
​
​
​
function end_of_method() {
​
​
    // __________Cut Above this line and paste into Innovator Method editor __________
}
​
​
​
function gm_ARAS_Dialog_Utilities() {
​
    // _________________Cut below this line to paste into Innovator________________________
    /* *****************************************************************************
    Method Name:            gm_ARAS Dialog Utilities
    Client Name:            General Motors
    Created By/Company:     Pitamber Tiwari/GM 
    Creation Date:          2017-08-17
    Description:
        Javascript utility methods to be used with ARAS Dialog Modal popups. 
        Update this file if you have a helper/utility method that is independent of item type and can be used without conflicts.
    
    Usage:
       For example; include the method in the parent form and bind it to onLoad event. This file must come before other functions that use the utility functions defined here.
       Can be used with other controls on UI with a different event too.
​
      Example of call from Grid Cell Event:
         top.arasModalDialogForFormNS.{function name}
        
    Hooks:
        Type:   ARAS Dialog Model 
        Event:  Any
        
        
    Revisions:
        Rev Date            Modified By             Description
        2017-08-17          Pitamber Tiwari         Initial creation
    ***************************************************************************** */
    // debugger;
​
    // Adding the funtion to the top so that we can access from the grid
    top.arasModalDialogForFormNS = arasModalDialogForFormNS;
}
​
// ARAS Dialog Utility Class
var arasModalDialogForFormNS = arasModalDialogForFormNS || function () {
​
    const CONSTANTS = {
        ItemTypeNames: {
            Form: "form"
        },
        PropertyNames: {
            Name: "name",
            Height: "height",
            Width: "width"
        },
        Attributes: {
            Select: "select",
            Get: "get"
        },
        DefaultPopup: "DefaultPopup",
        DialogHtmlName: "ShowFormAsADialog.html",
    };
​
    // Returns the form for a given name
    var getForm = function (formName) {
        var form = top.Innovator().newItem(CONSTANTS.ItemTypeNames.Form, CONSTANTS.Attributes.Get);
        form.setAttribute(CONSTANTS.Attributes.Select, "id,width,height");
        form.setProperty(CONSTANTS.PropertyNames.Name, formName); // name of Form
        return form.apply();
    };
​
    // Returns an option to be used with the Dialog for provided form
    var createOptionsForForm = function (form) {
        // get height and width
        var height = form.getProperty(CONSTANTS.PropertyNames.Height, "600");
        var width = form.getProperty(CONSTANTS.PropertyNames.Width, "800");
​
        var options = {
            dialogWidth: width,
            dialogHeight: height
        };
​
        return options;
    };
​
    // Returns the param object for the given form with the given title and parameter item
    var createParameters = function (form, dialogTitle, item) {
        var param = new Object();
        param.title = dialogTitle;
        param.formId = form.getItemByIndex(0).getID();
        param.aras = top.aras;
        param.isEditMode = true;
        param.item = item;
        return param;
    };
​
    // Shows the Dialog modal
    var show = function (param, options) {
        var wnd = aras.getMainWindow();
        wnd = wnd === top ? wnd.main : top;
        aras.modalDialogHelper.show(CONSTANTS.DefaultPopup, wnd, param, options, CONSTANTS.DialogHtmlName);
    };
​
    // Hides the dialog model
    var hideDialog = function () {
        window.parent.close();
    };
​
    // Creates Param, Options, and shows the dialog with the given title and param item for the specified form
    var showDialog = function (formName, dialogTitle, paramItem) {
        var form = getForm(formName);
​
        if (form.IsError()) {
            return top.aras.AlertError(form.getErrorString());
        }
​
        var options = createOptionsForForm(form);
        var param = createParameters(form, dialogTitle, paramItem);
        show(param, options);
    };
​
    return {
        showDialog: showDialog,
        hideDialog: hideDialog
    };
}();
​
​
function end_of_method() {
​
   
// __________Cut Above this line and paste into Innovator Method editor __________
}
​
​
​
​
​
function gm_ARAS_Itemtype_Utilities() {
​
    // _________________Cut below this line to paste into Innovator________________________
​
    /* *****************************************************************************
    Method Name:            gm_ARAS Event Utilities
    Client Name:            General Motors
    Created By/Company:     Pitamber Tiwari/GM 
    Creation Date:          2017-06-12
    Description:
        Javascript utility methods to be used with form/grid events. 
        Update this file if you have a helper/utility method that is independent of item type and can be used without conflicts.
​
    Usage:
       For example; include the method in the form and bind it to onLoad event. This file must come before other functions that use the utility functions defined here.
        
    Hooks:
        Type:   Javascript Utility functions 
        Event:  Any
        
        
    Revisions:
        Rev Date        Modified By             Description
        2017-06-12      Pitamber Tiwari         Initial creation
    ***************************************************************************** */
    // debugger;
​
    top.gmARASEventUtilitiesNS = gmARASEventUtilitiesNS;
}
​
// ARAS Itemtype utility class
var gmARASEventUtilitiesNS = gmARASEventUtilitiesNS || function () {
    var currentContext = null;
    var innovator = aras.newIOMInnovator();
​
    // Returns the item for the given keyedname
    var getItemUsingKeyedName = function (propertyName, keyedName, itemType) {
        // Get node from the context item
        var propertyItem = currentContext.getPropertyItem(propertyName);
       
        // If the item does not exist in the context, fetch it from database
        // This happens when the user manually types in the item number
        if (!propertyItem || propertyItem.getProperty("keyed_name") !== keyedName) {
            propertyItem = aras.newIOMInnovator().newItem(itemType, "get");
            propertyItem.setProperty("keyed_name", keyedName);
            propertyItem = propertyItem.apply();
​
            if (propertyItem.isError()) {
                // If the error was thrown becuase the keyed name does not exist, return an empty item as ARAS shows error message
                if (propertyItem.getErrorCode() === "0") {
                    return aras.newIOMInnovator().newItem(itemType, "get");
                } else {
                    throw propertyItem.getErrorDetail();
                }
            }
​
            if (propertyItem.getItemCount() > 1) {
                propertyItem = propertyItem.getItemByIndex(0);
            }
            // Update cache with item
            currentContext.setPropertyItem(propertyName, propertyItem);
        }
​
        return propertyItem;
    }
​
    // Returns the appropriate property value either from the event or from the cache. ARAS sometimes updates the cache after event but sometimes does not update the cache
    // Trying to get the right value no matter the event
    var getPropertyAfterEvent = function (context, propertyName, event, propertyItemType) {
        currentContext = context;
        // For grid, the value is updated in the cache. For form, if the event is fired by other item, cache has the value for this item
        if (!event || event.srcElement.name !== propertyName) {
            return currentContext.getProperty(propertyName);
        }
        else {
            // For item types, the cache is updated if the item is selected. If you clear without selection, the cache is not update
            if (propertyItemType) {
                if (event.srcElement.value) {
                    // srcElement value is the keyed name of the item type. So need to get the id from the property item
                    // This is also required if users manually types the keyed name in the item tpe text box. The underlying cache does not have the id yet
                    return getItemUsingKeyedName(propertyName, event.srcElement.value, propertyItemType).getProperty("id");
                }
​
                // Cleared the item type manually, so get it from srcElement. Cache still has the old value.
                return event.srcElement.value;
            }
                // non item types (dropdown for change action) will not have the cache updated yet. So, get the value from srcElement
            else {
                return event.srcElement.value;
            }
        }
    };
​
    return {
        getPropertyAfterEvent: getPropertyAfterEvent
    };
}();
​
function end_of_method() {
​
    // __________Cut Above this line and paste into Innovator Method editor __________
​
}
​
​
​
function gm_UI_Utilities() {
​
    // _________________Cut below this line to paste into Innovator________________________
    /* *****************************************************************************
    Method Name:            gm_ARAS Grid Utilities
    Client Name:            General Motors
    Created By/Company:     Pitamber Tiwari/GM 
    Creation Date:          2017-06-07
    Description:
        Javascript utility methods to be used with ARAS Relationship grids. 
        Update this file if you have a helper/utility method that is independent of item type and can be used without conflicts.
    
    Usage:
       For example; include the method in the parent form and bind it to onLoad event. This file must come before other functions that use the utility functions defined here.
       Can be used with other controls on UI with a different event too.
​
      Example of call from Grid Cell Event:
         top.gmARASGridUtilitiesNS.{function name}
        
    Hooks:
        Type:   ARAS Grid 
        Event:  Any
        
        
      Revisions:
        Rev Date          Modified By               Description
        2017-06-07      Pitamber Tiwari     Initial creation
        2017-06-19      Pitamber Tiwari     Add a method to return the grid control for the given control name
        2017-08-14      Pitamber Tiwari     Add utility methods to return list of property values (including for specific action) and set cell item property
        2017-08-31      Pitamber Tiwari     Add method to set the parent context so that context conflicts are removed
        2017-09-27      Pitamber Tiwari     Add method to get grid from a window for a given window id and tab name. Also add a method to set cell value without updating the cache
    ***************************************************************************** */
​
    // Adding the funtion to the top so that we can access from the grid
    top.gmARASGridUtilitiesNS = gmARASGridUtilitiesNS;
}
​
// ARAS Grid Utility Class
var gmARASGridUtilitiesNS = gmARASGridUtilitiesNS || function () {
    'use strict';
    var parentContext = parent;
    var innovator = aras.newIOMInnovator();
​
    // Returns the current index (column number) for the specified property in the given grid, even after column re-arragements
    var getColumnIndex = function (grid, propertyName) {
        return grid.grid_Experimental.order.indexOf(grid.GetColumnIndex(propertyName + "_D"));
    };
​
​
    // Sets the parent context to be used for the tabber
    var setParentContext = function (currentParentContext) {
        if (currentParentContext) {
            parentContext = currentParentContext;
        }
    };
​
    // Updates grid cell value as well as the underlying Cache
    var setCellValue = function (grid, relationshipID, propertyName, value) {
​
        // parent context must be set
        if (!parentContext) {
            return;
        }
​
        // Grid cannot update undefined or null and throws an error. Treat undefined/null as empty to not get error
        if (value === undefined || value === null) {
            value = "";
        }
​
        grid.cells(relationshipID, getColumnIndex(grid, propertyName)).setValue(value);
        var currentItem = parentContext.thisItem.getItemsByXPath("//Item[@id='" + relationshipID + "']");
​
        // don't know why but sometimes there are two items of same type returned in currentItem.
        if (currentItem.nodeList && currentItem.nodeList.length > 1) {
            currentItem = currentItem.getItemByIndex(0);
        }
​
        currentItem.setProperty(propertyName, value);
​
        // remove the keyedname and type,for itemtype so that empty ones return null for getPropertyItem function 
        currentItem.RemovePropertyAttribute(propertyName, "keyed_name");
        currentItem.RemovePropertyAttribute(propertyName, "type");
​
        // If the action is not set, set it to update
        if (!currentItem.getAction()) {
            currentItem.setAction("update");
        }
​
        // Mark it as dirty
        if (currentItem.getAttribute("isDirty") !== "1") {
            currentItem.setAttribute("isDirty", "1");
        }
    };
​
    // Updates grid cell value without updating the underlying cache (does not mark the item dirty)
    var setCellValueButNotCache = function (grid, relationshipID, propertyName, value) {
​
        // Grid cannot update undefined or null and throws an error. Treat undefined/null as empty to not get error
        if (value === undefined || value === null) {
            value = "";
        }
​
        grid.cells(relationshipID, getColumnIndex(grid, propertyName)).setValue(value);
    };
​
    // Updates grid cell property as well as the underlying Cache with the specified item (item must have keyed name as property or attribute)
    var setCellItemValue = function (grid, relationshipID, propertyName, item) {
        // parent context must be set
        if (!parentContext) {
            return;
        }
​
        // Grid cannot update undefined or null and throws an error. Treat undefined/null as empty to not get error
        if (item === undefined || item === null || item === "") {
            item = "";
            setCellValue(grid, relationshipID, propertyName, item);
            return;
        }
​
        var keyedName = item.getProperty("keyed_name", "");
​
        // Keyed name might be in the attribute, get it from there
        if (!keyedName) {
            keyedName = item.getAttribute("keyed_name");
        }
​
        // if the keyed name is still blank, get it from the database
        if (!keyedName) {
            var dbItem = innovator.getItemById(item.getType(), item.getID());
            keyedName = dbItem.getProperty("keyed_name", "");
​
            if (!keyedName) {
                keyedName = relationshipID;
            }
        }
​
        grid.cells(relationshipID, getColumnIndex(grid, propertyName)).setValue(keyedName);
        var currentItem = parentContext.thisItem.getItemsByXPath("//Item[@id='" + relationshipID + "']");
​
        // don't know why but sometimes there are two items of same type returned in currentItem.
        if (currentItem.nodeList && currentItem.nodeList.length > 1) {
            currentItem = currentItem.getItemByIndex(0);
        }
​
        // The action is set to skip by the item selector. This all is done to make sure the value is carried over to the form from grid that is not saved
        item.setAction("skip");
        item.setAttribute("keyed_name", keyedName);
        item.setPropertyAttribute(propertyName, "keyed_name", keyedName);
​
        // IE does not support innerHTML
        if (item.node.innerHTML) {
            item.node.innerHTML = ''; // no need to have the whole data
        }
​
        // Setting the property first because isNull was not removed by setPropertyItem
        currentItem.setProperty(propertyName, item.getID());
        currentItem.setPropertyItem(propertyName, item);
        currentItem.setPropertyAttribute(propertyName, "keyed_name", keyedName);
​
        // If the action is not set, set it to update
        if (!currentItem.getAction()) {
            currentItem.setAction("update");
        }
​
        // Mark it as dirty
        if (currentItem.getAttribute("isDirty") !== "1") {
            currentItem.setAttribute("isDirty", "1");
        }
    };
    
    // Returns a grid control for the given tab. Uses the parentContext scope for "parentContext" if supplied; otherwise uses the default "parentContext" scope
    var getGridForTabName = function (tabName, parentScope) {
        if (!tabName) {
            return;
        }
​
        // Take the parent scope if supplied, else use the default parent
        parentScope = parentScope || parentContext;
​
        // Parent scope was not defined, for some reason
        if (!parentScope) {
            return;
        }
​
        if (!parentScope.relationships ||
            !parentScope.relationships.relTabbarReady ||
            parentScope.relationships.relTabbar.GetTabOrder("|") === "") {
            setTimeout(function () {
                getGridForTabName(tabName, parentScope);
            }, 30);
            return;
        }
        var tabbar = parentScope.relationships.relTabbar;
        var tabID = tabbar.GetTabId(tabName);
        if (tabID) {
            var tabIFrame = parentScope.relationships.iframesCollection[tabID];
​
            if (tabIFrame && tabIFrame.contentWindow) {
                return tabIFrame.contentWindow.grid;
            }
            return null;
        }
        return null;
    };
​
    // Returns a grid control for the specified tab name on the given window if found; otherwise returns null. Use when you need to get a grid from already open parent window. For example; when you need to update PAT row from PAT form
    var getGridForTabNameAndWindowId = function (windowId, tabName) {
​
        // Window Id and tab name must be specified.
        if (!windowId || !tabName) {
            return null;
        }
​
        var itemWindow = aras.uiFindWindowEx(windowId);
        if (itemWindow) {
            var itemRelTabId = itemWindow.relationships.relTabbar.GetTabId(tabName);
            var itemRelTab = itemWindow.relationships.iframesCollection[itemRelTabId];
            if (itemRelTab && itemRelTab.contentWindow) {
                return itemRelTab.contentWindow.grid;
            }
        }
​
        return null;
    };
​
    // Returns the cell value for the property at a given row index
    var getCellValueForRowIndex = function (grid, rowIndex, propertyName) {
​
        if (!grid || rowIndex === undefined || rowIndex === null || !propertyName) {
            return null;
        }
​
        // Get the row id
        var rowId = grid.getRowId(rowIndex);
​
        // Get the column index
        var columnIndex = getColumnIndex(grid, propertyName);
        if (columnIndex < 0)
            return null;
​
        return grid.GetCellValue(rowId, columnIndex);
    };
​
    // Returns the cell value for the property of a specific rowid
    var getCellValueForRowId = function (grid, rowId, propertyName) {
​
        if (!grid || !rowId || !propertyName) {
            return;
        }
​
        // Get the column index
        var columnIndex = getColumnIndex(grid, propertyName);
        if (columnIndex < 0)
            return null;
​
        return grid.GetCellValue(rowId, columnIndex);
    };
​
    // Returns an array of all the (column) values for a given property. Returns distinct values if distinct set to true
    var getValueListForPropertyName = function (grid, propertyName, distinct) {
​
        if (!grid || !propertyName) {
            return;
        }
​
        var allValues = [];
        var rowCount = grid.GetRowCount();
​
        for (var i = 0; i < rowCount; i++) {
            var value = getCellValueForRowIndex(grid, i, propertyName);
​
            // if the cell is empty, do not add
            if (value) {
                // trim the value
                value = value.trim();
​
                // If distinct set to true; only add if not already in the array
                if (!distinct || allValues.indexOf(value) === -1) {
                    allValues.push(value);
                }
            }
        }
​
        return allValues;
    };
​
    // Returns a list of values that contains the provided substring for the given property in a grid. Returns distinct values if distinct set to true.
    // Does a case insensitive substring match. So, if there are NPN and npn, will return the first occurance
    var getValuesForPropertyNameContainingSubstring = function (grid, propertyName, substring, distinct) {
​
        if (!grid || !substring || !propertyName) {
            return;
        }
​
        var allValues = [];
        var upperCaseValues = []; // Used for case insensitive matching
        var rowCount = grid.GetRowCount();
​
        for (var i = 0; i < rowCount; i++) {
            var value = getCellValueForRowIndex(grid, i, propertyName);
​
            // if there is a value in the cell and contains the substring (case insensitive)
            if (value && value.toUpperCase().indexOf(substring.toUpperCase()) !== -1) {
                // trim the value
                value = value.trim();
​
                // If distinct set to true; only add if not already in the array. Using upper case array for case insensitive matching
                if (!distinct || upperCaseValues.indexOf(value.toUpperCase()) === -1) {
                    allValues.push(value);
                    upperCaseValues.push(value.toUpperCase());
                }
            }
        }
​
        return allValues;
    };
​
    // Returns an array of all the values for a given property from the grid rows that have the action specified. Returns distinct values if distinct is set to true
    // Can be used to get a property value from all the rows currently marked as deleted or all the rows that are being updated
    var getPropertyValuesForGivenAction = function (grid, propertyName, action, distinct) {
        if (!grid || !propertyName || !action) {
            return;
        }
​
        var allValues = [];
        var rowCount = grid.GetRowCount();
​
        for (var i = 0; i < rowCount; i++) {
            // Get the row id (row id is same as the item type id)
            var rowId = grid.getRowId(i);
​
            // Get the current row
            var currentItem = parentContext.thisItem.getItemsByXPath("//Item[@id='" + rowId + "']");
​
            var currentRowAction = currentItem.getAction();
​
            // Consider current row only if the current row has the same action specified by the user
            if (currentRowAction && currentRowAction.toUpperCase() === action.toUpperCase()) {
                // If the requested property is ID, the grid may not have it. So, use the rowID, which is same as id
                var value = propertyName.toUpperCase() === "ID" ? rowId : getCellValueForRowIndex(grid, i, propertyName);
​
                // if the cell is empty, do not add
                if (value) {
                    // trim the value
                    value = value.trim();
​
                    // If distinct set to true; only add if not already in the array
                    if (!distinct || allValues.indexOf(value) === -1) {
                        allValues.push(value);
                    }
                }
            }
        }
​
        return allValues;
    };
​
    // sets the dropdown list for the given property in a grid
    var setListValueInCell = function (grid, rowId, propertyName, labels, values) {
        //set cost impact area
        var columnIndex = getColumnIndex(grid, propertyName);
        var cell = grid.cells(rowId, columnIndex);
        //var labels = "Engineering Impact^Validation Impact";
        //var values = "Engineering Impact^Validation Impact";
        cell.setCombo_Experimental(labels, values, "^");
    };
​
    // Returns the content window for the given tabName and the parentscope if found; otherwise returns null
    var getRelationshipContentWindow = function (tabName, parentScope) {
​
        if (!tabName) {
            return;
        }
​
        // Take the parent scope if supplied, else use the default parent
        parentScope = parentScope || parentContext;
​
        // Parent scope was not defined, for some reason
        if (!parentScope) {
            return;
        }
​
        if (!parentScope.relationships ||
            !parentScope.relationships.relTabbarReady ||
            parentScope.relationships.relTabbar.GetTabOrder("|") === "") {
            setTimeout(function () {
                getRelationshipContentWindow(tabName, parentScope);
            }, 30);
            return;
        }
        var tabbar = parentScope.relationships.relTabbar;
        var tabID = tabbar.GetTabId(tabName);
        if (tabID) {
            var tabIFrame = parentScope.relationships.iframesCollection[tabID];
​
            if (tabIFrame && tabIFrame.contentWindow) {
                return tabIFrame.contentWindow;
            }
            return null;
        }
        return null;
    };
​
    // Fires the specified cell event for the given tabname, rowid, propertyname,eventname
    // tabName: Name of the tab that contains the grid cell
    // parentScope: parent object of the iframe that contains the tab. For example; parent of the PAT tab (ecrcontext)
    // rowId: Id of the row that has the cell 
    // propertyName: Name of the Property that is the cell
    // eventName: client event to fire. For example: oneditstart, oneditfinish etc
    var fireCellEvent = function (tabName, parentScope, rowId, propertyName, eventName) {
        var contentWindow = getRelationshipContentWindow(tabName, parentScope);
​
        if (contentWindow) {
            var grid = contentWindow.grid;
            var columnIndex = getColumnIndex(grid, propertyName);
​
            contentWindow.handleCellEvent(eventName, rowId, getColumnIndex(grid, propertyName));
        }
    };
​
    // Hides/Shows a grid property for the given property name
    var setColumnVisibility = function (grid, propertyName, isVisible, columnWidth) {
        var propertyIndex = getColumnIndex(grid, propertyName);
        if (propertyIndex) {
            grid.SetColumnVisible(propertyIndex, isVisible, columnWidth);
        }
    };
​
    // Updates grid column width to the given new value
    var updateColumnWidth = function (grid, propertyName, columnWidth) {
        var propertyIndex = getColumnIndex(grid, propertyName);
        if (propertyIndex) {
            // Hide and show the grid column to reset the column width. Just updating the width won't work. 
            // Check back and update the code if ARAS updates it's grid container script to update column width. This is just a trick I found
            grid.SetColumnVisible(propertyIndex, false, columnWidth);
            grid.SetColumnVisible(propertyIndex, true, columnWidth);
        }
    };
​
    return {
        setParentContext: setParentContext,
        setCellValue: setCellValue,
        setCellItemValue: setCellItemValue,
        setCellValueButNotCache: setCellValueButNotCache,
        getColumnIndex: getColumnIndex,
        getGridForTabName: getGridForTabName,
        getGridForTabNameAndWindowId: getGridForTabNameAndWindowId,
        getCellValueForRowIndex: getCellValueForRowIndex,
        getCellValueForRowId: getCellValueForRowId,
        getValueListForPropertyName: getValueListForPropertyName,
        getValuesForPropertyNameContainingSubstring: getValuesForPropertyNameContainingSubstring,
        getNPNSequencesForPropertyName: getNPNSequencesForPropertyName,
        getPropertyValuesForGivenAction: getPropertyValuesForGivenAction,
        getRelationshipContentWindow: getRelationshipContentWindow,
        fireCellEvent: fireCellEvent,
        setColumnVisibility: setColumnVisibility,
        updateColumnWidth: updateColumnWidth
    };
}();
​
function end_of_method() {
​
​
​
    // __________Cut Above this line and paste into Innovator Method editor __________
​
}
​
​
function gm_File_Revision_Hide_Controls() {
    // _________________Cut below this line to paste into Innovator________________________
​
    /* *****************************************************************************
    Method Name:            gm_ARAS Menu Utilities
    Client Name:            General Motors
    Created By/Company:     Pitamber Tiwari/GM  
    Creation Date:          02/05/2018
    Description:
        Utilities to Hide and Show toolbar menu icons from the relationship grid
        
    Hooks:
        Type:   Form
        Event:  OnLoad
        
    NOTES:
    All the available button ids
    "actions_menu", "emptyId_1", "related_option", "new", "emptyId_2", "pick_replace", "delete", "emptyId_3", "export2Excel", "export2Word", "emptyId_4", 
    "lock", "unlock", "emptyId_5", "promote", "search", "newsearch", "stop_search", "emptyId_6", "search_mode", "saved_search", "emptyId_7", "add_criteria", 
    "select_all", "page_size", "prev_page", "next_page", "emptyId_8", "show_item", "show_relationship", "emptyId_9", "copy2clipboard", "paste", "redline"
​
    All Mapped Labels
    "Actions", undefined, undefined, "New relationship", undefined, "Pick/Replace Related Item", "Delete relationship", undefined, "Export To Excel", "Export To Word", undefined,
    "Lock related item", "Unlock related item", undefined, "Promote Item", "Run Search", "Clear Search Criteria", "Stop Search", undefined, undefined, undefined, undefined, "Add Criteria", 
    "Select All", undefined, "Previous Page", "Next Page", undefined, "View item", "View relationship", undefined, "Copy Relationship to Clipboard", "Paste last copied relationships", "Enable Redline Mode"
    
    Popup Menu Controls: CONTROLS_STATE_ARRAY
    copy2clipboard: true
    delete: true
    lock: false
    new: true
    next_page: false
    paste: false
    paste_special: false
    pick_replace: false
    prev_page: false
    promote: false
    redline: false
    related_option: false
    select_all: true
    show_item: false
    show_relationship: false
    unlock: false
​
​
    Revisions:
        Rev Date        Modified By             Description
        02/05/2018      Pitamber Tiwari         Initial creation
    ***************************************************************************** */
​
    debugger;
}
​
// ARAS Menu Utility Namespace
var gmARASMenuUtilitiesNS = gmARASMenuUtilitiesNS || function () {
    'use strict';
​
    // Default number of iterations for the SetTimout functio
    var maxSetTimeRepeat = 100;
    var contentWindow = null;
​
    // Hides the list of buttons for the specified ids from the given tab Id
    var hideButtonsForIds = function (buttonsIdsToHide) {
​
        // Can hide directly without checking for valid button id. It seems to handle that without exception.
        for (var i = 0; i < buttonsIdsToHide.length; i++) {
            contentWindow.toolbar.hideItem(buttonsIdsToHide[i]);
        }
    };
​
    // Hides the list of buttons for the specified names from the given tab Id
    var hideButtonsForNames = function (buttonsNamesToHide) {
        for (var i = 0; i < buttonsNamesToHide.length; i++) {
            var buttonId = contentWindow.toolbar.GetButtonId(buttonsNamesToHide[i]);
            if (buttonId != undefined) {
                contentWindow.toolbar.hideItem(buttonId);
            }
        }
    };
​
    // Shows the list of buttons for the specified ids from the given tab Id
    var showButtonsForIds = function (buttonsIdsToHide) {
​
        // Can hide directly without checking for valid button id. It seems to handle that without exception.
        for (var i = 0; i < buttonsIdsToHide.length; i++) {
            contentWindow.toolbar.showItem(buttonsIdsToHide[i]);
        }
    };
​
    // Shows the list of buttons for the specified names from the given tab Id
    var showButtonsForNames = function (buttonsNamesToHide) {
        for (var i = 0; i < buttonsNamesToHide.length; i++) {
            var buttonId = contentWindow.GetButtonId(buttonsNamesToHide[i]);
            if (buttonId != undefined) {
                contentWindow.showItem(buttonId);
            }
        }
    };
​
    // Shows/Hides the menu buttons
    // context: current context the method is going to use. Usually, it's "parent"
    // tabName: Name of the tab from which the buttons are to be hidden/shown
    // buttonsArray: List of ids or names of the buttons to hide/show
    // currentIteration: Current repeatatoin number
    // isIds: boolean to indicate whether the buttonsArrays is a list of ids or names. true if ids.
    var showHideMenuButtons = function (context, tabName, buttonIdsArray, currentIteration, isIds, hide) {
        if (!currentIteration) {
            currentIteration = 0;
        }
​
        currentIteration++;
        if (!context || !tabName || !buttonIdsArray || buttonIdsArray.length === 0 || currentIteration > maxSetTimeRepeat) {
            return;
        }
​
        // Make sure the relationship grid is loaded
        if (!context.relationships || !context.relationships.relTabbarReady || context.relationships.relTabbar.GetTabOrder("|") === "") {
​
            setTimeout(function () {
                showHideMenuButtons(context, tabName, buttonIdsArray, currentIteration, isIds, hide);
            }, 1000);
            return;
        }
​
        var tabbar = context.relationships.relTabbar;
        var tabID = tabbar.GetTabId(tabName);
​
        // If the tab is hidden or not there, just return
        if (!tabID) {
            return;
        }
​
        // Make sure the toolbar for the given id is loaded properly
        if (!context.relationships.iframesCollection[tabID].contentWindow.toolbar.hideItem) {
            setTimeout(function () {
                showHideMenuButtons(context, tabName, buttonIdsArray, currentIteration, isIds, hide);
            }, 1000);
            return;
        }
​
        // Set the content window
        contentWindow = context.relationships.iframesCollection[tabID].contentWindow;
​
        // Hide the buttons
        if (hide) {
            if (isIds) {
                hideButtonsForIds(buttonIdsArray);
            } else {
                hideButtonsForNames(buttonIdsArray);
            }
        }
        else {
            if (isIds) {
                showButtonsForIds(buttonIdsArray);
            } else {
                showButtonsForNames(buttonIdsArray);
            }
        }
    };
​
    var showMenuButtons = function (context, tabName, buttonIdsArray, currentIteration, isIds) {
        showHideMenuButtons(context, tabName, buttonIdsArray, currentIteration, isIds, false);
    };
​
    var hideMenuButtons = function (context, tabName, buttonIdsArray, currentIteration, isIds) {
        showHideMenuButtons(context, tabName, buttonIdsArray, currentIteration, isIds, true);
    };
​
    // Sets the maximum iteration number. The detault value is 100
    var setMaxIteration = function (maxIteration) {
        maxSetTimeRepeat = maxIteration;
    };
​
    return {
        setMaxIterationNumber: setMaxIteration,
        hideMenuButtons: hideMenuButtons,
        showMenuButtons: showMenuButtons
    };
}();
​
function end_of_method() {
​
    // __________Cut Above this line and paste into Innovator Method editor __________
}
​
​

Open
Open
Senior
Open

Cached Result
Last Run:	3:39:05 pm
Compile:	0.145s
Execute:	0s
Memory:	0b
CPU:	0s

View IL Code