IG-Interactive Grid and JavaScript
Posted: Fri Nov 18, 2022 3:19 am
Initialization JavaScript Function
Dynamic Action
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;
}
)