IG-Interactive Grid and JavaScript

Oracle Application Express is a rapid development tool for Web applications on the Oracle database.
Post Reply
admin
Posts: 2062
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

IG-Interactive Grid and JavaScript

Post by admin »

Initialization JavaScript Function

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;
}
Dynamic Action

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;   
}

) 
Malik Sikandar Hayat
admin@erpstuff.com
didarulislam9938
Posts: 3
Joined: Thu Jul 27, 2023 4:37 am

Re: IG-Interactive Grid and JavaScript

Post by didarulislam9938 »

To much Effective JS in Oracle Apex. Thanks a lot, dear sir.
didarulislam9938
Posts: 3
Joined: Thu Jul 27, 2023 4:37 am

Re: IG-Interactive Grid and JavaScript

Post by didarulislam9938 »

Dear Sir, I need help to solve a query to Generate Last three months average by SQL with date filter. Please help me.
admin
Posts: 2062
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Re: IG-Interactive Grid and JavaScript

Post by admin »

Dear please join out community whatsapp group, using below link.

https://chat.whatsapp.com/CbT3HKqAwo69vVQ2a64717
Malik Sikandar Hayat
admin@erpstuff.com
didarulislam9938
Posts: 3
Joined: Thu Jul 27, 2023 4:37 am

Re: IG-Interactive Grid and JavaScript

Post by didarulislam9938 »

Thanks for WhatsApp link.
Amin23
Posts: 1
Joined: Tue Apr 11, 2023 7:40 pm

Re: IG-Interactive Grid and JavaScript

Post by Amin23 »

-- I made a simple modification:

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

apex.item("P52_CLERKS").setValue("0")
apex.item("P52_MANAGERS").setValue("0")

selected.forEach(function (r) {
model.setValue(r, "COMM", model.getValue(r, "SAL") * $v("P52_INC")/100);
let v_job = model.getValue(r, "JOB");
switch (v_job) {
case "CLERK":
v_amount_clerk += Number(model.getValue(r, "SAL"));
break;
case "MANAGER":
v_amount_manager += Number(model.getValue(r, "SAL"));
break;
default:
break;
}
apex.item("P52_CLERKS").setValue(v_amount_clerk)
apex.item("P52_MANAGERS").setValue(v_amount_manager)
}
)
Post Reply

Who is online

Users browsing this forum: No registered users and 4 guests