code for interactive grid to get data
Thu Jan 27 2022 07:00:10 GMT+0000 (Coordinated Universal Time)
Saved by
@ahsankhan007
var htmldb_delete_message='"DELETE_CONFIRM_MSG
(function($){
function update(model){
var amt = model.getFieldKey("QTY1"),
custAmt = model.getFieldKey("RATE"),
total = 0;
model.forEach(function(record, index, id){
var v_amt = record[amt],
v_custAmt = record[custAmt],
meta = model.getRecordMetadata(id);
var all_v_amt = Number(v_amt.replace(/,/g, ''));
var all_v_custAmt = Number(v_custAmt.replace(/,/g, ''));
if(!isNaN(all_v_amt, all_v_custAmt) && !meta.deleted && !meta.agg){
total += all_v_amt * all_v_custAmt;
}
});
var all_total = total.toFixed(2);
console.log('>>', all_total);
$s('P11201_GROSS_TOTAL', all_total);
$s('P11201_GROSS_TOTAL_PAY', all_total);
$s('P11201_NET', all_total);
$s('P11201_NET_PAY', all_total);
}
$(function(){
$("#invDtl").on("interactivegridviewmodelcreate", function(event, ui) {
var sid,
model = ui.model;
if ( ui.viewId === "grid" ){
sid = model.subscribe({
onChange: function(type, change){
if(type === "set"){
if(change.field === "QTY1"){
update(model);
}else if(change.field === "RATE"){
update(model);
}
}else if(type !== "move" && type !== "metaChange"){
update(model);
}
},
progressView: $("#P11201_GROSS_TOTAL")
});
update(model);
model.fetchAll(function() {});
}
});
});
})(apex.jQuery);
content_copyCOPY
Comments