1. Module MultiEdit

    Article: AN0001821Updated: 03.10.2018

    This module contains webpart for a mass record editing. By means of a simple scripting you can edit more records at one time and accelerate some operations in this way.

     

    You will pass list of records, to which the user has access rights, to the webpart by means of scripting. Webpart will display them in form of rows where each field can be edited. User can also delete records or create new ones.

    There is information about parent record, if it exists, in the upper part of the webpart - e.g. invoice record, where user can change invoice items.

    Webpart does not ensure access right control. This has to be managed by means of scripts by initialization. It is necessary to read only those records that the user can edit and save only what has to be saved.

    Configuration

    Property Description
    Enable new records Property for creation of new records. When enabled user can create a new record.
    Enable to delete records Property for deletion of records. When enabled user can delete records.
    Script for initialization Script is executed at display of the page with webpart.
    Script for reading records Script is executed reading records for editing.
    Script for displaying records Script is executed for ech record before its display on the page.
    Script for initialization of a new record Script is executed at at new record creation.
    Script for saving records Script is executed at saving all the records.
    Script for record deletion Script is executed at record deletion.

    Script parameters for initialization

    Verify in the script whether user can edit anything. Then read the class that will be edited and columns that shall be displayed in the webpart.

    OGInit - object for web initialization.

    OGWebPart - instance of the webpart.

    OGWebParts - list of all webparts in the page. In order to access the webparts use their code.

    Properties of object OGInit.

    Property Description
    bool NewAsPerson Indication, whether first a window for selection of an user shall pop up and the user is then filled in the new record. When not checked new record is added immediately.
    ClassDef ClassDef Class, records of which the user shall edit.
    Query Query Query, records of which the user shall see.
    ColumnClassDefList Columns List of columns from class that shall be displayed to user for editing.
    string ErrorMessage When error message is defined user will be redirected to an error page. Use this property e.g. for unauthorized access to this page.
    string LinkNavigation Text for a breadcrumb navigation. Format is same as by method OGForm.SetLinkNavigation.
    string BackUrl URL for button Back.
    bool HorizontalScrollable Indication whether data shall be displayed in horizontal scrollbar - the page is then not spread too much.
    void SetColumnWidth(int index, int width) Method sets width of the column.
    void SetColumnCss(int index, string css) Method sets CSS style for column.
    void SetColumnReadOnly(int index, bool readOnly) Method sets readonly indication for column.

    Script parameters for reading list of records

    In the script read the records, that the user shall see and edit.

    OGInit - object form initialization. It contains class, for which the records shall be read.

    OGWebPart - instance of the webpart.

    OGWebParts - list of all webparts in the page. In order to access the webparts use their code.

    Return the list of records by means of return.

    Script parameters for record display

    Script is executed for each record before it is displayed in the page.

    OGRow - configuration for currently displayed record.
    OGClassDef - class to which the record belongs.
    OGDataRow - record that shall be displayed.

    OGWebPart - instance of the webpart.

    OGWebParts - list of all webparts in the page. In order to access the webparts use their code.

    Properties of the object OGRow

    Name Description
    bool EnableDelete Indication for enabling/disabling record deletion.
    bool EnableSave Indication for enabling/disabling record saving.
    ColumnMultiEdit this[string code] Function returns column accoridng to the given code.
    ColumnMultiEdit this[int columnId] Function returns column accoridng to the given id.

    Properties of the object ColumnMultiEdit

    Name Decription
    ColumnClassDef Column Determination of column for which the setting applies.
    bool ReadOnly Indication whether column shall be displayed in readonly mode.
    bool Visible Indication whether column shall be displayed.

    Script parameters for a new record

    The script is executed after clicking on button New.

    OGNewDataRow - DataRow for a new record.
    OGActualMessage - object for setting error message.
    OGDataRows - list of records that are already in the multi-edit webpart. You can use it for check whether user can add a new record.
    OGPerson - selected new user.

    OGWebPart - instance of the webpart.

    OGWebParts - list of all webparts in the page. In order to access the webparts use their code.

    When an errror message is set by means of method OGActualMessage.SetError, you can cancel the creation of a new record. An error message is then displayed to the user.

     

    If there is property NewAsPerson checked in the webpart settings, there is a person, that the user selected at creation of a the record, passed in the parameter OGPerson. You can read this property in the script and check, whether a record can be created with selected user. Insert the user into OGNewDataRow if needed.

    Script parameters for storing records

    OGDataRows - list of records that shall be saved. The list contains only records that were changed by the user. At the same timese it contains only records that are not readonly.

    OGWebPart - instance of the webpart.

    OGWebParts - list of all webparts in the page. In order to access the webparts use their code.

    The saving itself will be secured by the webpart. You just check that everything is properly defined. If you find an error, throw an exception (OG.Throw) and saving will be cancelled.

    Script parameters for record deletion

    OGDataRowId - Id of a deleted record

    OGWebPart - instance of the webpart.

    OGWebParts - list of all webparts in the page. In order to access the webparts use their code.

    If you throw an exception (OG.Throw) in the script, saving will be cancelled.

    Scripts on page

    You can set url for button Back and crumbread navigation on page by means of following. You will read the values from the webpart MultiEdit with code multi-edit. You have to define these values before in the initialization script of the webpart.

    function OnPreRender()
    {
        var m = OGWebParts['multi-edit'];

        OGForm.SetLinkNavigation( m.LinkNavigation);

        var b = OGForm.GetControl('backToolbarButton');
        b.Visible = true;
        b.NavigateUrl = m.BackUrl;
    }

    Method SetColumn...

    Methods SetColumn... can set a particular property for particular column. Use them only in initialization script.

    Index for column starts from 0 for the first column.

    CSS styles cannot be inserted into the page by means of this webpart but you can insert them by means of webpart Script.

    Following script inserts a query and two columns into the configuration. Then CSS style is added. Finally horizontal shift is switched on.

    var m = OG.Model.GetByCode('it');
    var q = m.Queries['task_multi_edit'];
    OGInit.Query = q;
    OGInit.Columns.Add( q.Columns['t_name']);
    OGInit.Columns.Add( q.Columns['p_name']);
     
    OGInit.SetColumnCss( 0, 'task headcol');
    OGInit.SetColumnCss( 1, 'proj');
     
    OGInit.HorizontalScrollable = true;

    Script examples

    Below scripts are from capacity planning model, where users can edit project plan capacities.

    Script for initialization

    var cl = OG.ClassDef.GetByCode( 'it', 'project_year_requested_resources_monthly');
    OGInit.ClassDef = cl;
    OGInit.NewAsPerson = true;
    OGInit.Columns.Add(cl.Columns['resource']);
    OGInit.Columns.Add(cl.Columns['requested_resource_status']);
    OGInit.Columns.Add(cl.Columns['m01']);
    OGInit.Columns.Add(cl.Columns['m02']);
    OGInit.Columns.Add(cl.Columns['m03']);
    OGInit.Columns.Add(cl.Columns['m04']);
    OGInit.Columns.Add(cl.Columns['m05']);
    OGInit.Columns.Add(cl.Columns['m06']);
    OGInit.Columns.Add(cl.Columns['m07']);
    OGInit.Columns.Add(cl.Columns['m08']);
    OGInit.Columns.Add(cl.Columns['m09']);
    OGInit.Columns.Add(cl.Columns['m10']);
    OGInit.Columns.Add(cl.Columns['m11']);
    OGInit.Columns.Add(cl.Columns['m12']);

    var zpid = OG.QueryString.GetInt('drId');
    if ( zpid != null)
    {
        var clPR = OG.ClassDef.GetByCode( 'it', 'project_resources');
        var f = OG.DataRow.GetDataRowFilter( clPR.Id, zpid);
        var r = OG.ClassDef.HaveUserRightByClassDef( clPR.Id, OG.ClassDef.ClassDefRoleOperation_Update);
        if ( r == OG.ClassDef.RoleRight_RoleWithOrgStructure)
        {
            f.Filter_AplyOrgStructureForOperation = OG.ClassDef.ClassDefRoleOperation_Update;
        }
        var drl = OG.DataRow.GetDataByFilter(f);

        if ( drl != null && drl.Count == 1)
        {
            var dr = drl[0];
            var drp = dr.GetDR('project');
            var i = OGInit.Detail.CreateItem(clPR.Columns['project'].Name, drp.ShortDescription);
            i.ValueLink = drp.DetailUrl;
            OGInit.Detail.AddRow(i);

            var i1 = OGInit.Detail.CreateItem(clPR.Columns['year'].Name, dr['year']);
            var i2 = OGInit.Detail.CreateItem(clPR.Columns['amount'].Name, dr['amount']);
            OGInit.Detail.AddRow(i1, i2);

            var col = clPR.Columns['cost_type'];
            var i1 = OGInit.Detail.CreateItem(clPR.Columns['cost_type'].Name, dr.GetColumnDataAsString2( col.Id, col.ColumnType));
            var i2 = OGInit.Detail.CreateItem(clPR.Columns['accounting_amount'].Name, dr['accounting_amount']);
            OGInit.Detail.AddRow(i1, i2);

            var col = clPR.Columns['accounting_currency'];
            var i = OGInit.Detail.CreateItem(clPR.Columns['accounting_currency'].Name, dr.GetColumnDataAsString2( col.Id, col.ColumnType));
            OGInit.Detail.AddRow(i);

            OGInit.LinkNavigation = clPR.Model.Name + '|ModelInfo.aspx?Id=' + clPR.Model.Id + '>' + clPR .Name + '|' + dr.ListUrl + '>Záznam ID ' + dr.Id + '|' + dr.DetailUrl + '>Multi edit|WebContentPage.aspx' + OG.QueryString.Query;
            OGInit.BackUrl = dr.DetailUrl;
        }
        else
        {
            OGInit.ErrorMessage = 'Nemáte právo na úpravu zdrojů.';
        }
    }
    else
    {
        OGInit.ErrorMessage = 'Není zadán zdroj pro úpravu.';
    }

    Script for reading records

    var zpid = OG.QueryString.GetInt('drId');
    if ( zpid != null)
    {
        var col = OGInit.ClassDef.Columns['project_resources'];

        var f = OG.DataRow.GetDataRowFilter( OGInit.ClassDef.Id);
        f.Filter_OnlyActive = true;
        f.SetColumnData( col.Id, zpid);
        //seradit
        var drl = OG.DataRow.GetDataByFilter(f);

        var cl = OG.ClassDef.GetByCode( OGInit.ClassDef.Model.Id, 'requested_resource_status');
        var planStatus = OG.DataRow.GetDataRowByCode(null, cl, 'plan');
        var approvedStatus = OG.DataRow.GetDataRowByCode(null, cl, 'approved');
        var forapproveStatus = OG.DataRow.GetDataRowByCode(null, cl, 'for_approve');

        var usIds = ',';
        for( var i = 0; i < drl.Count; ++i)
        {
            var statusId = drl[i]['requested_resource_status'];
            if ( statusId == planStatus.Id || statusId == forapproveStatus.Id)
            {
                usIds += drl[i]['resource'].Id + ',';
            }
        }
        OG.SetItem('users1', usIds);

        return drl;
    }

    return null;

    Script for display of records

    OGRow['resource'].ReadOnly = true;
    OGRow['requested_resource_status'].ReadOnly = true;

    var usIds = OG.GetItem('users1');
    if ( usIds != null)
    {
       var cl = OG.ClassDef.GetByCode( OGClassDef.Model.Id, 'requested_resource_status');
       var approvedStatus = OG.DataRow.GetDataRowByCode(null, cl, 'approved');

       if ( OGDataRow['requested_resource_status'] == approvedStatus.Id && usIds.indexOf( ',' + OGDataRow['resource'].Id + ',') >= 0)
       {
          //var planStatus = OG.DataRow.GetDataRowByCode(null, cl, 'plan');
          var ro = true;   //!( OGDataRow['requested_resource_status'] == planStatus.Id);
          OGRow['m01'].ReadOnly = ro;
          OGRow['m02'].ReadOnly = ro;
          OGRow['m03'].ReadOnly = ro;
          OGRow['m04'].ReadOnly = ro;
          OGRow['m05'].ReadOnly = ro;
          OGRow['m06'].ReadOnly = ro;
          OGRow['m07'].ReadOnly = ro;
          OGRow['m08'].ReadOnly = ro;
          OGRow['m09'].ReadOnly = ro;
          OGRow['m10'].ReadOnly = ro;
          OGRow['m11'].ReadOnly = ro;
          OGRow['m12'].ReadOnly = ro;
       }
    }

    Script for a new record

    var cl1 = OG.ClassDef.GetById( OGNewDataRow.ParentId);
    var cl = OG.ClassDef.GetByCode( cl1.Model.Id, 'requested_resource_status');
    var planStatus = OG.DataRow.GetDataRowByCode(null, cl, 'plan');

    OGNewDataRow['requested_resource_status'] = planStatus .Id;
    OGNewDataRow['resource'] = OGPerson.ToPersonInfo();
    OGNewDataRow['project_resources'] = OG.QueryString.GetInt('drId');

    if ( OGPerson != null && OGDataRows != null)
    {
        for( var i = 0; i < OGDataRows.Count; ++i)
        {
            var p = OGDataRows[i]['resource'];
            if ( p != null && p.Id == OGPerson.Id)
            {
                OGActualMessage.SetError('This user is already selected. Please select another user.');
            }
        }
    }

    Example of appearance

    There are values from a parent record in the upper part of the webpart. Properties and values are populated by a script for initialization.

    Then there are buttons for a new record and saving of all the records.

    The last part are records for editing. In the below example there are two columns in read-only mode. Other columns in a row can be edited.

     

    Webpart configuration example. Each script has its own text field.

×