ERPstuff - Oracle EBS Community

Code: Select all

function(config) {
    if (!config.toolbar) {
        config.toolbar = {};
    }
    
    config.reportSettingsArea = false;
    
    config.defaultGridViewOptions = {
        multiple: true,
        selectAll: true ,
        footer: true, 
        rowHeader: 'sequence'
    }

   
 //   config.initActions = function( actions ) {  
 //   actions.remove("row-duplicate");  
 //   };  

    return config;
}

Code: Select all

var widget = apex.region('emp_ig').widget();
var grid = widget.interactiveGrid('getViews', 'grid');
var model = grid.model;
var selected = grid.view$.grid("getSelectedRecords");
var v_amount = 0;

// model.forEach(function(r) {  
//                 model.setValue(r,"COMM",model.getValue(r,"SAL"));  
//         }  
// )

//$s("P52_TOTAL","0")
apex.item("P52_CLERKS").setValue("0")

selected.forEach(function (r) {
    model.setValue(r, "COMM", model.getValue(r, "SAL") * $v("P52_INC")/100);
    // apex.item( "P7_EMPID" ).setValue ("255")

    if (model.getValue(r, "JOB") == "CLERK") {

        v_amount += Number(model.getValue(r, "SAL"))
        //   $s("P52_TOTAL", Number($v("P52_TOTAL")) + Number(model.getValue(r,"SAL"))) 
        $s("P52_CLERKS", v_amount)
    }

v_amount = 0;

    if (model.getValue(r, "JOB") == "MANAGER") {

        v_amount += Number(model.getValue(r, "SAL"))
        $s("P52_MANAGERS", v_amount)
   }
 v_amount = 0;   
}

)